From Data to Knowledge: A Unified Relational-Semantic Architecture with Context-Aware Term Modeling for Next-Generation Knowledge Systems

Document Type : Original Article

Author

Assistant Prof, Information Dissemination and Knowledge Exchange, Islamic Sciences and Culture Academy, Qom, Iran. Email: alimirarab@isca.ac.ir

10.22091/jdaid.2026.16042.1059

Abstract

Database design for knowledge-centric systems suffers from fragmentation: relational models provide integrity but implicit semantics; knowledge graphs offer explicit relationships but weak transactions; ontology-based approaches (OBDA) suffer mapping complexity; multi-model systems lack conceptual coherence. This paper proposes a unified relational-semantic architecture that bridges these gaps. The model introduces five principles: term-entity independence (context-neutral Terms), triadic contextualization (Term–Domain–Module tuples for polysemy resolution), relationships as first-class citizens (explicit Relations with typed RelationTypes), governance through typed schemas (module-relation compatibility MRT and declarative Relation Constraints), and service-oriented access control. Evaluation on a realistic dataset (5,000 terms, 18,547 relations) in Islamic sciences compares the proposed model against pure relational, Neo4j, and OBDA baselines. Results indicate that the model provides native support for contextualized term definitions across domains and modules—a feature absent from all baselines. Low overhead (45–99%) guarantees 99.4% constraint accuracy. For deep transitive closure, Neo4j is 4–5× faster (mitigable by materialized paths). The model outperforms OBDA by 3–8× and achieves a conceptual coherence score of 4.7/5, compared to 2.2–3.1/5 for baselines. The architecture offers a practical, empirically validated alternative for digital libraries, encyclopedias, and scholarly knowledge systems where contextual meaning and semantic relationships are paramount.

Keywords

Main Subjects


