JP2000222411A - System and method for extracting and outputting data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data extraction and output system and a method therefor capable of inexpensively and efficiently extracting data for every plural references and outputting the extracted data concerning a data extraction and output device and a method for extracting and outputting a certain desired data from a prescribed number of data bases by using prescribed data as references. SOLUTION: Prescribed data are extracted from a customer data base(DB) 12 and a branch DB 13, longitude and latitude are added to the extracted data by using a longitude/latitude added address table 14, etc., and the longitude/ latitude added data are stored in a customer longitude added DB 17A and a branch longitude added DB 17B. A prescribed number of target data are extracted in accordance with data referring to one of the data stored n the DBs 17A, 17B and a condition value inputted from an input part 18, the prescribed number of target data is ectracted for every prescribed number of reference data and stored in an extraction table 19 and the stored data are outputted and printed out by an information embodiment device or the like.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a data extraction / output system and a data extraction / output method for extracting and outputting desired data from a predetermined number of databases based on predetermined data.

[0002]

2. Description of the Related Art In recent years, various types of data have been made into various databases and used by individuals and various types of business. These databases generally extract desired data and are used in output forms such as display and printing, and various data are extracted. Therefore, for example, when performing direct mail, it is desired to extract and output a plurality of effective data to make the relationship between the sending source and the sending destination more efficient.

Conventionally, when data is extracted from a predetermined database and output, there are data that is displayed as an output form and data that is not displayed. For example, a car navigation system is displayed. This is because the input destination information and the current position information (G
Position measurement by PS (global positioning system)
Then, the map information in the database is extracted, and the distance, route, and the like are calculated from the map information and displayed on the display.

[0004] Further, as a device which is not displayed in an output form, for example, a device disclosed in Japanese Patent Laid-Open No. Hei 10-240825 is known. This is a system aimed at printing catalogs and direct mails for each customer as an output form of data extraction. In accordance with the input of an identification code from a customer via a communication line, individual product information specific to the customer is output from a database. This is to extract, edit this and product data, and print product guide information such as catalogs and direct mails.

[0005]

Incidentally, in the case where a catalog, direct mail, printing of an address, etc. are performed without displaying the data as an output form of data extraction, Japanese Patent Application Laid-Open No.
In the data extraction and output described in Japanese Patent No. 240825, it is not possible to collectively process a plurality of customers,
It is assumed that there is a single sender, and it cannot be applied to the case where the senders are dispersed in terms of customer collection efficiency, that is, to a plurality of data extractions based on a plurality of criteria. In addition, the car navigation system is a mapping system, which is expensive and, even if the processing of this system is applied, the system performs processing based on a relationship between destination information and current position information, that is, one-to-one data. Therefore, it cannot be applied to a process of extracting and outputting data based on a plurality of criteria. Therefore, the present invention has been made in view of the above problems,
It is an object of the present invention to provide a data extraction and output system and a data extraction and output method for inexpensively and efficiently extracting data for each of a plurality of criteria and outputting the data.

[0006]

In order to achieve the above object, according to the present invention, a predetermined number of databases storing predetermined data and an attribute for associating attribute information with the predetermined data are provided. An information table and a predetermined number of attributes for storing data extracted from the predetermined number of databases and attribute data associated with the attribute information table in the target information, respectively, in association with the databases; An information-added database,
A condition value to which the attribute information is added to data extracted from the predetermined number of databases, and data to which a predetermined number of reference attribute information extracted from one of the attribute information added databases is added; And a work means for extracting a predetermined number of target data specified by the above from other databases of the attribute information added database, and extracting and outputting these for each of the reference data. .

According to a second aspect of the present invention, in the data extraction and output system according to the first aspect, the attribute information is longitude and latitude longitude and latitude information, and a predetermined range from the reference data when extracting the target data. And the distance to the target data is calculated, and data extracted from the predetermined number of databases includes information associated with the attribute information.

According to a third aspect of the present invention, in the data extraction and output system according to the first or second aspect, the target data output from the work means is stored for each of the reference data and a predetermined number of individual data to be output are stored. It is configured to have a database.

According to a fourth aspect of the present invention, in the data extraction and output system according to any one of the first to third aspects, the data extraction and output system is based on the reference data and the target data output from the work means or the individual database. It is configured to include information embodying means for embodying information.

According to a fifth aspect of the present invention, in the data extraction and output system according to the fourth aspect, the information implementation means includes at least printing, printing, and information disclosure to a computer communication network.

According to a sixth aspect of the present invention, in the data extraction and output system according to the fourth or fifth aspect, the information embodying means has a configuration in which the embodying of the information is made different depending on individual information included in the target data. I do.

According to the present invention, a step of extracting predetermined data from a predetermined number of databases, a step of adding attribute information to the extracted data, and a step of adding attribute information extracted from the one database Extracting a predetermined number of target data extracted from another database and added with the attribute information by using one of the predetermined number of data as a reference and the reference data and an input condition value; Extracting and outputting the predetermined number of target data for each data serving as a number reference.

According to the invention of claim 8, in the data extraction and output method according to claim 7, the attribute information is longitude and latitude longitude / latitude information, and an area or a predetermined range from the reference data when extracting the target data. The distance to the target data is calculated, and data extracted from the predetermined number of databases includes information associated with the attribute information.

According to a ninth aspect of the present invention, in the data extraction and output method according to the seventh or eighth aspect, information based on the output reference data and target data is embodied.

According to a tenth aspect of the present invention, in the data extracting and outputting method according to the ninth aspect, the information is embodied at least including printing, printing, and information disclosure to a computer communication network.

According to the eleventh aspect of the present invention, in the ninth or the first aspect,
0, wherein the information is embodied differently according to the individual information included in the target data.

[0017]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Preferred embodiments of the present invention will be described below with reference to the drawings. FIG. 1 shows a system configuration diagram of an embodiment of the present invention. The data extraction and output system 11 shown in FIG. 1 is an example of a case where a direct mail is sent to a customer who is in charge of each branch in a bank or the like having each branch, in which two databases are used. Is shown. In FIG. 1, a data extraction and output system 11 has two databases (single database DB): a customer DB (database) 12 in which data of all customers is stored, and a branch DB 13 in which data of all branches are stored. Or more databases are applicable).

Then, two database customer DBs 12
In order to extract and output data based on the data in the branch DB 13, the work area 14, which is a work means for performing various data processing, and an address provided in the work area 14 (may be outside the work area). (Information associated with attribute information) is provided in the work table 14 (the address table 15 with latitude and longitude), which is an attribute information table in which the latitude and longitude on the map are associated with each other (may be outside the work area). A latitude / longitude addition table 16 for adding latitude / longitude to data including an address, and a customer latitude / longitude DB1 which is an attribute information addition database in which data of customers to which latitude and longitude are added are stored.
7A, a branch-latitude-attached DB 17 which is an attribute information-added database in which data of branches to which latitude and longitude are added are stored.
B, condition value input unit 1 for inputting condition values such as distance and direction
8. It is composed of an extraction list table 19 which is a predetermined number of individual databases for storing the extracted data for each reference data, and an information implementation device 20 which is an information implementation means for printing the output data.

FIG. 2 shows a flow chart of the data extraction of the present system. In FIG. 2, first, the branch DB
13, the data of each branch is acquired in the work area 14 (step (S) 1A), and the data of each customer is acquired in the work area 14 from the customer DB 12 (S1B). In this case, each branch data and each customer data include address data as described later.

Subsequently, the obtained branch data and customer data are converted into respective data using a longitude / latitude conversion table (longitude / latitude address table 15 and longitude / latitude addition table 16) based on the address data of each data. Attachment of latitude and longitude information as attribute information is added to the customer DB 12 and the branch DB, respectively.
13 is stored and acquired in the customer latitude and longitude DB 17A and the branch latitude and longitude DB 17B corresponding to the client 13 (S2).
A, S2B). These processes are performed for all branch data and each customer data (S3A, S3B). The process of adding latitude and longitude will be described in detail with reference to FIG.

The branch data with latitude and longitude of the predetermined branch stored in the branch latitude and longitude DB 17B is stored in the work area 14.
, And based on the longitude and latitude of each branch data with latitude and longitude, the area of the branch is specified by latitude and longitude based on the numerical value, data, and the like of the condition value input from the condition value input unit 18 ( S4). This area specification will be described in detail with reference to FIG. Subsequently, the customers belonging to the area that is classified by the predetermined branch whose area is specified are identified by the customer longitude and latitude D
B17A compares the latitude and longitude information added to the customer data and extracts target data of a predetermined number of customers (S17).
5). These processes are to specify an area for all branches and extract customers belonging to the area (S
6).

Although the above-described data extraction has been described for the case where customer data is extracted on the basis of each branch side, the same processing is performed when branch data is extracted on the basis of the customer side.

