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

21. 发明申请

US20090037366A1 ONLINE INDEX BUILDS AND REBUILDS WITHOUT BLOCKING LOCKS 有权
标题翻译：在线索引建立和重建，没有阻塞锁
公开(公告)号：US20090037366A1
公开(公告)日：2009-02-05
申请号：US11830545
申请日：2007-07-30
申请人： Shrikanth Shankar , Ramesh Kumar , Krishna Kunchithapadam , Ananth Raghavan , Dheeraj Pandey , Amit Ganesh , Joy M. Forsythe
发明人： Shrikanth Shankar , Ramesh Kumar , Krishna Kunchithapadam , Ananth Raghavan , Dheeraj Pandey , Amit Ganesh , Joy M. Forsythe
IPC分类号： G06F17/30
CPC分类号： G06F17/30336
摘要： Techniques are provided for processing a CREATE INDEX statement that avoids one or more locks on the underlying table. The processing of such a statement may be divided into a build phase and a cooperation phase. During the build phase, a journal table is created and published. A snapshot of the table is obtained after the last DML transaction (that was pending at the time the journal table was published) commits. The index is built based on the state of the table as of the snapshot. Any changes to the table while the index is built are recorded in the journal table. During the cooperation phase, the index is partially published. A subsequent DML statement determines whether any changes in the journal table affect the same data as the subsequent DML statement. If so, then those changes are applied to the index followed by the subsequent DML statement.
摘要翻译：提供了技术来处理CREATE INDEX语句，以避免基础表上的一个或多个锁。这种陈述的处理可分为建立阶段和合作阶段。在构建阶段，创建并发布日志表。该表的快照是在最后一个DML事务（在发布日志表时挂起的）提交之后获得的。索引是基于快照的表的状态构建的。索引构建时对表的任何更改记录在日记表中。在合作阶段，该指数部分公布。随后的DML语句确定日记表表中的任何更改是否影响与后续DML语句相同的数据。如果是这样，那么这些更改将应用于后面跟随的DML语句的索引。

22. 发明申请

US20080313209A1 PARTITION/TABLE ALLOCATION ON DEMAND 有权
标题翻译：分配/表分配需求
公开(公告)号：US20080313209A1
公开(公告)日：2008-12-18
申请号：US11764131
申请日：2007-06-15
申请人： Shrikanth Shankar , Ananth Raghavan , Badhri G. Varanasi
发明人： Shrikanth Shankar , Ananth Raghavan , Badhri G. Varanasi
IPC分类号： G06F17/30 , G06F12/02
CPC分类号： G06F17/30312 , G06F17/30486
摘要： A method and apparatus for the on-demand allocation of segments and creation of metadata for previously-created data storage spaces and partitions are provided. A space is created in a database. As part of this creation process, no segment is allocated for the space. Rather, metadata describing the space sufficiently to allocate the segment in the future is created and maintained by the database. Data is received indicating a new item. Based on the metadata, it is determined that the new item pertains to the space. In response to the determination, a segment is allocated for the space. Additional metadata necessary for normal database operations in relation to the space and newly-allocated segment may also be created at this time. The new item can then be stored in the space.
摘要翻译：提供了用于按需分配段并且为先前创建的数据存储空间和分区创建元数据的方法和装置。在数据库中创建一个空格。作为此创建过程的一部分，没有为该空间分配段。相反，由数据库创建和维护描述足够分配该段的空间的元数据。收到指示新项目的数据。基于元数据，确定新项目与空间有关。响应于确定，为该空间分配段。此时也可以创建与空间和新分配段相关的正常数据库操作所需的附加元数据。然后可以将新项目存储在空间中。

23. 发明申请

US20080034181A1 METHODS FOR PARTITIONING AN OBJECT 有权
公开(公告)号：US20080034181A1
公开(公告)日：2008-02-07
申请号：US11871520
申请日：2007-10-12
申请人： Subhransu Basu , Ananth Raghavan , Shrikanth Shankar , Vikram Shukla
发明人： Subhransu Basu , Ananth Raghavan , Shrikanth Shankar , Vikram Shukla
IPC分类号： G06F12/02
CPC分类号： G06F17/30587 , Y10S707/953 , Y10S707/972 , Y10S707/99932 , Y10S707/99942 , Y10S707/99943
摘要： The concept of portioning is expanded with a variety of techniques. In particular, one technique involves partitioning an object at multiple levels, where at least one of the levels uses list-based partitioning. Further, a partitioning technique is provided which involves storing a data item in a default partition when the item does not map to any one of the list-based partitions for which a key value group has been defined. Techniques are also provided for efficiently splitting a partition.

24. 发明授权

