Filters








20,044 Hits in 4.4 sec

Schema merging and mapping creation for relational sources

Rachel Pottinger, Philip A. Bernstein
2008 Proceedings of the 11th international conference on Extending database technology Advances in database technology - EDBT '08  
We address the problem of generating a mediated schema from a set of relational data source schemas and conjunctive queries that specify where those schemas overlap.  ...  Unlike past approaches that generate only the mediated schema, our algorithm also generates view definitions, i.e., source-to-mediated schema mappings.  ...  The input to mediated schema creation consists of relation schemas for the data sources and a set of overlap specifications, which are conjunctive queries.  ... 
doi:10.1145/1353343.1353357 dblp:conf/edbt/PottingerB08 fatcat:lhqbvnbnsnelzcaqbi5vpmlnaa

Schema merging and mapping creation for relational sources

Rachel Pottinger, Philip A. Bernstein
2008 Proceedings of the 11th international conference on Extending database technology Advances in database technology - EDBT '08  
We address the problem of generating a mediated schema from a set of relational data source schemas and conjunctive queries that specify where those schemas overlap.  ...  Unlike past approaches that generate only the mediated schema, our algorithm also generates view definitions, i.e., source-to-mediated schema mappings.  ...  The input to mediated schema creation consists of relation schemas for the data sources and a set of overlap specifications, which are conjunctive queries.  ... 
doi:10.1145/1352431.1352445 fatcat:bvkh6cp3yje7paixoy3zph5ywm

A relational-XML data warehouse for data aggregation with SQL and XQuery

Joseph Fong, Herbert Shiu, Davy Cheung
2008 Software, Practice & Experience  
Integration of multiple data sources is becoming increasingly important for enterprises that cooperate closely with their partners for e-commerce.  ...  SQL and XQuery can be used to process the materialized relational and XML data cubes of aggregated data.  ...  Merge entities by generalization Merge entities by aggregation The integrated metadata schema is mapped with heterogeneous source schemas and presented as a simple database schema in the middleware.  ... 
doi:10.1002/spe.868 fatcat:tuq6y5atajb5rghbhlibld5hdi

A framework for semantic grouping in P2P databases

