JP2009217315A - Information processor, control method for information processor, and control program for information processor - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To reduce a workload required for the maintenance or update of a query to be used by a user who retrieves a database for retrieval and to enhance also extensibility of a table. <P>SOLUTION: An information processor includes: a basic region retrieval part for generating and retrieving a retrieval formula for retrieving data to be classified into common items from a retrieval request to be transmitted from an information terminal; a tenant unique extension region retrieval part for generating and retrieving a retrieval formula for retrieving data classified into individual items; and a table retrieval result merge part for merging respective retrieval results obtained by the basic region retrieval part and the tenant unique extension region retrieval part, and for transmitting the retrieval result to the information terminal. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to an information processing apparatus, a control method for the information processing apparatus, and a control program for the information processing apparatus.

  An example of a multi-tenant data management system is described in Non-Patent Document 1. As illustrated in FIG. 8A of Non-Patent Document 1, the information processing apparatus configuring the multi-tenant data management system includes a standard table and an extension table. The standard table includes a data string for storing data and an ID string for storing an ID for identifying each record. The extension table includes an ID column that stores an ID for identifying each record in the standard table and an extension column that stores data for extension. Each record in the standard table is associated with a record in the extended table having the same ID as the ID stored in the respective ID column in the ID column.

Tetsuro Iwai "SaaS Development Guidelines" NSA-Vol.7 No.07009 March 19, 2007 pp. 11http: //www.nsa.or.jp/make_jimu/committee/9/data/07001.pdf

  However, in the configuration described above, the database administrator must know the table structure and which table each column is in when creating a query. For this reason, a large amount of cost is required for query maintenance work.

  Further, when a database having such a structure is searched with a single query, it is necessary to clearly specify each table name to be searched and the relationship between the tables.

  In addition, there is a technique called View that virtually shows a plurality of tables as one table. Even if this technique is used, if the table structure is changed, the View itself needs to be updated, which is managed by the database administrator. The cost of

  Further, when a user who uses a database tries to expand a table independently, it is necessary to modify a search query for an existing user who uses the table, which makes it difficult to maintain the query.

  The present invention has been made in view of the above problems, and one of its purposes is to reduce the work load required for maintenance and update of a query used by a user searching a database for search and improve the extensibility of a table. An information processing apparatus is provided.

  A preferred aspect of the information processing apparatus according to the present invention is connected to an information terminal used by a person in charge belonging to at least one of a plurality of business operators, and in response to a database search request transmitted from the information terminal. An information processing apparatus that searches a database and transmits a search result to the information terminal, wherein the database includes a basic table that stores data classified into common items common to the plurality of operators, and the plurality of businesses. An extended table that stores data classified into different individual items for each person, and the information processing device receives an information terminal that has received the search request for the database from the information terminal and has transmitted the search request. A receiving unit that identifies a business operator to which the person in charge to use belongs based on the search request, and a front based on the search request transmitted from the receiving unit. Based on the search request generated by generating a first search expression for searching for common item data, searching for the common item data, and specifying the provider by the receiving unit Generate a second search expression for searching the individual item data of the specified business operator and search for the individual item data, and the common item searched by the basic region search unit And a table search result merging unit that combines the data of the individual item searched by the tenant-specific extended area search unit and transmits it as the search result to the information terminal.

  Also, a preferred aspect of the method for controlling the information processing apparatus according to the present invention is a common item that is connected to an information terminal used by a person in charge belonging to at least one of a plurality of businesses and is common to the plurality of businesses. The database search request transmitted from the information terminal, comprising a database that includes a basic table that stores data classified into data and an extended table that stores data classified into individual items different for each of the plurality of operators. A method for controlling an information processing apparatus that searches the database in response to the information and transmits a search result to the information terminal, wherein the information processing apparatus receives the database search request from the information terminal, and the information processing apparatus Identifies the business operator to which the person in charge who uses the information terminal that has transmitted the search request belongs based on the search request, and Generates a first search expression for searching for the data of the common item based on the search request, searches for the data of the common item, and the information processing apparatus is transmitted by designating the provider. Based on the search request, a second search expression for searching the individual item data of the designated business operator is generated, the individual item data is searched, and the information processing apparatus searches the common item. And the searched individual item data are combined and transmitted to the information terminal as the search result.

  Moreover, a preferable aspect of the control program for the information processing apparatus according to the present invention is a common item that is connected to an information terminal used by a person in charge belonging to at least one of a plurality of business operators and is common to the plurality of business operators. The database search request transmitted from the information terminal, comprising a database that includes a basic table that stores data classified into data and an extended table that stores data classified into individual items different for each of the plurality of operators. The person in charge of using the information terminal that has received the database search request from the information terminal and has transmitted the search request to the information processing apparatus that searches the database according to the information and transmits the search result to the information terminal. A process of specifying a business company to which the user belongs based on the search request, and a first search for data of the common item based on the search request A process for generating a search expression and searching for data of the common item; and a second method of searching for data of individual items of the specified operator based on the search request transmitted by specifying the operator. A process of generating a search expression and searching for data of the individual item, and a process of combining the searched data of the common item and the searched data of the individual item and transmitting the result as the search result to the information terminal And execute.

  According to the present invention, it is possible to reduce a work load required for maintenance and update of a query used by a user who searches a database for search, and to improve the extensibility of a table.

Next, the best mode for carrying out the invention will be described in detail with reference to the drawings. First, a first embodiment will be described.

  FIG. 1 is a block diagram showing a configuration example of an information processing apparatus according to the first embodiment of the present invention.

  This information processing apparatus is managed by a database management company that manages this database. The database manager provides the database to a plurality of tenants (corresponding to the companies described in the claims) that are businesses or organizations that provide services using the database. The person in charge belonging to each tenant uses the information terminal to independently expand this database to manage information related to users who are customers of each tenant, or search for the information.

  Referring to FIG. 1, the information processing apparatus according to the first embodiment of the present invention is a computer 100 that is connected to an information terminal 110 via a network 10 and is connected to a storage unit 120 so as to be communicable. The computer 100 and the storage unit 120 may be connected via the network 10. The computer 100 may be configured to include the storage unit 120. In addition, referring to FIG. 1, two information terminals 110 are connected. However, the present invention is not limited to this, and any information terminal 110 may be connected to one or more information terminals 110 via the network 10.

  Next, the computer 100, the information terminal 110, and the storage unit 120 will be described in detail.

