Operational Database is the database-of-record consisting of system-specific reference data and event data belonging to a transaction-update system. It may also contain system control data such as indicators flags and counters. The operational database is the source of data for the data warehouse. It contains detailed data used to run the day-to-day...

An Operational Data Store ODS is an integrated database of operational data. Its sources include legacy systems and it contains current or near term data. An ODS may contain 30 to 60 days of information while a data warehouse typically contains years of data. An operational data store is basically a database that is used for being an interim area...

On-Line Analytical Processing On-Line Analytical Processing is a processing that supports the analysis of business trends and projections. It is also known as decision support processing and OLAP.  An OLAP software enables companies to have real-time analysis of data stored in a database. An OLAP server is typically a separate component of an...

On-Line Transaction Processing On-Line Transaction Processing is a processing that supports the daily business operations. Also know as operational processing and OLTP.  An OLTP is a database which must typically allow the real-time processing of SQL transactions to support traditional retail processes e-commerce and other time-critical applications....

In the broadest sense of the word aggregation means collecting and combining of data horizontally vertically and chronologically and then expressed in summary form to be used for statistical analysis. In the more technical sense aggregation is a special kind association that specified a part of whole relationship between the component part and the...

Automatic data partitioning is the process of breaking down large chunks of data and metadata at a specific data site into partitions according to the request specification of the client. Data sites contain multitudes of varied data which can be extremely useful as a statistical basis for determining many trends in businesses. Because data in the...

A cache is a type of dynamic and high speed memory that is used to supplement the function of the central processing unit and the physical disk storage. The cache acts as a buffer when the CPU tries to access data from the disk so the data traveling from the CPU and physical disks can have synchronized speed. Disk reading and writing process is generally...

In relational database management system RDBMS terminology Access Path refers to the path chosen by the system to retrieve data after a structured query language SQL request is executed. A query may request at least one variable to be filled up with one value or more. A query may look like this SELECT family_name FROM users WHERE family_name...

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which is predefine and performed routinely. The word Ad...

Data administration refers to the  way in  which data integrity is maintained within data  warehouse. Data warehouses are very large repository of all sorts of data. These data maybe of different formats. To make these data useful to the company the database running the data warehouse has to be configured so that it obeys the business...