公开(公告)号：US20090265335A1

公开(公告)日：2009-10-22

申请号：US12107141

申请日：2008-04-22

申请人： Virginia Hoffman ,  James M. McArdle

发明人： Virginia Hoffman ,  James M. McArdle

IPC分类号： G06F7/10 ,  G06F17/30

CPC分类号： G06F17/30592

摘要： A method, computer program product, and data processing system for computer-aided design of multidimensional data warehouse schemas are disclosed. A preferred embodiment of the present invention provides a software tool for identifying a latent star schema structure within an existing database. This software tool performs a heuristic analysis of the existing database schema to locate potential keys and measurement fields. Database tables within the existing schema are scored heuristically as to their suitability as fact tables based on the key candidates and measurement fields. For each fact table, other tables from the existing schema are identified as possible dimension tables. Data from the database is then used to test the suitability of the fact tables and dimension tables. The identified fact tables and their associated dimension tables are then reported to the user to reveal a basic star schema structure, which can be used as a basis for further design.

摘要翻译： 公开了一种用于多维数据仓库模式的计算机辅助设计的方法，计算机程序产品和数据处理系统。 本发明的优选实施例提供用于识别现有数据库内的潜在星型模式结构的软件工具。 该软件工具执行现有数据库模式的启发式分析，以定位潜在的键和测量字段。 现有架构中的数据库表根据关键候选人和测量领域的事实表启发式进行评分。 对于每个事实表，现有模式中的其他表被标识为可能的维度表。 然后使用数据库中的数据来测试事实表和维度表的适用性。 然后将识别的事实表及其相关的维度表报告给用户以显示基本星型模式结构，这可以用作进一步设计的基础。

公开(公告)号：US07856416B2

公开(公告)日：2010-12-21

申请号：US12107141

申请日：2008-04-22

申请人： Virginia Hoffman ,  James M. McArdle

发明人： Virginia Hoffman ,  James M. McArdle

IPC分类号： G06F17/30

CPC分类号： G06F17/30592

摘要： A method, computer program product, and data processing system for computer-aided design of multidimensional data warehouse schemas are disclosed. A preferred embodiment of the present invention provides a software tool for identifying a latent star schema structure within an existing database. This software tool performs a heuristic analysis of the existing database schema to locate potential keys and measurement fields. Database tables within the existing schema are scored heuristically as to their suitability as fact tables based on the key candidates and measurement fields. For each fact table, other tables from the existing schema are identified as possible dimension tables. Data from the database is then used to test the suitability of the fact tables and dimension tables. The identified fact tables and their associated dimension tables are then reported to the user to reveal a basic star schema structure, which can be used as a basis for further design.

摘要翻译： 公开了一种用于多维数据仓库模式的计算机辅助设计的方法，计算机程序产品和数据处理系统。 本发明的优选实施例提供用于识别现有数据库内的潜在星型模式结构的软件工具。 该软件工具执行现有数据库模式的启发式分析，以定位潜在的键和测量字段。 现有架构中的数据库表根据关键候选人和测量领域的事实表启发式进行评分。 对于每个事实表，现有模式中的其他表被标识为可能的维度表。 然后使用数据库中的数据来测试事实表和维度表的适用性。 然后将识别的事实表及其相关的维度表报告给用户以显示基本星型模式结构，这可以用作进一步设计的基础。