Title :
A study on designing a Layered Star Schema for data mining optimization
Author :
Shams Raza, Md. ; Nayak, A.K.
Author_Institution :
Dept. of CSE, NIT, Patna, India
Abstract :
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.
Keywords :
data mining; data warehouses; optimisation; query processing; data items; data mining application; data mining model; data mining optimization; data warehouse; granularity; layered star schema; query cost investment; Abstracts; Context; Data mining; Data warehouses; Databases; Lead; DM; DWH; Dimension Table; Fact Table; Granularity; Granularity Table; Layered Schema; OLTP; Star-schema;
Conference_Titel :
IT in Business, Industry and Government (CSIBIG), 2014 Conference on
Print_ISBN :
978-1-4799-3063-0
DOI :
10.1109/CSIBIG.2014.7056948
