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

1. 发明授权

US5561797A Method for synchronizing transaction processing in a distributed heterogeneous system 失效
标题翻译：用于在分布式异构系统中同步事务处理的方法
公开(公告)号：US5561797A
公开(公告)日：1996-10-01
申请号：US425675
申请日：1995-04-18
申请人： Robert A. Gilles , Robert J. Grafe , Robert D. Jackson , Roger A. Reinsch , Richard R. Sanders , Jacob Slonim , Melvin R. Zimowski
发明人： Robert A. Gilles , Robert J. Grafe , Robert D. Jackson , Roger A. Reinsch , Richard R. Sanders , Jacob Slonim , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F9/46 , G06F15/00 , G06F17/00
CPC分类号： G06F9/466 , Y10S707/99938
摘要： The invention provides transaction synchronization in the form of COMMIT processing in a distributed, heterogeneous database system wherein some resources are synchronized to a transaction by a single-phase commit procedures while other resources synchronize by multi-phase commit procedures. The invention invests an application requestor at an application site with authority to represent all single-phase commit resources in multi-phase commit processing.
摘要翻译：本发明在分布式异构数据库系统中以COMMIT处理的形式提供事务同步，其中一些资源通过单阶段提交过程与事务同步，而其他资源通过多阶段提交过程同步。本发明在应用程序站点投资应用程序请求者，具有在多阶段提交处理中表示所有单阶段提交资源的权限。

2. 发明授权

US5257366A Query language execution on heterogeneous database servers using a bind-file bridge between application and database languages 失效
标题翻译：使用应用程序和数据库语言之间的绑定文件桥接在异构数据库服务器上查询语言执行
公开(公告)号：US5257366A
公开(公告)日：1993-10-26
申请号：US500032
申请日：1990-03-27
申请人： John G. Adair , Richard A. Demers , Dusan Ecimovic , Robert J. Grafe , Robert D. Jackson , Bruce G. Lindsay , Michael E. Murphy , Roger A. Reinsch , Robert P. Resch , Richard R. Sanders , Patricia G. Selinger , Robert L. Sunday , Melvin R. Zimowski
发明人： John G. Adair , Richard A. Demers , Dusan Ecimovic , Robert J. Grafe , Robert D. Jackson , Bruce G. Lindsay , Michael E. Murphy , Roger A. Reinsch , Robert P. Resch , Richard R. Sanders , Patricia G. Selinger , Robert L. Sunday , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F17/30 , G03F9/44 , G03F15/20
CPC分类号： G06F17/30557 , Y10S707/99934 , Y10S707/99939
摘要： Application programs which are developed and scheduled within a first computing system environment are permitted to access relational data registered at a remote database management system (DBMS) operating in a second computing environment dissimilar to the first computing environment. Access to data through the DBMS from an application execution site remote from the DBMS is supported by a process, logically subordinate to the application program which maps application program data access requests to the DBMS.

3. 发明授权

US5566332A Method and combination for minimizing data conversions when data is transferred between a first database storing data in a first format and a second database storing data in a second format 失效
标题翻译：当数据以第一格式存储数据的第一数据库和以第二格式存储数据的第二数据库之间传送时，最小化数据转换的方法和组合
公开(公告)号：US5566332A
公开(公告)日：1996-10-15
申请号：US288837
申请日：1994-08-11
申请人： John G. Adair , Daniel J. Coyle, Jr. , Robert J. Grafe , Bruce G. Lindsay , Roger A. Reinsch , Robert P. Resch , Patricia G. Selinger , Melvin R. Zimowski
发明人： John G. Adair , Daniel J. Coyle, Jr. , Robert J. Grafe , Bruce G. Lindsay , Roger A. Reinsch , Robert P. Resch , Patricia G. Selinger , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F17/30 , G06F15/163
CPC分类号： G06F17/30569 , Y10S707/922 , Y10S707/99942 , Y10S707/99954
摘要： The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver's native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system's native format, never FROM its native format into some other format.
摘要翻译：本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换的数据的上下文，并且可以最小化数据转换。本发明通过建立隔离机器特性，支持软件级别和用户数据描述的描述信息层来实现这一点。通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。在协作的数据库管理系统之间交换最小的描述信息。可能需要的任何数据转换只能由数据的接收者进行，并且只有在需要以接收方的本机格式表示的数据进行处理的时候才能进行。对于匹配的发送和接收系统，完全避免数据转换，即使数据可能已经通过不匹配的中间DBMS系统转发。对于不匹配的发送和接收系统，数据转换最小化。每个系统中的数据转换例程和表也通过仅将INTO转换为系统的本机格式，从不将其本机格式从其他格式转换为最小化。

4. 发明授权

