JP2000181959A - Superior property retrieving device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To present the index of objective desirability to property by discriminating superiority under plural references concerning inputted construction property and further discriminating total superiority based on the discriminated superiority. SOLUTION: When property data are inputted from an input device 14 of a client computer 12, at a superior property retrieving device 10, these data are transmitted through a LAN 34 to a server computer 20. Relating to the server computer 20, the property data are stored in a property file 22, a superiority discrimination program 32 is activated, the superiority is discriminated based on the plural references concerning the property while referring to a transaction destination superiority file 24, timing superiority file 26 and location superiority file 28 and the total superiority is discriminated while referring to a total superiority discrimination file 30 based on the discriminated superiority. The property data including data concerning the discriminated superiority are displayed on a display device 16 of the client computer 12 and outputted from an output device 18 such as printer.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for analyzing the quality of acquired property data and selecting excellent properties.

[0002]

2. Description of the Related Art In the case where a certain property is an object of a business, the property often has a plurality of criteria for its favorableness as a business object.

[0003] For example, in the case of a building property, if a building material maker or a trading company has ever performed an ordering business with the owner or a contractor of a certain building property, the negotiation based on the result is performed. In many cases, the building can be smoothly proceeded, and the construction property is preferable based on the presence or absence of the transaction record or the criteria.

[0004] If a long period of time is left before the start of construction of a building, sufficient preparation can be made, which is preferable in terms of timing.

[0005] In addition, if the location of the building is close to the company's office, warehouse, agency, etc., there is an advantage that orders can be paid at low transportation costs, which is preferable in terms of convenience of location. .

[0006] With respect to these multiple criteria, each property may have different preferences. For example, in the case of architectural properties, there is a past transaction record with the owner, etc., but there is not enough time left before the start of construction, or the location and preparation period until the start of construction are preferable, but In this case, there is no past transaction history.

[0007] In such a case, conventionally, there is no objective index for the likeness of the property, and each sales person has performed sales activities based on personal experience.

[0008] In the case of a building property, various demands such as building materials, interior decoration of floors, and water and sewage may occur in one property. Therefore, even if the same company has a business unit such as an exterior material-related department, an interior material-related department, and a utility equipment-related department, there may be a case where there are a plurality of departments that can target the same property for business. is there. For example,
It is possible to conduct sales activities in which the exterior materials department sells tiles while the exterior materials department sells building materials.

Conventionally, however, each department has independently searched and obtained properties, and each sales representative has been working on sales activities without obtaining advantageous information such as past transaction results in other business departments. Was out.

[0010]

Conventionally, there has been no objective index for the likeness of a property, and each sales person has determined the likeness of the property based on personal experience. The criterion of judgment was different among the persons in charge. In addition, since each business unit independently searched for property information without considering the various demands related to one property, even if information on the property desired by another department within the same organization existed, Information was not available. As a result, overall business efficiency was poor and business opportunities were often missed.

An object of the present invention is to provide an excellent property search device and a program for recording a program, which provide an objective index of objectivity for a property and share property data held by each business department among many departments. To provide a medium.

[0012]

In order to achieve the above object, a superior property search device according to the present invention comprises a property data input means for inputting property data, and a storage device for storing a property file for storing property data. A plurality of superiority determining means for determining superiority based on a plurality of criteria relating to property data, and an overall superiority determining means for determining overall superiority based on outputs of the plurality of superiority determining means, It is characterized by comprising property data output means for outputting property data including data on the determined superiority.

In a preferred embodiment of the present invention, the property file is stored in a server computer on a network, and the property data can be referenced from a plurality of client computers provided with the property data output means. It is characterized by.

In a further preferred aspect of the present invention, at least one of the plurality of superiority judging means for judging the superiority based on a plurality of criteria relating to the property data,
A storage device for storing a quality file in which values that can be taken by the property data and the quality are stored in association with each other, and means for determining the quality of each property data based on the data stored in the quality file. It is characterized by becoming.

In a further preferred aspect of the present invention, the plurality of superiority judging means include a superiority of a supplier based on past transactions, a superiority of timing based on a remaining time, and a superiority of location based on a location. It is characterized by judging the degree of excellence.

Further, the recording medium of the present invention is characterized by recording a program for realizing the above-mentioned excellent property search device by a computer.

Here, the "property" refers to a real estate, a building scheduled to be built, or a civil engineering work.

“Excellentness” is an index of the likeness of the property. Multiple qualities can be considered from different criteria.

