Patent ID: 8156091
Filing Date: 2012-04-10
Classification: G06F

Abstract:
1. In a data processing system comprising a data processing apparatus comprising a Relational Data Base Management System (RDBMS) storing information shared among a plurality of organizations and a business application execution apparatus which is employed when either one of the organizations uses the information stored in the RDBMS of the data processing apparatus and which is communicably connected to the data processing apparatus, a data processing method for use with the data processing apparatus, wherein: the information is identified by an Identification (ID) and includes a plurality of data items; the data processing apparatus stores in the RDBMS shared item information for storing the ID and a shared item value as a value of a shared item which is a data item shared among the plural organizations and inherent item information for storing the ID, an organization name as a name of the organization, an inherent item name as a name of an inherent item which is a data item to be referred to and to be updated by an organization corresponding to the organization name, and an inherent item value as a value of the inherent item; the data processing apparatus comprises a table virtualizing section for outputting; based on an input from the business application execution apparatus, the input including an output item name including the shared items and the inherent items designated without discrimination therebetween, a search conditional expression including the shared items and the inherent items without discrimination therebetween, and the organization name; a record including the shared items and the inherent items without discrimination therebetween to the business application execution apparatus; and in the table virtualizing section an item type judge processing section judges an item type to determine whether each of the output item name thus inputted and the data item included in the search conditional expression is a shared item or an inherent item by referring to the shared item information, an inherent item referring conversion processing section creates, for the data item judged as an inherent item by the item type judge processing section, an inherent item search conditional expression to search the inherent item information for a part thereof associated with an organization name and an inherent item name matching the organization name thus inputted and an inherent item name of the data item judged as an inherent item, a shared item referring conversion processing section creates, based on the search conditional expression thus inputted, a shared item search conditional expression including only data items judged as shared items by the item type judge processing section, and a record output processing section concatenates, based on the output item name, a record obtained from the shared item information by use of the shared item search conditional expression to an inherent item value which has an IO substantially equal to an IO of the record and which is obtained from the inherent item information by use of the inherent item search conditional expression to produce a concatenated result, and outputs therefrom the concatenated result as a record including the shared items and the inherent items.