公开(公告)号：US07711730B2

公开(公告)日：2010-05-04

申请号：US10744633

申请日：2003-12-22

申请人： Margaret A. Bernal ,  Karelle L. Cornwell ,  Hsuiying Y. Cheng ,  Yao-Ching S. Chen ,  Christopher J. Crone ,  Fen-Ling Lin ,  James W. Pickel ,  Yumi K. Tsuji ,  Julie A. Watts

发明人： Margaret A. Bernal ,  Karelle L. Cornwell ,  Hsuiying Y. Cheng ,  Yao-Ching S. Chen ,  Christopher J. Crone ,  Fen-Ling Lin ,  James W. Pickel ,  Yumi K. Tsuji ,  Julie A. Watts

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30463

摘要： A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.

摘要翻译： 一种用于生成用于在单个进程中从数据库更新和检索数据的执行计划的方法包括：由服务器接收用第一组数据更新数据库的语句，并从数据库中检索第二组数据; 构建第一个执行计划，用第一组数据更新数据库; 构建第二个执行计划以从数据库中检索第二组数据; 并构建包括第一和第二执行计划的组合的单个执行计划。 单个执行计划允许通过客户端和数据库之间的接口的单个​​交叉来更新和检索数据。 通过以这种方式执行这两个功能，在数据库上执行这样的任务的效率显着增加。