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

1. 发明授权

US07231385B2 Method, system, and program for positioning a cursor on rows of a result table 有权
标题翻译：用于将光标定位在结果表的行上的方法，系统和程序
公开(公告)号：US07231385B2
公开(公告)日：2007-06-12
申请号：US10624964
申请日：2003-07-21
申请人： Margaret Ann Bernal , Christopher John Crone , Claire Willey McFeely , Kalpana Shyam , Julie Ann Watts
发明人： Margaret Ann Bernal , Christopher John Crone , Claire Willey McFeely , Kalpana Shyam , Julie Ann Watts
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/245 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942
摘要： Provided are a method, system, and program for making data available to an application program. A cursor is generated positioned with respect to a result table, wherein the cursor specifies a search criteria, and wherein the result table includes rows from a base table that satisfy the search criteria. A fetch request is received indicating to position the cursor on a plurality of rows of the result table. The cursor is positioned on the plurality of rows of the result table indicated in the fetch request that satisfy the search criteria.
摘要翻译：提供了一种使数据可用于应用程序的方法，系统和程序。生成相对于结果表定位的游标，其中光标指定搜索条件，并且其中结果表包括来自基表的满足搜索条件的行。接收到提取请求，指示将光标定位在结果表的多行上。光标位于满足搜索条件的获取请求中指示的结果表的多行。

2. 发明授权

US10089379B2 Method for sorting data 有权
公开(公告)号：US10089379B2
公开(公告)日：2018-10-02
申请号：US12193084
申请日：2008-08-18
申请人： Hong Min , Yefim Shuf , Hubertus Franke , Allan Benjamin Lebovitz , Christopher John Crone , Akiko Hoshikawa
发明人： Hong Min , Yefim Shuf , Hubertus Franke , Allan Benjamin Lebovitz , Christopher John Crone , Akiko Hoshikawa
IPC分类号： G06F17/30 , G06F7/36
摘要： A sequence of one or more input objects are sorted by identifying a property that is exhibited by a sequence of one or more input objects, determining whether each input object from the sequence of one or more input objects exhibits the property, storing each of the one or more input objects into a buffer, wherein an input object is stored in a first buffer if it exhibits the property and an input object is stored in a second buffer if it does not exhibit the property, sorting each of the one or more input objects in each buffer, and merging the one or more input objects in each buffer into a sequence of one or more input objects.

3. 发明授权

US08069193B2 Method and system for utilizing a generic scalar function to allow a column function to operate on row data 失效
标题翻译：用于利用通用标量函数以允许列函数对行数据进行操作的方法和系统
公开(公告)号：US08069193B2
公开(公告)日：2011-11-29
申请号：US09820451
申请日：2001-03-28
申请人： Jason Alexander Cu , Christopher John Crone , Andrei Fedorovich Lurie
发明人： Jason Alexander Cu , Christopher John Crone , Andrei Fedorovich Lurie
IPC分类号： G06F12/00 , G06F15/16 , G06F7/00 , G06F17/30 , G06F9/455
CPC分类号： G06F17/30595
摘要： A method and system for utilizing a column function for a relational database in a structure query language (SQL) environment is disclosed. The column function is capable of performing an operation on an indeterminate number of entries. The relational database utilizes data including a plurality of entries capable of being organized into at least one column and at least one row. The method and system include allowing a user to specify the at least one row as an argument for a generalized scalar function and simulating a column environment for the at least one row using the generalized scalar function to allow the at least one row to be provided to the column function as though the at least one row was a column. The method and system also include performing the column function on the at least one row to provide at least one output.
摘要翻译：公开了一种在结构查询语言（SQL）环境中利用关系数据库的列函数的方法和系统。列功能能够对不确定数量的条目执行操作。关系数据库利用包括能够被组织成至少一列和至少一行的多个条目的数据。所述方法和系统包括允许用户将所述至少一行指定为广义标量函数的参数，并且使用所述广义标量函数来模拟所述至少一行的列环境，以允许所述至少一行被提供给列的功能就好像至少有一行是一列。方法和系统还包括在至少一行上执行列函数以提供至少一个输出。

4. 发明申请

