JP2002197114A - Database management system, customer management system and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a database management system capable of reducing a data retrieval time at data retrieval and reuse of retrieval result. SOLUTION: This database management system 1 is provided with a first storage part 10 for storing a customer table 101 wherein an information concerning a customer is added with ID for identifying the customer, a retrieval part 14 for conducting retrieval of the customer table based on retrieval conditions when a retrieval request under a predetermined condition is received from outside, and an assembly table 111 for storing the ID of the customer obtained by the retrieval by the retrieval part as one assembly. At reuse of the retrieval result, the ID is read from the assembly table, thereby obtains the same result as re-retrieved. The assembly table stores the ID, therefore, a storage region can be steeply reduced compared to a conventional technique wherein the retrieval conditions or retrieval processes are stored to re-execute the retrieval.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a database management system (DBMS).
In particular, when searching for desired data from a large amount of data accumulated over a long period of time, past search results can be effectively utilized instead of searching every time from all accumulated data. Related to the system. This technology has a completely different concept from the conventional technology for storing procedural search results.

[0002]

2. Description of the Related Art In a DBMS, when searching for data corresponding to a predetermined search condition from a database,
An operator or the like inputs search conditions into the DBMS, and the DBMS
Generally, relevant data is extracted from a database based on the input search conditions. For example, when searching for a person who is 30 to less than 50 years old and bought a coat between September and December 1999 from a database in which the name, address, gender, age, and the like of the customer are recorded,
As an example, the operator sets the following search condition expression in the DB
Input to MS. Age> = 30 & Age <50 Sales Month> = 9909 & Sales Month <= 9912 & Product Name = Coat

[0003] In general, a DBMS executes a search process based on these search condition expressions, and extracts customer data as a search result from a database.

To search for data under the same conditions at different times, enter the same search condition formula again and repeat the search, or save the processing procedure at the time of the first search and save it. Is executed again.

[0005]

However, the conventional DBMS has the following problems. (1) When a large amount of data is to be searched, the search process takes a long time. (2) If the same data is required again at a different opportunity after searching for the data according to predetermined search conditions, the same operation is performed or the processing is registered as a procedure and the registered data is registered. The process will be executed again. In any case, the same processing will be performed again, and the DBMS
Requires the same load as the first time, and requires the same processing time. (3) For example, when a past event such as a customer buying a coat is used as a condition, it is necessary to store all the data. (4) When performing analysis processing on the searched data,
When analyzing past events under complex conditions, a large amount of data must always be retained and processed over time. (5) It is not possible to freely modify the search result and make the search result more suitable for the intention of the operator. (6) Storing a large amount of data also increases human resources for hardware investment and backup.

It is an object of the present invention to provide a database management system for reducing the data to be searched when the same search condition is input and for effectively using hardware. Another object of the present invention is to provide a database management system that enables even a person who is not proficient in search technology to perform a complicated search. Another object of the present invention is to provide a database management system in which a search result can be freely modified by an operator's intention. Another object of the present invention is to provide a recording medium capable of realizing a database management system on a general-purpose computer.

[0007]

A database management system according to the present invention for solving the above-mentioned problems comprises object data relating to a managed object including identification information for identifying each object, and an event actually occurring in the managed object. Storage means for storing, in the data representing the event, event data with identification information included in the object data of the managed object in which the event has occurred, and the first storage means in response to a search request from the outside Means for receiving a search condition for extracting desired identification information from
A search unit that searches a storage unit and extracts corresponding identification information; a temporary storage unit that stores the extracted identification information as a set for each of the search conditions; and a storage unit that is stored in the temporary storage unit. A second storage unit in which the identification information is stored in the set unit, and the identification information stored in the temporary storage unit in the second storage unit in the set unit and stored in the second storage unit And a set management means for writing the identification information obtained in the set in the temporary storage means in the set unit. It said set managing means, during the search by the same search condition, and the set according to stored the search condition in the second storage means to write to the temporary storage means.

