公开(公告)号：US07953749B2

公开(公告)日：2011-05-31

申请号：US10871073

申请日：2004-06-18

申请人： Bipul Sinha ,  Amit Ganesh

发明人： Bipul Sinha ,  Amit Ganesh

IPC分类号： G06F17/30

CPC分类号： G06F17/3048 ,  G06F17/30368

摘要： Processing a database statement received from a database client, which requests information about the timing of a last committed change to a row in a database table, comprises retrieving a logical time value that represents a commit time associated with the row and providing the value to the client. In one embodiment, providing the logical time value to the client is enabled by database infrastructure in which a virtual column is used to temporarily “store” the value so that the value can be manipulated as if the value resided in a column of the row. Performance of operations that involve the virtual column are processed similar to real columns, as if data was actually logically stored in the virtual column. For example, the virtual column can be used in condition clauses of database statements for concurrency control.

摘要翻译： 处理从数据库客户机接收到的数据库语句，该数据库语句向数据库表中的行请求关于最后提交的更改的定时的信息，包括检索表示与该行相关联的提交时间的逻辑时间值，并将该值提供给 客户。 在一个实施例中，通过数据库基础设施来实现向客户机提供逻辑时间值，其中使用虚拟列临时“存储”该值，使得可以像该值驻留在该行的列中一样被操纵。 涉及虚拟列的操作的性能被类似于实数列的处理，就像数据实际上是逻辑地存储在虚拟列中一样。 例如，虚拟列可以在数据库语句的条件子句中用于并发控制。

公开(公告)号：US07840551B2

公开(公告)日：2010-11-23

申请号：US11933756

申请日：2007-11-01

申请人： Daniel ManHung Wong ,  Amit Ganesh ,  Bipul Sinha ,  Chi Ching Chui

发明人： Daniel ManHung Wong ,  Amit Ganesh ,  Bipul Sinha ,  Chi Ching Chui

IPC分类号： G06F17/00

CPC分类号： G06F21/6227

摘要： One embodiment of the present invention provides a system for automatically classifying data in a database. During operation, the system receives and executes a database operation. Next, the system automatically determines if any data was modified as a result of executing the database operation. If so, for each data item that was modified, the system automatically determines if the data item is associated with a classification-rule. If so, the system automatically reclassifies the data item according to the classification-rule. If not, the system leaves a classification of the data item unchanged.

摘要翻译： 本发明的一个实施例提供一种用于在数据库中自动分类数据的系统。 在运行期间，系统接收并执行数据库操作。 接下来，由于执行数据库操作，系统会自动确定是否修改了任何数据。 如果是，对于修改的每个数据项，系统自动确定数据项是否与分类规则相关联。 如果是这样，系统会根据分类规则自动重新分类数据项。 如果没有，系统会保留数据项的分类。

公开(公告)号：US20100030781A1

公开(公告)日：2010-02-04

申请号：US11933756

申请日：2007-11-01

申请人： Daniel ManHung Wong ,  Amit Ganesh ,  Bipul Sinha ,  Chi Ching Chui

发明人： Daniel ManHung Wong ,  Amit Ganesh ,  Bipul Sinha ,  Chi Ching Chui

IPC分类号： G06F17/30

CPC分类号： G06F21/6227

摘要： One embodiment of the present invention provides a system for automatically classifying data in a database. During operation, the system receives and executes a database operation. Next, the system automatically determines if any data was modified as a result of executing the database operation. If so, for each data item that was modified, the system automatically determines if the data item is associated with a classification-rule. If so, the system automatically reclassifies the data item according to the classification-rule. If not, the system leaves a classification of the data item unchanged.

摘要翻译： 本发明的一个实施例提供一种用于在数据库中自动分类数据的系统。 在运行期间，系统接收并执行数据库操作。 接下来，由于执行数据库操作，系统会自动确定是否修改了任何数据。 如果是，对于修改的每个数据项，系统自动确定数据项是否与分类规则相关联。 如果是这样，系统会根据分类规则自动重新分类数据项。 如果没有，系统会保留数据项的分类。

公开(公告)号：US20070288529A1

公开(公告)日：2007-12-13

申请号：US11450092

申请日：2006-06-09

申请人： Amit Ganesh ,  Niloy Mukherjee ,  Manosiz Bhattacharyya ,  Bipul Sinha

发明人： Amit Ganesh ,  Niloy Mukherjee ,  Manosiz Bhattacharyya ,  Bipul Sinha

IPC分类号： G06F17/30

CPC分类号： G06F17/30442

摘要： A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.