“Data” refers to information stored so as to be referred to. For example, information readablely stored in a memory of a computer is an example of “data”.

A "record" is an integrated management of data on a plurality of predetermined items (fields) for one item.

A "file" is a set of records having the same item structure and stored in a storage device such as a memory or a magnetic disk. Note that the file does not always match the file managed by the operating system. For example, one table in a relational database, one table created by spreadsheet software, the United States
Lotus Notes, a product of Lotus Development Corporation
A document group and the like input from the same type of form correspond to the “file” of the present invention.

The term "output" generally refers to the act of extracting information from a computer, such as displaying on a display, printing with a printer, or writing on a magnetic disk or the like.

"Transactions" include orders and orders, trading of stocks,
Refers to the economic involvement of fund lending and group companies.

The “supplier superiority” is the superiority of the property based on the relationship with the supplier. For example, in the case of an architectural property, the customer's superiority is often high when there is a past record of ordering with the owner of the property.

"Remaining time" refers to a period from a certain point in time to a point in time when a specific business activity must be performed on the property. For example, when receiving an order for a building material for a building, it is often necessary to deliver the ordered building material before the start of the building. In this case, the period from the time of performing the superiority determination to the start of the construction is the remaining time.

"Timing excellence" is the excellence of the property based on the remaining time. If the remaining time is long, it means that the preparation period before conducting business activities is long, and the timing superiority of the property is often high.

“Location excellence” is an index of the likeness of a property based on the location. For example, when an order is received for a building material for a building property, if the location of the property is closer to an office, a warehouse, an agency, or the like, in many cases, transportation costs and the like can be reduced accordingly. In addition, in the case where it is easy to get to and from the location of the property or in a place where future development is expected, the location excellence is often high.

The “supplier superiority file”, “timing superiority file”, and “location superiority file” are files in which the values that can be taken by each data of the property and the superiority of each reference are stored. It is. These quality files do not necessarily need to exist independently, and may be realized by incorporating an algorithm for associating property data with each quality in the means for obtaining quality as needed. .

The “overall superiority” is the overall superiority of the property.

The "network" refers to an environment in which a plurality of computers are connected by a LAN (local area network), a WAN (wide area network), or the like.

The "server computer" is a computer connected to a network and including at least a storage device for storing a property file. In addition, the configuration may include a property data input unit, a superiority file, a superiority determining unit, a unit for determining overall superiority, and the like.

The "client computer" is a computer connected to a network and including at least property data output means. In addition, property data input means,
The configuration may include a superiority determination unit or the like.

[0033]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Referring to FIG. 1, the configuration of an embodiment of a superior property search device according to the present invention will be described. In this embodiment, architectural properties are to be searched, and each sales representative of a business department that receives orders for demand for building materials, tiles, and the like for the architectural properties is provided with objective superiority of the properties.

The excellent property search device 10 is connected with a keyboard and a mouse-like input device 14 for an operator to input data and the like, a display device 16 for displaying processing results, and an output device 18 such as a printer. Multiple client computers 12, property file 22, supplier quality file 24, timing quality file 2
6. A server computer 20 that implements the location superiority file 28, the overall superiority determination file 30, and the superiority determination program 32 on a storage device such as a memory or a magnetic disk.
And a LAN 34 connecting the client computer 12 and the server computer 20.

An example of the structure of the property file 22 is as shown in Table 1.

[0036]

[Table 1] “Property name” is an item that stores the name of a property. “Category” is an item that stores the type of building property (office, apartment, medical facility, etc.). The “owner”, “design office”, and “general contractor” are items that store the names of the owner, the design office, and the general contractor related to the building property, and are used to associate the property with a transaction record. “Start of construction” is an item for storing the start of construction of a building, and is used to calculate the remaining time. “Location” is an item that stores the location of a building property, and is used to determine location excellence. “Supplier excellence”, “Timing excellence”, “Location excellence”, and “Total excellence” are items for storing each excellence. In addition, "subcon",
You may have a memory related to the architectural property such as “area size” and “planned completion”.

An example of the structure of the supplier superiority file 24 is as shown in Table 2.

[0038]

[Table 2] The “supplier” is an item that stores the name of a partner having a transaction record, and an item that stores the name of an object that can be a supplier, such as “owner”, “design office”, or “general contractor” in the property file 22. Can be associated. "Customer excellence"
This is an item for storing supplier superiority determined in advance for each supplier. It is preferable that the supplier superiority is determined from an index such as a transaction amount and the number of transactions.

