Newsletters




Data Warehousing

Hardware and software that support the efficient consolidation of data from multiple sources in a Data Warehouse for Reporting and Analytics include ETL (Extract, Transform, Load), EAI (Enterprise Application Integration), CDC (Change Data Capture), Data Replication, Data Deduplication, Compression, Big Data technologies such as Hadoop and MapReduce, and Data Warehouse Appliances.



Data Warehousing Articles

SolarWinds is making a series of updates to its network management product portfolio, allowing the platform to support networks up to four times larger. This improvement makes it easy to consolidate monitoring solutions to a single provider enterprise-wise, and gives IT professionals' far greater flexibility to scale up and support larger data center networks as workloads increase, or scale out to address complex distributed networks. 

Posted May 25, 2018

Cloud-driven automation is creating the need for an evolution throughout IT and the enterprise. DBTA recently held a webcast featuring Joe McKendrick, independent analyst and author, and Maria Colgan, Oracle master product manager, who examined how cloud is driving change and how Oracle can help.

Posted May 25, 2018

Technology is constantly changing, and IT architects need to keep up with modern developments to ensure that their companies are achieving the best possible return on their IT investment.

Posted May 24, 2018

Chris Reuter, North America data warehousing sales leader, IBM, presented a keynote at Data Summit 2018 on the key trends in IT today and what organizations must do to advance their organizations.

Posted May 24, 2018

Kore Technologies, a provider of enterprise integration and eCommerce solutions, is releasing version 4.5 of Kourier Integrator Data Management, further enhancing cloud capabilities. Users will see new benefits for Amazon Web Services and Microsoft Azure. The update provides enhanced functionality and higher performance when doing integration and data warehousing with Microsoft SQL Server in the cloud.

Posted May 23, 2018

It's spring-cleaning season, meaning many diligent homeowners are busy trying to organize their closets and homes in preparation for the spring and summer. Organizations, both small and large, also must keep up with cleaning their virtual dust bunnies on a regular basis, just as one would do within their own home.

Posted May 23, 2018

DataOps is emerging as a methodology for data scientists, developers, and other data-focused professionals to enable an agile workflow while also adhering to data governance requirements. Kellyn Pot'Vin-Gorman, Technical Intelligence Manager, Delphix, presented her session, "Making Big Data Bite-Size with DataOps" on Wednesday, May 23, 2018 during Data Summit 2018. Pot'Vin-Gorman discussed how to move from simple DevOps with tools and automation, while making the data central to the solution.

Posted May 23, 2018

While companies are collecting treasure troves of information about their customers, they are increasingly looking for the right tools and technologies to gain a 360° view that is critical to leveraging the data's full value. Zak Pines, VP marketing, Bedrock Data, presented his session, "Overcoming Data Silos to Get a Unified View of Customers" on Tuesday, May 22, 2018 during Data Summit 2018.

Posted May 22, 2018

The evolution of computing has changed dramatically since the mainframe was first introduced. Thanks to a proliferation of options for handling Big Data more naturally and efficiently than relational database management systems (RDBMS), we are in a "post-relational era." David Teplow, CEO, Integra Technology Consulting, presented his session, "SQL's Sequel: Hadoop and the Post-Relational Revolution" on Tuesday, May 22, 2018 during Data Summit 2018. His session deep dived into the best solutions to utilize during this "era."

Posted May 22, 2018

MariaDB Server 10.3 introduces Oracle compatibility, allowing users to utilize Oracle PL/SQL and Oracle sequences in an open source database. This makes it easier for DBAs and developers to migrate and/or reuse database code.

Posted May 22, 2018

Hadoop has forever changed the economics and dynamics of large-scale computing, and its use among enterprises looking to augment their traditional data warehouses continues to grow. During the first day of Data Summit, May, 21, 2018, Marco Vasquez, senior technical director, MapR, held a pre-conference workshop exploring the basics of Hadoop.

Posted May 21, 2018

With the proliferation of big data throughout enterprises, businesses need innovative ways to derive insights to propel business value. This is where knowledge graphs come in, a tool that can drive new marketing strategies to maintain existing customers and attract new ones.

Posted May 17, 2018

Extending autonomous capabilities across its Cloud Platform, Oracle has announced the availability of Oracle Autonomous Analytics Cloud, Oracle Autonomous Integration Cloud, and Oracle Autonomous Visual Builder Cloud.

Posted May 16, 2018

Technology is constantly changing, and IT architects need to keep up with modern developments to ensure that their companies are achieving the best possible return on their IT investment. This can be achieved by architecting a solid IT infrastructure with modern components spanning the hardware, software, network resources, and services required for the operation and management of an enterprise IT environment.

Posted May 11, 2018

