Which of the following includes in Data Warehousing?
Data analysis, data designing, construction and administration includes in data warehousing.
A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.
1) Data analyzing:-
Data analysis is a subset of business intelligence (BI), which also incorporates data warehousing, database management systems, and online analytical processing.
2) Data designing:-
A schema is a collection of database objects, including tables, views, indexes, and synonyms. Most data warehouses use a dimensional model. The model of source data and the requirements of users help to design the data warehouse schema.
3) Construction and administration:-
Construction administratorsare in charge of completing administrative duties during their company's construction projects. They are responsible for ensuring that all required materials are delivered to the work site. They also conduct construction progress meetings, as well as review schedules and work progress.