A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
Filters
An Improved Generic ER Schema for Conceptual Modeling of Information Systems
[article]
2020
arXiv
pre-print
Preserved Fulltext
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]
2004
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2008; you can also visit the original URL.
The file type is application/pdf.
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
1994
ACM Transactions on Database Systems
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2001; you can also visit the original URL.
The file type is application/pdf.
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]
2006
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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]
1995
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2007; you can also visit the original URL.
The file type is application/pdf.
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
2015
International Journal of Database Theory and Application
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2018; you can also visit the original URL.
The file type is application/pdf.
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
2006
Data & Knowledge Engineering
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2008; you can also visit the original URL.
The file type is application/pdf.
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
2019
IEEE Access
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
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]
2006
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2014
Proceedings of the 2014 Federated Conference on Computer Science and Information Systems
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2017
Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
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
2009
2009 XXIII Brazilian Symposium on Software Engineering
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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]
2005
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
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
2011
Proceedings of the 2011 15th International Conference on Computer Supported Cooperative Work in Design (CSCWD)
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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]
2020
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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