JPH06338958A - Data base processor - Google Patents

Abstract

PURPOSE:To easily construct a system even in small capital. CONSTITUTION:Registered data in a hard disk device 28 is registered and updated for each franchise shop 3, 3A. When it reaches prescribed time, a center system 2 collects each registered data, and generates new master data. This master data is stored in the hard disk device 28 through an ISDN line 1. Thus, each franchise shop 3, 3A can execute the retrieval processing of various kinds of information on the basis of the same master data without accessing the center system 2.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database processing apparatus suitable for processing and searching various databases having a large amount of information such as images at each terminal.

[0002]

2. Description of the Related Art Conventionally, a database processing apparatus of this type displays, on the terminal side, the data content of a selection screen for database access sent from a general-purpose computer, as disclosed in, for example, Japanese Unexamined Patent Publication No. 3-282778. When it is displayed on the device and the coordinate data selected via the input device based on this data content is sent to the general-purpose computer side, the desired information data is retrieved from the database in the general-purpose computer and displayed again on the display device on the terminal side. It is supposed to be done. Data transmission between such a general-purpose computer and each terminal is mainly performed by ISD.
It is carried out via N lines (service integrated digital network).

[0003]

In the above-mentioned prior art, since all databases are stored in the general-purpose computer, it is necessary to call the general-purpose computer each time desired information data is taken out from the terminal side.
Therefore, when a plurality of terminals are connected to a general-purpose computer and used, enormous communication costs are incurred and it is difficult to construct a new system with a small amount of capital.

The present invention is intended to solve such a problem, and an object of the present invention is to provide a database processing apparatus capable of easily constructing a system with a small amount of capital.

[0005]

DISCLOSURE OF THE INVENTION The present invention is intended to achieve the above-mentioned object, and is updated at any time based on input means, master data common to each terminal, and information from the input means. Rewritable storage means having registration data, and sucking up the registration data stored for each of the terminals at a predetermined time, and creating new master data based on the comparison result of the collected registration data and the master data. And a control processing means for sending to each of the storage means.

[0006]

With the above structure, new information is stored and updated in the storage means from the input means of each terminal at any time,
The control processing means creates new master data based on the registration data downloaded from each terminal at a predetermined time. After that, since the contents of this new master data are stored in the storage means, each terminal searches for various information in real time based on the same master data stored in the storage means without calling the control processing means. It becomes possible to do.

[0007]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the accompanying drawings shown in FIGS. The database processing apparatus according to the present embodiment is applied to a search display system for selling used cars, which is installed in a center and a plurality of franchise stores, and in FIG. 1 showing the overall configuration, 1 denotes each terminal. An ISDN line as a communication means connected between the center system 2 and each of the franchise stores 3 and 3A. Through the ISDN line 1, various kinds of digital signalized data such as images and characters are mutually transmitted in large amounts. It is supposed to be done. Inside the center system 2, a communication terminal 4 as a transmitting / receiving means is provided, and the communication terminal 4 and the ISDN line 1 are provided.
Are connected via the interface 5. Reference numeral 6 denotes a work processing terminal device for executing processing such as vehicle registration and search according to a built-in control program at any time, and a control processing unit 7 having a keyboard 7A as an input means on the front surface, and a CRT 8 for displaying processing contents as an image. And a hard disk device 9 which is a rewritable storage means for storing various databases of images and characters, and a video camera 10 which is an input means for taking in image data. Reference numeral 11 is a trackball for further improving operability, and 12 is a printer as a printing means, which is connected to the control processing unit 7 as necessary. Reference numeral 13 is a file server that processes various databases.
Similarly, the control processing unit 14 having a keyboard 14A as a control processing unit, a CRT 15, an external hard disk device 16 as a storage unit, a printer 17, and the like are provided. The file server 13 and the terminals 4 and 6 are L
The coaxial cables 18 are connected to each other via an interface board (not shown) for AN.

On the other hand, in each of the franchise stores 3 and 3A, reference numeral 21 is a processing terminal device composed of a general-purpose personal computer connected to the ISDN line 1 through an interface 22. As is well known, the processing terminal 21 is a control processing unit.
23, a CRT 24 and a keyboard 25 connected to the control processing unit 23. A video camera 26 is connected to the control processing unit 23 when registering a new vehicle. Similar to the business processing terminal 6, each processing terminal 21 is provided with a trackball 27, a hard disk device 28, and a printer 29, and a large-sized (29-inch or larger) TV monitor 30 to promote the store effect.
Is connected to the control processing unit 23. Further, a relay box 31 for automatically starting the processing terminal device 21 is provided between the interface 22 and the control processing unit 23.

