JP2001318921A - Data base system and terminal equipment - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce server's processing load. SOLUTION: A server's computer 200 includes a data base storage part 220 for storing data. A terminal computer 300 connected to the computer 200 includes a storage part 320. A part or all of data included in a data base stored in the data base storage part 220 are stored in the storage part 320 as a data base. In the case of retrieving the data base by the computer 300, a processing part 310 in the computer 300 retrieves the data base stored in the storage part 320.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system and a terminal device for performing a predetermined operation on a database storing data.

[0002]

2. Description of the Related Art For example, a person who wants to sell real estate goes to a real estate agent or the like and presents information on the real estate to be sold to an intermediary such as a real estate agent to evaluate the desired selling price of the real estate. On the other hand, the intermediary presented the presented information of the real estate and the desired sale price, and the purchaser of the real estate looked at the information of the presented real estate and searched for the desired property.
In addition, the intermediary distributes the presented information of the real estate through newspaper advertisements and the like, and the purchaser looks at the advertisement to search for the desired property. The prospective buyer was then introduced to the prospective seller by an intermediary, and the purchase price of the real estate was determined by discussion between the prospective buyer and the prospective seller.

As described above, when purchasing a real estate, the purchaser first goes to an intermediary such as a real estate agent to search for the real estate, and then goes to the location of the real estate to examine the state of the real estate. . In addition, buyers went to buyers to negotiate the price of real estate. As described above, the purchaser repeatedly moves to purchase the real estate, which is very troublesome.

[0004] Therefore, for example, there is a system in which information of real estate obtained from a candidate for sale is accumulated in a server as a database, and a candidate for purchase obtains information of the desired real estate from a plurality of terminals connected to the server. Is being developed. In this case, the server includes operating means for performing a predetermined operation on the database. The operation means is, for example, a search means for searching the database for information on a predetermined real estate.

[0005] A purchaser accesses the server from one of the plurality of terminals, and retrieves information on desired real estate from the database. The server sends the search result to the terminal and outputs the search result at the terminal. The purchaser can check the output from the terminal and check the information of the desired real estate from the terminal.

[0006]

However, in the above system, when a plurality of purchasers access the server from each terminal almost simultaneously, and each purchaser searches for a desired real estate, Very heavy load on the server. Therefore, when a plurality of purchase applicants search at substantially the same time, it takes a very long time and sometimes it is not possible to search at substantially the same time. Further, when a terminal accesses a server via a communication line to perform a search, it may take a long time depending on the congestion of the communication line. Therefore, an object of the present invention is to provide a database system and a terminal device that can reduce the processing load on a server.

[0007]

In order to solve the above-mentioned problems, a database system according to the first aspect of the present invention provides a database storage medium for storing a database in which data is stored (for example, a database storage medium shown in FIG. 3). (E.g., the server computer 200 shown in FIG. 3) including the unit 220) and a terminal connected to the server (e.g., the terminal computer 300 shown in FIG. 3).
Means for storing a part or all of the data contained in the database stored in the database storage medium as a database in the storage medium (for example, processing unit 310 shown in FIGS. 3 and 5: step S15); Operation means for performing a predetermined operation on the database stored in the storage medium (for example, FIGS. 3, 11, and 1)
2, a processing unit 310 shown in FIG. 15: step S22, step S23, step S24, step S36, step S42, step S52, step S56), and the storage medium and the operation means are provided in the terminal. It is characterized by.

Here, the operating means includes means for displaying, printing, and outputting data contained in the database stored in the storage medium. The operation means also includes means for updating data included in the database stored in the storage medium.

As described above, according to the first aspect of the present invention, part or all of the data contained in the database stored in the database storage medium provided in the server is stored as a database in the storage medium of the terminal. Is done.
Then, a predetermined operation is performed on the database stored in the storage medium by the operation means. As described above, since the database is stored in the storage medium provided in the terminal, and the terminal performs a predetermined operation on the database, the processing load on the server is greatly reduced. That is, since the terminal stores the database in advance and operates the database at the terminal, for example, the terminal can operate the database without accessing the server via a communication line. it can. Therefore, a predetermined operation can be performed on the database in a very short time even if the communication line is congested. The operation of storing the database from the database storage medium to the storage medium can be performed more efficiently if executed when the communication line is not congested.

According to a second aspect of the present invention, in the database system according to the first aspect, the operating means includes:
It is characterized by having a search means (for example, the processing unit 310 shown in FIGS. 3 and 11: steps S22 and S23) for searching the database stored in the storage medium.

As described above, according to the second aspect of the invention, a part or all of the data contained in the database stored in the database storage medium provided in the server is stored as a database in the storage medium. . Then, the search unit searches the database stored in the storage medium. Since the storage medium and the search means are provided in the terminal, the searched database can be processed only by the terminal. For this reason, the number of times the terminal accesses the server becomes extremely small, and the processing load on the server is greatly reduced. Therefore, even when a plurality of terminals connected to the server perform a search at substantially the same time, the search processing is performed at each terminal, and the processing is not concentrated on the server. Time is reduced. Further, since the search processing is performed in each terminal, the server can direct the processing capacity to another processing, and the overall processing capacity is improved.

Since the terminal is provided with the search means, the terminal can perform the search without accessing the server through a communication line, for example. Therefore, the search can be performed in a very short time even if the communication line is congested.

According to a third aspect of the present invention, in the database system according to the first or second aspect, means for storing new data in the database storage medium as a part of the database (for example, FIG. The processing unit 210 shown in FIG. 3 is characterized by having a step S3).

As described above, according to the third aspect of the invention, the processing load on the server is greatly reduced as in the first aspect of the invention. Then, since the new data is stored in the database storage medium as a part of the database, the database stored in the database storage medium can be updated.

According to a fourth aspect of the present invention, there is provided the database system according to any one of the first to third aspects, wherein a part or all of the data contained in the database stored in the database storage medium is requested. Requesting means (for example, the processing unit 31 shown in FIGS. 3 and 5)
0: step S12) and means for storing only the data requested by the request means as a database in the storage medium (for example, the processing unit 3 shown in FIGS. 3 and 5)
10: step S15).

