Database backends

From ICISWiki

Design and development discussions > Database backends

Contents 1 News & Tips 2 Database Conversion 3 Testing of PostgreSQL as ICIS applications backend 3.1 ICIS version 5.5 3.2 ICIS version 5.4 4 Testing of MySQL as ICIS applications backend 5 Row-level security 6 Benchmarking

News & Tips

• PostgreSQL
• MySQL
• Microsoft Access
• Oracle

• Tools for managing databases

Database Conversion

• MS Access to MySQL conversion of ICIS databases
• MS Access to PostgreSQL conversion of ICIS databases

Testing of PostgreSQL as ICIS applications backend

ICIS version 5.5

• ICIS 5.5: Postgresql as Central database (GMS, DMS, GEMS)
• ICIS 5.5: Postgresql as Local database (GMS, DMS, IMS)

ICIS version 5.4

• Postgresql as Central GMS & Central DMS
• Postgresql as Local GMS, Local DMS, and IMS

Testing of MySQL as ICIS applications backend

• MySQL as central database
• MySQL as local database

Row-level security

• Oracle row-level security (VPD)
• MySQL row-level security

Benchmarking

Database benchmarking