SQL

Filters

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 al...

Spatial Data

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 whe...

Primary Key

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 i...

Primary Data Source

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 aft...

Optimized Data

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 ...

Normalized Data

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 wa...

Intuitive Data Warehouse

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 diffe...

Intelligent Agent

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...

Integrated Operational Data

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 ...

Mini Marts

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 ...