摘要翻译： 减少延迟的批量删除操作允许检索已删除的数据。 每个数据库对象保存一个删除SCN，指示上次执行批量删除操作的时间。 数据库对象中的每一行都保存一行行修改SCN，指示行何时上次更新。 通过将删除SCN的旧值写入undo表空间并更新删除SCN来执行批量删除。 没有为行存储撤消信息。 通过查找删除的行，存储删除的行的撤消信息并写入被删除的行来执行写入。 要从数据库对象读取，必要时执行回滚操作。 然后检索行修改SCN高于删除SCN并且小于或等于所请求数据的时间戳的那些行。

公开(公告)号：US20060149791A1

公开(公告)日：2006-07-06

申请号：US11031275

申请日：2005-01-06

申请人： Bipul Sinha ,  Amit Ganesh ,  Vivekanandhan Raja

发明人： Bipul Sinha ,  Amit Ganesh ,  Vivekanandhan Raja

IPC分类号： G06F17/30

CPC分类号： G06F9/466 ,  G06F16/2365

摘要： A method and apparatus for database-driven distributed recovery is provided. According to one aspect, a transaction manager sends, to one or more resource managers, connection information that indicates how to connect to the transaction manager. A resource manager that receives the connection information establishes an association between the connection information and the distributed transaction for which the connection information was received. If the resource manager is ever in doubt concerning whether the distributed transaction should be committed, the resource manager uses the associated connection information to send, to the transaction manager, a request for status information. The transaction manager maintains status information that indicates whether the distributed transaction should be committed, and responds to the resource manager with the requested status information. The resource manager receives the status information and, based on the status information, either commits or rolls back its portion of the distributed transaction.

摘要翻译： 提供了一种用于数据库驱动的分布式恢复的方法和装置。 根据一个方面，事务管理器向一个或多个资源管理器发送指示如何连接到事务管理器的连接信息。 接收连接信息的资源管理器建立连接信息和接收到连接信息的分布式事务之间的关联。 如果资源管理器对于是否应该提交分布式事务是有疑问的，则资源管理器使用关联的连接信息向事务管理器发送状态信息请求。 事务管理器维护状态信息，指示是否应该提交分布式事务，并使用所请求的状态信息来响应资源管理器。 资源管理器接收状态信息，并根据状态信息提交或回滚其分布式事务的部分。

公开(公告)号：US20060136508A1

公开(公告)日：2006-06-22

申请号：US11013519

申请日：2004-12-16

申请人： Sam Idicula ,  Namit Jain ,  Syam Pannala ,  Vasudha Krishnaswamy ,  Eric Sedlar ,  Nipun Agarwal ,  Bipul Sinha ,  Ravi Murthy

发明人： Sam Idicula ,  Namit Jain ,  Syam Pannala ,  Vasudha Krishnaswamy ,  Eric Sedlar ,  Nipun Agarwal ,  Bipul Sinha ,  Ravi Murthy

IPC分类号： G06F17/30

CPC分类号： G06F16/1774

摘要： A method and apparatus for performing file system operation locks at a database server is provided. A request to perform a file operation on a portion of a file managed by a database server is received at the database server. In response to receiving the request, the database server grants a lock that covers only a portion of the file that is involved in the file operation. For example, the database server may grant a lock that covers a range of bytes on the file, where the range of bytes is less than the entire file. Thereafter, the database server performs the file operation on the file. The file operation may be a NFS operation.

摘要翻译： 提供了一种用于在数据库服务器执行文件系统操作锁定的方法和装置。 在数据库服务器处接收对由数据库服务器管理的文件的一部分执行文件操作的请求。 响应于接收到该请求，数据库服务器授予仅覆盖文件操作中涉及的文件的一部分的锁。 例如，数据库服务器可以授予覆盖文件范围的字节的锁，其中字节的范围小于整个文件。 此后，数据库服务器对文件执行文件操作。 文件操作可能是NFS操作。

公开(公告)号：US20050120062A1

公开(公告)日：2005-06-02

申请号：US10934079

申请日：2004-09-03

申请人： Bipul Sinha ,  Vivekanandhan Raja ,  Amit Ganesh ,  Kenneth Jacobs

发明人： Bipul Sinha ,  Vivekanandhan Raja ,  Amit Ganesh ,  Kenneth Jacobs

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30309

摘要： Disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions. Also disclosed are algorithms, mechanisms, and processes that are employed to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a process for determining one or more life intervals when given a key.

