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

21. 发明授权

US07962481B2 Query based invalidation subscription 有权
标题翻译：基于查询的无效订阅
公开(公告)号：US07962481B2
公开(公告)日：2011-06-14
申请号：US10866344
申请日：2004-06-10
申请人： Amit Ganesh , Bipul Sinha , Michael De Groot , Eric W. Bing , Srinivas Vemuri
发明人： Amit Ganesh , Bipul Sinha , Michael De Groot , Eric W. Bing , Srinivas Vemuri
IPC分类号： G06F7/00 , 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.
摘要翻译：查询结果集是其内容由查询定义的数据主体类型的示例。对数据库的修改可以改变查询的结果，因此这样一个数据体的内容，比如结果集，应该是什么。活动查询是一种使数据库服务器能够检测数据库更改的方法，可更改为客户端注册的查询结果，并通知客户端这些更改。通知可以被发送到例如负责维护由查询生成的结果集缓存的一致性的高速缓存管理器。该通知通知高速缓存管理器需要什么时候和/或需要什么改变来维持高速缓存的一致性。

22. 发明授权

US07571173B2 Cross-platform transportable database 有权
标题翻译：跨平台可移植数据库
公开(公告)号：US07571173B2
公开(公告)日：2009-08-04
申请号：US10966961
申请日：2004-10-15
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
IPC分类号： G06F7/00
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.
摘要翻译：提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。基于源数据库中包含的数据，元数据（例如，系统表空间和控制文件中的数据）以及外部对象（例如，密码文件和外部存储的表），在目标平台上创建目标数据库。存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。可以在源数据库或目标数据库执行数据和元数据的转换。源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。可以在目标数据库上重新创建某些文件，例如密码文件和到外部存储对象的链接。

23. 发明授权

US07552149B2 Querying past versions of data in a distributed database 有权
标题翻译：查询分布式数据库中的过去版本的数据
公开(公告)号：US07552149B2
公开(公告)日：2009-06-23
申请号：US10866333
申请日：2004-06-10
申请人： Bipul Sinha , Amit Ganesh
发明人： Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30548 , Y10S707/99931 , Y10S707/99933 , Y10S707/99952 , Y10S707/99954
摘要： Past versions of data in a distributed database system comprising multiple databases and associated database servers are queried using temporal database access mechanisms, where a request for data in a past state from a “remote” database can be received at a “local” database server and relevant portions of the request are passed to the remote server for processing. The processing performed by the remote server includes returning the requested data in the specified past state to the local server, or at least with enough information to reconstruct the data into the past state.
摘要翻译：使用临时数据库访问机制查询包括多个数据库和关联的数据库服务器的分布式数据库系统中的数据的过去版本，其中可以在“本地”数据库服务器处接收来自“远程”数据库的过去状态的数据请求，请求的相关部分被传递到远程服务器进行处理。由远程服务器执行的处理包括将指定的过去状态的请求数据返回到本地服务器，或者至少具有足够的信息以将数据重构为过去状态。

24. 发明授权

US07437525B2 Guaranteed undo retention 有权
标题翻译：保证撤销保留
公开(公告)号：US07437525B2
公开(公告)日：2008-10-14
申请号：US10920874
申请日：2004-08-17
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh
IPC分类号： G06F12/16
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信息，数据库服务器可能会覆盖失效的撤销记录; 写入空撤销区; 分配新的撤销范围并写入新分配的盘区; 或覆盖没有保证撤消保留的未到期撤消记录。如果撤消记录没有保证撤消保留，则撤销记录可能会在到期时间过去之前被覆盖。如果没有撤销范围是空的或未分配的，并且如果所有的撤消记录都未到期并且保证了撤销保留，则数据库系统至少暂时耗尽可用和可重用的空间，并且可能会将错误报告给适当的派对。

25. 发明申请

US20080243865A1 Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems 审中-公开
标题翻译：维护由集群数据库系统的外部事务管理器管理的分布式事务的全局状态
公开(公告)号：US20080243865A1
公开(公告)日：2008-10-02
申请号：US11729473
申请日：2007-03-28
申请人： Yong Hu , Bipul Sinha , Amit Ganesh , Juan Loaiza , Vivekanandhan Raja
发明人： Yong Hu , Bipul Sinha , Amit Ganesh , Juan Loaiza , Vivekanandhan Raja
IPC分类号： G06F17/30
CPC分类号： G06F16/27
摘要： In accordance with an embodiment of the present invention, a transaction tracking mechanism is provided by a database server cluster to keep track of a global state of a distributed transaction. The global state of the distributed transaction comprises one or more statuses that are associated with one or more transaction branches that are part of the distributed transaction. The global state may be associated with a global lock. Through using the global state in association with the global lock, problems such as partial commits, data inconsistency, access contentions and deadlocks may be avoided when the database server cluster processes the distributed transaction.
摘要翻译：根据本发明的实施例，由数据库服务器集群提供事务跟踪机制以跟踪分布式事务的全局状态。分布式事务的全局状态包括与作为分布式事务的一部分的一个或多个事务分支相关联的一个或多个状态。全局状态可能与全局锁相关联。通过使用与全局锁相关联的全局状态，当数据库服务器集群处理分布式事务时，可能会避免诸如部分提交，数据不一致，访问争用和死锁等问题。

26. 发明授权

