A study on designing a Layered Star Schema for data mining optimization

Granularity refers to the level of detail of the data stored fact tables in a data warehouse. All the tools and techniques for Data mining mainly concerned with availability of huge storage of data in Data warehouse. Required relevant information can be derived only after searching and accessing related data items from the Data Warehouse which requires a query cost investment and some time it may return very minimal or even zero valued result. Therefore our proposed Layered Star Schema can help the Data miners to optimize their Data mining model with appropriate dimension before triggering their Data mining application to Data Warehouse.