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

1. 发明授权

US6105017A Method and apparatus for deferring large object retrievals from a remote database in a heterogeneous database system 失效
标题翻译：用于在异构数据库系统中从远程数据库推迟大对象检索的方法和装置
公开(公告)号：US6105017A
公开(公告)日：2000-08-15
申请号：US929642
申请日：1997-09-15
申请人： James Charles Kleewein , Eileen Tien Lin , Hemant Maheshwari , Tina Louise Mukai , Steven John Watts
发明人： James Charles Kleewein , Eileen Tien Lin , Hemant Maheshwari , Tina Louise Mukai , Steven John Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , Y10S707/99932
摘要： A database management method enables an improved efficiency processing action in a computer wherein manipulation of data from a table is required in accord with a query request, wherein the table is stored remotely from said computer and at least some data in the table includes large data objects (LOBs). The method includes the steps of: responding to the request by transmitting a query to the table; configuring a result set from the table in response to the query, wherein the result set includes one or more unique identifiers of any LOB data associated with the result set; receiving the result set and performing a data manipulation action on data contained in the result set to form a response; transferring the response to the query requester; and accessing LOB data from the table that is referenced by the one or more unique identifiers in the result set and causing transfer of the LOB data to the query requester.
摘要翻译：数据库管理方法能够在计算机中改进效率处理动作，其中根据查询请求对表中的数据进行操作，其中该表从所述计算机远程存储，并且该表中的至少一些数据包括大数据对象（LOB）。该方法包括以下步骤：通过向表发送查询来响应该请求; 从所述表中配置响应于所述查询的结果集，其中所述结果集包括与所述结果集相关联的任何LOB数据的一个或多个唯一标识符; 接收结果集并对包含在结果集中的数据执行数据操作动作以形成响应; 将响应传送给查询请求者; 以及从结果集中的一个或多个唯一标识符引用的表中访问LOB数据，并导致将LOB数据传送到查询请求者。

2. 发明授权

US5956727A Heterogeneous database system with data source extensibility and alteration of database functions 失效
标题翻译：具有数据源可扩展性和数据库功能更改的异构数据库系统
公开(公告)号：US5956727A
公开(公告)日：1999-09-21
申请号：US929809
申请日：1997-09-15
申请人： Tu-An Cheng , James Charles Kleewein , Eileen Tien Lin , Tina Louise Mukai , Yun Wang , Steven John Watts
发明人： Tu-An Cheng , James Charles Kleewein , Eileen Tien Lin , Tina Louise Mukai , Yun Wang , Steven John Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30566 , Y10S707/99933 , Y10S707/99943 , Y10S707/99945
摘要： A heterogeneous database system is described which includes plural database systems, one of the database systems acting as an interface (i.e., system manager). The system manager performs functions which provide an application program with transparent access to the entire database system. The system manager includes a memory for storing (i) a matrix of functional capabilities of each of the plural databases, (ii) a catalog of functions that are supportable by various databases and (iii) and entry matrix for providing an interface function between a user and the system manager. A processor is present in the system manager; and is responsive to a user entry, via the entry matrix, with respect to a functional capability of one of the plural databases, to alter a matrix of functional capabilities pertaining to the database. The alteration is carried out in accordance with a corresponding functional capability entry in the catalog. If a user entry is received which refers to a database for which no entry exists in the matrix of functional capabilities, the system manager presents an entry matrix in a form which reflects default functional capabilities. Thereafter, the default capabilities may be altered by a system administrator to reflect the capabilities of the new database.
摘要翻译：描述了一种异构数据库系统，其包括多个数据库系统，数据库系统之一充当接口（即系统管理器）。系统管理员执行向整个数据库系统提供透明访问的应用程序的功能。系统管理器包括用于存储（i）多个数据库中的每一个的功能性能矩阵的存储器，（ii）可由各种数据库支持的功能目录，以及（iii）和用于提供接口功能之间的接口功能的输入矩阵用户和系统管理员。处理器存在于系统管理器中; 并且相对于所述多个数据库之一的功能能力经由所述条目矩阵来响应于用户条目，以改变与所述数据库相关的功能能力的矩阵。该变更根据目录中相应的功能能力条目进行。如果接收到指向功能能力矩阵中没有条目的数据库的用户条目，则系统管理器以反映默认功能能力的形式呈现条目矩阵。此后，系统管理员可以更改默认功能以反映新数据库的功能。