As described above, according to the fourth aspect of the invention, the processing load on the server is reduced as in the first aspect of the invention. At this time, a database used for an operation such as a search in the terminal is stored in the storage medium of the terminal as a database using a part or all of the data included in the database stored in the database storage medium. When a part of the data is stored in the storage medium of the terminal as a database, the operation cannot be performed on all of the database of the server, but since only the necessary data is stored in the storage medium of the terminal as the database, The operation can be sufficiently performed. Further, since a part of the data is stored as a database in the storage medium of the terminal, the capacity for storing the data is smaller than when all the data are stored. Further, since the process is performed on the database including a part of the data, the process related to the operation of the terminal is reduced. On the other hand, when all the data is stored as a database in the storage medium of the terminal, the processing load for storing the database in the storage medium is large, but the operation can be performed on all of the database of the server. in this way,
Data required for the operation can be changed flexibly according to the operation purpose.

According to a fifth aspect of the present invention, in the database system according to the fourth aspect, first creating means (for example, a diagram shown in FIG. 1) for creating a list of data included in the database stored in the storage medium. 3, a processing unit 310 shown in FIG. 12: step S36) and a second creating unit for creating a list of data requested by the requesting unit (for example, the processing unit 21 shown in FIGS. 3 and 12)
0: Step S35) and storing only the requested data as a database in the storage medium based on the list created by the first creating means and the list created by the second creating means. Means (processing unit 210, processing unit 310 shown in FIGS. 3 and 12: step S3)
7 to step S42).

As described above, according to the fifth aspect of the present invention, the processing load on the server is greatly reduced as in the first aspect of the present invention. Then, a list of databases stored in the storage medium of the terminal is created, the server creates a list of databases requested by the terminal, and only the requested data based on these two lists is stored in the database of the server. It is stored as a database from the medium to the storage medium of the terminal. For this reason, these two lists are compared, and only the difference data is stored in the storage medium. Therefore, the database stored in the storage medium can be updated. In this case, the load on the process of storing the database on the storage medium of the terminal and the process of updating the database stored on the storage medium of the terminal are reduced.

According to a sixth aspect of the present invention, in the database system according to the fifth aspect, the list created by the first creating means is compared with the list created by the second creating means. Only the data that is in the list created by the second creating means and that is not in the list created by the first creating means is stored in the storage medium as a part of the database stored in the storage medium. It is characterized by including means for additionally storing (for example, the processing unit 210 and the processing unit 310 shown in FIGS. 3 and 12: step S38, step S39, and step S42).

As described above, according to the sixth aspect of the present invention, the list of the database stored in the storage medium of the terminal is compared with the list of the requested data to determine the requested data. Only data that is in the list and not in the list of databases stored in the storage medium of the terminal is additionally stored in the storage medium of the terminal as a part of the database, so that the database stored in the storage medium can be updated. . In this case, since additional storage is performed, processing related to updating the database stored in the storage medium is greatly reduced.

According to a seventh aspect of the present invention, in the database system according to the fifth or sixth aspect, the list created by the first creating means is compared with the list created by the second creating means. Means for deleting data from the database stored in the storage medium, the data being in the list created by the first creating means and not being in the list created by the second creating means (for example, , Processing unit 210 and processing unit 31 shown in FIGS.
0: Step S38, Step S40, Step S4
2).

As described above, according to the seventh aspect of the present invention, the list of the requested data is compared with the list of the database stored in the storage medium of the terminal. The data stored in the storage medium of the terminal is deleted from the database stored in the storage medium of the terminal, and the database stored in the storage medium of the terminal can be updated. In this case, processing related to updating the database stored in the storage medium is greatly reduced.

[0023] According to an eighth aspect of the present invention, in the database system according to any one of the fifth to seventh aspects, the list created by the first creating means and the second creating means is: This is a list in which the data ID of the database is associated with the data relating to the update date when the data corresponding to the data ID is updated, and the same data in the list created by the first creation means and the second creation means Regarding the ID, the update date of the list created by the first creation unit and the update date of the list created by the second creation unit are compared, and the update date of the list created by the second creation unit is changed by the first creation unit. When the created list is newer than the update date, means for replacing the data relating to the data ID as a part of the database stored in the storage medium (for example, FIGS. 3 and 12) Processing unit 210 illustrated, processing section 310:
(S38, S41, S42). The data ID is
For example, an identifier of a group of data in a database.

As described above, according to the eighth aspect of the invention, the processing load on the server is greatly reduced as in the first aspect of the invention. Further, in order to replace old data with new data in the database stored in the storage medium of the terminal, the data stored in the storage medium can be updated.

According to a ninth aspect of the present invention, there is provided a server (for example, for a server shown in FIG. 3) having a database storage medium (for example, a database storage unit 220 shown in FIG. 3) for storing a database in which data is stored. The terminal device (for example, the terminal computer 300 shown in FIG. 3) connected to the computer 200) includes a storage medium (for example, the storage unit 320 shown in FIG. 3) and a database stored in the database storage medium. Means for storing a part or all of the included data as a database in the storage medium (for example, processing unit 310 shown in FIGS. 3 and 5: step S15); Operation means for performing a predetermined operation (for example, the processing unit 310 shown in FIG. 3, FIG. 11, FIG. 12, and FIG. S22, step S23, step S24, step S36, step S42, step S
52, step S56). Here, the operation means includes means for displaying, printing, and outputting data included in the database stored in the storage medium. The operation means also includes means for updating data included in the database stored in the storage medium.

As described above, according to the ninth aspect of the present invention, a part or all of the data included in the database stored in the database storage medium provided in the server is stored in the storage medium of the terminal device as a database. It is memorized. Then, a predetermined operation is performed on the database stored in the storage medium by the operation means. in this way,
Since the database is stored in the storage medium provided in the terminal and the terminal device operates on the database, the processing load on the server is greatly reduced. That is, since the database is stored in the terminal device in advance and the database is operated at the terminal, for example, the database can be operated at the terminal device without accessing the server via a communication line. be able to. Therefore, a predetermined operation can be performed on the database in a very short time even if the communication line is congested.