=== Storage 120 ===
First, the storage unit 120 will be described. As illustrated in FIG. 1, the storage unit 120 is a database that stores at least a basic table 121 and an extension table 122.

<Basic table 121>
As shown in FIG. 2, the basic table 121 associates a value with each column of the table and stores it for each record. Each column has a common item name for identifying the column. Referring to the example of FIG. 2, “tenant ID”, “user ID”, “mail address”, and “record ID” are common item names. Further, the basic table 121 has a record ID for identifying each record for each record. As shown in FIG. 2, a column for storing each record ID may be newly provided in the basic table 121, or may be provided in the storage unit 120 as an index separately from the basic table 121. Referring to the example in FIG. 2, the character string “a @ bc”, “x @ yz”, “l @ mn”, “u @ v” is displayed in the column whose common item name is “mail address”. .W ”,“ d @ ef ”,“ j @ kl ”,“ g @ hi ”, and“ o@p.q ”are stored.

<Extended table 122>
As shown in FIG. 3, the extension table 122 stores record IDs assigned to the records of the basic table 121 and sets of individual item names and values in association with each other. The individual item name indicates a value attribute. Each record of the extension table 122 has the meaning of additional information in the record of the basic table 121 indicated by the record ID included in the record.

  Referring to the example of FIG. 3, a record with a record ID of 21, an individual item name of “number of dwarfs”, and a value of “2 people” has a “number of dwarfs” in the record of the basic table 121 with a record ID of 21 It shows that the information “2 people” is added. That is, a record virtually shown in FIG. 4 with a record of record ID 21 in the basic table 121 and a record ID of 21 in the extension table 122, the individual item name “small number of people”, and the value “2 people”. It shall be comprised.

  For each record stored in the basic table 121, each record ID associated with a record related to user information belonging to the same tenant, that is, a record with a common tenant ID for identifying a tenant, includes an extended table. 122, the common individual item names are associated with each other. For example, referring to the example of FIG. 2, a record whose tenant ID is “1” includes records having record IDs “11”, “12”, “13”, and “14”. The individual item names associated with the record IDs “11”, “12”, “13”, and “14” in the extension table 122 are common individual item names “occupation” and “DM availability”.

=== Information Terminal 110 ===
Next, the information terminal 110 will be described. As shown in FIG. 1, the information terminal 110 includes at least a search formula designation unit 111 and a search result display unit 112. The search expression specifying unit 111 is connected to the search result display unit 112.

<Search expression specifying unit 111>
When the person in charge specifies a search expression that is a condition for searching the storage unit 120, the search expression specifying unit 111 transmits the specified search expression to the computer 100. For example, the person in charge can specify a search formula for searching the storage unit 120 by giving information indicating a condition to be searched to the search formula specifying unit 111 from an input unit (not shown).

  The search expression is an inquiry sentence for searching the table, and includes at least one or a plurality of search conditions. The search condition is information indicating a condition for realizing a table search, and includes at least a common item name or an individual item name.

  The search expression may further include a command statement indicating an operation on the database or an operator indicating an operation such as ‘and’ or ‘or’ by connecting each search condition included in the search expression.

  For example, if the search expression is a character string “SELECT * WHERE 'e-mail address'='l@m.n' OR 'DM OK / NO' = 'NO'", "SELECT * WHERE" indicates a command statement, “'Mail address” = “l @ mn” ”,“ DM availability ”=“ impossible ”indicate search conditions, and“ OR ”indicates an operator. In addition, this search expression indicates that “records whose“ e-mail address ”is“ l@m.n ”or“ DM availability ”is“ impossible ”are extracted”.

  As another example in which the person in charge designates a search expression, the search expression designation unit 111 presents alternative choices to the person in charge, and the person in charge selects one of the search expressions from an input means (not shown). You may make it give to the designation | designated part 111. FIG.

  The search formula designation unit 111 transmits the search formula designated by the person in charge to the computer 100. Then, the search formula designation unit 111 acquires a search result corresponding to the transmitted search formula from the computer 100 and gives it to the search result display unit 112.

<Search result display unit 112>
The search result display unit 112 receives the search result from the search expression designating unit 111 and displays the received search result.

=== Computer 100 ===
Next, the computer 100 will be described. As shown in FIG. 1, the computer 100 includes a receiving unit 101, a basic area search unit 102, a tenant-specific extended area search units 103 a and 103 b, and a table search result merge unit 104.

  The receiving unit 101 is connected to the basic area searching unit 102 and the tenant specific extended area searching units 103a and 103b, respectively. The basic area search unit 102 is connected to the reception unit 101 and the table search result merge unit 104. The tenant specific extension area search units 103a and 103b are connected to the reception unit 101 and the table search result merge unit 104, respectively.

