期刊名称：International Journal of Innovative Research in Computer and Communication Engineering
印刷版ISSN：2320-9798
电子版ISSN：2320-9801
出版年度：2017
卷号：5
期号：1
页码：279
DOI：10.15680/IJIRCCE.2017.0501041
出版社：S&S Publications
摘要：Success of any Decision Support System (DSS) depends on the Data Warehouse (DW). Importantresults have been produced in the field of DW by the temporal database research. DW store data of historicalimportance, and hence could be clearly beneficial from this research. Temporal data warehouse combines two areas oftemporal database research and data warehouse. The multidimensional Bitemporal relational database generates objectsand cubes of DW. With the help of set of queries, the performances of the relational database and the Bitemporaldatabase are compared and evaluated in terms of the size or disk space consumption and execution time. The ideaproposed in this system is to perform an analysis on the relational and Bitemporal extension of the database on the basisof time required to perform queries and the size of the database. Based on the analysis, it is easier to understand thenature of the traditional and Bitemporal database. In the proposed work, we have developed a system which will beuseful for comparing the relational and Bitemporal databases and optimizing the performance of these databases byquery optimization. The proposed system will also be able to compare four databases at a single time.
关键词：Decision Support System (DSS); Data Warehouse (DW); Temporal database; Bitemporal database;Relational database; Query; Disk space consumption; Execution time; Optimization
