KR20020009148A - MAPIS - Base : MAP APPLICATION INFORMATION SYSTEM - Base - Google Patents

Abstract

PURPOSE: A method for constructing a database of attribute data about a digital map layer is provided to enable a user to easily construct a table about a layer and layer attributes without a separate program by constructing an integrated database for effectively managing attribute data. CONSTITUTION: The method comprises steps of selecting a digital map and opening the digital map(b2), searching a layer to work(b3) or displaying table windows by layer table window opening(b4), selecting a corresponding layer(b5), managing the title and basic data attributes of a layer table(b7) if a data field is added(b6) otherwise managing general details(b13), managing multiple layer list attributes included in the corresponding layer(b8), managing detailed attributes of the respective lists included in the layer(b9), and registering additional or alterative items about a data field(b10). In the detailed attribute management(b9), the detailed attributes are integrally managed with the digital map, the layer table and the list table. Database construction is performed in the sequence of the construction of a layer table, the construction of a list table and the construction of a detailed table. When registering additional or alterative items about a data field, additional field function is used.

Description

Property information database construction method for digital map layer {MAPIS-Base: MAP APPLICATION INFORMATION SYSTEM-Base}

According to the present invention, when constructing or applying a Geographic Information System (GIS), a user can add or change a data field in a database construction and a database construction in which attribute information of various layers of a digital map can be integrated and managed with a digital map layer. The present invention also relates to a method for constructing an effective database by automatically assigning data types and corresponding functions for data fields. Existing digital maps have managed only simple information (numerical information) about digital map layer, and when building attribute database, attribute information and dual management system, and hassle to purchase and use separate database engine and create table There was a limit to managing only a few specified data types (characters, dates, integers, reals). Therefore, the present invention integrates the digital map layer information and attribute information, and a memo type for managing information in the form of a memo for the attribute for effective management of the data field data type when creating the layer and attribute table. Link type for execution of other systems (including WEB SITE) and S / W, Attachment type for various documents and multimedia management, Code type for management of related code table (yes / no, true / By managing data types that are different from the existing ones such as logical type for managing false), it provides a way to build more efficient system when constructing database for geographic information system construction.

The present invention establishes an integrated database (layer information + layer attribute information) for effectively managing attribute information on layers and layer attributes of a digital map, and allows users to create a table on layer and layer attributes without additional program. It provides an easy way to build and use tables.

The technical problem to be achieved by the present invention is to allow users to build a database for the digital map layer and layer properties arbitrarily, and also to provide general functions and data fields for efficient management of various layers and layer properties when building the digital map database. By providing various types of data types, it is possible to build a more convenient and efficient database, as well as to provide the present invention in conjunction with GIS (Geographic Information System) construction. Common features include searching for layers and layer properties, saving and changing search results, converting maps to numeric maps for archived objects, modifying and deleting archived objects, and code tables for efficient operation Window function, column information function to provide information on existing columns, layer and layer property table creation and deletion function, layer fill function to display all layers on the numerical map in the table window, corresponding layer stored and It consists of the overall view / off function on the property operation screen, the spatial figure view function for viewing spatial information of layers and properties, the total sum of layers and layer properties included in the numerical map, and the data type for the data field. Manages characters and numbers to manage common text characters. Number and real type for the purpose of data, logical type for managing the data value (yes / no, true / false), date type for managing the schedule and time, memo type for managing the information in the form of simple memo, Manage linked documents for managing website addresses (URLs), manage various documents (documents, drawings, images, videos, etc.), and manage attachments and system code tables associated with data attributes. It is composed of code type for the purpose and provides the method to build the geographic information system efficiently through this method.

Figure 1. Conceptual diagram showing the overall concept of the invention

2 is a system configuration according to the present invention.

3 is a flow chart showing the overall embodiment according to the present invention.

Figure 4 is an exemplary view for opening a layer table window in claim 1 of the present invention.

5 is an overall configuration diagram for constructing a layer table, a layer list table, and a layer list detail table in claim 1 of the present invention;

6 is an exemplary view for searching for layer and attribute information for each table in claim 4 of the present invention;

Figure 7 is an exemplary view showing a method of adding a field for each table and managing data types in claim 2 of the present invention.

8 is an exemplary view showing a method of adding and deleting fields for each table in claim 3 of the present invention.

9 is a functional configuration for a general management function to be utilized and managed in the present invention.