3. 发明授权

US5943666A Method and apparatus for optimizing queries across heterogeneous databases 失效
标题翻译：用于优化跨异构数据库的查询的方法和装置
公开(公告)号：US5943666A
公开(公告)日：1999-08-24
申请号：US929877
申请日：1997-09-15
申请人： James Charles Kleewein , Eileen Tien Lin , Tina Louise Mukai , Shivakumar Venkataraman
发明人： James Charles Kleewein , Eileen Tien Lin , Tina Louise Mukai , Shivakumar Venkataraman
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30545 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A heterogeneous database system includes plural databases, one database acting as a system manager which performs functions to provide a transparent user interface that encompasses both the system manager database and other databases. The system manager includes a memory which stores (i) a database management procedure, (ii) a catalog of database functions that are supported by the plural databases, and (iii) a query optimizer procedure. A processor is responsive to a user query which requires data stored at a remote database, to execute the query optimizer procedure. The query optimizer procedure employs entries from the catalogue relating to database functions supported by both the system manager database and the remote database and establishes query plans for responding to the query. A first query plan is based upon execution at the remote database and a second query plan is based upon execution at the system manager database. The query optimizer then chooses one of the query plans in accordance with a determined criteria and causes the selected plan to be executed.
摘要翻译：异构数据库系统包括多个数据库，一个作为系统管理器的数据库，其执行功能以提供包含系统管理器数据库和其他数据库的透明用户界面。系统管理器包括存储器（i）数据库管理过程，（ii）由多个数据库支持的数据库功能的目录，以及（iii）查询优化器过程。处理器响应于需要在远程数据库处存储的数据的用户查询来执行查询优化器过程。查询优化器过程采用与目录相关的条目，与数据库功能相关的数据库功能由系统管理器数据库和远程数据库支持，并建立响应查询的查询计划。第一个查询计划是基于远程数据库上的执行，第二个查询计划是基于在系统管理器数据库执行的。查询优化器然后根据确定的标准选择一个查询计划，并导致所选择的计划被执行。

4. 发明授权

US6009428A System and method for providing a single application program interface for heterogeneous databases 失效
标题翻译：为异构数据库提供单个应用程序接口的系统和方法
公开(公告)号：US6009428A
公开(公告)日：1999-12-28
申请号：US931008
申请日：1997-09-15
申请人： James Charles Kleewein , Eileen Tien Lin , Tina Louise Mukai , Yun Wang
发明人： James Charles Kleewein , Eileen Tien Lin , Tina Louise Mukai , Yun Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/30569 , Y10S707/99932
摘要： An application program interface at a local processor enables transparent access to both a local database and a remote database. The remote database includes (i) a remote DBMS which segregates data into distinct remote datatype categories and (ii) remote data functions which define functions that are executable by the remote DBMS with respect to categories of remote datatypes. The local processor includes a memory which stores (i) a local DBMS that includes local datatypes which segregate locally stored data into local datatypes; (ii) local functions which define actions that are executable by the local DBMS with respect to defined categories of the local datatypes, and (iii) tables which store a mapping between local datatypes and remote datatypes, and local functions and remote functions. The mapping between at least one local datatype and at least one remote datatype indicates that the remote datatype is to be transformed into a local defined datatype that is different than the remote datatype. A local processor employs the table to convert a received instance of the at least one remote datatype to a mapped local datatype and subjects data comprising the instance of the remote datatype to a local function which is not executable for the remote datatype. The application program interface further enables specification of a function to be carried out at the remote database with respect to data stored thereat, which function is not readily performable by the local processor.
摘要翻译：本地处理器上的应用程序接口可实现对本地数据库和远程数据库的透明访问。远程数据库包括（i）远程DBMS，其将数据分离成不同的远程数据类型类别，以及（ii）远程数据功能，其定义关于远程数据类型的远程DBMS可执行的功能。本地处理器包括存储器（i）本地DBMS，其包括将本地存储的数据分离成本地数据类型的本地数据类型; （ii）定义本地DBMS相对于本地数据类型的定义类别可执行的操作的本地功能，以及（iii）存储本地数据类型和远程数据类型之间的映射以及本地功能和远程功能的表。至少一个本地数据类型与至少一个远程数据类型之间的映射表明远程数据类型将被转换为与远程数据类型不同的本地定义的数据类型。本地处理器使用该表将所接收的至少一个远程数据类型的实例转换为映射的本地数据类型，并将包含远程数据类型的实例的数据主题转换为对远程数据类型不可执行的本地功能。应用程序接口还能够指定要在远程数据库处执行的功能，该功能关于存储在其上的数据，该功能不容易被本地处理器执行。

5. 发明授权

US5920860A Method and apparatus for accessing of large object data segments from a remote database 失效
标题翻译：用于从远程数据库访问大对象数据段的方法和装置
公开(公告)号：US5920860A
公开(公告)日：1999-07-06
申请号：US931002
申请日：1997-09-15
申请人： Hemant Maheshwari , Tina Louise Mukai , Steven John Watts
发明人： Hemant Maheshwari , Tina Louise Mukai , Steven John Watts
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , Y10S707/99932 , Y10S707/99935
摘要： A method enables a computer to manipulate data from a table in a remote database in accord with a query from a query requestor, wherein at least some data in the table includes large data objects (LOBs). The method includes the steps of: responding to the query by configuring a database query and determining (i) if a response to the database query requires transfer of LOB data from the table and if yes, and (ii) the LOB data can be transferred in response to the database query without a data manipulation which uses the LOB data or (iii) a data manipulation required in response to the database query which uses the LOB data can be performed at the remote database, then designating the LOB data for "streaming"; dispatching the database query to the remote database and receiving a result set from the table from the remote database in response to the query; and storing the result set and causing any LOB data which has been marked for streaming to be then dispatched to the query requestor without being written to disk.
摘要翻译：一种方法使得计算机能够根据来自查询请求者的查询操纵来自远程数据库中的表的数据，其中表中的至少一些数据包括大数据对象（LOB）。该方法包括以下步骤：通过配置数据库查询来响应查询，并确定（i）对数据库查询的响应是否需要从表中传输LOB数据，如果是，则（ii）可以转移LOB数据响应于没有使用LOB数据的数据操作的数据库查询，或者（iii）可以在远程数据库处执行响应于使用LOB数据的数据库查询所需的数据操作，然后指定用于“流”的LOB数据 “; 将数据库查询分派到远程数据库，并响应于查询从远程数据库从表中接收结果集; 并且存储结果集并且使得已经标记为流的任何LOB数据然后被分派到查询请求者而不被写入到盘。

6. 发明授权