FIG. 2 shows the overall configuration of the system in a simplified form for the sake of convenience. In FIG. 2, the coaxial cable 18 of the center system 2 has another hard disk device 32 shared by the control processing units 7 and 14. Are properly connected. Further, when displaying various search results to the customer on the side of the center system 2, the same TV monitor 30 as in the franchise stores 3 and 3A is installed. These tv monitors 30
Are connected to the control processing units 7 and 23 via the image display interface board 33. 34 is a video camera
An interface board for image input connected to 10.

Each hard disk device 9, 16, 28, 31
Transaction data storage unit 9A, 16A, 28A, 31A
And a master data storage unit 9B, 16B, 28B, 31B. The transaction data storage units 9A and 28A of the hard disk devices 9 and 28 connected to the processing terminals 6 and 21 have the video camera 1 when registering a new vehicle.
Image / character information from 0, 26 and keyboards 7A, 25 is read and updated as registration data at any time. Further, the transaction data storage units 16A and 31A connected to the file server 13 side are transaction data storage units 9A and 28A sucked up via the control processing unit 14.
The registration data of is temporarily stored. On the other hand, common master data is stored in each master data storage unit 9B, 16B, 28B, 31B by batch processing.

The control processing units 7 and 23 of the respective processing terminals 6 and 21 include a vehicle registration processing unit, a vehicle search processing unit, and a vehicle reservation / processing unit.
Processing routines such as sales / reservation cancellation means and vehicle information print processing means are provided. In addition to these processing routines, the transaction data storage units 9A, 28
Vehicle information transmission processing means for transmitting the registration data of A to the file server 13 side and vehicle information reception processing means for storing new master data in the master data storage units 9B, 28B are provided. On the other hand, in the control processing unit 14 of the file server 13, registered vehicle maintenance processing means for correcting / deleting the registered vehicle information, each franchise store 3, 3
Maintenance processing means for registering / correcting / deleting vendor information such as address and telephone number of A, and center business reception processing means for managing reservation / sales / reservation cancellation information of each control processing unit 7, 23 are provided and processed. Downloading means for sucking up registration data in the terminals 6, 21, vehicle information matching processing means for creating new master data based on the comparison result of the collected registration data and master data, and new master data Processing terminal 6,21
And vehicle information distribution processing means for sending the information to the other side.

Next, the operation of the above configuration will be described. During normal business hours, by activating the processing terminal 21 on the side of each franchise store 3, 3A,
Registration and search of incoming vehicles are executed in real time for each of the franchise stores 3 and 3A. For example, when registering the image / character information of the vehicle purchased at each of the franchise stores 3 and 3A as search data, first, the video camera 10
Is operated to capture the image information of the vehicle to be registered, and the vehicle information is captured as characters through the keyboard 25 and the trackball 27. The captured image / character information is stored and registered in the transaction data storage unit 28A of the hard disk device 28 by the vehicle registration processing means of the control processing unit 23, and at the same time, the printer 29 is used as a checklist.
Will be output.

On the other hand, in the case of searching for a vehicle, the master data storage section is executed via the vehicle search processing means of the control processing section 23.
The master data stored in 28B is read out, and as shown in FIG. 3, the image information of a plurality of vehicles is divided by the image information section 41 and displayed as a list on the television monitor 30. Since this list display is processed and executed without passing through the ISDN line 1, it is inexpensive and can be constantly displayed for store effect. Further, as shown in FIG. 4, the image of the target vehicle type and the character information indicating the distance traveled and the presence / absence of optional parts may be separately displayed in color on the TV monitor 30 by the image information unit 41 and the character information unit 42. it can. Further, the vehicle information printing processing means of the control processing unit 23 outputs necessary vehicle information via the printer 29, so that the customer can freely use the system.

Further, the vehicle reservation / sales of the control processing unit 23
Reservation cancellation means Based on the management means, when the reservation and sale of the vehicle stored in the master data are made for each franchise store 3, 3A, these data will be ISD for confirmation.
It is sent to the file server 13 via the N line 1. The file server 13 is reserved by each of the franchise stores 3 and 3A by the center job reception processing means of the control processing unit 14.
The sales information is written in real time to a file in a text format, managed while maintaining data consistency, and output from the printer 17 as LOG (recording) information. At this time, the center system 2 notifies the franchise stores 3 and 3A of the processing result, which can be immediately notified to the customer. It should be noted that the same procedure is used for canceling the reservation.

