JP5490509B2 - Construction / business results search system - Google Patents

Description

The present invention relates to construction and operational performance search system, more particularly, company information, construction and operational performance search system for searching on the basis of the search condition consisting of at least one of the record information or technician information about the arm.

  To confirm the technical capabilities of the company in the ordering process for construction, etc., in order to contribute to the transparency, objectivity, and competitiveness of the procedures in the tender / contract of construction / operations (hereinafter referred to as construction, etc.) The construction / business performance search system is known.

FIG. 8 is a schematic diagram of a construction / business performance search system.
The construction / work performance search system is used for the contents of construction work ordered by public organizations such as national governments, independent administrative agencies, prefectures, ordinance-designated cities, municipalities, and public utilities such as railways, electricity, and gas. A company that has received an order for construction, etc., registers it in the system, creates a database of the registered contents, and provides information to the ordering organization and the ordering organization.・ Contributes to improving the transparency, fairness and competitiveness of contract procedures.

Information stored in the database in the system includes performance information consisting of construction results and design work completion information, company information consisting of information on each company, engineer information consisting of engineer results and affiliation, etc. Is included.
The ordering organization inputs desired search conditions consisting of company conditions, performance conditions, and engineer conditions, and searches for companies that meet the search conditions, so that it is possible to select suppliers with higher fairness and transparency. .

  However, the conventional construction / business performance retrieval system has the following problems.

(1) In the conventional search interface, only the final result (number of companies) according to the input search condition is displayed. Therefore, the search result is narrowed down by any condition among the search conditions input by the user. I ca n’t figure out. To check the search results, you must repeat the search operation while adjusting each search condition (adding, deleting, modifying search conditions, etc.) and check each search result individually. It is difficult to longitudinally examine the search results obtained by the search operation.
(2) In the conventional search interface, when it is desired to display the search results that have been previously searched, the same search conditions must be input again to display the search results, which can be obtained by a plurality of search operations. Cross-sectional examination of search results is difficult.

In view of the above, it is an object of the present invention is to provide a more convenient construction and operational performance search system.

The first invention of the present application, which has been made to solve the above problems, comprises at least one of company information, performance information or engineer information input from a user terminal in order to select a company as a construction ordering party. A construction / business performance search system capable of performing a search based on search conditions, a database storing at least a table group including company information, performance information, and engineer information, and a web of a user terminal to control the display in a browser, an HTTP server, and refiners advance any condition setting is made in the system, among the plurality of search result set generated by the search condition and refinements, any result set An extraction condition in which a condition for whether to extract the file is stored, an AP server that stores the extraction condition, and a DB server that executes search processing The HTTP server receives input screen data including a search condition input on the WEB browser of the user terminal, and the AP server performs a plurality of searches by combining the search condition and the refinement condition extracted by analyzing the input screen data. A search expression including a process for obtaining a result set and a process for extracting a part of the search result sets from the plurality of search result sets in accordance with the extraction condition is generated, and the DB server is configured based on the search expression. The search is performed on the database to acquire the partial search result set, and the AP server creates a search result screen in which the partial search result set is aggregated as output screen data , and the HTTP server Transmits the output screen data to the user terminal, and displays the search result on the WEB browser of the user terminal. There is provided a search system.

In the second invention of the present application, the search result screen displays a search condition input unit for inputting the search condition and a search result display unit for displaying a list of the partial search result set on one screen. it is then, is to provide a construction and operational performance retrieval system according to the first invention.

Further, according to a third invention of the present application, the AP server can store the partial search result set as a comparison candidate, and separately display a comparison list screen in which the plurality of stored comparison candidates are displayed in parallel. The construction / business performance search system according to the first invention or the second invention, which is configured so as to be created as output screen data .

Further, a fourth invention of the present application is the AP according to any one of the first to third inventions , wherein the AP server is configured to be capable of correcting at least one of the narrowing condition and the extraction condition. It provides a construction / business performance search system .

Further, the fifth invention of the present application is configured such that the AP server is configured to be able to store the history of the output screen data, and is capable of correcting at least one of the narrowing condition and the extraction condition. The construction / business performance search system according to any one of the first to fourth inventions is provided.

According to the present invention, at least one of the following effects can be obtained. (1) A plurality of search results including the details of narrowing down are displayed in one search operation, which contributes to a low number of searches. .
(2) By confirming the details of narrowing down a plurality of search results obtained by a single search operation, it is possible to easily grasp how narrowing has been made under what search conditions from among the input search conditions. . Therefore, it is possible to longitudinally examine the search result based on one search operation.
(3) By storing a history of search results that have been previously searched, differences in search results due to different search conditions can be easily grasped. Therefore, a cross-sectional examination is possible for search results based on a plurality of search operations.
(4) Since the search condition can be adjusted after confirming the search result narrowing history and the search result history, the search condition adjustment work is unlikely to be reversed.
(5) By appropriately modifying the search result narrowing conditions and extraction conditions, it is possible to flexibly respond to requests such as search narrowing procedures and addition / change of search results that the user wants to confirm.
(6) From the above points, the convenience of the system is improved as a whole.

The figure which shows the structure of the construction and business performance search system of this invention. The figure which shows an example of the production | generation model of a search expression. The figure which shows the information processing of each server at the time of a search. The figure which shows the information processing of each server at the time of log | history display. The figure which shows a search result screen. The figure which shows the detailed display screen of a search result. The figure which shows a comparison list screen. Schematic diagram of construction / business results search system

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
The “search expression generation device” of the present invention corresponds to an apparatus including a search expression generation function in the “AP server” related to the “construction / business performance search system”, and therefore, the description thereof is omitted.

<1> Overall Configuration of System FIG. 1 is a diagram showing a configuration of a construction / business performance search system according to the present invention.
The construction / business performance retrieval system of the present invention includes at least an HTTP server 2, an AP server 3, a DB server 4, and a database 5 connected to the user terminal 1, and can transmit and receive information to and from each other via a network. It is connected.

Each server includes an information processing apparatus having a server function, which includes a CPU, a memory, an external storage device, a medium driving device, a network connection device, and the like.
The function of each server can be realized by a software component that consists of a set of instructions stored in a specific program code segment of the memory.

  The network is an information communication network including an ISDN line, a CATV line, an optical cable line, a wireless line, and the like, and is configured to be able to transmit and receive information using protocols such as TCP / IP, FTP, and HTTP. For example, the Internet, LAN, VLAN Or other networks or combinations thereof. Details of each device will be described below.

(1) User terminal The user terminal 1 is a device for a user to input search conditions and browse search results, and is a well-known information processing device (personal computer, PDA, smartphone, etc.) equipped with a WEB browser. Therefore, the description is omitted.

(2) Database The database 5 is a storage device in which data is searched / extracted by the DB server 4 and includes an external recording medium such as an HDD.
The database 5 according to the present invention is roughly configured to include at least three database sets including an engineer set S1, a performance set S2, and a company set S3.
Hereinafter, each set will be described.

(2.1) Engineer set The engineer set S1 is a set in which information on engineers is stored in a database, and includes the following tables as representative tables. Each table is associated with each other based on the engineer identification number. Configure.

[Example of a table constituting a set of engineers]
(A) Engineer information table: engineer's name, date of birth, affiliated company, etc. (b) Engineer's possession qualification table: Qualification code, qualification name, qualification number, etc. possessed by engineer Period table: Engineer's engagement period, role, construction method, model code, etc.

(2.2) Results Set The results set S2 is a database of information on construction results and work results, and includes the following tables as representative tables. Each table is based on a registration number or company identification number. Associate and configure.

[Example of a table that configures a result set]
(A) Construction result table: construction contents, contract amount, construction start, contract form, order form, construction place, construction rating, etc.
(B) Work result table: work contents, contract amount, construction start, contract form, order form, work area, work rating, etc.

(2.3) Company Set The company set S3 is a database of information on companies, and includes the following tables as representative tables, and each table is configured to be associated with each other based on the company identification number.

[Example of a table constituting a company group]
(A) Company information table: company name, contact information, responsible person, etc. (b) Head office location table: address of head office location, contact information, etc. (c) Company PR table: number of engineers with specific qualifications, company URL, Capital etc.

(3) HTTP server The HTTP server 2 is a device for controlling the display of information on the WEB browser of the user terminal 1 via the Internet 6, and is a server device having a general HTTP function. Is omitted.

(4) AP Server The AP server (application server) 3 is a device for giving a search expression to the DB server 4 and generating output screen data from the returned search result set.
Hereinafter, each function of the AP server will be described in more detail.