An example of the configuration of the timing superiority file 26 is as shown in Table 3.

[0040]

[Table 3] The “remaining month” is an item for storing the number of months, and is a remaining month calculated from the “start of construction” of the property file 22 calculated in the superiority determination program 32 (remaining time calculated on a monthly basis).
This is an item for storing a value for comparison with. "Timing excellence" is an item for storing a timing excellence predetermined for each supplier. Each record is stored in descending order of the value of “remaining month”.

A configuration example of the location superiority file 28 is as shown in Table 4.

[0042]

[Table 4] “Location” is an item for storing a place name, and is associated with “Location” in the property file 22. "Location excellence"
Is an item for storing predetermined location excellence given to a property existing at the location. Preferably, the location excellence is determined from an index such as the population of the place or the distance from the main transportation network.

An example of the structure of the overall superiority judgment file 30 is as follows.
It is as shown in Table 5.

[0044]

[Table 5] The association between the "customer excellence", "timing excellence", and "location excellence" of the property and the predetermined "comprehensive excellence" are stored.

The relationship shown in FIG. 2 exists between the items of these files. In the figure, items surrounded by a bold frame mean that they are required items of the file. The line outside the frame with the arrow indicates the item indicated at the tip of the arrow.
This indicates that data is copied from the item indicated at the base of the arrow. A line outside the frame without an arrow indicates that there is a relationship of referring to and associating data of each item. The dashed line means that it is related not through direct reference but through a calculated value. In addition, “owner”, “design office”, “general contractor” in the property file 22
Are not required items, but at least one of the items corresponding to such business partners must be a required item in order to correspond to the “business partner” in the business partner superiority file 24. Means

The function of the excellent property search device 10 will be described below.

When the excellent property search device 10 is used, first, a menu screen shown in FIG.

First, the property input function will be described.

When inputting a new building property, "input property" is selected from the menu screen shown in FIG. In the property input function, at least "property name", "owner",
"Design office", "General contractor", "Start of construction", "Location"
Can be entered. Further, as in the example shown in FIG. 4, data relating to a building property such as a “category” may be input as necessary. When "Save" displayed at the top of the screen is selected, the server computer 20 stores the data entered in each item of the screen as a new record in the corresponding item of the property file 22, and further executes the superiority judgment program 32. to start.

The main routine of the superiority determination program 32 according to this embodiment will be described with reference to the flowchart of FIG.

In step 100, a property record to be subjected to the quality judgment is read from the property file 22. In step 102, the supplier record is judged for the property record read in step 100. The details of this processing will be described with reference to the flowchart of FIG. 6. In step 120, the data stored in any one of the "owner", "design office", and "general contractor" of the property record is determined by the superior supplier. It is determined whether it is stored in the “business partner” of the degree file 24. If any of them is stored, the process proceeds to step 122, where the value associated with “customer superiority” in the supplier superiority file 24 is set as the supplier superiority of the read property record, and “ Supplier excellence ”. Owner,
If multiple design offices and general contractors are stored,
The one with the highest supplier superiority is adopted as the supplier superiority of the read property record. For example, in the case of the property name "A product B branch" shown in Table 1, the product A of the owner is the customer superiority "2", and the construction E of the general contractor is the customer superiority "
1 "because it is stored as" Maximum customer superiority "
2 "is adopted as the supplier superiority of" A product B branch. "If there is no storage corresponding to the supplier superiority file 24, the process proceeds to step 124, where the supplier superiority of the read property record is read. Set to “0” and the property file 22
Write in "Customer excellence". In this embodiment,
When a plurality of business partners are stored, the maximum business partner quality is adopted. However, in some cases, it is better to use the minimum business quality or average value. After determining and storing the supplier superiority, the process returns to step 104.

In step 104, the timing record is judged for the property record read in step 100. The details of this processing will be described with reference to the flowchart of FIG. 7. In step 140, the remaining time from the current time to the construction start month of the property is calculated on a monthly basis according to the following equation (1).

Remaining month = construction month of property record−current year = (construction year−current year) * 12 + (construction month−current month) (1) In step 142, the top of the timing superiority file 26 Read the record in.

In step 144, it is determined whether or not the reading of the record in step 142 or 152 was successful. If the record can be read, the process proceeds to step 146 to determine the remaining month. If the record could not be read, that is, if there is no record to be read in the timing superiority file 26, the process proceeds to step 148, where the timing superiority of the read property record is set to "0", and the property file 22 ""Timingexcellence" and returns to step 106.

