-
1.发明授权System for optimally processing a transaction and a query to the same database concurrently 失效用于同时处理事务和查询到同一个数据库的系统
公开(公告)号：US5758149A
公开(公告)日：1998-05-26
申请号：US406265
申请日：1995-03-17
申请人： Michael J. Bierma , Sheng-te Chiang , Thomas P. Cooper , James A. Elke , Katsuhiko Kihara , John R. Jordan , Lester Y. Lee , Lee-Chin Liu , James R. Mettling , James M. Plasek , Ralph E. Sipple , Jennifer J. Smith , Ronald Q. Smith , Rajeev P. Tandon
发明人： Michael J. Bierma , Sheng-te Chiang , Thomas P. Cooper , James A. Elke , Katsuhiko Kihara , John R. Jordan , Lester Y. Lee , Lee-Chin Liu , James R. Mettling , James M. Plasek , Ralph E. Sipple , Jennifer J. Smith , Ronald Q. Smith , Rajeev P. Tandon
CPC分类号： G06F17/30348 , Y10S707/99933 , Y10S707/99934 , Y10S707/99938
摘要： A system for concurrent processing of queries and transactions against a shared database. The system includes multiple processors wherein a processor is available for processing queries and another processor is available for concurrently processing transactions. A query buffer is established for performing the query search while the data accessed by transactions is available in a database cache. Control logic in a database management system distinguishes between transactions and queries and initiates file-read control for reading the file containing the database. File-read control contains logic for logical sequential reading and logical non-sequential reading of the file. Control structures provide a means for control over the load that the query is allowed to place on the system.
摘要翻译： 用于针对共享数据库并行处理查询和事务的系统。 该系统包括多个处理器，其中处理器可用于处理查询，另一处理器可用于并发处理事务。 建立一个查询缓冲区，用于执行查询搜索，而数据访问的数据在数据库缓存中可用。 数据库管理系统中的控制逻辑区分事务和查询，并启动文件读取控制，以读取包含数据库的文件。 文件读取控件包含用于逻辑顺序读取和逻辑非顺序读取文件的逻辑。 控制结构提供了一种控制查询允许放置在系统上的负载的方法。
-
公开(公告)号：US20160125023A1
公开(公告)日：2016-05-05
申请号：US14533267
申请日：2014-11-05
申请人： James M. Plasek , Jennifer J. Smith
发明人： James M. Plasek , Jennifer J. Smith
IPC分类号： G06F17/30
CPC分类号： G06F16/2393 , G06F16/2282
摘要： Systems and methods for processing tables for query operations referencing the tables are described. A method may include determining whether a table is referenced one time or more than one time in a query that includes at least one operation referencing the table. The method may further include creating a single materialized view of the table when the table is determined to be referenced more than one time in the query. The method may also include creating two or more hash tables based, at least in part, on the single materialized view of the table by creating a hash table for each operator in the query that references the table, and evaluating the query using the two or more hash tables.
摘要翻译： 描述用于处理参考表的查询操作的表的系统和方法。 一种方法可以包括确定在包括至少一个引用该表的操作的查询中是一次还是多于一次地引用表。 该方法还可以包括当查询表被确定为多于一次被引用时，创建该表的单个物化视图。 该方法还可以包括至少部分地通过为引用该表的查询中的每个运算符创建哈希表，至少部分地基于该表的单个物化视图来创建两个或多个散列表，并且使用两者或 更多的哈希表。
-
公开(公告)号：US20160098454A1
公开(公告)日：2016-04-07
申请号：US14507912
申请日：2014-10-07
申请人： James M. Plasek , Jennifer J. Smith
发明人： James M. Plasek , Jennifer J. Smith
IPC分类号： G06F17/30
CPC分类号： G06F17/30495 , G06F17/30339 , G06F17/30345 , G06F17/30389 , G06F17/30427 , G06F17/30448 , G06F17/30469 , G06F17/30498
摘要： Systems and methods for evaluating analytic queries comprising disjunctive Boolean expressions are described. A method may include receiving an analytic query comprising a first disjunctive Boolean expression. The method may further include transforming the analytic query to obtain a transformed analytic query comprising at least one nondisjunctive Boolean expression and at least a second disjunctive Boolean expression. The method may also include evaluating the transformed analytic query, wherein complete evaluation of the at least one nondisjunctive Boolean expressions and the at least a second disjunctive Boolean expressions yields the same results as evaluation of the first disjunctive Boolean expression.
摘要翻译： 描述用于评估包含分离布尔表达式的分析查询的系统和方法。 方法可以包括接收包括第一分离布尔表达式的分析查询。 该方法还可以包括转换分析查询以获得包括至少一个非分支布尔表达式和至少第二分离布尔表达式的经转换的分析查询。 该方法还可以包括评估变换的分析查询，其中至少一个非延迟布尔表达式和至少一个第二分离布尔表达式的完整评估产生与第一分离布尔表达式的评估相同的结果。
-
4.发明申请公开(公告)号：US20130060732A1
公开(公告)日：2013-03-07
申请号：US13226539
申请日：2011-09-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30348
摘要： Altering tables in a database system may be difficult because the tables may only be altered when all connection to the tables have been released. A free resources parameter may be set on in a management system for the database system to specify that resources should be attempted to be released. Connections to the database may be closed earlier that conventionally closed. For example, connections that are idle may be released. Once the connections have been released the database may be altered and the free resources parameter turned off. The free resources parameter notifies the database system of a pending alteration and allows the database to gracefully close connections to provide an opportunity for the alteration to occur.
摘要翻译： 在数据库系统中更改表可能很困难，因为只有在释放了与表的所有连接时，才可能更改表。 可以在用于数据库系统的管理系统中设置空闲资源参数，以指定应尝试释放资源。 与数据库的连接可以在常规关闭之前关闭。 例如，空闲的连接可能会被释放。 一旦连接被释放，数据库可能会被更改，并且可用的资源参数被关闭。 免费资源参数通知数据库系统有待更改，并允许数据库优雅地关闭连接，以提供更改发生的机会。
-
5.发明授权公开(公告)号：US09189511B2
公开(公告)日：2015-11-17
申请号：US13226539
申请日：2011-09-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30348
摘要： Altering tables in a database system may be difficult because the tables may only be altered when all connection to the tables have been released. A free resources parameter may be set on in a management system for the database system to specify that resources should be attempted to be released. Connections to the database may be closed earlier than conventionally closed. For example, connections that are idle may be released. Once the connections have been released the database may be altered and the free resources parameter turned off. The free resources parameter notifies the database system of a pending alteration and allows the database to gracefully close connections to provide an opportunity for the alteration to occur.
摘要翻译： 在数据库系统中更改表可能很困难，因为只有在释放与表的所有连接时，表才能更改。 可以在用于数据库系统的管理系统中设置空闲资源参数，以指定应尝试释放资源。 与数据库的连接可能早于常规关闭。 例如，空闲的连接可能会被释放。 一旦连接被释放，数据库可能会被更改，并且可用的资源参数被关闭。 免费资源参数通知数据库系统有待更改，并允许数据库优雅地关闭连接，以提供更改发生的机会。
-
公开(公告)号：US20130060795A1
公开(公告)日：2013-03-07
申请号：US13226526
申请日：2011-09-07
IPC分类号： G06F17/30
CPC分类号： G06F16/24534
摘要： Performance of database systems may be improved by reducing the processing performed with each database query. For example, when a database query, such as a SQL statement, is executed with a first set of values, the query may be stored as a prepared statement and parsed and optimized as a section. When a similar database query is executed with a new set of values the section may be re-executed with the new set of values without re-parsing or re-optimizing the prepared statement. A similar database query may continue to be executed with new sets of values until the section is invalid because of an alteration to the table definitions of the database schema.
摘要翻译： 可以通过减少每个数据库查询执行的处理来改进数据库系统的性能。 例如，当使用第一组值执行数据库查询（例如SQL语句）时，查询可以作为预备语句存储，并作为部分进行解析和优化。 当使用新的一组值执行类似的数据库查询时，可以使用新的值集重新执行该部分，而无需重新解析或重新优化预准备语句。 类似的数据库查询可能会继续使用新的值集执行，直到该部分无效为止，因为数据库模式的表定义发生了变化。
-
7.发明授权Method and system for dynamic recompilation of statements of a first language embedded in a program having statements of a second language 有权用于动态重新编译嵌入在具有第二语言的语句的程序中的第一语言的语句的方法和系统公开(公告)号：US06496976B1
公开(公告)日：2002-12-17
申请号：US09369216
申请日：1999-08-05
申请人： Jennifer J. Smith , James M. Plasek
发明人： Jennifer J. Smith , James M. Plasek
IPC分类号： G06F945
CPC分类号： G06F8/48
摘要： A method and system for processing statements of a first language embedded in a program having statements of a second language are described in various embodiments. Statements of the first and second languages are compiled into an executable program, the executable program including original executable instructions associated with the statements of the first language. The executable program is executed, and during execution, recompilation conditions are detected for statements of the first language. In response to the recompilation conditions, selected statements of the first language are recompiled, during execution of the executable program, into new executable instructions. The new executable instructions are respectively associated with the selected statements and are executed in place of the original executable instructions.
摘要翻译： 在各种实施例中描述了用于处理嵌入在具有第二语言的语句的程序中的第一语言的语句的方法和系统。 第一语言和第二语言的语句被编译成可执行程序，该可执行程序包括与第一语言的语句相关联的原始可执行指令。 执行可执行程序，并且在执行期间，针对第一语言的语句检测到重新编译条件。 响应于重新编译条件，在执行可执行程序期间将第一语言的选定语句重新编译成新的可执行指令。 新的可执行指令分别与所选择的语句相关联，并且被执行代替原始可执行指令。
-
公开(公告)号：US06970865B1
公开(公告)日：2005-11-29
申请号：US10032915
申请日：2001-12-28
CPC分类号： G06F17/30327 , Y10S707/99933 , Y10S707/99936
摘要： A method and apparatus for improving search performance in databases organized in B Tree or B+ Tree format has an automatic determination and switching between two methods. It also searches to the end of a current leaf page even if a current value for all key parameters has been fulfilled in the search prior to reaching the end of the current leaf page. Swinging across and thus skipping leaf pages to fetch a next leaf page (trapeze fetching or swinging) is activated only either initially or where a B Tree search has resulted in a skipping of leaf pages previously in a search. User interference with the automatic selection of search type between next sequential leaf or trapeze type is not provided for and not allowed.
摘要翻译： 用于改善以B树或B +树格式组织的数据库中的搜索性能的方法和装置具有两种方法之间的自动确定和切换。 即使在到达当前叶页面结束之前，搜索中已经满足所有关键参数的当前值，它也会搜索当前叶页面的末尾。 因此跳过并因此跳过叶子页以获取下一个叶子页面（空中取景或摆动）仅在初始状态或B树搜索导致先前在搜索中跳过叶子页面的情况下被激活。 用户干扰自动选择下一个顺序叶子或空中飞行类型之间的搜索类型不是并且不允许的。
-
公开(公告)号：US20220300404A1
公开(公告)日：2022-09-22
申请号：US17202445
申请日：2021-03-16
摘要： A method for creating a learning model that evaluates risks of applying commits in a third-party product to a dependent product is disclosed. The method includes collecting data on past commits; training the learning model using the collected data; and using the learning model to determine if future commits are problematic.
-
公开(公告)号：US20100146003A1
公开(公告)日：2010-06-10
申请号：US12154292
申请日：2008-12-10
申请人： Kelsey L. Bruso , James M. Plasek
发明人： Kelsey L. Bruso , James M. Plasek
IPC分类号： G06F7/00
CPC分类号： G06F16/2246
摘要： Various approaches for adding data items to a database are described. In one approach, a method includes receiving a plurality of data items; each data item is to be stored under a unique primary key in the database. In response to each received data item, one of a plurality of fragment builders is selected and the data item is provided as input to the selected fragment builder. The fragment builders operate in parallel to create respective pluralities of B-tree fragments from the input data items. The B-tree fragments are merged into a single B-tree of the database, which is then stored.
摘要翻译： 描述了将数据项添加到数据库的各种方法。 在一种方法中，一种方法包括接收多个数据项; 每个数据项将被存储在数据库中的唯一主键下。 响应于每个接收到的数据项，选择多个片段构建器中的一个，并且将数据项提供给所选片段构建器的输入。 片段构建器并行操作以从输入数据项创建相应的多个B树片段。 B树片段被合并到数据库的单个B树中，然后被存储。
-
-
-
-
-
-
-
-
-
搜索结果
43 条记录 (耗时 0.077 秒)