<Receiver 101>
When the computer 100 receives a search formula that is a condition for searching the storage unit 120 from the information terminal 110, the receiving unit 101 specifies a tenant ID for identifying a tenant from the received search formula. For example, it is specified by the following method. The tenant ID is included in the search formula in advance and the information terminal 110 transmits, and the tenant ID is specified from the search formula received by the receiving unit 101. The above method is illustrative and is not limited to this method.

  The receiving unit 101 passes the search formula and the identified tenant ID to the basic area search unit 102 and passes the search formula to the tenant-specific extended area search unit 103 indicated by the identified tenant ID.

  In order for the basic area search unit 102 described later to identify the tenant to which the user indicated by each record belongs, the basic table 121 may further include a column for storing a tenant ID for identifying each tenant as shown in FIG. Good. Alternatively, the storage unit 120 may include a tenant ID correspondence table (not shown) that stores the record ID of each record and the tenant ID of the tenant to which the user indicated by the record belongs. The configuration is not limited to this, and any configuration is possible as long as the tenant to which the user indicated by each record belongs can be identified.

  Note that the following method may be used to specify the tenant ID described above. First, the user ID of the person in charge who uses the information terminal 110 is registered in advance in the information terminal 110. The receiving unit 101 associates the user ID and the tenant ID in advance and stores them in the user ID correspondence table 105 as shown in FIG. The search expression designating unit 111 transmits to the computer 100 the user ID of the person in charge who designated the search expression together with the search expression designated by the person in charge. Then, the receiving unit 101 identifies the tenant ID associated with the received user ID using the above-described user ID correspondence table.

  Alternatively, the reception unit 101 may specify a tenant ID from specific information included in the search formula. These are merely examples, and are not limited to these configurations, but may be any configuration as long as the receiving unit 101 can identify the tenant ID.

<Basic region search unit 102>
The basic area search unit 102 satisfies each search condition from the basic table 121 using the search condition including the common item name included in the basic table 121 in each search condition included in the search expression received from the reception unit 101. Extract each record. Then, the basic area search unit 102 passes the record ID included in the extracted record to the table search result merge unit 104.

  Further, the basic area search unit 102 extracts a record having the tenant ID received from the receiving unit 101 from the basic table 121. Then, the basic area search unit 102 passes the extracted record to the table search result merge unit 104 together with the received search formula.

  In the search using the search condition, the basic area search unit 102 may execute the search using the received search formula as it is. Alternatively, it may be realized by the following method. The basic area search unit 102 further includes a conversion unit (not shown) that extracts a search condition including a common item name included in the basic table 121 from the received search formula. Then, the conversion unit described above generates a new search expression. The basic area search unit 102 executes a search using the search formula generated by the conversion unit described above. Alternatively, the above-described conversion unit may be configured to generate a new search expression by converting a search condition that does not include the common item name included in the basic table 121 into information indicating trueness. The common item names included in the basic table 121 are stored in the common item name correspondence table 106 as shown in FIG. 6 in the conversion unit, and the basic area search unit 102 is stored in the conversion unit. You may comprise so that extraction of search conditions may be implement | achieved according to whether the common item name is contained in the said search conditions. These are examples and are not limited to the methods described above.

<Tenant-specific extension area 103>
The tenant-specific extended area search unit 103 is provided in the computer 100 for each tenant. When the tenant-specific extension area search unit 103 receives the search formula from the reception unit 101, the tenant-specific extension area search unit 103 searches the extension table 122 for each search condition included in the search formula. Then, the tenant-specific extended area search unit 103 passes the search result to the table search result merge unit 104.

  In the search using the search condition, the tenant-specific extended area search unit 103 may execute the search using the received search formula as it is. Alternatively, it may be realized by the following method. The tenant-specific extended area search unit 103 further includes a conversion unit (not shown) that extracts a search condition including an individual item name included in the extension table 122 from the received search formula. Then, the conversion unit described above generates a new search expression. The tenant-specific extended area search unit 103 executes a search using the search formula generated by the conversion unit described above. Alternatively, the above-described conversion unit may be configured to generate a new search expression by converting a search condition that does not include an individual item name included in the extension table 122 into information indicating trueness. The individual item names included in the extension table 122 are stored in the individual item name correspondence table 107 as shown in FIG. 7 in the conversion unit, and the tenant-specific extension area search unit 103 is stored in the conversion unit. The search condition may be extracted depending on whether or not the individual item name is included in the search condition. These are examples and are not limited to the methods described above.

  In the present embodiment, a case where the number of tenants is two is shown. In this case, the computer 100 includes a tenant-specific extended area search unit 103a corresponding to the tenant ID “1” and a tenant-specific extended area search unit 103b corresponding to the tenant ID “2”. In this embodiment, a case where the number of tenants is two is shown, but the number of tenants is not limited to this, and any number of tenants may be used.

  When the tenant-specific extended area search unit 103 receives a record ID from a table search result merge unit 104 described later, the tenant-specific extended region search unit 103 extracts a record having the record ID from the extension table 122 and extracts the extracted record into the table search result merge unit 104 To pass.