[0008] By storing the set of identification information obtained as a result of the search in the second storage means, it is possible to present the search result under the same conditions at a higher speed than in the past.
That is, in this system, when a search is issued under the same condition, a set of identification information is acquired from the second storage means and presented, so that the search result can be provided to the operator. Since only the identification information is stored, the hardware resources required for that are significantly reduced compared to the conventional case where the search procedure and the like are stored, and the processing load on the system is reduced. Further, the data stored in the first storage means can be reduced. For example, after searching for a customer who bought a coat, the search result is stored in the second storage means,
Since there is no need to hold event data representing the event that the customer bought the coat, the event data representing the event that the customer bought the coat can be deleted from the second table. Therefore, the event data held in the second table can always be minimized, and hardware resources can be used effectively. Since the data stored in the first storage means can be reduced, the data to be searched is reduced,
The search process becomes faster.

[0009] Another identification information is added to the set of the identification information stored in the temporary storage means, and the identification information is deleted from the set of the identification information stored in the temporary storage means. May be further provided so that the identification information included in the set can be modified. With such a configuration, it is possible to form a set in a form that meets the intention of the operator.

According to another database management system of the present invention, there is provided a first storage unit in which electronic data including identification information for identifying each of the first storage unit is stored, and the first storage unit in response to an external search request. Means for receiving a search condition for extracting desired electronic data, searching means for searching the first storage means in accordance with the search condition, and extracting corresponding electronic data, Temporary storage means for storing the identification information of the extracted electronic data as a set, second storage means for storing the identification information stored in the temporary storage means in the set unit, and second storage means To, a set management means for storing the identification information stored in the temporary storage means in the set unit,
Correction means for enabling the set consisting of the identification information stored in the temporary storage means to be corrected in response to an external request. In this database management system, the correction unit enables other identification information to be added to the set including the identification information stored in the temporary storage unit, and the identification unit stores the identification information stored in the temporary storage unit. Is configured to be able to delete identification information from the set. The correction means enables the addition or deletion of identification information to a set of identification information as a search result, so that the search result can be made according to the intention of the operator.

[0011] The set management means may further have a function of writing the identification information stored in the second storage means to the temporary storage means in units of the set, and the correction means may include a function of the second storage means. The identification information written in the temporary storage means may be configured to be able to be modified in response to an external request. With such a configuration, the set already stored in the second storage means can be corrected, and even if the set needs to be corrected at a later date after the set has been created, the set can be easily corrected.

The present invention may further comprise means for performing a logical operation between the sets stored in the temporary storage means, and creating a new set of identification information obtained as a result of the logical operation. Good. As a result, a logical operation can be performed between the sets obtained as a result of the search, and a new set of identification information can be obtained as an operation result. When performing a complicated search, it is not necessary to create various search condition expressions, and even a person who is not familiar with search technology can easily perform a complicated search. Also, since the processing itself consists of a search with a simple search formula and a logical operation,
The load on the system is also light.

Further, the present invention provides the following customer management system. The customer management system includes a first table holding object data relating to a customer including an ID for identifying each customer, and an event data representing an event actually occurring in the customer, and an object data of the customer in which the event has occurred. A first storage unit for storing a second table holding an ID included in the first table, and a second storage unit for extracting a desired ID from the first table or the second table in response to an external search request. Means for receiving a search condition; search means for searching the first table or the second table in accordance with the search condition to extract a corresponding ID; and for each of the search conditions, the extracted I
D, a temporary storage unit for storing the customer ID list as a set, a second storage unit for storing the ID stored in the temporary storage unit in units of the customer ID list, The I stored in the temporary storage means
Collective management means for storing D in the customer ID list unit and writing the ID stored in the second storage means in the temporary storage means in the customer ID list unit;
Means for performing a logical operation between the customer ID lists stored in the temporary storage means and creating a new customer ID list comprising IDs obtained as a result of the logical operation; and Modifying means for modifying the list in response to an external request. In such a customer management system, the set management unit, when performing a search under the same search condition, stores the customer ID according to the search condition stored in the second storage unit.
The list is configured to be written to the temporary storage unit, and the correction unit enables another ID to be added to the customer ID list stored in the temporary storage unit, and is stored in the temporary storage unit. It is configured such that an ID can be deleted from the customer ID list.

