What is Data Compression
Data Compression Data Compression is a method using which the storage space required for storing data is reduced with the help of mathematical techniques. Data compression is also referred to as sou...
Data Warehouse Basics
What is Data Completeness
In any data resource, it is essential to meet requirements of current as well as future demand for information. Data completeness assures that the above criterion is fulfilled. Data completeness ref...
What is Data Collection Frequency
What is Data Collection Frequency Data Collection Frequency, just as the name suggests refers to the time frequency at which data is collected at regular intervals. This often refers to whatever time...
What is Data Aggregation
Reporting and data analysis applications that work closely to tie together company data users and data warehouses need to overcome problem on database performance. Every single day, the amount data c...
What is Data Administration
Data administration refers to the processes and procedures by which the integrity and currency of the data in the warehouse are maintained. Data warehouses are very large repository of all sorts of ...
What is an Ad Hoc Query
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...
What is Access Path
Access Path 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 execu...
What is Cache
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 ...
Automatic Data Partitioning
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.
What is Aggregation
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 analys...