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

11. 发明授权

US08577906B2 Method for modifying a query by use of an external system for managing assignment of user and data classifications 有权
标题翻译：通过使用外部系统修改查询以管理用户和数据分类的分配的方法
公开(公告)号：US08577906B2
公开(公告)日：2013-11-05
申请号：US12951982
申请日：2010-11-22
申请人： Paul M. Bird , Walid Rjaibi
发明人： Paul M. Bird , Walid Rjaibi
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30448
摘要： Disclosed is a data processing-implemented method, a data processing system, and an article of manufacture for modifying a query during compilation of the query. The query includes a request for an element of data from a table in a database and parameters identifying the requested element. The data processing-implemented method includes determining available information from parameters for locating a classification of the requested element and a classification associated with the query, the requested data classification controlling access to the requested element according to the query associated classification, requesting a suggested action from an external system for obtaining a comparison of the requested data classification and the query associated classification based on the available information, receiving the suggested action from the external system responsive to the sent request, and incorporating the suggested action into the query, the suggested action effecting comparison of the requested data classification with the query associated classification.
摘要翻译：公开了一种数据处理实现的方法，数据处理系统和用于在查询的编译期间修改查询的制品。该查询包括对来自数据库中的表的数据元素的请求以及标识所请求元素的参数。数据处理实现的方法包括从用于定位所请求的元素的分类和与查询相关联的分类的参数确定可用信息，所请求的数据分类根据查询关联分类来控制对所请求的元素的访问，请求建议的动作用于基于所述可用信息获得所请求的数据分类和所述查询关联分类的比较的外部系统，响应于所发送的请求从所述外部系统接收所述建议的动作，并将所述建议的动作合并到所述查询中，所述建议的动作请求的数据分类与查询关联分类的比较。

12. 发明授权

US07007150B2 Memory balancing and optimization services 失效
公开(公告)号：US07007150B2
公开(公告)日：2006-02-28
申请号：US10401329
申请日：2003-03-27
申请人： Gary Valentin , Paul M. Bird , Matthew A Huras , Xun Xue
发明人： Gary Valentin , Paul M. Bird , Matthew A Huras , Xun Xue
IPC分类号： G06F12/00
CPC分类号： G06F9/5016
摘要： Memory balancing and optimization services (MBOS) control a size of a plurality of memory heaps, and a memory optimizer for allocating and de-allocating memory for a plurality of respective memory consumers. The MBOS may be instantiated within an application program such as a database management system providing services to memory consumers within the application. Alternatively, the MBOS may be instantiated within an operating system for providing services to memory consumers that are applications such as database management systems, e-commerce engines, operating systems, customer relationship management (CRM), enterprise resource planning (ERP), or supply chain management (SCM). Alternatively, an MBOS is instantiated within the operating system to provide services to applications and an MBOS is instantiated within each application to provide services to memory consumers within the application.

13. 发明授权

US06353833B1 Caching of distributed dynamic SQL statements in a multiple node RDBMS 有权
标题翻译：在多节点RDBMS中缓存分布式动态SQL语句
公开(公告)号：US06353833B1
公开(公告)日：2002-03-05
申请号：US09162165
申请日：1998-09-29
申请人： Paul M. Bird , Michael J. Snowbell
发明人： Paul M. Bird , Michael J. Snowbell
IPC分类号： G06F1730
CPC分类号： G06F17/30433 , G06F17/3048 , Y10S707/99938 , Y10S707/99952
摘要： A method and system for caching dynamic SQL statements and their sections at different nodes in a multiple node Relational Database Management System (RDBMS) while maintaining cache and application integrity across all nodes. Each node in the RDBMS having a global cache shared by all applications on that node. One of the nodes in the RDBMS being a catalogue node which controls access to a database. The catalogue node maintaining a list of participating nodes that have requested access to the database controlled by the catalogue node. The list of participating nodes being used to notify each participating node of any changes to the database that may affect the validity of a dynamic SQL statement stored in the global cache of the node.
摘要翻译：一种用于在多节点关系数据库管理系统（RDBMS）中的不同节点处缓存动态SQL语句及其部分的方法和系统，同时在所有节点上保持缓存和应用程序完整性。 RDBMS中的每个节点都具有由该节点上的所有应用程序共享的全局高速缓存。 RDBMS中的一个节点是控制对数据库的访问的目录节点。目录节点维护已请求访问由目录节点控制的数据库的参与节点的列表。参与节点的列表用于通知每个参与节点对数据库的任何可能影响存储在节点的全局缓存中的动态SQL语句的有效性的任何更改。

14. 发明申请

