scholarly journals The use of modeling tools at the stages of database design

2019 ◽  
Vol 6 (4) ◽  
Author(s):  
Marina Makhmutova ◽  
Novik Novik
Keyword(s):  
Data Model ◽  
Management System ◽  
Database Management ◽  
Database Design ◽  
Subject Area ◽  
Database Management System ◽  
Foreign Languages ◽  
Design Stage ◽  
Modeling Tools ◽  
The Subject

The article discusses the possibilities of using modeling tools at the stages of database design. Database design is one of the most complex and crucial tasks associated with the creation of an automated information system. As a result of solving this problem, the content of the database should be determined, an effective way for organizing data for all its future users, and data management tools. The main goal of this stage is to develop such a database scheme that it includes the necessary and sufficient data on information objects, their properties and relationships in accordance with the objects of the subject area and the processes of their transformation. The authors present the results of using modeling tools to solve the problems of the database design stage. Creating models is considered from the point of view of three-circuit architecture, the main principle of which is abstraction. To display the levels of data presentation, three related models have been developed: an external data model that displays the representations of each type of user existing in the organization (description of the subject area); a conceptual data model that displays a logical (or generalized) idea of data, independent of the type of database management system selected; an internal data model that displays the conceptual diagram in a specific way that is understandable to the selected target database management system. As an example of a subject area, the activity of a school of foreign languages is considered, namely, the registration of students in a school. The main problem is the large amount of information that is processed manually: paper forms of clients are drawn up, reports on the implementation of work are manually generated and filled out. It is necessary to develop a draft database for the registration of students of a school of foreign languages and to further implement it in the environment of the selected database management system.

Relationship Cardinality Constraints in Relational Database Design

2005 ◽  
pp. 2419-2424 ◽  
Author(s):  
Dolores Cuadra ◽  
Paloma Martinez ◽  
Elena Castro
Keyword(s):  
Real World ◽  
Management System ◽  
Database Management ◽  
Database Design ◽  
Database Management System ◽  
Conceptual Modelling ◽  
Complex Task ◽  
Cardinality Constraints ◽  
Abstract Level ◽  
Definition Of

Database modelling is a complex task that involves conceiving, understanding, structuring and describing real universes of discourse (UD) through the definition of schemata using abstraction processes and data models. Traditionally, three phases are identified in database design: conceptual, logical and physical design. The conceptual modelling phase represents the most abstract level since it is independent of any database management system (DBMS) and, consequently, it is very close to the user and allows him/her to collect almost completely the semantics of the real world to be modelled.

scholarly journals Growth of relational model: Interdependence and complementary to big data

2021 ◽  
Vol 11 (2) ◽  
pp. 1780
Author(s):  
Sucharitha Shetty ◽  
B. Dinesh Rao ◽  
Srikanth Prabhu
Keyword(s):  
Data Storage ◽  
Data Model ◽  
Concurrency Control ◽  
Management System ◽  
Database Management ◽  
Data Retrieval ◽  
Database Management System ◽  
Relational Model ◽  
Complete Model ◽  
Relational Data Model

A database management system is a constant application of science that provides a platform for the creation, movement, and use of voluminous data. The area has witnessed a series of developments and technological advancements from its conventional structured database to the recent buzzword, bigdata. This paper aims to provide a complete model of a relational database that is still being widely used because of its well known ACID properties namely, atomicity, consistency, integrity and durability. Specifically, the objective of this paper is to highlight the adoption of relational model approaches by bigdata techniques. Towards addressing the reason for this in corporation, this paper qualitatively studied the advancements done over a while on the relational data model. First, the variations in the data storage layout are illustrated based on the needs of the application. Second, quick data retrieval techniques like indexing, query processing and concurrency control methods are revealed. The paper provides vital insights to appraise the efficiency of the structured database in the unstructured environment, particularly when both consistency and scalability become an issue in the working of the hybrid transactional and analytical database management system.

Perancangan Basis Data Sistem Informasi Penjualan Barang (Studi Kasus: Minimarket “ABC” Sidareja)

2020 ◽  
Vol 2 (1) ◽  
pp. 61-68
Author(s):  
R Bagus Bambang Sumantri ◽  
Fajar Mahardika
Keyword(s):  
Data Processing ◽  
Management System ◽  
Database Management ◽  
Database Design ◽  
Database Management System ◽  
Effective Decision ◽  
Time Information

Data processing to produce a computerized information is a tool that needed at this time in various types of business because the information capable presented within quickly and accurately time. Information which capable of quickly and accurately presented can produce quickly and effective decision but the database design that applied in a database management system is no less important Good database design will facilitate the implementation of aplications and optimize the performance of the database manajemen system itself.

scholarly journals Optimization and Upgrade of Special Database Management System for University Archives Based on Cloud Computing

