Databasteknik: Getting started with Mimer

We have a Mimer server set up and running, for use in this database course. The Mimer server happens to run on a Linux machine, and we run the clients on Windows machines, but, like most large database management systems, Mimer can be run on a number of operating systems.

If you wish to try out Mimer at home you can go to www.mimer.com and download a Mimer development version for, among other choices, Windows, Mac OS X or Linux. (For running Mimer on a Mac, see the notes below.) If you install this on your own computer at home, you can create your own databases, or you can connect to our Mimer server and do the lab assignments from home.

Before you can download the Mimer software, you must create an account on the Mimer web site. This is not the same account as the one you will be using on our database server (basen.oru.se), so you must create a new account on the Mimer web site. (They probably want to send spam to you.) Go to https://developer.mimer.com/product-overview/downloads/, chose your operating system, and then click "LOGIN" and after that "Register".

Your database

We have created a database called dbk on the server. Each student will receive a login name (for example dbtek74) and a password.

Getting started on our Windows machines

Log in on a Windows PC with your normal user name.

To connect to a Mimer database, you must first tell the local Mimer installation that the database exists.

Click on Start, then on All Programs, then on Mimer SQL Engine 10.0, and choose Mimer Administrator from the menu. When Mimer Administrator has started, choose the tab Remote to register a remote database:

The Mimer Administrator window

That the database is "remote" means that it is stored on a server, and not locally on the same machine.

The database dbk may already be listed, but if it isn't, you have to add it.

Click on Add, and in the Window that appears, enter the name of the database (dbk, not dbtek as in the picture). The Node name should be basen.oru.se. Be sure to uncheck the check box for Create System Data Source.

The Remote Database Definition window


Again: dbk, not dbtek as in the picture!

When you click OK, the new database will show up in the Mimer Administrator window. You can now close that window.

The Mimer Administrator window with the new remote database

If you get an error message saying Error creating data source something, you forgot to uncheck Create System Data Source. Mimer will work anyway.

If you get an error message saying that the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Mimer\Mimer SQL\SQLHosts\something couldn't be created, there was a problem with how Mimer was installed on the machine. Nothing will work until the problem has been fixed. Please contact your teacher.

Running SQL using Mimer's Batch SQL

Click on Start, then on All Program, then on Mimer SQL Engine 10.0, then on Utilities, and choose Batch SQL from the menu. You will now get to choose which database to connect to:

Choosing a database for Mimer Batch SQL


Remember: dbk, not dbtek as in the picture!

Choose the correct database, and click on OK. A text window will open, where you can enter your user name and your password (which you will get from your teacher), and then type in SQL queries. Queries can span several rows, and end with a semi-colon (;).

The Mimer Batch SQL windows

DbVisualizer

Mimer's Batch SQL is good for batch use, when you have a file of SQL commands that you want to run, but it is a bit cumbersome for interactive use, especially with large queries that don't fit on one row. An alternative is to use DbVisualizer, which is a Java-based tool that simplifies the interaction with the database.

Start DbVisualizer from the start menu: Click on Start, then on All Programs, then Mimer SQL Engine 10.0, and finally DbVisualizer. This window opens:

DbVisualizer

If you have previously defined a connection to the database you wish to work with, you can just click on its name in the list of connections to the left. Then click on Connect:

DbVisualizer

If you have not already defined a connection to the database, you must create one. (Otherwise, you can jump directly to what you can do when you have an open connection.)

Click on Database in the menu bar, and choose Create Database Connection:

DbVisualizer

The "New Connection Wizard" is easiest to use:

DbVisualizer

DbVisualizer

DbVisualizer is a general database interaction tool, that can be used to connect to various database management systems, such as Oracle, MySQL, DB2, and Microsoft SQL Server. You must indicate that it is a Mimer database that you wish to use:

DbVisualizer

DbVisualizer is written in Java, and uses JDBC, which is the Java way to connect to databases. JDBC does not use the list of local and remote databases that you have declared in Mimer Administrator, so you have to type in some information again:

DbVisualizer


Just as with Batch SQL, the name of the database is dbk, not dbtek as in the picture!

Click on Test Connection to see if everything works:

DbVisualizer

Now that you have an open connection, you can look at an object in the database, such as the table SUPPLIER, shown here:

DbVisualizer

Or you can type and run SQL queries:

DbVisualizer

ODBC Data Sources

In order to use ODBC, you need to define an ODBC data source.

Click on Start, then on All Programs, then on Mimer SQL Engine 10.0, and choose Mimer Administrator from the menu. When Mimer Administrator has started, choose the tab User DSN to create a data source:

The Mimer Administrator window

A user data source can only be used by the user who created it, as opposite to a system data source, which can be used by anyone.

Click on the Add to create a new user data source.

The Mimer ODBC Data Source Setup window

Finally, click OK, and see how the new data source shows up:

The Mimer Administrator window

ODBC data sources can also be managed centrally in Windows, using the ODBC Data Source Administrator in the control panel. The newly created data source shows up there too:

The ODBC Data Source Administrator window

Mimer documentation

There are more manuals than you ever wanted at Mimer's developer web site, among them the full documentation for Mimer SQL 10.0 (which is the server's current version) and a number of specific HOWTO documents. Among other things, you can look up the exact syntax for each SQL command.

On Windows, you can get the documentation in a standard Windows help window. Click on Start, then on All Programs, then on Mimer SQL Engine 10.0, then on Online Documentation, and choose Mimer SQL Engine Documentation from the menu:

The Windows help window for Mimer

There is an FAQ list too.

Mimer on Mac OS X

On a Mac, start by downloading and then installing Mimer, as usual with Mac applications.

Then you can run the application Mimer SQL Database Install from Finder to create a local database. You can then open a command window and start Batch SQL with the command bsql name, where name is the name of the local database you just created. Login with the username sysadm and the password you speciefied when you created the database. To be able to create tables, you must first create a databank. Give this command in Batch SQL:

CREATE DATABANK mybank OF 1000 PAGES IN 'mybank.dbf' WITH LOG OPTION;

If you want to connect to the database server at the university, you must first "create a remote database". Open a command window and give this command:

sudo mimhosts -r dbk basen.oru.se

You can then use the command bsql dbk to connect to the university's Mimer server. Login with the username and password you recieved from the teacher.

See also https://developer.mimer.com/article/installing-mimer-sql-on-macos/


Thomas Padron-McCarthy (thomas.padron-mccarthy@oru.se), November 12, 2020