Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Medical-Critical software
Message
De
01/07/2009 16:23:36
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01409652
Message ID:
01409655
Vues:
63
>How safe is to associate a history file with a patient record in a dfb ?
>
>Memo or child table or memo field
>( text fields in the same record seems safe but limited)
>
>However if I am considering write the history of the patient in a child table
>
>Is there great chances of corruption and history exchange among clientes ?
>
>This is the first time that I came across with such a critical software
>
>I would like to here for your experiences and ways to create tables to
>such critical software

You may find that data security (controlling who has access to the data) is an important criterion. Data security is easier to achieve with an RDBMS back-end. There are some good free ones like PostgreSQL, MySQL and even the free SQL Server Express (the latter if your databases are not too large or require high performance).

RDBMSs are usually more fault-tolerant than VFP databases/tables, and there are usually fewer points of failure with an RDBMS:

- with VFP databases/tables, a crash at any workstation, or network failure at any connection can cause data corruption

- data integrity of RDBMSs is generally not affected by workstation or network failures

There is little reason to use native VFP databases/tables for "critical" data when there are good, free RDBMSs available.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform