Review
BibTex RIS Cite

An in-depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling

Year 2025, Volume: 38 Issue: 2, 706 - 729, 01.06.2025

Ahmet Arif Aydın

https://doi.org/10.35378/gujs.1467890

Abstract

Data is a crucial asset in the current era of big data. Organizations collect, store, and analyze data at different scales, velocities, types, and structures to aid their decision-making. Database management systems (DBMS) also play a key role in properly storing large amounts of data. Understanding data models and selecting the appropriate database are essential for achieving scalable storage and efficient query performance. The motivation and main purposes behind this work are to present important characteristics of prominent logical models of data storage systems in one place in order to accomplish the following goals: First, providing a detailed guide on logical data models of DBMS, starting from legacy ones to modern contemporary systems, all in one place; secondly, presenting a consolidated and comparative overview of the characteristics of logical data models for researchers, database designers, and developers of data-intensive systems to guide them in selecting the appropriate data storage system for data modeling tasks; and lastly, presenting an overview of popular data storage systems and their data models to illustrate current trends in DBMS.

Keywords

Data Models Data Modeling Data Storage Systems Information Systems NoSQL

References

  • [1] Yaqoob, I., Hashem, I.A.T., Gani, A., Mokhtar, S., Ahmed, E., Anuar, N.B., and Vasilakos, A. v., “Big data: From beginning to future”, International Journal of Information Management, 36: 1231–1247, (2016). DOI: https://doi.org/10.1016/j.ijinfomgt.2016.07.009
  • [2] https://www.domo.com/learn/infographic/data-never-sleeps-9, Access date: 29.07.2024
  • [3] Oussous, A., Benjelloun, F.Z., Ait Lahcen, A., and Belfkih, S., “Big Data technologies: A survey”, Journal of King Saud University - Computer and Information Sciences, 30: 431–448, (2018). DOI: https://doi.org/10.1016/j.jksuci.2017.06.001
  • [4] Han, H., Yonggang, W., Tat-Seng, C., and Xuelong, L., “Toward Scalable Systems for Big Data Analytics: A Technology Tutorial”, IEEE Access, 2: 652–687, (2014). DOI: https://doi.org/0.1109/ACCESS.2014.2332453
  • [5] Zhu, L., Bass, L., and Xu, X., “Data management requirements for a knowledge discovery platform”, ACM International Conference Proceeding Series, 169–172, (2012). DOI: https://doi.org/10.1145/2361999.2362036
  • [6] Aydin, A.A., “A Comparative Perspective on Technologies of Big Data Value Chain”, IEEE Access, 11: 112133–112146, (2023). DOI: https://doi.org/10.1109/ACCESS.2023.3323160
  • [7] https://db-engines.com/en/, Access date: 28.07.2024
  • [8] Kerpelman, C., Olle, T.W., Everest, G.C., Fry, J.P., Fuller, M.E., Hawes, M.K., Kay, A.J., Lefkovits, H.C., Systems, H.I., Mcgee, W.C., Metaxides, A., Laboratories, B.T., Olson, R.M., Corporation, C.D., Rich, M., Mathematics, E., Schubert, R.F., Chemical, B.F.G., Sibley, E.H., Stieger, W.H., Brass, C., Vorhaus, A.H., Weinert, A.E., Command, N., Support, and S., Young, J.W. “Introduction to " Feature Analysis of Generalized Data Base Management Systems ", Communications of the ACM, 14, (1971).
  • [9] Aydin, A.A., Anderson, K.M., “Data modelling for large-scale social media analytics: design challenges and lessons learned”, International Journal of Data Mining, Modelling and Management, 12: 386-414, (2020). DOI: https://doi.org/10.1504/IJDMMM.2020.111409
  • [10] Tsichritzis, D.C., and Lochovsky, F.H. “Hierarchical Data-Base Management: A Survey”, ACM Computing Surveys (CSUR), 8: 105–123, (1976). DOI: https://doi.org/10.1145/356662.356667
  • [11] Codd, E.F., “Data models in database management”, Proceedings of the 1980 workshop on Data abstraction, databases and conceptual modeling, 112–114. ACM Press, New York, New York, USA, (1980). DOI: https://doi.org/10.1145/800227.806891
  • [12] Codd, E.F., “Relational Database: A Practical Foundation for Productivity”, Communications of the ACM, 25: 109–117, (1982). DOI: https://doi.org/10.1145/358396.358400
  • [13] Dittrich, K.R., “Object-Oriented Database Systems: The Notion and the Issues”, 1986 international workshop on Object-oriented database systems, 3–10, (1991). DOI: https://doi.org/10.1007/978-3-642-84374-7_1
  • [14] Navathe, S.B. “Evolution of data modeling for databases”, Communications of the ACM, 35: 112–123, (1992). DOI: https://doi.org/10.1145/130994.131001
  • [15] Silberschatz, A., Korth, H.F., and Sudarshan, S., “Data Models”, ACM Computing Surveys, 28: 105–108, (1996). DOI: https://doi.org/10.1145/234313.234360
  • [16] Worboys, M.F., “Relational Databases and Beyond”, Geographical Information Systems: Principles, Techniques, Management and Applications, 373–384, (2005).
  • [17] Silberschatz, A., Korth, H., and Sudarshan, S., Database System Concepts, Sixth Edition, Mc Graw Hill, (2011).
  • [18] Ramakrishnan, R., Gehrke, J., Database Management Systems, (2003).
  • [19] Coronel, C., Morris, S., and Rob, P. Database Systems: Design, Implementation, and Management, Ninth Edition, Cengage Learning, (2011).
  • [20] Cattell, R., “Scalable SQL and NoSQL data stores”, ACM SIGMOD Record, 39: 12–27, (2010). DOI: https://doi.org/10.1145/1978915.1978919
  • [21] Codd, E.F., “Relational Data Model of Data for Large Shared Data Banks”, Communications of the ACM, 13: 377–387, (1970). DOI: https://doi.org/10.1007/978-1-4614-8351-9_7
  • [22] Elmasri, R., and Navathe, S.B., Fundamentals of Database Systems, Sixth Edition, (2011).
  • [23] Angles, R., and Gutierrez, C., “Survey of Graph Database Models”, ACM Computing Surveys, 40: 1–39, (2008). DOI: https://doi.org/10.1145/1322432.1322433
  • [24] Ribeiro, A., Silva, A., and da Silva, A.R., “Data Modeling and Data Analytics: A Survey from a Big Data Perspective”, Journal of Software Engineering and Applications, 08: 617–634, (2015). DOI: https://doi.org/10.4236/jsea.2015.812058
  • [25] Hull, R., and King, R., “Semantic Database Modeling: Survey, Applications, and Research Issues”, ACM Computing Surveys (CSUR), 19: 201–260, (1987). DOI: https://doi.org/10.1145/45072.45073
  • [26] Storey, V.C., and Song, I.Y., “Big data technologies and Management: What conceptual modeling can do”, Data & Knowledge Engineering, 108: 50–67, (2017). DOI: https://doi.org/10.1016/j.datak.2017.01.001
  • [27] Bachman, C.W., “Data structure diagrams”, ACM SIGMIS Database, 1: 4–10, (1969). DOI: https://doi.org/10.1145/1017466.1017467
  • [28] Chen, P.P.S., “The Entity-Relationship Model—toward a Unified View of Data”, ACM Transactions on Database Systems (TODS), 1: 9–36, (1976). DOI: https://doi.org/10.1145/320434.320440.
  • [29] Booch, G., “UML in Action”, Communications of the ACM, 42: 26–28, (1999). DOI: https://doi.org/10.1145/317665.317672
  • [30] Vera-Olivera, H., Guo, R., Huacarpuma, R.C., da Silva, A.P.B., Mariano, A.M., and Maristela, H., “Data Modeling and NoSQL Databases-A Systematic Mapping Review”, ACM Computing Surveys, 54: (2021). DOI: https://doi.org/10.1145/3457608
  • [31] Koupil, P., Hricko, S., and Holubová, I. “A universal approach for multi-model schema inference”, Journal of Big Data, 9, (2022). DOI: https://doi.org/10.1186/s40537-022-00645-9
  • [32] Brahmia, Z., Hamrouni, H., and Bouaziz, R., “XML data manipulation in conventional and temporal XML databases: A survey”, Computer Science Review, 36(100231): 1-13, (2020). DOI: https://doi.org/10.1016/j.cosrev.2020.100231
  • [33] Lu, J., and Holubová, I., “Multi-model Databases: A new journey to handle the variety of data”, ACM Computing Surveys, 52: 1-38, (2019). DOI: https://doi.org/10.1145/3323214
  • [34] Liu, Z.H., Lu, J., Gawlick, D., Helskyaho, H., Pogossiants, G., and Wu, Z., “Multi-model Database Management Systems - A Look Forward”, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 16–29, (2019). DOI: https://doi.org/10.1007/978-3-030-14177-6_2
  • [35] Besta, M., Gerstenberger, R., Peter, E., Fischer, M., Podstawski, M., Barthels, C., Alonso, G., and Hoefler, T., “Demystifying Graph Databases: Analysis and Taxonomy of Data Organization, System Designs, and Graph Queries”, (2019). DOI: https://doi.org/https://doi.org/10.48550/arXiv.1910.09017.
  • [36] Chen, J.K., and Lee, W.Z., “An introduction of NoSQL databases based on their categories and application industries”, Algorithms, 12: 1–16, (2019). DOI: https://doi.org/10.3390/a12050106
  • [37] Ali, W., Shafique, M.U., Majeed, M.A., and Raza, A., “Comparison between SQL and NoSQL Databases and Their Relationship with Big Data Analytics”, Asian Journal of Research in Computer Science, 4: 1–10, (2019). DOI: https://doi.org/10.9734/ajrcos/2019/v4i230108
  • [38] Bathla, G., Rani, R., and Aggarwal, H., “Comparative study of NoSQL databases for big data storage”, International Journal of Engineering & Technology, 7: 83-87, (2018). DOI: https://doi.org/10.14419/ijet.v7i2.6.10072
  • [39] Davoudian, A., Chen, L., and Liu, M., “A survey on NoSQL stores”, ACM Computing Surveys, 51: 40: 1-43, (2018). DOI: https://doi.org/10.1145/3158661
  • [40] Corbellini, A., Mateos, C., Zunino, A., Godoy, D., and Schiaffino, S., “Persisting big-data: The NoSQL landscape”, Information Systems, 63: 1–23, (2017). DOI: https://doi.org/10.1016/j.is.2016.07.009
  • [41] Gessert, F., Wingerath, W., Friedrich, S., and Ritter, N., “NoSQL database systems: a survey and decision guidance”, Computer Science - Research and Development, 32:353–365, (2017). DOI: https://doi.org/10.1007/s00450-016-0334-3
  • [42] V, M., “Comparative Study of NoSQL Document, Column Store Databases and Evaluation of Cassandra”, International Journal of Database Management Systems, 6: 11–26, (2014). DOI: https://doi.org/10.5121/ijdms.2014.6402
  • [43] Kaur, K., and Rani, R., “Modeling and Querying Data in NoSQL Databases”, 2013 IEEE International Conference on Big Data, 1–7, IEEE (2013). DOI: https://doi.org/10.1109/BigData.2013.6691765
  • [44] Battersby, S., “How a 3000-year-old code unmasked a stellar cannibal”, NewScientist, (1956). 216: 43–45, (2012). DOI: https://doi.org/10.1016/S0262-4079(12)63205-9
  • [45] Chang, F., Dean, J., Ghemawat, S., Hsieh, W.C., Wallach, D.A., Burrows, M., Chandra, T., Fikes, A., and Gruber, R.E., “Bigtable: A distributed storage system for structured data”, ACM Transactions on Computer Systems, 26: 4: 1-26, (2008). DOI: https://doi.org/10.1145/1365815.1365816
  • [46] Bertino, E., and Guerrini, G., “Object‐Oriented Databases”, Wiley Encyclopedia of Computer Science and Engineering, 1–15. Wiley (2008). DOI: https://doi.org/10.1002/9780470050118.ecse279
  • [47] Zendulka, J., “Object-Relational Modeling in the UML”, Encyclopedia of Database Technologies and Applications, 421–426, IGI Global, (2005). DOI: https://doi.org/10.4018/978-1-59140-560-3.ch071
  • [48] Vianu, V., “A Web odyssey”, ACM SIGMOD Record. 32: 68–77, (2003). DOI: https://doi.org/10.1145/776985.776999
  • [49] Lord, C., Gupta, S., The Evolution of Object Relational Databases, (2002).
  • [50] Salminen, A., and Tompa, F.W., “Requirements for XML Document Database Systems”, Proceedings of the ACM Symposium on Document Engineering, 85–94, (2001). DOI: https://doi.org/10.1145/502200.502201
  • [51] Wuwongse, V., Anutariya, C., Akama, K., and Nantajeewarawat, E., “A Data Model for XML Databases”, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 237–246, (2001). DOI: https://doi.org/10.1007/3-540-45490-X_28
  • [52] Zand, M., Collins, V., and Caviness, D., “A Survey of Current Object-Oriented Databases”, ACM SIGMIS Database, 26: 14–29, (1995). DOI: https://doi.org/10.1145/206476.206480.
  • [53] Cattell, R.G.G. Object Data Management: Object-Oriented and Extended Relational Database Systems, (1991).
  • [54] Stonebraker, M., Rowe, L.A., Lindsay, B.G., Gray, J., Carey, M.J., Brodie, M.L., Bernstein, P.A., and Beech, D., “Third-generation database system manifesto”, ACM SIGMOD Record, 19: 31–44, (1990). DOI: https://doi.org/10.1145/101077.390001
  • [55] Bancilhon, F., and Kim, W., “Object-Oriented Database Systems: In Transition”, ACM SIGMOD Record, 19: 49–53, (1990). DOI: https://doi.org/10.1145/122058.122063
  • [56] Kim, W., “Object-oriented databases: definition and research directions”, IEEE Transactions on Knowledge and Data Engineering, 2: 327–341, (1990). DOI: https://doi.org/10.1109/69.60796
  • [57] Schek, H.-J., and Scholl, M.H., “Evolution of data models”, Presented at the (1990). DOI: https://doi.org/10.1007/3-540-53397-4_35
  • [58] Bancilhon, F., and Kim, W., “Object-oriented database systems”, ACM SIGMOD Record, 19: 49–53, (1990). DOI: https://doi.org/10.1145/122058.122063
  • [59] Heiler, S., Dayal, U., Orenstein, J., and Radke-Sproull, S., “An object-oriented approach to data management: why design databases need it”, 24th ACM/IEEE conference proceedings on Design automation conference - DAC ’87, 335–340. ACM Press, New York, New York, USA, (1987).
  • [60] Fry, J.P., Sibley, E.H., “Evolution of Data-Base Management Systems”, ACM Computing Surveys (CSUR). 8:7–42, (1976). DOI: https://doi.org/10.1145/356662.356664
  • [61] Curtice, R.M., “Data base design using a codasyl system”, Proceedings of the 1974 annual ACM conference, 473–480, (1974).
  • [62] North, K., Database Systems: The First Generation, World Wide Web Internet And Web Information Systems, (1986).
  • [63] https://www.ibm.com/products/ims, Access Date: 17.04.2024.
  • [64] Taylor, R.W., and Frank, R.L., “CODASYL Data-Base management systems”, Computing Surveys, 8: 67–103, (1976). DOI: https://doi.org/10.11499/sicejl1962.19.206
  • [65] CODASYL Data Description Committe, “CODASYL Data Description Language”, Journal of Development, 155, (1974).
  • [66] Elmasri, R., and Navathe, S.B., Appendix E: An overview of Network Data Model. In: Fundementals of Database Systems 6th Edition, 1–24, (2010).
  • [67] Brown, A.S., Hirata, T.M., Koehler, A.M., Vishwanath, K., Ng, J., Pechulis, M.J., Sikes, M.A., Singleton, D.E., and Veazey, J.E., “Data Base Management for Hp Precision Architecture Computers”, Hewlett-Packard Journal, 37: 34–48, (1986).
  • [68] Codd, E.F., “Extending the Database Relational Model to Capture More Meaning”, ACM Transactions on Database Systems (TODS), 4: 397–434, (1979). DOI: https://doi.org/10.1145/320107.320109
  • [69] Stonebraker, M., and Kemnitz, G., “The POSTGRES next generation database management system”, Communications of the ACM, 34: 78–92, (1991). DOI: https://doi.org/10.1145/125223.125262.
  • [70] Ketabchi, M.A., “Object-Oriented Data Models and Management of CAD Databases”, IEEE, 123–128, (1986).
  • [71] Bertino, E., and Martino, L., “Object-Oriented Database Management Systems: Concepts and Issues”, Computer (Long Beach Calif), 24: 33–47, (1991). DOI: https://doi.org/10.1109/2.76261.
  • [72] Atkinson, M., DeWitt, D., Maier, D., Bancilhon, F., Dittrich, K., and Zdonik, S., “The Object-Oriented Database System Manifesto”, Building an Object-oriented Database System: The Story of O2, 1–17, Morgan Kaufmann Publishers Inc., (1992). DOI: https://doi.org/10.1016/b978-0-444-88433-6.50020-4.
  • [73] Schewe, K.D., and Thalheim, B., “Fundamental concepts of object oriented databases”, Acta Cybernetica, 11: 49–83, (1993).
  • [74] Vossen, G., “On formal models for object-oriented databases”, ACM SIGPLAN OOPS Messenger, 6: 1–19, (1995). DOI: https://doi.org/10.1145/219260.219262.
  • [75] Hui, S.C., Goh, A., and Raphel, J.K., “Data modeling using an object-oriented logic language”, Proceedings of IEEE Singapore International Conference on Networks/International Conference on Information Engineering: Communications and Networks for the Year 2000, SICON 1993, 2: 744–748, (1993).
  • [76] Yan, L., Ma, Z.M., and Zhang, F., “Algebraic operations in fuzzy object-oriented databases”, Information Systems Frontiers, 16: 543–556, (2014). DOI: https://doi.org/10.1007/s10796-012-9359-8.
  • [77] Alzahrani, H. “Evolution of Object-Oriented Database Systems”, Global Journal of Computer Science and Technology, 16: 33–36, (2016).
  • [78] Urban, S.D., and Dietrich, S.W., “Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappings”, SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education). 21–25, (2003). DOI: https://doi.org/10.1145/792548.611923.
  • [79] https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a76976/toc.htm, Access date: 16.07.2024.
  • [80] Dietrich, S.W., and Urban, S.D., Fundamentals of Object Databases: Object-Oriented and Object-Relational Design, (2010).
  • [81] https://www.w3.org/TR/2008/REC-xml-20081126/, Access date: 17.04.2024.
  • [82] https://www.w3.org/XML/Datamodel.html, Access date: 16.04.2024.
  • [83] Seligman, L., and Roenthal, A., “XML’s impact an databases and data sharing”, Computer (Long Beach Calif), 34: 59–67, (2001). DOI: https://doi.org/10.1109/2.928623.
  • [84] Steegmans, B., Bourret, R., Cline, O., Guyennet, O., Kulkarni, S., Priestly, S., Sylenko, V., and Wahli, U., XML for DB2 Information Integration, (2004).
  • [85] http://www.rpbourret.com/xml/XMLDatabaseProds.htm#xmlenabled, Access date: 17.04.2024.
  • [86] https://www.w3.org/TR/rdf-concepts/, Access date: 17.04.2024.
  • [87] Ramzan, S., Bajwa, I.S., Kazmi, R., Amna, “Challenges in NoSQL-based distributed data storage: A systematic literature review”, Electronics (Switzerland). 8: 1-29, (2019). DOI: https://doi.org/10.3390/electronics8050488.
  • [88] https://redis.io/, Access date: 17.04.2024.
  • [89] Hashem, H., and Ranc, D., “Evaluating NoSQL document oriented data model”, Proceedings - 2016 4th International Conference on Future Internet of Things and Cloud Workshops, W-FiCloud 2016, 51–56, (2016).
  • [90] https://www.json.org/json-en.html, Access date: 16.04.2024.
  • [91] https://www.mongodb.com/, Access date: 16.03.2024.
  • [92] Aydin, A.A., “Incremental Data Collection & Analytics the Design of Next-Generation Crisis Informatics Software”, PhD Thesis, University of Colorado Boulder, Boulder, USA, (2016).
  • [93] https://cassandra.apache.org/_/index.html, Access date: 16.03.2024.
  • [94] https://neo4j.com/, Access date: 16.03.2024.
  • [95] https://www.broadcom.com/products/mainframe/databases-database-mgmt/idms, Access date: 16.03.2024.
  • [96] https://developer.imdb.com/non-commercial-datasets/, Access date: 29.07.2024.
  • [97] https://ignitetech.ai/softwarelibrary/objectstore, Access date: 29.07.2024.
  • [98] Ryan, J., Big Data Velocity in Plain English, (2019).
  • [99] Chaudhry, N., Yousaf, M.M.: Architectural assessment of NoSQL and NewSQL systems. Distributed and Parallel Databases, 38: 881–926, (2020). DOI: https://doi.org/10.1007/s10619-020-07310-1
  • [100] Ryan, J.: Oracle vs. NoSQL vs. NewSQL Comparing Database Technology. (2018).
  • [101] Truică, C.O., Apostol, E.S., Darmont, J., and Pedersen, T.B., “The Forgotten Document-Oriented Database Management Systems: An Overview and Benchmark of Native XML DODBMSes in Comparison with JSON DODBMSes”, Big Data Research, 25, (2021). DOI: https://doi.org/10.1016/j.bdr.2021.100205
  • [102] Lourenço, J.R., Cabral, B., Carreiro, P., Vieira, M., and Bernardino, J., “Choosing the right NoSQL database for the job: a quality attribute evaluation”, Journal of Big Data, 2 (18): 1-26, (2015). DOI: https://doi.org/10.1186/s40537-015-0025-0.
  • [103] Kekevi, U., and Aydin, A.A., “Real-Time Big Data Processing and Analytics: Concepts, Technologies, and Domains”, Computer Science, 7 (2): 111–123, (2022). DOI: https://doi.org/10.53070/bbd.1204112.
  • [104] Srivastava, K., and Shekokar, N., “A Polyglot Persistence approach for E-Commerce business model”, Proceedings - 2016 International Conference on Information Science, ICIS 2016, 7–11, (2017).
  • [105] Schram, A., and Anderson, K.M., “MySQL to NoSQL Data Modeling Challenges in Supporting Scalability”, Proceedings of the 3rd annual conference on Systems, programming, and applications: software for humanity - SPLASH ’12, 191–202, (2012).

