Hi,
1. Subject Oriented
2. Integrated
3. Nonvolatile
4. Time Variant
Data warehouse is the pool of huge amount of data. The data in data ware house can be archived. And when the data is needed you can extract it from the archived files.
The answer will depends on where in the world the warehouse is!
The system that collects data from various key business processes and stores it in a single comprehensive data repository is often referred to as a Data Warehouse. It integrates data from multiple sources, allowing for centralized storage and analysis. This enables different departments within the organization to access and utilize the data for decision-making, reporting, and operational efficiency. Additionally, tools like Enterprise Resource Planning (ERP) systems may also play a role in consolidating data across business functions.
* Inventory: A concept of having something stored. * Warehouse: A building to store goods in.
There are many different programs available to inventory a warehouse. Matrix is a company that offers handheld units that one can enter the information into and it will provide detailed reports about the amount of inventory in a warehouse.
Metadata is data about data that provides information such as the structure, format, and characteristics of the data stored in a data warehouse. It is used in data warehouse architecture to facilitate data integration, data governance, and data lineage. Metadata helps users understand and manage the data in the data warehouse efficiently.
There are four key characteristics which separate the data warehouse from other major operational systems:Subject Orientation: Data organized by subjectIntegration: Consistency of defining parametersNon-volatility: Stable data storage mediumTime-variance: Timeliness of data and access terms
it's data warehouse....data warehouse: it is a collection of multiple databases or it it is repository of data.data mining it is the process of extracting data from data warehouse.
Data warehouse is a house where current as well as historical data can be stored.
Data warehouse is the database on which we apply data mining.
Data marts are combined into a data warehouse cannot be built alone without considering data marts. Both has equal importance to built proper data warehouse.
A data mart is a data repository that gathers data and similar items from certain users or workers. Its characteristics include being focused on one subject like finances or sales, only gathering data from a couple sources like the external data or central data warehouse, and being controlled by only one source.
A temporary warehouse is a type of warehouse, and it can be an efficient solution to storage problems if you need a warehouse right away.
Every data structure in the data warehouse contains the time element. Why?
One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.
A data warehouse architecture is similar to various relational database systems. What makes the best architecture is the organization of the warehouse itself and the data it consist of.
Data warehouse is the pool of huge amount of data. The data in data ware house can be archived. And when the data is needed you can extract it from the archived files.