Server aphplications

Program of monitoring a database and maps updating

Program of monitoring a database and maps updating is designed to process and synchronize spatial data contained on a digital vector map and stored in various databases.

ФорумForum Как купитьHow to buy Скачать последнюю версиюDownload the latest
Скачать документациюTo download

Program of monitoring can be performed in the following modes:

  • update of digital map by the information from the database;
  • update of information in the database on the basis of digital map's data.

Updating the information on the map or in the database is carried out automatically in synchronization with changes in this information on the source - in the database or on the map, respectively. The program can perform data updating in synchronous and asynchronous modes. The program contains tools for customization onto various table structures and formats of fields with the coordinates and properties of displayed objects.

The updated thematic maps can be made available to users via the GIS Server or GIS WebServer to organize a graphical interface for accessing databases.

By means of the Program of monitoring a database and maps updating, carried out in a mode of updating of the information in a DB according to a digital map data, it is possible to use any GIS working with maps of a format "Panorama", as a universal tool of visual editing the spatial information stored directly in a database.

The program implements the technology of external storage of cartographic information from the database in the form of a separate digital map. Unlike existing technologies of displaying cartographical data directly from the database, the presented implementation allows to provide direct access to a map without accessing the database, when thiggs is not required. The map can be accessed by users on the local network, it can be accessed for "thin clients", it can be sent by e-mail as an attachment, etc. In addition, the time for displaying cartographic information is significantly reduced. So, for example, for a map containing about 1000 000 objects, at displaying directly from the database several minutes are required, while visualization of the same map, stored separately, requires several seconds. Updating the data by means of the monitoring's program can be done both at a time if necessary, or in automatic mode with a specified time interval. There is also available the function of external management by the Program of monitoring by means of parameterized queries executed from the command line.

The program for monitoring the database and map updating while performing data synchronization operations in cyclic mode (by timer) can "pick up" the settings file without stopping the process. If the settings have changed (for example, the administrator made changes to the settings file or substituted it), the program will automatically recognize it and apply the new settings from the next iteration of the data update.

It is possible to process spatial data in the Base in two variants:

  • in a tabular form (a separate point of metric is a separate row of the table, each coordinate - latitude, longitude, height, - in a separate field);
  • in a separate field of the table with type of data OpenGIS Spatial (all metric of object is recorded into one field according to standards of Open GIS Consortium).

This version of the program provides work with the following databases:

  • Interbase / FireBird;
  • Microsoft Access;
  • Microsoft SQL Server;
  • Oracle (including Oracle Spatial).

It is possible to connect to any database using a configured ODBC connection (dBase, Paradox, Microsoft Excel, Linter, PostgreSQL, etc.).

The task of placing spatial information in a database is actual for many modern systems. A promising solution in this direction is application of technology of storage of the spatial information with use of the built-in GIS-subsystem of the DBMS itself. Such subsystem allows to store the spatial description of object in the field of a special type. Granting of access to such data and their processing is carried out on the basis of generally accepted standards approved by the Open GIS Consortium. For work with the spatial databases, constructed on the specified technology, the program Panorama SpatialDB Service is intended. The program of monitoring a database and map updating allows to process the metrics of objects placed in a DB in a tabular form.

Program of monitoring a database and map updating allows:

  • to synchronize the spatial and attributive information in the database and on a map, both at a time and in automatic mode with a specified time interval, or at the scheduled time on the specified days of week;
  • to carry out updating of all map of monitoring entirely, or only of objects, information about which in a database has undergone changes;
  • to monitor the change of data on spatial objects on the digital map, both at a time and in automatic mode with a specified time interval;
  • to carry out updating the information about spatial objects in a database on all map entirely, or only on those objects which have been changed on a map;
  • to map objects from the database by coordinates in the specified coordinate system;
  • to save a spatial description of map's objects into the database in the specified coordinate system;
  • to save a certain information about objects from the database into the map;
  • to fill certain fields in a database with values of semantic (attributive) characteristics of a map's objects;
  • to set the external view (conventional symbol) from the map classifier for a group of database objects;
  • to write down into a database the predetermined values corresponding to the external view (conventional symbol) of object on a map according to the table of recoding;
  • to save monitoring's settings for each specific case in separate files with the possibility of their subsequent reboot;
  • to carry out a running onto execution with that or other file of monitoring's settings, specified as a command-line parameter;
  • to log the monitoring process and view the protocol with the ability to filter records, and also to save the protocol into the specified file, to restore it from the file, either by command or automatically at startup or shutdown of the program.