The recording medium of the present invention is a computer-readable recording medium on which a computer program for forming the above-mentioned database management system on a computer is recorded.

[0015]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention makes it possible to reuse an initial search result and store it in combination with another search condition without storing search conditions and search processing procedures. The first search result is not stored as a procedure of the search processing, but only the identification information attached to the data obtained as the search result is set as a set, and the set is given a set name and stored. The identification information specifies a management object, that is, data extracted as a result of the search. In the case of a DBMS that manages data related to a customer's product purchase, for example, a customer, a store, a business partner, a product, or the like can be a management target. The attribute information indicating the attribute of the management target is stored as a table (object table) of the management target. Attribute information includes
There are a name (name), address, date of birth, telephone number, and the like.
In addition, events such as purchases, purchases, inquiries, accidents, etc. performed by the managed object in the past and events (release time, release area, etc.) that occurred in the managed object (products, etc.) are stored as event tables. I do. The object table and the event table are searched based on predetermined search conditions, and identification information for specifying the management target is extracted as a search result. The extracted identification information is stored as a set.

According to the present invention, at the time of reuse, a set name is designated to extract identification information as a search result, or a new set is created by combining the identification information included in the set with another search condition. It is also possible to create. Further, according to the present invention, it is possible to add identification information to a set or to delete identification information in a set.

An embodiment in which the present invention is applied to a DBMS that manages data relating to the purchase of goods by a customer will be described below. <System Configuration> FIG. 1 is a configuration diagram of the DBMS of the present embodiment. The DBMS 1 includes a first storage unit 10, a second storage unit 11, a main control unit 12, a search instruction / display mechanism 13, a search unit 14, and a group management unit 15.

The first storage unit 10 is provided for storing information about a customer. This can be realized by a general data storage mechanism such as a database or a data warehouse. In the present embodiment, as an example, a customer table 101 that stores information about customers and a purchase history table 102 that stores purchase histories of products for each customer are stored in the first storage unit 10.
Are stored.

The customer table 101 is a table for storing attribute information indicating the attributes of the customer, and is an object table in which the customer is a management target. FIG. 2 shows an example of the attribute information. The attribute information of each customer stored in the customer table 101 is provided with an ID (Identification) as identification information for identifying the customer. ID is assigned to be unique for each customer. If a numerical value is used as the ID, an ID of about 4 billion can be prepared in a size of 4 bytes (32 bits), which is sufficient and sufficient for managing customers and the like. Items other than ID include
Stores customer attribute information such as name, address, gender, date of birth, and telephone number. The content corresponding to each item of the customer is stored for each ID.

The purchase history table 102 is a table for storing the behavior of a customer, and is an event table when the customer is a management target. Here, it is assumed that the product purchase history is stored. FIG. 3 shows an example. The items in this table include an ID used in the customer table 101 to identify which customer purchased.
The same ID is used. Items other than the ID include a purchase date, a purchase store name, a product name, a sales amount, and the like. In this table, there is one record for one event that a customer has purchased. If the same customer has made multiple purchases, there are records for the same customer for the number of purchases. When the ID is specified, it is possible to specify which customer the corresponding record belongs to by referring to the customer table 101 by the ID.

The second storage unit 11 is provided to store the set table 111. In FIG. 1, the second storage unit 11 and the first storage unit 10 are logically independent,
It may be physically common. Set table 11
Reference numeral 1 denotes a table for storing customer IDs obtained by a search as a set for each search condition. FIG. 4 shows an example of the set table 111. Set table 111
Is, for each set, a set name, the number of customers corresponding to the search condition, and a list of IDs assigned to the customers corresponding to the search condition (hereinafter, referred to as
It is called a customer ID list. Save). The set name is a name for identifying the set in the set table 111.
The number of customers indicates the number of IDs included in the corresponding customer ID list. The customer ID list is a set of IDs assigned to customers extracted under predetermined search conditions.