2021 ◽  
Vol 2074 (1) ◽  
pp. 012087
Author(s):  
Jianjun Wang
Keyword(s):  
Cloud Computing ◽  
Data Management ◽  
Management System ◽  
Database Management ◽  
Colleges And Universities ◽  
Database Management System ◽  
Modeling Tools ◽  
Overall Design ◽  
University Archives ◽  
Optimization And Upgrading

Abstract With the progress of society and the development of science and technology, the data management of archives in colleges and universities has also changed from traditional manual operation to information technology system operation, which has taken a big step forward in the speed of data archive management. At the same time, following in the footsteps of the party and the state, according to the education reform measures issued by them, further implementation and implementation. With the innovation of education model, the reform of management method, and the expansion of teaching scale, the types and quantity of files are also increasing, and the scope is also expanding, which leads to the continuous increase of management difficulty. This requires data management to achieve informatization to meet the needs of society. The purpose of this paper is to study the optimization and upgrading of the special database management system of the archives of colleges and universities based on cloud computing. Based on cloud computing, this paper proposes the establishment of a special database management system for college archives and the methods and key technologies used in the process of optimization and upgrading. First, analyze the characteristics of the database management system, and then conduct demand analysis and functional analysis of the system. Secondly, research the advantages and disadvantages between the traditional data management of colleges and universities and the current latest database management system. Finally, according to the needs of the special database and system function requirements, the overall design of the archives management system is carried out, database modeling tools are used to optimize the database, and then its operation is studied, and system testing is carried out to enable it to meet the needs of university archives management. The experimental results show that the focus of database function optimization in different universities is different. University A prefers timeliness, accounting for 46%. University B thinks security is the most important, accounting for as high as 51%. University C is relatively even, both at 30%. The conclusion is to select the most practical and demanding functions for further optimization, and choose an overall design suitable for the special data of colleges and universities.

scholarly journals The global rock art database: developing a rock art reference model for the RADB system using the CIDOC CRM and Australian heritage examples

2015 ◽  
Vol II-5/W3 ◽  
pp. 89-96 ◽  
Author(s):  
R. A. Haubt
Keyword(s):  
Management System ◽  
Database Management ◽  
New Technologies ◽  
Reference Model ◽  
Rock Art ◽  
Database Management System ◽  
Design Stage ◽  
Test Model ◽  
Virtual Organisation ◽  
Cidoc Crm

The <i>Rock Art Database</i> (RADB) is a virtual organisation that aims to build a global rock art community. It brings together rock art enthusiasts and professionals from around the world in one centralized location through the deployed publicly available <i>RADB Management System</i>. This online platform allows users to share, manage and discuss rock art information and offers a new look at rock art data through the use of new technologies in rich media formats. Full access to the growing platform is currently only available for a selected group of users but it already links over 200 rock art projects around the globe. <br><br> This paper forms a part of the larger <i>Rock Art Database</i> (RADB) project. It discusses the design stage of the <i>RADB System</i> and the development of a conceptual <i>RADB Reference Model</i> (RARM) that is used to inform the design of the <i>Rock Art Database Management System</i>. It examines the success and failure of international and national systems and uses the Australian heritage sector and Australian rock art as a test model to develop a method for the <i>RADB System</i> design. The system aims to help improve rock art management by introducing the CIDOC CRM in conjunction with a rock art specific domain model. It seeks to improve data compatibility and data sharing to help with the integration of a variety of resources to create the global <i>Rock Art Database Management System</i>.

Cardiological Database Management System as a Mediator to Clinical Decision Support

1996 ◽  
Vol 35 (01) ◽  
pp. 52-58 ◽  
Author(s):  
A. Mavromatis ◽  
N. Maglaveras ◽  
A. Tsikotis ◽  
G. Pangalos ◽  
V. Ambrosiadou ◽  
...  
Keyword(s):  
Management System ◽  
Database Management ◽  
Medical Information ◽  
Object Oriented ◽  
Medical Personnel ◽  
Database Management System ◽  
Ease Of Use ◽  
Medical Database ◽  
Analysis And Design ◽  
Object Oriented Design

AbstractAn object-oriented medical database management system is presented for a typical cardiologic center, facilitating epidemiological trials. Object-oriented analysis and design were used for the system design, offering advantages for the integrity and extendibility of medical information systems. The system was developed using object-oriented design and programming methodology, the C++ language and the Borland Paradox Relational Data Base Management System on an MS-Windows NT environment. Particular attention was paid to system compatibility, portability, the ease of use, and the suitable design of the patient record so as to support the decisions of medical personnel in cardiovascular centers. The system was designed to accept complex, heterogeneous, distributed data in various formats and from different kinds of examinations such as Holter, Doppler and electrocardiography.

Sign in / Sign up

Export Citation Format

Share Document