scholarly journals An ER-based framework for declarative web programming

2012 ◽  
Vol 14 (3) ◽  
pp. 269-291 ◽  
Author(s):  
MICHAEL HANUS ◽  
SVEN KOSCHNICKE
Keyword(s):  
User Interface ◽  
Data Model ◽  
Relational Databases ◽  
Declarative Programming ◽  
Customer Requirements ◽  
Web Based ◽  
Data Dependencies ◽  
Er Model ◽  
Entity Relationship ◽  
High Level

AbstractWe describe a framework to support the implementation of web-based systems intended to manipulate data stored in relational databases. Since the conceptual model of a relational database is often specified as an entity-relationship (ER) model, we propose to use the ER model to generate a complete implementation in the declarative programming language Curry. This implementation contains operations to create and manipulate entities of the data model, supports authentication, authorization, session handling, and the composition of individual operations to user processes. Furthermore, the implementation ensures the consistency of the database w.r.t. the data dependencies specified in the ER model, i.e., updates initiated by the user cannot lead to an inconsistent state of the database. In order to generate a high-level declarative implementation that can be easily adapted to individual customer requirements, the framework exploits previous works on declarative database programming and web user interface construction in Curry.

Enforcing Cardinality Constraints in the ER Model with Integrity Methods

2002 ◽  
pp. 1-16 ◽  
Author(s):  
Mira Balaban ◽  
Peretz Shoval
Keyword(s):  
Data Model ◽  
Object Oriented ◽  
Database Schema ◽  
Direct Impact ◽  
Cardinality Constraints ◽  
Relationship Type ◽  
Er Model ◽  
Entity Relationship

Entity-Relationship (ER) schemas include cardinality constraints that restrict the dependencies among entities within a relationship type. The cardinality constraints have direct impact on application transactions, since insertions or deletions of entities or relationships might affect related entities. Application transactions can be strengthened to preserve the consistency of a database with respect to the cardinality constraints in a schema. Yet, once an ER schema is translated into a logical database schema, the direct correlation between the cardinality constraints and application transaction is lost, since the components of the ER schema might be decomposed among those of the logical database schema. We suggest extending the Enhanced-ER (EER) data model with integrity methods that can enforce the cardinality constraints. The integrity methods can be fully defined by the cardinality constraints, using a small number of primitive update methods, and are automatically created for a given EER diagram. A translation of an EER schema into a logical database schema can create integrity routines by translating the primitive update methods alone. These integrity routines may be implemented as database procedures, if a relational DBMS is utilized, or as class methods, if an object-oriented DBMS is utilized.

Using Ontology and Rule-Based Reasoning for Conceptual Data Models Synonyms Detection

2019 ◽  
Vol 30 (1) ◽  
pp. 1-21
Author(s):  
Ljubica Kazi ◽  
Zoltan Kazi
Keyword(s):  
Data Model ◽  
System Development ◽  
Data Models ◽  
University Student ◽  
Specific Data ◽  
Entity Relationship Model ◽  
Relationship Model ◽  
Er Model ◽  
Entity Relationship ◽  
Conceptual Data

Conceptual data models can change during the information system development and teamwork phases, which require constantly monitoring with synonyms detection. This study elaborates on an approach for detecting synonyms in an entity-relationship model based on mapping with ontological elements. The use of a specific data model validator (DMV) tool enables formalization of the ontology and ER models, as well as their integration with the set of reasoning rules. The reasoning rules enable mapping between formalized elements of the ontology and ER model, and the extraction of synonyms. Formalized elements and reasoning rules are processed within Prolog for the extraction of synonyms. An empirical study conducted by using university student exams demonstrates usability of the proposed approach. The results show effectiveness in extraction of synonyms in all types of conceptual data model elements.

Rules for Migrating from Entity Relationship (ER) Diagrams to Object Relationship (OR) Diagrams

2006 ◽  
Vol 2 (4) ◽  
pp. 177-191 ◽  
Author(s):  
Sikha Bagui
Keyword(s):  
Conceptual Design ◽  
Relational Databases ◽  
Object Oriented ◽  
Design Tool ◽  
Data Migration ◽  
Mapping Rules ◽  
Er Model ◽  
Entity Relationship ◽  
Object Relationship ◽  
Structural Aspects

In this paper, we provide detailed mapping rules (a methodology) to convert an ER schema into an object relationship (OR) schema. The mapping rules are presented in a manner that will keep as much of the semantics of the database intact, in order to smoothen the important step of data migration from an ER schema to an OR schema. This OR schema should also serve as a conceptual design tool for object-oriented data models, very much like the ER diagrams are a conceptual design tool for relational databases. Since we are mainly discussing the conversion from an ER model to an OR model, we are limiting the discussion in this paper to the structural aspects of the OR model.

scholarly journals PERANCANGAN SISTEM PENDUKUNG KEPUTUSAN UNTUK PENGENDALIAN KUALITAS PADA DEPARTEMEN BLOW PT. D Parwadi Moengin1), Rina Fitriana2),), Buana Ramadhan3)

