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
Specify the major components of the Designer Interface?
Write a brief note on a distributed database?
Explain what is meant by the repository and what does it consists of?
Give a brief introduction of the term data mining and data modeling? In what manner both the termed are used?
What occurs while rows are determined using a FETCH statement?
Clarify briefly why dimension tables is de-normalized in the nature?
Explain the ways to controlling Cursor Behavior.
What do you understand by the term RFM analysis?
Explain for what the Supervisor module is used?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
18,76,764
1939599 Asked
3,689
Active Tutors
1443397
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!