Home // ICIW 2016, The Eleventh International Conference on Internet and Web Applications and Services // View article

A Logical Design Process for Columnar Databases

Authors:
João Paulo Poffo
Ronaldo dos Santos Mello

Keywords: database design; logical design; nosql; columnar database.

Abstract:
Emerging technologies often break paradigms. NoSQL is one of them and is gaining space with the raising of Big Data, where the data volume exceeded the petabyte frontier and the information within these data can be of great importance to strategic decisions. In this case, legacy relational databases show themselves inadequate to efficiently manage these data and, consequently, their traditional project methodologies should must be reviewed to be suitable to new data models, such as the NoSQL columnar model. Regarding columnar database design, the literature lacks of methodologies for logical design, i.e., processes that convert a conceptual schema to a logical schema that optimize access and storage. Thus, this work proposes an approach for logical design of columnar databases that contributes to fill the void between classic project methodologies and the technological forefront with the NoSQL movement, in particular, columnar databases. Preliminary experiments had demonstrated that the methodology is promising, if compared with a baseline.

Pages: 29 to 38

Copyright: Copyright (c) IARIA, 2016

Publication date: May 22, 2016

Published in: conference

ISSN: 2308-3972

ISBN: 978-1-61208-474-9

Location: Valencia, Spain

Dates: from May 22, 2016 to May 26, 2016