Next, FIG. 3 is an explanatory diagram of the addition of latitude and longitude in the data extraction of the present system. As shown in FIG. 3, the customer DB 12 stores “customer ID”, “address”,
It is configured to include each information such as "Name"
Reference numeral 13 includes information such as “branch ID”, “address”, and “branch name” for each branch. On the other hand, the address table 15 with latitude and longitude includes, for example, “address code”, “kana”, “kanji (prefecture)”, “kanji (city / city)”,
"Kanji (large characters / commonly known)", "Total number of Kanji characters", "Numbers (Chome)", "Numbers (addresses / addresses)", "Numbers (No.)",
The address and the longitude and latitude are associated with each other including at least information such as “latitude” and “longitude”.

Therefore, in the work area 14, first, the customer DB
The customer data is taken in from 12, and the address and the total number of kanji characters thereof are extracted from the information of “address” and written in the latitude and longitude adding table 16. This and the latitude and longitude address table 1
5, "Total number of kanji" and "Kanji (prefecture)"
Compares the information of "Kanji (municipalities)" and "Kanji (large characters / commonly known)", and if they match, adds the latitude and longitude information to the customer's "Address" and "Total number of Kanji characters" information Then, it is stored together with the customer ID in the DB 17A with customer latitude and longitude. These processes are performed for all customers. Similarly, information on the longitude and latitude is added to all the branches and stored in the branch longitude and latitude DB 17B.

In addition, in adding the latitude and longitude, in the above example, a case was shown in which the comparison was performed using the information of "Kanji (prefecture)" and "Kanji (city, town, town and village)". "Numbers (chome)" in branch DB13,
By comparing the information of “numerical (number / address)” and “numerical (number)”, highly accurate latitude and longitude information can be added.

Next, FIG. 4 is an explanatory diagram for specifying an area in the data extraction of the present system. FIG. 4 (A), (B)
4C shows a case in which an area in which the branch is in a category is specified on the basis of the branch side, and FIGS. 4C and 4D show a case in which an area in which the customer is in a category is specified on the basis of the customer side. ing. In FIG. 4A, it is assumed that the work area 14 fetches predetermined branch α data from the branch longitude / latitude DB 17B and specifies an area having a radius X, for example, based on the longitude / latitude information (N, E).

At this time, the condition value of the information of the radius and the information of the distance X is inputted from the condition value input section 18 and the reference point α (N,
From E), the area Y1 in the category of the radius X is specified by the calculation processing, and the longitude and latitude within the area Y1 are specified.
The distance calculation in this case is, for example, a method of calculating the distance from the latitude and longitude of two points, calculating the radius of curvature of the earth near Japan, and assuming a sphere with that radius, the distance between the two spherical points is calculated There is a way to ask.

Then, the area Y to which the branch α belongs
1, the predetermined number of customers β1 (N, E) and β2 belonging to the area Y1 are compared with the latitude and longitude information of all customer data in the customer latitude and longitude information DB 17A.
(N, E),... Are extracted. As another extraction method, the distance between the reference point α (N, E) and the longitude and latitude β (N, E) of each customer data is determined by, for example, the above-mentioned calculation method without specifying the area from the reference data. This is a method of individually calculating, determining whether or not the distance is within the range of the distance X, and extracting a predetermined number of target data β1 (N, E), β2 (N, E),. These processing operations are performed for each branch.

FIG. 4A shows a case where an area Y1 having a radius X is specified based on the latitude and longitude α of a branch or customer data is extracted by distance calculation. FIG. This shows a case where an area is specified in a rectangular shape with the side length X as a reference, or customer data is extracted at each rectangular distance, and the processing method is the same as described above. FIG. 4C shows a case where an area Y2 having a radius X is specified or branch data is extracted by distance calculation with reference to the longitude / latitude beta of predetermined customer data. FIG. This is a case where a rectangular area having a side length of X is specified as a reference, or branch data is extracted at each rectangular distance, and the processing method is the same as described above. Although the specified area may cross,
The distance X may be set so as not to cross, or may be crossed to extract data overlapping each other.

Next, FIG. 5 shows an explanatory diagram of a data extraction result in the present system. FIG. 5 shows an extraction list table 19 which is an individual database. FIG. 5A shows a case where each branch is used as a reference, and FIG. 5B shows a case where a predetermined customer is used as a reference. . That is, in FIG. 5A, when the result of extracting the data of the corresponding customer by the above method is output, for example, the extraction list table 19 includes, for example, the A branch table 19-1A and the B branch table 19-1.
B, C branch tables 19-1C,... Are stored in individual databases for each branch. In this case, each table stores the extracted target data, for example, the customer ID of each customer, and outputs the data to the information embodying device 20 described later.