(4.1) Filtering Condition / Extraction Condition Saving Function The AP server 3 stores the filtering condition and extraction condition in the internal storage device.
The refinement condition is an additional search condition arbitrarily set on the system in addition to the search condition input by the user.
The extraction condition is a condition arbitrarily set on the system in order to extract a part of a set group from a plurality of search result set groups acquired from the DB server 4.
The contents of the narrowing condition and extraction condition can be appropriately modified and saved by the system administrator according to a search narrowing procedure, a request for addition / change of a search result the user wants to check, and the like.

(4.2) Analysis / Extraction Function of Search Condition The AP server 3 has a function of analyzing the input screen data input from the HTTP server 2 and extracting the search condition.

(4.3) Search Expression Generation Function The AP server 3 has a function of generating a search expression configured by an SQL sentence from the search condition, the narrowing condition, and the extraction condition.
FIG. 2 is a diagram illustrating an example of a search expression generation model.
The search expression generation model described in (4.3) will be described with reference to FIG.

(4.3.1) Creation of Basic Set Group First, search conditions (engineer condition A, results) input by the user for three sets (engineer set S1, results set S2, and company set S3) in the database. Each set (S4 to S19) is created in order based on the condition B, the company condition C) and the narrowing-down conditions (see the underlined portion in each set) stored in advance in the AP server. The details of each set S4 to S19 are as shown in the following table.

  Referring to Table 1 above, a set generated only by any one of the search conditions (engineer condition, company condition, performance condition), and the narrowing conditions held in the AP server 3 in those sets are shown. It can be understood that various sets are generated from the input search condition and the refinement condition stored internally, such as a set generated by addition and a set obtained by combining these sets.

(4.3.2) Extraction from Basic Set Group Next, based on the extraction conditions stored in the AP server 3, a predetermined set (S4, S6, S7, S10) from each set (S4 to S19). , S13, S14, S17) to generate a final search result. A list of final search results is shown in Table 2.

As for each set described in Table 2, a part of the set is extracted from the set shown in Table 1.
By confirming the size of the set according to Table 2, it is understood how the search results were narrowed down by what kind of search conditions (engineer condition, company condition, performance condition) entered. be able to.

(4.4) Search Expression Transmission / Search Result Processing Function The AP server 3 gives the search expression to the DB server 4 and extracts the returned search result according to a predetermined condition, and then processes it into output screen data. A function of outputting to the HTTP server 2.

(4.5) Other functions In addition, the AP server 3 stores a search condition and a search result in the database 5 and a history of the search result. A function of generating output screen data;

(5) DB Server The DB server 4 is a device for executing search processing on the database 5.
The DB server 4 has a function of executing a search process on the database 5 based on the search expression acquired from the AP server 3 and returning the acquired search result to the AP server 3.

<2> Basic Operation of System FIG. 3 is a diagram showing information processing of each server during search execution.
The basic operation of this system will be described with reference to FIG.

(1) Input of search condition / press of search button When the user presses the search button after inputting the search condition on the WEB browser of the user terminal 1, the user terminal 1 converts the search condition into input screen data. It transmits to the HTTP server 2 (S100)

(2) Reception of screen data When the HTTP server 2 receives the input screen data, the HTTP server 2 transfers the input screen data to the AP server 3 (S110).

(3) Analysis of screen data The AP server 3 analyzes the input screen data and extracts search conditions. (S120)

(4) Generating a search expression The AP server 3 generates a search expression including an SQL sentence based on the extracted search condition and a narrowing condition and an extraction condition stored in advance in the AP server, and sends them to the DB server. Transmit (S130).

(5) Execution of search The DB server 4 executes a search for the database 5 based on the search formula (S140). The search includes a process of reading the original data from the database 5 and a process of writing a set of search results acquired by the search formula onto the database 5.

(6) Retrieval of search results The DB server 4 reads the search results from the database 5 and returns them to the AP server 3 (S200).

(7) Aggregation of search results The AP server 3 aggregates a plurality of sets sent in the search results (S210).

(8) Creation and storage of screen data The AP server 3 creates output screen data based on the aggregated search results, transmits the output screen data to the HTTP server 2, and the created output screen data for each search operation. It accumulates in the internal storage device as history information.

(9) Saving Search Conditions / Results The DB server 4 also saves the search conditions and count results sent from the AP server 3 in the database 5 (S230).

(10) Return of output screen data The HTTP server 2 returns the output screen data to the user terminal 1 (S240), and the search result is displayed on the user terminal (S250).

<3> System History Display Operation FIG. 4 is a diagram showing information processing of each server when displaying a history of search results.
With reference to FIG. 4, an operation related to history display in this system will be described.

