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
Reduction in Cost: Huge reduction in costs can be achieved due to cloud computing both in terms of capital expenditure and operational expenditure. Since the organization now need not build its own
Reduction in Cost:
Specify the various advantages of the Lookup persistent cache?
When the collision and overlapping take place at same time, what will be the bucket size?
State the components of report studio?
Write down the purpose of Fact-less Fact Table?
Explain the way to select tables for partition in Sybase?
Define the Quick Sort.
Specify the System variables?
What do you understand by the term snapshot replication in DBMS?
Write down the brief notes on multidimensional data model.
18,76,764
Questions Asked
21,311
Experts
9,67,568
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!