The invention according to claim 10 is the same as the invention according to claim 9.
In the terminal device described above, the operation unit is a search unit that searches a database stored in the storage medium (for example, the processing unit 310 illustrated in FIGS. 3 and 5: step S22,
Step S23).

As described above, according to the tenth aspect of the present invention, the terminal device connected to the server stores a part or all of the database stored in the database storage medium of the server, and Since the stored database is searched, the processing load on the server is greatly reduced. Therefore, even if a plurality of terminal devices connected to the server search almost simultaneously, the search process is performed in each terminal device, so that the time required for the search is shorter than when the search process is performed in the server. Further, since the search processing is performed in each terminal device, the server can direct the processing capacity to another processing, and the overall processing capacity is improved.

Further, the invention described in claim 11 is the same as the ninth invention.
Or the requesting means for requesting a part or all of the data contained in the database stored in the database storage means (for example,
The processing unit 310 shown in FIGS. 3 and 5: step S12) is characterized in that only the data requested by the requesting means is stored in the storage medium as a database.

As described above, according to the eleventh aspect of the present invention, the processing load on the server is greatly reduced, as in the ninth aspect of the present invention. At this time, a database used for searching in the terminal device is stored in the storage medium of the terminal device as a database using a part or all of the data included in the database stored in the database storage medium. When some data is stored as a database in the storage medium of the terminal device, it is not possible to search the entire database of the server, but since only necessary data is stored in the storage medium of the terminal device as a database, The search can be performed sufficiently. Furthermore,
Since part of the data is stored as a database in the storage medium of the terminal device, the capacity for storing the data is smaller than when all the data is stored. Further, since the search is performed from the database including a part of the data, the processing related to the search of the terminal device is reduced.

[0031]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Preferred embodiments of the present invention will be described with reference to the drawings. In the following, the present invention is applied to a system for performing a predetermined operation on a database in which data on real estate such as the location of the real estate is stored. It should be noted that the present invention may be applied to a case where a predetermined operation is performed on a database in which data other than data relating to real estate is stored. FIG. 1 shows a block diagram of the configuration of the system of the present embodiment. As shown in FIG. 1, the system stores a database in which data is stored, and performs a server computer 100 for mainly performing various processing such as communication processing and data processing.
It comprises terminal computers 110-1 to 110-n connected to the server computer 100 via the communication network 120. Here, in FIG. 1, since there are four terminal computers 110, n is 4, but n is an integer value corresponding to the number of terminal computers.

The communication network 120 is an electric communication line such as the Internet, satellite communication, a dedicated communication line, or a public telephone line. Terminal computers 110-1 to 110-
n is installed mainly in a real estate store, a property broker, a real estate advertising store, etc., but may be a portable terminal that can be carried around. The terminal computer 110-
1 to 110-n may be general household personal computers, for example, a server computer 1 via a public telephone line using a communication device such as a modem or DSU.
00 may be connected to a personal computer. Also, the terminal computers 110-1 to 110-
n may be connected to the server computer 110 via the Internet by connecting to the Internet server using a communication device such as a modem or DSU.
The terminal computers 110-1 to 110-n may be portable communication devices such as mobile phones and pocket computers.

In this embodiment, the terminal computer 11
0-1 to 110-n are mainly the server computer 1
Computer 1 with a communication device for connecting to
11. The computer 111 is connected to an image input device 112 such as a scanner, and is configured to input an image of real estate as digital data by the image input device 112. Note that the image input device 112 may directly input a digital image obtained by a digital camera or the like, or may be an imaging device such as an artificial retinal camera or a CCD camera. Also, the computers 110-1 to 110-1
110-n has a printing device, a display device, and the like, and can print and display various data.
The terminal computers 110-1 to 110-n are:
An input device such as a keyboard is provided so that various data can be input and data can be updated.

In the present embodiment, the above-described configuration is used. Using the above-mentioned system, a person who wants to sell real estate provides information on the real estate he wants to sell, and a person who wants to purchase obtains information about the desired real estate. I do. The flow of the system according to the present embodiment will be described with reference to FIG. That is, the applicants for selling real estate are terminal computers 110-1 to 110-.
n, the property owner, the picture of the property to be sold, the location of the property, the area of land,
Real estate data such as a desired sale price is input (step S1).

Then, the server computer 100
The real estate data input from the terminal computer is received via the communication network 120 (step S2). The server computer 100 stores the data as real estate data. The server computer 100 accumulates a part of the database every time real estate data is input from the terminal computer, and creates a database (step S3).

On the other hand, the purchaser of the real estate uses one of the terminal computers 110-1 to 110-n to obtain desired real estate information from the stored database (step S4).

Next, FIG. 3 shows an example of a functional block diagram of the present embodiment. The functional block includes a server computer 200 and a terminal computer 300 connected to the server computer 200.

The server computer 200 accumulates real estate data received from the terminal computer 300 described later as a part of the database, and corresponds to the server computer 100 shown in FIG.

The terminal computer 300 inputs real estate data, changes and inputs real estate data, and transmits the data to the server computer 200. The terminal computer 300 is used to search for a desired real estate from a database in which real estate data is stored, and to output real estate data. The terminal computer 300 corresponds to the terminal computers 110-1 to 110-n shown in FIG. The terminal computer 300 is
Terminal computers 110-1 to 110-n shown in FIG.
Are connected to the server computer, but only one terminal computer 300 is shown for the sake of simplicity.

The server computer 200 includes a processing unit 2
10, the database storage unit 220, and the information storage medium 2
30. The processing unit 210 performs various processes, such as a process of creating a database, a process of changing the database, and a process of transmitting and receiving data to and from the terminal computer 300, based on various programs stored in the information storage medium 230. , The function of the processing unit 210 is CISC
Type, RISC type CPU, DSP, image capture IC,
It is realized by hardware such as a communication dedicated IC. The database storage unit 220 stores the real estate data received from the terminal computer 300 as a database by the processing of the processing unit 210. The functions of the database storage unit 220 are IC card, MO, F
It can be realized by a storage medium such as D, DVD, hard disk, and memory. The information storage medium 230 stores various programs for the processing unit 210 to perform various processes. The function of the information storage medium 230 can be realized by hardware such as an IC card, MO, FD, DVD, CD, hard disk, and memory.

