The schema for the Oracle database internally referred to as "central shared database"

FOI 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,

I would like to request the schema for the Oracle database used to
store the data for the Blue Book and other Office of National
Statics reports. I believe this database is referred to internally
as "the central shared database".

Yours faithfully,

Lisa Evans

show quoted sections

Dear Lisa,

The business area dealing with this request cannot answer the question
stated because CSDB (central shared database) does not use an ORACLE
database. The CORD system (Centralised ONS Repository of Data) used for
some parts of the annual production process in ELS does use an ORACLE
database, Is this the schema you require?

Please can you clarify which system the request relates to.

If you require any further clarification regarding this request, please
contact me.

Regards,

Paul Wearn LLB (Hons)
Legal Services
Office for National Statistics

Request - FOI00939/Evans

Dear Office for National Statistics,

I would like to request the schema for the Oracle database used to store
the data for the Blue Book and other Office of National Statics reports. I
believe this database is referred to internally as "the central shared
database".

Yours faithfully,

Lisa Evans

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

Our Reference: FOI00939/Evans/QE1

Thank you for your email requesting information about the schema of the
CORD system (Centralised ONS Repository of Data). I am writing to confirm
that the Office for National Statistics has now completed its search for
the information which you requested and copy of the information is
enclosed.

Please find attached a zip file containing the Data Architecture Document
(DAD) for National Accounts (which is the definitive usage of the CORD
design).

The zip file contains all the relevant PDF links referred to in the DAD,
including the logical and physical data models, and table descriptions.

(See attached file: FOI Request.zip)

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