The main control unit 12 controls the start and end of the operation of the entire DBMS 1 and the cooperation. The instruction from the search instruction / display mechanism 13 is analyzed, and the search unit 14 and the collective management unit 15 are activated as necessary. The main control unit 12 includes a search unit 14
And the customer ID list obtained from the group management unit 15 is calculated and corrected, and the obtained calculation result and correction result are stored in the group table 111 by the group management unit 15. The main control unit 12 also has a temporary storage unit 16. The temporary storage unit 16 is for temporarily storing the number of customers and a customer ID list obtained by a search or the like.
In this area, a plurality of customer ID lists can be stored. When storing a plurality of customer ID lists, each customer ID list is identified by a set name. The set name in this case is the set name for the customer ID list to which the set name is assigned. For a customer ID list to which no set name is assigned, a name that is unique within the system is automatically assigned by the main control unit 12.

The search instruction / display mechanism 13 receives various instructions from the outside by an operator, another system, or a program and sends them to the main control unit 12. The processing result by the main control unit 12 is displayed on a display (not shown) or transferred to a processing request source. That is, the search instruction / display mechanism 13 is an input / output mechanism of the DBMS 1.

Under the control of the main control unit 12, the search unit 14 searches the customer table 101 and the purchase history table 102 in the first storage unit 10 for desired data, and performs the main control on the obtained search results. Send to section 12. The search conditions and the like are specified by the main control unit 12. The set management unit 15 controls the set table 11 under the control of the main control unit 12.
1 is performed. The collective management unit 15 stores the number of customers and the customer ID stored in the temporary storage unit 16 of the main control unit 12.
In addition to having a function of storing the list in the set table 111, the number of customers stored in the set table 111 and the customer I
It has a function of reading the D list and sending it to the main control unit 12.

<Operation> DBMS configured as described above
1 will be described. Here, retrieval from the table stored in the first storage unit 10, storage of the search result in the second storage unit 11, reading of the search result stored in the second storage unit 11, logical operation between customer ID lists, The five operations of modifying the customer ID list will be described.

FIG. 5 shows a processing flow when a search request is made. The DBMS 1 receives a search request and a search condition from the outside by the search instruction / display mechanism 13 (S11). As an example, suppose a case in which “customers who purchased bags” are requested. In this case, a search condition for searching for items whose item of the product name is “bag” in the purchase history table 102 is given.

The main control unit 12 includes a search instruction / display mechanism 13
When the search request and the search condition are received from the server (S11: Yes), the request is analyzed for the received search request and search condition, and the search unit 14 is instructed to perform a search based on the search condition. The search unit 14 stores the first storage unit 1 according to the search condition.
A search of each table in 0 is performed (S12). As the search result, the IDs 1, 2, and 3 of the customers who have purchased the bags are extracted from the purchase history table 102. This set of customer IDs (customer ID list) is sent from the search unit 14 to the main control unit 12.
Sent to

The main control unit 12 stores the customer ID list sent from the search unit 14 and the number of customers included in the customer ID list in the temporary storage unit 16 (S13). Main controller 12
Is the search instruction / display mechanism 1 for the number of customers and the customer ID list.
3 (S14). As a result, a series of processing related to the search is completed, and the search instruction / display mechanism 13
We will wait for new instructions.

FIG. 6 shows a flow of processing related to storing the number of customers and a customer ID list (set) as search results in the second storage unit 11. Number of customers and customer IDs to be stored
The list is stored in the temporary storage unit 16 of the main control unit 12 as a final state according to the flow shown in FIG.

