BOI Software Entwicklung und Vertrieb GmbH

Phone: +43 (0) 732 / 736423 - 0

Spazgasse 4

Email: office@boi.at

4040 Linz, Austria

www.boi.at

Maintenance types for tables in relational databases

Direct maintenance of a single row through row selection

Each user selects just one row of a table. Thus, multiple users can maintain different rows on one table concurrently.

fig. Direct maintenance of single row

Direct maintenance of a table

One user maintains several rows of a table at once.

fig. Direct maintenance of table

Maintenance with release procedure

When maintaining tables with release procedure, the changed data are buffered in a TABEX modification database.

After successful review of data changes by a second user, the corresponding tables are transferred to the RDB and deleted from the TABEX modification database.

fig. Maintenance with release policy

Maintenance using SQLT table with or without release procedure

During table maintainance, TABEX tables with SQL connection (so-called SQLT tables) are attached with data of a relational database using an SQL SELECT statement.

The result of the SELECT statement is dynamically loaded from the relational database, if the table is empty when loading from the TABEX database.

fig. Maintenance using SQLT table with or without release procedure

Migration Packages

BOI GmbH offers migration packages for the table management systems SPITAB, TABSYS and VTAS.

 

» Migrations Packages

Success Stories

AirPlus has been using TABEX for 20 years.

Now TABEX/4 JAVA APPLICATION ENGINE has additionally been launched for audit-proof logging of the business processes by Java applications.

 

» read this success story

» more success stories