<Table search result merge unit 104>
The table search result merging unit 104 receives a search expression, a search result, and a record ID from the basic area search unit 102, and a search result from the tenant-specific extended area search unit 103. Next, the table search result merge unit 104 passes the received record ID to the tenant-specific extended area search unit 103 that has passed the search result. Next, the table search result merging unit 104 receives a record associated with the record ID described above from the tenant-specific extended area search unit 103. Next, the table search result merge unit 104 merges the received search results based on the search formula received from the basic area search unit 102. Next, the table search result merge unit 104 transmits the merged record to the information terminal 110 that has transmitted the search expression to the computer 100.

  For example, the basic area search unit 102 and the tenant-specific extended area search unit 103 store the record ID or search result in the table search result merge unit 104 so that each search result can be identified using which search condition. When handing over, it may be passed in association with the search conditions used to obtain the search result. The above is an example and is not limited to this method.

  The merge procedure is as follows. First, the table search result merge unit 104 passes the record ID received from the basic region search unit 102 to the tenant-specific extended region search unit 103 that has sent the search result. The tenant-specific extended area search unit 103 extracts a record having the received record ID, and passes the extracted record to the table search result merge unit 104. The table search result merge unit 104 is obtained by newly associating the record received from the tenant-specific extended area search unit 103 with the search condition associated with the above-described record ID and performing a search using the search condition. The result is regarded as the aforementioned record.

  Next, a record ID is extracted based on a search condition included in the search expression and an operator connecting each search condition. Hereinafter, ‘A’ and ‘B’ are used as search conditions, respectively. The record ID included in the search result obtained by the search condition 'A' and the record ID included in the search result obtained by the search condition 'B' are obtained, and the record indicated by the obtained record ID is searched. The search result when the condition “A and B” is searched is used. In addition, the record ID indicated by the record ID obtained by calculating the logical sum of the record ID included in the search result obtained by the search condition 'A' and the record ID included in the search result obtained by the search condition 'B'. Is the search result when the search condition 'A or B' is searched. This operation is repeated based on the received search expression.

  Next, the search result obtained in the above procedure is combined with the search result retrieved from the basic area search unit 102 based on the tenant ID. The combining method is realized by combining records having record IDs in the respective search results.

  Finally, output the merged record.

  Next, the operation of the above configuration example will be described.

  FIG. 8 is a sequence diagram showing an outline of the operation of the first exemplary embodiment of the present invention.

  First, the person in charge designates a search expression by the search expression specifying unit 111 in the information terminal 110. The search formula designating unit 111 transmits the designated search formula to the computer 100 (step S1001). The receiving unit 101 specifies a tenant ID from the search formula received by the computer 100, passes the received search formula and the specified tenant ID to the basic area search unit 102 (step S1002), and assigns the specified tenant ID to the specified tenant ID. The received search expression is passed to the corresponding tenant-specific extended area search unit 103 (step S1003).

  The basic area search unit 102 searches the basic table 121 using the search condition including the common item name included in the basic table 121 among the search conditions included in the received search expression, and obtains the record ID included in the search result. A record having the received tenant ID is retrieved from the basic table 121 together with the table search result merge unit 104 (step S1004), and the search result and the received search expression are delivered to the table search result merge unit 104 (step S1005). Upon receiving the search expression from the receiving unit 101, the tenant-specific extended area search unit 103 searches the extension table 122 for each search condition included in the received search expression, and passes the search results to the table search result merge unit 104 ( Step S1006).

  Next, the table search result merging unit 104 receives the search formula, the search result, and the record ID from the basic area search unit 102, and the search result from the tenant-specific extended area search unit 103, and performs merging. Furthermore, the table search result merging unit 104 transmits the result of merging to the information terminal 110 that has transmitted the search formula in step S1001 (step S1007). Next, the search expression specifying unit 111 receives the search result from the computer 100 and passes it to the search result display unit 112. The search result display unit 112 receives the search result from the search formula designating unit 111 and displays the search result (step S1008).

  In the first embodiment, from the search formula transmitted from the information terminal 110 and including the common item name or individual item name, the basic area search unit 102 sets the basic table 121 for each search condition included in the search formula. The extended area search unit 103 searches the extended table 122 for each search condition included in the search formula, and the table search result merge unit 104 merges the search results. The person in charge can perform a search without being aware of whether the common item name or individual item name included in the search formula is included in the basic table 121 or the extended table 122. Because it is determined whether the basic area search unit 101 and the tenant-specific extended area search unit 103 include a common item name or an individual item name for each search condition, and a search formula corresponding to the determination result is determined. This is because they are generated and searched. In addition, since it is not necessary to specify the table to which each column belongs in the query specified by the person in charge when searching, even if the table structure changes, there is no need to change the query according to the change. Maintenance work burden can be reduced.

  Further, according to such a configuration, when a new tenant is added, the system can be used by a person in charge belonging to the new tenant by providing the computer 100 with the tenant-specific extension area search unit 103 newly. Increase the tenant, can reduce the burden of expansion work. Even when this tenant is added, there is no need to change the search method in the existing tenant. This is because the tenant-specific extended area search unit 103 that searches the table for each tenant is provided in the computer 100, and each tenant-specific extended area search unit 103 generates a search expression for searching for an individual item of the tenant. is there.

  In the first embodiment, the basic area search unit 102 sends a record of the search result to the table search result merge unit 104 instead of the record ID included in the search result searched based on the search condition. The result merge unit 104 may pass the record ID included in the received record to the tenant-specific extended area search unit 103 that has sent the search result.

  Next, a second embodiment will be described.

  FIG. 9 is a block diagram showing a configuration example of the information processing apparatus according to the second embodiment of the present invention.

  Referring to FIG. 9, the information processing apparatus according to the second exemplary embodiment of the present invention is a computer 200 that is connected to the information terminal 110 via the network 10 and is connected to the storage unit 220 so as to be communicable. The computer 200 and the storage unit 220 may be connected via the network 10. The computer 200 may be configured to include the storage unit 220. 9, two information terminals 110 are connected. However, the present invention is not limited to this, and any information terminal 110 may be connected to one or more information terminals 110 via the network 10. Here, only the differences of the second embodiment from the first embodiment will be described, and the same components are denoted by the same reference numerals and the description thereof is omitted.

=== Storage 220 ===
The storage unit 220 will be described. As shown in FIG. 9, the storage unit 220 stores at least a basic table 221 and an extension table 122. The extension table 122 is the same as the extension table 122 in the first embodiment.

<Basic table 221>
As shown in FIG. 10, the basic table 221 is different from the basic table 121 in the first embodiment in that each column is given a common item name or an extended item name for identifying the column.

  The common item name identifies each column and indicates the attribute of the value stored in the column. The extension item name is for identifying each column. Each extended item name is stored in the region name correspondence table 208 described later in association with the individual item name. For example, referring to the example of FIG. 10, “user ID” and “email address” that identify each column and indicate the attribute of the value stored in the column are common item names, and “extended region 1” identifies each column. "," Extended area 2 "and" extended area 3 "are the extension item names.

  The column identified by the extension item name stores attribute values that differ for each tenant. For example, in the record with the tenant ID “1”, the character string indicating the quantity “5 million yen” or “7 million yen” in the column “extension area 2” is the record with the tenant ID “2”. In the “extension area 2” column, character strings indicating the residence forms of “detached house” and “condominium” are stored.

=== Computer 200 ===
Next, the computer 200 will be described. The computer 200 is different from the computer 100 in that the tenant-specific extended area search units 103a and 103b included in the computer 100 in the first embodiment are replaced with tenant-specific extended area search units 203a and 203b, respectively. The tenant-specific extended area search units 203a and 203b are connected to the receiving unit 101 and the table search result merge unit 104, respectively.