US20100042624A1 METHOD FOR SORTING DATA 审中-公开
标题翻译：分类数据的方法
公开(公告)号：US20100042624A1
公开(公告)日：2010-02-18
申请号：US12193084
申请日：2008-08-18
申请人： Hong Min , Yefim Shuf , Hubertus Franke , Allan Benjamin Lebovitz , Christopher John Crone , Akiko Hoshikawa
发明人： Hong Min , Yefim Shuf , Hubertus Franke , Allan Benjamin Lebovitz , Christopher John Crone , Akiko Hoshikawa
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30598 , G06F7/36 , G06F17/30607
摘要： Techniques for sorting a sequence of one or more input objects are provided. The techniques include identifying a property that is exhibited by a sequence of one or more input objects, determining whether each input object from the sequence of one or more input objects exhibits the property, storing each of the one or more input objects into a buffer, wherein an input object is stored in a first buffer if it exhibits the property and an input object is stored in a second buffer if it does not exhibit the property, sorting each of the one or more input objects in each buffer, and merging the one or more input objects in each buffer into a sequence of one or more input objects.
摘要翻译：提供了用于排序一个或多个输入对象的序列的技术。这些技术包括识别由一个或多个输入对象的序列呈现的属性，确定来自一个或多个输入对象的序列的每个输入对象是否呈现属性，将一个或多个输入对象中的每一个存储到缓冲器中，其中如果输入对象呈现所述属性并将输入对象存储在第二缓冲器中，如果不显示所述属性，则将输入对象存储在第一缓冲器中，对每个缓冲器中的所述一个或多个输入对象中的每一个进行排序，或更多的输入对象在一个或多个输入对象的序列中。

5. 发明授权

US06598041B1 Method, system, and program for processing modifications to data in tables in a database system 失效
标题翻译：用于在数据库中实现可滚动光标的方法，系统和程序
公开(公告)号：US06598041B1
公开(公告)日：2003-07-22
申请号：US09656558
申请日：2000-09-07
申请人： Margaret Ann Bernal , Christopher John Crone , Paramesh Desai , Georgia Carroll Fuller , Peter Hoa , Eric Naoto Katayama , William Y. Kyu , Kalpana Shyam , Julie Ann Watts , Jennifer Wha-Yuh Ou
发明人： Margaret Ann Bernal , Christopher John Crone , Paramesh Desai , Georgia Carroll Fuller , Peter Hoa , Eric Naoto Katayama , William Y. Kyu , Kalpana Shyam , Julie Ann Watts , Jennifer Wha-Yuh Ou
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99938 , Y10S707/99942 , Y10S707/99943 , Y10S707/99953
摘要： Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.
摘要翻译：提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。访问结果表以将请求的数据从基表返回到应用程序。

6. 发明授权

US07516138B2 Method for optimized parameter binding 失效
标题翻译：优化参数绑定的方法
公开(公告)号：US07516138B2
公开(公告)日：2009-04-07
申请号：US10676800
申请日：2003-09-30
申请人： Margaret Ann Bernal , Christopher John Crone , Andrei Fedorovich Lurie , Daya Vivek
发明人： Margaret Ann Bernal , Christopher John Crone , Andrei Fedorovich Lurie , Daya Vivek
IPC分类号： G06F17/00
CPC分类号： G06F17/30433
摘要： Disclosed is a technique for input parameter binding. When executing a statement, data in an application structure of the statement is compared with optimization information in a bind-in structure. When there is a match between the data in the application structure and data in the optimization information in the bind-in structure, the statement is executed with the optimization information.Also disclosed is a technique for output parameter binding. When executing a statement, data in an application structure of the statement is compared with optimization information in a bind-out structure. When there is a match between the data in the application structure and data in the optimization information in the bind-out structure, the statement is executed with the optimization information.
摘要翻译：公开了一种用于输入参数绑定的技术。执行语句时，将语句的应用程序结构中的数据与绑定结构中的优化信息进行比较。当应用程序结构中的数据与bind-in结构中的优化信息中的数据之间存在匹配时，该语句将使用优化信息执行。还公开了一种用于输出参数绑定的技术。执行语句时，将语句的应用程序结构中的数据与绑定结构中的优化信息进行比较。当应用程序结构中的数据与绑定结构中的优化信息中的数据之间存在匹配时，将使用优化信息执行该语句。

7. 发明授权

US06694305B2 Method, system, and program for processing modifications to data in tables in a database system 失效
标题翻译：用于处理数据库系统表中数据修改的方法，系统和程序
公开(公告)号：US06694305B2
公开(公告)日：2004-02-17
申请号：US09915866
申请日：2001-07-26
申请人： Margaret Ann Bernal , Christopher John Crone , San Yu Phoenix , Kalpana Shyam , James Zu-Chia Teng , Julie Ann Watts
发明人： Margaret Ann Bernal , Christopher John Crone , San Yu Phoenix , Kalpana Shyam , James Zu-Chia Teng , Julie Ann Watts
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99938 , Y10S707/99942 , Y10S707/99943 , Y10S707/99953
摘要： Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.
摘要翻译：提供了一种用于使数据可用于应用程序的方法，系统，程序和数据结构。生成结果表，其中包括与基表中具有满足查询谓词子句的一个或多个列中的数据的行子集相对应的行。结果表对于每一行包括基表中相应行的位置标识符和查询选择列表中每列的列。访问结果表以将请求的数据从基表返回到应用程序。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式