US5416917A Heterogenous database communication system in which communicating systems identify themselves and convert any requests/responses into their own data format 失效
标题翻译：异构数据库通信系统，其中通信系统识别自身并将任何请求/响应转换成他们自己的数据格式
公开(公告)号：US5416917A
公开(公告)日：1995-05-16
申请号：US66323
申请日：1993-05-21
申请人： John G. Adair , Daniel J. Coyle, Jr. , Robert J. Grafe , Bruce G. Lindsay , Roger A. Reinsch , Robert P. Resch , Patricia G. Selinger , Melvin R. Zimowski
发明人： John G. Adair , Daniel J. Coyle, Jr. , Robert J. Grafe , Bruce G. Lindsay , Roger A. Reinsch , Robert P. Resch , Patricia G. Selinger , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F17/30 , G06F3/00 , G06F13/00
CPC分类号： G06F17/30569 , Y10S707/922 , Y10S707/99942 , Y10S707/99954
摘要： The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver's native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system's native format, never FROM its native format into some other format.
摘要翻译：本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换的数据的上下文，并且可以最小化数据转换。本发明通过建立隔离机器特性，支持软件级别和用户数据描述的描述信息层来实现这一点。通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。在协作的数据库管理系统之间交换最小的描述信息。可能需要的任何数据转换只能由数据的接收者进行，并且只有在需要以接收方的本机格式表示的数据进行处理的时候才能进行。对于匹配的发送和接收系统，完全避免数据转换，即使数据可能已经通过不匹配的中间DBMS系统转发。对于不匹配的发送和接收系统，数据转换最小化。每个系统中的数据转换例程和表也通过仅将INTO转换为系统的本机格式，从而将其本机格式从其他格式转换为最小化。

5. 发明授权

US4868744A Method for restarting a long-running, fault-tolerant operation in a transaction-oriented data base system without burdening the system log 失效
标题翻译：在面向事务的数据库系统中重新启动长时间运行的容错操作的方法，而不会对系统日志造成负担
公开(公告)号：US4868744A
公开(公告)日：1989-09-19
申请号：US835396
申请日：1986-03-03
申请人： Roger A. Reinsch , Melvin R. Zimowski
发明人： Roger A. Reinsch , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F11/14
CPC分类号： G06F11/1474 , G06F11/141 , G06F2201/80
摘要： A restartable load without logging method permits the restart of a LOAD operation from the last COMMIT point without requiring the writing of images of loaded records to the log. Instead, the method logs only a minimal amount of information, recording positions within the data sets to be loaded and within the tablespace being loaded.
摘要翻译：没有记录方法的可重新启动的加载允许从上一个COMMIT点重新启动LOAD操作，而不需要将加载的记录的映像写入日志。相反，该方法只记录最少量的信息，记录要加载的数据集中的位置和正在加载的表空间。

6. 发明授权

US5278978A Method and system for describing and exchanging data between heterogeneous database systems with data converted by the receiving database system 失效
标题翻译：用异构数据库系统与接收数据库系统转换数据之间的数据进行描述和交换的方法和系统
公开(公告)号：US5278978A
公开(公告)日：1994-01-11
申请号：US499114
申请日：1990-03-26
申请人： Richard A. Demers , Bruce G. Lindsay , Roger A. Reinsch , Melvin R. Zimowski
发明人： Richard A. Demers , Bruce G. Lindsay , Roger A. Reinsch , Melvin R. Zimowski
IPC分类号： G06F12/00 , G06F17/30 , G06F12/06
CPC分类号： G06F17/30569 , Y10S707/922 , Y10S707/99942 , Y10S707/99952
摘要： The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. For systems which match, data conversion is completely avoided. For systems which do not match, data conversion is minimized.
摘要翻译：本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换数据的上下文。本发明通过建立隔离机器特性，支持软件级别和用户数据描述的描述信息层来实现这一点。通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。在协作的数据库管理系统之间交换最小的描述信息。对于匹配的系统，完全避免数据转换。对于不匹配的系统，数据转换最小化。

7. 发明授权

