Abstract
In this paper, we propose a novel database design structure that can deal with all the aspects of the complexity of data that has to be managed, using the concepts of defining objects in object oriented programming (OOP). As well, we create a set of procedures in database system that allows us to manage all type of data, without knowing the structure of the database. The creation of the database structure, also the mechanism of inserting and retrieval the information is made by using a metadata set of information.
The major benefit of the proposed approach is that we can use a relational database management system (RDBMS), that can assure ACID (atomicity, consistency, isolation and durability) principles, low cost management and quick development based on metadata structure. The main advantages of our approach comparing with NoSQL database system is that we preserve ACID properties of the information and comparing with NewSQL is that the cost of the projection of database structure and management of the system is much lower.
Our proposed system is functional and can manage very large amount of data from heterogenic sources that can be managed by companies without a lot of know-how.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Frâncu, V., Sabo, C.: Implementation of a UDC-based multilingual thesaurus in a library catalogue: the case of bibliophil. Knowl. Organ. 37(3), 209–215 (2010)
Carlyle, A.: Understanding FRBR as a conceptual model: FRBR and the bibliographic universe. Libr. Resour. Tech. Serv. 50(4), 264–273 (2006)
Giannopoulou, E., Mitrou, N., Chimos, K., Karvounidis, T., Douligeris, C.: A semantic web approach in the implementation of a linked data portal using a CMS. In: Proceedings of 10th International Conference on Signal-Image Technology and Internet-Based Systems, SITIS, p. 164 (2014)
Agosti, M., Crivellari, F., Di Nunzio, G.M., Gabrielli, S.: Understanding user requirements and preferences for a digital library web portal. Intl. J. Digital Libr. 11(4), 225–238 (2010)
Rokitskii, R.B.: Object-oriented databases with relational DBMSs. Cybern. Syst. Anal. 36(6), 813–822 (2000)
Vysniauskas, E., Nemuraite, L.: Transforming ontology representation from OWL to relational database. Inf. Technol. Control 35(3A), 333–343 (2006)
Frawley, W.J., Piatetsky-Shapiro, G., Matheus, C.J.: Knowledge discovery in databases: an overview. AI Mag. 13(3), 57–70 (1992)
http://www.loc.gov/bibframe/pdf/marcld-report-11-21-2012.pdf
Gartner, R.: An XML schema for enhancing the semantic interoperability of archival description. Arch. Sci. 15(3), 295–313 (2015)
Gardner, J.R.: Information architecture planning with XML. Libr. Hi Tech 19(3), 231–241 (2001)
Cheslow, S.: METS for the cultural heritage community: a literature review. Libr. Philos. Pract. 2014(1) (2014)
Pacheco, K.L., Ortega, C.D.: Model FRBR in origin. Biblios 60, 63–75 (2015)
Lee, C., Zheng, Y.: Automatic SQL-to-NoSQL schema transformation over the MySQL and HBase databases. In: IEEE International Conference on Consumer Electronics - Taiwan, ICCE-TW, pp. 426–427 (2015)
Cavaiani, T.P.: Object-oriented programming principles and the Java class library. J. Inf. Syst. Educ. 17(4), 365 (2006)
SAP AG: Patent issued for systems and methods for generating a common data model for relational and object oriented databases. J. Eng. 3005 (2013)
Holler, J., Tsiatsis, V., Mulligan, C., Avesand, S., Karnouskos, S., Boyle, D.: From Machine-To-Machine to the Internet of Things, pp. 1–331. Academic Press, Cambridge (2014)
Pop, P.C., Matei, O., Sabo, C.: A new approach for solving the generalized traveling salesman problem. In: Blesa, María J., Blum, C., Raidl, G., Roli, A., Sampels, M. (eds.) HM 2010. LNCS, vol. 6373, pp. 62–72. Springer, Heidelberg (2010). doi:10.1007/978-3-642-16054-7_5
Cola, C., Valean, H.: Ambient recognition using BigData model and Arduino controller. In: Proceedings of 2016 IEEE International Conference on Automation, Quality and Testing, Robotics THETA 20th edition, 19–21 May, Cluj-Napoca, Romania (2016). ISBN: 978-1-4673-8691-13
Coltri, A.: Databases in health care. In: Lehman, H.P., Abbott, P.A., Roderer, N.K., et al. (eds.) Aspects of Electronic Health Record Systems, 2nd edn, pp. 225–251. Springer, New York (2006). (Chap. 11)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Sabo, C., Pop, P.C., Vălean, H., Dănciulescu, D. (2017). An Innovative Approach to Manage Heterogeneous Information Using Relational Database Systems. In: Madureira, A., Abraham, A., Gamboa, D., Novais, P. (eds) Intelligent Systems Design and Applications. ISDA 2016. Advances in Intelligent Systems and Computing, vol 557. Springer, Cham. https://doi.org/10.1007/978-3-319-53480-0_1
Download citation
DOI: https://doi.org/10.1007/978-3-319-53480-0_1
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-53479-4
Online ISBN: 978-3-319-53480-0
eBook Packages: EngineeringEngineering (R0)