The number of customers and customer IDs stored in the temporary storage unit 16 from the outside via the search instruction / display mechanism 13
If a list storage request is received (S21: Yes), and the number of customers to be stored and the name (set name) given to the customer ID list are also received (S22: Yes), the main control unit 1
2 is the number of customers stored in the temporary storage unit 16 and the customer I
The D list and the set name are sent to the set management unit 15.
The set management unit 15 assigns a set name to the transmitted number of customers and the customer ID list, and stores them in the set table 111 (S2).
4). When no set name has been given (S22: none)
, The main control unit 12 automatically gives a name that is unique in the system (S23). By the set name,
The set stored in the set table 111 can be identified.

The set management unit 15 confirms that the designated set name is not the same as the set name of the set already stored, and stores the set name in an unused portion of the set table 111. If the received set name is the same as the set name of the set that has already been stored, the main control unit 12 causes the display (not shown) to display a screen prompting for the input of the set name again, and so on. Is re-entered by the operator.

FIG. 7 shows a flow of processing relating to reading of a customer ID list (set) stored in the set table 111 of the second storage unit 11. The DBMS 1 receives a read request for the set stored in the set table 111 from the outside by the search instruction / display mechanism 13 (S31). Here, it is assumed that “a set of customers who have purchased bags” is read. When accepting the read request, the set name of the set to be read, “bag purchase customer”, is also accepted.

The main control unit 12 has a search instruction / display mechanism 13
When a set read request is received from the group (S31: Yes), the set management unit 15 is instructed to read the set with the requested set name. Set management unit 15 from the corresponding entry in the set table 111, reads the customer number and customer ID list of the indicated set name (S3
2) Send the read customer number and customer ID list to the main control unit 12. The main control unit 12 stores the number of customers and the customer ID list sent from the collective management unit 15 in the temporary storage unit 16 (S33). Further, the main controller 12 presents the obtained number of customers and the customer ID list via the search instruction / display mechanism 13 (S34). As a result, a series of processes related to the retrieval of the retrieval result is completed, and the retrieval instruction / display mechanism 1
3 will wait for a new instruction.

FIG. 8 shows a flow of a logical operation process between the customer ID lists stored in the temporary storage unit 16. It is assumed that two or more customer ID lists are stored in the temporary storage unit 16 in advance (S41). The main control unit 12 can arbitrarily calculate between the customer ID lists stored in the temporary storage unit 16. In other words, it is possible to read out the customer ID list stored in the set table 111 or calculate the customer ID list created by searching the search unit 14 in the temporary storage unit 16. Which of the customer ID lists is to be operated is specified by designating a set name.

The DBMS 1 receives an external calculation request between the customer ID lists by the search instruction / display mechanism 13 (S42). As an example, a case is assumed in which a customer who satisfies both “a customer who purchases a bag” stored in the set table 111 and a “customer who purchases goods of 50,000 yen or more” is obtained. In the temporary storage unit 16 of the main control unit 12,
Both customer ID lists of a set of “bag-purchasing customers” and a set of “commercial-purchasing customers of 50,000 yen or more” are read.

The main control unit 12 includes a search instruction / display mechanism 13
(S42: Yes), the calculation between the customer ID lists in the temporary storage unit 16 is performed based on the calculation request. In this case, since the logical product of both sets is calculated, the customer IDs included in both of the two lists are selected, and the customer ID list obtained as a result of the operation is newly stored in the temporary storage unit 16. Store (S4
3). As the operation between the customer ID lists, the same operation as the set logical operation is possible, and a logical sum, a logical product, a complement set,
There is an exclusive OR or the like. The main control unit 12 presents the newly obtained number of customers and the customer ID list via the search instruction / display mechanism 13 (S44). As a result, the arithmetic processing between the search results is completed, and the search instruction / display mechanism 13 waits for a new instruction. When the newly obtained number of customers and the customer ID list are stored, the processing of the flow in FIG. 6 may be performed.

