Database Administration is the third subject in the Database (DB) branch and complements the knowledge of DB of the previous subjects, "Databases" and "Database Design". (However, it can be taken without having followed "Database Design".)

In the previous subjects, there has been work on the questions related to the design, programming and management of the DB and specifically in this one we will work over the tasks of administration of the DB.

The DB Administrator is responsible for the physical implementation of the DB, including the implementation and physical design of the DB, monitoring of security and integrity, system maintenance and reliability, and ensuring that applications perform satisfactorily for users. To carry out these tasks, a detailed knowledge of the Database Management System is also required.

The general objective of the subject is to present features related to the work of Database administration. The aim is to train students in the knowledge and techniques of Administration and Management of any Database Management System (DBMS) available on market, by introducing them to general questions, problems and existing solutions, using ORACLE DBMS and another one to be choose like MySQL, PostgreSQL, MariaDB, etc. to support lessons and laboratories.

Once the course has been completed, among other things, you will acquire the skills for:

- To define user accounts along with associated resources and privileges

- To establish and manage audit controls

- To select the appropriate concurrency and isolation control mechanisms in each context

- To learn about some of the possibilities that DBMS offer for backing up and recovering data from such backups

- To know and manage tools for monitoring, performance and adjustment of the DBMS

In addition to the competences of the subject, the general competences CB2, CB5, C2, C8, C9, as well as the specific competences IS3 and IS5 of the Software Engineering Speciality will be worked on, as they appear in the document of the Degree accessible at the address



http://www.ehu.es/documents/340468/516505/Lista+de+competencias.pdf

* Security and Audit: Management of users, profiles, privileges and roles.

* Concurrence: concurrence control protocols (reservations, time stamps and validation).

* Recovery of the DB

* Database maintenance

* Other aspects of DB management

The topics of the course will be presented and handled in the laboratory. Approximately 50% of the classes will have a totally practical approach. In the classroom sessions, there will be systematic presentations of the subjects of the course and exercises and practices to strengthen the techniques learned.

An active teaching methodology will be used, with laboratories and activities, both individual and in groups, and individual tests of lessons learned.

• Continuous Assessment System
• Final Assessment System
• Tools and qualification percentages:
  • Written test to be taken (%): 40
  • Realization of Practical Work (exercises, cases or problems) (%): 30
  • Team projects (problem solving, project design)) (%): 30

The subject has two modes of assessment: by final (or overall) assessment and by continuous assessment.

CONTINUOUS EVALUATION: The student will be able to take part voluntarily in it, since it is offered exclusively for those who can carry out the continuous monitoring of the subject within the established framework of dedication and assistance to presential activities. Pre-enrolment in the continuous assessment mode will take place during the first week of the course. Pre-enrolment will become definitive after confirmation of the application by the student on the dates established (around the 12th week with approximately 70% of the weight of the evaluation already completed) and after verification of partial performance by the teaching staff. If the student does not confirm his or her definitive enrolment in the continuous assessment on the above-mentioned dates, it will be understood that he or she dismisses this enrolment.

The course is focused on continuous assessment.

Written tests will be developed with a weight of 50%, laboratory work will account for 25% and non-presential work will account for 25%. All tests and practices must be carried out, obtaining the minimum score required.

FINAL EVALUATION: This will be applicable to students who do not wish to take part in the system of continuous assessment and to those who do not pass the conditions for final registration.

In this case, the development of the established laboratories must be completed prior to the date of the written examination. Their delivery on time and quality is a prerequisite for passing the course and will account for 20% of the grade.

It will be completed with the completion of a final examination of competence, to be carried out according to the official schedule of examinations of the Faculty and which will represent the remaining 80%. The minimum grade required in the final exam will be 5 out of 10.

FINAL EVALUATION: This will be applicable to students who do not wish to take part in the system of continuous assessment and to those who do not pass the conditions for final registration.

In this case, the development of the established laboratories must be completed prior to the date of the written examination. Their delivery on time and quality is a prerequisite for passing the course and will account for 20% of the grade.

It will be completed with a final examination of competence, to be carried out according to the official schedule of examinations of the Faculty and which will represent the remaining 80%. The minimum grade required in the final exam will be 5 out of 10.

Support material will be available in the eGela virtual classroom.
We will work with the Oracle12c DBMS and another one to be chosen by the student.

Basic bibliography

Fundamentos de Sistemas de Bases de Datos. R.A. Elmasri eta S.B. Navathe. Addison-Wesley, 2007.



Fundamentos de Bases de Datos. A. Silberschatz, H.F. Korth eta S. Sudarshan. McGraw-Hill, 2002.

Sistemas de Bases de Datos. Un enfoque práctico para diseño, implementación y gestión. T. Connolly eta C. Begg. Addison-Wesley, 2005.

Sistemas de Bases de Datos. Diseño, implementación y administración. P. Rob eta C. Coronel. Thomson, 2004.

Data Base Principles Programming Performance. P. O.Neil. Morgan Kaufmann, 1994



Principles of Distributed Database Systems. M.T. Ozsu, P Valduriez. Springer, 2011.



Database Administration. The Complete Guide to Practices and Procedures. C.S. Mullins. Addison-Wesley, 2002.

In-depth bibliography

Database Systems The Complete Book. H. García-Molina, J.D. Ullman, J. Widom. Pearson 2009.

Oracle database 12c Administración. Olivier Heurtel. Ediciones Eni, 2008

Web addresses

Oracle Web: technet.oracle.com
MySQL Web: MySQL.com
MariaDB Web: mariadb.org
PostgreSQL: postgresql.org.es