Documentation

Database Setup and Configuration

Productive Use

Server Type

An enterprise database must be provided.
This is either Microsoft SQL Server or a Postgres database.

Oracle support is in beta.

Please note: the embedded H2 database is not supported for productive and failover scenarios

Microsoft SQL

The framework supports SQL Server authentication. Please make sure to provide a local user with username and password.

Also you need to enable TCP/IP connections for the SQL Server.

Storage

The database must be suited to hold the Retrieval Suite’s data. In general each indexed document will consume up to 100kb of storage. This is due to storing and visualizing the metadata for debugging and development purposes.

For indexing 1M documents, the database storage should be 50-100 GByte.

Authentication

There must be a user with username and password provided to access the database. The user must have the following permissions on the database

  1. Tables: Create, modify, delete, drop

  2. Indexes: Create, modify and drop indexes

  3. Data: Execute arbitrary Select, delete, update statements on the tables

Development and Testing with Embedded Database

For development and testing scenarios, you can use the embedded H2 database as storage. But also the above mentioned databases are supported.

When running the RheinInsights Suite with the embedded database, the following storage requirement applies for the machine, where the Suite is running:

  • In general each indexed document will consume up to 100kb of storage.

  • For indexing 1M documents, the database storage should be 50-100 GByte.