FIG. 9 shows a flow of a process of correcting a search result and a calculation result of a customer ID list and the like stored in the temporary storage unit 16. It is assumed that the customer ID list is stored in the temporary storage unit 16 in advance (S51).
The DBMS 1 receives a request to modify the customer ID list from the outside by the search instruction / display mechanism 13 (S5).
2). The customer ID list to be modified is specified by the set name. When receiving the correction request from the search instruction / display mechanism (S52: Yes), the main control unit 12 corrects the customer ID list stored in the temporary storage unit 16 based on the correction request (S53). . The correction request includes deletion of a customer ID existing in the customer ID list,
And the like. The main controller 12 presents the corrected number of customers and the customer ID list via the search instruction / display mechanism 13 (S54). When there is an external instruction to save the corrected customer ID list via the search instruction / display mechanism 13, the main control unit 12 stores the corrected customer ID list in the set table 111 with the same set name. It is overwritten and saved, or is saved in the set table 111 with another set name. When saving with a different set name, the processing of the flow in FIG. 6 may be performed. As a result, a series of processes relating to the modification of the search result is completed, and the search instruction / display mechanism 13 waits for a new instruction.

Creation of a set realized by the above procedure,
The following effects can be obtained by performing processing combining basic operations of storage, calculation, and correction.

(Effect of Saving Set) By storing the customer ID, which is the result of the search once, as a set (customer ID list), when the result under the same search condition is required again, the result is re-searched. Faster than you get
Present search results. Further, since it is only necessary to read the customer ID list from the set table 111, it is possible to present the search result with a small number of resources.

The purchase history table 102 stores data corresponding to the history of purchases made by customers. This table also holds five items of data per case as shown in FIG. 3 in the above embodiment. When the data length of each item assuming 10 bytes, the data amount of 1 per 50 bytes.
For example, assuming that there are 100 customers who have purchased the product “back”, the data amount of these is 50 bytes × 100
= 5000 bytes. On the other hand, when "customers who purchased the bag" are searched and stored as a set, the data size is 20 bytes for the set name, 4 bytes for the number of customers, and
Assuming that the D-list is 4 bytes, only 20 bytes + 4 bytes + 4 bytes × 100 = 424 bytes are required.
The data amount when stored as a set is 1/10 or less as compared with the case where the data is managed in the customer history table 102. Once "customers who have purchased bags" are stored as a set, it is not necessary to perform the same search again, so that these data can be deleted from the purchase history table 102. Since unnecessary data can be deleted, the storage area required for storing data can be significantly reduced.

When a search result or an operation result of a set is newly stored as a set, a set name is given. This set name is determined not by how the customer ID list (set) is created, but by Choose a name that keeps in mind what the customer ID list means. This has a very remarkable effect when the logical operation between sets is repeated. This is because even if the set shows the created conditional expression, it becomes difficult for the creator to understand.

(Effect of Operation Between Sets) A logical operation can be performed by combining the stored customer ID list and the customer ID list obtained by searching, so that it is possible to obtain the customer ID list finally obtained. The process can be realized only by repeating basic operations. Therefore, it is not necessary to assemble at once a request in which search conditions are combined in a complicated manner, so that it is unnecessary to learn complicated search requests and the load on the search processing system is reduced.

(Effect of Correction of Customer ID List) In order to enable the correction of the customer ID list, the customer ID list can be customized according to the intention of the operator who is performing the correction. By customizing, it is possible to make the customer ID list convenient for the operator. If there is an item in each table of the first storage unit 10, a desired customer ID list can be created by performing a search. Customer I, even if not in item
By modifying the D list, a desired customer ID list can be created.

As an example, let us consider a case in which “customer who is important for senior management” is selected. In this case, the selection criterion for “important customer of senior management” is very vague, and each person (one company, one company)
The reason is different, and it is possible that the managing director cannot clearly show why it is important. Therefore, it is difficult to obtain a desired customer ID by searching the table.
However, for example, customer IDs are extracted to some extent under rough search conditions in advance and set as a set, and each person (one company, one company)
By looking at the name of the (company), it is possible for the managing director to judge whether it is important or not and to add and delete IDs to make an optimal set of IDs. Once the "important customer of the managing director" is registered as a set, this set can be handled and processed in the same manner as that created under the search condition. Further, even if the content of “important customer of senior management” changes between 1999 and 2000, it is possible to respond.

