Differences

This shows you the differences between two versions of the page.

--- database:convert_from_bde_to_sqlite [2017/09/04 19:01] – More content cmenz
+++ database:convert_from_bde_to_sqlite [Unknown date] (current) – external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Convert from BDE to SQLite ======
+With coDiagnostiX 9.8, the storage system used for patient data has changed.
+Why we did this:
+  - Ready for data generated by current technology
+  - Foundation for future developments
+  - The new database is easier to maintain
+  - Less prone to harmful user interventions
+  - No interference with 3rd party software
+However, to profit from the benefits of the new database system, all patients from the 9.7 database need to be moved to the new system. Generally, this process does not require any user intervention. However, in some circumstances, questions may arise. This article is intended to answer these questions.
 ===== The conversion process =====
+Converting an old database into the new structure happens without requiring user intervention. The process can be separated into two phases:
-Converting an old database into the new structure can be separated into two phases:
   - Creation of the patient index
   - Conversion of the patient datasets
@@ Line 50: / Line 62: @@
 ===== Database folder structure =====
+  Database
+  |-Cache
+  |-Legacy
+  |-Patients
+==== Database ====
+PatientDatabase.cdxDatabase is the only permanent file in this folder. It is an index file and contains the patients' meta data, like names, date of birth and the hospital's patient id.
+==== Cache ====
+The directory contains one cache file for each patient dataset in the database. These files contain data required to visualize (CB)CT data. If disk space is required, these files can be deleted. They are recreated when the corresponding patient dataset is opened the next time.
+==== Legacy ====
+**Do not change anything in this folder.** It will very likely make the contained patient data unreadable.
+This folder contains the old BDE database. Whenever a patient dataset is opened that was not opened in version 9.8 (or newer) before, the dataset is read from the BDE database and stored in the new database.
+==== Patients ====
+This directory contains one file for each patient in the database. A cdxPatient-file contains all data that belongs to a patient. The includes (CB)CT data, plannings, imported model scans and planned implants.
 ===== Parallel usage of pre 9.8 versions with 9.8 or later versions =====
@@ Line 55: / Line 89: @@
   * When updating to version 9.8, the database path of version 9.7 is changed to a new, not existing database path. Name: [database path] + "97". When version 9.7 is started, it will create a new, empty database in that folder.
-  * Using the BDE database in the legacy folder inside of a converted database with a parallel installation of 9.7 is not recommended. Instead, the old database should be copied.
+  * Using the BDE database in the legacy folder inside of a converted database with a parallel installation of 9.7 is not recommended. Instead, the old database should be copied **before** the conversion.
   * Datasets already converted to version 9.8 should be removed from the copy to avoid confusion.
   * Having an SQLite (9.8 and newer) and a BDE (9.7 and older) in the same directory should not be a problem. Version 9.8 will first try to find a SQLite database in that directory and open it. A BDE database is only opened and converted if no SQLite database can be found.
-===== Downgrade of 9.8 to 9.7 =====
+===== Downgrade of a 9.8 database to 9.7 =====
+Not possible.