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

Lisa Evans made this Freedom of Information request to Office for National Statistics

This request has been closed to new correspondence from the public body. Contact us if you think it ought be re-opened.

The request was successful.

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

Lauren Brown, Office for National Statistics

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

Paul Wearn, Office for National Statistics

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

Dear Paul Wearn,

It is the schema of the CORD system (Centralised ONS Repository of Data) used for some parts of the annual production process in ELS, that I require.

Yours sincerely,

Lisa Evans

Dear Paul Wearn,

Could you update me on why this request is delayed?

Yours sincerely,

Lisa Evans

Paul Wearn, Office for National Statistics

1 Attachment

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