Information about objects is provided by a database to the program of monitoring in the form of tables or representations. Presence of three such tables or representations is provided:

  • table (representation) of the object description;
  • table (representation) of the object metrics;
  • a table of accounting for changes in the monitoring's object (change log).

The table of general information contains the data of descriptions of monitoring's object which at its mapping will be presented in the form of semantic characteristics. In the same table, in a separate field, you can specify a certain type of object - the characteristic of the object that affects its external view on the map.

The metrics table is intended directly for providing the access to spatial information of the updated objects for the Program of Monitoring. There are two options for placing spatial data (object coordinates):

  • in a tabular form (a separate metrics point of the object is entered in a separate row of the database table, where for each coordinate - latitude, longitude, height, - a separate field is provided);
  • in a separate field of the table with Spatial data type (the entire metric of the object is written into one field according to the Open GIS Consortium standards).

At placing the spatial information on objects in the form of the table of coordinates of points, there are supported the coordinate systems of 42 year, WGS84, PZ-90.

Tabular view of metricsThe metric in the form of Spatial (OpenGIS)


The change accounting's table is designed to register changes to objects to display them on the map. The table of changes account is intended for registration of changes of objects for their displaying on a map. In case the use of this table is allowed in the monitoring's program settings, only those objects of monitoring whose changes are registered in the changes table will be edited on the map.

At working with spatial data in Oracle Spatial format there are the restrictions:

  • the following types of object metrics are supported: point, vector sign, simple line, simple polygon;
  • only the coordinate system WGS-84 (latitude/longitude in degrees, Oracle SRID=8307) is supported;
  • work with Oracle Spatial is possible only for reading from the Oracle database and is not available in the monitoring's mode "Map> Database".

For the monitoring's mode in the direction "Map> Database" it is necessary that interface tables or views in the database ("Object description table" and "object metric table") were accessible not only for reading, but also for writing.

Automating launch of multiple copies of the program

One copy of the monitoring's program at a time can synchronize with the map only one set of data and only in one direction. For mutual updating of data from several digital maps with several data sets in one or more databases, it is necessary to run several copies of the program with different settings. The number of required copies of the monitoring's program is equal to the number of bundles the «Map - Data set» performed in one of the monitoring's directions.

To automate the launch of multiple copies of the Program of monitoring simultaneously, a list of these copies is created using the Launch Manager program included into the software package. Launching the programs included into the data list can be carried out either directly from the program of the Startup Manager of the Program of monitoring or by a special service from the program complex of the Monitoring's Program. The service carries out starting the copies of programs under the list at operating system start even if the user does not log on to the system.

Added into the list of automated startup the copies of the Program of monitoring should already be completely configured for connection to a database and a map and for execution of process of data synchronization between them. Thus, the executable file itself (db2map.exe) can be one for all started copies, and the configuration file and the job log file must necessarily be personal for each copy.

Appearance of the Startup Manager
of the Program of monitoring

Buttons assignment of the main menu
of the Startup Manager

Work in a mode of System Service

System Service carries out starting the copies of programs under the list at operating system start even if the user does not log on to the system.
The list of copies of the Program of monitoring of a Data Base and maps updating to be automatically launched is generated by the Launch Manager (see above).
The service is managed from the standard operating system console.

System Services Operating System Management Console

When the service starts, it carries out running all copies of the Program of monitoring according to the list previously prepared in the Startup Manager of the Program of monitoring a database and maps updating. When the service is stopped, it sends out a command to shut down all running copies of the Monitoring Program, waits for some time to allow the copy to complete its work independently, and then forcibly stops the process within which the instance is executed.

Remote monitoring of the work process

Each copy of the Program of monitoring maintains its own work log, which can be saved to a text file at a specified periodicity. By providing remote access to viewing such protocol files, the user can remotely monitor the process of the program's work. Access to the work logs of the Monitoring's Programs can be organized both as file access in the local network and as publication on the Internet, for example, using IIS or Apache web servers.

Customizing an interval for saving the log file
of work of the Program of monitoring

Remote viewing the logs of the Program of monitoring
through the Internet using a standard web-browser.