The terminal computer 300 includes a processing unit 31
0, storage unit 320, input unit 330, and output unit 340.
And an information storage medium 350. The processing unit 310 performs processing for inputting real estate data based on various programs stored in the information storage medium 350, and the storage unit 32
0, a process related to searching the database stored in the storage unit 320, a process of transmitting / receiving data to / from the server computer 200, a setting process for outputting real estate data, etc. The processing is performed. The function of the processing unit 310 is C
It is realized by hardware such as an ISC type or RISC type CPU, DSP, image capture IC, and communication IC. The input unit 330 is for inputting real estate data, changing real estate data, inputting search conditions for searching, and the like. The function of the input unit 330 is a keyboard, a mouse, a scanner, a digital It is realized by hardware such as a camera and a touch panel. The processing unit 310 performs various processes on the data input from the input unit 330. The output unit 340 outputs real estate data based on the processing of the processing unit 310. The function of the output unit 340 is mainly realized by functions of a CRT, an LCD, a printing device, a touch panel, and the like. The storage unit 320 is stored in the database storage unit 220 by the processing of the processing unit 210 and the processing unit 310.
In this case, some or all of the data included in the database stored in is stored as a database. The functions of the storage unit 320 are IC card, MO, FD, DV
D, a hard disk, and a storage medium such as a memory. The information storage medium 350 stores a program for the processing unit 310 to perform various processes.
The functions of the information storage medium 350 are IC card, MO, F
It can be realized by hardware such as D, DVD, CD, hard disk, and memory. The condition storage unit 360 stores conditions of data to be stored in the storage unit 320 when data is stored in the storage unit 320 from the database storage unit 220 in a process described below. The condition storage unit 360 can be realized by hardware such as a RAM.

First, the processing of accumulating real estate data and creating a database in steps S1 to S3 of the flowchart shown in FIG. 2 will be described.

Real estate data is input from the input section 330 by the operation of the sale applicant (step S1). The processing section 310 performs processing for transmitting the real estate data input from the input section 330 to the server computer 200 based on the program stored in the information storage medium 350. The real estate data transmitted from the terminal computer 300 is received by the server computer 200 (step S2).

Processing unit 21 of server computer 200
0 is the information storage medium 23 of the server computer 200
Based on the program stored in “0”, a process for storing the real estate data received from the terminal computer 300 in the database storage unit 220 as a part of the database is performed. Further, the processing unit 210 performs processing for accumulating the data as a database and storing the data in the database storage unit 220 every time the real estate data is stored as described above. That is, when new real estate data is received from the terminal computer 300, the processing unit 210 causes the database storage unit 220 to store the new data as part of the database. When the data of each real estate included in the database is changed or new real estate data is input, a process of adding an update date (input date) to the real estate data is performed. As described above, a database is created in the database storage unit 220 by adding real estate data to the database storage unit 220 or changing the database stored in the database storage unit 220 (step S3).

Real estate data includes, for example, real estate owner, real estate price, real estate land and building type, real estate location, real estate location, real estate location along and nearest station, real estate deposit, real estate deposit Key money, real estate deposit, real estate land area, real estate driveway burden, real estate floor area, real estate balcony area, real estate floor unit price, real estate building rate, real estate floor area ratio, real estate management expenses, real estate construction The number of years, the number of rooms of the real estate, the number of floors of the real estate, the layout of the real estate, the appearance of the real estate, the inside view of the real estate, the date of registering the data, the date of updating the data, and the like.

FIG. 4 shows an example of the database 222 stored in the database storage unit 220.
That is, the processing unit 210 associates the real estate ID with the real estate data received from the terminal computer 300. This real estate ID is assigned a different real estate ID each time property data is input from the terminal computer 300. That is, the real estate ID is an identifier of a group of real estate data transmitted from the terminal computer 300. For example, as shown in FIG. 4, the data of the real estate with “ID0” is “P1 prefecture”, the city is “C1 city”, the nearest station is “S1 station”, Along the R1 line, the exterior photo is "D1", the type of real estate is "Apartment", the type of rental or sale is "Rent", and the price is "1".
0,000 yen "and the data update date is" April 8, 2000 ".

Next, in step S4 of the flowchart shown in FIG.
A process performed by the above system to obtain real estate information from 0 will be described. In the present embodiment, the database 222 stored in the database storage unit 220
The purchaser does not obtain the data of the desired real estate from the user. For example, the database 22 is stored in the storage unit 320 of the terminal computer 300 by an operation of a system administrator or the like.
A part or all of the data of 2 is stored as a database, and desired data can be obtained from the database stored in the storage unit 320 by the operation of the purchaser.

First, a process for storing part or all of the data of the database 222 stored in the database storage unit 220 in the storage unit 320 will be described with reference to FIG. A data condition required by the system administrator or the like is input from the input unit 330. FIG. 6 shows a system administrator who inputs necessary data conditions.
13 shows an example of a screen output to the output unit 340. The system administrator inputs necessary data conditions according to this screen (step S11).

Then, the processing section 310 controls the information storage medium 3
The conditions are transmitted to server computer 200 based on the program stored in 50. Also, the processing unit 310
Causes the condition storage unit 360 to store the condition (step S12). When the server computer 200 receives the condition, the processing unit 21 of the server computer 200
0 extracts only data that meets the above conditions from the database 222 based on the program stored in the information storage medium 230 (step S13). And the processing unit 21
0 transmits only data that meets the above conditions to the terminal computer 300 (step S14). When the terminal computer 300 receives the data that satisfies the condition, the processing unit 310 causes the storage unit 320 to store the data that satisfies the condition as a database (step S1).
5). Here, for example, when the condition is “the location of the prefecture is P1 prefecture”, only the data of the real estate in which the “location of the prefecture” is “P1” is stored in the storage unit 320 as a database. It is memorized. Of course, if the condition is “all data” (for example, FIG.
"Not specified"), all the data of the database 222 stored in the database storage unit 220 is stored in the storage unit 320 as a database. Note that the processing unit 210 is different from the database storage unit 220 to the storage unit 320.
The terminal calculates the time required to transfer the data to the terminal computer 300 and outputs the time from the output unit 340. In addition, for example, it is "C1 city", or
A condition can be input as an OR condition of “C2 city”, for example, “C1 city”
A condition can also be input as an AND condition of “20 million yen to 80 million yen”.