<Tenant-specific extended search unit 203>
The tenant-specific extended area search unit 203 is provided in the computer 100 for each tenant. Upon receiving the search expression from the receiving unit 101, the tenant-specific extended area search unit 203 uses the area name correspondence table 208 to determine whether to search the basic table 221 or the extension table 122 for each search condition included in the search expression. Then, a table corresponding to the determination result is searched, and the search result is passed to the table search result merge unit 104. The above-described determination is performed for each search condition included in the received search expression based on whether or not the individual item name included in the search condition is included in the area name correspondence table 208.

  The area name correspondence table 208 is provided in each tenant-specific extension area search unit 203 and stores individual item names and extension item names in association with each other. FIG. 11 shows area name correspondence tables 208a and 208b provided in the tenant-specific extended area search units 203a and 203b, respectively. For each search condition included in the received search formula, the tenant-specific extended area search unit 203 checks whether or not the individual item name included in the search condition is included in the area name correspondence table 208. If it is included, the tenant-specific extended area search unit 203 replaces the individual item name included in the search condition with the extended item name associated with the individual item name. Then, the tenant-specific extension area search unit 203 extracts records satisfying the search condition from the basic table 221 using the search condition replaced with the extension item name. Further, the tenant-specific extended area search unit 203 extracts a record having a record ID included in the extracted record from the extension table 122 and passes the record extracted from the extension table 122 to the table search result merge unit 104.

  On the other hand, for each search condition included in the received search expression, if the individual item name included in the search condition is not included in the area name correspondence table 208, the tenant-specific extended area search unit 203 satisfies the search condition. Records are extracted from the expansion table 122. Then, the tenant-specific extension area search unit 203 passes the record extracted from the extension table 122 to the table search result merge unit 104.

  The second embodiment has the same effect as the first embodiment.

  Next, a third embodiment will be described.

  FIG. 12 is a block diagram showing a configuration example of an information processing apparatus according to the third embodiment of the present invention.

  Referring to FIG. 12, the information processing apparatus according to the third exemplary embodiment of the present invention is a computer 300 that is connected to the information terminal 110 via the network 10 and is connected to the storage unit 220 so as to be communicable. The computer 300 and the storage unit 220 may be connected via the network 10. The computer 300 may be configured to include the storage unit 220. Referring to FIG. 12, two information terminals 110 are connected. However, the present invention is not limited to this, and any information terminal 110 may be connected to one or more information terminals 110 via the network 10. Here, only the differences of the third embodiment from the second embodiment will be described, and the same components are denoted by the same reference numerals and the description thereof is omitted.

=== Computer 300 ===
The computer 300 will be described. The computer 300 replaces the tenant-specific extended area search units 203a and 203b included in the computer 200 in the second embodiment with a tenant-specific extended area search unit 303, and replaces the receiving unit 101 with the receiving unit 301. This differs from the computer 200 in that respect. The tenant specific extension area search unit 303 is connected to the reception unit 301 and the table search result merge unit 104, respectively. The reception unit 301 is connected to the basic area search unit 102 and the tenant-specific extension area search unit 303, respectively.

<Receiving unit 301>
The receiving unit 301 receives the search formula received from the information terminal 110 instead of passing the search formula received from the information terminal 110 to the tenant-specific extended area search unit indicated by the tenant ID specified by the receiving unit 101 in the configuration of the receiving unit 101. And the tenant ID specified by the reception unit 301 is different from the reception unit 101 in that the tenant ID is passed to the tenant-specific extension area search unit 303.

