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 the clients at the university run on Windows computers, but, like most large database management systems, Mimer can be run on a number of operating systems.

If you wish to use Mimer from 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 do the lab assignments from home, either by connecting to our Mimer server or by creating your own local database and using that.

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".

The Mimer web sites mimer.com and developer.mimer.com were extremely slow in Firefox. When I turned off tracking protection for both sites, it worked better.

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.

Note: Since everyone is working from home this year, due to the Corona, you don't need to use the university's computers. Instead, everyone will need to install Mimer on their own computers at home. Since you now have Mimer running at home, there is no need to use the dbk database. Just create a local database and use that one, instead of connecting to the dbk database!

Getting started on a Windows machine

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 the Windows symbol to open up the "start menu", scroll down to Mimer SQL 11.0.5A (but maybe with the version you have installed, instead of 11.0.5A) 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 File and then on Add:

The Mimer Administrator window

In the Window that appears, enter the name of the database (dbk). The Node name should be basen.oru.se. If you are doing this on the university computers, you might not have permission to create system data sources, and in that case uncheck the check box for Create System Data Source.

The Mimer Administrator window

You can click Test to test that the server can be reached and is responding, but then click OK.

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

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

Creating a local database

The section above describes how to create a remote database. That is fairly simple, since the database already exists on the server, and all we do is tell Mimer that it is there. We can also create a local database, on the same machine. That is more complicated, since we actually have to create the database.

The Mimer Administrator window

Click on File and then on Add:

The Mimer Administrator window

In the Window that appears, enter the name of the database (dbk). The Home Directory should be a directory (or "folder") on your machine that Mimer will use to store the data in the database.

The Mimer Administrator window

Keep clicking Yes and Next to everything, until you get to Finish and the process is finished. The final window will look like this:

The Mimer Administrator window

Now you can connect to the database and start giving SQL commands. There are two ways to connect to a Mimer database using SQL:

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

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

The Mimer Batch SQL windows

On Mac OS X and on Linux, you should instead open a terminal window, and give the command bsql in that Window. Add the database name as argument to bsql:

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 the Windows symbol, scroll down to Mimer SQL 11.0.5A, and choose DbVisualizer from the menu. The DbVisualizer window looks like this:

DbVisualizer

Since DbVisualizer is a Java-based program, you might have to install the Java runtime environment. In that case, a window similar to this will open the first time you start DbVisualizer:

DbVisualizer

Click Install, and complete the Java installation.

The first time you start DbVisualizer (or later if you deliberately run it) the New Connection Wizard will open, to help you configure DbVisualizer for connecting to a database:

DbVisualizer

Enter the name of the database connection (for example dbk) and click Next.

You also need to select which "JDBC driver" (a plugin program that helps a Java program connect to the datbase) to use for this connection. If this is the first time you have started DbVisualizer, it probably runs the "JDBC Driver Finder" automatically, showing up in a separate window looking like this:

DbVisualizer

You can just close that window. The connection wizard has a step where you select which driver to use:

DbVisualizer

The driver is specific to each DBMS, and you should use the one for Mimer. If you are using the standard DbVisualizer that is included with the Mimer download, that is the only driver available.

DbVisualizer

Finally, fill in the database server (basen.oru.se if you are using the university's server and not your own local database), the database (dbk), and the user name (for example dbtek42) and password that you have received:

DbVisualizer

You can click Ping Server to test that the connection works:

DbVisualizer

Finally, click Finish to complete the configuration of the database connection. Now you can use DbVisualizer's main window:

DbVisualizer

The green arrow with a plus sign creates a new "SQL commander tab", which is a frame where you can type and run SQL queries. In the free version of DbVisualizer, you can only have one at a time.

The three green arrows below are used to run the query in the SQL commander tab. You can keep the mouse still over them ("hover") to get help pop-ups that tell what they do.

DbVisualizer

ODBC Data Sources

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

(The images in this sections are from an older version of Mimer, but more recent versions are very similar.)

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 11.0 and a number of specific HOWTO articles. 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 the Windows symbol to open up the start menu, scroll down to Mimer SQL 11.0.5A, and choose on Mimer SQL Documentation.

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), April 7, 2021