发明名称 |
Method of returning data during insert statement processing |
摘要 |
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.
|
申请公布号 |
US2005138010(A1) |
申请公布日期 |
2005.06.23 |
申请号 |
US20030744633 |
申请日期 |
2003.12.22 |
申请人 |
BERNAL MARGARET A.;CORNWELL KARELLE L.;CHENG HSUIYING Y.;CHEN YAO-CHING S.;CRONE CHRISTOPHER J.;LIN FEN-LING;PICKEL JAMES W.;TSUJI YUMI K.;WATTS JULIE A. |
发明人 |
BERNAL MARGARET A.;CORNWELL KARELLE L.;CHENG HSUIYING Y.;CHEN YAO-CHING S.;CRONE CHRISTOPHER J.;LIN FEN-LING;PICKEL JAMES W.;TSUJI YUMI K.;WATTS JULIE A. |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|