In step 146, the value of the remaining month for the property obtained in step 140 is compared with the value of “remaining month” in the record of the timing superiority file 26 read out in step 142 or step 152. If the remaining month value for the property is greater, step 150
Then, the value of the “timing superiority” of the record in the timing superiority file 26 is set as the timing superiority of the read property record, written in the “timing superiority” of the property file 22, and the process returns to step 106. Also,
If the value of the remaining month for the property is equal to or less than the value of “remaining month” in the timing superiority file 26, the process proceeds to step 152, where the next record is read from the timing superiority file 26, and the process returns to step 144. In any case, the process returns to step 106 after the finite number of repetitions.

For example, the two records shown in Table 3 are
Assuming that it is stored in the timing superiority file 26 and the current date is November 6, 1998, the value of “Start of construction” of the property name “A product B branch” shown in Table 1 is January 1, 2000.
Since it is a day, the remaining month is obtained as follows according to equation (1).

(2000-1998) * 12 + (1-11) = 14 (2) Since “14” is larger than the “remaining month” value “12” of the first record of the timing superiority file 26, "Timing excellence" value of the first record. "
2 "is the timing excellence of" A product B branch ".

The timing superiority file 26 is
It is considered that the number of records is often smaller than other files. In this case, the timing superiority file 26 does not necessarily exist as an independent file, but may be incorporated in the superiority determination program 32 as an algorithm for associating “remaining month” with “timing superiority”. For example, in this embodiment, the flowchart of FIG. 8 may be employed instead of the combination of the timing superiority file 26 and the flowchart shown in FIG. However, in the present embodiment, if the determination standard of the timing excellence is changed in the future, the change can be easily reflected without modifying the program.
Are adopted.

Assuming that the correspondence between the possible values of the property data and the superiority is stored as the superiority file and is separated from the superiority determination program 32, the modification of the superiority determination program is performed at all or almost. This is preferable because the problem can often be solved without the need.

At step 106, the location record is judged for the property record read at step 100. The details of this processing will be described with reference to the flowchart of FIG. 9. In step 160, it is determined whether the data stored in the "location" of the property record is stored in the "location" of the location superiority file 28. I do. If it is stored, the process proceeds to step 162, where the value associated with “location excellence” of the location excellence file 28 is set as the location excellence of the read property record, and written in the “location excellence” of the property file 22. .
If there is no storage corresponding to the location superiority file 28, the process proceeds to step 164, where the location superiority of the read property record is set to “0” and written to “location superiority” of the property file 22. In any case, the process returns to step 108 after judging the location excellence. For example, the location of the property name “A product B branch” shown in Table 1 is “E prefecture F city”. It is checked whether "E Prefecture F City" is stored in the "location" of the location superiority file 28. Since it is not stored, the location superiority of "A product B branch" is "0".
Becomes

In step 108, the total superiority of the read property record is determined from the respective superiorities determined so far. Whether the combination of the data stored in the “supplier superiority”, “timing superiority”, and “location superiority” of the read property record is also stored in the item of the same name in the comprehensive superiority determination file 30. Is determined. Table 4 shows an example of the overall superiority determination rule. If the combination of the respective grades of the property record is stored, the process proceeds to step 110, and the value associated with “total grade” of the comprehensive grade determination file 30 is set as the total grade of the read property record, Property file 22
"Comprehensive excellence" is written, and excellence judgment program 3
2 is ended. For example, in the case of the property name “A product B branch” shown in Table 1, the customer superiority is “2”, the timing superiority is “2”, and the location superiority is “0”. Supplier excellence “2”, timing excellence “2”, location excellence ”
When a combination of “0” is searched for in the overall quality determination rule, the overall quality that exists and is associated with is “2.” Therefore, the overall quality of “A product B branch” is “2”. If the corresponding combination is not stored in the overall superiority determination file 30, the process proceeds to step 112,
The total quality of the read property record is set to “0”, written in “total quality” of the property file 22, and the quality determination program 32 is terminated. For example, in the case of the property name “N clinic” shown in Table 1, the customer superiority is “0”, the timing superiority is “0”, and the location superiority is “2”.
When a combination of supplier superiority “0”, timing superiority “0”, and location superiority “2” is searched for in the overall superiority determination rule, there is no such combination.
0 ".

In this manner, a new property can be input.

Next, the function of displaying a list of properties will be described.

Each property record that has been input as described above and whose quality has been determined is stored in the property file 22 on the server computer 20, so that a plurality of client computers 12 connected to the server computer 20 are connected. Can also be referred to.

