research-article

Towards a uniform data model in multi-database environments

Authors:

Diego Serrano,

Eleni StrouliaAuthors Info & Claims

CASCON '14: Proceedings of 24th Annual International Conference on Computer Science and Software Engineering

Pages 347 - 350

Published: 03 November 2014 Publication History

Get Access

Abstract

The massive amounts of heterogeneous data available today give rise to numerous opportunities for new services. At the same time, new complex challenges are implied by the volume, velocity and variability of the data at hand. A fundamental conceptual shift facing software architects today is the obsolescence of what used to be called "the data tier", which, in pursuit of performance, has now been fragmented into federations of relational and NoSQL repositories with denormalized and duplicated data. In this paper, we review some of the relevant research and technological background, discuss the challenges associated with a multi-database environment, and put forward a research road-map for creating a common data model to support inter-database consistency, workflow automation, and data management.

References

[1]

P. Atzeni, F. Bugiotti, and L. Rossi. Uniform access to non-relational database systems: The sos platform. In Advanced Information Systems Engineering. Springer Berlin Heidelberg, 2012.

Digital Library

Google Scholar

[2]

O. Curé, R. Hecht, C. Duc, and M. Lamolle. Data integration over nosql stores using access path based mappings. In Proceedings of the 22Nd International Conference on Database and Expert Systems Applications - Volume Part I, 2011.

Digital Library

Google Scholar

[3]

O. Curé, F. Kerdjoudj, Chan Le Duc, M. Lamolle, and D. Faye. On the potential integration of an ontology-based data access approach in nosql stores. In Emerging Intelligent Data and Web Technologies (EIDWT), 2012 Third International Conference on, 2012.

Digital Library

Google Scholar

[4]

Apache Hive. Hcatalog. https://cwiki.apache.org/confluence/display/Hive/HCatalog, April 2014.

Google Scholar

[5]

R. Lawrence. Integration and virtualization of relational sql and nosql systems including mysql and mongodb. In Computational Science and Computational Intelligence (CSCI), 2014 International Conference on, 2014.

Digital Library

Google Scholar

[6]

AO. Mendelzon, G. A Mihaila, and T. Milo. Querying the world wide web. In Parallel and Distributed Information Systems, 1996., Fourth International Conference on, 1996.

Digital Library

Google Scholar

[7]

OASIS. Odata. http://www.odata.org/, 2014.

Google Scholar

[8]

K. Ong, Y. Papakonstantinou, and R. Vernoux. The sql++ semi-structured data model and query language: A capabilities survey of sql-on-hadoop, nosql and newsql databases. CoRR, abs/1405.3631, 2014.

Google Scholar

[9]

D. Serrano, E. Stroulia, D. Barbosa, and V. Guana. Sociql: A query language for the socialweb. In Advances in Network Analysis and its Applications. Springer Berlin Heidelberg, 2013.

Google Scholar

[10]

H. Zhang, Y. Wang, and J. Han. Middleware design for integrating relational database and nosql based on data dictionary. In Transportation, Mechanical, and Electrical Engineering (TMEEx), 2011 International Conference on, pages 1469--1472, Dec 2011.

Google Scholar

Recommendations

Uniform data access platform for SQL and NoSQL database systems

A novel metamodel-based data integration approach is proposed, which allows to query data from heterogeneous (relational and NoSQL) database systems simultaneously.The presented method cover structural, semantic and syntactic heterogeneities of source ...
Towards the Maturity of Object-Relational Database Technology: Promises and Reality

Object-relational technology provides a significant increase in scalability and flexibility over the traditional relational databases. The additional object-relational features are particularly satisfying for advanced database applications that ...
Towards NoSQL-based Data Warehouse Solutions

Data warehousing is a traditional domain of relational databases, and there are two main reasons for that: (1) data warehouses mostly are used in enterprises with large-scale data sets created in different legacy systems with relational data storages, (...

Comments

Information & Contributors

Information

Published In

CASCON '14: Proceedings of 24th Annual International Conference on Computer Science and Software Engineering

November 2014

399 pages

Conference Chair:
Joanna Ng
CAS Research, IBM Canada Software Lab
,
Program Chairs:
Jin Li
IBM Canada Software Lab
,
Ken Wong
University of Alberta

Publisher

IBM Corp.

United States

Publication History

Published: 03 November 2014

Qualifiers

Research-article

Acceptance Rates

Overall Acceptance Rate 24 of 90 submissions, 27%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

0
Total Citations
50
Total Downloads

Downloads (Last 12 months)1
Downloads (Last 6 weeks)0

Reflects downloads up to 07 Nov 2024

Other Metrics

View Author Metrics

Citations

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Recommendations

Uniform data access platform for SQL and NoSQL database systems

Towards the Maturity of Object-Relational Database Technology: Promises and Reality

Towards NoSQL-based Data Warehouse Solutions

Comments

Published In

Sponsors

Publisher

Publication History

Qualifiers

Acceptance Rates

Other Metrics

Article Metrics

Other Metrics

Login options

Full Access

PDF

eReader

Abstract

References

Recommendations

Uniform data access platform for SQL and NoSQL database systems

Towards the Maturity of Object-Relational Database Technology: Promises and Reality

Towards NoSQL-based Data Warehouse Solutions

Comments

Information

Published In

Sponsors

Publisher

Publication History

Qualifiers

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Get Access

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations