The core of the VODCA package is the capability to create, administrate and use multiple longitudinal patient and outcome databases tailored to meet the needs in radiotherapy. VODCA interfaces Firebird®, an open source SQL relational database management system, in a client/server relationship for patient and outcome databases.
VODCA Database Structure
When you create a new VODCA database using the application "VODCA-DATABASE" a new Firebird® single file database is created. At this stage, in addition to the various standard Firebird® system pages and tables, some supplemental configurations are performed.
The structure of a VODCA database consists of 3 main parts:
- A static text space where the database administrator can save multiple formatted pages with relevant information for the database users - For clinical trial databases for example the entire trial protocol,
- A dynamic text space where the users can save date and time ordered relevant information about the database - The optimal way to pass information to other users, and
- The data space as a container for patient datasets.
Every patient dataset
has an unlimited amount of user defined fields
subdivided into 4 categories:
- Patient data,
- Treatment data,
- Clinical data, and
- Serial data.
Serial data is a particular data category where a set of fields can be repeated over many tables, notably adapted for time-series. Data fields can be added or deleted at any time by the database administrator.
VODCA databases include 3 groups of users with different privileges: Administrator, user, and guest.
Firebird® is a registered trademark of Firebird Foundation Inc., Australia