·         Operational systems – Execution of business process. Also known as Transactional system or OLTP

·         Analytical System – Evaluation of business process. Also known as Data warehouse system or Data Mart

·         Measurements are facts and context of measurement is dimensions.

·         Dimension in speech – FOR , BY

·         Dimension in a report serve as a filter or a query predicate.

·         Facts – Elements that are aggregated summarize or subtotaled are Facts.

·         Star Schema – A dimensional design for relational database is called as Star Schema

·         Surrogate Key – It is a primary key of dimension table

·         Browse queries – It is a query on dimension table only to any level, for example to get distinct records of Products.

·        

·         Data warehouse will describe any solution that contains an analytic database, including stand-alone data marts. This term will not be meant to imply a central or integrated repository.

·         Enterprise data warehouse will be used to refer to the central repository of the Corporate Information Factory. Use of this term is not meant to imply that other data warehouse architectures lack an enterprise focus.

·         Data mart will refer to a subject area in any architecture. Use of this term is not meant to imply departmental focus or the lack of an enterprise context.

·         ETL will refer to any activity that moves information between structured data stores. The use of this term in the generic sense is not intended as a slight to the Corporate Information Factory, where it has a more specific definition.

·         Source system will refer to the computer system(s) from which a star schema gets its data. In the case of a data mart in a Corporate Information Factory, the source system is the enterprise data warehouse. In the case of a star schema in a dimensional data warehouse or stand-alone data mart, the source system is an operational system.

·         Business Intelligence will be used to describe any software product used to create reports and other information products for end users. It is not meant to imply a separate analytic data store, nor the use of any particular form of packaged software.