JP2006119937A - Method and system for updating database - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a method and a system for updating databases, which can appropriately and efficiently update data even if there is not a person who knows both system structure and update method, and technical data contents for a database at the side of database users or persons who update the database. <P>SOLUTION: The database update method includes a pre-registration process to link simple update information to a database to register in the user side, an update instruction information display process to display the simple update information as update instruction information at the side of a person who updates the database, a formal registration process to update data based on the update instruction information at the side of the person who updates it, and a receiving and checking information display process, in which updated data is displayed to receive and check the updated data and the update instruction information is linked to updated data as update receiving and checking information to be displayed. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a database update method and an update system. In particular, update of data that can be suitably applied to update of data that has expertise in understanding the contents of data, and update of data in a geographical information system used for management of wide area mass transfer facilities such as water and gas The present invention relates to a method and an update system.

  In order to maintain the quality of the database, it is necessary to update the data in the database as appropriate. For this reason, the database usually has editing functions available to the user. However, this editing function does not check and guarantee whether the data itself has quality suitable for the purpose of use. Therefore, when updating highly specialized database data, it is necessary to have expertise (technical skills and judgment) and time allowance in addition to operation skills of editing functions and database users. However, it may be difficult to combine all of these.

For example, in the case of a facility information database of water supply facilities, a management system that manages and utilizes facility information using a geographic information system is disclosed (for example, see Patent Document 1). In such a management system, since the state of the facility changes due to the addition, repair, or improvement of the facility, it is necessary to update the data in the facility information database. In this case, there are experts who are familiar with the contents of the facility information on the user side who maintains and manages the facility, that is, experts who can check the quality of the data and are familiar with the geographical location of the facility. However, the system structure of such a database may be complex, and it is difficult for users to train experts who are familiar with the system structure and data update methods (computer system experts for business support). There are cases. On the other hand, when all database update operations are outsourced to computer system specialists (updaters), the updaters usually do not have specialized knowledge of water supply facilities, and are particularly familiar with the geographical location of the facilities. Therefore, it takes time to identify where the change of the water supply facility occurred, and the renewal work becomes inefficient.
JP 2003-105808 A

  The present invention corresponds to the current situation as described above, and there is no person who knows both the database system structure and the update method and the specialized contents of the data on the database user side or the updater side. However, the present invention is characterized by providing a database updating method and an updating system capable of appropriately and efficiently updating data.

  As a result of intensive studies to cope with the above-mentioned problems, the present inventors have simply entered the contents of a simple change of the facility where the user has changed as simple information, and the renewer side has entered this information and other details. By accurately updating the data based on the information and accepting the updated data by the user side, the characteristics of both can be merged, the data can be updated efficiently, and the database quality can be maintained. It was.

  That is, the present invention provides the following database update method and update system.

[1] A database update method, a temporary registration step in which simple update information is registered in association with a database on the user side; an update instruction information display step in which the updater side displays the simple update information as update instruction information; A main registration step of updating data in the database based on the update instruction information on the user side; and, in order to verify the updated data on the user side, the updated data is displayed, and the update instruction information is updated A database update method including an acceptance information display step of displaying in association with updated data.

[2] The database update method according to [1], wherein the database is a database of a geographic information system including position information data, facility data, and facility change report data.

[3] The database update method according to [2], wherein the simple update information includes memo information including simple position information and character information, and simple graphic information.

[4] In the temporary registration step, a step of displaying a map based on the geographic information data, displaying an existing facility on the map based on the facility data, and prompting the designation of the update position, and the designated position information Including a step of registering simple update information information in association with a database by location information; in the update instruction information display step, a map is displayed based on geographic information data, and an existing facility is displayed on the map based on facility data. And a step of displaying update instruction information including the position information designated in the provisional registration process on the map in association with the database by the position information; including a step of updating the facility data in the main registration process; In the display process, a map is displayed based on the geographic information data, the facility is displayed on the map based on the updated facility data, and the temporary registration is further performed. Updating method database according to the above [2] or [3], including the step of displaying on a map in association with the database by the location information update instruction information including the specified position information as an update inspection information in step.

[5] The above-described [2] to [2] further including a step of displaying facility change data corresponding to the update instruction information on the updater side; and a step of displaying facility change data corresponding to the update content of the data on the user side. 4] The database update method described in any one of [4].

