发明申请
US20110307472A1 SYSTEM AND METHOD FOR MANAGING METADATA IN A RELATIONAL DATABASE
有权
在关系数据库中管理元数据的系统和方法
- 专利标题: SYSTEM AND METHOD FOR MANAGING METADATA IN A RELATIONAL DATABASE
- 专利标题(中): 在关系数据库中管理元数据的系统和方法
-
申请号: US13160451申请日: 2011-06-14
-
公开(公告)号: US20110307472A1公开(公告)日: 2011-12-15
- 发明人: Dominik Slezak , Graham Toppin , Marcin Kowalski , Arkadiusz Wojna
- 申请人: Dominik Slezak , Graham Toppin , Marcin Kowalski , Arkadiusz Wojna
- 申请人地址: CA Toronto
- 专利权人: INFOBRIGHT, INC.
- 当前专利权人: INFOBRIGHT, INC.
- 当前专利权人地址: CA Toronto
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
In a method for storing data in a relational database system using a processor, a collection of values is assigned to a structure dictionary, wherein each of the values represents the value of a row for an attribute and has a unique ordinal number within the collection, and wherein the structure dictionary contains structures defined based on at least one of interaction with a user of the system via an interface, automatic detection of structures occurring in data, and predetermined information about structures relevant to data content that is stored in the system. For each structure in the structure dictionary, a structure match list is formed from ordinal numbers of values matching the structure, and a structure sub-collection from values matching the structure, using the processor. An outlier match list is formed from ordinal numbers of values that are not null and do not match any structure in the structure dictionary, and an outlier sub-collection from values that are not null and do not match any structure in the structure dictionary. The collection of values is stored in the relational database in a form of structure match lists, structure sub-collections, outlier match list and outlier sub-collection.
公开/授权文献
信息查询