When it comes to capturing and analyzing data, IT departments have more choices today than ever before. And choice is a good thing. However, in order to pick the right tool for the job, enterprises need to fully understand the business requirements as well as choices. DBTA recently held a webinar with Brian Bulkowski, CTO and founder of Aerospike, and Jean-Pierre Dijcks, master product manager, big data, Oracle, who discussed the key differences between Hadoop, NoSQL,  and RDBMS and how to choose between them.

Posted May 11, 2018

It's time to vote for the annual Database Trends and Applications Readers' Choice Awards Program in which the winning information management solutions, products, and services are chosen by you—the people who actually use them. Voting ends Friday, May 11, 2018, so be sure cast your ballot now for the candidates of your choice.

Posted May 08, 2018

Innovative organizations in a range of fields are using ground-breaking tools to put data to work for a variety of purposes—in some cases, with life-saving results. At Data Summit 2018, Fabricio Silva, an informationist at Knowledgent, and Yan Ge, director of data analytics, Global R&D, Data Science Institute, Takeda Pharmaceuticals, will showcase how Knowledgent's technology is improving diagnostics for the global pharmaceuticals company during a presentation, titled "Disrupting Paradigms with Analytics."

Posted May 08, 2018

We're all familiar with the IT "war room" scenario. When there's an issue, members of the IT team come together to troubleshoot and find a solution. For organizations with important applications, such as SQL Server running in virtual infrastructures, these IT teams are no strangers to the IT war room environment. In this case, input from the SQL Server system administrators and DBAs isn't considered (or even requested) when the infrastructure team implements it virtualization plan.

Posted May 07, 2018

As data from the Internet of Things is emerging and changing the data landscape as we know it, a new set of challenges are rising. IoT devices that generate megabytes or gigabytes of data per second are stunning organizations. Certainly, the infrastructure will have to change, as those volumes of data will likely overwhelm the available bandwidth for aggregating the data into a central repository.

Posted May 02, 2018

As we enter a new era of database technology with the introduction of Oracle's Autonomous Database Cloud, it is time for organizations to get up to speed in terms of what it enables for the business, and for DBAs, as well, to prepare for the changes to their roles.

Posted May 02, 2018

Due to the constant influx of data, data warehousing has been forced to evolve or get left behind. Conventional, on-premises data warehouses are simply unable to provide the agility, elasticity or pay-as-you-go efficiency that today's businesses and analytics use cases demand.

Posted April 26, 2018

Companies continue to get wrapped up in this constant big data deluge. Expanding data volumes and longer data retention requirements are putting enormous and previously unforeseen stresses on organizations' data security and compliance environments.

Posted April 26, 2018

HCL Technologies (HCL), along with Sumeru Equity Partners (SEP), a technology and growth-focused private equity firm, have signed a definitive agreement to acquire Actian Corporation. The all-cash deal is valued at $330 million.

Posted April 26, 2018

An astounding array of new technologies and approaches have emerged on the database scene over the past few years that promise to turn the next 12 months into a time of unprecedented transformation for the database landscape. There are new developments, along with reinforcement of tried-and-true technologies, some of which may help make the jobs of data managers just a bit easier.

Posted April 25, 2018

Dremio has announced its first release since the company's launch in the data analytics market with the availability of the Dremio Self-Service Data Platform in July 2017. Embracing the data lake and helping companies to drive more of their data science and BI workloads directly out of it without data transfer is a central theme in the Dremio 2.0 release.

Posted April 25, 2018

DBAs can recover a database, tune SQL, and may even know how to write some PL/SQL when push comes to shove. And, yes, those are all great skills to have. But in 2018, DBAs need more, writes Matt Malcheski in a new IOUG SELECT article. Malcheski goes over the "hot topics," including blockchain, AI, and Internet of Things, and notes that DBAs of the future will need to understand not only the technical aspects of these and the other technologies but also must be able understand and add value to the functional data requirements necessary for all-encompassing solutions. "This is characterized in a data point from Gartner: By 2021, 40% of IT staff will be 'versatilists' holding multiple roles, most of which will be business rather than technology related."

Posted April 18, 2018

Hitachi Consulting, a subsidiary of Hitachi, Ltd., a Platinum level member of Oracle PartnerNetwork (OPN), and provider of consulting-led solutions and services, has been named an OPN Cloud Elite partner. Joining a small number of Oracle partners who have attained this designation, Hitachi Consulting earned the status by achieving a set of criteria that demonstrate its full investment in Oracle Cloud solutions.

Posted April 18, 2018

Presented once each year by three major Oracle users groups—Independent Oracle Users Group, Oracle Applications Users Group, and Quest International Users Group—COLLABORATE is one event focused solely on the spectrum of Oracle technologies and solutions that you can count on to get information from experts and fellow users about practical implications, real-world use cases, and how to benefit from new solutions and overcome difficulties you may be having.

Posted April 18, 2018