US06526403B1 Method, computer program product, and system for rewriting database queries in a heterogenous environment 失效
标题翻译：方法，计算机程序产品和用于在异构环境中重写数据库查询的系统
公开(公告)号：US06526403B1
公开(公告)日：2003-02-25
申请号：US09466492
申请日：1999-12-17
申请人： Eileen Tien Lin , Tina Louise Mukai , Shivakumar Venkataraman , Tian Zhang
发明人： Eileen Tien Lin , Tina Louise Mukai , Shivakumar Venkataraman , Tian Zhang
IPC分类号： G06F1730
CPC分类号： G06F17/30463 , Y10S707/99934
摘要： A method, computer product, and system for rewriting database without decreasing pushdownability is provided. First, a pushdown analysis of the query in its entirety is performed prior to the application of any query rewrite rules in order to establish a baseline on pushdownability for the query. The results of this analysis is stored with the internal query representation. After each rule is applied to rewrite a portion of a query, that rewritten portion is analyzed again for pushdownability. If pushdownability is not decreased, then the rewritten query remains and the internal representation of the query is updated to reflect the pushdownability of that portion. If pushdownability is decreased, then an undo operation is applied to the rewritten portion of the query to back out the effects of the rule and leave the query in the same state as before the rewrite. Finally, additional rewrite rules that are directed to the heterogeneous database environment are also provided.
摘要翻译：提供了一种用于重写数据库而不降低可压缩性的方法，计算机产品和系统。首先，在应用任何查询重写规则之前执行整个查询的下推分析，以便建立查询的可推式性的基线。该分析的结果与内部查询表示一起存储。每个规则应用于重写查询的一部分后，再次分析重写的部分以进行推测。如果下推性不降低，则重写的查询将保留，并更新查询的内部表示形式，以反映该部分的可推移性。如果可压缩性降低，则对查询的重写部分应用撤消操作，以排除规则的影响，并使查询处于与重写前相同的状态。最后，还提供了针对异构数据库环境的其他重写规则。

7. 发明授权

US08387028B2 Determining a target data type in a heterogeneous multi-level environment 失效
标题翻译：确定异构多级环境中的目标数据类型
公开(公告)号：US08387028B2
公开(公告)日：2013-02-26
申请号：US12110187
申请日：2008-04-25
申请人： Lan Huang , Eileen Tien Lin , Tina Louise Mukai , Amit Radheshyam Somani , Yang Sun
发明人： Lan Huang , Eileen Tien Lin , Tina Louise Mukai , Amit Radheshyam Somani , Yang Sun
IPC分类号： G06F9/45 , G06F17/00 , G06F7/00
CPC分类号： G06F17/30566 , Y10S707/99945
摘要： An apparatus and computer program product determine a target data type in an environment having a plurality of levels. The plurality of levels comprise a source level, zero or more intermediate levels, and a target level. The zero or more intermediate levels are between the source level and the target level. A target data type representing a transformation of a data type of an associated datum as the datum passes from the source level through the zero or more intermediate levels to the target level is generated. The target data type comprises a sequence of nested transformation functions having an innermost transformation function and an outermost transformation function.
摘要翻译：设备和计算机程序产品在具有多个级别的环境中确定目标数据类型。多个级别包括源级别，零级或更多级别以及目标级别。零个或多个中间级别在源级别和目标级别之间。生成表示当基准从源级别通过零个或多个中间级别传递到目标级别时的关联数据的数据类型的变换的目标数据类型。目标数据类型包括具有最内变换函数和最外变换函数的嵌套变换函数序列。

8. 发明申请

US20090055362A1 SYSTEM AND COMPUTER PROGRAM PRODUCT FOR PERFORMING AN INEXACT QUERY TRANSFORMATION IN A HETEROGENEOUS ENVIRONMENT 失效
标题翻译：用于执行异构环境中的INEXACT QUERY转换的系统和计算机程序产品
公开(公告)号：US20090055362A1
公开(公告)日：2009-02-26
申请号：US12259979
申请日：2008-10-28
申请人： Lan HUANG , Eileen Tien Lin , Tina Louise Mukai
发明人： Lan HUANG , Eileen Tien Lin , Tina Louise Mukai
IPC分类号： G06F17/30
CPC分类号： G06F17/30427 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： An inexact query transformation system selects a query element from a query statement. If an inexact transformation improves the query performance, the system prioritizes the candidate transformation rules applicable to the selected query element. The system applies the candidate transformation rules to the selected query element to generate a transformed query element that includes a transformed remote query element. If the transformed remote query element is pushdownable, the system adds the transformed remote query element to a transformed inexact query output. Otherwise, the system applies additional candidate transformation rules to the selected query element to generate the transformed inexact query output. The system applies the transformed inexact query output to a heterogeneous datastore to provide an output query result.
摘要翻译：不精确的查询转换系统从查询语句中选择查询元素。如果不精确的转换提高了查询性能，系统将适用于所选查询元素的候选转换规则确定优先级。系统将候选变换规则应用于所选择的查询元素，以生成包含经变换的远程查询元素的变换查询元素。如果转换后的远程查询元素是可下载的，则系统将转换后的远程查询元素添加到已转换的不精确查询输出。否则，系统对所选择的查询元素应用附加的候选变换规则以生成变换的不精确查询输出。系统将转换的不精确查询输出应用于异构数据存储区以提供输出查询结果。