[6] The database updating method according to any one of [2] to [5], wherein the database of the geographic information system is a database of a mass transfer facility.

[7] The database updating method according to [6], wherein the mass transfer facility is a water supply facility.

[8] Database update system, temporary registration means for registering simple update information in association with the database on the user side; update instruction information display means for displaying the simple update information as update instruction information on the updater side; A main registration means for updating data on the user side based on the update instruction information; and for updating the updated data on the user side, the updated data is displayed and the update instruction information is updated as update acceptance information. Database update system comprising acceptance information display means for displaying in association with the received data.

  According to the present invention, by temporarily registering the change of information on the user side, the change of information can be reflected in the database in a timely manner, and by detailed registration of the detailed update information on the updater side, Database quality can be maintained. Furthermore, by updating data on the user side and the updater side in a distributed manner, the data update operation can be performed more efficiently.

  Hereinafter, although an embodiment of the present invention is described based on an example of a geographical information system of a water supply facility (hereinafter sometimes referred to as a water supply GIS), the present invention is not limited to the following specific example.

  FIG. 1 is a schematic diagram functionally showing the database update system of the present invention. This database update system 1 includes temporary registration means 2 for registering simple update information in association with a database on the database user side, update instruction information display means 3 for displaying the simple update information as update instruction information on the updater side, The main registration means 4 for updating the database based on the update instruction information on the updater side, and the updated data are displayed in order to verify the updated data on the user side, and the update instruction information is updated and updated. As shown in FIG. 5, the inspection information display means 5 for displaying the data in association with the updated data.

  FIG. 2 is a schematic diagram illustrating an example of a data structure of the water supply GIS. The water supply GIS 6 is centered on water supply facility data 7 including information on water supply / distribution pipelines and their incidental facilities, and is linked with an electronic filing system 9 including water supply facility change data 8 to have geographical information such as maps. This is a system that can display facilities linked to geographic information by a GIS engine based on data 10. An example of the data structure of the water supply GIS is shown in Table 1. Hereinafter, the update of the water supply facility data 7 in the water supply GIS will be described as an example.

  In this example, when there is a change in the water supply facility such as the addition of a distribution pipe, provisional registration is performed on the user side to register the simplified update information in association with the database. An example of a screen in a state where the simple update information is provisionally registered on the user side is shown in FIG. At the time of temporary registration, the map 11 is displayed based on the geographic information data, and the existing pipeline 12 and the existing water supply device 13 are displayed on the map 11 based on the water facility data. On this screen, the simple update information is input and registered in association with the position on the map where the facility has been added or modified. The simple update information includes location information for associating with a map and simple contents of facility update. For example, on the map 11 in FIG. 3, a frame line 14 (position information) indicating the approximate position of the place where the facility has been changed, such as addition or modification of the facility, and character information 15 (date, construction details) indicating the details of the change. Memo information including device number, character name such as person in charge) and simple graphic information 16 which can visually recognize the outline of the contents of the change are inputted and registered as simple update information. The memo information preferably includes a memo classification indicating the use of the memo information. The memo classification is, for example, “update instruction”, “correction instruction”, “acceptance request”, “inquiry”, and the like. For example, the simple update information shown in FIG. 3 is registered on the user side, and when this is sent to the updater side, the simple update information may be the update instruction information by sending the memo classification as an “update instruction”. It becomes clear. At this stage, the water facility data itself is not updated, and the simple update information is registered as data different from the water facility data.

  As means for registering memo information, for example, it is preferable to provide a memo editor 17 as shown in FIG. 4 as a user interface (hereinafter also referred to as UI). In the memo editor 17 shown in FIG. 4, the memo classification 18 is appropriately selected, and the construction content, the person in charge, the date, other comments, and the like are input to the memo content 19. Such a memo editor 17 makes it possible to easily register memo information. The position information indicating the changed location of the facility is registered as the memo polygon 20 in the memo editor 17 in FIG. Specifically, for example, by moving the pointer so as to surround the corresponding part with a mouse or the like on the map 11 in FIG. 3, a polygon (frame line 14) surrounding the corresponding part is formed, and the position information is registered. As a means for registering simple graphic information, for example, it is preferable to include simple graphic drawing means capable of registering a graphic composed of points and / or lines such as the simple graphic 16 in FIG. Specifically, a simple figure showing the route of a pipeline can be created by selecting a line and specifying the position with a mouse, etc., and selecting a point and specifying the position with a mouse etc. Simple figures showing plugs can be created. Note that the position information and simple graphic information described here do not require accuracy, the position information only needs to know the approximate position of the place where the change has occurred, and the simple graphic information is an outline of the contents of the change. As long as the can be visually recognized.

  Next, the simple update information is sent from the user side to the updater side as update instruction information. The sending method is not particularly limited, and may be sent online via a wired or wireless communication line, or may be sent offline. In the case of sending offline, for example, as shown in FIG. 5, the database 21 including the update instruction information temporarily registered periodically (for example, every month) may be copied to a movable medium and sent to the updater side. preferable. In this case, as shown in FIG. 5, the user side and the updater side each have a database, and the contents of the data are different. Therefore, it is preferable to include a step of synchronizing each database as shown in FIG. Examples of means for synchronizing include means for synchronizing by a replication function. By including such a step, the database can be updated without interrupting the use of the database on the user side. When sending update instruction information online, the user side and the updater side may each have a database. As shown in FIG. 7A, one database is provided on the user side, and the updater side is connected via the network. It is good also as a structure which can be accessed. Alternatively, as shown in FIG. 7B, a database may be placed in another place so that the user side and the updater side can access each via a communication line. It is not essential to send the update instruction information from the user side to the updater side, as long as the update instruction information can be displayed on the updater side.

  Next, the update instruction information is displayed on the updater side. The update instruction information is also displayed on the updater side as shown in FIG. In this case, it is preferable that the character information 15 is displayed in an image in which a sticky note is put in correspondence with the frame line 14 indicating the changed portion. Usually, in order to display the update instruction information on the updater side, there is provided means for displaying and registering / editing the existing facility information and simple update information (update instruction information) on the map, as with the user side.

  Next, the main registration for updating the data in the database is performed based on the update instruction information displayed on the updater side. In this example, the water supply facility data at the corresponding position indicated by the update instruction information is updated.

  At this time, it is preferable to display the facility change data of the facility corresponding to the update instruction information. When a facility is changed, a drawing or ledger showing detailed information on the change is created. Detailed change information such as the drawing and ledger is registered as facility change information in the electronic filing system 9 shown in FIG. 2 in various data formats such as character data including an apparatus number, image data, and CAD data. Then, data is provided to the GIS (water supply GIS 6) as facility change data (water supply facility change data 8) from the electronic filing system 9, and the facility change data is associated with the update instruction information from the device number registered as memo information. It is possible to display. By referring to the facility change data, accurate and efficient data updating can be performed. Therefore, it is preferable that this database update system is configured to be able to access the facility change data, and has means capable of displaying corresponding to the update instruction information. As means for updating data in the database (here, water facility data), an editing function attached to a normal database can be used.

  Next, along with the updated data, update instruction information is sent as update acceptance information from the updater side to the user side. At this time, as shown in FIG. 8, the memo section 18 is changed to “acceptance request”, and it becomes clear that the information to be sent is information (updated acceptance information) for acceptance on the user side. Further, the comment 23 and other information are registered in the memo information as necessary. In FIG. 8, the changed pipeline 24 (added in this example) and the changed water supply device 25 (added in this example) are different from the simplified graphic information 16 in FIG. It is displayed based on the registered facility data. In FIG. 8, the simple graphic information displayed in FIG. 3 is deleted. Means for sending the updated database data and the updated acceptance information from the renewer side to the user side include means for sending them online and offline as described above. Further, when the system has one database on-line as shown in FIG. 7B, it is not necessary to transmit the database data. Further, when sending the update acceptance information, it is preferable to create a list of update information as shown in FIG. 5 and send it as a delivery data list 26 to the user side.

  Next, on the user side, the updated update acceptance information and the update location of the data are displayed as shown in FIG. At this time, it is preferable to display detailed facility change data corresponding to the updated contents of the data as described above. By displaying detailed facility change data corresponding to the updated contents of the database, accurate and efficient water facility data inspection can be performed. Then, after the acceptance confirmation, the updated acceptance information such as memo information is deleted, and only the registered facility information is displayed on the map 9 as shown in FIG. In addition, when a point to be corrected is found in the registered contents at the time of acceptance, the memo classification is changed to “correction instruction”, the correction instruction information is sent to the updater side, and the updater side Data correction is performed in step (b).

  Moreover, as shown in FIG. 10, it is preferable that the database update system includes a search unit that can search various information such as memo information. By providing such a search means, work in each process can be performed more smoothly.

  FIG. 11 shows an image of the flow of data update using the database update method and update system of the present invention. According to this method and system, the work on the user side can be limited to the update instruction and the inspection of the updated content, and the user can be concentrated by utilizing the database. The database update method and update system of the present invention are particularly effective for updating the water supply GIS database as described above, but the use of the database update method and update system of the present invention is limited to the water supply GIS database. It can be suitably used for updating a database of highly specialized data. Among these, it is effective for a GIS database, and can be used particularly effectively for updating a wide area mass transfer facility, particularly a wide area fluid transfer facility, such as a database of gas, electricity, water supply and sewerage.

  The database update method and the update system according to the present invention can appropriately and efficiently update the database even if there is no person who is familiar with both the database system structure and the update method and the technical content of the data. Therefore, it can be effectively used for updating a database of highly specialized data.

