公开(公告)号：US06243704B1

公开(公告)日：2001-06-05

申请号：US09024126

申请日：1998-02-17

申请人： Isamu Ooishi

发明人： Isamu Ooishi

IPC分类号： G06R1730

CPC分类号： G06F17/2217 ,  Y10S707/99931

摘要： A business nonstandard character processing apparatus includes a plurality of work processing parts for carrying out processes using nonstandard character data registered in a system nonstandard character file, one or a plurality of nonstandard character files provided correspondence with work identification information, and a nonstandard character registration processing part registering as the nonstandard character file a nonstandard character file provided in correspondence with a specified work identification information.

摘要翻译： 业务非标准字符处理装置包括多个工作处理部件，用于使用非标准字符数据进行处理，所述非标准字符数据被登记在系统非标准字符文件中，一个或多个非标准字符文件与工作识别信息对应，以及非标准字符注册处理 将非标准字符文件注册为与指定的工作标识信息相对应地提供的非标准字符文件。

公开(公告)号：US06484163B1

公开(公告)日：2002-11-19

申请号：US09516524

申请日：2000-03-01

申请人： Andrew Martin Lawrence ,  Mark Steven Ramsey ,  David Alec Selby ,  Vincent Philip Thomas

发明人： Andrew Martin Lawrence ,  Mark Steven Ramsey ,  David Alec Selby ,  Vincent Philip Thomas

IPC分类号： G06R1730

CPC分类号： G06F17/30539 ,  G06F17/30421 ,  G06F2216/03 ,  Y10S707/954 ,  Y10S707/966 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99937

摘要： A technique for enhanced data mining of large scale relational databases is described. User defined functions (UDF) are created by a user and distributed by a managing node of a database to each node of the database. Upon the issuance of a prespecified SQL command, the UDF is executed by each node relative to the data controlled by each node. Specifically, targeted tuples in the data controlled by each node are scored based on criteria contained in the UDF. A new data field is added to each target tuple, and the score is placed therein. The score is then used to determine whether, for example, a customer which is represented by the tuple should be included in an advertising campaign or to tailor a mailing to a customer based on the score contained in the new data field.

摘要翻译： 描述了一种用于增强大型关系数据库的数据挖掘的技术。 用户定义的功能（UDF）由用户创建并由数据库的管理节点分发给数据库的每个节点。 在发出预先指定的SQL命令之后，每个节点相对于每个节点控制的数据执行UDF。 具体来说，根据UDF中包含的标准对每个节点控制的数据中的目标元组进行评分。 将新的数据字段添加到每个目标元组，并将得分置于其中。 然后，该分数用于确定例如，由元组表示的客户是否应包含在广告活动中，或者基于新数据字段中包含的分数来定制对客户的邮寄。

公开(公告)号：US06496828B1

公开(公告)日：2002-12-17

申请号：US09466862

申请日：1999-12-17

申请人： Roberta Jo Cochrane ,  James C. Kleewein ,  Ting Yu Leung ,  Mir Hamid Pirahesh ,  Narayana Subramanian ,  Shivakumar Venkataraman

发明人： Roberta Jo Cochrane ,  James C. Kleewein ,  Ting Yu Leung ,  Mir Hamid Pirahesh ,  Narayana Subramanian ,  Shivakumar Venkataraman

IPC分类号： G06R1730

CPC分类号： G06F17/30463 ,  G06F17/30457 ,  G06F17/30545 ,  Y10S707/971 ,  Y10S707/99933

摘要： A system, method, and article of manufacture for supporting summary tables in a distributed database environment is disclosed. The system generally comprises a central program and a plurality of remote database systems that may be heterogeneous. The central program is configured to communicate with the database systems and to support summary tables (also referred to as materialized views) within the central program or within one or more of the database systems. The summary tables may contain summary data from one or more of the database systems. The central program may initiate the generation of summary tables, which may be populated local to the central program or local to one or more of the database systems. The central program may also maintain or coordinate maintenance of the summary tables. In addition, the central program may be configured to receive user queries on one or more of the database systems and to generate optimized query plans based upon the user queries, considering in so doing, the summary tables.

摘要翻译： 公开了一种用于支持分布式数据库环境中的汇总表的系统，方法和制品。 该系统通常包括可以是异构的中央程序和多个远程数据库系统。 中央程序被配置为与数据库系统进行通信，并且支持中央程序内或在一个或多个数据库系统内的汇总表（也称为物化视图）。 汇总表可能包含来自一个或多个数据库系统的汇总数据。 中央程序可以启动汇总表的生成，其可以在中央程序本地填充或本地地填充到一个或多个数据库系统。 中央程序还可以维护或协调汇总表的维护。 此外，中央程序可以被配置为在一个或多个数据库系统上接收用户查询，并且基于用户查询来生成优化的查询计划，在这样做时，总结表。

