It would not be hard to imagine how a daunting the task would of wanting to retrieve a data from the vast repository of data inside the data warehouse. The data warehouse is the main repository of all company data including historical data which may include those from several years past and the current transactional data which are being used in the...
Spatial data is about information that has several dimensions. It is sometimes referred to as aspatial data. It includes both geospatial data and structo-spatial data. It is all about information wherein location is of some benefit or importance although is not always about location on the planet s surface but in other entities as well like the body...
Also known as a primary keyword or a unique identifier a primary key is key used in a relational database which uniquely represents each record. It is a set of one or more data characteristics and its value uniquely identifies each data occurrence in a data subject.  It can be any unique identifier in a database table s records such a driver s...
An enterprise data management system that consists of data stores and data warehouse may have several data sources. Primary Data Source is the first data site at which the original data is stored after their origination. Imagine the data warehouse whose database is the repository of all of the company s historical data. The data warehouse is the...
Optimized data are essential to an efficient running maintenance and management of a data warehouse in particular and an information system of a company in general.  Optimized Data are data in the logical schema and conceptual schema that have been through data optimization.  Although optimized data may come from different IT considerations...
Normalized Data is the data in the data view schema and the external schema which have gone through data normalization. Maintaining a data warehouse means dealing with millions of data as the data warehouse itself is the main repository of a company s historical data or its corporate memory. Thus data should be well managed and one of the ways to...
A data warehouse is a repository of a business organization s historical data.  It is a large part of an enterprise data management system which consists of several servers running on different kinds of platforms and database management systems. It is generally practiced that in an enterprise data management system it is the data warehouse house...
An intelligent agent is a sub-system of the artificial intelligence but with a lot less functionalities and intelligence" . An intelligent agent is simple a software tool designed to assist end users in performing non-repetitive task related to computing processes. The intelligent part is that it can act on its behalf when configured to respond...
Integrated Operational Data also known as operational data stores is a volatile collection of data that support an organization’ s daily business activities. Integrated Operational Data are the output of the operational data store. An operational data store is an architectural construct which is part of the larger enterprise data management...
A data warehouse is a business organization s corporate memory or the main repository of historical data and it typically contains all the raw materials from the decision support system of the management. The data from the data warehouse are being used by the business intelligence system as on of the main bases for company decisions and that the...
Database reverse engineering is an important process in improving the understanding of data semantics. Many aspects of the database evolution especially those that pertain to old and legacy databases where the semantics of their data have been lost through the years need a database reverse engineering process to understood in detail. Today there...
Redundant Data as the name suggests is data duplication.  It means same data of a single organization is stored at multiple data sites. Dealing with redundantly data means that a company has to spend a lot of time money and energy. Since as mentioned these redundant data are unknown to the organization they can crawl into the system and...
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...
Massive Parallel Processing MPP is the shared nothing” approach of parallel computing. It is a type of computing wherein the process is being done by many CPUs working in parallel to execute a single program. One of the most significant differences between a Symmetric Multi-Processing or SMP and Massive Parallel Processing is that...
A primary is one of the most important aspects of a database implementation and its function is mainly to make records in the database table unique to avoid redundancy. Primary keys are generally used in the design and implementation of relational database systems.  The primary key which is often called a unique key is a candidate key a key...
In Lightly Summarized Data the evaluational data is summarized by removing one or a few data characteristic from the primary key of the data focus. Any company implementing a data warehouse is investing in large amount of money in the hope of getting relevant information that will help the company come up with very sound decisions to give them...
Multi-Dimensional Database is a database which has been constructed with the multiple dimensions pre-filled in hyper dimensional cubes” of data rather than the traditional two dimensional tables of Relational Databases. It is also a database concept designed for decision support systems in which related data is stored in multidimensional...
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...
Data warehouse implementation although basically the similar in that is based on certain data architecture and data models also has several differences brought about the differences in hardware and software platforms which are hosting the databases. In a data warehouse specially the very large ones there are various data sources. Big companies typically...