Data Models, Semantics, Query languages

Abstract

This study tries to offer a complete review of database concepts, semantics, and query languages. A data model is a theoretical data representation that specifies the structure, connections, and restrictions of data in a certain area. It allows you to organise and categorise data for easier organisation, access, and management. A query language is a kind of computer programming language that is used to get information from a database. It enables users to describe the data they wish to obtain as well as the criteria under which the data must be provided. In the overall context of data modelling and query languages, semantics refers to the interpretation and significance of data and questions. It entails setting the rules and limitations for data storage, retrieval, and manipulation, as well as verifying that query results are consistent and relevant. Data modelling, query language, and semantics work together to create the basis of database management systems, allowing for efficient and effective data storage and retrieval for a broad variety of applications. We intend to give a greater knowledge of these ideas and their usefulness in data management by exploring the strengths and shortcomings of various data models and query languages, as well as highlighting the problems and applications of semantics. Here, also determines the expansion for the global usage of EHR systems and the demand for efficient data management services which built for the betterment of health records. A precise literature study was carried out, encompassing a wide variety of publications and themes such as Data Models, Semantics, Query Languages, the importance of these ideas in database systems, and an assessment of the advantages and drawbacks of numerous data models.