摘要翻译： 公开了允许指定新的表装饰子句以获得一个或多个数据项的一个或多个过去版本的机制，系统，接口和过程。 版本查询提供了一个直接接口来获取多个版本的行。 此外，可以检索和显示过去版本的信息以及过去的版本。 还公开了用于在过去版本上实现查询的算法，机制和过程。 在一种方法中，版本查询可以被定义为基于“rowid”的访问或基于非rowid的访问。 使用基于rowid的访问，给定的rowid用于标识需要过去版本的数据。 还公开了当给予钥匙时确定一个或多个生命间隔的过程。

公开(公告)号：US20050055384A1

公开(公告)日：2005-03-10

申请号：US10866344

申请日：2004-06-10

申请人： Amit Ganesh ,  Bipul Sinha ,  Michael De Groot ,  Eric Bing ,  Srinivas Vemuri

发明人： Amit Ganesh ,  Bipul Sinha ,  Michael De Groot ,  Eric Bing ,  Srinivas Vemuri

IPC分类号： G06F17/30

CPC分类号： G06F17/3048 ,  G06F17/30516

摘要： A query result set is an example of a type of body of data whose content is defined by a query. Modifications to a database can change the result of a query and therefore what the content of such a body of data, such as a result set, should be. Active Queries is an approach that enables a database server to detect database changes that alter the result of a query registered for a client and to notify a client of those changes. The notifications may be sent to, for example, a cache manager responsible for maintaining coherency of a result set cache generated by the query. The notification notifies the cache manager of when and/or what changes are needed to maintain the coherency of the cache.

摘要翻译： 查询结果集是其内容由查询定义的数据主体类型的示例。 对数据库的修改可以改变查询的结果，因此这样一个数据体的内容，比如结果集，应该是什么。 活动查询是一种使数据库服务器能够检测数据库更改的方法，可更改为客户端注册的查询结果，并通知客户端这些更改。 通知可以被发送到例如负责维护由查询生成的结果集缓存的一致性的高速缓存管理器。 该通知通知高速缓存管理器需要什么时候和/或需要什么改变来维持高速缓存的一致性。

公开(公告)号：US20050015563A1

公开(公告)日：2005-01-20

申请号：US10920874

申请日：2004-08-17

申请人： Wanli Yang ,  Bipul Sinha ,  Amit Ganesh

发明人： Wanli Yang ,  Bipul Sinha ,  Amit Ganesh

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30371 ,  Y10S707/99953

摘要： Techniques are provided for guaranteed undo retention. The techniques include a database server attempting to store undo information in undo storage. In order to store the undo information, the database server may overwrite expired undo records; write to empty undo extents; allocate new undo extents and write to the newly-allocated extents; or overwrite unexpired undo records that do not have guaranteed undo retention. If an undo record does not have guaranteed undo retention, then the undo record may be overwritten before the expiration time has elapsed. If no undo extent is empty or unallocated, and if all of the undo records are unexpired and have guaranteed undo retention, then the database system has, at least temporarily, run out of usable and reusable space and an error may be reported to an appropriate party.

摘要翻译： 提供技术保证撤销保留。 这些技术包括尝试在撤销存储中存储撤消信息的数据库服务器。 为了存储undo信息，数据库服务器可能会覆盖失效的撤销记录; 写入空撤销区; 分配新的撤销范围并写入新分配的盘区; 或覆盖没有保证撤消保留的未到期撤消记录。 如果撤消记录没有保证撤消保留，则撤销记录可能会在到期时间过去之前被覆盖。 如果没有撤销范围是空的或未分配的，并且如果所有的撤消记录都未到期并且保证了撤销保留，则数据库系统至少暂时耗尽可用和可重用的空间，并且可能会将错误报告给适当的 派对。

公开(公告)号：US09697253B2

公开(公告)日：2017-07-04

申请号：US11875782

申请日：2007-10-19

申请人： Lakshminarayanan Chidambaran ,  Mehul Dilip Bastawala ,  Srinath Krishnaswamy ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Bipul Sinha ,  Srinivas S. Vemuri

发明人： Lakshminarayanan Chidambaran ,  Mehul Dilip Bastawala ,  Srinath Krishnaswamy ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Bipul Sinha ,  Srinivas S. Vemuri

IPC分类号： G06F17/30

CPC分类号： G06F17/3048

摘要： A method, system, and computer program product is disclosed for caching results in a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that associate a first snapshot of a database with a client that indicates a state of the database after a last database request by the client, and indicate any number of invalid cached results in the client cache for the client based upon the first snapshot. In some embodiments, the method further includes receiving a second snapshot that indicates a state of the database upon receipt of a database server request by the client, and updating the first snapshot with the second snapshot.