International Journal of Computer Applications |
Foundation of Computer Science (FCS), NY, USA |
Volume 60 - Number 13 |
Year of Publication: 2012 |
Authors: Asiya Abdus Salam Qureshi, Syed Muhammad Khalid Jamal |
10.5120/9750-3582 |
Asiya Abdus Salam Qureshi, Syed Muhammad Khalid Jamal . Taxonomy based Data Marts. International Journal of Computer Applications. 60, 13 ( December 2012), 6-12. DOI=10.5120/9750-3582
The aim of this paper is to depict new approach called taxonomy based data marts which add a new layer for the categorization of the queries using data warehouse which is the database that contains data relevant to an organization information and respond quickly to multi dimensional analytical queries. The new algorithm is introduced here for more precise results and time saving consumption using data marts which collects data for specific set of users or knowledge workers. Data warehouses often adopt a three-tier architecture. The bottom tier is a warehouse database server, which is typically a relational database system. The middle tier is an OLAP server, and the top tier is a client that contains query and reporting tools. Another new layer is added for faster results. This is done with the help of query classification technique.