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

1. 发明授权

US07480662B2 Fact table storage in a decision support system environment 有权
标题翻译：事实表存储在决策支持系统环境中
公开(公告)号：US07480662B2
公开(公告)日：2009-01-20
申请号：US10719819
申请日：2003-11-20
申请人： Dmitry Potapov , Vishwanath Karra , Amit Ganesh , Jonathan Klein
发明人： Dmitry Potapov , Vishwanath Karra , Amit Ganesh , Jonathan Klein
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99932 , Y10S707/99943
摘要： A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.
摘要翻译：事实表设置没有任何维度列。表中的数据按照与尺寸顺序对应的顺序进行排序。该表被分成对应于数据的连续部分的段。包含度量值的非空值的表的部分被放入段中。可以根据数据中的不连续密度来确定段和位置段的大小。索引的有组织的表用于确定表的每个段的开始和结束，数据中的不连续性的位置，以及便于访问表的度量。

2. 发明申请

US20050004936A1 Fact table storage in a decision support system environment 有权
标题翻译：事实表存储在决策支持系统环境中
公开(公告)号：US20050004936A1
公开(公告)日：2005-01-06
申请号：US10719819
申请日：2003-11-20
申请人： Dmitry Potapov , Vishwanath Karra , Amit Ganesh , Jonathan Klein
发明人： Dmitry Potapov , Vishwanath Karra , Amit Ganesh , Jonathan Klein
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99932 , Y10S707/99943
摘要： A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.
摘要翻译：事实表设置没有任何维度列。表中的数据按照与尺寸顺序相对应的顺序进行排序。该表被分成对应于数据的连续部分的段。包含度量值的非空值的表的部分被放入段中。可以根据数据中的不连续密度来确定段和位置段的大小。索引的有组织的表用于确定表的每个段的开始和结束，数据中的不连续性的位置，以及便于访问表的度量。

3. 发明申请

US20050256908A1 Transportable database 有权
标题翻译：可运输数据库
公开(公告)号：US20050256908A1
公开(公告)日：2005-11-17
申请号：US10966961
申请日：2004-10-15
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander Hwang , Steven Wertheimer , Francisco Sanchez , Dmitry Potapov , Shen-Ban Meng , Juan Loaiza , William Bridge , J. Lee
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander Hwang , Steven Wertheimer , Francisco Sanchez , Dmitry Potapov , Shen-Ban Meng , Juan Loaiza , William Bridge , J. Lee
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30569 , Y10S707/99942
摘要： A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.
摘要翻译：提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。基于源数据库中包含的数据，元数据（例如，系统表空间和控制文件中的数据）以及外部对象（例如，密码文件和外部存储的表），在目标平台上创建目标数据库。存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。可以在源数据库或目标数据库执行数据和元数据的转换。源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。可以在目标数据库上重新创建某些文件，例如密码文件和到外部存储对象的链接。

4. 发明授权

US07752181B2 System and method for performing a data uniqueness check in a sorted data set 有权
标题翻译：用于在排序数据集中执行数据唯一性检查的系统和方法
公开(公告)号：US07752181B2
公开(公告)日：2010-07-06
申请号：US10984113
申请日：2004-11-08
申请人： Jonathan Klein , Bipul Sinha , Amit Ganesh
发明人： Jonathan Klein , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , G06F17/30371
摘要： Embodiments of the present invention include a method for performing a data uniqueness check in a set of sorted data blocks comprising accessing data to be inserted into the set of sorted data blocks, determining a proper data block of the set of sorted data blocks for which the data to be inserted should be located based on a first sorting key. The method further includes examining the proper data block for an existing data entry and if the proper data block is empty, the method further includes inserting the data to be inserted into the proper data block of the set of sorted data blocks.
摘要翻译：本发明的实施例包括一种用于在一组分类数据块中执行数据唯一性检查的方法，包括访问要插入到该排序数据块集合中的数据，确定该排序数据块集合中的适当数据块，应插入的数据应基于第一个排序键来定位。该方法还包括检查现有数据条目的正确数据块，如果正确的数据块为空，则该方法还包括将要插入的数据插入到该排序数据块集合的正确数据块中。

