VODCA Databases

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.

 

 

Database users

VODCA databases include 3 groups of users with different privileges: Administrator, user, and guest.

 

 

Firebird® is a registered trademark of Firebird Foundation Inc., Australia

 

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer