article

The role of domain ontologies in database design: An ontology management and conceptual modeling environment

Authors:

Vijayan Sugumaran,

Veda C. StoreyAuthors Info & Claims

ACM Transactions on Database Systems (TODS), Volume 31, Issue 3

Pages 1064 - 1094

https://doi.org/10.1145/1166074.1166083

Published: 01 September 2006 Publication History

Abstract

Database design is difficult because it involves a database designer understanding an application and translating the design requirements into a conceptual model. However, the designer may have little or no knowledge about the application or task for which the database is being designed. This research presents a methodology for supporting database design creation and evaluation that makes use of domain-specific knowledge about an application stored in the form of domain ontologies. The methodology is implemented in a prototype system, the Ontology Management and Database Design Environment. Initial testing of the prototype illustrates that the incorporation and use of ontologies is effective in creating entity-relationship models.

References

[1]

Allen, A. F. 1983. Maintaining knowledge about temporal intervals. Commu. ACM 26, 11, 832--843.

Digital Library

[2]

Allen, G. and March, S. 2006. The effects of state-based and event-based data representations on user performance in query formulation tasks. MIS Quarterly 30, 2, 269--290.

Digital Library

[3]

Al-Muhammed, M., Embley, D. W., and Liddle, S. W. 2005. Conceptual model based semantic Web services. In Proceedings of the 24th International Conference on Conceptual Modeling (ER '05). Klagenfurt, Austria (Oct.), 288--303.

Digital Library

[4]

Alter, S. 1999. Information Systems: A Management Perspective. Addison-Wesley.

Digital Library

[5]

Batra, D., Hoffer, J. A., and Bostrom, R. P. 1990. Comparing representations developed using relational and EER models. Commu. ACM 33, 128--139.

Digital Library

[6]

Bergholtz, M. and Johannesson, P. 2001. Classifying the semantics of relationships in conceptual modeling by categorization of roles. In Proceedings of the 6th International Workshop on Applications of Natural Language to Information Systems (NLDB '01). Madrid, Spain (June), 199--203.

Digital Library

[7]

Bock, D. B. and Yager, S. E. 2002. Improving entity relationship modeling accuracy with novice data modelers. J. Comput. Inform. Syst. 42, 2, 69--75.

[8]

Bodart, F., Pate, A., Sim, M., and Weber, R. 2002. Should optional properties be used in conceptual modeling? A theory and three empirical tests. Inform. Syst. Resear. 12, 4, 384--405.

[9]

Brewster, C. and O'Hara, K. 2004. Knowledge representation with ontologies: the present and future. IEEE Intelli. Syst. 19, 1, 72--81.

Digital Library

[10]

Bunge, M. 1997. Treatise on Basic Philosophy: Vol. 3: Ontology I: The Furniture of the World. D. Reidel Publishing Co., Inc., New York, NY.

[11]

Burton-Jones, A., Storey, V. C., Sugumaran, V., Ahluwalia, P. 2005. A semiotic metrics suite for assessing the quality of ontologies. Data Knowl. Engin. 55, 1, 84--102.

Digital Library

[12]

Corcho, O., Fernandez-Lopez, M., and Gomez-Perez, A. 2003a. Methdologies, tools and languages for building ontologies. Where is their meeting point? Data Knowl. Engin. 46, 1, 41--64.

Digital Library

[13]

Corcho, O., Gomez-Perez, A., Guerrero-Rodriguez, D. J., Perez-Rey, D., Ruiz-Cristina, A., Sastre-Toral, T., and Suarez-Figueroa, M. C. 2003b. Evaluation experiment of ontology tools' interoperability with the WebODE ontology engineering workbench. 2nd International Workshop on Evaluation of Ontology-Based Tools. (Oct), Sanibel Island, FL.

[14]

Dahchour. 2001. Integrating generic relationships into object models using metaclasses. PhD thesis (March). Department of Computing Science and Engineering, Université Catholique de Louvain, Belgium.

[15]

Dennis, A. and Wixom, B. H. 2000. Systems Analysis and Design. John Wiley.

[16]

Dey, D., Storey, V. C., and Barron, T. M. 1999. Improving database design through the analysis of relationships. ACM Trans. Datab. Syst. 24, 4, 453--486.

Digital Library

[17]

Ding, Y. and Foo, S. 2002. Ontology research and development: Part 2--A review of ontology mapping and evolving. J. Inform. Science 28, 5, 375--388.

[18]

Embley, D. W. 2004. Toward semantic understanding---An approach based on information extraction ontologies. In Proceedings of the of the 15th Australasian Database Conference (ADC '04). Dunedin, New Zealand, (Jan.). Klaus-Dieter Schewe, K.-D., and Williams, H., Eds. Conferences in Research and Practice in Information Technology, 27.

Digital Library

[19]

Embley, D. W., Tao C., and Liddle, S. W. 2005. Automating the extraction of data from HTML tables with unknown structure. Data Knowl. Engin. 54, 1 (July), 3--28.

Digital Library

[20]

Fensel, D., Harmelen, F. V., Horrocks, I., McGuinness, D. L., and Patel-Schneider, P. F. 2001. OIL: An ontology infrastructure for the Semantic Web. IEEE Intelligent Syst. (Mar./Apr.), 38--45.

Digital Library

[21]

Friedman-Hill, E. 2006. JESS, the expert system shell, Sandia National Laboratories, Livermore, CA. URL: http://herzberg.ca.sandia.gov/jess.

[22]

Gomez-Perez, A. 1999. Tutorial on ontological engineering. In Proceedings of the 16th International Joint Conference on Artificial Intelligence (IJCAI--99). Stockholm, Sweden (July/Aug.). 6.

[23]

Gruber, T. R. 1993. A translation approach to portable ontology specifications. Knowl. Acquisition 5, 199--220.

Digital Library

[24]

Gualtleri, A. and Ruffolo, M. 2005. An ontology-based framework for representing organizational knowledge. In Proceedings of the 5th International Conference on Knowledge Management (I-KNOW '05). Graz, Austria (June/July), 71--78.

[25]

Guarino, N. 2005. Personal correspondence.

[26]

Heflin, J. and Hendler, J. 2000. Dynamic ontologies on the Web. In Proceedings of 17th AAAI-2000. AAAI/MIT Press, 443--449.

Digital Library

[27]

Hendler, J. 2001. Agents and the semantic Web. IEEE Intelligent Systems (March/April), 30--36.

Digital Library

[28]

Kassarjian, H. H. 1977. Content analysis in consumer research. J. Consumer Resear. 4, 1, 8--18.

[29]

Knight, C., Gašević, D., and Richards, G. 2006. An ontology-based framework for bridging learning design and learning content. Educat. Technol. Society 9, 1, 23--37.

[30]

Lammari, N. and Metais, E. 2004. Building and maintaining ontologies: A set of algorithms. Data Knowl. Engin. 48, 2, 155--176.

Digital Library

[31]

Lenat, D. B. 1995. CYC: A large-scale investment in knowledge infrastructure. Comm. ACM 38, 11, 33--38.

Digital Library

[32]

Lindland, O. I., Sindre, G., and Solvberg, A. 1994. Understanding qwuality in conceptual modeling. IEEE Software 11, 2, 42--49.

Digital Library

[33]

Lloyd-Williams, M. 1997. Exploiting domain knowledge during the automated design of object oriented databases. In Proceedings of the 16th International Conference on Conceptual Modeling (E-R'97). Los Angeles, CA, (Nov).

Digital Library

[34]

Mason, O. and Grove-Stephensen, I. 2002. Automated free text marking with paperless school. In Proceedings of 6th International Computer Assisted Assessment Conference. Loughborough, UK. (July). 213--219.

[35]

McGuinness, D. L. 2002. Ontologies come of age. In D. Fensel, J. Hendler, H. Lieberman, and W. Wahlster, Eds. Spinning the Semantic Web: Bringing the World Wide Web to Its Full Potential. MIT Press, Cambridge, MA.

[36]

Moody, D. L. and Shanks, G. G. 1998. What makes a good data model? A framework for evaluating and improving the quality of entity relationship models. Australian Comput. J. 30, 3, 97--110.

[37]

Noah, S. A. and Williams, M. D. 2002. Knowledge-based approaches to database design diagnosis; improving performance with a domain specific thesaurus structure. In Proceedings of the IASTED International Conference on Artificial and Computational Intelligence, N. Ishii, Ed. Calgary, Alberta, Canada. ACTA Press, 366--371.

[38]

Noy, N. F., Rubin, D. L., and Musen, M. A. 2004. Making biomedical ontologies and ontology repositories work. IEEE Intelligent Syst. 19, 6, 78--81.

Digital Library

[39]

Oberle, D., Volz, R., Motik, B., Staab, S. 2004. An extensible ontology software environment. In Handbook on Ontologies, Staab, S., and Studer, R., Eds. Springer, Verlag, Berlin, Germany, 311--333.

[40]

Parsons, J. and Wand, Y. 2000. Emancipating instances from the tyranny of classes in information modeling. ACM Trans. Datab. Syst. 25, 2 (June), 228--268.

Digital Library

[41]

Pease, A., Niles, I., and Li, J. 2002. The suggested upper merged ontology: A large ontology for the semantic Web and its applications. In Working Notes of the AAAI-2002 Workshop on Ontologies and the Semantic Web, Edmonton, Canada (July/Aug.).

[42]

Pinto, H. S. and Martins, P. J. 2004. Ontologies: How can they be built? Knowl. Inform. Syst. 6, 4, 441--464.

Digital Library

[43]

Purao, S. and Storey, V. C. 2005. A multi-layered ontology for comparing relationship semantics in conceptual models of databases. J. Applied Ontology 1, 1, 117--139.

Digital Library

[44]

Shanks, G., Tansley, E., Nurelini, J., Toblin, D., and Weber, R. 2002. Representing part-whole relationships in conceptual modeling: An empirical evaluation. International Conference on Information Systems, Barcelona, Spain (Dec.).

[45]

Siau, K. 2004. Relationship construct in modeling information systems. Editorial Preface--J. Datab. Manag. 15, 3 (July/Sept.), i--v.

[46]

Siau, K., Wand, Y., and Benbasat, I. 1997. The Relative importance of structural constraints and surface semantics in information modeling. Inform. Syst. 22, 23, 155--170.

Digital Library

[47]

Stewart, D. B. and Arora, G. 2003. A tool for analyzing and fine tuning the real-time properties of an embedded system. IEEE Trans. Softw. Engin. 29, 4, 311--326.

Digital Library

[48]

Storey, V. C. 2005. Classifying and comparing relationships in conceptual modeling. IEEE Trans. Knowl. Data Engin. 17, 11, 1--13.

Digital Library

[49]

Storey, V. C., Chiang, R., and Chen, L. 2005. Ontology creation: Extraction of domain knowledge from Web documents. In Proceedings of the 24th International Conference on Conceptual Modeling (ER '05). Lecture Notes in Computer Science, Springer-Verlag, Berlin, Germany, 24--28 (Oct.).

Digital Library

[50]

Storey, V. C., Dey, D., Ullrich, H., and Sundaresan, S. 1998. An ontology-based expert system for database design. Data Knowl. Engin. 28, 1, 31--46.

Digital Library

[51]

Sugumaran, V., Storey, V. C. 2002. Ontologies for conceptual modeling: Their creation, use, and management. Data Knowl. Engin. 42, 3, 251--271.

Digital Library

[52]

Swartout, W. 1999. Ontologies. IEEE Intelligent Syst., (Jan./Feb.), 18--19.

Digital Library

[53]

Teorey, T. J., Yang, D., and Fry, J. P. 1986. A logical design methodology for relational databases using the extended entity-relationship model. ACM Comput. Surv. 18, 2, 197--222.

Digital Library

[54]

Turk, D. E., Vijayasarathy, L. R., and Clark, J. D. 2003. The value of conceptual modeling in database development: An experimental investigation. In Proceedings of the Evaluation of Modeling Methods in Systems Analysis and Design Conference, Velden, Austria.

[55]

Wand, Y., Storey, V. C., and Weber, R. 1999. Analyzing the meaning of a relationship. ACM Trans. Datab. Syst. 24, 4 (Dec.), 494--528.

Digital Library

[56]

Weber, R. 1996. Are attributes entities? A study of database designers' memory structures. Inform. Syst. Resear. 7, 2 (June), 137--162.

Digital Library

[57]

Weber, R. 2002a. Conceptual modeling and ontology: Possibilities and pitfalls. In Proceedings of the 21st International Conference on Conceptual Modeling (ER '02), S. Spaccapietra, S. T. March, and Y. Kambayashi, Eds. Lecture Notes in Computer Science, vol. 2503, 1--2, Springer-Verlag Berlin, Germany.

Digital Library

[58]

Weber, R. 2002b. Ontological issues in accounting information systems. Sutton, S. and Arnold, V., Eds., Researching Accounting as an Information Systems Discipline. American Accounting Association, Sarosota, FL.

[59]

Welty, C. and Guarino, N. 2001. Supporting ontological analysis of taxonomic relationships. Data Knowl. Engin. (Special Issue on ER 2000) 39, 1, 51--74.

Digital Library

Cited By

Storey VLukyanenko RCastellanos A(2023)Conceptual Modeling: Topics, Themes, and Technology TrendsACM Computing Surveys10.1145/358933855:14s(1-38)Online publication date: 17-Jul-2023
https://dl.acm.org/doi/10.1145/3589338
Ouared ABenali ASiabdelhadi A(2023)GOMAD: A Goal Oriented Approach for Modeling and Analyzing Database Deployment2023 4th International Informatics and Software Engineering Conference (IISEC)10.1109/IISEC59749.2023.10391023(1-6)Online publication date: 21-Dec-2023
https://doi.org/10.1109/IISEC59749.2023.10391023
Omar M(2023)Measurement of ChatGPT Performance in Mapping Natural Language Speficaction into an Entity Relationship Diagram2023 IEEE 11th International Conference on Systems and Control (ICSC)10.1109/ICSC58660.2023.10449869(530-535)Online publication date: 18-Dec-2023
https://doi.org/10.1109/ICSC58660.2023.10449869
Show More Cited By

Index Terms

The role of domain ontologies in database design: An ontology management and conceptual modeling environment
1. Information systems
  1. Data management systems
    1. Database design and models

Recommendations

An ontological analysis of the relationship construct in conceptual modeling

Conceptual models or semantic data models were developed to capture the meaning of an application domain as perceived by someone. Moreover, concepts employed in semantic data models have recently been adopted in object-oriented approaches to systems ...
Integrating Ontologies in Database Scheme: Ontology-Based Views Conceptual Modeling
SITIS '10: Proceedings of the 2010 Sixth International Conference on Signal-Image Technology and Internet Based Systems

In this paper, we propose an approach to integrate the domain ontology life cycle in database scheme process design. To this end, we lay down that: (i) the ANSI/X3/SPARC architecture is used as modeling framework, (ii) ontology and data semantics are ...
Ontologies for conceptual modeling: their creation, use, and management

Although ontologies have been proposed as an important and natural means of representing real world knowledge for the development of database designs, most ontology creation is not carried out systematically. To be truly useful, a repository of ...

Comments

Information & Contributors

Information

Published In

cover image ACM Transactions on Database Systems

ACM Transactions on Database Systems Volume 31, Issue 3

September 2006

400 pages

ISSN:0362-5915

EISSN:1557-4644

DOI:10.1145/1166074

Issue’s Table of Contents

Copyright © 2006 ACM.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 September 2006

Published in TODS Volume 31, Issue 3

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

76
Total Citations
View Citations
3,503
Total Downloads

Downloads (Last 12 months)51
Downloads (Last 6 weeks)9

Reflects downloads up to 27 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

Storey VLukyanenko RCastellanos A(2023)Conceptual Modeling: Topics, Themes, and Technology TrendsACM Computing Surveys10.1145/358933855:14s(1-38)Online publication date: 17-Jul-2023
https://dl.acm.org/doi/10.1145/3589338
Ouared ABenali ASiabdelhadi A(2023)GOMAD: A Goal Oriented Approach for Modeling and Analyzing Database Deployment2023 4th International Informatics and Software Engineering Conference (IISEC)10.1109/IISEC59749.2023.10391023(1-6)Online publication date: 21-Dec-2023
https://doi.org/10.1109/IISEC59749.2023.10391023
Omar M(2023)Measurement of ChatGPT Performance in Mapping Natural Language Speficaction into an Entity Relationship Diagram2023 IEEE 11th International Conference on Systems and Control (ICSC)10.1109/ICSC58660.2023.10449869(530-535)Online publication date: 18-Dec-2023
https://doi.org/10.1109/ICSC58660.2023.10449869
Diker SSakar C(2023)Creating CREATE queries with multi-task deep neural networksKnowledge-Based Systems10.1016/j.knosys.2023.110416266(110416)Online publication date: Apr-2023
https://doi.org/10.1016/j.knosys.2023.110416
Patil YGandhi SKiwelekar ANetak L(2023)A Small-Scale Ontology to Represent Knowledge About Question ItemsSmart Trends in Computing and Communications10.1007/978-981-99-0838-7_5(47-58)Online publication date: 15-Jun-2023
https://doi.org/10.1007/978-981-99-0838-7_5
Li YRadev DRafiei DLi YRadev DRafiei D(2023)Data and Query ModelNatural Language Interfaces to Databases10.1007/978-3-031-45043-3_3(27-47)Online publication date: 25-Nov-2023
https://doi.org/10.1007/978-3-031-45043-3_3
Trujillo JDavis KDu XDamiani EStorey V(2021)Conceptual modeling in the era of Big Data and Artificial Intelligence: Research topics and introduction to the special issueData & Knowledge Engineering10.1016/j.datak.2021.101911135(101911)Online publication date: Sep-2021
https://doi.org/10.1016/j.datak.2021.101911
Lukyanenko RStorey VPastor O(2021)Foundations of information technology based on Bunge’s systemist philosophy of realitySoftware and Systems Modeling (SoSyM)10.1007/s10270-021-00862-520:4(921-938)Online publication date: 1-Aug-2021
https://dl.acm.org/doi/10.1007/s10270-021-00862-5
Lukyanenko RStorey VPastor O(2020)Article 8. Fondements des technologies de l’information d’après la philosophie systémiste de la réalité de BungeMεtascience10.3917/metas.002.0175N° 2:2(175-219)Online publication date: 11-Jan-2020
https://doi.org/10.3917/metas.002.0175
Hafidh RSharif MAl-Bayatti AAlfakeeh AAlassafi MAlqarni M(2020)An Effective Knowledge-Based Modeling Approach towards a “Smart-School Care Coordination System” for Children and Young People with Special Educational Needs and DisabilitiesSymmetry10.3390/sym1209149512:9(1495)Online publication date: 11-Sep-2020
https://doi.org/10.3390/sym12091495
Show More Cited By

View Options

Login options

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

Full Access

Get this Article

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Issue’s Table of Contents