To refer to the stored list of architectural properties, select "display property list" from the menu shown in FIG. Then, the server computer 20 stores the property file 2
2 is read out and displayed in a list as illustrated in FIG. As the display order, in addition to the order of the property name, it is possible to sort by category, location, comprehensive evaluation, and the like.

In the state where the list is displayed, the property is selected by the cursor and the function of the detail display is selected, so that the detailed data of the property is displayed on one screen as shown in FIG. This makes it easier to refer to data on one property. Further, the property record may be modified or deleted from this screen.

Note that various superiority judging rules may be modified, and the remaining time from the present time to the start of construction of the property is reduced day by day, so that the judgment made at the time of inputting does not conform to the actual situation. It is thought to go. Therefore, it is desirable that the superiority determination program 32 be executed for all property records at regular intervals.

Further, there may be a case where it is desired to make a different quality judgment for each business department. For example,
Since the preparation period required to provide building materials is different from the preparation period required to provide tiles, we want to determine different timing excellence between the exterior material-related department that handles building materials and the interior material-related department that handles tiles. This is the case.
In such a case, different timing superiority determination means 26 is provided for each local user such as a department, and items relating to superiority are separated from the property file 22 and stored as separate files for each local user. Solvable. In this case, the file for each local user may be stored in a server computer common to local users, different from the server computer 20, or may be stored in the client computer 12.

The other means for determining the degree of excellence may be different for each local user. For example, it is preferable to use different determination means for the location excellence, for example, when the location of a product agent differs for each local user.

By doing so, the operator can know not only the individual judgment but the objectively judged superiority, and at the same time, handle it in other business units which could not be known in the past. You can know the existence of a building.

[0071]

As described above, in the superior property search device according to the present invention, the superiority of the input building article is determined based on a plurality of criteria, and based on the plurality of determined superiorities. Since the overall superiority is determined and provided, it is possible to know the objectively determined superiority rather than the individual determination.

In a preferred embodiment of the present invention,
By using a network, the property data stored in the server computer can be referenced from multiple client computers, so it is possible to know the existence of building properties handled by other business units that could not be known in the past. The excellent effect that can be obtained is obtained. By this effect, the number of negotiations can be increased, and negotiations can be efficiently advanced.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram of an embodiment of an excellent property search device according to the present invention.

FIG. 2 is a diagram illustrating a file structure according to an embodiment of the present invention.

FIG. 3 is a diagram showing a menu screen.

FIG. 4 is a diagram showing a property input screen.

FIG. 5 is a flowchart illustrating a process of a superiority determination program 32;

FIG. 6 is a flowchart illustrating a process of supplier superiority determination 102;

FIG. 7 is a flowchart illustrating processing of timing superiority determination 104;

FIG. 8 is a flowchart illustrating a process of another embodiment of the timing superiority determination 104;

FIG. 9 is a flowchart illustrating a process of location superiority determination 106;

FIG. 10 is a diagram of a property list display screen.

FIG. 11 is a diagram of a property detail display screen.

Continued on front page F term (reference) 5B049 BB05 BB11 CC05 DD01 DD05 EE01 EE05 EE31 FF02 FF03 FF07 GG02 GG04 5B075 KK07 KK13 KK34 KK39 NK04 NK13 NK54 PP02 PP12 PQ02 PQ15 PQ46 QT06 UU08

Claims (5)

[Claims] 1. A property data input means for inputting property data, a storage device for storing a property file for storing property data, and a plurality of quality determining means for determining quality based on a plurality of criteria relating to property data. And an overall quality determining means for determining overall quality based on the outputs of the plurality of quality determining means, and property data output means for outputting property data including data on the determined quality. Excellent property search device characterized by the following. 2. The apparatus according to claim 1, wherein said property file is stored in a server computer on a network, and said property data can be referred to from a plurality of client computers provided with said property data output means. Excellent property search device. 3. A storage device for storing a quality file in which possible values of property data and quality are stored in association with each other in advance, and at least one of the plurality of quality determination means is included in the quality file. 3. The excellent property search device according to claim 1, further comprising means for judging the quality of each property data based on the stored data. 4. The plurality of superiority determining means determines superiority including supplier superiority based on past transactions, timing superiority based on remaining time, and location superiority based on location. 2. The method according to claim 1, wherein
3. The excellent property search device according to any one of items 1 to 3. 5. A computer-readable recording medium on which a program for realizing a superior property search device according to claim 1 by a computer is recorded.