![]() ![]() |
Natural Resources Canada | Earth Science Sector | Geological Survey of Canada
![]() ![]() |
GlobalDB System Release 3.7 |
GlobalDB System Site Map | Presentation | Requirements | Software and Scripts | Aliases | Using GShell | Using GQuery | Using Documentor
The folder GlobaDBSystem321 contains the application interfaces and tools GShellADO (GShell), GShellBrowser, GQueryADO (GQuery), GQ_ADO_XtraTables, Documentor, and GBDSTools. The folder also contains the document howtoADO.rtf (how to define database aliases), a copy of this web site in the folder Documentation, and a folder Databases which contains an empty MS-Access 2000 database named EmptyWMGDP321_Picklists.mdb. The database and derivative data are contained in the folder Data321. GlobalDBSystem321 and Data321 should be copied over to a chosen destination in their entirety. After database aliases, or data links, are defined (alias definition), the programs can be run directly.
The programs are not accompanied by Help files. This web site, together with hints and status bar messages, provides documentation on using the software.
If an earlier release of the GlobalDB System is already installed on your computer and you are not using it to access earlier versions of the databases, we suggest that it be uninstalled to keep your computer clean. This is done by clicking the Start button, then Settings, then Control Panel. In the Control Panel window, click on Add/Remove Programs (XP or earlier) or Programs and Features (Windows 7), select "WMGDP – GlobalDB System" and click Add/Remove. During de-installation, you will be prompted about removing some shared files. The programs supplied in this Open File do not need to be installed using a setup program as was required by earlier versions of GlobalDB System, and do not need to be uninstalled through Add/Remove Programs. The new tools in the GlobalDBSystem321 folder will not conflict with older ones if copied over in their own folder. The GlobalDBSystem321 GShell and GShellBrowser interfaces cannot be used for databases with earlier versions of the schema; this is not an issue for the other tools.
The GlobalDBSchema321.sql scripts in the folder Data321\Data_SQL\InterbaseSchema were created by Robert Laramée in 2005 for defining an empty version of the database in an SQL_enabled database management system (DBMS), in this case Interbase. The schema scripts will create all tables and define their primary and foreign keys and relationships, but they will not populate the database. A database administrator who knows how to tweak such database objects as users, roles, and grants should be the one to load the schema. For instance, in the Interbase script, line 12 reads "SET SQL DIALECT 3;"; if you do not work with InterBase (version 6.0 or more recent), you should remove that line or it will generate an error message. An alternative GlobalDBSchema script that we used to build databases in PostgreSQL is included in the folder PostgresqlSchema. GBDSTools was used to create was used to export the contents of the Canadian Iron Formation database just prior to this publication. Depending on whether you would like a populated Canadian Iron Formation database, for example, or an empty one with picklists, scripts IF_Canada_InsertData.sql or EmptyWMGDP321_InsertData.sql can be run against the newly created database.
The SQL scripts of the upgrade level 321 databases have been successfully tested on an InterBase version 6.5 server running in MS-Windows and in Linux, with MS-SQL Server version 7.0, with Oracle 9i and with PostgreSQL. GShell still only runs with MS-Access databases (under operating systems XP or earlier). On the other hand, GQuery version 3.21 runs properly with MS-Access, InterBase and MS-SQL Server using ADO aliases; it has not yet been tested with Oracle or PostgreSQL.
GlobalDB System Site Map | Presentation | Requirements | Downloads | Aliases | Using GShell | Using GQuery | Using Documentor
Important notices and disclaimers | 2014-09-26 |