<Tenant-specific extended area search unit 303>
Upon receiving the search expression and the tenant ID from the receiving unit 301, the tenant-specific extended area search unit 303 searches the basic table 221 or the extension table 122 for each search condition included in the search expression using the area name correspondence table 308. After determining whether to perform the search, a table corresponding to the determination result is searched, and the search result is passed to the table search result merge unit 104. The above determination is based on whether or not the individual item name included in the search condition and the received tenant ID are associated with each search condition included in the received search expression and included in the area name correspondence table 308. Do.

  The area name correspondence table 308 is provided in the tenant-specific extended area search unit 303 and stores individual item names, extended item names, and tenant IDs in association with each other. FIG. 13 shows an area name correspondence table 308 provided in the tenant-specific extended area search unit 303. Whether the tenant-specific extended area search unit 303 stores, for each search condition included in the received search expression, the individual item name included in the search condition in association with the received tenant ID in the area name correspondence table 308. Check whether or not. If stored, the tenant-specific extended area search unit 303 replaces the individual item name included in the search condition with the extended item name associated with the individual item name. Then, the tenant-specific extension area search unit 303 extracts records satisfying the search condition from the basic table 221 using the search condition replaced with the extension item name. Further, the tenant-specific extended area search unit 303 extracts a record having a record ID included in the extracted record from the extended table 122 and passes the record extracted from the extended table 122 to the table search result merge unit 104.

  On the other hand, for each search condition included in the received search expression, if the individual item name included in the search condition is not stored in the area name correspondence table 208 in association with the received tenant ID, the tenant-specific extension The area search unit 303 extracts records satisfying the search condition from the extension table 122. Then, the tenant-specific extension area search unit 303 passes the record extracted from the extension table 122 to the table search result merge unit 104.

  In the third embodiment, the tenant-specific extension area search unit 303 receives the tenant ID and is associated with the received tenant ID based on the area name correspondence table 308 provided in the tenant-specific extension area search unit 303. A new search expression is generated from the individual item name and the extended item name and the received search expression. The tenant-specific extended area search unit 303 performs a search using this search formula. The person in charge can perform a search without being aware of whether the common item name or individual item name included in the search formula is included in the basic table 121 or the extended table 122.

  Further, according to such a configuration, when a new tenant is added, the system can be used by updating the area name correspondence table 308 provided in the tenant-specific extension area search unit 303, and the tenant can be used. Increased expansion work burden can be reduced. Even when this tenant is added, there is no need to change the search method in the existing tenant. This is because the area name correspondence table 308 stores the extended item name and the individual item name in association with each other as information for generating a search expression for each tenant, and the tenant-specific extended area search unit 303 stores the area name correspondence table 308 in the area name correspondence table 308. This is because a search expression for searching for individual items of each tenant is generated based on the search results.

  Next, a fourth embodiment will be described. In the fourth embodiment, the first embodiment will be described in detail using a specific example.

  The information terminal 110 is a personal computer including at least a central processing unit (CPU), a memory, and a network interface, and includes a keyboard or a mouse as input means and a display as display means. Further, the CPU in the personal computer functions as a search expression specifying unit 111 and a search result display unit 112 as shown in FIG. 1 by interpreting and executing a program developed on the memory.

  The computer 100 is a server device and includes at least a CPU, a memory, and a network interface. A reading device for reading a computer-readable recording medium such as a flexible disk or a CD-ROM, or a magnetic storage device may be provided. The computer 100 expands the program code received from the network interface on the memory, or reads out the program code stored in the CD-ROM or the magnetic storage device and expands the expanded program code on the memory. 1 operates as a computer that realizes various functions as the receiving unit 101, the basic area searching unit 102, the tenant-specific extended area searching unit 103, and the table search result merging unit 104 as shown in FIG.

  In the magnetic storage device, as shown in FIG. 5, a user ID for identifying a person in charge and a tenant ID for identifying a tenant are stored in association with each other. Further, in the magnetic storage device, the common item names included in the basic table 121 as shown in FIG. 6 are used as the common item name correspondence table 106, and the individual items included in the extension table 122 as shown in FIG. The names are stored as the individual item name correspondence table 107.

  The storage unit 120 is a so-called storage device, and includes at least a network interface and a magnetic storage device. The magnetic storage device stores a basic table 121 and an extension table 122 as shown in FIGS.

  The person in charge belonging to the tenant with the tenant ID “1” has an e-mail address of “l @ m. Suppose that it is desired to obtain information on a user who is “n” or a tenant with a tenant ID “1” whose DM availability is “impossible”.

  First, an input means such as a keyboard of the information terminal 110 is operated by the person in charge, and the program is started. That is, a program is developed on the memory of the information terminal 110, and the CPU interprets and executes the program. The CPU displays a video for specifying a search expression on the display of the information terminal 110 and waits for input from the person in charge. The person in charge designates the search expression and the user ID of the person in charge using input means such as a keyboard or a mouse. In this embodiment, it is assumed that “SELECT * WHERE 'email address” = “l @ mn” OR “DM availability” = “impossible” ”and“ 10000 ”as the user ID are specified as the search expressions. .

  There are two search conditions included in this search formula: “'email address” = “l@m.n”, ““ DM availability ”=“ impossible ”. The individual item name is one of “DM availability”. The common item name is one of “mail address”.

  In the above-described search expression, “SELECT * WHERE” corresponds to a command sentence, and this search expression means “extract all items of records satisfying each search condition after“ WHERE ””.

  When the person in charge inputs the search formula, the search formula designating unit 111 of the information terminal transmits the designated search formula to the computer 100 through the network interface and the network.

  The receiving unit 101 of the computer 100 uses “SELECT * WHERE 'email address” = “l @ mn” OR “DM availability” = “impossible” as a search expression, “10000” as a user ID, and a network interface. If the tenant ID associated with the user ID “10000” is stored in the magnetic storage device of the computer 100, it is checked. In this embodiment, since “1” is stored as the tenant ID corresponding to “10000”, the receiving unit 101 reads “1” from the magnetic storage device.

  The receiving unit 101 uses the received search expression “SELECT * WHERE 'email address' = 'l @ mn' OR 'DM OK / NO' = 'NO' and the read tenant ID '1' as the basis of the computer 100. In addition to passing to the area search unit 102, the search formula is passed to the tenant-specific extension area search unit 103 of the computer 100 indicated by the tenant ID.

  Next, the basic area search unit 102 of the computer 100 uses the search condition “SELECT * WHERE 'email address' =“ l @ mn ”OR“ DM availability ”=“ impossible ”” Extract command statements. The search conditions constituting this search formula are each character string of “'mail address” = “l@m.n”, “DM availability” = “impossible”. Further, the command statement constituting this search expression is a character string “SELECT * WHERE”. In order to extract these character strings, there is a method of extracting a specific word as a reserved word and using that word as a mark. For example, “WHERE” included in the search expression is a reserved word at the boundary between the command sentence and the search condition. Then, the character string before ‘WHERE’ in the search expression is a command sentence, and the character string after that is one or more search conditions. Further, “OR” or “AND” included in the search expression is a reserved word at the boundary of each search condition. Then, one or more search conditions in the search formula are separated by “OR” or “AND”, and each search condition is extracted. Of course, the reserved word is not limited to this, and may be a symbol indicating a blank character, punctuation mark, special character, or other boundary. Reserved words are not essential and may be omitted.

  Next, the basic area search unit 102 checks whether or not each search condition includes a common item name using the common item name correspondence table 106 stored in the magnetic storage device. Then, the basic area search unit 102 extracts only search conditions in which the common item name is included in the search conditions. In the case of the present embodiment, as shown in FIG. 6, 'mail address' is stored as a common item name, and 'DM availability' is not stored as a common item name. The mail address' = 'l @ mn.' Is extracted. Then, the basic area search unit 102 combines command sentences for each extracted search condition to form a new search formula, and searches the basic table 121 for each new search formula. In the present embodiment, the basic area search unit 102 generates a new search expression “SELECT * WHERE 'email address' =“ l@m.n ”” and searches the basic table 121. This new search formula means an instruction to “extract all items of a record whose“ e-mail address ”is“ l@m.n ””. The basic area search unit 102 searches the basic table 121 for a column having a common item name “mail address” included in the search expression, and the character string included in this search expression in the next searched column. 'l @ m. It is checked whether or not n 'is included. Then, the basic area search unit 102 sends the character string ‘l @ m. Records including n ′ are obtained as search results. Then, the record shown in FIG. 14A is obtained as a search result. Next, the basic area search unit 102 associates the record ID “12” included in the search result with the search condition “'email address” = “l @ mn” and associates the table search result merge unit 104 of the computer 100 with it. And the received search expression “SELECT * WHERE 'email address' = 'l @ mn' OR 'DM OK / NO' = 'NO'" is passed to the table search result merge unit 104.

  Next, the basic area search unit 102 searches the basic table 121 for a record having the tenant ID “1” read from the magnetic storage device. In the case of the present embodiment, for example, the basic area search unit 102 may generate a new search expression “SELECT * WHERE 'tenant ID' = '1'” and search the basic table 121. Good. In this case, the record shown in FIG. 14B is obtained as a search result. Next, the basic area search unit 102 passes the record obtained as the search result to the table search result merge unit 104.

  Next, the tenant-specific extended area search unit 103 that has received the tenant ID from the receiving unit 101 includes an individual item name using the individual item name correspondence table 107 stored in the magnetic storage device for each search condition. Investigate. Then, the tenant-specific extended area search unit 103 extracts only the search condition in which the individual item name is included in the search condition. In the case of the present embodiment, as shown in FIG. 7, “DM availability” is stored as an individual item name, and “email address” is not stored as an individual item name. “'DM availability” = “impossible” ”is extracted. Then, a command statement is combined for each extracted search condition to form a new search formula, and the extension table 122 is searched for each new search formula. In the case of the present embodiment, the tenant-specific extension area search unit 103 generates a new search expression “SELECT * WHERE 'DM OK / NO' = 'NO'" and searches the extension table 122. This new search formula means an instruction to “extract all items of a record whose“ DM availability ”is“ impossible ”. The tenant-specific extension area search unit 103 searches the extension table 122 for a column having the individual item name “DM availability” included in the search expression, and the next searched column is included in this search expression. Check to see if it contains the string 'impossible'. Then, the tenant-specific extended area search unit 103 obtains a record including the character string “impossible” as a search result, and also obtains a record having a record ID included in the search result as a search result. Then, a record as shown in FIG. 14C is obtained as a search result. Next, the tenant-specific extended area search unit 103 associates the record obtained as the search result with the search condition “‘ DM availability ”=“ impossible ”and passes it to the table search result merge unit 104.

  Next, the table search result merge unit 104 sends a search expression “SELECT * WHERE 'mail address' = 'l @ mn' OR 'DM availability' = 'impossible'" from the basic area search unit 102 as shown in FIG. ) And the record ID “12”, and the record shown in FIG. 14C is received from the tenant-specific extended area search unit 103. Then, the table search result merge unit 104 passes the record ID “12” received from the basic region search unit 102 to the tenant-specific extended region search unit 103 that has passed the search result. The tenant-specific extended area search unit 103 searches the extended table for a record having the received record ID “12”, and obtains a record as shown in FIG. 14D as a search result. The tenant-specific extended area search unit 103 passes the record obtained as the search result to the table search result merge unit 104. The table search result merge unit 104 receives a record as shown in FIG. 14D from the tenant-specific extended area search unit 103. The table search result merge unit 104 associates the received record with the search condition associated with the record ID transmitted to the tenant-specific extended area search unit 103. That is, 'email address' =' l @ m. n ′ is associated with a record as shown in FIG.

  Next, the table search result merge unit 104 merges the search results received based on the search formula received from the basic area search unit 102. Each search result is associated with a search condition used to obtain the search result, and the search conditions are merged based on an operator connecting the search conditions and the search conditions. First, the table search result merge unit 104 uses the search condition “SELECT * WHERE 'email address' = 'l @ mn' OR 'DM admissibility' = 'impossible'" as the first search condition "email address '=' l @ m .N ′ ”, the second search condition“ DM availability ”=“ impossible ”and the operator“ OR ”connecting them are referred to. The record ID included in the search result (FIG. 14 (d)) associated with “mail address” = “l @ mn.” Is associated with “12” and “DM availability” = “impossible”. The record IDs included in the retrieved result (FIG. 14 (c)) are “11” and “13”, and they are connected by “OR”, so that they are ORed. Search result when the record (FIG. 15 (e)) indicated by the obtained record ID is searched using the search condition “'email address' = 'l @ mn' OR 'DM OK / NO' = 'NO'" And

  Next, the table search result merge unit 104 combines the search result (FIG. 15E) and the record received from the basic area search unit 102 (FIG. 14B). The combining method is realized by combining records having record IDs in the respective search results. As a result of the merge, the record shown in FIG. 15F is obtained.

  Next, the table search result merging unit 104 transmits the record of FIG. 15F to the information terminal 110 that has transmitted the search expression and the user ID. The search formula designating unit 111 displays the received record in FIG. 15F on the search result display unit 112.

  In the above description, in FIG. 14 and FIG. 15, the names of the respective columns are given for explanation, but actually these items may not be given.

  Each embodiment described so far is a preferred embodiment of the present invention, and the scope of the present invention is not limited only to the above-described embodiment, and various modifications are possible without departing from the gist of the present invention. It is possible to implement in a form that has been modified.

  In addition, each component in each embodiment of the present invention can be realized by a computer and a program as well as its function in hardware. The program is provided by being recorded on a computer-readable recording medium such as a magnetic disk or a semiconductor memory, read by the computer at the time of starting up the computer, etc., and controlling the operation of the computer. It functions as a component in the form.

  INDUSTRIAL APPLICABILITY According to the present invention, it can be applied to uses such as providing services to multi-tenants by SaaS (Software as a Service).

