▼ Scroll to Site ▼

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

Oracle has identified a need for "augmented" analytics, leveraging machine learning and AI throughout the analytics process to help drive up the impact and value of data, and enable knowledge workers to uncover more insights. Recently, Bruno Aziza, group VP, Oracle Analytics, described this new phase in analytics, the role that cloud plays in making it possible, and what the capabilities will enable for customers.

Posted October 16, 2019

The cloud, ethics in artificial intelligence, privacy, and compliance were some of the topics that attendees were concerned about at Strata Data NY as data professionals converged at the Jacob Javits Center in New York City from September 24 - 26.

Posted October 15, 2019

Advanced analytics software provider Mode today announced the availability of its first instant, responsive data engine, Helix. Helix creates the dual backbone between modern business intelligence and interactive data science. By combining these workflows, data scientists no longer have to choose between shipping fast, one-off answers and building dashboards for broader coverage.

Posted October 14, 2019

GoodData, provider of end-to-end analytics solutions, announced it is now leveraging Amazon Redshift, a cloud data warehouse by Amazon Web Services (AWS). In addition, the combination of GoodData and Amazon Redshift can change the way in which enterprise and product teams are making business decisions. Namely, the trend toward integrating analytics into business applications so every customer, partner, and team member becomes empowered with data and insights at the point of work.

Posted October 11, 2019

DataStax, the company behind a database built on Apache Cassandra, is opening early access to the DataStax Change Data Capture (CDC) Connector for Apache Kafka. The DataStax CDC Connector for Apache Kafka gives developers bidirectional data movement between DataStax, Cassandra, and Kafka clusters. CDC is designed to capture and forward insert, update, and delete activity applied to tables (column families).

Posted October 10, 2019

Collibra, the Data Intelligence company, is making platform-wide upgrades to improve access to critical data and hasten time to insight. The new release introduces machine learning enhancements to Collibra Catalog and marks the availability of Collibra Privacy & Risk, a sustainable approach to compliance with modules for CCPA and GDPR.

Posted October 09, 2019

Has the meaning of big data changed? Many agree that data no longer has to be "big" to meet today's evolving requirements. In particular, open source and cloud tools and platforms have brought data-driven sensibilities into organizations that previously did not have such expertise, making big data more accessible.

Posted September 26, 2019

The big cloud vendors tout many reasons for running IT infrastructure in the cloud. A very prominent benefit is "accelerated innovation and delivery." That's a powerful selling point because every IT manager I have ever known wants to deliver better results, faster, and at lower cost. However, it seems that the less IT managers know about doing actual hands-on IT work, the more demanding they are.

Posted September 26, 2019

Yellowbrick Data, a provider of next-generation enterprise data warehousing, is releasing the Yellowbrick Cloud Data Warehouse and the Yellowbrick Cloud Disaster Recovery (Cloud DR) service. The Yellowbrick Cloud Data Warehouse has been operating in enterprise production environments since early 2019, and both new products leverage the power of the Yellowbrick Data Warehouse.

Posted September 25, 2019

Splunk, a provider of the data-to-everything platform, is making several advancements to pricing, partner, and investment initiatives designed to help customers make smarter business decisions.

Posted September 25, 2019

Radiant Advisers' John O'Brien identifies four focus areas for data analytics—understanding customer behavior, understanding product usage, increasing operational efficiency, and business model innovation—in his closing keynote at Data Summit 2019.

Posted September 24, 2019

Although adopting advanced analytics is on the radar for most organizations these days, it is important to understand some of the problems that can occur as you implement analytics projects. Perhaps the most important obstacle to overcome is ensuring buy-in from your organization's leaders.

Posted September 16, 2019

Each year, Big Data Quarterly presents the "Big Data 50," a list of forward-thinking companies that are working to expand what's possible in terms of capturing, storing, protecting, and deriving value from data.

Posted September 11, 2019

Quest Software's Jason Hall explains the need to manage multiple platforms simultaneously has complicated the jobs of database administrators in this clip from his presentation at Data Summit 2019.

Posted September 10, 2019

In order to protect your organization, it is critical to watch over the elements that have been built, keep processes running, and be on top of change. Spend the time and resources necessary to properly maintain the solutions for which you are responsible. The amount spent in such endeavors will be less time than that spent trying to play catch up on too many changes after bad things have resulted.

Posted September 03, 2019

We've reached the point where hybrid cloud arrangements have become commonplace in enterprises, and with this trend come implications for databases and data management. The rise of both hybrid and multi-cloud platforms means data needs to be managed in new ways, industry experts point out. And, there are lingering questions about which data should go into the cloud, and which should stay on-premise.

Posted August 29, 2019

Each year, Database Trends and Applications presents the Readers' Choice Awards, providing a unique opportunity to recognize companies whose products are selected by experts whose opinions carry more weight than any others—you, the readers. Here we present the top three vote-getters in each category. Congratulations to all and thanks to everyone who submitted nominations and voted!

Posted August 29, 2019

In previous articles, we looked at creating and managing Oracle Cloud Infrastructure (OCI) database and compute instances through the web UI. The UI is ideal for a new user and occasional management of a cloud environment. When a cloud administrator is managing and automating dozens or hundreds of instances, manually clicking through the UI becomes untenable. Oracle supports and maintains a number of developer tools to solve this problem.

