Latest Answer: Dimensional modelling consist of 3 stages1.conceptual Requirementshere business architect should be clear with facts and levels (data for Dimension table)2.Logical requirementshere he has to design dimension table with levels, and c=fact table with facts ...
Answered by Kiran on 2005-05-06 20:12:19: The perception of what constitutes a VLDB continues to grow. A one terabyte database would normally be considered to be a VLDB.
Latest Answer: Very Large Database (VLDB)it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows. Typically, these are decision support systems or transaction processing applications serving large ...
Latest Answer: Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose. ...
Latest Answer: When you design a DB you always use identification numbers to define objects instead of the actual name or description and store the description in a lookup table.that makes any later update or insertion of any name or description ...
Latest Answer: A sheduling tool is a tool which is used to shedule the datawarehouse jobs...All the jobs which does some process are sheduled using this tool, which eliminates the manual intervension. ...
Answered by on 2005-03-23 01:45:54: bitmap index
Latest Answer: Space requirements for indexes in a warehouse are often significantly larger than the space needed to store the data, especially for the fact table and particularly if the indexes are B*trees.Hence, you may want to keep indexing on the fact table to a ...
Latest Answer: Raid 0 - Make several physical hard drives look like one hard drive. No redundancy but very fast. May use for temporary spaces where loss of the files will not result in loss of committed data. Raid 1- Mirroring. Each hard drive in the ...
Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much
Latest Answer: As explained by users , i think DWH is repository containing subject-oriented , integrated , nonovalatile and time varient data which helps the management to analysis the business trends and take the appropriate decision to improve the business.It is ...
Latest Answer: Granularity means nothing but it is a level of representation of measures and metrics.The lowest level is called detailed dataand highest level is called summary dataIt depends of project we extract fact table significanceBye ...
Answered by Puneet on 2005-05-07 04:24:28: Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance dataware house can be used to mine data for the most high
Latest Answer: Data Mining: Smpler way we can define as DWH(Data Warehouse)+ AI(Artificial Intellegence)used in DSS(Decision Supportive System) ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 Next >>
Go Top
