专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08180748B2 Surrogate key generation and utilization 有权
标题翻译：替代密钥生成和利用
公开(公告)号：US08180748B2
公开(公告)日：2012-05-15
申请号：US12876010
申请日：2010-09-03
申请人： Donald M. Farmer
发明人： Donald M. Farmer
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30595
摘要： The subject disclosure pertains to databases as well as generation and utilization of keys. A desired or default number of values can be requested from a domain and allocated for use. These values can be utilized to generate surrogate keys. Subsequently or concurrently, the keys can be employed with respect to operations such as single pass loading of databases and/or data warehouses. Any unused keys can be returned and made available for use by other users or processes. Furthermore, the key generation functionality can be provided outside a database thereby relieving a database system of this burden.
摘要翻译：主题公开涉及数据库以及密钥的生成和利用。可以从域请求所需或默认的值，并分配使用。这些值可用于生成代理键。随后或同时地，可以对诸如数据库和/或数据仓库的单次加载的操作使用密钥。任何未使用的密钥都可以返回，并可供其他用户或进程使用。此外，密钥生成功能可以在数据库之外提供，从而减轻数据库系统的这种负担。

2. 发明授权

US07844570B2 Database generation systems and methods 失效
标题翻译：数据库生成系统和方法
公开(公告)号：US07844570B2
公开(公告)日：2010-11-30
申请号：US11074508
申请日：2005-03-08
申请人： Amir Netz , Paul J. Sanders , Donald M. Farmer , Kenneth Kwok , Ovidiu Burlacu
发明人： Amir Netz , Paul J. Sanders , Donald M. Farmer , Kenneth Kwok , Ovidiu Burlacu
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30592
摘要： The subject invention pertains to systems and methods that facilitate generation of a database to support a multidimensional model. A database schema is generated in a top-down fashion. In particular, multidimensional structures and attributes such as cubes and dimensions can be defined. From such definition, a proposed database schema can be produced. This schema can subsequently be modified prior to or after populating the database. For example, a table or column could be added. Thereafter, the cubes and dimensions could be altered and a modified schema generated that preserves changes made to the schema. Accordingly, the subject systems and methods disclose an iterative approach that supports both top-down and bottom-up multidimensional database design.
摘要翻译：本发明涉及促进数据库生成以支持多维模型的系统和方法。以自顶向下的方式生成数据库模式。特别地，可以定义多维结构和属性，例如立方体和维度。从这样的定义可以产生一个提出的数据库模式。随后可以在填充数据库之前或之后修改此模式。例如，可以添加表或列。此后，可以修改立方体和维度，并生成修改后的模式，以保留对模式所做的更改。因此，主题系统和方法公开了支持自上而下和自下而上的多维数据库设计的迭代方法。

3. 发明授权

US07801844B2 Surrogate key generation and utilization 有权
标题翻译：替代密钥生成和利用
公开(公告)号：US07801844B2
公开(公告)日：2010-09-21
申请号：US11286623
申请日：2005-11-23
申请人： Donald M. Farmer
发明人： Donald M. Farmer
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30595
摘要： The subject disclosure pertains to databases as well as generation and utilization of keys. A desired or default number of values can be requested from a domain and allocated for use. These values can be utilized to generate surrogate keys. Subsequently or concurrently, the keys can be employed with respect to operations such as single pass loading of databases and/or data warehouses. Any unused keys can be returned and made available for use by other users or processes. Furthermore, the key generation functionality can be provided outside a database thereby relieving a database system of this burden.
摘要翻译：主题公开涉及数据库以及密钥的生成和利用。可以从域请求所需或默认的值，并分配使用。这些值可用于生成代理键。随后或同时地，可以对诸如数据库和/或数据仓库的单次加载的操作使用密钥。任何未使用的密钥都可以返回，并可供其他用户或进程使用。此外，密钥生成功能可以在数据库之外提供，从而减轻数据库系统的这种负担。

4. 发明授权

US07565335B2 Transform for outlier detection in extract, transfer, load environment 有权
标题翻译：在提取，传输，加载环境中进行异常值检测
公开(公告)号：US07565335B2
公开(公告)日：2009-07-21
申请号：US11375850
申请日：2006-03-15
申请人： ZhaoHui Tang , Donald M. Farmer , C. James MacLennan
发明人： ZhaoHui Tang , Donald M. Farmer , C. James MacLennan
IPC分类号： G06E1/00
CPC分类号： G06N7/005 , Y10S707/99936
摘要： Systems and methods that cleanse data in Extract, Transform, Load environments (ETL), via employing an outlier detect component that is positioned in data pipeline to data warehouse(s). Such outlier detect component employs a cluster mining model to split data into normal and outlier data. Different predictive models can be employed to detect outliers in different data slices to enhance the accuracy of the predictions. In addition, a graphical user interface (GUI) enables a user to interact with cluster groups that are created and/or analyzed by the outlier detect component.
摘要翻译：通过采用位于数据管道到数据仓库的异常值检测组件，在Extract，Transform，Load Environment（ETL）中清除数据的系统和方法。这种异常检测组件采用集群挖掘模型将数据分解为正常数据和异常数据。可以采用不同的预测模型来检测不同数据片段中的异常值，以提高预测的准确性。此外，图形用户界面（GUI）使得用户能够与异常值检测组件创建和/或分析的群集组进行交互。

5. 发明申请

US20100332463A1 SURROGATE KEY GENERATION AND UTILIZATION 有权
标题翻译：主要产生和利用现状
公开(公告)号：US20100332463A1
公开(公告)日：2010-12-30
申请号：US12876010
申请日：2010-09-03
申请人： Donald M. Farmer
发明人： Donald M. Farmer
IPC分类号： G06F17/30
CPC分类号： G06F17/30595
摘要： The subject disclosure pertains to databases as well as generation and utilization of keys. A desired or default number of values can be requested from a domain and allocated for use. These values can be utilized to generate surrogate keys. Subsequently or concurrently, the keys can be employed with respect to operations such as single pass loading of databases and/or data warehouses. Any unused keys can be returned and made available for use by other users or processes. Furthermore, the key generation functionality can be provided outside a database thereby relieving a database system of this burden.
摘要翻译：主题公开涉及数据库以及密钥的生成和利用。可以从域请求所需或默认的值，并分配使用。这些值可用于生成代理键。随后或同时地，可以对诸如数据库和/或数据仓库的单次加载的操作使用密钥。任何未使用的密钥都可以返回，并可供其他用户或进程使用。此外，密钥生成功能可以在数据库之外提供，从而减轻数据库系统的这种负担。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式