US07240065B2 Providing mappings between logical time values and real time values 有权
标题翻译：提供逻辑时间值和实时值之间的映射
公开(公告)号：US07240065B2
公开(公告)日：2007-07-03
申请号：US10856569
申请日：2004-05-27
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/00 , G06F7/00
CPC分类号： G06F17/30551 , Y10S707/99952
摘要： Techniques are provided for providing mappings between logical time values and real time values for a database. The techniques include, if a first event related to the database occurs, writing an entry of a current LTV and a current RTV in a volatile mapping data structure; and if a second event related to the database occurs, writing one or more entries in a non-volatile mapping data structure based on information contained in the volatile mapping data structure. The techniques also include, once a request from a requestor to provide an LTV that is mapped to a particular RTV is received, determining the LTV for the particular RTV, based on the particular RTV and information from a source, wherein the source is one of the volatile mapping data structure and the non-volatile mapping data structure; and providing the LTV that is mapped to the particular RTV to the requestor.
摘要翻译：提供了提供数据库的逻辑时间值和实时值之间的映射的技术。这些技术包括：如果发生与数据库相关的第一事件，则在易失性映射数据结构中写入当前LTV和当前RTV的条目; 并且如果发生与数据库有关的第二事件，则基于包含在易失性映射数据结构中的信息，在非易失性映射数据结构中写入一个或多个条目。所述技术还包括，一旦来自请求者提供映射到特定RTV的LTV的请求被接收，基于特定RTV和来自源的信息确定特定RTV的LTV，其中源是易失性映射数据结构和非易失性映射数据结构; 以及将映射到特定RTV的LTV提供给请求者。

27. 发明申请

US20050114409A1 Method and mechanism for row versioning 有权
标题翻译：行版本化的方法和机制
公开(公告)号：US20050114409A1
公开(公告)日：2005-05-26
申请号：US10933832
申请日：2004-09-03
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30309
摘要： Disclosed are algorithms, mechanisms, processes, mechanisms, and systems 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 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.
摘要翻译：公开了在过去版本上实现查询的算法，机制，过程，机制和系统。在一种方法中，版本查询可以被定义为基于“rowid”的访问或基于非rowid的访问。使用基于rowid的访问，给定的rowid用于标识需要过去版本的数据。还公开了允许指定新的表装饰子句以获得一个或多个数据项的一个或多个过去版本的机制，系统，接口和过程。版本查询提供了一个直接接口来获取多个版本的行。此外，可以检索和显示过去版本的信息以及过去的版本。

28. 发明授权

US08589357B2 Techniques for automatically tracking and archiving transactional data changes 有权
标题翻译：自动跟踪和归档交易数据更改的技术
公开(公告)号：US08589357B2
公开(公告)日：2013-11-19
申请号：US11863310
申请日：2007-09-28
申请人： Venkatesh Radhakrishnan , Vasudha Krishnaswamy , Liang Guo , Bipul Sinha , Amit Ganesh
发明人： Venkatesh Radhakrishnan , Vasudha Krishnaswamy , Liang Guo , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/00 , G06F17/30 , G06F11/00
CPC分类号： G06F17/00 , G06F11/00 , G06F17/30 , G06F17/30551 , G06F17/30595
摘要： A technique for making versions of rows of a user-defined tracked table temporally queryable. The database management system of the technique permits temporal queries of user-defined tables. The queries return versions of rows in the user-defined table that are currently in an undo log maintained by the database system. Associated with the tracked table are a system history table which contains versions of the rows and temporal metadata indicating when the versions were in the tracked table and a system form history table which contains versions of the form of the tracked table and metadata indicating when the tracked table had the form. These tables are created and maintained by a background process in the database management system. A temporal query on the tracked table combines results from the undo log with results from the system history table. The results' form is determined by the system form history table.
摘要翻译：用于使用户定义的跟踪表的行的版本在时间上可查询的技术。该技术的数据库管理系统允许用户定义表的临时查询。查询返回用户定义表中当前处于数据库系统维护的撤销日志中的行的版本。与跟踪表相关联的是系统历史表，其中包含行的版本和时间元数据，指示版本在跟踪表中的何时以及系统表单历史表，其中包含跟踪表格和元数据的版本以及指示何时被跟踪的表表有形式。这些表由数据库管理系统中的后台进程创建和维护。跟踪表上的时间查询将撤消日志的结果与系统历史记录表的结果相结合。结果表单由系统表单历史表确定。

29. 发明授权

US07953749B2 Providing the timing of the last committed change to a row in a database table 有权
标题翻译：将最后一次提交更改的时间提供给数据库表中的一行
公开(公告)号：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.
摘要翻译：处理从数据库客户机接收到的数据库语句，该数据库语句向数据库表中的行请求关于最后提交的更改的定时的信息，包括检索表示与该行相关联的提交时间的逻辑时间值，并将该值提供给客户。在一个实施例中，通过数据库基础设施来实现向客户机提供逻辑时间值，其中使用虚拟列临时“存储”该值，使得可以像该值驻留在该行的列中一样被操纵。涉及虚拟列的操作的性能被类似于实数列的处理，就像数据实际上是逻辑地存储在虚拟列中一样。例如，虚拟列可以在数据库语句的条件子句中用于并发控制。

30. 发明授权

US07840551B2 Method and apparatus for automatically classifying data 有权
标题翻译：自动分类数据的方法和装置
公开(公告)号：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.
摘要翻译：本发明的一个实施例提供一种用于在数据库中自动分类数据的系统。在运行期间，系统接收并执行数据库操作。接下来，由于执行数据库操作，系统会自动确定是否修改了任何数据。如果是，对于修改的每个数据项，系统自动确定数据项是否与分类规则相关联。如果是这样，系统会根据分类规则自动重新分类数据项。如果没有，系统会保留数据项的分类。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式