US20110161742A1 Efficient Monitoring in a Software System 失效
标题翻译：软件系统中的高效监控
公开(公告)号：US20110161742A1
公开(公告)日：2011-06-30
申请号：US12648434
申请日：2009-12-29
申请人： Paul M. Bird , David Kalmuk , Scott D. Walkty
发明人： Paul M. Bird , David Kalmuk , Scott D. Walkty
IPC分类号： G06F11/28 , G06F11/00
CPC分类号： G06F11/3466 , G06F11/0715 , G06F11/0757 , G06F2201/81 , G06F2201/865
摘要： A monitoring of a server system during an execution of a server system processing logic, includes: during collection and storage of operational metrics by a given thread in a thread-local memory, determining that a checkpoint within the server system processing logic is reached; determining whether a threshold number of checkpoints have been encountered by the given thread; in response to the threshold number of checkpoints having been encountered, determining whether a threshold time interval since a last rollup of the collected operational metrics has been exceeded; and in response to the threshold time interval being exceeded, performing a rollup of the collected operational metrics from the thread-local memory to an accumulation point in a shared memory, where the accumulation point stores aggregated operational metrics from a plurality of threads.
摘要翻译：在执行服务器系统处理逻辑期间对服务器系统的监视包括：在由线程本地存储器中的给定线程收集和存储操作指标期间，确定到达服务器系统处理逻辑内的检查点; 确定给定线程是否遇到阈值数量的检查点; 响应于已经遇到的检查点的阈值数量，确定是否已经超过了所收集的操作度量的最后一次累积的阈值时间间隔; 并且响应于所述阈值时间间隔被超过，从所述线程本地存储器到所述共享存储器中的累积点执行所收集的操作度量的汇总，其中所述累积点存储来自多个线程的聚合操作度量。

15. 发明授权

US07970787B2 Access concurrency for cached authorization information in relational database systems 失效
标题翻译：访问关系数据库系统中缓存授权信息的并发性
公开(公告)号：US07970787B2
公开(公告)日：2011-06-28
申请号：US10391118
申请日：2003-03-17
申请人： Michael A. F. Stuy , Paul M. Bird
发明人： Michael A. F. Stuy , Paul M. Bird
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30362
摘要： A method and system for improving access concurrency to information stored in at least one table in a relational database system is disclosed. The method comprises providing a data cache, which stores a portion of the at least one table. The data cache includes a plurality of cache entries, wherein each cache entry comprises a first data item, a second data item, and a cache entry state. The method further comprises retrieving from the at least one table and storing in a cache entry's first data item a representation of committed information for a user, and retrieving from the at least one table and storing in the cache entry's second data item a representation of changes applied to the committed information, but not yet committed in the database system.
摘要翻译：公开了一种用于改善与关系数据库系统中的至少一个表中存储的信息的访问并发性的方法和系统。该方法包括提供存储该至少一个表的一部分的数据高速缓存。数据高速缓存包括多个高速缓存条目，其中每个高速缓存条目包括第一数据项，第二数据项和高速缓存条目状态。所述方法还包括从所述至少一个表中检索并在高速缓存条目的第一数据项中存储用于用户的已提交信息的表示，以及从所述至少一个表中检索并在所述高速缓存条目的第二数据项中存储变化的表示应用于提交的信息，但尚未在数据库系统中提交。

16. 发明授权

US07099863B2 System and method for caching database query statements 有权
标题翻译：用于缓存数据库查询语句的系统和方法
公开(公告)号：US07099863B2
公开(公告)日：2006-08-29
申请号：US10425164
申请日：2003-04-29
申请人： Paul M. Bird , Michael J. Snowbell
发明人： Paul M. Bird , Michael J. Snowbell
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30607 , G06F17/30433 , G06F17/30457 , G06F17/30471 , G06F17/30595 , G06F21/6227 , Y10S707/955 , Y10S707/99933 , Y10S707/99934
摘要： In a database system that supports object name overloading, database query statements are compiled and cached as data structures so that object level privileges are correctly resolved. Database query statements stored in the cached data structures are utilized when appropriate and a new compilation is performed when an incorrect resolution would result. The data structures are stored in a predefined order to ensure that a deterministic search of the cache is efficiently performed.
摘要翻译：在支持对象名称重载的数据库系统中，将数据库查询语句编译和缓存为数据结构，以便正确解析对象级特权。存储在缓存的数据结构中的数据库查询语句在适当时被使用，当导致不正确的解析时执行新的编译。以预定义的顺序存储数据结构，以确保有效执行高速缓存的确定性搜索。

17. 发明授权

US06735605B2 Method and apparatus for synchronizing not-logged application temporary tables in a multi-node relational database management system 失效
标题翻译：用于在多节点关系数据库管理系统中同步未记录的应用程序临时表的方法和装置
公开(公告)号：US06735605B2
公开(公告)日：2004-05-11
申请号：US09796843
申请日：2001-02-28
申请人： Paul M. Bird , Yuk Kuen Chan , Jesse Lee , Hebert W. Pereyra , Yeung-Kuen See , Michael J. Snowbell , Catharina K. Wong
发明人： Paul M. Bird , Yuk Kuen Chan , Jesse Lee , Hebert W. Pereyra , Yeung-Kuen See , Michael J. Snowbell , Catharina K. Wong
IPC分类号： G06F1730
CPC分类号： G06F17/30371 , Y10S707/99943 , Y10S707/99956
摘要： A multi-node relational database management system is provided that can be embodied in software for managing a database having declared temporary tables associated with respective software application programs. The system comprises a plurality of nodes. The nodes include a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporary tables.
摘要翻译：提供了一种多节点关系数据库管理系统，其可以用于管理具有与各个软件应用程序相关联的声明临时表的数据库的软件。该系统包括多个节点。节点包括用于维护与任何应用相关联的声明临时表的标识符列表的目录节点; 用于应用程序的协调器节点; 用于所述应用的至少一个下级节点，所述下级节点具有所述申请的已声明临时表的至少一个分区; 以及声明的临时表管理器，用于使协调器节点为应用程序维护已声明的临时表的列表。