公开(公告)号：US06633883B2

公开(公告)日：2003-10-14

申请号：US09736711

申请日：2000-12-13

申请人： Elie Ouzi Koskas

发明人： Elie Ouzi Koskas

IPC分类号： G06R1730

CPC分类号： G06F17/30595 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A reference table, which may not be stored, has columns associated with data attributes and rows containing related words assigned to those attributes in a collection of data. The stored data include at least one macroword thesaurus associated with an attribute and with a prefix length shorter than a word length of said attribute, and reference table row identifier lists respectively associated with thesaurus entries. Each macroword thesaurus associated with an attribute and with a prefix length has a respective entry for each prefix value having this prefix length and matching a corresponding prefix of at least one word assigned to this data attribute in the collection of data.

摘要翻译： 可能不存储的参考表具有与数据属性相关联的列和包含在数据集合中分配给这些属性的相关单词的行。 所存储的数据包括与属性相关联并具有比所述属性的字长短的前缀长度的至少一个宏词词库，以及分别与词库条目相关联的参考表行标识符列表。 与属性和前缀长度相关联的每个宏词词库具有对于具有该前缀长度的每个前缀值具有相应条目，并且在数据集合中匹配分配给该数据属性的至少一个字的相应前缀。

公开(公告)号：US06574619B1

公开(公告)日：2003-06-03

申请号：US09535905

申请日：2000-03-24

申请人： Venugopal P. Reddy ,  Harmindar S. Matharu

发明人： Venugopal P. Reddy ,  Harmindar S. Matharu

IPC分类号： G06R1730

CPC分类号： G06F17/30592 ,  G06F17/30539 ,  Y10S707/99932 ,  Y10S707/99943

摘要： A system for generating a value for a first attribute includes a database having one or more dimensions that each include one or more members. The database includes one or more storage locations that are each associated with one member from each dimension in a set of one or more of the dimensions. A server evaluates an expression including at least one second attribute that depends on a set of one or more of the dimensions, the expression mapping at least one member of a first dimension on which the first attribute depends to at least one member of a second dimension on which the second attribute depends. The value for the first attribute is generated according to the expression. The server and database may operate in an on-line analytical processing (OLAP) environment.

摘要翻译： 用于生成第一属性的值的系统包括具有一个或多个维度的数据库，每个维度各自包括一个或多个成员。 数据库包括一个或多个存储位置，每个存储位置与一个或多个维度的集合中的每个维度的一个成员相关联。 服务器评估包括依赖于一组或多个维度的至少一个第二属性的表达式，所述表达式映射第一维度的至少一个成员，其中第一属性依赖于第二维度的至少一个成员 第二个属性所依赖的。 第一个属性的值根据表达式生成。 服务器和数据库可以在在线分析处理（OLAP）环境中操作。

公开(公告)号：US06434558B1

公开(公告)日：2002-08-13

申请号：US09212238

申请日：1998-12-16

申请人： Stewart P. MacLeod ,  Casey L. Kiernan ,  Vij Rajarajan

发明人： Stewart P. MacLeod ,  Casey L. Kiernan ,  Vij Rajarajan

IPC分类号： G06R1730

CPC分类号： G06F17/30595 ,  Y10S707/99936 ,  Y10S707/99942

摘要： A system for tracking the lineage of data in a database. Data within the tables are tracked by attaching lineage information to the data, preferably, by adding a lineage identifier to each row in a table. Data that share a common lineage can be identified by virtue of sharing a common lineage identifier. The lineage identifier can then be used to trace the source of the data, i.e., data having a common identifier share a common history. Preferably, the lineage data type is an identifier that is universally unique and is optimized to provide little impact on the performance of the database. For example, by providing a sufficient size identifier to ensure its uniqueness while minimizing storage size. More preferably, the data lineage data type is a sixteen-byte number.

摘要翻译： 用于跟踪数据库中的数据谱系的系统。 通过将谱系信息附加到数据来跟踪表中的数据，优选地通过向表中的每一行添加谱系标识符来跟踪。 可以通过共享公共谱系标识符来识别共享谱系的数据。 然后可以使用谱系标识符来跟踪数据的来源，即具有共同标识符的数据共享共同的历史。 优选地，谱系数据类型是普遍唯一的标识符，并且被优化以对数据库的性能几乎没有影响。 例如，通过提供足够的大小标识符来确保其唯一性，同时最小化存储大小。 更优选地，数据谱系数据类型是十六字节数。