Get started

Data warehouse software

• data warehouse

  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

• data mart (datamart)

  A data mart is a repository of data that is designed to serve a particular community of knowledge workers. Continue Reading

• Apache Hive

  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

• Google Cloud data lake fuels cloud payment processing flow

  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

• semantic technology

  Semantic technology is a set of methods and tools that provide advanced means for categorizing and processing data, as well as for discovering relationships within varied data sets. Continue Reading

• Definitions to Get Started

  • data warehouse
  • data mart (datamart)
  • Apache Hive
  • semantic technology

  • data warehouse as a service (DWaaS)
  • Extract, Load, Transform (ELT)
  • tree structure
  • extract, transform, load (ETL)

  View All Definitions

• A buyer's guide to selecting the best data warehouse product

  With several deployment options and product choices, it's difficult to know where to start. This buyer's guide helps you choose the right data warehouse product for your company.Continue Reading

• data warehouse as a service (DWaaS)

  Data warehousing as a service (DWaaS) is an outsourcing model in which a service provider configures and manages the hardware and software resources a data warehouse requires, and the customer provides the data and pays for the managed service.Continue Reading

• Big data software finds common ground with EDWs, governance programs

  In many companies with big data projects, Hadoop clusters are moving toward peaceful coexistence with data warehouses and data governance efforts.Continue Reading

• Extract, Load, Transform (ELT)

  Extract, Load, Transform (ELT) is a data integration process for transferring raw data from a source system to a target database and then preparing the information for downstream uses.Continue Reading

• Quiz: Data warehouse performance issues

  After you view and listen to the content in our data warehouse performance classroom, take this short quiz to test your knowledge of the topic.Continue Reading

• The analytical advantages of an enterprise data warehouse system

  Learn about the potential benefits of an enterprise data warehouse system for analytics uses. Also, find out about the data security issues and cost considerations of large data warehouses.Continue Reading

• Why IT departments should consider a large data warehouse system

  Find out how a large data warehouse system can benefit companies. Learn how enterprise data warehouses help meet business needs. Get tips on operational considerations for a central data warehouse.Continue Reading

• Exploiting the power of a large enterprise data warehouse

  Learn how to take advantage of a large enterprise data warehouse in this book excerpt. And find out how the proliferation of data sources, data volumes and queries affects data warehouse performance.Continue Reading

• Quiz: Data warehousing technologies and trends

  After you watch consultant Rick Sherman’s BI University classroom videos on data warehousing, take this short quiz to test your knowledge of data warehouse tools and best practices.Continue Reading

• Test time: What do you know about 'big data' technologies?

  Take this short quiz to test your understanding of ‘big data’ technologies, use cases and management issues – plus get recommendations for additional reading on big-data topics.Continue Reading