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

31. 发明授权

US6063133A No preprocessor for embedded SQL in a 3GL 失效
标题翻译：没有预处理器用于3GL中的嵌入式SQL
公开(公告)号：US6063133A
公开(公告)日：2000-05-16
申请号：US107804
申请日：1998-06-30
申请人： Chin Hsiang Li , I-Shin-Andy Wang , Wei Young , Shu Huar Joseph Yeh , John Shek-Luen Ng , Kuo-Wei Hwang , Mir Hamid Pirahesh , Tak-Ming Lo
发明人： Chin Hsiang Li , I-Shin-Andy Wang , Wei Young , Shu Huar Joseph Yeh , John Shek-Luen Ng , Kuo-Wei Hwang , Mir Hamid Pirahesh , Tak-Ming Lo
IPC分类号： G06F9/45 , G06F11/36
CPC分类号： G06F11/3624 , G06F8/427 , G06F8/447
摘要： A system and method for translating source code, comprising high level source code with embedded SQL statements, to p-code or machine-language instructions by a one-pass parsing mechanism. The one-pass parsing mechanism generates executable code without the need to generate an intermediate file. Additionally, the p-code or machine-language instructions are annotated with references to the line numbers of the corresponding source code, thereby allowing a source level debugger to debug the source code with embedded SQL statements.
摘要翻译：用于将源代码（包括具有嵌入式SQL语句的高级源代码）通过一遍解析机制转换为p代码或机器语言指令的系统和方法。一次性解析机制生成可执行代码，而不需要生成中间文件。此外，p代码或机器语言指令通过引用相应源代码的行号进行注释，从而允许源级调试器使用嵌入式SQL语句调试源代码。

32. 发明授权

US5987455A Intelligent compilation of procedural functions for query processing systems 失效
标题翻译：智能编译查询处理系统的程序功能
公开(公告)号：US5987455A
公开(公告)日：1999-11-16
申请号：US884998
申请日：1997-06-30
申请人： Roberta Jo Cochrane , Mir Hamid Pirahesh , Serge Philippe Rielau , Richard Sefton Sidle , Tolga Urhan
发明人： Roberta Jo Cochrane , Mir Hamid Pirahesh , Serge Philippe Rielau , Richard Sefton Sidle , Tolga Urhan
IPC分类号： G06F17/30
CPC分类号： G06F17/30415 , G06F17/30436 , G06F17/30471 , Y10S707/99934 , Y10S707/99938 , Y10S707/99939 , Y10S707/99953
摘要： A method, apparatus, and article of manufacture for an intelligent compiler. A query is executed in a computer to retrieve data from a relational database stored on a data storage device. The query contains a procedural function. The query is compiled to generate an internal representation of the procedural function. Then, the execution of the procedural function is optimized using the generated internal representation.
摘要翻译：智能编译器的方法，设备和制造。在计算机中执行查询以从存储在数据存储设备上的关系数据库检索数据。该查询包含一个程序功能。编译查询以生成过程函数的内部表示。然后，使用生成的内部表示优化程序功能的执行。

33. 发明授权

US5960426A Database system and method for supporting current of cursor updates and deletes from a select query from one or more updatable tables in single node and mpp environments 失效
标题翻译：用于支持来自单节点和mpp环境中的一个或多个可更新表的选择查询的游标更新和删除的数据库系统和方法
公开(公告)号：US5960426A
公开(公告)日：1999-09-28
申请号：US884246
申请日：1997-06-30
申请人： Mir Hamid Pirahesh , David E. Simmen , Tuong Chanh Truong
发明人： Mir Hamid Pirahesh , David E. Simmen , Tuong Chanh Truong
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/3041 , G06F17/30365 , G06F17/30424 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935
摘要： A database system and method provide support for a positioned data set modification operation on a collection of data sets involved in a data set query operation, in which the data set modification operation is based on the position of a query execution iterator. At query compile time, the database system generates an iterator position retrieval function and a data set modification function for each data set involved in the query operation. At query execution time, the database system invokes each of the iterator retrieval functions until the iterator position retrieval function for a current open data set returns the current the position of the query execution iterator on that data set. The database system then invokes each of the data set modification functions until the data set modification function for the current open data set performs a data set modification operation at the current position of the query execution iterator specified by the iterator position retrieval function. The system and method may be implemented on single node systems and on multi-node shared-nothing parallelism architectures.
摘要翻译：数据库系统和方法提供了对数据集查询操作中涉及的数据集合的定位数据集修改操作的支持，其中数据集修改操作基于查询执行迭代器的位置。在查询编译时，数据库系统为查询操作中涉及的每个数据集生成迭代器位置检索功能和数据集修改功能。在查询执行时，数据库系统调用每个迭代器检索函数，直到当前打开的数据集的迭代器位置检索函数返回当前查询执行迭代器在该数据集上的位置。数据库系统然后调用每个数据集修改功能，直到当前打开的数据集的数据集修改功能在迭代器位置检索功能指定的查询执行迭代器的当前位置执行数据集修改操作。系统和方法可以在单节点系统和多节点无共享平行架构上实现。