As described above, the database 222 is stored in the database storage unit 220,
Is stored in the storage unit 320.
Is stored.

On the other hand, the purchaser can use the terminal computer 300 to search for data. That is, the data search is performed on the database stored in the storage unit 320. For data search,
This will be described with reference to FIGS. The search condition is input from the input unit 330 by the operation of the purchase applicant (step S21). 7 to 9 show examples of screens output to the output unit 340 in order to input search conditions for a purchaser. FIG. 7 shows an example of a screen output for inputting the city, ward, town and village of the real estate as a search condition. FIG. 8 shows an example of a screen output for inputting a type of real estate, a type such as rent or sale as a search condition. FIG. 9 shows an example of a screen output for inputting the price of a real estate as a search condition. The purchaser inputs necessary data conditions according to this screen. In addition, for example, it is "C1 city",
Alternatively, a search condition can be input as an OR condition of “C2 city”. For example, a search condition can be entered as an AND condition of “C1 city” and “20 million to 80 million yen”. Can also be entered.
In addition, the location of the real estate, the location of the real estate along the nearest station, the real estate security deposit, the real estate key money, the real estate security deposit, the real estate land area, the real estate private road burden, the real estate total floor area, the real estate balcony area, the real estate The search condition may be a unit price per tsubo, a real estate building ratio, a real estate floor area ratio, a real estate management cost, a real estate building age, a real estate room number, a real estate floor number, a real estate floor plan, and the like.

Based on the program stored in the information storage medium 350 and the search condition, the processing unit 310 of the terminal computer 300 searches for a real estate matching the search condition from a database stored in the storage unit 320. A process for searching for data is performed (step S22). Then, based on the program stored in the information storage horse 350, the processing unit 310 extracts real estate data that meets the above search condition from the database stored in the storage unit 320 (step S23), and the extracted data is extracted. A process of outputting the output data via the output unit 340 is performed (step S24). Here, for example, when the item of the search condition “City” is “C1 city”, the output unit 340 outputs only the data of the real estate whose “City” is “C1 city”. Output via For example, as shown in FIG. 10, a list screen of real estate that matches the search condition is output to the output unit 340. The appearance image of the property is iconified and displayed for each real estate, and the location, price, land area, building coverage and floor area ratio of the property are displayed. Then, the purchaser selects a desired real estate via the input unit 330 based on the list screen, and further outputs data relating to the selected real estate to the output unit 340.

As described above, in this embodiment, real estate data is input from the terminal computer 300, and the real estate data input from the terminal computer 300 is
Database storage unit 22 of server computer 200
0 is stored as a database. Then, part or all of the data stored in the database storage unit 220 is stored in the storage unit 320 of the terminal computer 300 as a database.

On the other hand, in this embodiment, when a purchaser searches for desired data from the database using the terminal computer 300, the processing unit 310 of the terminal computer 300 stores the data in the database stored in the storage unit 320. Search from. Therefore, even when a plurality of terminal computers 300 connected to the server computer 200 search at substantially the same time, the processing load on the server computer 200 is greatly reduced because each terminal computer 300 performs the search processing. You. Therefore, the server computer 200 can focus its processing capacity on the process of receiving the real estate data from the terminal computer 300 and the like, and the overall processing capacity is improved.

By the way, the server computer 20
0 are connected to a plurality of terminal computers 300.
For this reason, new real estate data is input from another terminal computer, or real estate data is changed from the terminal computer, and the database is changed. In this case, the database stored in the database storage unit 220 of the server computer 200 is updated. Accordingly, the terminal computer 300
The database stored in the storage unit 320 must also be updated. The feature of this embodiment is that the storage unit 320
In the process of updating the database stored in the database.

The process of updating the database stored in the storage section 320 will be described with reference to FIG. Similar to the process for storing part or all of the data of the database stored in the database storage unit 220 in the storage unit 320, necessary data conditions are input (step S31). Then, the processing unit 310 transmits the condition to the server computer 200 based on the program stored in the information storage medium 350 (Step S34). In this case, for example, when a predetermined time has elapsed and no condition has been input (step S32: No),
The processing unit 310 may read the condition from the condition storage unit 360 (Step S33) and transmit the condition to the server computer 200 (Step S34).

When the server computer 200 receives the condition, the processing unit 210 associates the real estate ID of the real estate data including the condition with the data update date from the database storage unit 220 based on the program stored in the information storage medium 230. The attached data table 224 (shown in FIG. 13) is created (step S35).

On the other hand, when the system administrator inputs necessary data conditions, the processing unit 310 of the terminal computer 300 checks the database currently stored in the storage unit 320 for the real estate ID, the data update date, and the like. Is created (step S36). Then, the processing unit 310 stores the data table 324 in the server computer 200.
(Step S37). When the condition is transmitted from the terminal computer 300 to the server computer 200, the data table 324 may be transmitted to the server computer.

When server computer 200 receives data table 324, server computer 200
The processing unit 210 reads only the real estate data corresponding to the real estate ID included in the data table 224 from the database storage unit 220 based on the data table 224 and the data table 324, and transmits only this data to the terminal computer 300. . That is, the processing unit 210 compares the data table 224 and the data table 324 (step S38), and only the data of the real estate corresponding to the real estate ID in the data table 224 and not in the data table 324 is stored in the terminal computer 300.
(Step S39). Then, the processing unit 310 of the terminal computer 300 additionally stores the transmitted real estate data as a part of the database in the storage unit 320 (step S40). For example, as shown in FIG. 13 and FIG.
5 ", but the data table 324 does not have" ID5 ". Therefore, the data of the real estate of “ID5” is read from the database storage unit 220 and stored in the storage unit 320 as a part of the database.

On the other hand, the processing unit 310
The real estate ID in the terminal computer 300 is transmitted to the terminal computer 300 (step S41). Then, the processing unit 310 deletes the real estate data corresponding to the transmitted real estate ID from the database stored in the storage unit 320 (step S4).
2). For example, as shown in FIGS. 13 and 14, the data table 324 has “ID4”, but the data table 224 does not have “ID4”. Therefore, "ID
The real estate data of the real estate No. 4 is deleted from the database stored in the storage unit 320.

On the other hand, even if the data table 224 and the data table 324 are the data of the real estate of the real estate ID, if the data update date of the data table 224 is newer than that of the data table 324, the real estate I
D for the real estate data corresponding to the terminal computer 30
0 (step S43). Then, the transmitted real estate data is updated in the recording unit 320 as a part of the database. For example, as shown in FIGS. 13 and 14, the data whose real estate data is “ID3” is included in both the data tables 224 and 324, but the data update date of the data table 224 is newer than that of the data table 324. Therefore, "ID3"
Of real estate corresponding to the terminal computer 300
And then the data is updated.

As described above, the database stored in the storage section 320 is updated (step S4).
4).

As described above, since only data that is not included in the database stored in the storage unit 320 is additionally stored, processing related to updating the database stored in the storage unit 320 is greatly reduced. You. Also, the data table 324 and the data table 224
The database stored in the storage unit 320 can be updated to delete the real estate data corresponding to the real estate ID that does not exist. In this case, once the entire database stored in the storage unit 320 is deleted and all the data of the real estate with the real estate ID included in the data table 224 is stored in the storage unit 320, the database of the storage unit 320 is updated. Also, the processing related to updating is greatly reduced.

Next, a predetermined operation on the database stored in the storage section 320 of the terminal computer 300 will be described with reference to FIG. The system administrator or the purchaser inputs the real estate ID of the real estate data to be obtained via the input unit 330 (step S5).
1). The processing unit 310 performs processing for extracting data corresponding to the real estate ID input from the input unit 330 from the database of the storage unit 320 and displaying the data via the output unit 340 (step S52). The system administrator or the purchaser checks the data displayed from the output unit 340, and if there is unnecessary real estate data in the data (Step S53: Yes), inputs the real estate ID of the data (Step S53). S54). On the other hand, if there is no unnecessary real estate data (step S53: Yes) and the printing is to be performed (step S55: Yes), the purchaser inputs a print signal via the input unit 330. The processing unit 310 performs a process of printing the real estate data from the output unit 340 based on the print signal (step S56). When displaying real estate data, a search may be performed as shown in FIG. 11 and then real estate data matching the search condition may be displayed.

Next, an example of a hardware configuration capable of realizing the present embodiment will be described with reference to FIGS. The apparatus shown in FIG. 16 is an example of the configuration of the server computer 100 shown in FIG.
M402, RAM 403, information storage medium 409, image generation IC 410, I / O ports 411, 412, 413,
414 are connected to each other via a system bus 415 so that data can be input and output. The display 404 is connected to the image generation IC 410, and the I / O port 411
Is connected to the communication device 405, the I / O port 412 is connected to the input device 406, the I / O port 413 is connected to the image input device 407, and the I / O port 414 is connected to the printing device 408. Have been.

The information storage medium 409 mainly stores programs and the like.
Equivalent to 30. When the information storage medium 409 is portable, an IC card, MO, F
D, DVD, etc. On the other hand, when the information storage medium 409 is not portable, such as a hard disk or a memory, it may correspond to the RAM 403 or the ROM 402.

The input device 406 mainly corresponds to a keyboard, a mouse and the like. By operating the input device 406, real estate data can be input from the server computer. The image input device 407 has an image input function such as a scanner or a digital camera. By operating the image input device 407, an external view or an inside view of the real estate as real estate data can be input from the server computer.

The communication device 405 exchanges various kinds of information used inside the device with the outside. The communication device 405 is a terminal computer 110- shown in FIG.
1 to 110-n for transmitting and receiving predetermined information corresponding to a program or the like.

According to a program stored in the information storage medium 409 or the ROM 402, a signal input from the input device 406, information received from the communication device 407, etc.
U401 controls the entire apparatus and performs various arithmetic processing. RA
M403 is storage means used as a work area of the CPU 401, information received from the communication device 405, predetermined contents of the information storage medium 409 and the ROM 402,
Alternatively, the calculation result of the CPU 401 is stored. That is,
The database stored in the database storage unit 220 is stored in the RAM 403. The data tables 224 and 324 shown in FIGS.
It is temporarily stored in the AM 403.

Further, the image generation IC 410 includes the RAM 40
3, an integrated circuit that generates pixel information to be output to the display 404 based on image information sent from the ROM 402, the information storage medium 129, and the like. The display 404 is intended to include a display device such as a CRT, an LCD, a TV, a plasma display, and a projector.
The printing device 408 is realized by a printing function of a printer or the like.
A predetermined content is printed based on information stored in the AM 403 or the ROM 402. The screens shown in FIGS. 6 to 10 are mainly displayed on the display 50 of the terminal computer.
4 (shown in FIG. 17), but may be output to the display 404. Further, the above-described screen may be output by printing by the printing apparatus 408.

The device shown in FIG. 16 is an example of the configuration of the terminal computers 110-1 to 110-n shown in FIG. 1, and includes a CPU 501, a ROM 502, a RAM 503, an information storage medium 509, an image generation IC 510, and an I / O port. 5
11, 512, 513, and 514 are connected to the system bus 515.
Are connected so that data can be input and output to and from each other. The display 504 is connected to the image generation IC 510, the communication device 505 is connected to the I / O port 511, the input device 506 is connected to the I / O port 512, and the image input device is connected to the I / O port 513. 507 is connected, and the printing device 508 is connected to the I / O port 514.