The present invention can be applied not only to management of a customer's purchase history but also to the following fields. -It is possible to handle not only the purchase history of the customer's products but also various transaction statuses with the customer, that is, the history of inquiry status by telephone, facsimile, letter, e-mail, and the like. The data exemplified in the customer table 101 and the purchase history table 102 is not limited to a database, but may be data stored in a data warehouse, a data mart, a data web house, or the like.・ It is possible to accumulate and use the download history of sites and pages on the Internet in the same way as the purchase history. Save as a set,
It can be reused.

In this embodiment, an example has been described in which data to be searched is stored in two tables and a search is performed. However, the data to be searched is not limited to this, and data that can be identified by identification information is not limited to this. If it is, it may be stored in any form.

[0047]

As it is evident from the foregoing description, that according to the present invention, it becomes possible to shorten the data read time at the time of re-use of the search processing time and search results of data when the data of interest has become mass It has a special effect.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a database management system to which the present invention is applied.

FIG. 2 is a diagram showing an example of the contents of a customer table.

FIG. 3 is a diagram showing an example of the contents of a purchase history table.

FIG. 4 is a diagram showing an example of the contents of a set table.

FIG. 5 is a diagram showing a processing flow when a search request is made;

FIG. 6 is a diagram showing a flow of processing related to storage of a set.

FIG. 7 is a diagram showing a flow of processing relating to reading of a stored set.

FIG. 8 is a diagram showing a flow of an operation between sets.

FIG. 9 is a diagram showing a flow of processing for correcting a set.

[Description of Signs] 1 DBMS 10 First storage unit 11 Second storage unit 12 Main control unit 13 Display mechanism 14 Search unit 15 Set management unit 16 Temporary storage unit 101 Customer table 102 Customer history table 102 Purchase history table 111 Set table

 ────────────────────────────────────────────────── ─── Continuing on the front page (72) Inventor Kyoko Suga 1-6-1 Nishi-Shinjuku, Shinjuku-ku, Tokyo Beacon Information Technology Inc. F-term (reference) 5B075 PP23 PQ02 PR03 5B082 GA08 GA16

Claims (8)