Year 2025, Volume: 38 Issue: 2, 706 - 729, 01.06.2025

Ahmet Arif Aydın

https://doi.org/10.35378/gujs.1467890

Abstract

References

  • [1] Yaqoob, I., Hashem, I.A.T., Gani, A., Mokhtar, S., Ahmed, E., Anuar, N.B., and Vasilakos, A. v., “Big data: From beginning to future”, International Journal of Information Management, 36: 1231–1247, (2016). DOI: https://doi.org/10.1016/j.ijinfomgt.2016.07.009
  • [2] https://www.domo.com/learn/infographic/data-never-sleeps-9, Access date: 29.07.2024
  • [3] Oussous, A., Benjelloun, F.Z., Ait Lahcen, A., and Belfkih, S., “Big Data technologies: A survey”, Journal of King Saud University - Computer and Information Sciences, 30: 431–448, (2018). DOI: https://doi.org/10.1016/j.jksuci.2017.06.001
  • [4] Han, H., Yonggang, W., Tat-Seng, C., and Xuelong, L., “Toward Scalable Systems for Big Data Analytics: A Technology Tutorial”, IEEE Access, 2: 652–687, (2014). DOI: https://doi.org/0.1109/ACCESS.2014.2332453
  • [5] Zhu, L., Bass, L., and Xu, X., “Data management requirements for a knowledge discovery platform”, ACM International Conference Proceeding Series, 169–172, (2012). DOI: https://doi.org/10.1145/2361999.2362036
  • [6] Aydin, A.A., “A Comparative Perspective on Technologies of Big Data Value Chain”, IEEE Access, 11: 112133–112146, (2023). DOI: https://doi.org/10.1109/ACCESS.2023.3323160
  • [7] https://db-engines.com/en/, Access date: 28.07.2024
  • [8] Kerpelman, C., Olle, T.W., Everest, G.C., Fry, J.P., Fuller, M.E., Hawes, M.K., Kay, A.J., Lefkovits, H.C., Systems, H.I., Mcgee, W.C., Metaxides, A., Laboratories, B.T., Olson, R.M., Corporation, C.D., Rich, M., Mathematics, E., Schubert, R.F., Chemical, B.F.G., Sibley, E.H., Stieger, W.H., Brass, C., Vorhaus, A.H., Weinert, A.E., Command, N., Support, and S., Young, J.W. “Introduction to " Feature Analysis of Generalized Data Base Management Systems ", Communications of the ACM, 14, (1971).
  • [9] Aydin, A.A., Anderson, K.M., “Data modelling for large-scale social media analytics: design challenges and lessons learned”, International Journal of Data Mining, Modelling and Management, 12: 386-414, (2020). DOI: https://doi.org/10.1504/IJDMMM.2020.111409
  • [10] Tsichritzis, D.C., and Lochovsky, F.H. “Hierarchical Data-Base Management: A Survey”, ACM Computing Surveys (CSUR), 8: 105–123, (1976). DOI: https://doi.org/10.1145/356662.356667
  • [11] Codd, E.F., “Data models in database management”, Proceedings of the 1980 workshop on Data abstraction, databases and conceptual modeling, 112–114. ACM Press, New York, New York, USA, (1980). DOI: https://doi.org/10.1145/800227.806891
  • [12] Codd, E.F., “Relational Database: A Practical Foundation for Productivity”, Communications of the ACM, 25: 109–117, (1982). DOI: https://doi.org/10.1145/358396.358400
  • [13] Dittrich, K.R., “Object-Oriented Database Systems: The Notion and the Issues”, 1986 international workshop on Object-oriented database systems, 3–10, (1991). DOI: https://doi.org/10.1007/978-3-642-84374-7_1
  • [14] Navathe, S.B. “Evolution of data modeling for databases”, Communications of the ACM, 35: 112–123, (1992). DOI: https://doi.org/10.1145/130994.131001
  • [15] Silberschatz, A., Korth, H.F., and Sudarshan, S., “Data Models”, ACM Computing Surveys, 28: 105–108, (1996). DOI: https://doi.org/10.1145/234313.234360
  • [16] Worboys, M.F., “Relational Databases and Beyond”, Geographical Information Systems: Principles, Techniques, Management and Applications, 373–384, (2005).
  • [17] Silberschatz, A., Korth, H., and Sudarshan, S., Database System Concepts, Sixth Edition, Mc Graw Hill, (2011).
  • [18] Ramakrishnan, R., Gehrke, J., Database Management Systems, (2003).
  • [19] Coronel, C., Morris, S., and Rob, P. Database Systems: Design, Implementation, and Management, Ninth Edition, Cengage Learning, (2011).
  • [20] Cattell, R., “Scalable SQL and NoSQL data stores”, ACM SIGMOD Record, 39: 12–27, (2010). DOI: https://doi.org/10.1145/1978915.1978919
  • [21] Codd, E.F., “Relational Data Model of Data for Large Shared Data Banks”, Communications of the ACM, 13: 377–387, (1970). DOI: https://doi.org/10.1007/978-1-4614-8351-9_7
  • [22] Elmasri, R., and Navathe, S.B., Fundamentals of Database Systems, Sixth Edition, (2011).
  • [23] Angles, R., and Gutierrez, C., “Survey of Graph Database Models”, ACM Computing Surveys, 40: 1–39, (2008). DOI: https://doi.org/10.1145/1322432.1322433
  • [24] Ribeiro, A., Silva, A., and da Silva, A.R., “Data Modeling and Data Analytics: A Survey from a Big Data Perspective”, Journal of Software Engineering and Applications, 08: 617–634, (2015). DOI: https://doi.org/10.4236/jsea.2015.812058
  • [25] Hull, R., and King, R., “Semantic Database Modeling: Survey, Applications, and Research Issues”, ACM Computing Surveys (CSUR), 19: 201–260, (1987). DOI: https://doi.org/10.1145/45072.45073
  • [26] Storey, V.C., and Song, I.Y., “Big data technologies and Management: What conceptual modeling can do”, Data & Knowledge Engineering, 108: 50–67, (2017). DOI: https://doi.org/10.1016/j.datak.2017.01.001
  • [27] Bachman, C.W., “Data structure diagrams”, ACM SIGMIS Database, 1: 4–10, (1969). DOI: https://doi.org/10.1145/1017466.1017467
  • [28] Chen, P.P.S., “The Entity-Relationship Model—toward a Unified View of Data”, ACM Transactions on Database Systems (TODS), 1: 9–36, (1976). DOI: https://doi.org/10.1145/320434.320440.
  • [29] Booch, G., “UML in Action”, Communications of the ACM, 42: 26–28, (1999). DOI: https://doi.org/10.1145/317665.317672
  • [30] Vera-Olivera, H., Guo, R., Huacarpuma, R.C., da Silva, A.P.B., Mariano, A.M., and Maristela, H., “Data Modeling and NoSQL Databases-A Systematic Mapping Review”, ACM Computing Surveys, 54: (2021). DOI: https://doi.org/10.1145/3457608
  • [31] Koupil, P., Hricko, S., and Holubová, I. “A universal approach for multi-model schema inference”, Journal of Big Data, 9, (2022). DOI: https://doi.org/10.1186/s40537-022-00645-9
  • [32] Brahmia, Z., Hamrouni, H., and Bouaziz, R., “XML data manipulation in conventional and temporal XML databases: A survey”, Computer Science Review, 36(100231): 1-13, (2020). DOI: https://doi.org/10.1016/j.cosrev.2020.100231
  • [33] Lu, J., and Holubová, I., “Multi-model Databases: A new journey to handle the variety of data”, ACM Computing Surveys, 52: 1-38, (2019). DOI: https://doi.org/10.1145/3323214
  • [34] Liu, Z.H., Lu, J., Gawlick, D., Helskyaho, H., Pogossiants, G., and Wu, Z., “Multi-model Database Management Systems - A Look Forward”, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 16–29, (2019). DOI: https://doi.org/10.1007/978-3-030-14177-6_2
  • [35] Besta, M., Gerstenberger, R., Peter, E., Fischer, M., Podstawski, M., Barthels, C., Alonso, G., and Hoefler, T., “Demystifying Graph Databases: Analysis and Taxonomy of Data Organization, System Designs, and Graph Queries”, (2019). DOI: https://doi.org/https://doi.org/10.48550/arXiv.1910.09017.
  • [36] Chen, J.K., and Lee, W.Z., “An introduction of NoSQL databases based on their categories and application industries”, Algorithms, 12: 1–16, (2019). DOI: https://doi.org/10.3390/a12050106
  • [37] Ali, W., Shafique, M.U., Majeed, M.A., and Raza, A., “Comparison between SQL and NoSQL Databases and Their Relationship with Big Data Analytics”, Asian Journal of Research in Computer Science, 4: 1–10, (2019). DOI: https://doi.org/10.9734/ajrcos/2019/v4i230108
  • [38] Bathla, G., Rani, R., and Aggarwal, H., “Comparative study of NoSQL databases for big data storage”, International Journal of Engineering & Technology, 7: 83-87, (2018). DOI: https://doi.org/10.14419/ijet.v7i2.6.10072
  • [39] Davoudian, A., Chen, L., and Liu, M., “A survey on NoSQL stores”, ACM Computing Surveys, 51: 40: 1-43, (2018). DOI: https://doi.org/10.1145/3158661
  • [40] Corbellini, A., Mateos, C., Zunino, A., Godoy, D., and Schiaffino, S., “Persisting big-data: The NoSQL landscape”, Information Systems, 63: 1–23, (2017). DOI: https://doi.org/10.1016/j.is.2016.07.009
  • [41] Gessert, F., Wingerath, W., Friedrich, S., and Ritter, N., “NoSQL database systems: a survey and decision guidance”, Computer Science - Research and Development, 32:353–365, (2017). DOI: https://doi.org/10.1007/s00450-016-0334-3
  • [42] V, M., “Comparative Study of NoSQL Document, Column Store Databases and Evaluation of Cassandra”, International Journal of Database Management Systems, 6: 11–26, (2014). DOI: https://doi.org/10.5121/ijdms.2014.6402
  • [43] Kaur, K., and Rani, R., “Modeling and Querying Data in NoSQL Databases”, 2013 IEEE International Conference on Big Data, 1–7, IEEE (2013). DOI: https://doi.org/10.1109/BigData.2013.6691765
  • [44] Battersby, S., “How a 3000-year-old code unmasked a stellar cannibal”, NewScientist, (1956). 216: 43–45, (2012). DOI: https://doi.org/10.1016/S0262-4079(12)63205-9
  • [45] Chang, F., Dean, J., Ghemawat, S., Hsieh, W.C., Wallach, D.A., Burrows, M., Chandra, T., Fikes, A., and Gruber, R.E., “Bigtable: A distributed storage system for structured data”, ACM Transactions on Computer Systems, 26: 4: 1-26, (2008). DOI: https://doi.org/10.1145/1365815.1365816
  • [46] Bertino, E., and Guerrini, G., “Object‐Oriented Databases”, Wiley Encyclopedia of Computer Science and Engineering, 1–15. Wiley (2008). DOI: https://doi.org/10.1002/9780470050118.ecse279
  • [47] Zendulka, J., “Object-Relational Modeling in the UML”, Encyclopedia of Database Technologies and Applications, 421–426, IGI Global, (2005). DOI: https://doi.org/10.4018/978-1-59140-560-3.ch071
  • [48] Vianu, V., “A Web odyssey”, ACM SIGMOD Record. 32: 68–77, (2003). DOI: https://doi.org/10.1145/776985.776999
  • [49] Lord, C., Gupta, S., The Evolution of Object Relational Databases, (2002).
  • [50] Salminen, A., and Tompa, F.W., “Requirements for XML Document Database Systems”, Proceedings of the ACM Symposium on Document Engineering, 85–94, (2001). DOI: https://doi.org/10.1145/502200.502201
  • [51] Wuwongse, V., Anutariya, C., Akama, K., and Nantajeewarawat, E., “A Data Model for XML Databases”, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 237–246, (2001). DOI: https://doi.org/10.1007/3-540-45490-X_28
  • [52] Zand, M., Collins, V., and Caviness, D., “A Survey of Current Object-Oriented Databases”, ACM SIGMIS Database, 26: 14–29, (1995). DOI: https://doi.org/10.1145/206476.206480.
  • [53] Cattell, R.G.G. Object Data Management: Object-Oriented and Extended Relational Database Systems, (1991).
  • [54] Stonebraker, M., Rowe, L.A., Lindsay, B.G., Gray, J., Carey, M.J., Brodie, M.L., Bernstein, P.A., and Beech, D., “Third-generation database system manifesto”, ACM SIGMOD Record, 19: 31–44, (1990). DOI: https://doi.org/10.1145/101077.390001
  • [55] Bancilhon, F., and Kim, W., “Object-Oriented Database Systems: In Transition”, ACM SIGMOD Record, 19: 49–53, (1990). DOI: https://doi.org/10.1145/122058.122063
  • [56] Kim, W., “Object-oriented databases: definition and research directions”, IEEE Transactions on Knowledge and Data Engineering, 2: 327–341, (1990). DOI: https://doi.org/10.1109/69.60796
  • [57] Schek, H.-J., and Scholl, M.H., “Evolution of data models”, Presented at the (1990). DOI: https://doi.org/10.1007/3-540-53397-4_35
  • [58] Bancilhon, F., and Kim, W., “Object-oriented database systems”, ACM SIGMOD Record, 19: 49–53, (1990). DOI: https://doi.org/10.1145/122058.122063
  • [59] Heiler, S., Dayal, U., Orenstein, J., and Radke-Sproull, S., “An object-oriented approach to data management: why design databases need it”, 24th ACM/IEEE conference proceedings on Design automation conference - DAC ’87, 335–340. ACM Press, New York, New York, USA, (1987).
  • [60] Fry, J.P., Sibley, E.H., “Evolution of Data-Base Management Systems”, ACM Computing Surveys (CSUR). 8:7–42, (1976). DOI: https://doi.org/10.1145/356662.356664
  • [61] Curtice, R.M., “Data base design using a codasyl system”, Proceedings of the 1974 annual ACM conference, 473–480, (1974).
  • [62] North, K., Database Systems: The First Generation, World Wide Web Internet And Web Information Systems, (1986).
  • [63] https://www.ibm.com/products/ims, Access Date: 17.04.2024.
  • [64] Taylor, R.W., and Frank, R.L., “CODASYL Data-Base management systems”, Computing Surveys, 8: 67–103, (1976). DOI: https://doi.org/10.11499/sicejl1962.19.206
  • [65] CODASYL Data Description Committe, “CODASYL Data Description Language”, Journal of Development, 155, (1974).
  • [66] Elmasri, R., and Navathe, S.B., Appendix E: An overview of Network Data Model. In: Fundementals of Database Systems 6th Edition, 1–24, (2010).
  • [67] Brown, A.S., Hirata, T.M., Koehler, A.M., Vishwanath, K., Ng, J., Pechulis, M.J., Sikes, M.A., Singleton, D.E., and Veazey, J.E., “Data Base Management for Hp Precision Architecture Computers”, Hewlett-Packard Journal, 37: 34–48, (1986).
  • [68] Codd, E.F., “Extending the Database Relational Model to Capture More Meaning”, ACM Transactions on Database Systems (TODS), 4: 397–434, (1979). DOI: https://doi.org/10.1145/320107.320109
  • [69] Stonebraker, M., and Kemnitz, G., “The POSTGRES next generation database management system”, Communications of the ACM, 34: 78–92, (1991). DOI: https://doi.org/10.1145/125223.125262.
  • [70] Ketabchi, M.A., “Object-Oriented Data Models and Management of CAD Databases”, IEEE, 123–128, (1986).
  • [71] Bertino, E., and Martino, L., “Object-Oriented Database Management Systems: Concepts and Issues”, Computer (Long Beach Calif), 24: 33–47, (1991). DOI: https://doi.org/10.1109/2.76261.
  • [72] Atkinson, M., DeWitt, D., Maier, D., Bancilhon, F., Dittrich, K., and Zdonik, S., “The Object-Oriented Database System Manifesto”, Building an Object-oriented Database System: The Story of O2, 1–17, Morgan Kaufmann Publishers Inc., (1992). DOI: https://doi.org/10.1016/b978-0-444-88433-6.50020-4.
  • [73] Schewe, K.D., and Thalheim, B., “Fundamental concepts of object oriented databases”, Acta Cybernetica, 11: 49–83, (1993).
  • [74] Vossen, G., “On formal models for object-oriented databases”, ACM SIGPLAN OOPS Messenger, 6: 1–19, (1995). DOI: https://doi.org/10.1145/219260.219262.
  • [75] Hui, S.C., Goh, A., and Raphel, J.K., “Data modeling using an object-oriented logic language”, Proceedings of IEEE Singapore International Conference on Networks/International Conference on Information Engineering: Communications and Networks for the Year 2000, SICON 1993, 2: 744–748, (1993).
  • [76] Yan, L., Ma, Z.M., and Zhang, F., “Algebraic operations in fuzzy object-oriented databases”, Information Systems Frontiers, 16: 543–556, (2014). DOI: https://doi.org/10.1007/s10796-012-9359-8.
  • [77] Alzahrani, H. “Evolution of Object-Oriented Database Systems”, Global Journal of Computer Science and Technology, 16: 33–36, (2016).
  • [78] Urban, S.D., and Dietrich, S.W., “Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappings”, SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education). 21–25, (2003). DOI: https://doi.org/10.1145/792548.611923.
  • [79] https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a76976/toc.htm, Access date: 16.07.2024.
  • [80] Dietrich, S.W., and Urban, S.D., Fundamentals of Object Databases: Object-Oriented and Object-Relational Design, (2010).
  • [81] https://www.w3.org/TR/2008/REC-xml-20081126/, Access date: 17.04.2024.
  • [82] https://www.w3.org/XML/Datamodel.html, Access date: 16.04.2024.
  • [83] Seligman, L., and Roenthal, A., “XML’s impact an databases and data sharing”, Computer (Long Beach Calif), 34: 59–67, (2001). DOI: https://doi.org/10.1109/2.928623.
  • [84] Steegmans, B., Bourret, R., Cline, O., Guyennet, O., Kulkarni, S., Priestly, S., Sylenko, V., and Wahli, U., XML for DB2 Information Integration, (2004).
  • [85] http://www.rpbourret.com/xml/XMLDatabaseProds.htm#xmlenabled, Access date: 17.04.2024.
  • [86] https://www.w3.org/TR/rdf-concepts/, Access date: 17.04.2024.
  • [87] Ramzan, S., Bajwa, I.S., Kazmi, R., Amna, “Challenges in NoSQL-based distributed data storage: A systematic literature review”, Electronics (Switzerland). 8: 1-29, (2019). DOI: https://doi.org/10.3390/electronics8050488.
  • [88] https://redis.io/, Access date: 17.04.2024.
  • [89] Hashem, H., and Ranc, D., “Evaluating NoSQL document oriented data model”, Proceedings - 2016 4th International Conference on Future Internet of Things and Cloud Workshops, W-FiCloud 2016, 51–56, (2016).
  • [90] https://www.json.org/json-en.html, Access date: 16.04.2024.
  • [91] https://www.mongodb.com/, Access date: 16.03.2024.
  • [92] Aydin, A.A., “Incremental Data Collection & Analytics the Design of Next-Generation Crisis Informatics Software”, PhD Thesis, University of Colorado Boulder, Boulder, USA, (2016).
  • [93] https://cassandra.apache.org/_/index.html, Access date: 16.03.2024.
  • [94] https://neo4j.com/, Access date: 16.03.2024.
  • [95] https://www.broadcom.com/products/mainframe/databases-database-mgmt/idms, Access date: 16.03.2024.
  • [96] https://developer.imdb.com/non-commercial-datasets/, Access date: 29.07.2024.
  • [97] https://ignitetech.ai/softwarelibrary/objectstore, Access date: 29.07.2024.
  • [98] Ryan, J., Big Data Velocity in Plain English, (2019).
  • [99] Chaudhry, N., Yousaf, M.M.: Architectural assessment of NoSQL and NewSQL systems. Distributed and Parallel Databases, 38: 881–926, (2020). DOI: https://doi.org/10.1007/s10619-020-07310-1
  • [100] Ryan, J.: Oracle vs. NoSQL vs. NewSQL Comparing Database Technology. (2018).
  • [101] Truică, C.O., Apostol, E.S., Darmont, J., and Pedersen, T.B., “The Forgotten Document-Oriented Database Management Systems: An Overview and Benchmark of Native XML DODBMSes in Comparison with JSON DODBMSes”, Big Data Research, 25, (2021). DOI: https://doi.org/10.1016/j.bdr.2021.100205
  • [102] Lourenço, J.R., Cabral, B., Carreiro, P., Vieira, M., and Bernardino, J., “Choosing the right NoSQL database for the job: a quality attribute evaluation”, Journal of Big Data, 2 (18): 1-26, (2015). DOI: https://doi.org/10.1186/s40537-015-0025-0.
  • [103] Kekevi, U., and Aydin, A.A., “Real-Time Big Data Processing and Analytics: Concepts, Technologies, and Domains”, Computer Science, 7 (2): 111–123, (2022). DOI: https://doi.org/10.53070/bbd.1204112.
  • [104] Srivastava, K., and Shekokar, N., “A Polyglot Persistence approach for E-Commerce business model”, Proceedings - 2016 International Conference on Information Science, ICIS 2016, 7–11, (2017).
  • [105] Schram, A., and Anderson, K.M., “MySQL to NoSQL Data Modeling Challenges in Supporting Scalability”, Proceedings of the 3rd annual conference on Systems, programming, and applications: software for humanity - SPLASH ’12, 191–202, (2012).