The information storage medium 509 mainly stores programs and the like.
Equivalent to 50. That is, as described above, a program for searching in the terminal computer is stored in the information storage medium 509. When the information storage medium 509 is portable, it is an IC card, MO, FD, DVD, or the like. On the other hand, when the information storage medium 509 is not portable, such as a hard disk or a memory, the RAM 503 or the ROM
It may correspond to 502.

The communication device 505 exchanges various information used inside the device with the outside.
And transmits / receives predetermined information corresponding to a program or the like. Input device 506
Is mainly equivalent to a keyboard, a mouse, a touch panel, etc., and realizes the function of the input unit 330 shown in FIG. Also, the image input device 5
Reference numeral 07 denotes an image input function such as a scanner or a digital camera, and the function of the input unit 330 shown in FIG.

The CPU 501 controls the entire apparatus in accordance with information input from the information storage medium 509, information input from the image input device 507, signals input from the input device 506, information received from the communication device 505, and the like. And various data processing. The RAM 503 includes the CPU 5
01, which stores information received from the communication device 505, information input from the image input device 507, predetermined contents of the ROM 502, calculation results of the CPU 501, and the like. That is, the database stored in the storage unit 320 shown in FIG.
Stored in the AM 503. The data table 324 shown in FIG. 14 is temporarily stored in the RAM 503.
The conditions stored in condition storage section 360 shown in FIG. 3 are temporarily stored in RAM 503.

Further, this apparatus includes an image generation IC 510
Are provided so that a suitable image output can be performed. The image generation IC 510 includes a RAM 503, a ROM
An integrated circuit that generates pixel information to be output to the display 504 based on image information sent from the communication device 502 or image information sent from the communication device 505. The display 404 is intended to include a display device such as a CRT, an LCD, a TV, a plasma display, and a projector.

The printing device 508 is realized by a printing function of a printer or the like, and prints predetermined contents based on information received by the communication device 505 and information stored in the RAM 503 or the ROM 502. In addition, FIG.
The screen in FIG. 10 is mainly output visually on the display 504, but may be output by printing the above-described screen by the printing apparatus 508, for example.

The present invention is not limited to the above embodiment, and various improvements and design changes may be made without departing from the spirit of the present invention. For example, in other systems, a terminal computer is connected to a server computer, and the present invention can be applied to a database search system in which a database is searched using the terminal computer.

Further, in order to store data as a database in the database storage unit 220, real estate data is input using the terminal computer 300, but real estate data may be input from the server computer 200. In this case, the server computer 20 shown in FIG.
0 is configured to include the functions of the input unit and the output unit as in the terminal computer 300.

Further, the search process of the terminal computer 300 is a process of searching for real estate data that matches the search conditions. For example, a tree structure search process of searching a tree structure database may be used. Then, an index search process for creating an index from the database and performing a search based on the index may be performed.

Further, the terminal computer 300 is stored in the database storage section 220 of the server computer 200.
Although the system administrator inputs the conditions when storing the database in the storage unit 320, the terminal computer 300 may automatically store data from the server computer 200. In this case, the processing unit 31
0 reads the condition of the database to be stored in the storage unit 320 from the condition storage unit 360, and transmits the condition to the server computer 200. Based on the condition, the processing unit 210 of the server computer 200 stores the data of the real estate meeting the condition in the database storage unit 220.
And sends it to the terminal computer 300.

Further, when printing (outputting) an external photograph or price as real estate data from the output unit 340 of the terminal computer 300, it may be printed as a flyer format for advertisement.

[0082]

According to the first aspect of the present invention, the terminal is provided with the storage medium for storing the database stored in the server and the operation means for operating the database stored in the storage medium. Thus, the processing load on the server is greatly reduced. That is, since the terminal stores the database in advance and operates the database at the terminal, for example, the terminal can operate the database without accessing the server via a communication line. it can. Therefore, a predetermined operation can be performed on the database in a very short time even if the communication line is congested.

According to the second aspect of the present invention, since the storage medium and the search means are provided in the terminal, the processing load on the server is greatly reduced. Therefore, when a plurality of terminals connected to the server perform a search at substantially the same time, the search processing is performed at each terminal, so that the time required for the search is shorter than when the search processing is performed at the server. Further, since the search processing is performed in each terminal, the server can direct the processing capacity to another processing, and the overall processing capacity is improved.

According to the third aspect of the invention, similarly to the first aspect of the invention, the processing load on the server is greatly reduced. Then, since the new data is stored in the database storage medium as a part of the database, the database stored in the database storage medium can be updated.

According to the fourth aspect of the invention, the processing load on the server is reduced as in the first aspect of the invention. At this time, the database used for the operation in the terminal is stored in the storage medium of the terminal as a part or all of the data included in the database stored in the database storage medium. If some data is stored as a database in the storage medium of the terminal, operations cannot be performed on the database of the server, but since only necessary data is stored in the storage medium of the terminal as a database, sufficient Operation can be performed.

According to the fifth aspect of the present invention, the processing load on the server is greatly reduced as in the first aspect of the present invention. Then, the server compares the list of databases stored in the storage medium of the terminal with the list of databases requested by the terminal, and stores only difference data in the storage medium. Therefore, the database stored in the storage medium can be updated. In this case, the load on the process of storing the database on the storage medium of the terminal and the process of updating the database stored on the storage medium of the terminal are reduced.

According to the sixth aspect of the invention, the processing load on the server is greatly reduced as in the first aspect of the invention. The list of databases stored in the storage medium of the terminal is compared with the list of requested data, and the list of requested data is included in the list of databases stored in the storage medium of the terminal. Since only the missing data is additionally stored in the storage medium of the terminal as a part of the database, the database stored in the storage medium can be updated. In this case, since additional storage is performed, processing related to updating the database stored in the storage medium is greatly reduced.

According to the seventh aspect of the present invention, the processing load on the server is greatly reduced as in the first aspect of the present invention. The list of databases stored in the storage medium of the terminal is compared with the list of requested data, and the list of requested data is not included in the list of data stored in the list of databases stored in the storage medium of the terminal. Since the data is deleted from the database stored in the storage medium of the terminal, the database stored in the storage medium can be updated. In this case, processing related to updating the database stored in the storage medium is greatly reduced.