Verena Kantere, Dimitrios Tsoumakos, Timos Sellis
2008 Information Systems  
Considering a source schema S and a target schema S ′ , a GAV/LAV/GLAV mapping between them M(S, S ′ ) is the set {Cr M (S, S ′ ),Cond M (S, S ′ )}, where the set of concept correspondences Cr M (S, S  ...  ′ Obviously, for each pair of concepts {R.A, R ′ .A ′ } that each belong to a different schema, R.A ∈ S and R ′ .A ′ ∈ S ′ , and that are corresponded through a mapping M(S, S ′ ), there is one such pair  ...  The project is cofinanced 75% of public expenditure through EC -European Social Fund, 25% of public expenditure through Ministry of Development -General Secretariat of Research and Technology and through  ... 
doi:10.1016/j.is.2008.01.011 fatcat:3ie5el7auzd5rivn6i4or5hguq

DYNAMERGE: A MERGING ALGORITHM FOR STRUCTURED DATA INTEGRATION ON THE WEB

FRANÇOIS SCHARFFE
2007 Advances in Scalable Web Information Integration and Service  
Based on a network of schemas (database schemas, ontologies) related via mappings our algorithm generates a global view over a set of resources.  ...  We propose in this article a method allowing for the dynamic integration of data sources on the web.  ...  The merged schema G get the result of merge that take as a parameter a source schema O s , a target schema O t and a mapping between the two schemas M ap s,t .  ... 
doi:10.1142/9789812770240_0009 fatcat:kpdrh4dusnfmnaczwhdbviytiq

Unity: Speeding the creation of community vocabularies for information integration and reuse

Ken Smith, Peter Mork, Len Seligman, Peter Leveille, Beth Yost, Maya Li, Chris Wolf
2011 2011 IEEE International Conference on Information Reuse & Integration  
This paper presents Unity, a novel tool for speeding the development of a community vocabulary, which includes both a standard schema and the necessary mappings.  ...  Unfortunately, creation of these standards and the mappings to the enterprise's implemented systems is both time consuming and expensive.  ...  For any two source concepts and , we generate a mapping where denotes the similarity between concepts and .  ... 
doi:10.1109/iri.2011.6009534 dblp:conf/iri/SmithMSLYLW11 fatcat:zlc2s3us2vd5xcrwa4wrek6onu

Automatic schema merging using mapping constraints among incomplete sources

Xiang Li, Christoph Quix, David Kensche, Sandra Geisler
2010 Proceedings of the 19th ACM international conference on Information and knowledge management - CIKM '10  
In this paper, we present a novel approach for merging multiple relational data sources related by a collection of mapping constraints in the form of P2P style tuple-generating dependencies (tgds).  ...  Under Open World Assumption (OWA), we characterize the semantics of schema merging by properties of the output mapping system between the source schemas and the mediated schema.  ...  Acknowledgements: The authors are grateful to the anonymous referees for comments helping to improve the paper.  ... 
doi:10.1145/1871437.1871479 dblp:conf/cikm/LiQKG10 fatcat:kn2vw6ryaveb7fh3f3ozvvcrtu

Constraint-based Query Distribution Framework for an Integrated Global Schema [article]

Ahmad Kamran Malik, Muhammad Abdul Qadir, Nadeem Iftikhar, and Muhammad Usman
2010 arXiv   pre-print
Constraints in global schema and mappings are used for source selection, query optimization,and querying partitioned and replicated data sources.  ...  Contributions include the use of constraints in our existing global schema which help in source selection and query optimization, and a global query distribution framework for querying distributed heterogeneous  ...  We extend this global schema creation approach by adding integrity constraints and validation rules in the global schema and mapping documents that are later used for source selection and query optimization  ... 
arXiv:1004.2155v1 fatcat:ypi2yeao6rdxzjrqmittndwwfm

Semi-Automatic Schema Integration in Clio

Laura Chiticariu, Mauricio A. Hernández, Phokion G. Kolaitis, Lucian Popa
2007 Very Large Data Bases Conference  
Extracting Concept Hierarchies Once mappings between source schemas are established, users can request the creation of integrated schemas.  ...  The schema integration system is built in conjunction with Clio [7] , a schema mapping system that produces a declarative mapping specification describing the relationship between a source and a target  ... 
dblp:conf/vldb/ChiticariuHPK07 fatcat:7hfuv4jpd5eg5bote7ib2yklfa

Data Interoperability and Curation: The European Film Gateway Experience [chapter]

Michele Artini, Alessia Bardi, Federico Biagini, Franca Debole, Sandro La Bruzzo, Paolo Manghi, Marko Mikulicic, Pasquale Savino, Franco Zoppi
2013 Communications in Computer and Information Science  
EFG designed a common data model for movie information, onto which archives data models can be optimally mapped.  ...  These mainly concerned the curation and interoperability issues derived by the need of aggregating metadata from heterogeneous archives (different data models, hence metadata schemas, and exchange formats  ...  Its completion would have not been possible without the precious cooperation of Marco Rendina (Istituto Luce, Italy), Georg Eckes and Francesca Schultze (Deutsches Filminstitut, Germany) for the design  ... 
doi:10.1007/978-3-642-35834-0_6 fatcat:4uihtvu5ajh6rgqejnu5dr5taa

Dimensions of Dataspaces [chapter]

Cornelia Hedeler, Khalid Belhajjame, Alvaro A. A. Fernandes, Suzanne M. Embury, Norman W. Paton
2009 Lecture Notes in Computer Science  
The vision of dataspaces has been articulated as providing various of the benefits of classical data integration, but with reduced upfront costs, combined with opportunities for incremental refinement,  ...  capture both the components that a dataspace management system may contain and the lifecycle it may support, and uses these dimensions to characterise representative proposals.  ...  As this is a hard task, various simplifying assumptions are made: the source schemas are limited to relational schemas with a single relation, and for the purpose of managing uncertainty, the sources are  ... 
doi:10.1007/978-3-642-02843-4_8 fatcat:lyz5ks3anzh73e5vn5c6dhgaba

Schema Evolution and Reproducibility of Long-term Hydrographic Data Sets at the IOW

Tanja Auge, Erik Manthey, Susanne Jürgensmann, Susanne Feistel, Andreas Heuer
2020 Lernen, Wissen, Daten, Analysen  
It classifies well-known schema evolution operators which can be expressed as schema mappings, and defines two new operators for merging and splitting attributes, up to now not considered in other research  ...  These operators have proven to be essential for development of a new universal schema for the central oceanographic database on the IOW -the IOWDB.  ...  Since we already developed formal techniques based on schema mappings (such as s-t tgds, i.e. source-to-target tuple-generating dependencies) [8] for steps (1) and (3), we have to integrate schema  ... 
dblp:conf/lwa/AugeMJF020 fatcat:hxls7ft7andyflaq2d3ixtblj4

DSToolkit: An Architecture for Flexible Dataspace Management [chapter]

Cornelia Hedeler, Khalid Belhajjame, Lu Mao, Chenjuan Guo, Ian Arundale, Bernadette Farias Lóscio, Norman W. Paton, Alvaro A. A. Fernandes, Suzanne M. Embury
2012 Lecture Notes in Computer Science  
mappings over all sources including the new one.  ...  The user feedback gathered is utilised for improvement by annotating, selecting and refining mappings.  ...  The presented approach where the data remains in the sources, however, is not the only option for a dataspace system.  ... 
doi:10.1007/978-3-642-28148-8_6 fatcat:vi34ldrb45gvlg7rry3oy45gm4

Mapping-driven XML transformation

Haifeng Jiang, Howard Ho, Lucian Popa, Wook-Shin Han
2007 Proceedings of the 16th international conference on World Wide Web - WWW '07  
We present a three-phase framework for highperformance XML-to-XML transformation based on schema mappings, and discuss methodologies and algorithms for implementing these phases.  ...  ., generating target data from the source data based on schema mappings).  ...  For phase one, relational data sources are stored in relational tables and accessed through JDBC.  ... 
doi:10.1145/1242572.1242715 dblp:conf/www/JiangHPH07 fatcat:tolptkegc5ga5dirue75pwhtfa

PORSCHE: Performance ORiented SCHEma mediation

Khalid Saleem, Zohra Bellahsene, Ela Hunt
2008 Information Systems  
Semantic matching of schemas in heterogeneous data sharing systems is time consuming and error prone. Existing mapping tools employ semi-automatic techniques for mapping two schemas at a time.  ...  We report on experiments with up to 80 schemas containing 83,770 nodes, with our prototype implementation taking 587 seconds on average to match and merge them, resulting in an integrated schema and returning  ...  Acknowledgements: ZB is supported by ANR-05-MMSA-007 and EH is funded by an EU Marie Curie Fellowship.  ... 
doi:10.1016/j.is.2008.01.010 fatcat:74gcuy2cr5cd7amaehcizd3zfq
« Previous Showing results 1 — 15 out of 20,044 results