Abstract: In an MD schema definition modifying process for specifying tables to be modified in terms of addition of columns or the like when modification such as addition of a dimension is applied to an MD schema in a BI system having a fixed model such as a data model, tables to be modified in terms of addition of columns or the like are specified on the basis of information of modification such as addition of the dimension to the MD schema. In an extraction process of modification candidate tables, all combinations of tables and columns to be modified in terms of addition of columns or the like are output. In a decision process of modification target tables, a combination of tables to be modified can be output.

Abstract: An electrical form design and management method for conducting design and management on electrical forms provides a technique capable of improving the maintenance efficiency of electrical forms. The method includes a step of referencing mapping information, which associates electrical forms with components used in the electrical forms, and searching for electrical forms using an updated component, and a step of updating or adding components used in the electrical forms obtained by the search or mapping information of the electrical forms, and thereby updating or generating electrical forms.

Abstract: For achieving improvements on efficiency of designing and/or development of the data format for use of input/output screens, as well as, on efficiency of development of a reception program for achieving the format transformation, in an application having input/output screen, a system for supporting to develop an application, according to the present invention, has a definition module of data format transformation for producing an entry data format from a business data format. Also, according to the present invention, there is provided a data processing system, applying a definition of data format transformation with data entry screen ID, which has a format transformation module for achieving the format transformation defined for each entry screen, upon a format transformation call of a reception module.

Abstract: A form transmitting unit 112 of an application server 110 creates as-saved form information containing form information by required form type and check information for verifying input data and downloads it to a client personal computer 130 of a requesting client. A form uploading unit 133 uploads form data containing the as-saved form information received and input data inputted off line to be added thereto, to the application server 110. A form receiving unit 115 checks the received form information as required and the input data using the check information.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: A database management system for executing database operations in parallel by a plurality of nodes and a query processing method for it are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

Abstract: A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database.

Abstract: An electrical form design and management method for conducting design and management on electrical forms provides a technique capable of improving the maintenance efficiency of electrical forms. The method includes a step of referencing mapping information, which associates electrical forms with components used in the electrical forms, and searching for electrical forms using an updated component, and a step of updating or adding components used in the electrical forms obtained by the search or mapping information of the electrical forms, and thereby updating or generating electrical forms.

Abstract: The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database.

Abstract: The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database.

Abstract: There is provided such a technique that database processing of accessing a specific DB resource can be conducted efficiently. When invoking a module for implementing a function related to a data type of a query subject, and conducting database processing, a query given by a user is analyzed. It is determined whether database resource access information of a module for implementing a function in the query given by the user indicates that access to a specific database resource should be conducted. If it is indicated that access to a specific database resource should be conducted, then an execution procedure is determined so as to execute the module in a database processing apparatus storing and managing the database resource.

Abstract: A request accepting server accepts a processing request of data of a predetermined type, analyzes the request, and allocates a process corresponding to the request to either one of the request accepting server and at least one database processing server. A handle is a control block to manage a storage area of data as a processing target and has a server in which the processing target data has been stored and information regarding its storing position. When the processing target data corresponding to the processing request is processed in accordance with the processing request, the request accepting server executes a process according to the processing request by using a handle regarding the processing target data. When an entity of the processing target data is necessary, the entity of the processing target data is obtained on the basis of the handle and is processed.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: A request accepting server accepts a processing request of data of a predetermined type, analyzes the request, and allocates a process corresponding to the request to either one of the request accepting server and at least one database processing server. A handle is a control block to manage a storage area of data as a processing target and has a server in which the processing target data has been stored and information regarding its storing position. When the processing target data corresponding to the processing request is processed in accordance with the processing request, the request accepting server executes a process according to the processing request by using a handle regarding the processing target data. When an entity of the processing target data is necessary the entity of the processing target data is obtained on the basis of the handle and is processed.

Abstract: In a database management system including a request reception server and a plurality of execution servers, each having a plug-in program module incorporated by a user, the request reception server analyzes a processing request from the user to determine whether or not the plurality of execution servers require currently unidentified input parameters when executing external functions in their plug-in modules, based on a definition information table created from descriptions of interface specifications for the plug-in program modules. When it is determined that the execution servers require such input parameters, an external function in the plug-in program module in the request reception server is executed to previously acquire the unidentified input parameters.

Abstract: A user defined ADT function (to be implemented by an embedded module assigned to the function) is executed with module calling triggers other than the execution of the ADT function described in an SQL statement in a database management method which allows the user to define a data type. By creating a proper execution procedure command package, an embedded module implementing an ADT function can be executed even if the function is defined in a format to return execution results as a set. The database processing method includes an ADT function analysis for selecting a procedural model for creating a proper execution procedure command package in accordance with an evaluation style and a non-ADT function called embedded module analysis for adding information on embedded modules called on module calling triggers other than execution of ADT functions.

Abstract: In an MD schema definition modifying process for specifying tables to be modified in terms of addition of columns or the like when modification such as addition of a dimension is applied to an MD schema in a BI system having a fixed model such as a data model, tables to be modified in terms of addition of columns or the like are specified on the basis of information of modification such as addition of the dimension to the MD schema. In an extraction process of modification candidate tables, all combinations of tables and columns to be modified in terms of addition of columns or the like are output. In a decision process of modification target tables, a combination of tables to be modified can be output.