34. 发明授权

US08661019B2 Join algorithms over full text indexes 失效
标题翻译：在全文索引上加入算法
公开(公告)号：US08661019B2
公开(公告)日：2014-02-25
申请号：US12696013
申请日：2010-01-28
申请人： Latha Sankar Colby , Quanzhong Li , Fatma Ozcan , Mir Hamid Pirahesh , Eugene J. Shekita , Zografoula Vagena
发明人： Latha Sankar Colby , Quanzhong Li , Fatma Ozcan , Mir Hamid Pirahesh , Eugene J. Shekita , Zografoula Vagena
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30498
摘要： According to one embodiment of the present invention, a method for processing join predicates in full-text indexes is provided. The method includes evaluating local predicates of an outer full text index to generate a first posting list of documents. For each document in the first posting list, the value of a join attribute is determined and an inner full text index is probed to obtain a second posting list of documents containing one of the join attributes determined for each document. Local predicates of an inner full text index are evaluated to generate a third posting list of documents, and the second posting list is merged with the third posting list to generate a merge list of documents. Documents in the first posting list may be paired up with documents in the merge list.
摘要翻译：根据本发明的一个实施例，提供了一种用于处理全文索引中的连接谓词的方法。该方法包括评估外部全文本索引的本地谓词以生成文档的第一张贴列表。对于第一个发布列表中的每个文档，确定连接属性的值，并探测内部全文索引以获取包含为每个文档确定的连接属性之一的文档的第二个发布列表。评估内部全文本索引的本地谓词以生成文档的第三张发布列表，并且将第二张发布列表与第三张发布列表合并以生成文档的合并列表。第一个发布列表中的文档可能与合并列表中的文档配对。

35. 发明授权

US07953694B2 Method, system, and program for specifying multidimensional calculations for a relational OLAP engine 有权
标题翻译：用于为关系型OLAP引擎指定多维计算的方法，系统和程序
公开(公告)号：US07953694B2
公开(公告)日：2011-05-31
申请号：US10341763
申请日：2003-01-13
申请人： Nathan Gevaerd Colossi , William Earl Malloy , Mir Hamid Pirahesh , Craig Reginald Tomlyn
发明人： Nathan Gevaerd Colossi , William Earl Malloy , Mir Hamid Pirahesh , Craig Reginald Tomlyn
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30592
摘要： Provided is a system, method, and program for specifying multidimensional calculations. Selection of a subset of a cube model metadata object that is generated from a facts metadata object and one or more dimension metadata objects is received. The facts metadata object references one or more measure metadata objects. A statement is generated for retrieving multidimensional information using metadata in the cube model metadata object and the measure metadata objects, wherein each of the measure metadata objects specifies one or more aggregations.
摘要翻译：提供了用于指定多维计算的系统，方法和程序。接收从事实元数据对象和一个或多个维元数据对象生成的多维数据集模型元数据对象的子集的选择。事实元数据对象引用一个或多个度量元数据对象。生成用于使用多维数据集模型元数据对象和度量元数据对象中的元数据来检索多维信息的语句，其中每个度量元数据对象指定一个或多个聚合。

36. 发明授权

