47,253 Hits in 7.3 sec

An Improved Generic ER Schema for Conceptual Modeling of Information Systems [article]

Dhammika Pieris, M.C Wijegunesekera, N. G. J. Dias
2020 arXiv   pre-print
The Entity-Relationship (ER) model is widely used for creating ER schemas for modeling application domains in the field of Information Systems development.  ...  We create a generic ER schema - an ER schema that represents any phenomena in symbolic form - and use it to show that a one-to-one mapping exists for any real-world application.  ...  Prefaces of a method for developing a Generic ER schema In our proposed model, the letter " " represents a regular entity type.  ... 
arXiv:2002.12482v1 fatcat:jo235wvt5jbpdbng7upy4wgygy

Resolving Schematic Discrepancy in the Integration of Entity-Relationship Schemas [chapter]

Qi He, Tok Wang Ling
2004 Lecture Notes in Computer Science  
values in entity-relationship (ER) schemas.  ...  We present algorithms to resolve schematic discrepancies by transforming metadata into entities, keeping the information and constraints of original schemas.  ...  Our approach is an extension to theirs by using ontology to provide semantics necessary for schema integration. In general, local schemas could be in different data models.  ... 
doi:10.1007/978-3-540-30464-7_20 fatcat:kgzdhiecyjglblqoavfb2tidea

Tools and transformations---rigorous and otherwise---for practical database design

Arnon Rosenthal, David Reiner
1994 ACM Transactions on Database Systems  
For a 1:1 relationship, a designer may declare which entity should be treated as the parent when creating a hierarchical schema from a network schema.  ...  Relationship parent: For a 1:n relationship, the parent is the entity on the 1 side.  ...  Each of the transformations below is defined for a single relationship and its incident entities. In general, a DDEW command applies several different transformations.  ... 
doi:10.1145/176567.176568 fatcat:4ekrov5vuvbhlfwkbur2s2uqze

Designing Quality XML Schemas from E-R Diagrams [chapter]

Chengfei Liu, Jianxin Li
2006 Lecture Notes in Computer Science  
Finally, a recursive algorithm is developed to transform an E-R diagram to a corresponding quality XML Schema.  ...  XML has emerged as the standard for representing, exchanging and integrating data on the Web.  ...  In ERD2XSD, we first generate XML schema elements for regular entity sets (Line 4-9) and ISA relationships (Line 10-14), then generate elements for all other entity sets (Line 15-26).  ... 
doi:10.1007/11775300_43 fatcat:l3lrqsh6zrcuzjczran427vclu

Resolving structural conflicts in the integration of Entity-Relationship schemas [chapter]

Mong Li Lee, Tok Wang Ling
1995 Lecture Notes in Computer Science  
This paper describes a different approach to integrate two Entity-Relationship (ER) schemas.  ...  We have an algorithm to transform an attribute in one schema into an equivalent entity type in another schema without any loss of semantics or functional dependencies which previous approaches have not  ...  a relationship set in another schema, (2) an entity type in one schema is modeled as a relationship set in another schema, (3) a relationship set in one schema is modeled as an attribute of an entity  ... 
doi:10.1007/bfb0020552 fatcat:5esybzg3snejbl6vdkfgmmmih4

μE – Automation Framework

Mohammad Almseidin, Khaled Alrfou
2015 International Journal of Database Theory and Application  
The Entity-Relationship and relational database schema are the most popular methodology for designing database.  ...  This paper aims to develop framework called μE that can help database designers for mapping ERdiagram to Relational database schema and vice versa. μE is an automation framework for mapping. μE framework  ...  Acknowledgements First and foremost all praises and thanks to Allah for giving us the ability to write this paper. We would like to thank Dr. Mustafa Hammad, for the guidance and support.  ... 
doi:10.14257/ijdta.2015.8.3.21 fatcat:cpxfka2ppnbezojo7syp73w5ny

An ontology based approach to the integration of entity–relationship schemas

Qi He, Tok Wang Ling
2006 Data & Knowledge Engineering  
We explicitly declare the context that is the meta information relating to the source, classification, property etc of entities, relationships or attribute values in entity-relationship (ER) schemas.  ...  We present algorithms to resolve schematic discrepancies by transforming metadata into the attribute values of entity types, keeping the information and constraints of original schemas.  ...  In particular, we give the general form of a FD on a relationship type of a transformed schema and the corresponding FDs in the original schema, and show that the FD of the transformed schema and the FDs  ... 
doi:10.1016/j.datak.2005.07.005 fatcat:f3efy5pixzdubfb72guj46yxd4

A Model-Driven Approach to Generate Schemas for Object-Document Mappers

Alberto Hernandez Chillon, Diego Sevilla Ruiz, Jesus Garcia Molina, Severino Feliciano Morales.
2019 IEEE Access  
The solution consists of a two-step model transformation chain, where an intermediate model is generated to ease the code generation.  ...  We show how schemas and other artifacts (e.g. validators and indexes) for ODMs can be automatically generated from inferred schemas.  ...  FIGURE 6 . 6 Entity differentiation model for the Album entity. FIGURE 7 . 7 Generated Mongoose schema for album and review entities. FIGURE 8 . 8 Generated Morphia schema for the Album entity.  ... 
doi:10.1109/access.2019.2915201 fatcat:75ondwvhyzam5ouuhh6wvtwpuu

