Abstract

In the context of a proliferation of Database Management Systems (DBMSs), we have envisioned and produced an OWL 2 ontology able to provide a high-level machine-processable description of the DBMSs domain. This conceptualization aims to facilitate a proper execution of various software engineering processes and database-focused administration tasks. Also, it can be used to improve the decision-making process for determining/selecting the appropriate DBMS, subject to specific requirements. The proposed model describes the most important features and aspects regarding the DBMS domain, including the support for various paradigms (relational, graph-based, key-value, tree-like, etc.), query languages, platforms (servers), plus running environments (desktop, Web, cloud), specific contexts—i.e., focusing on optimizing queries, redundancy, security, performance, schema vs. schema-less approaches, programming languages/paradigms, and others. The process of populating the ontology with significant individuals (actual DBMSs) benefits from the existing knowledge exposed by free and open machine-processable knowledge bases, by using structured data from Wikipedia and related sources. The pragmatic use of our ontology is demonstrated by two educational software solutions based on current practices in Web application development, proving support for learning and experimenting key features of the actual semantic Web technologies and tools. This approach is also an example of using multiple knowledge from database systems, semantic Web technologies, and software engineering areas.

Highlights

  • Database management systems are permanently classified and ranked by specialized sites around which communities of users and developers are created

  • We identified a set of decisive aspects to be considered for the conceptualization of the Database Management Systems (DBMSs) domain: Data model: relational, hierarchical, graph, key-value, multi-value, object-oriented, objectrelational, document, triple-store/quad-store (RDF—Resource Description Framework), etc

  • The Web application was used to assist the interested students in the decision process of choosing one or more DBMSs suitable for implementing a team-oriented software project to be assessed for Web Application Development discipline

Read more

Summary

Introduction

Database management systems are permanently classified and ranked by specialized sites around which communities of users and developers are created. As of July 2021, according to the DB-Engines Ranking, there are 373 different Database Management Systems (DBMSs) supporting various models such as relational, document, key-value, graph, RDF Our conceptual model can further be used in order to classify Instance Data from these public knowledge bases This further step provides the context for an enhanced view of the domain of DBMSs with the prospect of improving the overall support for information integration and search capabilities, by creating a specific knowledge graph. The second contribution consists of envisioning, designing, and developing two knowledgebased Web applications exposing suitable information about DBMSs according to user needs and preferences. This research is positioned at a confluence of the database systems, knowledge modeling, (semantic) Web technologies, and software engineering areas

A Knowledge Model of Database Management Systems
Ontology Engineering
Overview
Formulating Use Cases
System Architecture and Technological Aspects
12 DB Weekly
Practical Usage
Related Work
Findings
Conclusion
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call