Academic Paper - Dextro Research
Contents
1. Then choose the table you want to alter by selecting it from the combo box Then a pane similar to the following appears hai Alter table add column x Please choose table to alter ID VID MYARKA MEOTKLONEN 001 IME_POSTRADAL TUJITEL Figure 7 Add Column To Table Dialog You can select the class of the new column of the table by clicking the lower combo box The most convenient way however is to click the Search button to search classes by class id class name or class abbreviation By double clicking the most appropriate found class the combo automatically changes its current item to this class Click Alter table to add the column If the nomenclature table has multiple records the operation might take some time Georgi Pashev lt Add Column To Table gt Page 9 USER MANUAL EMS RELATION USER MANUAL lt REMOVE COLUMN From TABLE Remove column from table Menu Item Then choose the table you want to alter by selecting it from the combo box Then a pane similar to the following appears sQLRelation All Please choose table to alter NMESTA ID KOD OBSTIMA KOD NASEL MYASTO NMESTA Figure 8 Remove Column From Table Dialog There are some limitations of this operation For example you cannot remove the main ID column and the main column of the table because this operation might affect the validity of data in some steps in some dossiers If the tab2. USER MANUAL EMS RELATION PREPARED BY GEORGI PASHEV DegxrRO RESEARCH LiTtp gt lt 19 06 2013 gt USER MANUAL EMS RELATION USER MANUAL TABLE OF CONTENTS lt OVERVIEW gt 2 lt VISUAL CLASSES SEARCH ENGINE gt 3 lt DATA IMPORT FROM TEXT FILE gt 4 lt TABLE CREATION gt 6 lt DROP TABLE gt 8 lt ADD COLUMN TO TABLE gt 9 lt REMOVE COLUMN FROM TABLE gt 10 CONSTRAINT MANAGEMENT 11 DATA MANIPULATION DIALOG 13 PREPARATION FOR NETWORK COMMUNICATION WITH BROKER 15 SEND TABLES TO BROKER 16 RECEIVE TABLES FROM BROKER 17 Georgi Pashev Indexes Page I USER MANUAL EMS RELATION USER MANUAL OVERVIEW gt administrator to create develop and debug sqlite tables nomenclatures as well as automate sqlite database object management in the convenient environment This sqlite front end provides utilities to compare synchronize and backup sqlite database with scheduling and gives possibility to analyze and report sqlite tables data It supports synchronization of nomenclatures with those in a centralized broker when started in Network Communication Mode ix EMSG Relation x File Tables Constraints Import Cloud communication FO Search classes J kc Figure 1 Main Screen of EMS Relation Some of the supported features are Version Control and Synchronization with EMS Broker Visual Table Data Manag
3. Table dialog If you intend to import data in the previously created table SEX the text file with the import data must be named SEX dat By clicking Georgi Pashev Data import from text file gt Page 4 USER MANUAL EMS RELATION USER MANUAL Choose File button you can select the path to the file Then you must choose the columns separator The next obligate step is to select the encoding of the file For example if you created table sex with columns SEX_TEXT SEX_CODE Table SEX SEX CODE SEX TEXT Figure 4 Example import table then you must change the order of the columns in the import file SEX dat An Example SEX dat would be MALE 001 FEMALE 002 As you can see the first column in the file is SEX TEXT and the second is SEX CODE Georgi Pashev Data import from text file gt Page 5 USER MANUAL EMS RELATION USER MANUAL lt TABLE CREATION gt item Then a Create table dialog appears where you must enter the number of columns in the new table and table name The table name must consist of only capital Latin letters and _ symbol When you have already entered the number of columns and table name click View Fields Button A dialog like this appears I mo sQLRelation All x Change sort order Table name SEXX foretankeys Ld Main Column 181 72 CHASA Y 2 Foreign Key Column 181 72 CHASA Y 2 Foreign Key Create Table Fi
4. you want you can deselect some of the selected tables Click the button Send Tables To Broker On successful completion all your new tables will be sent to broker and on next load of the same dialog the tables that you have already sent will not be automatically selected Georgi Pashev lt Send Tables to Broker gt Page 16 USER MANUAL EMS RELATION USER MANUAL lt RECEIVE TABLES FROM BROKER Communication Receive New Tables From Broker I x Update x Please review selected tables For update Update Log Building list of tables Figure 15 Receive Tables From Broker Dialog The Receive Tables From Broker Dialog loads with a list with all of your remote tables which has all tables that should be received from broker already selected The Cloud Communication Subsystem of EMS Relation has its own version control system All tables without local Broker version information or tables with lower local version than remote are automatically selected for Update If you want you can deselect some of the selected tables Click the button Receive Tables From Broker On successful completion all your new tables will be received from broker and on next load of the same dialog the tables that you have already received will not be automatically selected Georgi Pashev lt Receive Tables from Broker gt Page 17
5. Addr gt lt PortNumber gt 9999 lt PortNumber gt lt BrokerInfo gt lt CurrentLanguage gt English lt CurrentLanguage gt EmsglIni Figure 13 Example content of emsgini xml configuration file IPAddr tag contains the IP address of the broker Port Number contains the Client Service s Server Port of the Broker In order the changes to take effect restart EMS Relation In order to proceed you must select your department and type your username and password if you are a department administrator or select Cloud Admin Department from the Departments List if you are a Cloud Administrator On successful login the main form of EMS Relation appears Georgi Pashev Preparation for Network Communication with Broker Page 15 USER MANUAL EMS RELATION USER MANUAL SEND TABLES TO BROKER Communication Send New Tables To Broker hd Update x Please review selected tables for update DLAJNSL DOKKOMP ETNOS FL UL GOAL Send Tables To Broker Update Log Building list of tables Figure 14 Send Tables To Broker Dialog The Send Tables To Broker Dialog loads with a list with all of your local tables which has all tables that should be sent to broker already selected The Cloud Communication Subsystem of EMS Relation has its own version control system All tables without remote Broker version information or tables with higher local version than remote are automatically selected for Update If
6. I BYPTACKA OBJIACT BAPHEHCKA OBJIACT JIOBELLKA OBJIACT MIHXAPUIOBFPAJICKA OBJIACT Seba anm OBNACT Change sort ora Figure 12 Data Manipulation Dialog Georgi Pashev lt Data Manipulation Dialog gt Page 13 USER MANUAL EMS RELATION USER MANUAL To manipulate the child most table in the hierarchy you should first select the value of the parent tables current items and click the Next gt button The current table in the hierarchy is underlined as shown in figure 12 You can change update insert delete any record anywhere in the hierarchy by clicking the corresponding buttons after entering the data in the fields If you change a base table base column of a hierarchical foreign key you will get a cascade update warning for the child table The deletion process is similar The main column of the table is shown above the list widget which shows all records main columns values All other columns and their data manipulation fields are below it The button Change sort order changes the order from alphabetical to ID ordered or vise versa Georgi Pashev Data Manipulation Dialog Page 14 USER MANUAL EMS RELATION USER MANUAL lt PREPARATION FOR NETWORK COMMUNICATION WITH communication mode To do that you must put a file in its directory named emsgini xml with the following example content EmsglIni lt BrokerInfo gt lt IpAddr gt 127 0 0 1 lt Ip
7. ement insertion deletion update Visual Table Meta data Management visual creation add remove column constraint management Data import from text files Visual Classes Search Engine Cloud communication feature Nomenclatures synchronization Georgi Pashev Overview Page 2 USER MANUAL EMS RELATION USER MANUAL lt VISUAL CLASSES SEARCH ENGINE gt class to use as a table column The class name and class abbreviation of each class are searched and class matches are displayed Search classes Figure 2 Classes Search Engine The Classes Search Engine is quite useful when called from within Create Table Visual Module to search classes for a table colums By double clicking the most suitable class in the Classes Search Engine Results pane the class is automatically selected to be the class of the column Georgi Pashev Visual Classes Search Engine Page 3 USER MANUAL EMS RELATION USER MANUAL lt DATA IMPORT FROM TEXT FILE gt You can trigger the Data Import Module by clicking Import Import Text Data from the menu The dialog of the module appears sQLRelation All x Import m BENE Choose calumn Separator Queries to be imported windows 1251 Apple Roman Select encoding Big5 Big5 HKSCS Create insert queries Figure 3 Data Import From Text File Dialog Before using this functionality you should first create the table by using the Create
8. gure 5 Create table dialog For each column of the new nomenclature table you should have an appropriate class already created with the Class Editor It s quite convenient to use the Search Classes Module by clicking Search button on the rightmost side for each nomenclature column The Main Column of a nomenclature table is the column that is going to contain the text of the combo items in the dossier s steps if this table is used as a combo table in the combo item s class and this is specified by using the Class Editor You can specify that a column is a foreign key to an already created nomenclature table by clicking the column s Foreign key checkbox and then selecting the foreign key base table and its column to which the foreign key points It s a good practice to have the same class for the foreign key column of Georgi Pashev Table Creation gt Page 6 USER MANUAL EMS RELATION USER MANUAL this table and the base column of the base table If so the combo of the base column will automatically select the column of the appropriate class in the base table You are not obliged to create the foreign key constraint right now You can always add this constraint by using the constraint management pane later The hierarchical nomenclature sequence of tables for example COUNTRIES REGIONS CITIES STREETS causes the insert change delete record dialog of this program to act accordingly When you select Great Brita
9. in and click Next only the Regions of Great Britain will appear This hierarchy is also observed automatically in the Client Runtime environment If for example user has already selected the current Country from a Combo in the current step or in a parent step and whenever the user triggers the combo of regions only regions in the selected country will appear Georgi Pashev lt Table Creation gt Page 7 USER MANUAL EMS RELATION USER MANUAL lt Drop TABLE item A Drop Table Dialog appears I x SQLRelation_All x Please choose table to drop Figure 6 Drop Table Dialog You must choose the table you want to drop and then click Drop button There are some limitations for this operation For instance you cannot drop a table that participates in a hierarchy as a parent table a table that contains a base column to which a foreign key points before first dropping the child table Another limitation which is not strict is when the current table participates in a combo class as its table If you delete such a nomenclature table it s quite possible to have problems displaying data in combos in steps designed to use this nomenclature table Warnings of eventual problematic drop is displayed as soon as you Select the table to be dropped from the combo Georgi Pashev lt Drop Table gt Page 8 USER MANUAL EMS RELATION USER MANUAL lt App CoLuMN To TABLE Column To Table menu item
10. le participates in a hierarchy and the column you want to remove is a child or a parent column in the hierarchy you cannot remove it either You must break the hierarchy first by using the Constraints Management Dialog Georgi Pashev Remove Column From Table Page 10 USER MANUAL EMS RELATION USER MANUAL lt CONSTRAINT MANAGEMENT Constraint Management Menu Item Then choose the table you want to alter by selecting it from the combo box Then panes similar to the following appear sQLRelation All x KOD_OBSTINA KOD_NASEL_MYASFe KOD_NASEL_MYAS KOD_ULICA ULICI LSS SSS a ae eee ere ee Figure 9 Graphical Relational Representation of Tables Dialog sQLRelation All x Please choose table Update unique constraints NMESTA T UNIQUE Foreign key Not Null column names Remove this Remove this Remove this Add KOD NASEL MYASTO J E NOT NULL KOD_ULICA al NOT NULL ULICI ve RN a M NOT NULL Remove selected Figure 10 Constraint Management Dialog Georgi Pashev Constraint Management Page 11 USER MANUAL EMS RELATION USER MANUAL The types of constraints you can manipulate by the Constraint Management Dialog are FOREIGN KEY NOT NULL UNIQUE For each constraint for the table new constraint column in the dialog appears As you can see in the example there are 3 constraints for the table UNIQUE colum
11. n FOREIGN KEY NOT NULL for the column ULICT You can add a constraint by clicking the button Add You then click the button of the constraint to change its type Then you must specify the properties of the constraint If the constraint is of type Foreign key select the base table of the foreign key in the uppermost combo of the column Then for the corresponding column of this table ie the corresponding row of the dialog select the parent column of the foreign key constraint If the constraint is NOT NULL or UNIQUE then check the corresponding combo box or combination for the constraint Combinational constraints are supported The Graphical Relational Representation of Tables Dialog shows partial Entity Relational Model of the Nomenclatures Database concerning the current table The table with yellow background is the current table If there are foreign key constraints in the table the base tables of those constraints are also displayed with white background The column with blue background is the main column of the table The column with the key is the primary key ID column which is automatically added to the table in the process of its creation In terms of the EMS Project there are two distinct types of foreign keys hierarchical and class defined Hierarchical foreign keys form a hierarchy of nomenclature tables for example Country Regions in Country Cities in Regions etc This foreign key type is specified using the EMS Relatio
12. n Tool The class defined foreign keys are defined by the Class Editor Tool When you create a class by using the Class Editor and you specify that it is a combo class and specify its class table you create a class defined foreign key opportunity When you use the class as a column class of a table in EMS Relation Tool you create class defined foreign key Both of the foreign key types are displayed in the Graphical Relational Representation of Tables Dialog The main difference between those two foreign keys is that the Class defined Foreign Keys are not used to form a hierarchy in The EMS Client Runtime Environment and the EMS Relation tool Georgi Pashev lt Constraint Management gt Page 12 USER MANUAL EMS RELATION USER MANUAL DATA MANIPULATION DIALOG gt Dialog or by clicking the corresponding item in the toolbar It has a built in hierarchical functionality For example if you choose to manipulate data in a streets child table you must first choose the city if such a hierarchy exists Choose the table you want to manipulate by selecting it in the combo box If the table is a child table in a hierarchy the whole hierarchy is shown above as shown x o Select Table Table Hierarchy OBLAST OBSHTIMI NMESTA ULICI Table name ULICI Figure 11 Automatic Hierarchy Recognition and Display Click OK to prog ee A dialog like this appears SQLRelation All x OBLAST OBSHTIMI NMESTA ULIC
Download Pdf Manuals
Related Search