According to the eighth aspect of the present invention, the processing load on the server is greatly reduced as in the first aspect of the present invention. Further, old data can be updated to new data in the database stored in the storage medium of the terminal.

According to the ninth aspect of the present invention, the terminal device includes the storage medium for storing the database stored in the server and the operating means for operating the database stored in the storage medium. Processing load is greatly reduced. That is, since the database is stored in the terminal device in advance and the database is operated at the terminal, for example, the database can be operated at the terminal device without accessing the server via a communication line. be able to. Therefore, even when the communication line is congested, a predetermined operation can be performed on the database in a very short time.

According to the tenth aspect, the terminal device connected to the server stores part or all of the database stored in the database storage medium of the server and searches the database stored by the terminal device. Therefore, the processing load on the server is greatly reduced. Therefore, even if a plurality of terminal devices connected to the server search almost simultaneously, the search process is performed in each terminal device, so that the time required for the search is shorter than when the search process is performed in the server. Further, since the search processing is performed in each terminal device, the server can direct the processing capacity to other processing, and the overall processing capacity is improved. Since the terminal device is provided with the search means, the search can be performed in the terminal device without accessing the server via a communication line, for example. Therefore, the search can be performed in a very short time even if the communication line is congested.

According to the eleventh aspect, the ninth aspect is provided.
As in the described invention, the processing load on the server is greatly reduced. At this time, a database used for operations such as search in the terminal device is stored in the storage medium of the terminal device as a database using a part or all of the data included in the database stored in the database storage medium. When a part of the data is stored as a database in the storage medium of the terminal, the operation of the database of the server cannot be performed. However, since only necessary data is stored in the storage medium of the terminal device as the database, The search can be performed sufficiently. Furthermore, since part of the data is stored as a database in the storage medium of the terminal device, the capacity for storing the data is smaller than when all the data is stored. Further, since the operation is performed on the database including a part of the data, the processing related to the operation of the terminal device is reduced.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a system to which the present invention is applied.

FIG. 2 is a flowchart showing a flow of the system.

FIG. 3 is an example of a functional block diagram of the system according to the embodiment.

FIG. 4 is a diagram illustrating an example of a database stored in a database storage unit.

FIG. 5 is a flowchart showing a flow of the operation of the system.

FIG. 6 is a diagram showing an example of a screen for requesting data from a terminal computer.

FIG. 7 is a diagram showing an example of a screen for inputting search conditions.

FIG. 8 is a diagram showing an example of a screen for inputting search conditions.

FIG. 9 is a diagram showing an example of a screen for inputting search conditions.

FIG. 10 is a diagram illustrating an example of a search result list screen.

FIG. 11 is a flowchart showing a flow of an operation of the system.

FIG. 12 is a flowchart showing a flow of an operation of the system.

FIG. 13 is a diagram illustrating an example of a data table of requested data.

FIG. 14 is a diagram illustrating an example of a data table of data included in a database stored in a storage unit.

FIG. 15 is a flowchart showing an operation flow of the system, and is a drawing showing an example of a printing flow in the terminal computer.

FIG. 16 is a diagram illustrating an example of a hardware configuration that can implement the present embodiment;

FIG. 17 is a diagram illustrating an example of a hardware configuration that can implement the present embodiment;

[Explanation of symbols]

200 Computer for Server (Server) 210 Processing Unit 220 Database Storage Unit (Database Storage Medium) 300 Computer for Terminal (Terminal, Terminal Device) 310 Processing Unit (Operation Unit, Searching Unit) 320 Storage Unit (Storage Medium)

Claims (11)

[Claims] 1. A server having a database storage medium for storing a database in which data is stored, a terminal connected to the server, and a part or all of the data contained in the database stored in the database storage medium And a means for performing a predetermined operation on the database stored in the storage medium. The storage medium and the operation means are provided in the terminal. A database system characterized by: 2. The database system according to claim 1, wherein said operation means includes a search means for searching a database stored in said storage medium. 3. The database system according to claim 1, further comprising means for storing new data in said database storage medium as a part of a database. 4. The database system according to claim 1, wherein: a requesting means for requesting a part or all of the data contained in the database stored in the database storage medium; Means for storing only the data requested by the request means as a database in the storage medium. 5. The database system according to claim 4, wherein: first creation means for creating a list of data included in the database stored in the storage medium; and Second creating means for creating a list, and storing only the requested data as a database based on the list created by the first creating means and the list created by the second creating means as a database Means for storing in a medium, and a database system. 6. The database system according to claim 5, wherein a list created by said first creating means is compared with a list created by said second creating means, and said list is created by said second creating means. A means for additionally storing only data in the created list and not in the list created by the first creating means as a part of the database stored in the storage medium in the storage medium is provided. A database system, characterized in that: 7. The database system according to claim 5, wherein the list created by the first creating unit is compared with the list created by the second creating unit. A database system comprising means for deleting, from a database stored in the storage medium, data in the list created by the means and not in the list created by the second creating means. 8. The database system according to claim 5, wherein the list created by the first creating unit and the second creating unit includes a data ID of the database and the data ID of the database. Is a list in which the data corresponding to the update date that has updated the data corresponding to the first data is associated with the same data ID in the list created by the first creation means and the second creation means. The update date of the list created by the second creation device is compared with the update date of the list created by the second creation device, and the update date of the list created by the second creation device is compared with the update date of the list created by the first creation device. If the data is new, a database system comprising means for replacing data relating to the data ID as a part of a database stored in the storage medium. 9. A terminal device connected to a server having a database storage medium for storing a database in which data is stored, comprising: a storage medium; a part included in a database stored in the database storage medium; A terminal device comprising: means for storing all data as a database in the storage medium; and operation means for performing a predetermined operation on the database stored in the storage medium. 10. The terminal device according to claim 9, wherein said operation means has a search means for searching a database stored in said storage medium. 11. The terminal device according to claim 9, further comprising requesting means for requesting a part or all of data contained in a database stored in said database storage means, wherein said requesting means requests said data. A terminal device, wherein only the data obtained is stored in the storage medium as a database.