FIG. 5B shows a case where the result of extracting the branch data by the above method based on a predetermined customer is output, for example, an A customer table 19-2A and a B customer table 19-2B. , C customer tables 19-2C,... Store, for example, branch IDs. In this case, when there are a plurality of extracted branches, or when the same branch is redundantly extracted by each customer, for example, only the data having the shortest distance may be used. May be added. Then, the target data stored in each of these tables is output to the information embodying device 20 described later.

Next, FIG. 6 is an explanatory diagram of an example of data output in the present system. In the present embodiment, the output of each customer data or each branch data of the extraction list table 19 is sent to the information embodying device 20. Examples of the information embodying device 20 include a printing device, a printing device, and a computer. Accordingly, FIG.
FIG. 6B shows the concept when printing is performed on the envelope 22, the shipping table, and the like by the printing device, and FIG. 6C shows the concept of computer communication by the computer. This shows a concept in a case where the information 23 is disclosed on a network (for example, an information transmission system WWW (Wold Wide Web) on the Internet).

For example, taking printing as an example, in response to the output of a predetermined number of customer data (FIG. 5 (A)) for each branch stored in the extraction list table 19, the printing apparatus moves the branch to a predetermined location. The name of the branch, its address (the name of the person in charge if necessary), the customer name extracted based on the branch, and its address are printed on an envelope with the sender as the sender. In this case, when only the customer ID is stored in the extraction list table 19, the name, address, and the like may be read from the branch ID and the customer ID based on each customer DB and the branch DB. In addition, a customer ID,
Necessary addresses, names, and the like may be stored in addition to the branch ID.

As described above, in the bank described above,
Direct mail can be sent from each branch to customers who have direct transactions, thereby improving customer collection efficiency and transaction efficiency. Further, the present invention is not limited to direct mail, and can be used to easily and inexpensively produce mails and dispatches as cover letters and shipping data.

By the way, the information embodying device 20 may have a different embodying form according to the target data. For example, individual information is attached to each customer data in each table of the extraction list table 19 shown in FIG. The individual information may include, for example, age, gender, telephone number, and the like. That is, according to the age and gender of the customer, the distance X input when extracting the target data based on the reference data is changed (to shorten the distance in the case of an elderly person or a woman), and printing and printing are performed. In addition, characters (fonts) for information disclosure or information disclosure are enlarged, appropriate designs are applied, or these are appropriately combined.

As described above, in extracting and outputting a predetermined number of target data for each of a plurality of references, it is possible to calculate distances at once inexpensively and simply on data processing without using an expensive mapping system or display device. Thus, data can be selected, extracted, and output practically efficiently.

If the mapping data is used to extract the customer (branch) target data based on the longitude / latitude information based on the reference data of the branch (customer), the data is simply calculated from the latitude / longitude on the map by a linear distance. Instead, the distance and the route can be specified. For example, from the latitude and longitude information of obstacles (rivers, lakes, arterial roads, railway tracks, etc.) on a straight route, select a route that avoids these at bridges, pedestrian crossings, railroad crossings, etc., and use data calculated for the distance. Thus, data can be extracted more usefully. When using mapping data without latitude and longitude as attribute information, for example, matrix information on mapping (on a plane) can be applied instead of latitude and longitude.

In the above embodiment, a bank has been described as an example. However, the present invention is not limited to this and can be applied to a telephone communication business, a house closing business, a real estate business, a convenience store business, a vending business (installation), and the like. For example, when applied to the telephone communication industry, a communication cost or the like is calculated (or a table is calculated) by extracting a predetermined number of target data (communication destinations) based on a plurality of criteria (communication sources) in relation to a communication source and a communication destination. In addition to this, it is possible to compare the communication costs of local calls, long distance calls, long-distance calls and other communication costs with other communication costs at a low cost and efficiently.

[0039]

As described above, according to the first and seventh aspects of the present invention, predetermined data is extracted from a predetermined number of databases, attribute information is added thereto, and data based on one of the extracted data is input. A structure in which a predetermined number of target data is extracted for each predetermined number of reference data according to a predetermined condition value, data extraction and output of a plurality of references can be easily and inexpensively and collectively performed on data processing. Is what you can do.