It is an approximate line figure showing functionally the update system of the database of the present invention. It is a basic diagram which shows an example of a data structure of water supply GIS. It is a figure which shows an example of the screen on which simple update information was temporarily registered. It is a figure which shows an example of the registration screen of memo information. It is a basic diagram which shows the cycle of data update. It is a basic diagram which shows the process of taking the synchronization of a database. (A) And (b) is a basic diagram which shows an example of the system configuration | structure of this invention, respectively. It is a figure which shows an example of the screen of the state in which data was updated. It is a figure which shows an example of the screen of the state where the inspection of data update was completed. It is a figure which shows an example of a search screen. It is a basic diagram which shows the image of the flow of a database update.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Database update system, 2 ... Temporary registration means, 3 ... Update information display means, 4 ... This registration means, 5 ... Inspection information display means, 6 ... Water supply GIS, 7 ... Water supply facility data, 8 ... Water supply facility change data , 9 ... Electronic filing system, 10 ... Geographic information system data, 11 ... Map, 12 ... Existing pipeline, 13 ... Existing water supply device, 14 ... Frame line, 15 ... Character information, 16 ... Simple graphic information, 17 ... Memo Editor, 18 ... Memo Category, 19 ... Memo Content, 20 ... Memo Polygon, 21 ... Database, 23 ... Comment, 24 ... Changed Pipeline, 25 ... Changed Water Supply Device, 26 ... Delivery Data List.