9. 发明申请

US20080201345A1 Apparatus and Article of Manufacture For Determining a Target Data Type In a Heterogeneous Multi-Level Environment 失效
标题翻译：用于确定异构多层环境中的目标数据类型的装置和制造
公开(公告)号：US20080201345A1
公开(公告)日：2008-08-21
申请号：US12110187
申请日：2008-04-25
申请人： Lan Huang , Eileen Tien Lin , Tina Louise Mukai , Amit Radheshyam Somani , Yang Sun
发明人： Lan Huang , Eileen Tien Lin , Tina Louise Mukai , Amit Radheshyam Somani , Yang Sun
IPC分类号： G06F17/30
CPC分类号： G06F17/30566 , Y10S707/99945
摘要： An apparatus and article of manufacture for determining a target data type in an environment having a plurality of levels are provided. Zero or more intermediate levels are between the source level and the target level. A target data type representing the transformation of a data type of an associated datum as the datum passes from the source level through the zero or more intermediate levels to the target level is generated. In another aspect of the invention, the datum is assigned to the target level in accordance with the target data type. In yet another aspect of the invention, the target data type is passed with the associated datum, via the zero or more intermediate levels to the target level.
摘要翻译：提供了一种用于在具有多个级别的环境中确定目标数据类型的装置和制品。零级或更多的中间级别在源级别和目标级别之间。生成表示当基准从源级别通过零个或多个中间级别传递到目标级别时相关联的数据的数据类型的变换的目标数据类型。在本发明的另一方面，根据目标数据类型将数据分配给目标级别。在本发明的另一方面，目标数据类型通过相关联的数据经由零个或多个中间级别传递到目标级别。

10. 发明授权

US07856462B2 System and computer program product for performing an inexact query transformation in a heterogeneous environment 失效
标题翻译：用于在异构环境中执行不精确查询转换的系统和计算机程序产品
公开(公告)号：US07856462B2
公开(公告)日：2010-12-21
申请号：US12259979
申请日：2008-10-28
申请人： Lan Huang , Eileen Tien Lin , Tina Louise Mukai
发明人： Lan Huang , Eileen Tien Lin , Tina Louise Mukai
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30427 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： An inexact query transformation system selects a query element from a query statement. If an inexact transformation improves the query performance, the system prioritizes the candidate transformation rules applicable to the selected query element. The system applies the candidate transformation rules to the selected query element to generate a transformed query element that includes a transformed remote query element. If the transformed remote query element is pushdownable, the system adds the transformed remote query element to a transformed inexact query output. Otherwise, the system applies additional candidate transformation rules to the selected query element to generate the transformed inexact query output. The system applies the transformed inexact query output to a heterogeneous datastore to provide an output query result.
摘要翻译：不精确的查询转换系统从查询语句中选择查询元素。如果不精确的转换提高了查询性能，系统将适用于所选查询元素的候选转换规则确定优先级。系统将候选变换规则应用于所选择的查询元素，以生成包含经变换的远程查询元素的变换查询元素。如果转换后的远程查询元素是可下载的，则系统将转换后的远程查询元素添加到已转换的不精确查询输出。否则，系统对所选择的查询元素应用附加的候选变换规则以生成变换的不精确查询输出。系统将转换的不精确查询输出应用于异构数据存储区以提供输出查询结果。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式