New & Notable
Data warehouse software News
July 27, 2018
Google is enabling BigQuery users to build SQL-based machine learning models inside the cloud data warehouse via a BigQuery ML technology now out in beta.
December 01, 2017
After Cyber Monday, Amazon Web Services techies headed for re:Invent 2017. There, among a deluge of cloud product announcements by AWS, the Amazon Neptune graph database surfaced.
July 12, 2017
Spirited competition is under way among cloud providers as they enhance large-scale relational data warehouses in the cloud. An Azure SQL Data Warehouse update by Microsoft is the latest example.
December 02, 2016
Amazon's Athena data engine brings interactive SQL queries to S3 data sets and lets users pay as they go. It's based on an open source framework called Presto that Teradata and others also employ.
Data warehouse software Get Started
Bring yourself up to speed with our introductory content
A data warehouse is a federated repository for all the data collected by an enterprise's various operational systems, be they physical or logical. Continue Reading
Apache Hive is an open source data warehouse system for querying and analyzing large data sets that are principally stored in Hadoop files. Continue Reading
To create a cloud payment processing system, Global Payments first had to deploy a data lake in the Google Cloud. Getting quick user feedback was another early step. Continue Reading
Evaluate Data warehouse software Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
There are many ways to store big data, but the choice of data warehouse vs. data lake vs. data mart comes down to who uses the data and how. Use this cheat sheet to compare. Continue Reading
GPU databases offer a new way to process data. 451 Research analyst James Curtis discusses where they fit in big data applications, particularly for parallel processing. Continue Reading
Amazon's Neptune database may change the status quo in the graph technology world. But it could also introduce a wider base of possible users to graph databases, existing vendors say. Continue Reading
Manage Data warehouse software
Learn to apply best practices and optimize your operations.
Mapping data to a graph model can be challenging -- but it can also help an organization create prototypes to evaluate graph database tools in a growing market. Continue Reading
Siloed data isn't only a problem for businesses. It's also a big issue for many large universities -- one that their data infrastructures need to resolve for effective analytics. Continue Reading
The crush of big data leads some data pros to seek more automation of data integration processes. The Pentaho software platform now offers metadata injection capabilities to help meet such needs. Continue Reading
Problem Solve Data warehouse software Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Fact tables and dimension tables are used together in star schemas to support data analytics applications. But they play different roles and hold different types of data. Continue Reading
Operational data stores and data warehouses both store operational data, but the similarities between them end there -- and they both have a role to play in analytics architectures. Continue Reading
In a video interview, consultant Claudia Imhoff discusses the increasing need to augment data warehouses with technologies such as Hadoop and real-time analytics systems. Continue Reading