An object-oriented relational database
Communications of the ACM
Object-oriented modeling and design for database applications
Object-oriented modeling and design for database applications
Extracting schema from semistructured data
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
A distributed scientific data archive using the Web, XML and SQL/MED
ACM SIGMOD Record
Fundamentals of Database Systems with Cdrom and Book
Fundamentals of Database Systems with Cdrom and Book
Adding Structure to Unstructured Data
ICDT '97 Proceedings of the 6th International Conference on Database Theory
DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Using Schema Matching to Simplify Heterogeneous Data Translation
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Relational Databases for Querying XML Documents: Limitations and Opportunities
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
WIDM '06 Proceedings of the 8th annual ACM international workshop on Web information and data management
Referential integrity quality metrics
Decision Support Systems
DBDOC: querying and browsing databases and interrelated documents
Proceedings of the First International Workshop on Keyword Search on Structured Data
Keyword search across databases and documents
Proceedings of the 2nd International Workshop on Keyword Search on Structured Data
Visualizing metadata for environmental datasets
DCMI '10 Proceedings of the 2010 International Conference on Dublin Core and Metadata Applications
Catalogue manager for metadata dissemination in the NetTraveler middleware system
International Journal of Intelligent Information and Database Systems
Integrating and querying web databases and documents
Proceedings of the 20th ACM international conference on Information and knowledge management
Integrating and querying source code of programs working on a database
KEYS '12 Proceedings of the Third International Workshop on Keyword Search on Structured Data
Querying external source code files of programs connecting to a relational database
Proceedings of the 5th Ph.D. workshop on Information and knowledge
Hi-index | 0.00 |
A federated database consists of several loosely integrated databases, where each database may contain hundreds of tables and thousands of columns,interrelated by complex foreign key relationships. In general, there exists a lot of semistructured data elements outside the database represented by documents (files), created and updated by multiple users and programs. Documents have references to multiple databases and subsets of their tables and columns. Manually tracking which specific tables and columns are referred to by a document, accessed by a specific program or user is a daunting task. With such a goal in mind, we present a system that builds metadata models for a federated database using a relational database as a central object type and metadata repository. Metadata includes table and columns coming from logical data models corresponding to each database, as well as documents representing external semistructured data sources. SQL statements assemble metadata and data types to create objects and relationships as relational tables for easy querying. We discuss potential applications in federated scientific databases.