US07945577B2 System and method for adaptive database caching 有权
标题翻译：自适应数据库缓存的系统和方法
公开(公告)号：US07945577B2
公开(公告)日：2011-05-17
申请号：US12123101
申请日：2008-05-19
申请人： Mehmet Altinel , Christof Bomhoevd , Chandrasekaran Mohan , Mir Hamid Pirahesh , Berthold Reinwald , Saileshwar Krishnamurthy
发明人： Mehmet Altinel , Christof Bomhoevd , Chandrasekaran Mohan , Mir Hamid Pirahesh , Berthold Reinwald , Saileshwar Krishnamurthy
IPC分类号： G06F17/00
CPC分类号： G06F17/3048 , Y10S707/99933
摘要： A local database cache enabling persistent, adaptive caching of either full or partial content of a remote database is provided. Content of tables comprising a local cache database is defined on per-table basis. A table is either: defined declaratively and populated in advance of query execution, or is determined dynamically and asynchronously populated on-demand during query execution. Based on a user input query originally issued against a remote DBMS and referential cache constraints between tables in a local database cache, a Janus query plan, comprising local, remote, and probe query portions is determined. A probe query portion of a Janus query plan is executed to determine whether up-to-date results can be delivered by the execution of a local query portion against a local database cache, or whether it is necessary to retrieve results from a remote database by executing a remote query portion of Janus query plan.
摘要翻译：提供本地数据库缓存，实现远程数据库的完整或部分内容的持久自适应缓存。包含本地缓存数据库的表的内容基于每个表进行定义。表是：在查询执行之前以声明方式和填充方式定义，或者在查询执行期间按需动态和异步地填充表。基于最初针对远程DBMS发出的用户输入查询和本地数据库高速缓存中的表之间的参考高速缓存约束，确定包括本地，远程和探测查询部分的Janus查询计划。执行Janus查询计划的探查查询部分以确定是否可以通过对本地数据库高速缓存执行本地查询部分来传递最新结果，或者是否需要通过以下方式从远程数据库检索结果：执行Janus查询计划的远程查询部分。

37. 发明授权

US07315852B2 XPath containment for index and materialized view matching 有权
标题翻译： XPath包含索引和物化视图匹配
公开(公告)号：US07315852B2
公开(公告)日：2008-01-01
申请号：US10698622
申请日：2003-10-31
申请人： Audrey L. Balmin , Kevin S. Beyer , Roberta Jo Cochrane , Fatma Ozcan , Mir Hamid Pirahesh
发明人： Audrey L. Balmin , Kevin S. Beyer , Roberta Jo Cochrane , Fatma Ozcan , Mir Hamid Pirahesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30935 , G06F17/30457 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： A method for using pre-computed information stored in auxiliary structures to speed up processing of expensive queries on hierarchical documents such as XML documents being queried using XPath. The invention defines a taxonomy of such structures such as indexes and materialized views for storing pre-computed XPath results (PXRs), determines what portion of the query can be evaluated by the structures, and computes the compensation for the results generated by the structures. The invention detects all structures applicable to the query and rewrites the query to use such structures, speeding up the performance of the queries. The invention identifies the matching structures by detecting containment mappings between XPath expressions in the query and the structure. The invention also includes a new representation for XPath expressions that is rich enough to express all features of XPath.
摘要翻译：使用存储在辅助结构中的预先计算的信息的方法，用于加速使用XPath查询的诸如XML文档之类的分层文档上的昂贵查询的处理。本发明定义了这种结构的分类法，例如用于存储预先计算的XPath结果（PXR）的索引和物化视图，确定该结构可以评估查询的哪些部分，并且计算由结构生成的结果的补偿。本发明检测适用于查询的所有结构，并重写查询以使用这种结构，加速查询的执行。本发明通过检测查询中的XPath表达式和结构之间的容纳映射来识别匹配结构。本发明还包括XPath表达式的新表示，其足以表达XPath的所有特征。

38. 发明授权

US07185004B1 System and method for reverse routing materialized query tables in a database 有权
标题翻译：数据库中反向路由物化查询表的系统和方法
公开(公告)号：US07185004B1
公开(公告)日：2007-02-27
申请号：US11298853
申请日：2005-12-09
申请人： David Everett Simmen , Mir Hamid Pirahesh
发明人： David Everett Simmen , Mir Hamid Pirahesh
IPC分类号： G06F7/00 , G06F12/00
CPC分类号： G06F17/30457 , Y10S707/99933
摘要： A reverse routing system optimizes execution of a query that accesses data stored in one or more materialized query tables in a database of a computer system. The system receives a query directly referencing the materialized query table. The system identifies the referenced materialized query tables in a catalogue of materialized query tables and a defining query associated with the referenced materialized query table. The system substitutes the defining query for the referenced materialized query table in the received query. The system adds the referenced materialized query table to the set of eligible materialized query tables that are selected using query matching algorithms so that they can be considered for routing by the query optimizer.
摘要翻译：反向路由系统优化访问存储在计算机系统的数据库中的一个或多个物化查询表中的数据的查询的执行。系统接收直接引用物化查询表的查询。系统识别物化查询表目录中的引用物化查询表以及与引用的物化查询表关联的定义查询。系统将定义查询替换为接收到的查询中的引用的实例化查询表。系统将引用的实体化查询表添加到使用查询匹配算法选择的合格物化查询表集合，以便它们可以被查询优化器考虑进行路由选择。