It is a block diagram which shows the structure of 1st Embodiment for implementing this invention. It is a figure which shows the specific example of the basic table. It is a figure which shows the specific example of the expansion table. It is a figure which shows the specific example of a virtual record. It is a figure which shows the specific example of the user ID corresponding | compatible table 105. FIG. It is a figure which shows the specific example of the common item name corresponding | compatible table 106. FIG. It is a figure which shows the specific example of the individual item name corresponding | compatible table 107. FIG. It is a figure which shows the processing flow of 1st Embodiment for implementing this invention. It is a block diagram which shows the structure of 2nd Embodiment for implementing this invention. It is a figure which shows the specific example of the basic table. It is a figure which shows the specific example of area | region name corresponding | compatible table 208a, 208b. It is a block diagram which shows the structure of 3rd Embodiment for implementing this invention. It is a figure which shows the specific example of the area | region name corresponding | compatible table 308. FIG. In the fourth embodiment for carrying out the present invention, it is a diagram for explaining in detail the operation of each search. (A) In 4th Embodiment for implementing this invention, the basic region search part 102 shows the result searched based on search conditions. (B) In the fourth embodiment for carrying out the present invention, the basic area search unit 102 performs a search based on the tenant ID. (C) In the fourth embodiment for carrying out the present invention, the tenant-specific extension area search unit 103 shows a search result based on the search condition. (D) In the fourth embodiment for carrying out the present invention, the tenant-specific extended area search unit 103 shows a search result based on the record ID received from the table search result merge unit. In the fourth embodiment for carrying out the present invention, it is a diagram for explaining in detail each search and merge operation. (E) The table search result merge unit 104 shows a result of merging the search results received based on the search formula received from the basic area search unit 102. (F) Indicates a record obtained as a search result.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Network 100 Computer 101 Reception part 102 Basic area search part 103a, 103b Tenant specific expansion area search part 104 Table search result merge part 105 User ID correspondence table 106 Common item name correspondence table 107 Individual item name correspondence table 110 Information terminal 111 Search formula Designation unit 112 Search result display unit 120 Storage unit 121 Basic table 122 Extension table 200 Computer 203a, 203b Tenant-specific extended area search unit 208a, 208b Area name correspondence table 220 Storage unit 221 Basic table 300 Computer 301 Reception unit 303 Tenant-specific extension area Search part