The Transformational Approach to Database Engineering [chapter]

Jean-Luc Hainaut
2006 Lecture Notes in Computer Science  
logical design, schema integration, view derivation, schema equivalence, data conversion, reverse engineering, schema optimization, wrapper generation and others.  ...  In the database engineering realm, the merits of transformational approaches, that can produce in a systematic way correct, compilable and efficient database structures from abstract models, has long be  ...  The Generic Entity-Relationship Model (GER) The GER model, GER for short, is an extended Entity-relationship model that includes, among others, the concepts of schema, entity type, domain, attribute, relationship  ... 
doi:10.1007/11877028_4 fatcat:qofgggf4fjalzdacl6ag5cs6qe

Extended Entity-Relationship Approach in a Multi-Paradigm Information System Modeling Tool

Vladimir Dimitrieski, Milan Ćelikovič, Slavica Aleksic, Sonja Ristić, Ivan Luković
2014 Proceedings of the 2014 Federated Conference on Computer Science and Information Systems  
MIST components currently provide a formal specification of EER database schema specification and its transformation into the relational data model, or the class model.  ...  In this paper we present a Multi-Paradigm Information System Modeling Tool (MIST) that supports Extended Entity-Relationship (EER) approach to database design.  ...  Generated SQL and Java code VLADIMIR DIMITRIESKI ET AL.: EXTENDED ENTITY-RELATIONSHIP APPROACH interface elements. However, designers widely use EER approach for database schema modeling.  ... 
doi:10.15439/2014f239 dblp:conf/fedcsis/DimitrieskiCARL14 fatcat:mrizmorxbbht3bszdg7qmirwhq

An MDE Approach to Generate Schemas for Object-document Mappers

Diego Sevilla, Severino Feliciano, Jesús García-Molina
2017 Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development  
Then, NoSQL schema models are input to a two-step model transformation chain that generates schemas, validators and updating procedures, among other Mongoose artefacts.  ...  In this article, we present an MDE approach that automatically generates schemas and other artefacts for mappers.  ...  This transformation traverses an input NoSQL schema model and generates the corresponding PlantUML code for all the entities involved.  ... 
doi:10.5220/0006279102200228 dblp:conf/modelsward/SevillaMM17 fatcat:7aqbdaqagjgp3f47edeaeqwygq

A Framework for Modeling, Building and Maintaining Enterprise Information Systems Software

Alexandre Cláudio de Almeida, Glauber Boff, Juliano Lopes de Oliveira
2009 2009 XXIII Brazilian Symposium on Software Engineering  
The main ideas are to focus on the conceptual modeling of the three aspects of the EIS software -application functions, business rules, and database schema -and to automatically generate code for each  ...  An Enterprise Information System (EIS) software has three main aspects: data, which are processed to generate business information; application functions, which transform data into information; and business  ...  The transformation tool generates the SQL-DDL schema and also the stored procedures (SQL-DML) to manipulate instances of all entities and relationships of the conceptual schema (which are all converted  ... 
doi:10.1109/sbes.2009.24 dblp:conf/sbes/AlmeidaBO09 fatcat:s7euxcuo3vdt3hsamrmoz6zd7y

A General Approach to the Generation of Conceptual Model Transformations [chapter]

Nikolaos Rizopoulos, Peter Mçbrien
2005 Lecture Notes in Computer Science  
and formal framework for the generation of schema transformations.  ...  This is used as a basis for deriving transformations over high level models. The approach is demonstrated in this paper to generate transformations for ER and relational models.  ...  Generic Framework for Transformation Generation Based on the definitions in the previous section, we now define a generic framework for the integration of schemas irrespective of the high level conceptual  ... 
doi:10.1007/11431855_23 fatcat:35qt3oqgj5fe7lkhx2ijfrf2za

A light weight approach for ontology generation and change synchronization between ontologies and source relational databases

Waqas Ahmed, Muhammad Ahtisham Aslam, Jun Shen, Jianming Yong
2011 Proceedings of the 2011 15th International Conference on Computer Supported Cooperative Work in Design (CSCWD)  
Most of industrial data is present in relational databases and a relational database schema represents a domain model.  ...  An ontology built from this schema can represent concepts and relationships that are present in domain of discourse. However, databases are not static and their schema evolves over time.  ...  An example of these lost semantics is transformation of bridge table that is a result of many-to-many relationship between two entities.  ... 
doi:10.1109/cscwd.2011.5960076 dblp:conf/cscwd/AhmedASY11 fatcat:ygzbkwngsvg2pkqwbrrafunoki

ER model Partitioning: Towards Trustworthy Automated Systems Development [article]

Dhammika Pieris, M.C Wijegunesekera, N.G.J Dias
2020 arXiv   pre-print
In database development, a conceptual model is created, in the form of an Entity-relationship(ER) model, and transformed to a relational database schema (RDS) to create the database.  ...  For this purpose, we modified the ER model and the transformation algorithm resolving some deficiencies existed in them.  ...  According to [12] , if the information is preserved when a conceptual schema (e.g., ER model) is transformed to a logical schema (e.g., RDS) (forward transformation), the logical schema should be able  ... 
arXiv:2007.00999v1 fatcat:d4aa7nitwzhwxio4lhi6tpbqlm
« Previous Showing results 1 — 15 out of 47,253 results