Control of the external database

 Top Next

The management system of the user Database is a component of system of the GIS Panorama and is intended for work with the data stored in separate databases tables on a local or network disk drive. It works with databases dBase, MS SQL, MySQL, PostgreSQL, Oracle. The external database can contain the attributive information about map objects in addition to its semantic characteristics. Database allows to structure, store and process the data of various type by means of creation of the user projects.

Database project (DB Project) it is an aggregate of the separate data tables, ways of their displaying and editing. The content of the Project of DB is saved in file: "Project filename.DBX ". For a concrete digital map several DB Projects can be created. With a concrete map only one DB Project simultaneously can be processed.

The basis of the DB Project is the user-generated list of database tables. The user himself defines (customizes) the interrelation character of the tables from this list, indicates the subordinate (Detail table) and controlling (Master table) tables and fields by which one the link takes place.

There are two possibilities for review and editing of the tables contents of a DB:

- With usage of the Standard Form (SF), which one displays the table data as a standard grid with possibility of their editing and execution of search functions.

- With usage of the User Form (UF). UF allows personally for each table to define the order of displaying and information processing using a set of visual components.

To activate the task of the Database control it is necessary to select Base Administrator item from DataBase menu. The database is controlled by panel (Tools panel item of DataBase menu), which one is placed after its activation at the bottom of the  main system window and is named the Main panel of Database. For task termination Base it is necessary to switch off the sign of activation of the Tools panel from DataBase menu.

On the Main panel the following controlling buttons are located:

ici_9083 - Open project of a DB

ici_9084 - Close project of a DataBase

ici_9085 - Show or hide form of DataBase Administrator    

ici_9086 - Hide the current active forms (or to show earlier hidden)

ici_9087 - Show or to hide Standard form

ici_9088 - Search of user's form for selected object

 

The main panel of a DB can resize and can be displaced into any place. Its main assignment is access to the Administrator of a DB.