(1) Pressing the search button When the user presses the history button on the WEB browser of the user terminal 1, the user terminal 1 converts information indicating whether the search history should be displayed into input screen data and converts it to an HTTP server. 2 (S300)

(2) Reception of screen data When receiving the input screen data, the HTTP server 2 transfers the input screen data to the AP server 3 (S310).

(3) Analysis of screen data The AP server 3 analyzes the input screen data and extracts information indicating what number search history should be displayed. (S320)

(4) Reading history information The AP server 3 reads predetermined output screen data from the history information stored in the internal storage device based on the information indicating whether or not the previous search history should be displayed. It transmits to the server 2 (S330).

(5) Return of output screen data The HTTP server 2 returns the output screen data to the user terminal 1 (S340), and the search result is displayed on the user terminal (S350).

<4> Display Screen Examples FIGS. 5 to 8 are examples of the display screen of the system according to the present invention.
An example of the display screen will be described with reference to FIGS.

(1) Search Result Screen FIG. 5 is a diagram showing the search result screen 6.
A search condition input unit 61 is arranged on the left side of the search result screen 6, a search result display unit 62 is arranged on the right side, and a search button 63 is arranged above the search result display unit.
When the user inputs search conditions to the search condition input unit 61 and presses the search button 63, a search operation is performed, and a plurality of search results are output to the search result display unit 62.
By adopting this arrangement, it is possible to check the search results as appropriate while checking the search conditions entered on one screen.

A history button 64 is arranged above the search condition input unit 61.
By pressing the history button 64, the search conditions stored in the AP server 3 and the search result history can be confirmed.

Below the search result display portion 62, a plurality of list display buttons 65 are arranged.
By pressing a list display button 65 for a certain set, a list display screen of the selected set can be displayed.

(2) Details Display Screen FIG. 6 is a diagram showing a details display screen 7 that displays details of the search results.
The detailed display screen 7 is provided with a detailed content display section 71 including the name of the corresponding company in the selected set, the number of achievements, the number of engineers, and the like.
Below the detailed content display section 71, a comparison candidate addition button 72 and a comparison candidate list display button 73 are arranged.
When the comparison candidate addition button 72 is pressed, the displayed set is stored as a comparison candidate in the storage device in the AP server 3.
When the comparison candidate list display button 73 is pressed, a comparison list screen 8 for displaying a list of each set of stored comparison candidates can be displayed.

FIG. 7 is a diagram showing the comparison list screen 8.
In the comparison list screen 8, a comparison candidate list display section 81 including each search result stored in the AP server when the comparison candidate addition button 72 in the detail display screen 7 is pressed is displayed across the screen.

1 User terminal 2 HTTP server 3 AP server 4 DB server 5 Database

Claims (5)

Work / operations that can be searched based on a search condition consisting of at least one of company information, results information, and engineer information input from the user terminal in order to select the company that is the contractor. A results search system,
A database storing at least a table group including company information, performance information and engineer information;
An HTTP server that controls display on the WEB browser of the user terminal;
Extraction with a condition set as to which search result set to be extracted from a search condition set with arbitrary conditions set in advance in the system and a plurality of search result sets generated based on the search condition and the search condition The AP server storing the conditions,
And a DB server that executes search processing.
The HTTP server accepts input screen data including a search condition input on the WEB browser of the user terminal,
A process in which the AP server acquires a plurality of search result sets by combining the search condition and the narrowing-down condition extracted by analyzing the input screen data, and a part of the plurality of search result sets according to the extraction condition. Generating a search expression including a process for extracting a search result set,
The DB server performs a search on the database based on the search formula to obtain the partial search result set,
AP server, create a search result screen obtained by aggregating the results set of the part as the output screen data,
The HTTP server is configured to transmit the output screen data to a user terminal and display a search result on a WEB browser of the user terminal.
Construction / business results search system. 2. The search result screen according to claim 1, wherein a search condition input unit that inputs the search condition and a search result display unit that displays a list of the partial search result set are displayed on one screen. Construction / business results search system. The AP server can save the partial search result set as a comparison candidate, and can separately create a comparison list screen in which the plurality of saved comparison candidates are displayed in parallel as the output screen data. The construction / business results search system according to claim 1 or 2. The construction / business performance search system according to any one of claims 1 to 3, wherein the AP server is configured to be capable of correcting at least one of the narrowing condition and the extraction condition. The construction / business performance search system according to any one of claims 1 to 4, wherein the AP server is configured to be able to store a history of the output screen data.