The present invention provides geographic information by applying various new conceptual data type management functions of data field and general management function according to database construction and database construction related to digital map layer and layer property for effective management of digital map. It provides a more efficient method when constructing system and spatial information system.

1 is a general conceptual diagram of the present invention, provides a method for efficiently managing information associated with various layers and layer attributes included in a digital map, and provides a method for easily constructing a layer and layer attribute information database. The numerical map a01 shown in FIG. 1 is a vectorized map in various formats, and the numerical map a01 is configured in various layers a02. Each layer (a02) contains simple information about the layer, but it is very difficult to manage information on layer properties. Therefore, the present invention is directed to a database construction method capable of integrated management of layer information and attribute information of layers. First, the database structure includes a list table (a05) and list information (a04) for managing the layer table (a03) for managing the layer information (a02) of the numerical map and the list information (a04) belonging to the layer information (a02). It consists of a detailed table (a7) for managing the detailed information (a06) belonging to the configured table (a03, a05, a07) information is integrated and managed in the numerical map database (a11).

In addition, it provides a general management function (a08) for efficient management of the database, and provides a data field management function (a10) for efficient construction of the database. The general management function (a08) includes the function of creating and deleting layer table, changing and saving function, filling all selected layers in the task window, saving search and search results, and storing objects required for building the digital map database (a11). Map conversion and modification function, code table window opening function, column information window opening function, selected spatial information viewing function, attachment file viewing function, etc. (b11) are provided. The data field management function a10 provides various management functions b09 to the data field type to provide a more effective method for constructing a database. In addition, the system configuration of FIG. 2 includes a file and database server 400, a web server 300, an internet environment 200, and a LAN 500 environment. The operating environment is a web server 300 and an Internet user 11n. Internet environment, files and client / server environment driven between DB server 400 and client 51n, and personal computing environment driven separately from Internet user 11n and client 51n. .

3 is a flowchart illustrating the overall embodiment according to the present invention, and the numerical map a01 is applied to all methods. First, to build a database of layers and layer property information, select a digital map map (b02) to be opened and open the digital map. When the numerical map is opened (a01), a table window (b05, b06, b07) is displayed on the screen by searching for a layer to be worked on or opening a layer table window and selecting a corresponding layer (b05). When adding a data field after selecting the layer (b05) (b06), the operation for layer table management (b07) is performed (b06) or the operation for general matter management (b13). Layer table management (b07) manages the name of the layer and layer basic information attributes, list table management (b08) manages multiple layer list attributes belonging to the layer, and detailed table management (b09) belongs to the layer. As a table management window for managing the detailed information property of each list, it is integrated and managed with the numerical map a01, the layer table b07, the list table b08, and the detail table b09. For table management (b07, b08, b09), the database should be built in order of layer table, list table, and detail table so that users can build the table themselves. When registering changes (b10), the user builds related tables by using the additional field function in each table management (b07, b08, b09).

Additional field function (b10) consists of field name (English, Korean, etc.), data type (b11), data length, and data selection function for managing information on the data field. If you press the additional field button in each table management, input English and Korean name for the field, and press data type for the field, various data types (b11) are displayed. Select the appropriate data type among the displayed data types and register the length for the field according to the selected data characteristics. Looking at the new method for the field data type (b11), the memo type for managing information in the form of memo according to the characteristics of the field, the link type for linking to the website of the website, and the execution of linkage with documents and other systems. It is composed of attached type and code type for linking code table associated with field. After registering additional field (b10), field contents are stored in digital map database. The data type stored in the digital map DB (B14) is automatically displayed in the layer table, list table, and detail table windows according to the data type registered in the general management and command information (b14). Execute related functions according to the data type.

The following is a general matter management function (b13) according to the present invention. The contents of the composition are composed of effective construction of a layer and a layer property table and functions that allow a user to easily utilize a digital map. In detail function of general management function (b13), delete the row of the corresponding field, change and save contents of table (b07, b08, b09), create and delete table to build layer table (b07, b08, b09), Fill function to display all the details of layer / layer list / layer list included in the numerical map in each table window (b07, b08, b09), and look up the number of rows included in each table window (b07, b08, b09) Sum function, search the contents in the digital map db (b14) and save or delete the search results under different name, invert function, keep the search results, and convert and modify the map as arbitrary digital map for the stored objects. Function, on / off function for the relevant layer and property, view information of column and code table of the used data field, and view or execute data (link type, attachment type, etc.) according to data type Sphere It is made. As described above, the present invention is not only significantly different from the existing method of using digital maps, but also by using a digital map of new thinking and establishing a database. In terms of productivity as well as cost, we expect significant cost savings.