On the other hand, at a predetermined time, preferably at night after business hours, the master data stored in each master data storage unit 9B, 16B, 28B, 31B is updated according to the flowchart shown in FIG. Be seen. First,
In step S1, when the preset time at night is reached, the siphoning processing means causes the file server 13
A drive signal for starting the processing terminal 21 is output from the relay boxes 31 of the franchise stores 3 and 3A (step S2). Then, the process proceeds to step S3, and the file server 13 sucks up the registration data of the franchise stores 3 and 3A by the polling process via the ISDN line 1. At this time, the processing terminal 21 uses the vehicle information transmission processing means to process the transaction data storage unit 9
The registration data of A and 28A is transmitted to the file server 13 side. When the downloading of the registration data is completed, the processing terminal 21 is once powered off via the relay box 31 (step S4). The procedure of steps S1 to S4 described above is performed for each franchise store 3, 3A. The image and character information of each registration data collected in this way are separately stored in the transaction data storage units 16A and 31A.
When all the registration data are stored in the printer, the registration result of the registration data is output from the printer 17. Next, in step S5, the registration data stored in the transaction data storage units 16A and 31A and the master data storage units 16B and 31B are stored based on the vehicle information matching processing means in the control processing unit 14. It is compared with the master data. And
If the same vehicle information already exists in the master data, the data is corrected, and if the same vehicle information does not exist in the master data, it is processed as data registration.
The new master data thus obtained is stored in the master data storage units 16B and 31B of the hard disk devices 16 and 31 as common difference data. For each of the franchise stores 3 and 3A, after accessing the processing terminal 21 and reactivating the processing terminal 21 by the relay box 31 (steps S6 and S7), the master is set via the ISDN line 1. Data is sent (step S8), and the processing terminal 21 is powered off in step S9. The steps S6 and S9 are sequentially performed on the processing terminals 21 of all franchise stores 3 and 3A,
Finally, the master data is stored in the master data storage units 9B and 28B of the franchise stores 3 and 3A, respectively. Therefore, the next morning, when each processing terminal 21 is started up in each franchise store 3, 3A, a series of tasks such as vehicle search, reservation, and sales are performed without calling the center system 2 based on the common new master data. It becomes possible to do.

As described above, according to the above-mentioned embodiment, the night batch processing is performed by updating the image / character information of the new receiving vehicle on the side of each franchise store 3, 3A as the registration data in the hard disk device 28 at any time. The new master data created based on each registration data by the
Since it is sent to 3A, each franchise store 3,3A
It is possible to provide the customer with various kinds of vehicle information in real time based on the same master data stored in the hard disk device 28 without calling the center system 2 one by one. Therefore, the communication cost between the center system 2 and the franchise stores 3 and 3A can be suppressed only during nighttime batch processing, and even when a large amount of information such as images is handled for each franchise store 3 and 3A, the processing is simply performed. By introducing a general-purpose personal computer as the terminal device 21 to each of the franchise stores 3 and 3A, it becomes possible to easily construct a new system with a small amount of capital.

Furthermore, as an effect of the embodiment, a large television monitor provided in each franchise store 3, 3A.
With the 30, various kinds of information are intuitively transmitted through the eyes, so that the storefront effect becomes remarkable. Further, since the contents of the vehicle information registered in the other franchise stores 3 and 3A can be read out in real time from the hard disk device 28 when new master data is created, the inventory at each franchise store 3 and 3A can be read. It is possible to reduce risks and improve business performance by grouping franchise stores 3 and 3A. further,
Since the master data from the center system 2 can be freely used mainly by the franchise stores 3 and 3A side, restrictions on management are small, and data registration can be performed immediately.

The present invention is not limited to the above embodiment, and various modifications can be made within the scope of the present invention. For example, in the embodiment, the case where the present invention is applied to the search display system for selling used cars is shown, but the database is not limited to used cars, and the present invention is applied to all search processing systems such as business for the purpose of store effect. Can be applied. In addition, by increasing the number of database types, this system can be applied to diversified management such as clothes, sundries, furniture, and tourist information other than cars, while minimizing the burden on the franchise store side. further,
Not only the above ISDN line but also various communication means can be used between the terminals. Further, the storage means can be used in combination with a hard disk built in the control processing means, and in some cases, it can be appropriately changed to a rewritable one such as a CD-ROM.

[0019]

According to the present invention, input means, rewritable storage means provided for each terminal and having common master data and registration data updated at any time based on information from the input means, and a predetermined And a control processing unit for sucking up the registration data stored for each of the terminals at a time and transmitting new master data to each of the storage units based on a comparison result between the collected registration data and the master data. Therefore, it is possible to provide a database processing device capable of easily constructing a system with a small capital.

[Brief description of drawings]

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

FIG. 2 is a schematic configuration diagram of the same system.

FIG. 3 is a front view showing an example of display on the television monitor of the same.

FIG. 4 is a front view showing an example of a display on the television monitor of the same.

FIG. 5 is a flowchart showing a procedure when updating master data of the same.

[Explanation of symbols]

 2 Center system (terminal) 3,3A Franchise store (terminal) 7A, 25 Keyboard (input means) 10,26 Video camera (input means) 9,16,28,31 Hard disk device (storage means) 14 Control processing unit (control) Processing means)

Claims (1)

[Claims] 1. An input unit, a rewritable storage unit which is provided for each terminal and has common master data, and registration data which is updated at any time based on information from the input unit; A control processing unit for sucking up the registration data stored for each terminal and transmitting new master data to each of the storage units based on a result of comparison between the collected registration data and the master data. Database processing device.