I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

Database Summary

This database was implemented to

Support selected processes with a simple “central” data repository
Get rid of individual spreadsheets which have to be maintained with high effort
Simplify the task of data retrieval and of data storage
Enable additional calculations over defined periods of time and “slice & dice” calculations
Precisely define user or process access rights

This database is a simple all-purpose database. After the initial setup there is no further need for database table maintenance or index maintenance (apart from deleting old records to avoid the database becoming too big).

Limitations:
The database is not designed for mass storage – you are advised to define a regular data deletion (maintenance) procedure for each new field / data you regularly add to this database
The design is simple and field orientated. There is no support for curves or for surfaces – which means you cannot store nor retrieve curves or surfaces in one go. All points would have to be dealt with individually. This is possible but it creates quite an overhead to the database engine. So if this needs to be used it should only be temporary and not for mass storage
Fields are stored as string values. The user needs to convert all data into the required data types

There are 3 levels of access or responsibilities:
Technology and help desk support – After initial setup the database is backed up on a daily basis, repair or restore can be done within two hours, new users with read or read/write access can be introduced or old users can be deleted within 24h
Super user with read/write access – YOU define new fields and feeds the database with approved rate sources
Other Users with read-only access

YOU are the owner of this database.

Go back to Database Main Page

Sulprobil   Get it done   Contact   Disclaimer   Download