Claims (7)

Connected to an information terminal used by a person in charge belonging to at least one of a plurality of business operators, searches the database in response to a database search request transmitted from the information terminal, and transmits a search result to the information terminal An information processing apparatus that
The database is
A basic table that stores data classified into common items common to the plurality of operators, and an extension table that stores data classified into different individual items for each of the plurality of operators,
The information processing apparatus includes:
A receiving unit that receives a search request for the database from the information terminal and identifies a business operator to which a person in charge using the information terminal that has transmitted the search request belongs, based on the search request;
A basic area search unit for generating a first search expression for searching for data of the common item based on the search request transmitted from the receiving unit, and searching for the data of the common item;
Based on the search request transmitted by designating the business operator by the receiving unit, a second search expression that retrieves data of the individual item of the designated business operator is generated, and the data of the individual item is retrieved. Tenant-specific extension area search part to
A table search result merging unit that combines the data of the common item searched by the basic area search unit and the data of the individual item searched by the tenant-specific extension area search unit and transmits the combined result to the information terminal as the search result; ,
An information processing apparatus comprising:
The information processing apparatus according to claim 1,
The information processing apparatus includes the tenant-specific extended area search unit for each of the plurality of operators,
The information processing apparatus, wherein the receiving unit designates and transmits the business operator by transmitting the search request to a tenant-specific extended area search unit corresponding to the identified business operator.
The information processing apparatus according to claim 1,
The receiving unit transmits the search request received from the information terminal and the information for identifying the specified business operator to the tenant-specific extension area searching unit,
The tenant-specific extended area search unit has a second search formula for searching for data of individual items of the specified business operator based on a search request transmitted from the reception unit and information for identifying the business operator. An information processing apparatus that generates and searches for data of the individual items.
The information processing apparatus according to any one of claims 1 to 3,
The information processing apparatus includes a user ID correspondence table that stores a user ID that identifies a person in charge who uses the information terminal and information that identifies the plurality of operators in association with each other.
The receiving unit receives a search request including a user ID from the information terminal;
The reception unit is information that identifies the business operator associated with the user ID included in the search request and stored in the user ID correspondence table, and the person in charge who uses the information terminal that has transmitted the search request An information processing device that identifies the company to which the company belongs.
The information processing apparatus according to any one of claims 1 to 3,
An information processing apparatus including the database.
A basic table that is connected to an information terminal used by a person in charge belonging to at least one of a plurality of businesses and stores data classified into common items common to the plurality of businesses, and each of the plurality of businesses And an extended table for storing data classified into different individual items, searching the database in response to a search request for the database transmitted from the information terminal, and transmitting a search result to the information terminal A method for controlling an information processing apparatus,
The information processing apparatus receives a search request for the database from the information terminal, and identifies a company to which a person in charge using the information terminal that has transmitted the search request belongs based on the search request.
The information processing apparatus generates a first search expression for searching for data of the common item based on the search request, searches for data of the common item,
The information processing apparatus generates a second search expression for searching for data of the individual item of the designated business operator based on the search request transmitted by designating the business operator, and the data of the individual item Search for
The information processing apparatus control method, wherein the information processing apparatus combines the searched common item data and the searched individual item data, and transmits the combined result as the search result to the information terminal.
A basic table that is connected to an information terminal used by a person in charge belonging to at least one of a plurality of business operators and stores data of common items common to the plurality of business operators, and a different individual for each of the plurality of business operators An information processing apparatus that includes an extended table that stores data of items, and that searches the database in response to a search request for the database transmitted from the information terminal and transmits a search result to the information terminal;
A process of receiving a search request for the database from the information terminal, and identifying a company to which a person in charge using the information terminal that has transmitted the search request belongs, based on the search request;
Generating a first search expression for searching for data of the common item based on the search request, and searching for the data of the common item;
Generating a second search expression for searching for data of individual items of the specified business operator based on the search request transmitted by designating the business operator, and processing for searching for data of the individual items;
The program for performing the process which combines the searched said common item data and the searched said individual item data, and transmits to the said information terminal as said search result.

Images