18. 发明授权

US07827608B2 Data leak protection system, method and apparatus 有权
标题翻译：数据泄漏保护系统，方法和装置
公开(公告)号：US07827608B2
公开(公告)日：2010-11-02
申请号：US11053105
申请日：2005-02-08
申请人： Paul M. Bird , David L. Kaminsky , Sam S. Lightstone , Walid Rjaibi
发明人： Paul M. Bird , David L. Kaminsky , Sam S. Lightstone , Walid Rjaibi
IPC分类号： G06F11/00 , G06F12/14 , G06F13/00 , G08B23/00
CPC分类号： G06F21/6227 , G06F17/30306 , G06F17/30477
摘要： A method, system and apparatus for data leak prevention. An information system, such as a database system, which has been configured for data leak protection in accordance with the present invention can include an IDS coupled to the information system and a data leak protection system configured to apply a data leak protection policy for result sets produced by the information system in response to a database query. The data leak protection policy can include a listing of data shapes and corresponding remedial measures. The data leak protection policy further can include consideration for metrics produced by the IDS.
摘要翻译：一种防止数据泄露的方法，系统和装置。根据本发明已被配置用于数据泄漏保护的诸如数据库系统的信息系统可以包括耦合到信息系统的IDS和被配置为对结果集合应用数据泄漏保护策略的数据泄漏保护系统由信息系统生成的响应数据库查询。数据泄漏保护策略可以包括数据形状列表和相应的补救措施。数据泄漏保护政策还可以包括对IDS产生的度量的考虑。

19. 发明授权

US07370049B2 Detection and prevention of writing conflicts within nested query statements 有权
标题翻译：检测和防止在嵌套查询语句中写入冲突
公开(公告)号：US07370049B2
公开(公告)日：2008-05-06
申请号：US10413637
申请日：2003-04-14
申请人： Douglas J. Doole , Paul M. Bird
发明人： Douglas J. Doole , Paul M. Bird
IPC分类号： G06F17/30
CPC分类号： G06F17/30359 , Y10S707/99932 , Y10S707/99933 , Y10S707/99938
摘要： Conflict checking for writing operations in an SQL database system is carried out for nested statements invoked by a parent statement. Each statement has an associated table access data structure defined at compile-time indicating the tables in the database that the statement accesses and the mode of access. At execution-time the table access data structure for each nested statement is accessed and the information is compared with a list of tables maintained for the parent statement to determine if there is a read/write or write/write conflict possible if the nested statement is executed. Where there is no conflict detected, the information from the table access data structure is copied to the list of tables.
摘要翻译：对于由父语句调用的嵌套语句，对SQL数据库系统中的写入操作进行冲突检查。每个语句都具有在编译时定义的关联表访问数据结构，指示数据库中该表所访问的表和访问模式。在执行时，访问每个嵌套语句的表访问数据结构，并将信息与为父语句维护的表的列表进行比较，以确定是否存在读/写或写/写冲突，如果嵌套语句为执行。在没有检测到冲突的情况下，来自表访问数据结构的信息被复制到表的列表中。

20. 发明授权

US06321235B1 Global caching and sharing of SQL statements in a heterogeneous application environment 失效
标题翻译：在异构应用程序环境中全局缓存和共享SQL语句
公开(公告)号：US06321235B1
公开(公告)日：2001-11-20
申请号：US09162164
申请日：1998-09-29
申请人： Paul M. Bird
发明人： Paul M. Bird
IPC分类号： G06F1730
CPC分类号： G06F17/30433 , Y10S707/954 , Y10S707/955 , Y10S707/99932 , Y10S707/99934 , Y10S707/99954
摘要： A global cache for SQL sections and methods of accessing the cache. The global cache being at the database level and being accessible to all agents of all applications. The global cache having a static and a dynamic portion. The static portion containing section entries having both section information and section data. The dynamic portion having two sub-portions, a statement portion and a dependency portion. The dependency portion containing multiple SQL statements, multiple compilation environments for each SQL statement and multiple variations within each compilation environment. The dependency portion of the dynamic portion containing a plurality of lists of object types. Each object type having its own list, the list containing data on which variations are dependant on each object.
摘要翻译：用于SQL部分和访问缓存的方法的全局缓存。全局缓存位于数据库级别，可供所有应用程序的所有代理访问。全局缓存具有静态和动态部分。静态部分包含部分条目具有部分信息和部分数据。具有两个子部分的动态部分，语句部分和依赖部分。包含多个SQL语句的依赖部分，每个SQL语句的多个编译环境以及每个编译环境中的多个变体。动态部分的依赖部分包含多个对象类型列表。每个对象类型都有自己的列表，该列表包含数据，变化依赖于每个对象。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式