According to William Inmon, widely considered the father of the modern data warehouse, a Data Warehouse is a "Subject-Oriented, Integrated, Time-Variant, Nonvolatile collection of data in support of decision making". Data Warehouses tend to have these distinguishing features: (1) Use a subject oriented dimensional data model; (2) Contain publishable data from potentially multiple sources and; (3) Contain integrated reporting tools.
The most widely recognized definition of a data warehouse is, “subject-oriented, integrated, time variant, non-volatile collection of data in support of management's decision-making process.” (Inmon, 1992). Subject-oriented means the data warehouse focuses on the high-level entities of the business, such as students, courses, accounts, and employees. This is in contrast to operational systems, which deal with processes such as student registration or payment of an invoice. Integrated means the data are stored in consistent formats (e.g., consistent naming conventions, domain constraints, physical attributes, and measurements). Time variant means the data are associated with a point in time (e.g., semester, fiscal year, or pay period). Finally, non-volatile means the data do not change once they are entered into the warehouse. Data warehouses are large collections of uniquely organized data that are primarily used to support analytical processes. They can contain highly aggregated as well as finely detailed data that is designed to assist in the decision-making tasks of senior management and operational staff alike.
Integrates separate databases within a health care system for the interchange of data and reports to allow the management information system (MIS) system to handle data from several sources as if from one source. (See Clinical Data Repository)
The department or entity charged with collecting organization-wide data, verifying its accuracy, and analyzing, managing, and distributing it throughout the organization. In organizations without a data warehouse, each department may collect, analyze, manage, and distribute the data it needs for its operations.
A data warehouse is a collection of data designed to support decision making and analytical processing. Data warehouses contain a wide variety of data, usually from multiple data sources, presenting a comprehensive view of a particular business environment. Due to the nature of the data stored in a data warehouse, the size of the data warehouse is usually very large, so it requires special design and planning.
A data collection -- prepackaged or summarized according to specific business rules and designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business information.
The gathering of extensive data - especially on customers and sales - and complex multi-dimensional queries on the data. Depending on the type of data storage, one distinguishes between Data Marts and Data Warehouses. Data Mining refers to the analysis of data records.
A collection of integrated, subject-oriented databases designed to support the DSS function, where each unit of data is relevant to some moment in time. The data warehouse contains atomic data and lightly summarized data.
a copy of transaction data specifically designed to give decision makers instant access to information through the usage of query and reporting tools, enabling knowledge tools such as analysis, forecasting and trending
a system used for storing and delivering huge quantities of data, while data warehousing refers to the process used to extract and transform operational data into informational data and loading it into a central data store or "warehouse"
a generic term for a system for storing, retrieving, and managing large amounts of any type of data from single or multiple sources; often includes sophisticated compression and hashing techniques for fast searches and advanced filtering. The terms relational, network, flat, and hierarchical all refer to the way it organizes information internally.
An aggregate of information from various resources stored centrally to provide flexible and efficient access to data. Many organizations keep a data warehouse to maintain large amounts of business data, such as transaction histories and analyze it to help support business decisions.
An information collection, transformation, and distribution center that offers an organization access to critical information for driving, managing, tracking, and measuring enterprise strategies and processes. In other words, a data warehouse integrates data from multiple sources into one place for ease of use.
A central computer repository that stores all (or significant portions of) the data collected by an enterpriseås multiple business systems. Data from online transaction processing applications and other sources is selectively collected, extracted, sorted, and cleaned. Then it is stored in a data warehouse, which is usually housed in an enterprise mainframe server.
A record of an enterprise's past transactional and operational information, stored in a database. Data warehousing is not meant for current "live" data; rather, data from the production databases are copied to the data warehouse so that queries can be performed without disturbing the performance or the stability of the production systems.
A ready-only informational database. Populated with detailed, summary and exception data and information generated by other transaction and management information systems. Can be accessed by end-users and managers with DSS tools that generate a virtually limitless variety of information in support of decision-making. Data must be full and consistent; bad data will be rejected; data is in a consistent state before and after load; used for trend analysis, yearly comparisons, summaries of thousands/millions of records. History is preserved.
A is a central repository for all or significant parts of the data that an enterprise's various business systems collect. Data warehousing emphasizes the capture of data from diverse sources for useful analysis and access, but does not generally start from the point-of-view of the end user or knowledge worker who may need access to specialized, sometimes local databases.
A subject oriented, integrated, time-variant, non-volatile collection of data in support of management's decision making process. A repository of consistent historical data that can be accessed and manipulated easily for decision support. (2) An implementation of an informational database used to store sharable data sourced from an operational database-of-record. It is typically a subject database that allows users to tap into a company’s vast store of operational data to track and respond to business trends and facilitate forecasting and planning efforts.
A repository for data organized in a format that is suitable for ad hoc query processing. The data is built from operational databases used for day-to-day business processes. The data is cleaned and transformed in such a way that is amenable to fast retrieval and efficient analysis.
A collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time. Development of a data warehouse includes development of systems to extract data from operating systems and applications plus installation of a warehouse database system that provides managers flexible access to the data. The term data warehousing generally refers to the combination of many different databases across an entire enterprise.
The Data Warehouse is a database repository containing historical data that is usually consolidated from several sources. Note that it is separate from other transaction-oriented databases, and is targeted for the purpose of analysis to aid the organization in decision-making. A data warehouse can grow to be quite large and provides the database infrastructure of a business intelligence solution.
A central repository for all or significant parts of the data that a system collects. A data warehouse typically is a database or collection of databases existing in virtual, rather than physical, space.
A database containing copious amounts of information, organized to aid decision-making in an organization. Data warehouses receive batch updates, and are configured for fast online queries to produce succinct summaries of data.
A separate database dedicated to decision support. Data is transferred from transaction processing systems and integrated. A data warehouse can provide management information via report writers, query tools, data access and retrieval tools, OLAP servers, and enterprise information systems.
A separate database dedicated to decision support. Detailed data is transferred from different transaction processing systems and integrated in order to provide a single view of the customer. It can be used to support customer segmentation, profitability analysis, campaign management, oneâ€‘toâ€‘one marketing, data mining, etc.
A relational database that is designed for query and analysis rather than transaction processing. A data warehouse usually contains historical data that is derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables a business to consolidate data from several sources. In addition to a relational database, a data warehouse environment often consists of an ETL solution, an OLAP engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users. See Also: ETL and online analytical processing (OLAP)
The Data Warehouse is a central repository of data that provides the MIT community with integrated, up-to-date data from various administrative systems. Using a reporting tool called BrioQuery, you can download the information from the database into a report format. Many standard data warehouse reports are available, or you can create reports of your own.
A database structured and optimized for distribution. It collects and stores integrated sets of historical data from multiple operational systems and feeds them to one or more data marts. It may also provide end-user access to support enterprise views of data.
A separate database dedicated to decision support. Data is transferred from transaction processing systems and integrated. It is accessed to provide management information through report writers, query tools, data access and retrieval tools, OLAP servers and enterprise information systems. It is a software architecture, not a product.
1. An information infrastructure that enables businesses to access and analyze detailed data and trends. 2. A separate store of transactional data that provides a single integrated view of the customer. (Also known as Customer Information Repository).
A collection of data that supports decision-making. Unlike data used in an online transaction processing system, warehouse data is usually subject-specific, historic, and non-volatile. A data warehouse usually contains many years of data.
An integrated repository of data from multiple, possibly heterogeneous data sources, presented with consistent and coherent semantics. Warehouses usually contain summary information represented on a centralized storage facility.
A subject-oriented non-volatile collection of data used to support strategic decision making. The warehouse is the central point of data integration for business intelligence. It is the source of data for data marts within an enterprise and delivers a common view of enterprise data.
A database, frequently very large, that can access all of a company's information. While the warehouse can be distributed over several computers and may contain several databases and information from numerous sources in a variety of formats, it should be accessible through a server. Thus, access to the warehouse is transparent to the user, who can use simple commands to retrieve and analyze all the information. The data warehouse also contains data about how the warehouse is organized, where the information can be found, and any connections between data. Frequently used for decision support within an organization, the data warehouse also allows the organization to organize its data, coordinate updates, and see relationships between information gathered from different parts of the organization.
An enterprise structured repository of subject-oriented, time-variant, historical data used for information retrieval and decision support. The data warehouse stores atomic and summary data. The data warehouse is the source data stored in the data marts.
A database built to support information access. Typically a data warehouse is fed from one or more transaction databases. The data needs to be cleaned and restructured to support queries, summaries, and analyses.
A data warehouse is one or more databases designed to support management, analysis, reporting and decision making in an organization. Data from the operational systems (such as Banner) are migrated to the data warehouse so that queries can be performed without disturbing the performance or the stability of the operational systems. The traditional features of a data warehouse are: subject-oriented, integrated across subject areas and time-oriented, i.e., there is a historical perspective to the data. A data warehouse generally contains both detailed data and may also contain summarized data. What is included in a data warehouse environment varies widely but is generally acknowledged to be the database(s), documentation about the data (metadata), a delivery/access method and a commitment to extract, transform and load (ETL) data from multiple source systems. (Adapted from http://www.pcmag.com/encyclopedia_term and Bill Inmon, 1996) ()
A database specifically designed to contain historic snapshots of various operational system data, normally in an aggregated and cleansed form. Used for reporting and strategic Decision Support by data analysts. Data in a data warehouse is stored in different structures from that stored in transactional systems.
A data warehouse is a subject oriented, integrated, non volatile, time variant collection of data. The data warehouse contains atomic level data and summarized data specifically structured for querying and reporting.
A collection of data designed to support management decision making. Development includes a warehouse database providing efficient, flexible access to data in order to complete queries, projections, and data summaries.
A collection of databases designed to support management decision-making. The term “data warehousing” generally refers to combining a wide variety of databases across an entire organization. Development of a data warehouse includes development of systems to extract data from operating systems plus installation of a warehouse database system that provides users flexible access to the data.
data warehouse is a collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time. Data warehousing generally refers to the combination of many different databases across an entire enterprise. [Source: Webopedia.com
The Data Warehouse is a storehouse of recent production data, organized logically and efficiently to promote fast queries and the development and execution of financial reports without affecting the daily operations of the production database.
A database warehouse is a database where various parts of the data collection must be archived for future longitudinal studies.It is most often accompanied by data mining capabilities to provide data in display for analysis and comparison over time.
A collection of databases combining information from different parts of an organization, generally used in conjunction with data mining techniques. A large retailer's data warehouse, for example, may contain information about customer purchases, supplier deliveries, transport vehicle schedules and new products.
Databases that typically have more information in them than repositories, bringing together clinical, financial and demographic information. Data warehouses are typically used retrospectively to conduct research through the use of on-line analytical processing tools.
Data mining and data warehousing go hand in hand. Before you can effectively mine information, you have to put it all in one place - at least temporarily. Data warehousing involves integrating information from different systems, functions, and locations across an enterprise into a central database to allow more accurate analysis of customer needs, buying patterns, and profitability and improved decision making and marketing.
A generic term for a system for storing, retrieving and managing large amounts of any type of data. Data warehouse software often includes sophisticated compression and hashing techniques as well as specially designed databases for fast searches.
The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis (such as data mining) on the information without slowing down the operational systems.
An implementation of an informational database used to store sharable data sourced from an operational database-of-record. It is typically a subject database that allows users to tap into a company's vast store of operational data to track and respond to business trends and facilitate forecasting and planning efforts. DAMA web site at www.dmreview.com
a separate architecture used to maintain critical historical data that has been extracted from operational data storage and transformed into formats understandable to the organization's analytical community