Posted August 21, 2019

Athena IT Solutions managing partner Richard Sherman provides a whirlwind tour of today's predominant database technologies in this clip from his presentation at Data Summit 2019.

Posted August 20, 2019

Franz Inc., an early adopter of Artificial Intelligence (AI) and provider of Semantic Graph Database technology for Knowledge Graph Solutions, is now supporting Shapes Constraint Language (SHACL), a World Wide Web Consortium (W3C) specification for validating graph-based data against a set of conditions.

Posted August 15, 2019

Social media, the Internet of Things, demands for mobile access, and real-time insights are just some of the factors that have increased the pressure on organizations to change how data is managed. And as a result there have never been so many data management choices to deal with it all.

Posted August 14, 2019

The world's largest and most innovative businesses are turning to enterprise open source databases for mission-critical applications, with the most popular open source relational databases being MariaDB, MySQL, and Postgres.

Posted August 12, 2019

An effective approach to processing and transforming large datasets is likely comprised of multiple steps. The large data will likely be split apart into several smaller sets, maybe even in a couple of differing fashions with a common and understandable theme. But there should not be too many split-apart variants; rather, as with the three bears, it should be just the right number of smaller datasets. And then, similar to solving a Rubik's Cube, a twist or two at the very end brings all the new and old datapoints together in a complete and organized fashion.

Posted August 07, 2019

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when it comes to optimizing and tuning your SQL Server database performance.

Posted August 07, 2019

Richard Sherman, Athena IT Solutions managing partner, discusses data's three states—integrated, as-is, and curated/integrated—and what's required for analysis in each state in this clip from his presentation at Data Summit 2019.

Posted July 30, 2019

The need for faster and smarter data integration capabilities is growing. The proliferation of data sources, types, and stores is increasing the challenge of combining data into meaningful, valuable information. At the same time, to deliver business value, people need information they can trust to act on, so balancing governance is absolutely critical nowadays, especially with new regulations.

Posted July 29, 2019

Data Summit 2019 in Boston drew industry experts with deep knowledge spanning all areas of enterprise IT, including AI and machine learning, analytics, cloud, data warehousing, and software licensing who presented 3 days of thought-provoking sessions, keynotes, panel discussions, and hands-on workshops. Here are some key takeaways from the Data Summit 2019.

Posted July 25, 2019

While change has always been a part of the database credo, the growing emphasis on data-driven decision making in today's economy has resulted in a dizzying plethora of technologies and methodologies entering the market. The number and scope of game-changing technologies are too numerous to mention, and one thing is certain: Database management will never be the same. We have identified some of the most promising technology initiatives, based on discussions with and input from data experts from across the industry spectrum, gathering their views on the key technologies—well-known or under the radar—that are worth watching.

Posted July 25, 2019

Data analytics is no longer the luxury of organizations with large budgets that can accommodate roving teams of analysts and data scientists. Every organization, no matter the size or industry, deserves a data analytics capability. Thanks to a convergence of technology and market forces, that's exactly what's happening.

Posted July 17, 2019

IBM has launched a data prep solution designed to help clients improve their DataOps processes so they can have data ready for AI more quickly and efficiently. Jointly developed with data prep software provider Trifacta, the new InfoSphere solution is engineered to work in conjunction with clients' existing data environments, including data lakes.

Posted July 08, 2019

Oracle has introduced the new Autonomous Database Dedicated service to provide customers with more control for their most mission-critical workloads. "Our Autonomous Database Dedicated service eliminates the concerns enterprise customers previously had about security, isolation, and operational policies when moving to cloud," said Juan Loaiza, executive vice president, Mission-Critical Database Technologies, Oracle.

Posted July 03, 2019

source{d}, a data platform for the software development life cycle (SDLC), is releasing a new Enterprise Edition with built-in visualization, management capabilities, and advanced analytic functions. source{d} enables enterprises to aggregate all SDLC data sources into one data lake where they can easily extract, load and transform source code, version control data, project tracking data, build systems data, configuration files and more.

Posted July 02, 2019

EnterpriseDB has been acquired by Great Hill Partners, a private equity firm. Financial terms of the private transaction were not disclosed. "This acquisition comes at a time when the Postgres market is exploding," said Ed Boyajian, president and CEO of EnterpriseDB. Michael Stonebraker, a pioneer in database technology and original architect of what is now Postgres, has been named technical advisor; and database expert and entrepreneur Andy Palmer has been named to the board of directors.

Posted July 01, 2019

Managing Oracle databases in the cloud may require some adjustments to the way you are used to doing things, so there is likely a learning curve when adding the additional tasks discussed in this article. In the end, database services in OCI are engineered to save time and avoid problems, among other things, so it is definitely worth the investment.

Posted June 27, 2019

IT executives and their business counterparts understand the importance of a strong data strategy and its value to their businesses, and most are starting to get the key pieces in place to drive transformation through next-generation technologies and processes. One in four enterprises now regards real-time data as critical to their ongoing operations—and another one in four is actively preparing to introduce real-time data capabilities into their infrastructures, according to a new Unisphere Research survey.

Posted June 26, 2019

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
27
28
29
30
31
32

Sponsors