‘Data Model’ Archives
Heterogeneous Databases and Legacy Databases
As we are driven by the goal making information technology understandable by business decision makers and end-users, therefore when ever we find any simple word made unnecessarily technical term, we made best efforts to make them original / understandable. So Legacy database is a group of heterogeneous data bases that combines different kind of [...]
Data mart model and schema another perspective
Due to frequent questions on Data Mart Schema, we are writing more in this respect, A data mart can contain star schemas and other tables. For example, a single data mart might contain data for the following reporting needs of specific business areas like finance, Marketing and human Resources. Typically more database design is conducted when [...]
Metrics and Key Performance Indicators
Metrics is a direct numerical measure of business data in the light of one or more dimensions. For example total sale by week, in that case the sale will be a metric and week is dimension. Key Performance Indicators (KPI): is metric that is related to target. KPI represents how far a metric is above or below a pre-determined target. Key [...]
Difference between MOLAP and ROLAP
MOLAP A data mart is MOLAP data mart in which the data is loaded into data mart in highly structured manner and where dimensions of the data created. Typical dimensions might be product, time and location. There are usually limited number -four to six- of dimensions for a MOLAP data mart. MOLAP data mart has a very high degree of [...]
Slowly Changing Dimension
The "Slowly Changing Dimension" a common problem in data warehousing. Basically, this applies to cases where the attribute for a record varies over time. For Example; George is an employee with XYZ Inc. He first worked at production plant. So, the original entry in the employee lookup table has the following record: Employee ID or Employee [...]
An example of University of Toronto Business Intelligence (UTBI)
This Post is about University of Toronto Business Intelligence (UTBI). University of Toronto Business Intelligence (UTBI) is a service-oriented program focused on empowering the University’s information analysts and decision-makers. We are including this in our website because we found that very help in understanding Data Mart, Data Ware [...]
