Data exploration is a common process in data warehouses which are characterized by large bulks of data coming from disparate systems. Since these systems can have data in different formats and sources also when data converge in a central data warehouses it may be a very difficult task to get the relevant data needed for statistical reporting as well...

Modern data warehouses are becoming more and more powerful. In the past data warehouses can only present statistical reports in flat table formats. But today s data warehouses can supply data and in conjunction with other application such as geographic information systems GIS reports can be done in graphical format that shows geographic maps. This...

Modern Relational Database Management Systems can be configured to collect data at certain events.  In a business some of the events are sale order deposit pay request and many more. Events are really business activities in a company.  Big companies in order to gain competitive advantage invest heavily on setting up business data warehouses...

Data Summarization summarizes evaluational data included both primitive and derived data in order to create a derived evaluational data that is general in  nature.  Since the data in the data warehouse is of very high volume there needs to be a mechanism in order to get only the relevant and meaningful information in a less messy format....

Data visualization is intended to provide data consumers with a qualitative understanding of the information contents in an appealing graphical presentation.  Data Visualization involves understanding historical data like relationships patterns and trends and providing visual information to the decision maker. For instance scientist may be...

A data warehouse is a subject-oriented integrated time-variant non-volatile collection of data in support of management s decision making process" . As brief backgrounder a data warehouse is a rich repository of corporate data containing not just historical corporate information which is tightly integrated into the operational database...

Multi-Dimensional Analysis is an Informational Analysis on data which takes into account many different relationships each of which represents a dimension. For example a retail analyst may want to understand the relationships among sales by region by quarter by demographic distribution income education level gender by product. Multi-dimensional...

Multiple Dimension Processing is also referred to as static data analysis because the data values do not change. The role of information in today s business environment has become so tremendous that business organizations can literally not function without it. In fact companies are spending millions of dollars just to implement an enterprise data...

Static Query is a stored parameterized procedure. It is optimized for access to a particular data warehouse.  It can never be denied that the data warehouse is one of the biggest forms of data repository. In fact since a data warehouse contains the business organizations repository of historical data every single day the volume increases...