The present invention utilizes a method that is different from the existing digital map management method in terms of efficient management and utilization of digital maps, which are the basis of GIS (geographic information system) construction, and reduces work productivity, cost savings, and project air. In addition to the effects, such as system integration, as well as non-specialist in IT (information technology) field can be easily built through the present invention the user wants the system. Firstly, as an integrated management method of the digital map database, the present invention provides data management by providing an integrated management method of the existing layer management method and the property information belonging to the layer and the detailed information linked to the layer and the property information. It provides more scientific management by providing systematic and consistent management method of digital map database. Second, it builds data table by diversifying management function of data type for data field when building database table. It is not limited to this, but it provides specific functions to the data type itself so that it can be used systemically (unit module) when using the data.

Existing database management method (limited to letters / numbers (integer, real number) / date when designating data type) has limitation of managing only simple data type according to database construction. By providing and managing new system-specific detailed system modules deviating from the data type, it is expected that there will be enormous utilization in the future in the database and GIS (geographic information system) sectors. When managing video information, the existing database construction method cannot be used, and video information management was possible only by establishing a separate video management system. Therefore, the present invention can simply manage the video information by selecting the attachment type (data type of the present invention) to the data type (data type) and specifying only the video file without constructing a separate system. As mentioned above, it is convinced that the new concept of information technology management method according to the use of the present invention will be based on the future industrial development and national competitiveness, and will become a big framework of the knowledge industry.

Claims (7)

In how to manage the database of digital map ① Steps to open the numerical map layer table window ② Create a numerical map database ③ Steps to build a layer table ④Building a layer list table belonging to a layer ⑤ building the layer list detail table belonging to the layer list ⑥ linking the table with a data type management function ⑦ the step of linking the table and the general management function (b13). When building a general database, how to build a field for the table ① Step of granting a memo management function for registering and managing memo of various memo types in data type ② The step of granting a document attachment type management function to register and manage various documents (documents, drawings, spreadsheets, images, photos, etc.) to a data type. ③ The step of registering the web site address (URL) in the data type and providing a link function for automatic linkage and execution. ④ Granting the function to register and manage moving images and multimedia files in the data type ⑤ Granting the function to register and manage the code file related to the data type ⑥ Manage the above functions by icons, and automatically display icons on the screen according to the functions registered in the data type when searching the corresponding field, and execute them by pressing the icon button. In the method of adding and changing (modifying and deleting) fields in the construction of a layer table, a layer list table, and a layer list detail table of a digital map. ① Step of selecting and opening the corresponding numerical map (map) ②Layer table window open function ③ Function to create and delete layer table, layer list table, and layer list detail table ④ The steps for creating and selecting the button of the corresponding function to give and manage the function to add the field to the table of ③ ⑤ Implement the window to manage the functions such as English name, Korean name, data type (data typa), length of field, selection of data type used so far in the function for adding a field. (6) providing a data type with a character type, an integer type, a real type, a date type, a logical type (yes / no, true / false), and the functions of the present invention claim 3; ⑦ When the definition of additional fields is completed (enter), place the mouse on the field position to add to each table window and click the mouse button (right or left) to implement the function to add and delete the field at the corresponding field position. do. In the method of retrieving the various information registered in the numerical value database, saving the retrieved information as a general database, modifying the contents in the general database tool and bringing it back to the original numerical map database ① Display the information in each table window by giving the search condition (sql) for the specific information about the selected numerical map. ② It saves the searched information and the whole table information in the table window to the general database (access, etc.). At this time, the user can open the general database and modify and change the contents freely. ③ The modified and modified general database can be automatically imported into the numerical map database of the present invention. In the process of converting a stored object into a numerical map (map) ① Store and empty the retrieved objects ② Modifying the contents of the stored object ③ Consists of the step of converting the stored object into a map. In the general management function that must be provided essential to the efficient management and utilization of the present invention ① Steps to add / delete rows, filter off, and sort off ② Field contents writing step after list table search total ③ Invert delete function for searched results ④ Delete all tables ⑤ Viewing and selecting function of used information ⑥Opening code table window ⑦ It consists of the function of viewing spatial information about the layer, layer list table, and layer list detail table. How to save and use layer properties ① In the present invention, the user arbitrarily constructs a layer file suitable for the purpose of storing the layer file (.lay) ② It consists of interlocking spatial information with numerical map when opening layer property file.