As the volume and complexity around data grows, it has become more critical than ever for organizations to develop a deep knowledge of their business context and to understand and quantify the value of that data.

Posted April 18, 2018

Special early bird registration pricing for Data Summit 2018 has been extended for 1 week, and will end Friday, April 27. The Data Summit conference is a unique world-class event that brings together IT practitioners and business stakeholders from top corporations, government agencies, and public institutions to learn about the leading technologies and strategies for succeeding in this increasingly data-driven world.

Posted April 17, 2018

Priority Software Ltd., a provider of ERP solutions, is releasing Priority v18.2, enhancing system openness and mobile capabilities, introducing a new document generator, and boosting support for regulations compliance.

Posted April 12, 2018

For data architects, it is not unusual to use a data modeling tool to reverse-engineer existing solutions' databases. The reverse-engineering could occur for a functional reason, such as gathering information to evaluate a replacement option, or to comprehend a solution, seeking to work out what data should be extracted for a downstream business intelligence need.

Posted April 12, 2018

Data lake is a newer IT term created for a new category of data store. But just what is a data lake? According to IBM, "a data lake is a storage repository that holds an enormous amount of raw or refined data in native format until it is accessed." That makes sense. I think the most important aspect of this definition is that data is stored in its "native format." The data is not manipulated or transformed in any meaningful way; it is simply stored and cataloged for future use.

Posted April 12, 2018

Startups with a mission to address an unanswered problem continue to emerge in the tech sector. These companies tap into new and still emerging technologies such as cloud, IoT, machine learning, containerization, AI, NoSQL, and blockchain to provide fresh solutions that simply were not possible before.

Posted April 11, 2018

MicroStrategy, a provider of enterprise analytics and mobility software, is releasing an enhanced version of its flagship software, boosting mapping capabilities and more. Version 10.11 introduces new out-of-the-box visualizations, intelligent recommendations for content, prompts for dossiers, a native MicroStrategy Library app for smartphones, and more.

Posted April 10, 2018

SentryOne has launched new professional services offerings aimed at helping companies save time and resources in resolving SQL Server performance issues. While SentryOne has always offered service to customers who needed to supplement their internal structure with a deeper level of expertise in deploying monitoring tools, Pro Services formalizes the different levels of engagement options and provides access to the company's database administration experts, said Scott Brooks, SentryOne vice president of customer success.

Posted April 10, 2018

Launched in 2012 after 2 years in stealth mode, cloud data warehousing company Snowflake Computing kicked off 2018 by announcing $263 million in additional growth funding. Since its founding 6 years ago, Snowflake has raised a total of $473 million in growth funding with the mission to combine the power of data warehousing, the flexibility of big data platforms, and the elasticity of the cloud. Recently, Christian Kleinerman, the company's VP of product, reflected on how enterprise data architecture is changing and the growing role of cloud in analytics.

Posted April 09, 2018

Oracle executive chairman and CTO Larry Ellison announced the availability of the first service based on the new Oracle Autonomous Database during a presentation at Oracle headquarters. Described as "the world's first self-driving, self-securing, self-repairing database cloud service," the Oracle Autonomous Data Warehouse Cloud uses machine learning to deliver performance, security, and availability with no human intervention.  

Posted April 04, 2018

Not many companies have the opportunity to take a greenfield approach to data architecture. Most have "accidental architectures" that were never really intentionally designed at all, but instead have been built up over time across different eras of data management, according Rick Sherman, managing partner of Athena IT Solutions. But fragmented architectures can still be improved, says Sherman, who will present a talk titled "Designing a Data Architecture for Modern Business Intelligence and Analytics" at Data Summit.

Posted March 29, 2018

It's time to vote for the annual Database Trends and Applications Readers' Choice Awards Program in which the winning information management solutions, products, and services are chosen by you—the people who actually use them. This year, there are 27 categories in which to vote—providing plenty of opportunity for the recognition of both well-established products as well as new and cutting-edge technologies.

Posted March 28, 2018

With more big data options than ever before we are now in the post-relational database era, according to David Teplow, CEO, Integra Technology Consulting. However, professionals aren't done with relational database management systems (RDBMS) and are utilizing Hadoop, HBase, Cassandra, MongoDB and more, alongside tried and true RDBMS solutions.Teplow will discuss the rise of Hadoop and other massively parallel processing architectures during his Data Summit 2018 session titled, "SQL's Sequel: Hadoop and the Post-Relational Revolution."

Posted March 28, 2018

Redgate Software, a Microsoft SQL Server tools vendor, is updating its SQL Monitor solution, adding capabilities that allow it to integrate with the deployment tools in Redgate's portfolio. The new deployment capability is important because the increased frequency of releases that DevOps enables means companies and organizations are shifting from big deployments to smaller ones.

Posted March 27, 2018

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

Sponsors