Parallel database system retrieval method of a relational database management system using initial data retrieval query and subsequent sub-data utilization query processing for minimizing query time

Claim 3

A method according to claim 1, wherein said retrieving step retrieves said sub-data items of said data from said database operation server based on said location information and dictionary information concerning locations of said sub-data items within said data and sub-data identifiers necessary for queries.

Claim 4

A method according to claim 1 further comprising the step of: performing a process using the retrieved sub-data items.

Claim 5

A method according to claim 2 further comprising the step of: performing a process using the retrieved sub-data items.

Claim 6

A method according to claim 1, wherein said location information comprises: an identifier of said database operation server having retrieved said data and an address of said data within said database operation server.

Claim 7

A method according to claim 2, wherein said dictionary information of locations of said sub-data items within said data comprises: offset values representing locations of said sub-data items relative to a starting address, said sub-data items being clustered within said data.

Claim 8

A method according to claim 2, wherein said data comprises: offset values representing locations of said sub-data items relative to a starting address, said sub-data items being clustered within said data, and wherein a sub-data item is retrieved by use of said offset value extracted.

Claim 9

A method according to claim 4, wherein, when said process using said retrieved sub-data items is an update of the retrieved data, an internal-format procedure for providing an update is sent together with said location information of said data and said dictionary information of the locations of said sub-data items to said database operation server, so that said internal-format procedure in operation uses the retrieved sub-data items on the side of said database operation server.

Claim 12

A method according to claim 9, wherein in said first process said sub-data items of said data is retrieved from said database operation server based on said location information and dictionary information about locations of said sub-data items within said data and said sub-data identifiers necessary for queries.

Claim 13

A method according to claim 9, wherein said first process further comprises: performing a process using the retrieved sub-data items.

Claim 14

A method according to claim 10, wherein said first process further comprises: performing a process using the retrieved sub-data items.

Claim 15

A method according to claim 10, wherein said predetermined selection criteria involve calculating costs of said first and said second processes based on said dictionary information including sub-data lengths, and comparing the two processes in terms of calculated costs, so that a more cost-effective one of said two processes is selected.

Claim 16

A method according to claim 10, wherein said predetermined selection criteria require that said first process be selected if any sub-data item within said data is longer than a reference value stipulated by the system, and that said second process be selected if no sub-data item within said data is longer than said reference value.

Claim 17

A method according to claim 10, wherein, upon retrieval of data including a plurality of sub-data items, a result of processing returned from said front end server to a user application program includes flag information indicating either that said data has been transferred to said front end server or that not said data but location information of said data has been transferred to said front end server; and wherein said flag information is used to generate an internal-format procedure corresponding to either said first process or said second process which has been selected, so that any of said plurality of sub-data items in said data is used for processing, control and database operations subsequent to the retrieval of said data.

Claim 18

A parallel database retrieval system comprising: a front end server for analyzing queries about a database; and a plurality of database operation servers connected to said front end server by a network, for operating a database, wherein said database operation servers retrieve data from said database, and said front end server processes and controls data retrieved by said database operation servers, and wherein said front end server causes a database operation server, upon retrieval of data including a plurality of sub-data items indicating attributes of an Abstract Data Type (ADT), to return location information about said data as a retrieval result to said front end server, and retrieves said sub-data items of said data from said database operation server based on said location information so that any of said sub-data items in said data is used for processing, control and database operations subsequent to the retrieval of said data.

Claim 19

A parallel database retrieval system comprising: a front end server for analyzing queries about a database; and a plurality of database operation servers connected to said front end server by a network, for operating a database, wherein said database operation servers retrieve data from said database, and said front end server processes and controls data retrieved by said database operation servers, and wherein said front end server causes a database operation server, upon retrieval of data including a plurality of sub-data items indicating attributes of an Abstract Data Type (ADT), to return location information about said data as a retrieval result to said front end server, and retrieves said sub-data items of said data from said database operation server based on said location information so that any of said sub-data items in said data is used for processing, control and database operations subsequent to the retrieval of said data.

Claim 20

A parallel database retrieval system according to claim 16, wherein said front end server retrieves said sub-data items of said data from said database operation server based on said location information and dictionary information concerning locations of said sub-data items within said data and sub-data identifiers necessary for queries.

Claim 21

A parallel database retrieval system according to claim 16, wherein said front end server performs a process using the retrieved sub-data items.

Claim 22

A parallel database retrieval system according to claim 17, wherein said front end server performs a process using the retrieved sub-data items.

Claim 23

A parallel database retrieval system according to claim 16, wherein said location information comprises: an identifier of said database operation server having retrieved said data and an address of said data within said database operation server.

Claim 24

A parallel database retrieval system according to claim 17, wherein said dictionary information of locations of said sub-data items within said data comprises: offset values representing locations of said sub-data items relative to a starting address, said sub-data items being clustered within said data.

Claim 25

A parallel database retrieval system according to claim 17, wherein said data comprises: offset values representing locations of said sub-data items relative to a starting address, said sub-data items being clustered within said data, and wherein a sub-data item is retrieved by use of said offset value extracted.

Claim 26

A parallel database retrieval system according to claim 19, wherein said front end server, when said process using said retrieved sub-data items is an update of the retrieved data, sends an internal-format procedure for providing an update together with said location information of said data and said dictionary information of the locations of said sub-data items to said database operation server, so that said internal-format procedure in operation uses the retrieved sub-data items on the side of said database operation server.

