Searching for just a few words should be enough to get started. If you need to make more complex queries, use the tips below to guide you.
Article type: Research Article
Authors: Chaalal, Hichema; * | Travers, Nicolasb | Belbachir, Hafidaa
Affiliations: [a] Université des Sciences et Technologies d’Oran Mohamed Boudiaf, USTO-MB, El M’naouer, Oran Algérie | [b] Léonard de Vinci Pôle Universitaire, Research Center, Paris La Défense, France
Correspondence: [*] Corresponding author: Hichem Chaalal, Université des Sciences et Technologies d’Oran Mohamed Boudiaf, USTO-MB, BP 1505, El M’naouer, Oran Algérie. E-mail: hichem.chaalal.contact@gmail.com.
Abstract: Classical databases represent the traditional DBMS’s and the most widely used DBMS in the world of databases and information systems; they have been regarded as the best systems for managing data. Today with the growth of data for both applications and consumers, and its openness to the public, traditional databases are not able to meet the needs of a large number of applications, including Online Analytical Processing models: OLAP data processing and Business Intelligence analysis. As a result, many dedicated DBMS have emerged like: Column Store, In Memory and NoSQL databases. They meet users’ expectations and fit well with current needs. Consequently, the scope of classical databases has become increasingly restricted to handle Online Transaction Processing OLTP models and small problems. However, those dedicated solutions hardly cope with rich features of DBMS like simplicity, flexibility or scalability. They remain limited to mainly process single database models, and users cannot deal with both OLTP and OLAP queries in a single environment. To deal with this problem, vertical fragmentation is the best way to effectively handle the OLAP model, but this technique fails to handle some analytical queries with low selectivity, presenting poor results in some cases. In this perspective, we propose a new vertical fragmentation design T-Plotter which makes it possible to deal effectively with the whole of analytical queries and improve the performance of DBMS’s to process the OLAP data models.
Keywords: OLAP databases, OLTP databases, vertical fragmentation, physical design, TPCH benchmark
DOI: 10.3233/MGS-190311
Journal: Multiagent and Grid Systems, vol. 15, no. 3, pp. 237-257, 2019
IOS Press, Inc.
6751 Tepper Drive
Clifton, VA 20124
USA
Tel: +1 703 830 6300
Fax: +1 703 830 2300
sales@iospress.com
For editorial issues, like the status of your submitted paper or proposals, write to editorial@iospress.nl
IOS Press
Nieuwe Hemweg 6B
1013 BG Amsterdam
The Netherlands
Tel: +31 20 688 3355
Fax: +31 20 687 0091
info@iospress.nl
For editorial issues, permissions, book requests, submissions and proceedings, contact the Amsterdam office info@iospress.nl
Inspirees International (China Office)
Ciyunsi Beili 207(CapitaLand), Bld 1, 7-901
100025, Beijing
China
Free service line: 400 661 8717
Fax: +86 10 8446 7947
china@iospress.cn
For editorial issues, like the status of your submitted paper or proposals, write to editorial@iospress.nl
如果您在出版方面需要帮助或有任何建, 件至: editorial@iospress.nl