Claims (8)

A database update method,
Temporary registration process for registering simple update information in association with the database on the user side;
An update instruction information display step of displaying the simplified update information as update instruction information on the updater side;
A main registration step of updating data in the database based on the update instruction information on the updater side; and updating data on the user side for displaying the updated data in order to verify the updated data on the user side. A database update method including an inspection information display step of displaying in association with data updated as information.   The database update method according to claim 1, wherein the database is a database of a geographic information system including geographic information data, facility data, and facility change data.   The database update method according to claim 2, wherein the simple update information includes memo information composed of position information and character information, and simple graphic information. In the temporary registration step, a map is displayed based on the geographic information data, an existing facility is displayed on the map based on the facility data, and the update position is prompted, and the simplified update information including the specified position information Including registering information in association with the database by location information;
In the update instruction information display step, a map is displayed based on the geographic information data, an existing facility is displayed on the map based on the facility data, and the update instruction information including the position information specified in the temporary registration step is further positioned. Including displaying information on a map in association with a database;
Updating the facility data in the main registration step;
In the acceptance information display step, a map is displayed based on the geographic information data, the facility is displayed on the map based on the updated facility data, and the update instruction information including the location information specified in the temporary registration step is updated. The database updating method according to claim 2, further comprising a step of displaying on a map in association with the database based on position information as inspection information.   The updater side further includes the step of displaying the facility change data corresponding to the update instruction information; and the user side further includes the step of displaying the facility change data corresponding to the update contents of the data. How to update the described database.   The database update method according to claim 2, wherein the database of the geographic information system is a database of mass transfer facilities.   The database update method according to claim 6, wherein the mass transfer facility is a water supply facility. A database update system,
Temporary registration means for registering simple update information in association with the database on the user side;
Update instruction information display means for displaying the simplified update information as update instruction information on the updater side;
Main registration means for updating the data in the database based on the update instruction information on the updater side; and for updating the data updated on the user side, displaying the updated data and updating the update instruction information A database update system comprising acceptance information display means for displaying in association with data updated as information.