Patent ID: 6789074
Filing Date: 2004-09-07
Classification: G06F,Y10S

Abstract:
A method, in a database system including a front-end server, that is a logical unit of a database management system, for accepting a query from a user and analyzing the query and at least one back-end server, that is a logical unit of a database management system, for accessing data in a database, the front-end server and the back-end server being on different computers, for invoking a module to implement a user-defined function related to a data type in a query, and conducting processing, said method comprising the steps of:storing, when an user defines a user-defined function, information whether a module for implementing the user-defined function accesses a specific database resource which is necessary data to estimate the user-defined function and which is not table data; when analyzing a query given by a user to generate an execution procedure, if the user-defined function accesses said specific database resource which is necessary data to estimate the user-defined function and which is not table data, determining an execution procedure so as to invoke the module in the back-end server having said specific database resource which is necessary data to estimate the user-defined function and which is not table data, if the user-defined function does not access said specific database resource which is necessary data to estimate the user-defined function and which is not table data, determining an execution procedure so as to invoke the module in the front-end server.