March 3, 2012

Review of a research paper “How To Build a High-Performance Data Warehouse”

Review of a research paper “How To Build a High-Performance Data Warehouse” (Download reference research paper) Three ways are highlighted by the author to handle scalability issues and get high performance at low cost: Following three ways highlighted to handle scalability issues and get high performance at low cost: Shared Memory Shared Disk Shared Nothing […]

Critical analysis of Unsupervised Learning methods of Dimensional modeling

Critical analysis of Unsupervised Learning methods of Dimensional modeling Unsupervised learning method for dimensional modeling: Unsupervised learning method will be selected for such situation where you don’t of have the information about data by which you can classify it as FACTS and DIMENSIONS. Even in some cases you can not put any information indirectly and […]

Critical analysis of Supervised Learning methods of Dimensional modeling

Critical analysis of Supervised Learning methods of Dimensional modeling Supervised learning method for dimensional modeling: Supervised learning method is far better flexible and beneficial than unsupervised learning method if the supporting information is available. Because if information if available so we can perform a no. of analysis on it. Benefits: 1- High performance in query […]

Supervised and Unsupervised Learning are used in Dimensional modeling

Supervised and Unsupervised Learning are used in Dimensional modeling Before looking into supervised and unsupervised learning we have to understand that what dimensional modeling is and why is there need of supervised or unsupervised learning so that it can be used in dimensional modeling. Understanding Dimensional Modeling: It is a way of simplifying the entity […]

Improvements suggested for solution proposed in research paper “A Case for Parallelism in Data Warehousing and OLAP”

Improvements suggested for solution proposed in research paper “A Case for Parallelism in Data Warehousing and OLAP” (Download Reference Research Paper) As the solution in research paper is proposed to best fit the situation faced by data warehouses but as it is a proposal so few suggestions can be added to it as below: 1) […]

How the parallel star join works?

How the parallel star join works? (Download Reference Research Paper) Star Join Works Involving: i) JDI (Join DataIndexing) ii) i-th dimension tables iii) Use of conventional relational approach As the situation is a process so described to the point as follows: They proposed and demonstrated the implementation by partitioning the table into sub-tables. For example […]

Approach of parallelism used in Data warehouse and OLAP

Approach of parallelism used in Data warehouse and OLAP (Download Reference Research Paper) Processor grouping is used to divide and allocate queries to run parallel and data is divided an assigned to different processors as well. In fact parallelism is implemented in two phases: i) A processor group partitioning (d+1 groups) ii) A physical data […]