answersLogoWhite

0

Characteristics of data warehouse

Updated: 9/14/2023
User Avatar

Wiki User

12y ago

Best Answer

Hi,

1. Subject Oriented

2. Integrated

3. Nonvolatile

4. Time Variant

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Characteristics of data warehouse
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the characteristics of data in a data warehouse?

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


What is data where housing and mining?

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.


What describes contents of a data warehouse?

A data warehouse stores structured data from various sources for analysis and reporting. It typically includes historical data, organized into tables, aimed at supporting decision-making processes. Data warehouses are optimized for complex queries and data aggregation.


What do you mean by data warehouse?

Data warehouse is a house where current as well as historical data can be stored.


What are the key relationships between data warehouse and data mining?

Data warehouse is the database on which we apply data mining.


How does Data Warehouse differ from Data Mart?

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.


Which are the characteristics of data mart?

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.


Every data structure in data warehouse contains time element?

Every data structure in the data warehouse contains the time element. Why?


What are the characteristics of warehouse?

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.


What are benefits of data warehouse?

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.


What makes the best data warehouse architecture?

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.


What are the advantages of a warehouse?

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.