Areas where data warehouses are utilized
Specify some of the areas where the data warehouses are utilized in the present and in the future?
Expert
Potential subject areas where the data ware houses may be designed at present and also in future are:
a) Census data:
Registrar general and census commissioner of te India decennially compiles the information of all the individuals, villages, population groups and so on. This information is wide ranging just like the individual slip. A compilation of the information of individual households, of which the database of 5%sample is retained for analysis. Data warehouse may be built from this database over which the OLAP techniques may be applied, Data mining can also be carried out for analysis and knowledge discovery.
b) Prices of vital Commodities:
Ministry of the food and civil supplies, Government of the India complies daily basis data for around 300 observation centers within the whole country over the prices of the vital commodities like rice, edible oil and so on, a data warehouse may be built for this data and OLAP methods may be applied for its analysis
States the term Star Schema?
Describe briefly the alternative terminology which is employed in the relational model?
Database Requirements Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: • Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classifie
Illustrate briefly the term insertion and deletion anomalies?
Describe briefly Recovering sessions?
Write about the term APT_CONFIG within the data stage?
What is meant by the parameter file?
Explain the linked universes?
Define the term File Manager and Storage Manager in relational database management system.
Explain the term CLIPPER.
18,76,764
1922487 Asked
3,689
Active Tutors
1413536
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!