KR100404305B1 - Facility management and consumer management system with digital map and mobile telecommunication terminals and the managing method thereof - Google Patents

Abstract

The present invention relates to a facility management and customer management system using digital digital maps and mobile communication terminals, and a method thereof, and to construct geographic information data nationwide including basic roads, buildings, and facilities having a land mark. Based on this, various information can be viewed on a map, and the geographic information data is corrected and edited in real time according to a data modification request transmitted from the mobile communication terminal in real time. The system according to the present invention includes a digital map generating means for creating a digital map based on vector data, a database in which the digital map data, CRM data, facility data, and topographic data are stored, and means for responding to a request for providing information from a client. And a decoding means for correcting and editing the numerical map data in response to a client's data modification request, requesting the server apparatus to provide information, searching for information provided by the server apparatus, and receiving an error in the provided information. The mobile communication terminal includes a mobile communication terminal that corrects an error and sends the data correction request to a server device, wherein the mobile communication terminal includes a content converter including a rule / script, a script engine, and a markup language converter. The modification request data transmitted from the terminal is It characterized in that it comprises a structured code history log files corresponding to the edited contents. The management system may further include a lower server searching the database of the server device in response to a request for providing the information of the client to obtain the requested information and providing the information to the client.

Description

Facility management and customer management system and method using digital digital map and mobile communication terminal

The present invention relates to a management system and method using a geographic information system and a mobile communication terminal. More specifically, the present invention uses a digital digital map and a mobile communication terminal, for example, a PDA (Personal Digital Assistant) applying a geographic information system (GIS), and directly edits and edits data by the mobile communication terminal. This relates to possible facilities, retail and / or customer care systems and methods.

