50,482 Hits in 4.4 sec

Re-engineering relational databases

Abdelsalam Maatuk, M. Akhtar Ali, Nick Rossiter
2011 Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications - ISWSA '11  
Besides, none of the existing proposals can be considered as a method for migrating an RDB into an objectrelational database.  ...  Database migration from the source into each of the targets is discussed and critically evaluated, including the semantic enrichment, schema translation and data conversion.  ...  translation, in which a source schema is enriched by semantics or recovered to a conceptual schema before being translated into a target schema.  ... 
doi:10.1145/1980822.1980839 dblp:conf/iswsa/MaatukAR11 fatcat:zi7kqzk2ebap5hmtysnl6pinye

R2RS: schema-based relational databases mapping to linked datasets

Ju Ri Kim, Sung Kook Han
2018 International Journal of Engineering & Technology  
for the translation of RDB to RDF: instance-based and schema-based mapping approaches.  ...  in RDB.Interpretation of SQL query result into JSON-LD format.Experiments show the schema-based mapping approach is a straightforward, succinct and efficient mapping method for RDB2RDF.Improvements/Applications  ...  Focusing on conceptual schema, the mapping method can realize seamless translation of RDB to RDF at schema level.  ... 
doi:10.14419/ijet.v7i2.33.13868 fatcat:63ejhu755vddtjz3xxmkxtg6ka

R2LD: Schema-based Graph Mapping of relational databases to Linked Open Data for multimedia resources data

Zhanfang Zhao, SungKook Han, JuRi Kim
2019 Multimedia tools and applications  
The translation of SPARQL queries into equivalent SQL queries is one of the crux issues in RDB2RDF [5, 8] . This paper proposes a noble and practical method based on schema translation for RDB2RDF.  ...  This paper proposes a noble and practical schema-based mapping method to populate Linked Open Data sets from relational databases for multimedia resources.  ..., which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a  ... 
doi:10.1007/s11042-019-7281-5 fatcat:gucb2iewmzbjrahehxzfajznti

Schema-Based Mapping Approach for Data Transformation to Enrich Semantic Web

Senthilselvan Natarajan, Subramaniyaswamy Vairavasundaram, Yuvaraja Teekaraman, Ramya Kuppusamy, Arun Radhakrishnan, Rashid A Saeed
2021 Wireless Communications and Mobile Computing  
The resultant mapped RDF graph presents the relational database in a conceptual schema and maintains the instance triples as data graph.  ...  Hence, in this paper, a novel schema-based RDB-RDF mapping method (relational database to Resource Description Framework) is proposed, which is an improvised version for transforming the relational database  ...  A noble mapping method that suits well for LOD at the conceptual level is schema-based RDB-RDF mapping.  ... 
doi:10.1155/2021/8567894 fatcat:g5s75rnakvg3vclflxqxevevbi

Domain-specific metamodels for heterogeneous information systems

J. Tan, C.A. Ewald, A. Zaslavsky, A. Bond
2003 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the  
Third, we develop our own methods of schema translation and schema mapping based on the domainspecific metamodel, capable of a significant degree of semiautomation for convenience and adherence to the  ...  We have developed a schema mapping framework that features domain-specific metamodels, metamodel-driven schema translation, and semiautomated schema mapping driven by the metamodel.  ...  Through such definitions, the schema translation method we developed lays the groundwork for schema mapping.  ... 
doi:10.1109/hicss.2003.1174885 dblp:conf/hicss/TanZEB03 fatcat:nklrd2higbbltly4363qhl2u3m

Algebra-to-SQL Query Translation for Spatio-Temporal Databases [chapter]