2018 ◽  
Vol 7 (3) ◽  
Author(s):  
Parwadi Moengin ◽  
Rina Fitriana ◽  
Buana Ramadhan
Keyword(s):  
User Interface ◽  
Data Model ◽  
Data Flow ◽  
Flow Diagram ◽  
Physical Data ◽  
Data Flow Diagram ◽  
Entity Relationship ◽  
Entity Relationship Diagram

<p><em>PT. D merupakan perusahaan yang bergerak di bidang manufaktur dan salah satu supplier kemasan plastik terbaik di Asia. Plastik yang diproduksi adalah jenis plastik kemasan siap pakai seperti botol minuman dan botol kemasan obat. Permasalahan yang terjadi di departemen blow PT. D adalah sistem pengendalian kualitas dini yang kurang efektif pada Inline 1.Hal tersebut disebabkan oleh petugas QC yang telah menemukan cacat pada produk botol harus mencari supervisor agar dapat menindaklanjuti permasalahan yang ada di mesin agar tidak terus menerus menghasilkan produk yang memiliki kecacatan tersebut. Tujuan penelitian ini adalah untuk merancang sistem pendukung keputusan untuk mengendalikan kualitas pada departemen blow PT. D. Perancangan sistem pendukung keputusan dimulai dengan melakukan analisa sistem yang sedang terjadi menggunakan kerangka PIECES. Analisa tersebut dilakukan untuk mengetahui kebutuhan dari pengguna sistem. Selanjutnya adalah melakukan perancangan komponen pengolahan data dengan membuat diagram konteks, Data Flow Diagram (DFD), Entity Relationship Diagram (ERD), Physical Data Model (PDM) dan pembuatan database menggunakan software MySQL. Model yang digunakan dalam perancangan sistem pendukung keputusan ini adalah model peta kendali untuk melihat apakah data tersebut out of control atau tidak dan model FMEA digunakan untuk melihat tindakan yang harus dilakukan bedasarkan RPN tertinggi. Langkah yang terakhir adalah perancangan user interface dengan menggunakan bahasa pemograman PHP. Sistem Pendukung Keputusan yang dibuat dapat menghitung peta kendali dan menganalisis kecacatan menggunakan FMEA. Dari sistem yang telah dibuat bedasarkan hasil perhitungan peta kendali, data yang didapat dalam kategori in control karena penyebaran data tidak ada yang melebihi UCL dan LCL. Bedasarkan analisis menggunakan FMEA, perhitungan RPN tertinggi sebesar 324. Jenis kegagalan dengan RPN sebesar 324 adalah flashing. Hasil dari analisis menggunakan FMEA tersebut adalah dibuat usulan instruksi kerja untuk perbaikan pisau didalam mesin. Dalam proses verifikasi dan validasi, sistem yang telah dibuat valid.</em></p>

scholarly journals An Exploration of Individual Differences in Synthesizing Entity-Relationship Data Models

10.28945/2616 ◽  
2003 ◽  
Author(s):  
Vijay V. Raghavan
Keyword(s):  
Individual Differences ◽  
Learning Styles ◽  
Data Model ◽  
National Origin ◽  
Popular Approach ◽  
Er Model ◽  
Written Descriptions ◽  
Entity Relationship ◽  
The Individual ◽  
Conceptual Data

Entity Relationship (ER) modeling (1976) is a popular approach to formulate a conceptual data model for designing properly structured databases. In spite of some criticisms of the model leading to numerous extensions added to the original ER model, it is generally believed to be a method of choice for designing common databases. Not surprisingly, ER Modeling is inextricably a part of all database-design classes. Teachers of this modeling construct often encounter students experiencing problems in synthesizing ER models from verbal or written descriptions. This study explores whether individual differences contribute to such difficulties. Gender, length of Information Technology (IT) experience, length of database experience, length of business experience, national origin and learning styles are hypothesized as the individual diffe r-ences that might contribute to a student’s ability to synthesize a conceptual ER model. Ability to synthesize ER models was evaluated using a textbook type ER modeling problem.

A Generic Model for Universal Data Storage and Conversion and Its Web Based Prototypical Implementation

2012 ◽  
Vol 7 (1) ◽  
pp. 67-82 ◽  
Author(s):  
Andreas Unterweger ◽  
Bernadette Himmelbauer ◽  
Simon Kranzer ◽  
Peter Ott ◽  
Robert Merz ◽  
...  
Keyword(s):  
Data Storage ◽  
Data Model ◽  
Data Representation ◽  
Data Conversion ◽  
Generic Model ◽  
Data Converter ◽  
Web Based ◽  
Data Dependencies ◽  
Data Generator ◽  
Extensible Markup

