Feature Wiki

Information about planned and released features

Tabs

Database

Page Overview

[Hide]

1 General
2 Projects
3 Suggested Features
4 Scheduled Features
5 Redundant and Rejected Feature Requests

1 General

Maintainer and Tester

Database
- Authority to Sign off on Conceptual Changes: fschmid
- Authority to Sign off on Code Changes: fschmid , smeyer
- Authority to Curate Test Cases: fschmid
- Authority to (De-)Assign Authorities: fschmid
- Tester: TESTER MISSING
- Assignee for Security Reports: fschmid
- Assignee for Security Issues: fschmid
- Unit-specific Guidelines, Rules, and Regulations: LINK MISSING

Additional

Roadmap

Short Term

Put Database under Coordinator-Model

The goal is to put the Database under the Coordinator-Model. The service is crucial for the whole system and should not be managed by a single person.

Mid Term

Project: Establish Referential Integrity

Currently (ILIAS 8) ILIAS doesn't use advanced database-built-in functionalities that ensure the integrity of stored data.

The benefits ILIAS demands from the Database Management System (DBMS) regarding data value correctness on field-level currently are:

uniqueness, by primary or unique indexes
'not null' (without a defined default) for essential required fields
low-level datatype warranty on field-level, reasonable for numeric- and date/time-types, sometimes poor for unspecific varchar fields (examples: email and client_ip in usr_data)
To improve data quality and to support code maintaining modern DBMSs offer several options ILIAS COULD use:
Referential Integrity (Foreign Keys)
Stored Procedures & Functions
Trigger

For more information visit the project page: Project: Establish Referential Integrity

Long Term

Query-Builder and and ORM

The goal is to implement a Query-Builder and an ORM or move to a framework which provides these features such as Doctrine.

2 Projects

The following projects are planned or have been realised for this component:

NEW Projects

Ongoing Projects

(Project) Establish Referential Integrity

Projects On-Hold

Completed Projects

3 Suggested Features

List of suggested features - please add new requests below in alphabetical order [1] )

Suggested for 11

Abandon Database Benchmark

Already suggested

4 Scheduled Features

The following features have been scheduled / published in ILIAS Release 11:

The following features have been scheduled / published in ILIAS Release 10:

The following features have been scheduled / published in ILIAS Release 9:

The following features have been scheduled / published in ILIAS Release 8:

The following features have been scheduled / published in ILIAS Release 7:

The following features have been scheduled / published in ILIAS Release 6:

Required and Supported Software ILIAS 6

The following features have been scheduled / published in ILIAS Release 5.4:

Abandon Oracle Support

The following features have been scheduled / published in ILIAS Release 5.3:

The following features have been scheduled / published in ILIAS Release 5.2:

The following features have been scheduled / published in ILIAS Release 5.1:

The following features have already been developed and published in ILIAS Release 5.0:

The following features have already been developed and published in ILIAS Release 4.4:

The following features have already been developed and published in ILIAS Release 4.3:

The following features have already been developed and published in ILIAS Release 4.1:

Oracle 11g