Recently, a service for transmitting various types of information applied by a geographic information system (GIS) to a personal computer (PC) directly connected to the Internet regardless of an operating system is widely used. This type of system is called a network-oriented GIS system. It takes the form in which users access the GIS engine on the web server of the company providing the service and download the necessary geographic information to their PC. An example of such a network-oriented GIS system is the portal site Hanmir (http://www.hanmir.com) operated by Korea Telecom. In the site, the user can search for a desired feature, a site number, etc., a search can be performed through a mutual name, etc., and geographic location information is shown in a drawing, and data such as a telephone number is also presented.

Meanwhile, a portable computing device such as a personal digital assistant (PDA) or a handheld personal computer (HPC) that collects, stores, composes, retrieves, and communicates information may be used for satellite tracking system (GPS) or geographic information system ( It is being developed to apply to GIS), which is applied to transportation courier system, navigating system, insurance business, mobile finance business, security police business and tourism.

However, in the systems developed so far, the portable computing device merely uses the provided information by providing the requested information in response to the information requested by the portable device from the server system. Therefore, when the server provides wrong information or old information, it is difficult to modify and edit the information even though the user knows that the information is wrong. This problem places a limit on the range of data that can be sent to the server in real time in a situation where a mobile terminal, such as a salesperson or a manager carrying a PDA device, manages the area or branch office in charge of a mobile terminal. This can be a particularly serious problem for customer, retail, and agency management systems that require the use of mobile devices to create optimal delivery routes, sales and production plans, and management plans.

Accordingly, it is an object of the present invention to provide a management system capable of directly modifying and editing data by a mobile communication device.

Another object of the present invention is to provide a system and method for easily knowing the geographical distribution and status of character or numeric data represented and managed in a customer management system.

Another object of the present invention is a mobile communication that can transmit and receive data wirelessly with CRM functions such as location information and sales and management status of the agency and management target of the company, sales and management status, etc. System that transmits sales status, management status, and order history of sales employee and facility manager in real time by using terminal, and saves them in CRM database and upper server of lower server such as local agency, and enables planning and decision-making based on them. To provide a way.

1 is a block diagram showing the overall structure of a system according to a first embodiment of the present invention.

2 is a block diagram showing the overall structure of a system according to a second embodiment of the present invention;

3A-3D are tables illustrating an example of a database according to the present invention.

4 is a flow chart illustrating a process of creating and editing a digital map database that can be used in the present invention.

5 is a flowchart illustrating a process of creating and editing a digital map database that can be used in the present invention.

6 is a schematic diagram showing a structure of vector data applied to the present invention.

7 is a flow diagram schematically illustrating the overall process of a process according to the invention.

8 is a schematic diagram illustrating an example of a mobile communication terminal that can be used in the present invention.

9 is a schematic diagram showing an example of a screen configuration of a mobile communication terminal that can be used in the present invention.

10 is a schematic diagram illustrating a decoding process in a server system according to the present invention.

<Description of Major Symbols in Drawing>

10: main server

20: CRM, facilities, feature database

30: Subordinate Server Database

40: network

50: subordinate server

60: CRM, Facility Database

70: network

80: mobile communication terminal

The present invention provides a new type of management system and method combining GIS, facility management (FM), and customer relation management (CRM). In the present invention, a geographic information system (GIS) is a collection of hardware, software, geographic data, and personnel of a computer organized to efficiently acquire, store, update, manage, analyze, and output all types of geographically arranged information. to be. Therefore, GIS uses computer to digitize attribute information and spatial information related to various spatial elements such as land, geography, environment, resources, facility management, urban planning, disaster prevention, etc. according to geographic spatial location. It is a comprehensive information management system for spatial analysis with the ability to input and manage, process and analyze the information according to the purpose of use and output the required result. In addition, CRM (Customer Relation Management) is a company that provides goods, services, and services so that all data can be computerized and searched and analyzed to efficiently manage end customers, retailers, and distributors. System. FM (Facility Management) refers to a system for managing facilities such as telegraph poles, water supply and sewerage, and transmission towers scattered in a network form based on GIS data inputting location information and attribute information.

The present invention builds geographic information data of the whole country including basic roads, buildings, facilities, etc. with a land mark, and based on this, various information can be viewed on a map and transmitted in real time from a mobile communication terminal. According to the data modification request, the geo-editing data is edited and edited in real time.

The system according to the present invention is a management system using a digital numerical map and a geographic information system, the numerical mapping means for creating a digital map based on vector data, and the numerical map data, CRM data, facility data and topographical data are stored A server device comprising: a database; a means for responding to a request for providing information from a client; and decoding means for modifying and editing said numerical map data in response to a client's request for data modification; A mobile communication terminal which retrieves the information provided by the server device and corrects the error and sends the data correction request to the server device when the information provided has an error, wherein the mobile communication terminal includes a rule / script, a script engine, and markup. A content converter configured as a language converter Hereinafter, and change request data transmitted from the mobile communication terminal is characterized in that it comprises a structured code history log file corresponding to modify edits. The management system may further include a lower server searching the database of the server device in response to a request for providing the information of the client to obtain the requested information and providing the information to the client.

The method according to the present invention comprises the steps of: creating a numerical map based on vector data; accepting a request for terrain information from a client; and searching for information meeting the conditions requested by the client and transmitting the searched result information to the client. And a step of screening the transmitted information to a client, comparing and searching the displayed information with actual information, and determining whether to correct the data. And performing map data correction and editing, wherein the step of preparing a digital map comprises: preparing a map, determining whether the prepared map is vector data, and when the vector data determination step is not vector data. Vectorizing it, extracting attributes from the vectorized map Building a database; overlaying and editing maps; linking drawings and property data; correcting and correcting errors by inspecting drawings and databases; and a database of map data and property data. The method may further include a step of completing, wherein the searching and transmitting the information meeting the condition requested by the client may further include transmitting a data re-request to the client and receiving a request for the changed condition from the client.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.

1 is a block diagram showing the overall structure of a system according to an embodiment of the present invention. The management system 100 according to the present invention includes a main server 10, databases 20 and 30, a plurality of subordinate servers 50, a database 60, and a mobile communication terminal 80. The main server 10 and the lower server 50 are connected to a communication network 40 such as, for example, the Internet network. The lower server 50 and the mobile communication terminal 80 are connected to a wireless or wired communication network 70.

The main server 10 is a computer system including a communication protocol, a communication architecture, an operating system, and is composed of other hardware such as a processor, a system controller, a memory, a display, a keyboard, and the like. The database 20 managed by the main server 10 stores CRM data, facility data, and topographical point data, and the database 30 stores data about the lower server 50. The lower server 50 is a computer system, which manages the CRM / facilities database 60. There are a plurality of lower server 50 according to a predetermined geographical range. The mobile communication terminal 80 connected to the subordinate server 50 is, for example, a PDA or HPC as a mobile computing terminal, which not only collects, stores, creates, retrieves and communicates information, but also modifies or edits provided information. A portable device capable of requesting this to the server system.

The main server 10 and the lower server 50 provide a web service based on HTTP, and the mobile communication terminal 80 processes a wireless communication protocol such as WAP (Wireless Application Protocol) based content. In this case, a proxy server that converts HTTP and WAP to each other, that is, a gateway is required. The gateway may be included in the lower server 50 or may be configured as a separate entity from the lower server 50. The mobile communication terminal 80 makes a WAP request to the subordinate server 50 or the gateway (not shown), and the subordinate server 50 or the gateway replaces the WAP request with an HTTP request, thereby providing a web server ( (Not shown). The response transmitted from the web server to the mobile communication terminal goes through the same conversion process.

The database 20 includes, for example, three data tables (CRM table, facility table, topographic table). For example, as shown in FIG. 3A, the CRM table includes a pharmacy data field in which data such as pharmacy name, address, telephone, fax, homepage, business registration number, pharmacy owner, store size, number of employees, asset size, license number, Pharmacist data field where data such as school of origin (final education), telephone, fax, e-mail address, hobby, specialty, gender, etc., hospital name, doctor's name, scale, license number, specialty etc. It may consist of a data field. For example, as shown in FIG. 3B, the facilities table includes data on locations of public offices, cultural facilities, shopping facilities, etc., main building data fields in which data such as building names, building history, etc., road names, width sources, lane numbers, and traffic information are stored. It may be configured as a stored road data field, pharmacy and related institution data fields stored in the location and occupancy information of the relevant facilities, such as pharmacies and hospitals. The topographic point table includes, for example, topographic map data, cadastral map data, and road network map data, as shown in FIG. 3C. The cadastral map data is map data that has the number, and map data that is represented on the numerical map including all the numbers of Seoul or the whole country. On an electronic map, cadastral map is also referred to as zip map or zip map instead of words. Since this map has a number, it can be used for customer management, sales management, shipping and logistics. On the other hand, the terrain data is a map of the terrain of the country, including the contour of the mountain, the water system of the river, etc. can also display information such as the height and width of the contour. Road network data stores road-related data such as roads, signaling systems, and intersections.

The lower server database 30 includes, for example, a sales table and a user authentication table as shown in FIG. 3D. The sales table is a distributor data field that stores data such as trade name, business registration number, distributor name, license number, and transaction size, and a retailer data field that stores data such as trade name, business registration number, representative, and transaction size, name, social security number. It consists of salesperson data fields that store data such as the area in charge, the number of customers, sales performance, and employee evaluations. The user authentication table stores data such as an agency data field in which data such as agency name, business registration number, representative name, license number, ID, password, etc., trade name, business registration number, representative name, ID, and password are stored. It consists of a personal data field in which data such as a retailer data field, name, social security number, ID, and password are stored.

The data structure shown in FIG. 3 is merely an example, and the fact that the contents of the data field can be changed according to the field of application of the present invention will be readily understood by those skilled in the art.

In FIG. 1, a general user 90 may be provided with information by accessing a server system through a communication network 70 and / or a communication network 40. 1 is a server / client type system, whereas the management system shown in FIG. 2 represents a host type configuration.

The management system shown in FIG. 2 is composed of a main server 10, a database 25, a client system 55 corresponding to an agency or a sales office, and a mobile communication terminal 85. FIG. The database 25 stores CRM data, facility data, and topographical point data, which may have a data structure as shown in FIG. The user 90 accesses the server system 10 through the communication network 45 to request data and receive the requested data. The main server 10 may include a gateway along with a web server.

The main server 10 shown in FIG. 1 and FIG. 2 uses the data stored in the databases 20 and 25 to create a numerical map which is a basic element necessary for constructing a geographic information system. Numeric map means a map including roads, features, buildings, place names, water systems, etc., based on road networks and aerial photographs designed for the purpose of storing road-related information such as roads, signaling systems, and intersections. It can be classified into a topographic map containing information such as contour lines and building boundaries, and a branch map containing land boundaries and land number codes. Numeric maps consist of lines, circles, and faces, which are created using CAD and many other GIS tools, and usually share data in compatible formats such as DXF.

Numerical maps can be created by digitizing maps that have already been acquired by using the methods of obtaining data (Digitizing, Vectorizing) and scanning (Automatic). There is a new way to map.

4 is a flowchart illustrating a process of creating and editing a digital map database that can be used in the present invention. 4 centers on the process of creating and editing a digital map database of cadastral maps and road networks based on topographic maps.

The starting step 110 is followed by preparing 112 a numerical topographical map, map, road map, for example, purchasing an existing map. The map preparation step 112 includes a data acquisition process and a map production process. It is determined whether the prepared map is composed of vector data (114). If it is not vector data, it means that the prepared data is image data, that is, raster data, which is subjected to vectorization (116). Raster data refers to data in which a certain grid cell represents the location and value of data. It is the simplest data model, and the processing speed is very fast for nesting and proximity analysis. There is a difficulty in expressing. On the other hand, since vector data has a basic structure as points, and objects are represented by connecting points in a straight line, objects can be represented relatively accurately, and computational processing speed such as overlapping accessibility is relatively fast compared to raster data. There is this. In addition, there is an advantage that the vector data can be easily edited and edited by the mobile communication terminals 80 and 85.

The numerical map data used in the present invention is, for example, vector data having a structure as shown in FIG. The vector data 200 shown in FIG. 6 is composed of a base layer 210, a line layer 220, a point layer 230, and a coordinate layer 240.

In FIG. 4, when the data is vectorized or the data is already vector data, the feature feature is extracted from the topographic map and constructed as a database (118), the number attribute is extracted from the cadastral map and the database is constructed (120). Road attributes and traffic information are collected and built into a database (122).

Meanwhile, in parallel with steps 118, 120, and 122, overlapping the topographic map and the cadastral map and editing it based on the topographic map 124, overlaying the road network diagram on the edited data and editing the road location based on the topographic map 126 proceeds.

When the database construction and editing steps are completed, the drawing and the attribute data are linked (130). The attribute data is in the form of a table. For example, the attribute data may have a building name, a building owner name, a resident registration number of the building owner, and the like as data. The method of associating the drawing data with the attribute data can be largely divided into a combination method and a separation method. The combined method is to store and manage two types of data together in one storage location. In this case, no action is required for the association between the two kinds of data. Because the two kinds of data are already stored together and combined. On the other hand, the separation method stores two kinds of data in different places and manages them independently. However, two types of related data are stored in different places to be managed independently, and an identifier (key or identifier) is combined between the two types of related data so that two types of data for one spatial object can be managed. To combine.

In step 132, the drawings and the database are examined to supplement and correct the exaggerated, deleted or transitioned portions. In other words, if an error occurs in the inspection process 132, the process returns to step 118 or 124 along the path 133. If there is no error in the inspection step 132, the database for map data and attribute data is completed (134), and the completed data as final data is loaded (136) into the program to create and edit the numerical map database.

5 is a flowchart illustrating a process of creating and editing a digital map database used in the present invention. 5 illustrates a process of creating and editing a topographic map and an cadastral map based on a road network diagram. Steps 160, 162, 164, 166, 168, 17, 172, 180, 182, 184, and 186 and portions associated with the path 183 are the same as described above with reference to FIG. 4 and thus will not be redundantly described.

In FIG. 5, when the vectorization of the data is completed, the road network and the topographic map are overlaid, the road position is edited 174, and the parcel is overlaid and edited 176.

7 shows the overall flow of the management method according to the present invention.

The left process 285 of the figure shows the flow going in the main server, and the right process 287 shows the flow going in the client or mobile communication terminal. When the mobile communication terminal requests local terrain information (250), the main server receives the terrain information request (252). The main server retrieves local information that meets the requested condition from the national topographic information database 20, 25, and sends it to the client along the route 255 (254). On the other hand, if there is no local information corresponding to the requested condition, the request for re-request of the data is sent to the client along the path 272 (270). Upon re-request, the client may request again by changing the terms of the request for providing information.

The information provided to the client is displayed on the screen through the client's terminal (computer system or mobile communication terminal device) to show the corresponding region information (256). The client collects 258 sales activity and regional information and compares or retrieves it 260 with the displayed information. The client determines whether there is an error between the collected information and the received information and needs to correct the provided information (262).

If it is not necessary to correct the information in the determination step 262, the process proceeds to the end step 280, and if the correction work is required, the correction and edit work is performed (264). Editing and editing work is transformed into formal code according to a set of conventions. The formal code will be described later.

It is determined whether to transmit the modified edited data to the server (266). If necessary, the modified edited data is uploaded to the server (268). If no transmission is needed, the process proceeds to end step 280. The data uploading 268 is delivered to the server system via the path 274, and the server system 276 performs the decoding process 276 to store the modified edited data in the national topographic information database. The decoding process will be described later.

8 shows an example of a mobile communication terminal that can be used in the present invention. The mobile communication terminal shown in Fig. 8 uses, for example, a RISC chip of 199 MHz as the CPU and Windows CE as the operating system. The mobile communication terminal includes, for example, a 16M ROM in which an application program is stored and a 32M DRAM in which data is stored.

The mobile communication terminal includes a communication antenna 302, a port 304, a microphone 306, a shortcut key 308, a speaker 310, a scroll key 312, a touch panel 314, a touch button, and a control button. 316, a screen 318. The port 304 is, for example, a serial port such as RS-232C, and the screen 318 is a touch screen with a TFT thin film of 256 colors and a resolution of 640x480.

The mobile communication terminal has a built-in content converter. The content converter performs a proper conversion to the destination format regardless of the source format in the HTTP protocol, and may be composed of a rule / script, a script engine, and a markup language converter. The rule / script is a part for storing rules or scripts related to content reformatting, and stores information on user personalization and screen configuration of a mobile communication terminal device.

9 is a schematic diagram showing an example of a screen configuration of a mobile communication terminal that can be used in the present invention. The screen displayed on the mobile communication terminal may vary depending on the application program stored in the ROM and the data stored in the RAM. The screen 320 illustrated in FIG. 9 includes an edit button 330, a dot button 331, a line button 332, and a figure button (that are function execution buttons that can be used to modify and edit map information provided by a mobile communication terminal). 333, a DB call button 334, an execution button 335, and an end button 336. The regional map data displayed on the screen 320 includes a road in the east-west direction and a road 324 and a building 326 branched here in the north-south direction. On the other hand, the part where the error occurs as a result of the comparison between the information collected by the mobile communication terminal and the provided information is the road 327 and the building 328 indicated by dotted lines, and the mobile communication terminal uses the device to directly correct and edit the error occurrence data. do. The data edited and edited in this way is requested to modify data to the server system. The server system modifies and edits the database by decoding the data requested for modification.

10 is a schematic diagram illustrating a decoding process in a server system according to the present invention. The modification request data 350 sent from the mobile communication terminal may be, for example, a wireless transfer protocol (WTP) 352, a protocol 354 for a repeater, a TCP / IP 356, a log file 358, and data 350. Consists of WTP 352, protocol 354, and TCP / IP 356 are also referred to as headers. In the log file 358, a formal code code 370 corresponding to a content modified and edited by the mobile terminal using the terminal device is recorded. This code corresponds to, for example, Code 1-Delete, Code 2-Cut, Code 3-Extension, Code 4-Point, Code 5-Line, Code 6-Shape, Code 7-Execution, as shown in FIG. 10, The content 350 modified and edited by the mobile communication terminal is coded by a code 4-4-2-7-5-1. Receiving the log file 358, the server system decodes the code 350 contained in the log file 358 according to the standardized code code 370, and executes the edit editing of the same process as that performed by the mobile communication terminal. do.

Although the embodiments of the present invention have been described above with reference to the drawings, these are merely exemplary and are not intended to limit the scope of the invention. Those skilled in the art will readily appreciate that various modifications and variations of the embodiments shown in the drawings can be made without departing from the spirit and scope of the invention.

As described above, according to the present invention, since data can be directly modified and edited by the mobile communication device, data can be updated in real time and management based on more accurate information is possible. In addition, according to the present invention, it is possible to know at a glance the status of data to be managed by providing management data through a geographical distribution. In addition, the company uses the mobile communication terminal to transmit and receive data wirelessly with CRM functions such as location information, sales and management status of the company's dealerships and management targets, and existing retail store management and customer management. The sales status, management status, and order history of employees and facility managers can be transmitted in real time, and stored in the CRM database of the subordinate server such as regional distributors and the upper level server for planning and decision making.

Claims (14)

Digital mapping means for creating a digital map based on vector data, a database in which the digital map data, CRM data, facility data, and topographical data are stored, a means for responding to a request for providing information from a client, and data modification of the client A server device comprising decoding means for modifying and editing said numerical map data in response to a request; A mobile communication terminal requesting the server device to provide information, searching for information provided by the server device, and correcting and editing the error to send the data correction request to the server device when there is an error, The mobile communication terminal includes a content converter consisting of a rule / script, a script engine, a markup language converter, The modification request data transmitted from the mobile communication terminal includes a log file in which a standardized code corresponding to the edited edit content is recorded, and the facility management and customer management system using the digital numerical map and the mobile communication terminal. The digital digital map and mobile communication terminal of claim 1, further comprising a lower server that searches a database of the server device in response to a request for providing information from a client, retrieves the requested information, and provides the information to the client. Facility management and customer management system. According to claim 1 or 2, Facility management and customer management using a digital numerical map and a mobile communication terminal further comprises a gateway for converting the data processed in the server device and the data processed in the mobile communication terminal system. delete delete delete Creating a numerical map based on vector data, Accepting a client's request for terrain information, Searching for information that meets the requirements of the client and transmitting the searched information to the client; Displaying the transmitted information to a client; Comparing the displayed information with the actual information to determine whether to correct the information; If a correction is necessary in the determining step, the method includes a data modification request and a map data correction and editing according to the request. The numerical mapping step Preparing the map, Determining whether the prepared map is vector data; Vectorizing the non-vector data in the vector data determining step; Extracting attributes from the vectorized map and building it into a database, Editing and overlaying the map, Linking the drawing and the attribute data, Correcting and correcting errors by inspecting drawings and databases; Further comprising completing a database of map data and attribute data, The step of retrieving and sending information that meets the conditions requested by the client Sending a re-request of the data to the client and receiving the request for the changed condition from the client again. Facility management and customer management using digital digital map and mobile communication terminal characterized in that. delete The method of claim 7, wherein the extracting the attributes from the vectorized map and constructing them into a database includes extracting the feature features from the topographic map, constructing them into a database, extracting the numbering properties from the cadastral map, and constructing them into a database. Collecting and building the database into a database, characterized in that the facility management and customer management method using a digital digital map and a mobile terminal. The method of claim 7, wherein the editing of the map by overlapping the map includes overlaying the topographic map and the cadastral map and editing the map based on the topographic map, and overlaying the road network map on the edited data and editing the road location based on the topographic map. Facility management and customer management method using a digital digital map and a mobile communication terminal, characterized in that. The digital numerical map and the mobile communication terminal of claim 7, wherein the step of overlapping and editing the map includes the steps of overlapping road networks and topographic maps, editing road positions, and editing parcels by overlaying cadastral maps. Facility management and customer management method. delete The digital numerical map and the mobile communication terminal of claim 7, wherein the step of accepting the modification request receives data including a file in which a standard code code corresponding to the modified and edited content is recorded by the mobile communication terminal client. Facility management and customer care methods used. 15. The method of claim 7 or 13, wherein the modification editing step is to decode the standardized code code corresponding to the modification edited by the mobile communication terminal client to perform a modification edit of the same process as the modification edit of the client. Facility management and customer management using digital digital map and mobile communication terminal.