39. 发明授权

US07020649B2 System and method for incrementally maintaining non-distributive aggregate functions in a relational database 失效
标题翻译：在关系数据库中逐步维护非分布式聚合函数的系统和方法
公开(公告)号：US07020649B2
公开(公告)日：2006-03-28
申请号：US10335376
申请日：2002-12-30
申请人： Roberta Jo Cochrane , Themistoklis Palpanas , Mir Hamid Pirahesh , Richard Sefton Sidle
发明人： Roberta Jo Cochrane , Themistoklis Palpanas , Mir Hamid Pirahesh , Richard Sefton Sidle
IPC分类号： G06F17/30
CPC分类号： G06F17/30383 , Y10S707/99933 , Y10S707/99935
摘要： A system for incrementally maintaining non-distributive aggregate functions in a relational database includes a data storage device in which a relational database is stored. A processor communicates with the data storage device and includes a database maintenance module. The database maintenance module includes a program for incrementally maintaining non-distributive aggregate functions in a relational database. The method embodied in the program includes determining whether all functions in a relational database query are distributive. Based on this determination, a basic propagate phase graph is selectively altered to yield a new propagate phase graph. Changes to an automatic summary table are then applied thereto based on the new propagate phase graph.
摘要翻译：用于在关系数据库中递增地维护非分布式聚合函数的系统包括存储关系数据库的数据存储设备。处理器与数据存储设备通信并且包括数据库维护模块。数据库维护模块包括用于在关系数据库中逐步维护非分布式聚合函数的程序。程序中包含的方法包括确定关系数据库查询中的所有功能是否是分布式的。基于该确定，选择性地改变基本传播相图以产生新的传播相图。然后根据新的传播阶段图，对自动摘要表进行更改。

40. 发明授权

US06993516B2 Efficient sampling of a relational database 有权
标题翻译：关系数据库的有效抽样
公开(公告)号：US06993516B2
公开(公告)日：2006-01-31
申请号：US10329892
申请日：2002-12-26
申请人： Peter Jay Haas , Guy Maring Lohman , Mir Hamid Pirahesh , David Everett Simmen , Ashutosh Vir Vikram Singh , Michael Jeffrey Winer , Markos Zaharioudakis
发明人： Peter Jay Haas , Guy Maring Lohman , Mir Hamid Pirahesh , David Everett Simmen , Ashutosh Vir Vikram Singh , Michael Jeffrey Winer , Markos Zaharioudakis
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30536 , Y10S707/99932 , Y10S707/99936
摘要： A system, method and computer readable medium for sampling data from a relational database are disclosed, where an information processing system chooses rows from a table in a relational database for sampling, wherein data values are arranged into rows, rows are arranged into pages, and pages are arranged into tables. Pages are chosen for sampling according to a probability P and rows in a selected page are chosen for sampling according to a probability R, so that the overall probability of choosing a row for sampling is Q=PR. The probabilities P and R are based on the desired precision of estimates computed from a sample, as well as processing speed. The probabilities P and R are further based on either catalog statistics of the relational database or a pilot sample of rows from the relational database.
摘要翻译：公开了一种用于从关系数据库采样数据的系统，方法和计算机可读介质，其中信息处理系统从用于采样的关系数据库中的表中选择行，其中数据值被排列成行，行被排列成页，并且页面排列成表。根据概率P选择页面进行采样，并根据概率R选择所选页面中的行进行采样，以便选择采样行的总体概率为Q = PR。概率P和R基于从样本计算的估计精度以及处理速度。概率P和R进一步基于关系数据库的目录统计数据或来自关系数据库的行的导频样本。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式