... tool directly supports "analysis through time" by supporting aggregation of information by different time frames (week, month year). Data Mining Data mining refers to the use of sophisticated software to search and sift through large amounts of data stored in a data warehouse, typically using pattern recognition, statistical analysis and mathematical modeling tools, to uncover correlations, patterns and trends ... . Data mining provides a means of extracting unknown information from a data warehouse. In contrast to defined reports and ad hoc access tools ( ... which are designed to provi...

• Word Count: 2050
• Approx Pages: 8
• Grade Level: Undergraduate

An enterprise data-warehouse architecture needs to be as flexible as possible to meet the entire spectrum of current and future requirements. To maximize flexibility, a consolidated data warehouse should be stored in a standard RDBMS with a normalized database design, with some summaries and denormalization added for performance. This kind of data-warehouse design is sometimes called an atomic data warehouse. The main purposes of an atomic data warehouse are to serve as a staging ground for subsets of the atomic warehouse, called data marts, and to serve as a reference data warehouse. The size...

• Word Count: 560
• Approx Pages: 2
• Grade Level: Undergraduate