5. 发明申请

US20060122963A1 System and method for performing a data uniqueness check in a sorted data set 有权
标题翻译：用于在排序数据集中执行数据唯一性检查的系统和方法
公开(公告)号：US20060122963A1
公开(公告)日：2006-06-08
申请号：US10984113
申请日：2004-11-08
申请人： Jonathan Klein , Bipul Sinha , Amit Ganesh
发明人： Jonathan Klein , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , G06F17/30371
摘要： Embodiments of the present invention include a method for performing a data uniqueness check in a set of sorted data blocks comprising accessing data to be inserted into the set of sorted data blocks, determining a proper data block of the set of sorted data blocks for which the data to be inserted should be located based on a first sorting key. The method further includes examining the proper data block for an existing data entry and if the proper data block is empty, the method further includes inserting the data to be inserted into the proper data block of the set of sorted data blocks.
摘要翻译：本发明的实施例包括一种用于在一组分类数据块中执行数据唯一性检查的方法，包括访问要插入到该排序数据块集合中的数据，确定该排序数据块集合中的适当数据块，应插入的数据应基于第一个排序键来定位。该方法还包括检查现有数据条目的正确数据块，如果正确的数据块为空，则该方法还包括将要插入的数据插入到该排序数据块集合的正确数据块中。

6. 发明授权

US07047386B1 Dynamic partitioning of a reusable resource 有权
标题翻译：可重用资源的动态分区
公开(公告)号：US07047386B1
公开(公告)日：2006-05-16
申请号：US09872243
申请日：2001-05-31
申请人： Gary Ngai , Amit Ganesh , Jonathan Klein , Sujatha Muthulingam
发明人： Gary Ngai , Amit Ganesh , Jonathan Klein , Sujatha Muthulingam
IPC分类号： G06F12/00
CPC分类号： G06F9/5016 , G06F17/30339 , Y10S707/99953
摘要： Techniques for managing changes in a computer system include storing, in a storage space, undo information for removing changes that are being made by entities. The undo information for each entity is stored in a segment of multiple segments within the storage space. Usage of the storage space by the entities is monitored. The number of segments in the plurality of segments or the sizes of the plurality of segments or both are adjusted automatically based on the usage. These techniques allow a resource to be recycled and allocated for new uses by other entities in a computer system dynamically based on usage. These techniques do not burden a human administrator with partitioning the resource and then penalize the administrator and users by generating errors when the partitions do not match usage.
摘要翻译：用于管理计算机系统中的变化的技术包括在存储空间中存储用于去除由实体进行的改变的撤销信息。每个实体的撤消信息存储在存储空间内的多个段的段中。监视实体对存储空间的使用情况。根据使用情况自动调整多个段中的段的数量或多个段或两者的大小。这些技术允许资源根据用途动态地回收和分配给计算机系统中的其他实体的新用途。这些技术不会给管理员分配资源造成负担，然后通过在分区与使用情况不匹配时生成错误来惩罚管理员和用户。

7. 发明授权

US06574717B1 Techniques for time-based retention of a reusable resource 有权
标题翻译：用于基于时间的保留可重用资源的技术
公开(公告)号：US06574717B1
公开(公告)日：2003-06-03
申请号：US09872267
申请日：2001-05-31
申请人： Gary Ngai , Amit Ganesh , Jonathan Klein , Sujatha Muthulingam
发明人： Gary Ngai , Amit Ganesh , Jonathan Klein , Sujatha Muthulingam
IPC分类号： G06F1300
CPC分类号： G06F17/30371
摘要： Techniques for managing, within a computer system, a resource that is reusable by a plurality of entities include establishing a minimum period of time for retaining an amount of the resource after completion of use of the resource by an entity. A first amount of the resource is allocated to a first entity. After allocating the first amount to the first entity, the first amount is prevented from being allocated to a second entity before the minimum period of time expires after the first entity completes use of the first resource. These techniques allow resources to be recycled and allocated for new uses by other entities in a computer system, but also guarantee the resources are retained in a given state for consistent use by other entities, even after the entity terminates that first had the resource allocated.
摘要翻译：在计算机系统内管理由多个实体可重用的资源的技术包括在实体完成使用资源之后建立用于保留资源量的最小时间段。资源的第一数量被分配给第一实体。在向第一实体分配第一数量之后，在第一实体完成使用第一资源之后的最短时间段到期之前，防止第一数量被分配给第二实体。这些技术允许资源被回收并分配给计算机系统中的其他实体的新用途，而且还保证资源被保持在给定状态以供其他实体的一致使用，即使在实体终止之后，首先资源被分配。