According to the second and eighth aspects of the present invention, data associated with attribute information is included in the data, and the attribute information is extracted as longitude and latitude longitude / latitude information within an area or within a predetermined distance. Data extraction can be performed at low cost without using a simple mapping system.

According to the third aspect of the present invention, the target data output from the working means is stored in a predetermined number of individual databases for each of the reference data, and each data is output, whereby the data is extracted based on a plurality of references in the same manner as described above. Data can be output efficiently.

According to the fourth and ninth aspects of the present invention, information output from the working means or the individual database is realized by the information realizing means for each reference data, so that a low-cost and efficient display device is not required. Information can be embodied.

According to the fifth and tenth aspects of the present invention, at least printing, printing, and information disclosure to a computer communication network are included as an embodiment of the information implementing means.
The information can be embodied inexpensively and efficiently without the need for a display device.

According to the sixth and eleventh aspects of the present invention, the information embodying means varies the materialization of information according to the individual information included in the target data, thereby realizing an effective information realization according to the target data. It can be carried out.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of an embodiment of the present invention.

FIG. 2 is a flowchart of data extraction of the present system.

FIG. 3 is an explanatory diagram of latitude and longitude addition in data extraction of the present system.

FIG. 4 is an explanatory diagram for specifying an area in data extraction of the present system.

FIG. 5 is an explanatory diagram of a data extraction result in the present system.

FIG. 6 is an explanatory diagram of an example of data output in the present system.

[Explanation of symbols]

 Reference Signs List 11 Data extraction output system 12 Customer database 13 Branch database 14 Work area 15 Address table with latitude and longitude 16 Addition table with latitude and longitude 17A Database with latitude and longitude 17B Database with branch latitude and longitude 18 Condition value input section 19 Extraction list table 20 Information implementation device

Continued on the front page F term (reference) 2C032 HB06 HB08 HB15 HB31 HC05 5B075 ND02 NK46 PQ02 PQ34 PQ46 UU13 5H180 AA14 AA15 BB05 FF21 9A001 BB04 FF03 JJ02 JJ11 KZ60

Claims (11)

[Claims] A predetermined number of databases storing predetermined data; an attribute information table for associating attribute information with the predetermined data; and an attribute information table for extracting data respectively extracted from the predetermined number of databases. A predetermined number of attribute information-added databases for storing the target data to which the attribute information associated with the attribute information table is added in correspondence with the databases, and the attribute information to data extracted from the predetermined number of databases. A predetermined number of target data specified by data to which a predetermined number of reference attribute information extracted from one of the attribute information added databases is added and a condition value to be input are added to the attribute information added database. Extracted from other databases in the additional database, and these are extracted for each of the reference data. And a work means for extracting and outputting the data. 2. The data extraction and output system according to claim 1, wherein the attribute information is longitude and latitude longitude and latitude information,
When extracting the target data, the distance from the reference data to a predetermined range of the area or the target data is calculated, and information extracted from the predetermined number of databases includes information associated with the attribute information. A data extraction output system characterized by being included. 3. The data extraction and output system according to claim 1, further comprising a predetermined number of individual databases for storing and outputting the target data output from the work means for each of the reference data. Characterized data extraction and output system. 4. The data extraction and output system according to claim 1, wherein information based on said reference data and target data output from said work means or said individual database is embodied. A data extraction / output system comprising information implementing means. 5. The data extraction and output system according to claim 4, wherein the information implementation means includes at least printing, printing, and information disclosure to a computer communication network. 6. The data extraction and output system according to claim 4, wherein said information embodying means changes the embodyment of said information in accordance with individual information included in said target data. Output system. 7. A process for extracting predetermined data from a predetermined number of databases, a process for adding attribute information to the extracted data, and a process for extracting a predetermined number of data extracted from the one database and to which the attribute information is added. Extracting, based on one of the data, a predetermined number of target data extracted from another database and added with the attribute information based on the reference data and the input condition value; and Extracting and outputting the predetermined number of target data for each data. 8. The data extraction and output method according to claim 7, wherein the attribute information is longitude and latitude longitude and latitude information,
When extracting the target data, the distance from the reference data to a predetermined range of the area or the target data is calculated, and information extracted from the predetermined number of databases includes information associated with the attribute information. A data extraction / output method characterized by being included. 9. The data extraction and output method according to claim 7, wherein information based on the output reference data and target data is embodied. 10. The data extraction and output method according to claim 9, wherein the information is embodied at least including printing, printing, and information disclosure to a computer communication network. 11. The data extraction and output method according to claim 9, wherein the information is embodied differently according to individual information included in the target data.