user documentation
Contents
1. lt nove tabulkyfdobazy gt MSysaccessObjects Movs ES a MSysoueries MSysRelationships Tabulka1 tmp 0121811413 Seznam f Ufivatel Skupiny Typ objektu tabulka Opr vn n I otevir n i spou t n w ten dat W Zobrazen n vrhu Aktualizace dat Zm na n vrhu vkl d n dat Spr va Odstra ov n dat Stoma Poueit e Try to connect again2. Knocker main application User manual Author Jaroslav Tykal Application Knocker exe Document Main application Page 1 18 p M KNOCKER Content 1 STRI NTN 3 1 1 EMNE 3 1 2 MD NNN NN 3 2 CONNECTION TO PT NE aires ciecercnscecraaeicwes na oer TN EOE ENNO EO Ea EERTE a N n S 4 21 MANAGE DATABASE CONNECTIONS sanere REEE A AEN e 4 LLL TANN 4 22 AMDAM Nr 5 LEN 5 2 2 2 Sample ODBC connection for MySQL rennrvrrvvnvnrrvvnevnsnrnennsnrnvvnsnenvvnsvnsnvnsnnsnrnsvesvrssvnsnassvnsnasvrnsvasvensvesvene 6 2 3 Mor 6 2 4 SPTOTHERCONNECHON AS SETE cee rv al ana a a F 2 5 ADD SUPPORT FOR UNKNOWN ODBC DRIVER sssosssicsesesachendsoanaacudssoiatesscbcsadasacbondeedweesssaaesakecaancaabbencacalsssoaasieae 7 D Chaos NNN 7 3 MANAGE MODULES de 10 3 1 MANAGE MODULES METODO EE EE 10 3 2 TIN 10 EE 11 EE O O O E A E 11 4 MAIN APPLICATION WINDOW sessoseossssossosossoscososeosessoscosossoseosossosessoseosossoseososeosossossosossossososeosessossosos 12 41 IV NO oh OPPA E pas O O O O 12 TN 12 AEE 0 EEE ME R O KEANE EEE KE O O ER EA TN 13 MOE 14 4 2 BONN EDA n 6 PPR E ace E vce E ee ceca nec O O tee TA 14 4 3 NNM 14 4 4 PROC DORT ER EE EE P O 14 44 1 Create new version of data rrrrrrrrrnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnusnsnnnnnnnnnenvnvnunneneeeesssenennnneesevvnvvnne 14 GE GORE EE O rr rt Tre 15 21 Apply Ter 15 444 Apply simple transformations on other version ssrrvnnrnrnvvnrvrnnvnrnernvnevesnen
3. Split table b Click on Apply button Steps a and b can be repeated more times z Save data as new version 2 Save transformed data as a new version Save data as new version To save your transformed data click on Save data as new version button Enter the name for this version in the dialog New version name gt Enter new Version name Save Don t save Confirm the name by click on Save button New version will be hanged below the source version Note e Some transformations can invoke Save data as new version immediately after finishing their work These transformations usually create more than one data version 4 44 Apply simple transformations on other version Prerequisites e version is created by simple transformations application e another version exists 1 create a version using simple transformations 2 click right mouse button on this version and then select Copy transformation from context menu or open item in menu Version gt Copy transformation 3 select version to which the copied transformation should be applied and then select Apply transformation from context menu or select Version gt Apply transformation in menu Apply transformation can not be applied to the version with different columns This version must have the same columns name simple type as the starting version from step 1 4 4 5 Run data mining method Prerequi
4. 4 Confirm by pressing Create button Note Format of CSV file e the first line contains a name for each column e the second line contains simple type for each column o Simple type is one of values INT integer DOUBLE number with decimal point STRING text with length up to 255 characters e each next line contains data o empty column is interpreted as null value Sample of CSV file Column1 Column2 Colum3 INT DOUBLE STRING 1 1 5 the first line 2 the second line 4 4 2 Drop version Prereguisites e version which should be dropped exists User can drop a version in two ways e To click the right mouse button on the version and select Drop from context menu e To select the version and choose Version gt Drop selected version from Menu 4 4 3 Apply simple transformations Prereguisites e one version is selected e atleast one simple module is loaded Simple transformations may be applied repeatedly Application is switched to Edit mode after the first usage of Apply button for selected version It is possible to apply simple transformations in this mode Changes on data are shown in DataGrid If Knocker application is in the Edit mode then description Data from version called contains both the version name and EDITED by Simple transformation note EG 1 Select and apply simple transformations a Select exactly one transformation from the list of all transformations Normalization
5. kter chcete vytvofit zdroj dat konfigurovat Microsoft Text Driver tat cev Microsoft Tesxt Treiber txt cz Microsoft Visual FoxPro Driver Microsoft Visual FoxFro Treiber pi MySQL ODBC 3 51 Driver Oracle in OraHomed2 PE MERANT DEM 3 70 32 BIT Btrieve dta sobu p ipojen k FE MERAMT OEM 3 70 32 BIT DB2 at m ete vid t FE MERANT OEM 3 70 32 BIT dBASE File dbf Pe PE MERARIT OF hd 2 70 AET Forakilarkkoab 15 uzit N pov da 5 enter Data Source Name this Data Source Name is used as the connection name in Add new connection dialog in Knocker application MySQL ODBC 3 51 Driver D5N Configuration Yersion 3 51 06 This dialog helps vou in configuring the ODBC Data Source Name that you can use to connect to MySQL server DSH Information Data Source Name TestDSN Descriptions MySaL ODBC 3 51 Driver DSN MySQL Connection Parameters Host Server Mamelor IF fiecalhost Database Name E User Password Port if not 3306 3506 SQL command on connect Cancel Options gt gt Test Data Source 2 3 Remove connections Each connection has a check box in Manage database connection dialog All checked connections will be removed after pushing the Remove selected button N zev dokumentu Main application Str nka 6 18 38 2 4 Set other connection as work There is a combo box with all defined connections in Manage database conne
6. of work connection during the start initializations If there is no valid work connection application can t connect using this connection the application will show dialog to manage connections Detail information is included in chapter Manage database connections 1 2 Module definition We can use two different types of modules e Simple transformations data transformations It is useful for preparing of data E g normalization null values replacing splitting data from one table into more tables etc e Normal transformations we call them methods these modules visualize the work of selected Data mining methods E g Neural networks Market basket analysis Decision trees Kohonen maps The transformations of the first type are additive More transformations of this type can be reapplied to similar data The transformations of the second type haven t got this facility they are not additive Methods implemented visualization of algorithm instead EG 2 Connection to database All database connections use ODBC driver ODBC driver should be installed on computer for each database you intend to use Application was tested with these ODBC drivers e Microsoft ODBC driver for Oracle e Oracle ODBC driver e MySQL ODBC 3 51 driver e Microsoft ODBC driver for Access e Microsoft SOL Server 2000 It is possible to enlarge this set of databases by modification of configuration file More info is in chapter A
7. Browse Runnable Neuametstt O0 Description Neural network O0 Type Nm ID ME Cancel EG 3 2 1 Items e Path at the beginning it is necessary to select a DLL containing desired module User can find the DLL file by browsing Browse button e Class to run when program reads selected DLL library a list of all classes accessible in DLL is shown As a next step user selects class which is used as a starting point of the method You can find name of this class in documentation of each module e Description This text will appear in main application menu for normal data transformations or in main application combo box for simple data transformation e Type Simple transformations without visualization support or normal e ID should be unique for each module N zev dokumentu Main application Str nka 11 18 E KNOCKER 4 Main application window Main Version Methods Help Del S pa The first table E The second table SE The second table normalized io The thid able Data trom version called The second table normalized blabla O 233333333 blif 0 333333333 abc 0 533333333 O GEGGGBGEE O SEGGGBBEE 1 ode efg fidksf wiwidstdsfstd Choose simple transformation Apply Save data as new version Capabilities e Version tree o reading data into version tree o dropping version and all its subversions fro
8. bed near each element description Each of following elements are mandatory and occurs exactly once in each database element Element lt showTables gt e Shows list of all tables for connected user No variables are available Element lt alterTableModify gt e SQL statement for type of column modification Available variables are o TableName name of the table o ColumnName name of the column o ColumnTypeNew new database type of the column Element lt alterTableAdd gt e SQL statement for inserting column into the table Available variables are o TableName name of the table o ColumnName name of the new column o ColumnType database type for the new column N zev dokumentu Main application Str nka 87 18 EG Element lt alterTableRemove gt e SQL statement for removing one of existing columns from the table Available variables are o TableName name of the table o ColumnName name of the column to remove Element lt alterTableRename gt e SQL statement for renaming of the column Available variables are o TableName name of the table o ColumnNameOld old name of the column o ColumnNameNew new name for a column Element lt dropTable gt e SQL statement for dropping of the table Available variables are o TableName name of the table If there are multiple drivers belonging to one database and these drivers have the same set of SQL statements then they can be placed in one shared Databas
9. ction dialog Select work connection furtas TestUrtax OF Cancel Choose one of the connections and confirm by clicking on OK button 25 Add support for unknown ODBC driver ODBC interface may differ for some types of queries or databases E g list of all tables all databases don t use the same data types etc That s why it is necessary to make mapping between SQL statements and corresponding database This mapping is in a configuration file sqlStatements xml Application can find out only driver name from the database connection In practice more databases can be managed by one driver DLL library 2 5 1 Changes in configuration file User must do these steps after insert of unknown for application driver 1 obtain driver name DLL library with new ODBC driver 2 modify configuration file sglStatements xml with SQL statements and data types 1 obtaining a driver name In Windows Start gt Controls panel gt Administrative Tools gt Data source ODBC gt Drivers Each driver has information about relevant file with Driver 2 modification of the configuration file Each record in element database contains a definition of one database and one or more drivers Each database object may refer to more than one element database in the configuration file This usually happens when a driver is interface for more databases Application finds the first database name in which the driver corresponds Then t
10. dd new type of ODBC driver Information about defined connection is stored in configuration file connections xml Warning Defining appropriate database as the work connection may affect time of processing We recommend using of MS Access just as a data source do not use it as database for work connection 2 1 Manage database connections Manage database connections gt gt Short description Connectionsting state O DSN TestMSSOL Walid SQILSAY32 0LL Bt d er Per Or nt Remove selected Select work connection mssql MS SQL v OK Cancel OK Cancel 2 1 1 How to show this dialog e This dialog will be shown automatically if no valid work connection exists e main application window menu Main gt Database connections Each database connection contains e Description description for user e Short description this description is shown whenever user displays a connection or a table connection e g in combo box for select tables e Connection string connection string which is used to connect to database e State current state of database connection This item can reach one of the following values o Valid connection is correct o SQL Error connect is correct but SQL query for obtaining a list of all table names failed This error is typical for wrong permission settings on database system tables o Broken it is impossible to connect to database Nazev dokume
11. ds This command shows a dialog to add remove modules Each normal module is shown as an item of this menu This item is responsible for corresponding module start Context menu Context menu for the Tree View Control has the same menu except Add new version items as you can find in Main Menu menu Version 4 3 4 4 4 4 1 Simple transformations Selection of all simple transformations Push the button to apply selected transformation APB Save data as new version Save modified data as a derived version Save data as new version Procedures Create new version of data New version can be created from the following types of data existing database table from defined connection file in CSV format format described below da 1 Run dialog for a new version creation This can be done by clicking on rel or by choosing an item Version gt Add new version from menu ae iol x New version name Data from fr databaze T able name file File name Browse Create Close E 2 Enter a new version name This name will be shown in the version tree 3 If our version should be created from table then select database and table from the combo box There are only names of the tables which do not contain any space in their name If version should be created from a CSV file then user finds the file using Browse button or writes file name directly into the text box
12. e element Drivers for different databases should always be placed in separate Database elements although the set of SQL statements for all the drivers is identical This rule keeps the configuration file well arranged and readable for human Nazev dokumentu Main application Stranka Y 18 ren R KNOCKER 3 Manage modules Both types of modules simple transformations and methods can be loaded to application in the same way Manage modules dialog 3 1 Manage modules methods How can user show this dialog From main windows menu Methods gt Methods Information about each module ID helps differentiation among methods Each method must have unigue ID Description This text will represent this method in lists of all methods Type type of method o simple simple transformations for simple data transform o normal more complex methods which support visualization Class to run name of the class which is used to run module DLL Path location of DLL library with method Manage modules dd Description Type Runnable class DLL Path 10 Neural network normal Neural et bart DM BPHetwork di 1101 Normalizations simple Form orrnalzation Simple T ranstorms dll Remove selected DE Cancel Capabilities Add method Remove methods 3 2 Add module In Manage module dialog click on Add button Add new module i Path C Documents and Settings Jaroslav Tyka
13. evnsnenvvnsnersvnsvesnrnsvesvessvesvene 16 AAS Run data MNS MENO NE EEE EE nar envy rrr mr rete 16 TG NN 17 44 7 CreateneWw SESSIO oessasssnscescvenecedtnsieansanoesonsunevtiscaseaneupuseddancamenvsadncwuntswidnesieuauendbawcstensboxseseetsuaveevensenesbeansacaus 17 5 SOLUTION OF POSSIBLE PROBLEMS ccccscscscscsccccccccsccsccccscccsccscccscccccccsccccsccscccccccccccccccecccsccsccccsccsesces 18 5 1 CAN NOT CONNECT TO MS ACCESS DATABASE SQL ERROR csssccesseeeseeeeeeesseeeesaeeesaeeesaeeesaeeesaeeesaeeeas 18 Document Main application Page 2 18 ae 1 Start application For a correct running of the application is necessary a to define a connection to database b to define modules which work with data and visualize data mining methods 1 1 Connection to database It is necessary to define a connection to database at the first application run This database will be used as data storage The database connection is always called work connection Data storage will contain all versions of all sessions Each version contains either a copy of existing table or data imported from CSV file or modified data from existing version created by existing modules Application allows user to define more than one database connection But just one can be the work connection More connections are useful when user requests data from more sources e g from tables in MS Access MS SQL Oracle MySQL Application checks an existence and validity
14. m version tree o showing data for selected version o showing basic information about selected version o Data view o user can choose which columns are displayed o user can choose column order in data grid o user can load all data in data grid this action may take allocate huge part of memory e Running method of type normal e Switching to Edit mode user can repeatedly apply simple transformation on selected version Result may be saved as derived version into Version tree e Managing database connections e Managing methods 41 Main Menu 4 1 1 Main e New iki This command creates a new session If another previously opened session is active user will be asked whether the active session should be saved or not e Open This command opens a dialog to select session from list of existing sessions If another previously opened session is active user will be asked whether the active session should be saved or not 4 1 2 EG Open session Available sessions Description Saved session SavedSession Second saved session SavedSession Third saved session SavedSessian Cancel Type of session can contain one of these values o SavedSession session is saved in database o NewsSession session is not saved in database o OpenSavedSession another user has probably opened this session Close This command closes current session and opens a new session If another previously opened session is active use
15. ntu Main application Stranka 4 18 138 e Driver When the connection to database is correct the Driver for this ODBC connection is shown Otherwise text Broken is shown Capabilities e Add new connection e Remove connections e Set connection as the work connection 2 2 Add a new connection How to show this dialog e click on Add button in Manage database connection dialog Add new connection 3 Description JWorkconmection Short description ok Connection Using connection name TestDSN Using connection string I mark as work connection Add Cancel 2 2 1 Items e Description description for user e Short description this name is shown whenever user selects a connection or table connection e g in combo box for select tables e Connection o Using connection name in this case a connection is defined in user or system DSN Control panels gt Administrative tools gt Data Sources ODBC See also Sample ODBC connection for MySQL o Using connection string in this case user has to enter a valid connection string to connect to database e Mark as work connection if this choice is checked then connection is set as the work connection Connection previously marked as the work connection remains in definition of connections but till that moment it will not be marked as work connection Click on Test connection button to detect whether
16. r will be asked whether the active session should be saved or not Database connections This command shows a dialog to administrate database connections Exit This command closes application Version Add new version E This command opens a dialog to load data from a database table or from a file in CSV format Drop selected version This command deletes selected version More info This command shows a dialog with more information about selected version Save version as permanent table This command saves selected version as a permanent table into the working database This table doesn t belong to any session and will not be dropped Mew Table name Connection New table name must not be empty the first character is in a Z A Z and other characters are in a z A Z V 1 _ Maximal length of this name is 20 characters Save version as CSV This command exports data from selected version into a file in CSV format File uses UTF8 encoding Data are in format described in Create new version of data 4 1 3 4 2 EG Copy transformation If a version is created using simple transformations then these transformations may be saved into clipboard Apply transformation If a simple transformation can be applied to the selected version then this command executes it Then it creates a new version derived from the selected one Methods Metho
17. ries to execute showTables statement and checks if the statement fails or not Example lt database name Oracle gt lt description gt ODBC for Oracle lt description gt lt dbdriver gt MSORCL32 DLL lt dbdriver gt lt dbdriver gt SQORA32 DLL lt dbdriver gt Mom ersln lt columnInt gt integer lt columnInt gt lt columnDouble gt double precision lt columnDouble gt lt columnString gt varchar2 255 lt columnString gt lt columnLongString gt varchar2 4000 lt columnLongString gt lt conversions gt oc Le lt showTables gt SELECT table name FROM cat lt showTables gt lt alterTableModify gt ALTER TABLE TableName MODIFY ColumnName ColumnTypeNew lt alterTableModify gt lt alterTableAdd gt ALTER TABLE TableName ADD ColumnName ColumnType lt alterTableAdd gt lt alterTableRemove gt ALTER TABLE TableName DROP COLUMN ColumnName lt alterTableRemove gt N zev dokumentu Main application Str nka 7 18 ae lt alterTableRename gt ALTER TABLE TableName RENAME COLUMN ColumnNameOld TO ColumnNameNew lt alterTableRename gt lt dropTable gt DROP TABLE TableName lt dropTable gt Hagl lt database gt Element lt database gt e It contains definition of SQL statements for group of ODBC drivers e Attribute name is optional and it has been made for better database identification Element lt description gt optional at most one e Long description of this record Element lt dbdriver gt mandato
18. ry at least one e Name of driver DLL library with ODBC driver Element lt conversions gt mandatory exactly one e It contains other elements for processing of conversion between database types and simple types Element lt columnInt gt mandatory exactly one e Database type corresponding to simple type INT an integer Element lt columnDouble gt mandatory exactly one e Database type corresponding to simple type DOUBLE a number with decimal point Element lt columnString gt mandatory exactly one e Database type corresponding to simple type STRING text up to 255 characters length Element lt columnLongString gt mandatory exactly one e Database type corresponding to simple type STRING text up to 4000 characters length Element lt sql gt mandatory exactly one e It contains other elements with SQL statements It is necessary to define following items o show list of all tables element lt showTables gt change database type of relevant table column element lt alterTableModify gt add column into relevant table element lt alterTableAdd gt remove column from relevant table element lt alterTableRemove gt rename relevant table column element lt alterTableRename gt O O O O drop table element lt dropTable gt It is necessary to use variables for table name column name and type These variables will be substituted with appropriate values These variables has prefix and their names are descri
19. sites e atleast one version of data e at least one module of type normal 1 Choose one of the existing versions 2 From menu Modules gt menu item with relevant Module name Nazev dokumentu Main application Stranka 16 18 ae 4 4 6 Save session Session is saved automatically when user creates a new one opens an existing or selects menu item Main gt Close session User enters session name before saving Eo O a xj Session name Name of session Drop If Drop button is pressed session and all included versions will be deleted from database 4 4 7 Create new session Main Windows menu Main gt New Current session is closed before the new one is created User is asked to save the new session whenever it contains at least one version N zev dokumentu Main application Str nka 17 18 ae 5 Solution of possible problems 5 1 Can not connect to MS Access database SQL Error Situation e File xxx mdb is created e ODBC driver lead to xxx mdb e Test connection is OK e There is a SOL error in the test connection Solution e Open xxx mdb file with database e MS Access menu Tools gt Options gt View gt check Hidden objects e MS Access menu Tools gt Security gt Users and groups permissions gt set according this screenshot Pr va u ivatel a skupin x Opr vn n Zm nit vlastn ka U ivatelsk jm no nebo n zev skupiny N zev objektu
20. the connection is valid This test takes effect just in case that Connection name possibly Connection string is not empty Results of this test might be e Connect to specified database is OK e This connection do not support show list of all tables o This result may happen in case of incorrect definition of configuration file sqlStatements xml or if permission setting for system database tables failed e Unknown ODBC driver Please add relevant information about driver into configuration file o This result is returned when user selects a data source which is unknown for application See also Add support for unknown ODBC driver A new connection insert is confirmed by clicking on Add button Note User can add an invalid database connection The connection must be valid at application start or it cannot be used ae 2 2 2 Sample ODBC connection for MySQL In Windows Open Start gt Control panels gt Administrative tools gt Data Sources ODBC 1 Open User DSN U ivatelsk DSN 2 Click on Add button P idat 3 Select MySQL ODBC 3 51 or similar name depends on installed ODBC driver 4 Click on Finish Dokon it Spr vce zdroj dat ODBC x Ovlada e Trasov ni Sdru ov n p ipojeni O rozhrani ODBC U ivatelsk DSN Syst mov DSN Souborov OSN Udivateleke zdroje dat N zev Ovlada iat ytvoreni nov ho zdroje dat i M Odebrat Vyberte ovlada pro
Download Pdf Manuals
Related Search