Details of the CSDB (central shared database)

Freedom of Information Team

Please could you advise and respond to the following email.

Many thanks

Lauren Brown
Customer Advisor| Cynghorydd Cwsmeriaid
Customer Intelligence | Cudd-wybodaeth Cwsmeriaid
Room 1.101 | Ystafell 1.101
Office for National Statistics | Swyddfa Ystadegau Gwladol
Government Buildings | Adeiladau'r Llywodraeth
Cardiff Road | Heol Caerdydd
Newport/Casnewydd
NP10 8XG
Telephone 0845 6013034 | Ffôn: 0845 6013034

Communication Matters | Materion Cyfathrebu
Communication Division | Is-adran Gyfathrebu

Dear Office for National Statistics,

Under the Freedom of Information Act 2000, for the Office of
National Statistics CSDB (central shared database), please may I be
sent:

(1) The name and version of the database software (eg Oracle,
mySQL, etc);

(2) The definitions of the tables in this database in terms of
names, columns and datatypes;

(3) The total size of the database in terms of its memory on disk;

(4) How frequently this information is backed up and/or reloaded
into the database, and how long this process takes.

Yours faithfully,

Lisa Evans

show quoted sections

Our Reference: FOI00963/Evans/QE1

Dear Ms Evans,

Thank you for your email requesting information about CSDB. I am writing to
confirm that the Office for National Statistics has now completed its
search for the information and a copy of the information is enclosed.

(1) The name and version of the database software (eg Oracle, mySQL, etc);

Ingres 2006 (9.1.1), OpenRoad 2006.

(2) The definitions of the tables in this database in terms of names,
columns and datatypes;

Attached is a tab delimited file, TablesColumns.txt, containing details
for all tables on the CSDB database:

(See attached file: TablesColumns.txt)

(NB This list includes a number of "user" created tables, it would take
more than 3 days to identify 'real' from "user" tables.)

(3) The total size of the database in terms of its memory on disk;

The amount of disk space used by CSDB is 58Gb.

(4) How frequently this information is backed up and/or reloaded into the
database, and how long this process takes.

The database is backed-up every week night and takes 4.5 hours. There
has never been a need to restore the database.

You have the right to have this response to your freedom of information
request reviewed internally by an internal review process and, if you
remain unhappy with the decision, by the Information Commissioner. If you
would like to have the decision reviewed please write to Frank Nolan,
Office for National Statistics, Room 1127, Government Buildings, Cardiff
Road, Newport, Gwent, NP10 8XG.

If you have any queries about this email, please contact me. Please
remember to quote the reference number above in any future communications.

Regards,

Paul Wearn LLB (Hons)
Legal Services
Office for National Statistics
For the latest data on the economy and society consult National Statistics at http://www.ons.gov.uk

show quoted sections

Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
*********************************************************************************

show quoted sections