Abiteboul, S., Hull, R., & Vianu, V. (1995). Foundations of databases. Addison-Wesley.
Angles, R., Arenas, M., Barceló, P., Hogan, A., Reutter, J., & Vrgoč, D. (2017). Foundations of modern graph query languages. ACM Computing Surveys, 50(5), Article 68, 1–40. https://doi.org/10.1145/3104031
Auer, S., Bizer, C., Kobilarov, G., Lehmann, J., Cyganiak, R., & Ives, Z. (2007). DBpedia: A nucleus for a web of open data. In Proceedings of the 6th International Semantic Web Conference (ISWC 2007) (pp. 722–735). https://doi.org/10.1007/978-3-540-76298-0_52
Batini, C., Ceri, S., & Navathe, S. B. (1992). Conceptual database design: An entity-relationship approach. Benjamin-Cummings.
Berners-Lee, T., Hendler, J., & Lassila, O. (2001). The semantic web. Scientific American, 284(5), 34–43. https://doi.org/10.1038/scientificamerican0501-34
Boncz, P., & Manegold, S. (2020). Repeatable database benchmarking. In Proceedings of the 46th International Conference on Very Large Data Bases (VLDB 2020 Tutorial).
Brachman, R. J., & Levesque, H. J. (2004). Knowledge representation and reasoning. Morgan Kaufmann.
Calvanese, D., Cogrel, B., Komla-Ebri, S., Kontchakov, R., Lanti, D., Rezk, M., Rodriguez-Muro, M., & Xiao, G. (2017). Ontology-based data access: A survey. In Proceedings of the 26th International Joint Conference on Artificial Intelligence (IJCAI 2017) (pp. 5146–5150).
Calvanese, D., De Giacomo, G., Lembo, D., Lenzerini, M., Poggi, A., Rodriguez-Muro, M., & Rosati, R. (2007). Ontology-based data access. In Proceedings of the 19th International Conference on Knowledge Representation and Reasoning (KR 2007) (pp. 1–11).
Elmasri, R., & Navathe, S. B. (2016). Fundamentals of database systems (7th ed.). Pearson.
Gómez-Pérez, A., Fernández-López, M., & Corcho, O. (2004). Ontological engineering. Springer. https://doi.org/10.1007/b97353
Gruber, T. R. (1995). Toward principles for the design of ontologies used for knowledge sharing. International Journal of Human-Computer Studies, 43(5–6), 907–928. https://doi.org/10.1006/ijhc.1995.1081
Haghshenas Nasrabadi, A., & Ghasemy Yaghin, R. (2025). The role of data quality and visibility in risk management and performance optimization in the downstream supply chain. Journal of Data Analytics and Intelligent Decision-making, 1(1), 23–32. https://doi.org/10.22091/jdaid.2025.14090.1005
Hogan, A., Blomqvist, E., Cochez, M., d'Amato, C., Melo, G. D., Gutierrez, C., Kirrane, S., Gayo, J. E. L., Navigli, R., Neumaier, S., Ngomo, A. C. N., Polleres, A., Rashid, S. M., Rula, A., Schmelzeisen, L., Sequeda, J., Staab, S., & Zimmermann, A. (2021). Knowledge graphs. ACM Computing Surveys, 54(4), Article 71, 1–37. https://doi.org/10.1145/3447772
Lu, J., & Holubová, I. (2019). Multi-model databases: A new journey to handle the variety of data. ACM Computing Surveys, 52(3), Article 55, 1–38. https://doi.org/10.1145/3301281
Mansoori, A. (2025). The application of artificial intelligence in human resource performance appraisal: A conceptual framework for responsible implementation. Journal of Data Analytics and Intelligent Decision-making, 1(3), 13–30. https://doi.org/10.22091/jdaid.2025.14114.1009
Microsoft Corporation. (2019). SQL Server 2019 documentation. https://docs.microsoft.com/en-us/sql/sql-server/
Microsoft Corporation. (2021). ASP.NET Core documentation. https://docs.microsoft.com/en-us/aspnet/core/
Neo4j, Inc. (2023). Neo4j graph database platform (Version 5.8) [Computer software]. https://neo4j.com
Ontop. (2023). Ontop OBDA framework (Version 4.5.0) [Computer software]. https://ontop-vkg.org
Rodriguez-Muro, M., & Calvanese, D. (2012). High performance query answering over DL-Lite ontologies. In Proceedings of the 13th International Conference on Principles of Knowledge Representation and Reasoning (KR 2012) (pp. 308–318).
Shahabi, V., Toloie Eshlaghy, A., Amiri, M., & Mehdiabadi, A. (2025). Designing a social banking model for developing micro enterprises using a system dynamics approach. Journal of Data Analytics and Intelligent Decision-making, 1(2), 23–41. https://doi.org/10.22091/jdaid.2025.14318.1012
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database system concepts (7th ed.). McGraw-Hill.
Stonebraker, M., Brown, P., Poliakov, A., & Raman, S. (2016). The case for polystores. IEEE Data Engineering Bulletin, 39(4), 3–11.
Swagger. (2023). Swagger/OpenAPI tools. https://swagger.io
W3C. (2009). SKOS Simple Knowledge Organization System reference. https://www.w3.org/TR/skos-reference
Wohlin, C., Runeson, P., Höst, M., Ohlsson, M. C., Regnell, B., & Wesslén, A. (2012). Experimentation in software engineering. Springer. https://doi.org/10.1007/978-3-642-29044-2
Xiao, G., Calvanese, D., Kontchakov, R., Lembo, D., Poggi, A., Rosati, R., & Zakharyaschev, M. (2018). Ontology-based data access: A survey. In Proceedings of the 27th International Joint Conference on Artificial Intelligence (IJCAI 2018) (pp. 5511–5519). https://doi.org/10.24963/ijcai.2018/777
Jafari, M., Akhavan, P., & Akbari, A. H. (2026). Enhancing supply chain agility and performance through big data analytics: the role of digitalization and top management support. International Journal of Productivity and Performance Management, 1-22. https://doi.org/10.1108/IJPPM-06-2025-0557 
Tavakkoli-Moghaddam, R., Akbari, A. H., Tanhaeean, M., Moghdani, R., Gholian-Jouybari, F., & Hajiaghaei-Keshteli, M. (2024). Multi-objective boxing match algorithm for multi-objective optimization problems. Expert Systems with Applications, 239, 122394. https://doi.org/10.1016/j.eswa.2023.122394