There are 105 citations in total.

Details

Primary Language English
Subjects Database Systems
Journal Section Computer Engineering
Authors

Ahmet Arif Aydın 0000-0002-4124-7275

Early Pub Date March 5, 2025
Publication Date June 1, 2025
Submission Date April 13, 2024
Acceptance Date December 29, 2024
Published in Issue Year 2025 Volume: 38 Issue: 2

Cite

APA Aydın, A. A. (2025). An in-depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling. Gazi University Journal of Science, 38(2), 706-729. https://doi.org/10.35378/gujs.1467890
AMA Aydın AA. An in-depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling. Gazi University Journal of Science. June 2025;38(2):706-729. doi:10.35378/gujs.1467890
Chicago Aydın, Ahmet Arif. “An in-Depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling”. Gazi University Journal of Science 38, no. 2 (June 2025): 706-29. https://doi.org/10.35378/gujs.1467890.
EndNote Aydın AA (June 1, 2025) An in-depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling. Gazi University Journal of Science 38 2 706–729.
IEEE A. A. Aydın, “An in-depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling”, Gazi University Journal of Science, vol. 38, no. 2, pp. 706–729, 2025, doi: 10.35378/gujs.1467890.
ISNAD Aydın, Ahmet Arif. “An in-Depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling”. Gazi University Journal of Science 38/2 (June 2025), 706-729. https://doi.org/10.35378/gujs.1467890.
JAMA Aydın AA. An in-depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling. Gazi University Journal of Science. 2025;38:706–729.
MLA Aydın, Ahmet Arif. “An in-Depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling”. Gazi University Journal of Science, vol. 38, no. 2, 2025, pp. 706-29, doi:10.35378/gujs.1467890.
Vancouver Aydın AA. An in-depth Examination of Logical Data Models Utilized in Data Storage Systems to Facilitate Data Modeling. Gazi University Journal of Science. 2025;38(2):706-29.