US09569482B2 Transforming default values dynamically 有权
标题翻译：动态转换默认值
公开(公告)号：US09569482B2
公开(公告)日：2017-02-14
申请号：US11801495
申请日：2007-05-09
申请人： Shrikanth Shankar
发明人： Shrikanth Shankar
IPC分类号： G06F7/00 , G06F17/30 , G06F17/00
CPC分类号： G06F17/30377 , G06F17/30306
摘要： When altering records in a repository of information to add an attribute that has a non-NULL default value and a corresponding constraint to the records, no update record is issued and instead, the existing records are essentially treated as having a NULL value for the attribute being added. To compute a query over the records to which the attribute has been added, a value is generated for rows that hold NULL values for the attribute in which the value in which the NULL values held therein are translated to the default value.
摘要翻译：当更改信息存储库中的记录以将具有非NULL缺省值和相应约束的属性添加到记录时，不会发出更新记录，而是将现有记录基本上视为具有属性的NULL值被添加。要计算对已添加该属性的记录的查询，将为其中将其中保留的NULL值的值转换为默认值的属性保留NULL值的行生成一个值。

25. 发明授权

US07698310B2 System for allowing object metadata to be shared between cursors for concurrent read write access 有权
标题翻译：允许对象元数据在光标之间共享用于并发读写访问的系统
公开(公告)号：US07698310B2
公开(公告)日：2010-04-13
申请号：US11129617
申请日：2005-05-13
申请人： Subhransu Basu , Russell John Green , Shrikanth Shankar
发明人： Subhransu Basu , Russell John Green , Shrikanth Shankar
IPC分类号： G06F17/30
CPC分类号： G06F17/30902 , G06F21/6218 , G06F2221/2147 , Y10S707/99954
摘要： A system, method, computer program and article of manufacture for sharing metadata among cursors is provided. A metadata object marked as a versioned object can have multiple versions. Program units can share these versions of object metadata as opposed to copying the non-versioned object metadata into their memory. These program units may contain a pointer to an object's metadata but are otherwise void of the metadata information for the object. A locking protocol for the metadata ensures concurrency control and triggers dependency tracking. A locking protocol for the cursors controls cursor dependency status.
摘要翻译：提供了一种用于在游标之间共享元数据的系统，方法，计算机程序和制品。标记为版本化对象的元数据对象可以有多个版本。程序单元可以共享对象元数据的这些版本，而不是将非版本化的对象元数据复制到其内存中。这些程序单元可以包含指向对象的元数据的指针，但是否则该对象的元数据信息无效。用于元数据的锁定协议确保并发控制并触发依赖关系跟踪。光标的锁定协议控制游标依赖状态。

26. 发明申请

US20050251511A1 Optimizing execution of a database query by using the partitioning schema of a partitioned object to select a subset of partitions from another partitioned object 有权
标题翻译：通过使用分区对象的分区方案来优化数据库查询的执行，以从另一个分区对象中选择分区的一个子集
公开(公告)号：US20050251511A1
公开(公告)日：2005-11-10
申请号：US10857651
申请日：2004-05-28
申请人： Shrikanth Shankar , Vikram Shukla
发明人： Shrikanth Shankar , Vikram Shukla
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30454 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： One embodiment of the present invention provides a system that optimizes the execution of a database query involving a target partitioned-database-object. During system operation, the database receives a query. If the query has a predicate that includes a partition-mapping function that uses the partitioning schema of a partitioned database-object and a list of columns from one or more tables to express a mapping of the list of column values to the partitions of the partitioned database-object, the system determines the compatibility of the partitioning schemas of the target partitioned-database-object and the partitioned database-object. Next, if the partitioning schemas are compatible, and if the list of columns is compatible with the partitioning keys of the target partitioned-database-object and the partitioned database-object, the system attempts to identify a subset of partitions in the target partitioned-database-object that satisfy the predicate. Finally, if a subset of partitions is successfully identified, the system performs the query only on the identified subset of partitions, and not on the other partitions, thereby optimizing the execution of the query by reducing the number of partitions that need to be accessed.
摘要翻译：本发明的一个实施例提供了一种优化涉及目标分区数据库对象的数据库查询的执行的系统。在系统操作期间，数据库接收查询。如果查询具有包含分区映射函数的谓词，该函数使用分区数据库对象的分区模式和一个或多个表中的列列表，以将列值列表映射到分区的分区数据库对象，系统确定目标分区数据库对象与分区数据库对象的分区模式的兼容性。接下来，如果分区模式是兼容的，并且如果列列表与目标分区数据库对象和分区数据库对象的分区密钥兼容，则系统尝试识别目标分区数据库对象中的分区子集，满足谓词的数据库对象。最后，如果分区的子集被成功识别，则系统仅对所识别的分区子集执行查询，而不在其他分区上执行查询，从而通过减少需要访问的分区数来优化查询的执行。

27. 发明授权

US07340452B2 Parallel single cursor model on multiple-server configurations 有权
标题翻译：多服务器配置上的并行单光标模型
公开(公告)号：US07340452B2
公开(公告)日：2008-03-04
申请号：US10901411
申请日：2004-07-27
申请人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Shrikanth Shankar
发明人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Shrikanth Shankar
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99933 , Y10S707/99934
摘要： A cursor that is generated from an original database statement includes a master plan that is shared among the various participants involved in the parallel execution of the operations specified in the original statement. For participants that cannot share the same cursor, such as slave processes on remote servers, a remote cursor is generated. Signatures are generated for both the master plan and the remote plans, and compared to ensure that the remote plans are equivalent to the master plans. Various parameters and statistics are provided to remote servers to increase the likelihood that the remote plans will be equivalent to the master plan.
摘要翻译：从原始数据库语句生成的游标包括在并行执行原始语句中指定的操作的各参与者之间共享的主计划。对于无法共享相同光标的参与者（如远程服务器上的从属进程），将生成远程光标。为主计划和远程计划生成签名，并进行比较，以确保远程计划等同于主计划。向远程服务器提供了各种参数和统计信息，以增加远程计划与主计划相当的可能性。

