Querying database system to execute stored procedures using abstract data type attributes, retrieving location information of data, sub-data between first and second servers

A method in a parallel database system having a front end server for analyzing queries about a database and a plurality of database operation servers for operating said database, said front end server being connected with said database operation servers by a network, said database operation servers retrieving data from said database, and said front end server processing and controlling retrieved data, said method comprising:

• a first process of causing a database operation server, upon retrieval of data including a plurality of sub-data items, to return location information about the retrieved data as a retrieval result to said front end server, and retrieving 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 in said data is used for processing, control and database operations subsequent to the retrieval of said data;
• and
• a second process of causing a database operation server, upon retrieval of data including a plurality of sub-data items, to return the retrieved data including sub-data items as a retrieval result to said front end server, and retrieving 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 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.

A parallel database retrieval system comprising:

• a front end server for analyzing queries about a database;
• and
• a plurality of database operation servers for operating a database, said database operation servers being connected to said front end server by a network,
• wherein said database operation servers retrieve data from said database, and said front end server processes and controls data retrieved by said database operation controllers, and
• wherein said front end server causes a database operation server, upon retrieval of data including a plurality of sub-data items, 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.

A parallel database retrieval system comprising:

• a front end server for analyzing queries about a database;
• and
• a plurality of database operation servers for operating a database, said database operation servers being connected to said front end server by a network,
• wherein said database operation servers retrieves data from said database, and said front end server processes and controls data retrieved by said database operation controllers, 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, 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 in 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, 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.