US5615337A System and method for efficiently processing diverse result sets returned by a stored procedures 失效
标题翻译：用于有效处理由存储过程返回的各种结果集的系统和方法
公开(公告)号：US5615337A
公开(公告)日：1997-03-25
申请号：US417863
申请日：1995-04-06
申请人： Melvin R. Zimowski , Curt L. Cotner , Peter K. L. Shum
发明人： Melvin R. Zimowski , Curt L. Cotner , Peter K. L. Shum
IPC分类号： G06F17/30 , G06F15/40
CPC分类号： G06F17/3041 , G06F17/30415 , Y10S707/99933 , Y10S707/99939
摘要： A system for processing diverse and non-diverse result sets is described. The system includes a client process in a client computer system that constructs a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that the client process is capable of handling. The client process execution request is transferred from the client process in the client computer system to a server process in a server computer system. The server process invokes the stored procedure identified by the client process execution request. Execution of the stored procedure results in the generation of answer set data for a plurality of diverse query result sets. Result set generators obtain answer set data for X of the query result sets, where X is defined by the constraints. The server process then generates an initial response containing, for each of the X query result sets, an amount of the obtained answer set data consistent with the constraints. The initial response is transferred from the server computer system to the client process in the client computer system. The client application is then able to access and process answer set data for the diverse result sets in any order.
摘要翻译：描述了一种用于处理多样化和非多样化结果集的系统。该系统包括在客户端计算机系统中的客户端进程，其构建客户端进程执行请求，该客户端进程执行请求标识存储过程，并且指定客户端进程能够处理的响应数据量的约束。客户端进程执行请求从客户端计算机系统中的客户端进程传输到服务器计算机系统中的服务器进程。服务器进程调用由客户端进程执行请求标识的存储过程。存储过程的执行导致生成用于多个不同查询结果集的应答集数据。结果集生成器获取查询结果集的X的答案集数据，其中X由约束定义。然后，服务器进程生成包含针对X个查询结果集中的每一个的初始响应，所获得的答案集数据与约束一致。初始响应从服务器计算机系统传输到客户端计算机系统中的客户端进程。然后，客户端应用程序可以以任何顺序访问和处理各种结果集的应答集数据。

8. 发明授权

US5632015A Computer program product to efficiently process diverse result sets returned by a stored procedure 失效
标题翻译：用于有效处理存储过程返回的各种结果集的计算机程序产品
公开(公告)号：US5632015A
公开(公告)日：1997-05-20
申请号：US474111
申请日：1995-06-07
申请人： Melvin R. Zimowski , Curt L. Cotner , Peter K. L. Shum
发明人： Melvin R. Zimowski , Curt L. Cotner , Peter K. L. Shum
IPC分类号： G06F17/30
CPC分类号： G06F17/3041 , G06F17/30415 , Y10S707/99933 , Y10S707/99939
摘要： A system for processing diverse and non-diverse result sets is described. The system includes a client process in a client computer system that constructs a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that the client process is capable of handling. The client process execution request is transferred from the client process in the client computer system to a server process in a server computer system. The server process invokes the stored procedure identified by the client process execution request. Execution of the stored procedure results in the generation of answer set data for a plurality of diverse query result sets. Result set generators obtain answer set data for X of the query result sets, where X is defined by the constraints. The server process then generates an initial response containing, for each of the X query result sets, an amount of the obtained answer set data consistent with the constraints. The initial response is transferred from the server computer system to the client process in the client computer system. The client application is then able to access and process answer set data for the diverse result sets in any order.
摘要翻译：描述了一种用于处理多样化和非多样化结果集的系统。该系统包括在客户端计算机系统中的客户端进程，其构建客户端进程执行请求，该客户端进程执行请求标识存储过程，并且指定客户端进程能够处理的响应数据量的约束。客户端进程执行请求从客户端计算机系统中的客户端进程传输到服务器计算机系统中的服务器进程。服务器进程调用由客户端进程执行请求标识的存储过程。存储过程的执行导致生成用于多个不同查询结果集的应答集数据。结果集生成器获取查询结果集的X的答案集数据，其中X由约束定义。然后，服务器进程生成包含针对X个查询结果集中的每一个的初始响应，所获得的答案集数据与约束一致。初始响应从服务器计算机系统传输到客户端计算机系统中的客户端进程。然后，客户端应用程序可以以任何顺序访问和处理各种结果集的应答集数据。

9. 发明授权

US4956774A Data base optimizer using most frequency values statistics 失效
标题翻译：数据库优化器使用大多数频率值统计
公开(公告)号：US4956774A
公开(公告)日：1990-09-11
申请号：US239712
申请日：1988-09-02
申请人： Akira Shibamiya , Melvin R. Zimowski
发明人： Akira Shibamiya , Melvin R. Zimowski
IPC分类号： G06F17/30
CPC分类号： G06F17/30474 , G06F17/30952 , Y10S707/99932 , Y10S707/99933
摘要： A method for more accurately estimating the time required to process a data base query using a selected index. A selected number of the most frequently occurring index key values (38) are collected during an index sequential scan. These most frequency occurring values are stored as percentage frequencies of occurrence in the data base system's catalog (42). Estimated access and processing times (NPAR, NPAS, NCPU) for a given query are calculated based on the stored frequencies where possible. Where the query's search criteria specify values other than the stored most frequently occurring values, those values are assumed to be uniformly distributed.
摘要翻译：一种更精确地估计使用所选索引处理数据库查询所需时间的方法。在索引顺序扫描期间收集选定数量的最常出现的索引键值（38）。这些大多数频率出现的值以数据库系统目录中的百分比出现频率存储（42）。根据可能的存储频率计算给定查询的估计访问和处理时间（NPAR，NPAS，NCPU）。在查询的搜索条件指定除了存储的最常出现的值之外的值的情况下，假定这些值是均匀分布的。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式