[Claims] 1. An object data related to a managed object including identification information for identifying each object, and data representing an event actually occurring in the managed object included in object data of the managed object in which the event occurred First storage means for storing event data to which identification information is attached, and means for receiving a search condition for extracting desired identification information from the first storage means in response to an external search request; A search unit that searches the first storage unit in accordance with the search condition and extracts corresponding identification information; a temporary storage unit that stores the extracted identification information as a set for each search condition; A second storage unit in which the identification information stored in the temporary storage unit is stored in the unit of a set; and the identification information stored in the temporary storage unit in the second storage unit. Stores in serial set unit, the second
And a set management unit that writes the identification information stored in the storage unit to the temporary storage unit in the set unit, wherein the set management unit is configured to perform the second storage when searching under the same search condition. A database management system configured to write a set based on the search condition stored in the means into the temporary storage means. 2. A method for adding another identification information to the set including the identification information stored in the temporary storage unit and deleting the identification information from the set including the identification information stored in the temporary storage unit. The database management system according to claim 1, further comprising a correction unit configured to perform the correction, and configured to be able to correct the identification information included in the set. 3. A first storage means for storing electronic data including identification information for identifying each of them, and for extracting desired electronic data from the first storage means in response to an external search request. Means for receiving the search condition, searching means for searching the first storage means in accordance with the search condition, and extracting the corresponding electronic data, identification of the extracted electronic data for each search condition Temporary storage means for storing information as a set, second storage means for storing the identification information stored in the temporary storage means in units of the set, and storage in the second storage means and in the temporary storage means A set management unit that stores the set identification information in the set unit; and enables the set that includes the identification information stored in the temporary storage unit to be modified according to an external request. Correction means, wherein the correction means enables other identification information to be added to the set of the identification information stored in the temporary storage means, and the correction information stored in the temporary storage means. A database management system configured to enable identification information to be deleted from the set of identification information. 4. The set management means further has a function of writing the identification information stored in the second storage means to the temporary storage means in units of the set, and the correction means includes: 4. The database management system according to claim 3, wherein the identification information written from the second storage unit to the temporary storage unit can be modified in response to an external request. 5. 5. The apparatus according to claim 1, further comprising: a unit that performs a logical operation between the sets stored in the temporary storage unit, and creates a new set including identification information obtained as a result of the logical operation. Database management system. 6. A first table for holding object data relating to a customer including an ID for identifying each of them, and an event data representing an event actually occurring for the customer in an object data of the customer in which the event occurred. First storage means for storing a second table to which an ID is included and held, and a search for extracting a desired ID from the first table or the second table in response to an external search request Means for receiving a condition; searching means for searching the first table or the second table in accordance with the search condition to extract a corresponding ID; gathering the extracted ID for each search condition Temporary storage means for storing as a customer ID list, and the ID stored in the temporary storage means,
A second storage unit that is stored in units of a D list; and the ID that is stored in the temporary storage unit in the second storage unit is stored in units of the customer ID list, and the second storage unit that is stored in the second storage unit. A group management unit that writes an ID to the temporary storage unit in units of the customer ID list; a new customer that performs a logical operation between the customer ID lists stored in the temporary storage unit and that is an ID obtained as a result of the logical operation Means for creating an ID list; and correction means for enabling the customer ID list stored in the temporary storage means to be corrected in response to an external request. When a search is performed under the same search condition, the customer ID list based on the search condition stored in the second storage unit is written in the temporary storage unit. Serial modifying means is configured to allow add other ID to the customer ID list stored in the temporary storage means, from the customer ID list stored in the temporary storage unit I
A customer management system configured to allow D to be deleted. 7. Object data relating to a managed object including identification information for identifying each object, and data representing an event actually occurring in the managed object included in object data of the managed object in which the event occurred First storage means for storing event data to which identification information is attached, and means for receiving a search condition for extracting desired identification information from the first storage means in response to an external search request; A search unit that searches the first storage unit in accordance with the search condition and extracts corresponding identification information; a temporary storage unit that stores the extracted identification information as a set for each search condition; A second storage unit in which the identification information stored in the temporary storage unit is stored in the unit of a set; and the identification information stored in the temporary storage unit in the second storage unit. Stores in serial set unit, the second
A set management unit that writes the identification information stored in the storage unit to the temporary storage unit in units of the set, wherein the set management unit stores the identification information in the second storage unit when a search is performed under the same search condition. A computer-readable recording medium on which a computer program for forming a database management system on a computer for writing the set obtained by the search condition into the temporary storage means is recorded. 8. A first storage means for storing electronic data including identification information for identifying each of them, and for extracting desired electronic data from said first storage means in response to an external search request. Means for receiving the search condition, searching means for searching the first storage means in accordance with the search condition, and extracting the corresponding electronic data, identification of the extracted electronic data for each search condition Temporary storage means for storing information as a set, second storage means for storing the identification information stored in the temporary storage means in units of the set, and storage in the second storage means and in the temporary storage means A set management unit that stores the set identification information in the set unit; and enables the set that includes the identification information stored in the temporary storage unit to be modified according to an external request. And a correction means, said correction means is configured to allow adding other identification information to the set consisting of the identification information stored in the temporary storage means, from the identification information stored in the temporary storage means A computer-readable recording medium on which a computer program for forming a database management system on a computer which enables identification information to be deleted from the set is recorded.