28. 发明授权

US11474874B2 Systems and methods for auto-scaling a big data system 有权
公开(公告)号：US11474874B2
公开(公告)日：2022-10-18
申请号：US14459631
申请日：2014-08-14
申请人： Joydeep Sen Sarma , Mayank Ahuja , Sivaramakrishnan Narayanan , Shrikanth Shankar
发明人： Joydeep Sen Sarma , Mayank Ahuja , Sivaramakrishnan Narayanan , Shrikanth Shankar
IPC分类号： G06F9/50
摘要： Systems and methods for automatically scaling a big data system. Methods include determining, at a first time, a first number of nodes for a cluster to process a request; assigning an amount of nodes equal to the first number of nodes to the cluster; determining a rate of progress of the request; determining, at a second time based on the rate of progress a second number of nodes; and modifying the amount of nodes to equal the second number of nodes. Systems include a cluster manager, to add and/or remove any nodes; the big data system, to process requests that utilize the cluster and nodes, and an automatic scaling cluster manager including a big data interface for communicating with the big data system; a cluster manager interface for communicating with the cluster manager; and a cluster state machine.

29. 发明申请

US20160048415A1 Systems and Methods for Auto-Scaling a Big Data System 审中-公开
标题翻译：自动缩放大数据系统的系统和方法
公开(公告)号：US20160048415A1
公开(公告)日：2016-02-18
申请号：US14459631
申请日：2014-08-14
申请人： Joydeep Sen Sarma , Mayank Ahuja , Sivaramakrishnan Narayanan , Shrikanth Shankar
发明人： Joydeep Sen Sarma , Mayank Ahuja , Sivaramakrishnan Narayanan , Shrikanth Shankar
IPC分类号： G06F9/50
CPC分类号： G06F9/5083 , G06F9/5072
摘要： Systems and methods for automatically scaling a big data system are disclosed. Methods may include: determining, at a first time, a first optimal number of nodes for a cluster to adequately process a request; assigning an amount of nodes equal to the first optimal number; determining a rate of progress of the request; determining, at a second time based on the rate of progress a second optimal number of nodes; and modifying the number of nodes assigned to the cluster to equal the second optimal number. Systems may include: a cluster manager, to add and/or remove nodes; a big data system, to process requests that utilize the cluster and nodes, and an automatic scaling cluster manager, including: a big data interface, for communicating with the big data system; a cluster manager interface, for communicating with a cluster manager instructions for adding and/or removing nodes from a cluster used to process a request; and a cluster state machine.
摘要翻译：公开了用于自动缩放大数据系统的系统和方法。方法可以包括：在第一时间确定簇的第一最佳数量的节点以充分地处理请求; 分配等于第一最优数的节点数; 确定请求的进度; 基于所述进展速度在第二时间确定第二最佳数量的节点; 以及修改分配给所述集群的节点数量等于所述第二最佳数量。系统可以包括：群集管理器，用于添加和/或移除节点; 一个大数据系统，用于处理利用集群和节点的请求，以及一个自动扩展集群管理器，包括：一个大数据接口，用于与大数据系统进行通信; 集群管理器接口，用于与集群管理器通信用于从用于处理请求的集群中添加和/或移除节点的指令; 和集群状态机。

30. 发明授权

US08005792B2 System and method for managing versions of metadata 有权
标题翻译：用于管理元数据版本的系统和方法
公开(公告)号：US08005792B2
公开(公告)日：2011-08-23
申请号：US11129717
申请日：2005-05-13
申请人： Russell John Green , Subhransu Basu , Shrikanth Shankar , Kumar Rajamani , Ho Chak Hung , Jaebock Lee
发明人： Russell John Green , Subhransu Basu , Shrikanth Shankar , Kumar Rajamani , Ho Chak Hung , Jaebock Lee
IPC分类号： G06F7/00
CPC分类号： G06F17/30356
摘要： Versioned metadata allows multiple versions of metadata for a given object to exist concurrently on a system thereby supporting the parallel execution of operations which would otherwise be mutually exclusive. Metadata updates are permitted while other objects maintain access to another version of the metadata through a versioning infrastructure. The versioning infrastructure allows the creation of new versions of metadata, maintains obsolete versions in the system as long as they are being used by any object, and deletes the obsolete versions once they are no longer in use.
摘要翻译：版本化元数据允许给定对象的多个版本的元数据同时存在于系统上，从而支持并行执行否则将是相互排斥的操作。允许元数据更新，而其他对象通过版本控制基础架构可以访问其他版本的元数据。版本控制基础架构允许创建新的元数据版本，只要系统使用它们，就可以在系统中维护过时的版本，并在不再使用过时的版本后删除它们。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式