Survey of DBA problems
Apologies if you have already replied to this posting. However I would still appreciate any completed questionnaires you would care to return. Many Thanks ...... Jerry --------------------------------------------------------------- As the final element of my part-time studies for a degree in computing, I'm currently working on a project which will result in a 15,000 word project dissertation. As a DBA working on both DB2 and Oracle for a British bank, I have chosen a project which combines current Database Administration issues as well as looking forward to the features introduced by object-oriented databases. The aim of the project is to review some of the problems currently experienced within the administration of relational databases and to ascertain whether or not these have been tackled within commercially available object-oriented database management systems (OODBMSs). As part of the investigation into current problems, I have created the following questionnaire and would be grateful if you could spend a few minutes of your time answering the questions before e-mailing it back to me. The questionnaire is designed to be modified from within your e-mail application, and where possible, makes use of 'tick' or 'check' box style answers. The major exceptions to the 'tick' or 'check' box answers are questions 7 and 8, which use a more standard question style. However, please do not be put-off by these questions, as I'm more interested in 'ball-park' figures rather than 100% accuracy. Failing this, please provide what information you can, as I would rather have 50 questionnaires which are 85% complete than 2 which are 100% complete. Finally, to prevent filling-up this Newsnet group with questionnaire responses, please post all replies (plus any queries you may have) direct to my e-mail address which is 'jerrym@cix.compulink.co.uk'. Thank-you for taking the time to read this introduction, and I hope you will be able to respond to this questionnaire. Many Thanks for your interest ........ Jerry McKeon --- cut here ----------------------------------------------------------- Database Administration Questionnaire ------------------------------------- Question 1. Please give the name of the country you work in :- Name of country is : _______________________________ Question 2. From the following list of classifications, please indicate (using a 'x') which ONE best describes the type of organisation you work for :- +++++++++++++++++++++++++++++++++ |Computing | | |Financial Services | | |Government | | |Manufacturing | | |Petro-Chemical | | |Public Utilities | | |Retail | | |Services | | |Telecommunications | | |Transport | | |Other | | +++++++++++++++++++++++++++++++++ Question 3. Please indicate (using a 'x') the approximate percentage of your working week you spend carrying out any of the following job roles :- For example, if your job is a mixture of Applications Programming, Systems Analysis and Database Administration, indicate on the appropriate lines an estimate of the time you spend on each of these job roles. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ | |1 |11 |21 |31 |41 |51 |61 |71 |81 |91 | | |to |to |to |to |to |to |to |to |to |to | | |10%|20%|30%|40%|50%|60%|70%|80%|90%|100| |+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++| |Manager/Supervisor | | | | | | | | | | | |Systems Analysis | | | | | | | | | | | |Systems Design | | | | | | | | | | | |Data Administration | | | | | | | | | | | |Programming | | | | | | | | | | | |Database Admin | | | | | | | | | | | |Tech/Systems Support | | | | | | | | | | | |Operations | | | | | | | | | | | |Business User | | | | | | | | | | | |Other (please specify) | | | | | | | | | | | | | | | | | | | | | | | | .................... | | | | | | | | | | | +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Question 4. Please indicate (using a 'x') all of the application environments within which, you carry out any of the job roles you indicated in Question 3 :- +++++++++++++++++++++++++++++++++ |Development/Unit Test | | |Module/Integration Test| | |System/Acceptance Test | | |Production (live) | | +++++++++++++++++++++++++++++++++ Question 5. Please indicate (using a 'x') all of the Relational Database Management Systems you currently have some involvement with :- +++++++++++++++++++++++++++++++++ |DB2 | | |Informix | | |Ingres | | |Oracle | | |SQL Server | | |Sybase | | |Other (please specify) | | | | | | .................... | | +++++++++++++++++++++++++++++++++ Question 6. On approximately how many computers across your organisation, are the Relational Database Management Systems you indicated in Question 5 currently installed (i.e. the approximate number of computers which act as relational database servers) :- Number of relational database servers is : __________ Question 7. Although an exact figure is NOT expected (i.e. a 'ball-park' figure is sufficient), approximately how many database tables have been created across all of your organisation's environments :- NOTE : If you are unsure of how many database tables have been created across you organisation. Please feel free to answer this question by giving a range (i.e. between x and y), or anything else you feel happy with. Approximate number of database tables is : __________ Question 8. As per Question 7, please try and give a 'ball-park' figure for the number of Megabytes/Gigabytes (.... etc.) of disk storage which is currently allocate