An overview of query optimization in relational systems
PODS '98 Proceedings of the seventeenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Principles of distributed database systems (2nd ed.)
Principles of distributed database systems (2nd ed.)
A distributed scientific data archive using the Web, XML and SQL/MED
ACM SIGMOD Record
An Architecture for Managing Distributed Scientific Resources
SSDBM '02 Proceedings of the 14th International Conference on Scientific and Statistical Database Management
Integrating Distributed Scientific Data Sources with MOCHA and Xroaster
SSDBM '01 Proceedings of the 13th International Conference on Scientific and Statistical Database Management
Data Mining: Concepts and Techniques
Data Mining: Concepts and Techniques
WIDM '06 Proceedings of the 8th annual ACM international workshop on Web information and data management
Fundamentals of Database Systems (5th Edition)
Fundamentals of Database Systems (5th Edition)
Referential integrity quality metrics
Decision Support Systems
Estimating and bounding aggregations in databases with referential integrity errors
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Consistency-aware evaluation of OLAP queries in replicated data warehouses
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Extended aggregations for databases with referential integrity issues
Data & Knowledge Engineering
Measuring consistency with respect to topological dependency constraints
Proceedings of the 18th SIGSPATIAL International Conference on Advances in Geographic Information Systems
Hi-index | 0.00 |
Distributed relational databases are used by different organizations located at multiple sites that work together on common projects. In this article, we focus on distributed relational databases with incomplete and inconsistent content. We propose to measure referential integrity errors in them for integration and interoperability purposes. We propose local and global referential integrity metrics at three levels: column, table and database. We assume each table can be asynchronously updated at any site and new records are periodically broadcasted to all sites. We explain several distributed query optimization issues. Our proposal is useful in database integration, multiple database interoperability and data quality assurance. We discuss applications of our proposal in distributed scientific databases.