A Referential Integrity Browser for Distributed Databases
A Referential Integrity Browser for Distributed Databases
复制标题
分布式数据库的引用完整性浏览器
DOI：
--
复制
发表时间：
2009
期刊：
影响因子：
--
通讯作者：
Carlos Garcia
中科院分区：
文献类型：
--
作者：
C. Ordonez;Javier García;Rogelio Montero;Carlos Garcia
我们演示了一个程序，可以检查分布式关系数据库在互联网上发现和量化的引用完整性问题的集成目的。该程序在四个粒度级别计算引用完整性的数据质量度量：数据库，表，列和值，从全局到详细视图，展示有关引用错误的特定证据。两个正交的数据质量维度被认为是：完整性和一致性。每个表都存储在一个主站点上，并且可以在多个站点上复制，具有指向同一站点或不同站点上的表的外键引用。用户可以选择其他查询评估策略来精确地计算引用错误度量。我们的建议可以用于数据集成，数据仓库和数据质量保证。
We demonstrate a program that can inspect a distributed relational database on the Internet to discover and quantify referential integrity issues for integration purposes. The program computes data quality metrics for referential integrity at four granularity levels: database, table, column and value, going from a global to a detailed view, exhibiting specific evidence about referential errors. Two orthogonal data quality dimensions are considered: completeness and consistency. Each table is stored at one primary site and it can be replicated at multiple sites, having foreign key references to tables at the same site or at dierent sites. The user can choose alternative query evaluation strategies to eciently compute referential error metrics. Our proposal can be used in data integration, data warehousing and data quality assurance.