Mohammed Minout, Esteban Zimányi
2004 Lecture Notes in Computer Science  
In this paper we describe the Query Translator module that is in charge of transforming the queries expressed for the conceptual schema into an operational query for a target DBMS or GIS (e.g., an SQL  ...  It is composed of a Transformation module that translates a conceptual query into an equivalent logical query using only the concepts provided by the target software, and a Wrapper module that expresses  ...  Second, the logical query is rewritten into a query expressed with the Data Manipulation Language provided by the target system.  ... 
doi:10.1007/978-3-540-30075-5_87 fatcat:xguknazdhfbvvadjez76uuf5cu

Stones Falling in Water: When and How to Restructure a View–Based Relational Database [chapter]

Eladio Domínguez, Jorge Lloret, Ángel L. Rubio, María A. Zapata
2010 Lecture Notes in Computer Science  
We have proposed such a method, by means of a database evolution architecture (MeDEA) that makes use of database views.  ...  It is clear that any method that can reduce the impact that database modifications produce on application programs is valuable for software engineering processes.  ...  For example, after the change, the entity type department is translated to a relation schema instead of to a view.  ... 
doi:10.1007/978-3-642-15576-5_45 fatcat:k2qgyss2m5dozduwelttbad3fi

Sparql query processing in relational databases

Ju Ri Kim, Zhanfang Zhao, Sung Kook Han
2018 International Journal of Engineering & Technology  
This paper shows how to implement SPARQL endpoint in RDB using a conceptual level mapping approach.Methods/Statistical analysis: Many diverse approaches and related languages for mapping RDB to RDF have  ...  This paper analyzes these conventional mapping approaches and proposes a new approach based on schema mapping.  ...  This paper proposes a new modeling method based on schema translation for RDB to RDF.  ... 
doi:10.14419/ijet.v7i2.33.13860 fatcat:xoolr2gxdjfhvpka4wjrbzerj4

Elementary Translations: The Seesaws for Achieving Traceability Between Database Schemata [chapter]

Eladio Domínguez, Jorge Lloret, Ángel L. Rubio, María A. Zapata
2004 Lecture Notes in Computer Science  
In this paper we introduce the notions of translation rule and elementary translation which are used within a forward database maintenance strategy.  ...  This framework can also be applied in the context of metadata management for database evolution, in which transformations are needed both to translate schemata from one level to another and to modify existing  ...  entity type primary key attribute into a column of a subtype table ETT60 translation of a conceptual primary key into a logical primary key ETT62 translation of a conceptual primary key into a primary  ... 
doi:10.1007/978-3-540-30466-1_35 fatcat:ai2iqxonubdd7cwjo3nekdp36u

On the design and maintenance of optimized relational representations of entity-relationship schemas

Marco A. Casanova, Luiz Tucherman, Alberto H.F. Laender
1993 Data & Knowledge Engineering  
A method for obtaining optimized relational representations of database conceptual schemas in an extended entity-relationship model is first proposed.  ...  Then, a redesign method that, given changes to the conceptual schema, generates a plan to modify the original representation and to organize the database state is described.  ...  We Optimized relational representations of E-R schemas 19 would also like to thank Alexandre Plastino Carvalho, Lorenzo Ridolfi, Mauricio Roma Cavalcanti and Jos6 Carlos Magno for the implementation  ... 
doi:10.1016/0169-023x(93)90043-o fatcat:hhfuclia3bdbbcvvg4ewzzndvy

Local query translation and optimization in a distributed system

Emmanuel Onuegbe, Said Rahimi, Alan R. Hevner
1983 Proceedings of the May 16-19, 1983, national computer conference on - AFIPS '83  
The technique is new in that it does not translate each relational command in isolation, but rather attempts to find a collection of relational commands for which an optimized sequence of CODASYL DML commands  ...  The algorithm translates local queries expressed in representational schemas (relational) to their equivalent internal schemas (network).  ...  A compiled query is stored in the data dictionary for execution at a later time. There are two approaches for translating relational commands into network DML statements.  ... 
doi:10.1145/1500676.1500705 dblp:conf/afips/OnuegbeRH83 fatcat:ogvtxdlfkvbhlhc3kdpblqqghq

Conceptual Design of Data Warehouse using Hybrid Methodology

Sekhar Reddy G
2020 International Journal of Advanced Trends in Computer Science and Engineering  
schemas that are reconciled with data sources to improvise the conceptual quality.  ...  Furthermore, the proposed system introduces and illustrates an automatic design technique based on a logical programming to perform the integration of different data sources using UML multidimensional  ...  Root = newVertex (pk (F)); \\ Fact class F translate (F, identifier (F)) where translate (E, v): \\ E be the current entity, V be the current vertex { for each attribute aϵE do addchild (v, a); \\ a be  ... 
doi:10.30534/ijatcse/2020/13932020 fatcat:wgejc3mgbrf25bmgeypy3xmy2y

A normal form object-oriented entity relationship diagram [chapter]

Tok Wang Ling, Pit Koon Teo
1994 Lecture Notes in Computer Science  
The third approach treats each 00 schema as au external schema of a conceptual schema represented by a normal form OOER diagram.  ...  Three approaches are described to translate good quality 00 schemas from a normal form OOER diagram.  ...  For example, the entity type EMPLOYEE has a method (derived attribute) called Pge() in the conceptual schema; this method can be included in the class EMPLOYEE in the external schema.  ... 
doi:10.1007/3-540-58786-1_83 fatcat:dn76xe475vbhvj2gxx3ru4qem4

Automatic Translation of Heterogeneous Data Models

Sheneela Naz, Yasir Majeed, Amir Qayyum
2012 International Journal of Computer and Communication Engineering  
Schema translation is the process of transforming schemas in heterogeneous data models into a single target data model. Today there exist various data models to save useful data.  ...  Our approach translates the schema and data of one model to the target schema and data. We use the concept of metadictionary to achieve translation.  ...  This system provides the convenient method for data conversion into another model. However if a new model needed to be translated into another model, we have to define new rules for translation.  ... 
doi:10.7763/ijcce.2012.v1.11 fatcat:vqxxxg3rbnavxpdw2gqa3zfkf4

Strategy for Database Application Evolution: The DB-MAIN Approach [chapter]

Jean-Marc Hick, Jean-Luc Hainaut
2003 Lecture Notes in Computer Science  
In the second phase, this logical schema is transformed into a conceptual one that is the basis for modification activities.  ...  In the first one, the different parts of the original database are analysed to obtain a logical schema for the implemented physical schema.  ...  A second set of schema modifications includes the most useful conceptual-to-logical transformations for relational schemas [12] .  ... 
doi:10.1007/978-3-540-39648-2_24 fatcat:oawy44guo5a5vkiuh6lw74ekr4
« Previous Showing results 1 — 15 out of 50,482 results