This paper presents a prototypical, Web based data conversion framework and its underlying data representation principles which allow conversions from and to any data format. Therefore, a data model is proposed which allows storing values of arbitrary types, including inter-data dependencies and meta information. Furthermore, an Extensible Markup Language (XML) based model to describe data formats is provided which allows specifying programs to convert data represented in existing formats both from and to the proposed data model. It will be shown that these programs are Turing complete, thus allowing the same arbitrarily complex conversions which are possible with Extensible Stylesheet Language Transformations (XSLT) or the C programming language. Finally, the components of a prototypical Web based implementation in form of a validator, a data converter and a data generator are described. In combination with a data editor, parts of this prototypical implementation are already employed in several use cases in the industry and other research projects to transform data between different formats.

scholarly journals Perancangan Aplikasi Web Penyewaan Lapangan Futsal (Studi Kasus :Sumber Jaya Futsal Tangerang)

2020 ◽  
Vol 8 (1) ◽  
pp. 31-35
Author(s):  
Ika Yuniva ◽  
Andriansah Andriansah ◽  
Yoga Nur Ikhsan
Keyword(s):  
Programming Language ◽  
Data Model ◽  
Web Application ◽  
Web Based ◽  
Development Method ◽  
Transaction Scheduling ◽  
Report System ◽  
Entity Relationship ◽  
Entity Relationship Diagram ◽  
Web Based System

Futsal sports have developed and are popular in Indonesia. Sumber Jaya Futsal is one of the providers of futsal field rental business in Tangerang. Sumber Jaya Futsal currently does not have a web-based system, the system for leasing futsal fields in Sumber Jaya Futsal is still conventional, where customers come directly or by calling to find out the schedule of available futsal fields. The rental transaction scheduling and report system is still using a notebook. Based on the problem, the purpose of this research is to produce a draft web application for futsal field rental at Sumber Jaya Futsal Tangerang. In this study to collect data the author uses case studies with methods of observation and literature. The design of this web application is made using the PHP programming language, assisted by xampp as a web server, MySQL for database management, ERD (Entity Relationship Diagram) and LRS (Logical Record Structure) to describe the data model. While the author's software development method uses the Waterfall Method.

Mapping Generalizations and Specializations and Categories to Relational Databases

2009 ◽  
pp. 1-11
Author(s):  
Sikha Bagui
Keyword(s):  
Relational Databases ◽  
Web Data ◽  
Structural Validity ◽  
Short Article ◽  
Database Applications ◽  
Mapping Rules ◽  
Basic Concepts ◽  
Er Model ◽  
Entity Relationship

An Entity Relationship (ER) model that includes all the concepts of the original ER model and the additional concepts of generalizations/specializations and categories is often referred to as the Extended ER (EER) model (Elmasri & Navathe, 2007). With the rising complexity of database applications, and also in light of today’s web data applications (Necasky, 2006), the basic concepts of the ER model, as originally developed by Chen(1976), are no longer sufficient. Hence the basic ER model has been extended to include generalizations and specializations (Bagui & Earp, 2003; Elmasri & Navathe, 2007), and the concept of categories (Elmasri, et al., 1985). In this short article we shed some light on these relationship concepts, concepts that database designers often find difficult to directly model (Engels et al., 1992/93). We also discuss the mapping rules for generalizations/specializations and categories. Important contributions in this area are also reported in (Elmasri et al., 1985; Gogolla & Hohenstein, 1991; Markowitz & Shoshani, 1992; Dey, et. al., 1999). Dullea, et. al. (2003) discusses the structural validity of modeling structures with ER models.

Data Modeling and Workflow Analysis of Cyber-Manufacturing Systems

2020 ◽  
Author(s):  
Zhengyi Song ◽  
Young Moon
Keyword(s):  
Data Model ◽  
Manufacturing Systems ◽  
Data Modeling ◽  
Web Based ◽  
Manufacturing Intelligence ◽  
Main Driver ◽  
Manufacturing Resources ◽  
Generic Data Model ◽  
Factory Of The Future ◽  
Entity Relationship

Abstract Cyber-Manufacturing System (CMS) is a vision for the factory of the future, where physical manufacturing resources and processes are integrated with computational workflows to provide on-demand, adaptive, and scalable manufacturing services. In CMS, functional manufacturing components in a factory floor are digitized and encapsulated in production services; and are accessible by users throughout the network. CMS utilizes data-centric technologies to program manufacturing activities in factory floors. Leveraging advanced technologies, CMS can provide robust solutions to achieve better manufacturing agility, flexibility, scalability, and sustainability than from traditional factories. While data is the main driver of the manufacturing activities in CMS, the lack of (i) a generic data model of explicit representation of the entities and stakeholders in CMS and (ii) workflow definition and analysis for service-orientated functionalities and manufacturing intelligence of CMS is still hindering the implementation of a fully executable CMS. To address such problems, this paper (i) formalizes a data modeling of CMS using Entity-Relationship (E-R) diagram, (ii) presents the definition and analysis of workflows along with data pipelines and Extract/Transform/Load (ETL) processes that automate the entire lifecycle activities in CMS and (iii) deploys the proposed data model and workflows in a Web-based application, and (iv) tests the functionality of this application with an industrial case and eventually validates the proposed data model and workflows.

Sign in / Sign up

Export Citation Format

Share Document