Claim 27

A parallel database retrieval system comprising: a front end server for analyzing queries about a database; and a plurality of database operation servers connected to said front end server by a network, for operating a database, wherein said database operation servers retrieve data from said database, and said front end server processes and controls data retrieved by said database operation servers, and wherein said front end server performs a first process of causing a database operation server, upon retrieval of data including a plurality of sub-data items indicating attributes of an Abstract Data Type (ADT), to return location information about the retrieved data as a retrieval result to said front end server, and retrieves said sub-data items of said data from said database operation server based on said location information so that any of said plurality of sub-data items from said data is used for processing, control and database operations subsequent to the retrieval of said data, and performs a second process of causing a database operation server, upon retrieval of data including a plurality of sub-data items indicating attributes of said Abstract Data Type (ADT), to return the retrieved data including sub-data items as a retrieval result to said front end server, and retrieves said sub-data items of said data from said front end server for processing, control and database operations subsequent to the retrieval of said data, wherein one of said first and second processes is selected by said front end server in accordance with predetermined selection criteria upon analysis of a query, so that an internal-format procedure corresponding to the selected process is generated and executed.

Claim 28

A parallel database retrieval system comprising: a front end server for analyzing queries about a database; and a plurality of database operation servers connected to said front end server by a network, for operating a database, wherein said database operation servers retrieve data from said database, and said front end server processes and controls data retrieved by said database operation servers, and wherein said front end server performs a first process of causing a database operation server, upon retrieval of data including a plurality of sub-data items indicating attributes of an Abstract Data Type (ADT), to return location information about the retrieved data as a retrieval result to said front end server, and retrieves said sub-data items of said data from said database operation server based on said location information so that any of said plurality of sub-data items from said data is used for processing, control and database operations subsequent to the retrieval of said data, and performs a second process of causing a database operation server, upon retrieval of data including a plurality of sub-data items indicating attributes of said Abstract Data Type (ADT), to return the retrieved data including sub-data items as a retrieval result to said front end server, and retrieves said sub-data items of said data from said front end server for processing, control and database operations subsequent to the retrieval of said data, wherein one of said first and second processes is selected by said front end server in accordance with predetermined selection criteria upon analysis of a query, so that an internal-format procedure corresponding to the selected process is generated and executed.

Claim 29

A parallel database retrieval system according to claim 24, wherein in said first process performed by said front end server said sub-data items of said data is retrieved from said database operation server based on said location information and dictionary information of locations of said sub-data items within said data and said sub-data identifiers necessary for queries.

Claim 30

A parallel database retrieval system according to claim 24, wherein said first process performed by said front end server comprises: performing a process using the retrieved sub-data items.

Claim 31

A parallel database retrieval system according to claim 25, wherein said first process performed by said front end server comprises: performing a process using the retrieved sub-data items.

Claim 32

A parallel database retrieval system according to claim 25, wherein said predetermined selection criteria involve calculating costs of said first and said second processes based on said dictionary information including sub-data lengths, and comparing the two processes in terms of calculated costs, so that a more cost-effective one of said two processes is selected.

Claim 33

A parallel database retrieval system according to claim 25, wherein said predetermined selection criteria require that said first process be selected if any sub-data item within said data is longer than a reference value stipulated by the system, and that said second process be selected if no sub-data item within said data is longer than said reference value.

Claim 34

A parallel database retrieval system according to claim 25, wherein, upon retrieval of data including a plurality of sub-data items, a result of processing returned from said front end server to a user application program includes flag information indicating either that said data has been transferred to said front end server or that not said data but location information of said data has been transferred to said front end server; and wherein said flag information is used to generate an internal-format procedure corresponding to either said first process or said second process which has been selected, so that any of said plurality of sub-data items in said data is used for processing, control and database operations subsequent to the retrieval of said data.

Claim 35

A database system, comprising: a plurality of data operation servers which operate a database, and which retrieve data from said database; and a front end server connected to said data operation servers, which controls and analyzes queries about said database, including a data retrieval query to retrieve data containing a plurality of sub-data items indicating attributes of an Abstract Data Type (ADT) from selected ones of said data operation servers, and a sub-data utilization query to retrieve only selected sub-data items from said data retrieved from a database operation.

Claim 36

A database system, comprising: a plurality of data operation servers which operate a database, and which retrieve data from said database; and a front end server connected to said data operation servers, which controls and analyzes queries about said database, including a data retrieval query to retrieve data containing a plurality of sub-data items indicating attributes of an Abstract Data Type (ADT) from selected ones of said data operation servers, and a sub-data utilization query to retrieve only selected sub-data items from said data retrieved from a database operation.

Claim 37

A database system according to claim 31, wherein said front end server retrieves said sub-data items of said data from said selected ones of said database operation servers based on location information and dictionary information concerning locations of said sub-data items within said data and sub-data identifiers necessary for said queries.

Claim 38

A database system according to claim 31, wherein said location information comprises an identifier of said selected ones of said database operation servers having retrieved said data and an address of said data within said selected one of said database operation servers.

Claim 39

A database system according to claim 31, wherein said dictionary information of locations of said sub-data items within said data comprises offset values representing locations of said sub-data items relative to a starting address, said sub-data items being clustered within said data.