8. 发明申请

US20060212492A1 Method and mechanism for identifying transaction on a row of data 有权
标题翻译：用于识别一行数据上的事务的方法和机制
公开(公告)号：US20060212492A1
公开(公告)日：2006-09-21
申请号：US11436263
申请日：2006-05-17
申请人： Kenneth Jacobs , Amit Ganesh , Jonathan Klein , Archna Johnson , Vivekanandhan Raja
发明人： Kenneth Jacobs , Amit Ganesh , Jonathan Klein , Archna Johnson , Vivekanandhan Raja
IPC分类号： G06F17/30
CPC分类号： G06F17/30551 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A method and mechanism for identifying one or more transactions that have modified or created an object in a database system. Also disclosed is a method and mechanism to compensate for the effects of a transaction in a database system is disclosed. The disclosed approach can be applied to perform auditing for changes and/or transactions in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.
摘要翻译：用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。还公开了一种补偿数据库系统中的事务的影响的方法和机制。所公开的方法可以应用于对数据库系统中的变更和/或交易执行审计，并且用于识别由系统中的交易进行的变更和数据访问的范围。

9. 发明授权

US06981004B2 Method and mechanism for implementing in-memory transaction logging records 有权
标题翻译：实现内存中事务日志记录的方法和机制
公开(公告)号：US06981004B2
公开(公告)日：2005-12-27
申请号：US10245602
申请日：2002-09-16
申请人： Amit Ganesh , Srinivas Vemuri , Jonathan Klein , Bipul Sinha
发明人： Amit Ganesh , Srinivas Vemuri , Jonathan Klein , Bipul Sinha
IPC分类号： G06F17/30
CPC分类号： G06F17/30368 , G06F17/30371 , Y10S707/99953
摘要： A method and mechanism is disclosed for implementing transaction logging in a database system. In-memory undo records are maintained to log undo information for the database system. Redo records are batch processed, with multiple redo records for a transaction stored on disk at commit time.
摘要翻译：公开了一种在数据库系统中实现事务日志记录的方法和机制。维护内存中的撤销记录以记录数据库系统的撤消信息。重做记录是批量处理的，在提交时存储在磁盘上的事务具有多个重做记录。

10. 发明授权

US06976022B2 Method and mechanism for batch processing transaction logging records 有权
标题翻译：批处理事务日志记录的方法和机制
公开(公告)号：US06976022B2
公开(公告)日：2005-12-13
申请号：US10245118
申请日：2002-09-16
申请人： Srinivas Vemuri , Amit Ganesh , Arvind Nithrakashyap , Roger Bamford , Jonathan Klein , Vikram Joshi
发明人： Srinivas Vemuri , Amit Ganesh , Arvind Nithrakashyap , Roger Bamford , Jonathan Klein , Vikram Joshi
IPC分类号： G06F17/30
CPC分类号： G06F17/30368 , G06F17/30371 , Y10S707/99938
摘要： A method and mechanism is disclosed for implementing transaction logging in a database system. In-memory undo records are maintained to log undo information for the database system. Redo records are batch processed, with multiple redo records for a transaction stored on disk at commit time.
摘要翻译：公开了一种在数据库系统中实现事务日志记录的方法和机制。维护内存中的撤销记录以记录数据库系统的撤消信息。重做记录是批量处理的，在提交时存储在磁盘上的事务具有多个重做记录。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式