Database/s used to store East Cambridgeshire District Council Accounts

Lisa Evans made this Freedom of Information request to East Cambridgeshire District Council

The request was partially successful.

From: Lisa Evans

10 May 2010

Dear East Cambridgeshire District Council,

I would like to request the following details of the database/s
used to store the details of East Cambridgeshire District Council
Accounts:

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

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

(3) The total size of the database containing this information 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

Link to this

From: foi
East Cambridgeshire District Council

10 May 2010

Thank you for your Freedom of Information request below. This has been logged under reference 10025.3-10/11-034 and passed to the appropriate department. You should expect to receive a reply within 20 working days, being 8 June 2010.

PLEASE NOTE THAT BEFORE RE-USING ANY OF THE INFORMATION PROVIDED, AN APPLICANT MUST SPECIFICALLY REQUEST PERMISSION FROM THE COUNCIL, IN ACCORDANCE WITH THE RELEVANT RE-USE OF PUBLIC SECTOR INFORMATION REGULATIONS 2005 AND THE COUNCIL'S OWN POLICY DOCUMENT / FORM UNDER THE PUBLICATION SCHEME (AVAILABLE VIA THE INTERNET.) SUCH A REQUEST WOULD BE CONSIDERED SEPARATELY IN ACCORDANCE WITH THE REGULATIONS AND IS NOT AUTOMATIC. THEREFORE NO PERMISSION IS IMPLIED IN THE RE-USE OF THIS INFORMATION, UNTIL SUCH REQUEST TO RE-USE IS MADE AND AGREED, SUBJECT TO ANY APPROPRIATE CONDITIONS. I HAVE ATTACHED A LINK TO THE REGULATIONS FOR EASE OF REFERENCE: http://www.opsi.gov.uk/si/si2005/2005151....

Kind Regards

FOI & EIR Administration
East Cambridgeshire District Council
Tel:01353 665555

show quoted sections

Link to this

From: Annette Wade
East Cambridgeshire District Council

8 June 2010

Good Evening Lisa

Please find the response to your Freedom Of Information Request detailed in blue below:

The name and version of the database software (eg Oracle, mySQL, etc) used - Agresso Business World Version 5.4 Service Pack 5 ( SQL 200 database)

The definitions of the tables in this database in terms of names, columns, data types and relationships - This information is not available

The total size of the database containing this information in terms of its memory on disk - 79112.59MB

How frequently this information is backed up and/or reloaded into the database, and how long this process takes - Daily differential back up, takes 20 mins & Weekly full back up, takes 50 mins.

PLEASE NOTE THAT BEFORE RE-USING ANY OF THE INFORMATION PROVIDED, AN APPLICANT MUST SPECIFICALLY REQUEST PERMISSION FROM THE COUNCIL, IN ACCORDANCE WITH THE RELEVANT RE-USE OF PUBLIC SECTOR INFORMATION REGULATIONS 2005 AND THE COUNCIL'S OWN POLICY DOCUMENT / FORM UNDER THE PUBLICATION SCHEME (AVAILABLE VIA THE INTERNET.) SUCH A REQUEST WOULD BE CONSIDERED SEPARATELY IN ACCORDANCE WITH THE REGULATIONS AND IS NOT AUTOMATIC. THEREFORE NO PERMISSION IS IMPLIED IN THE RE-USE OF THIS INFORMATION, UNTIL SUCH REQUEST TO RE-USE IS MADE AND AGREED, SUBJECT TO ANY APPROPRIATE CONDITIONS. I HAVE ATTACHED A LINK TO THE REGULATIONS FOR EASE OF REFERENCE: <http://www.opsi.gov.uk/si/si2005/2005151...>.

Regards

Annette Wade
Principal ICT Officer (e-gov & ICT Support)

ECDC Private and Confidential Notice

The information contained in this e-mail is intended for the named recipients only. If you are not the intended recipient you may not copy, distribute or take any action or reliance on it.

Opinions expressed are those of the individual and do not necessarily represent the opinions of East Cambridgeshire District Council.

If you have received this e-mail in error please notify the sender immediately by using the e-mail address or by telephoning (01353 665555 Ext.6497)

Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communication medium. We advise that you understand and observe this lack of security when e-mailing us.

Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure that they are actually virus-free.

Link to this

Things to do with this request

Anyone:
East Cambridgeshire District Council only:
Would you like to work with the team that built this site? We’re recruiting.