Universidad de Jaén

1. Management Database

1.1. The database administrator (DBA)

1.2. DBA functions

1. 3. Relational DBMS architecture

1.4. Management Tools

2. Database Security

2.1. Objectives and requirements

2.2. User Identification

2.3. Privilege Management

2. 4. Allocation and control of system resources

2.5. SQL Security

2.6. Views

3. Transaction Management

3.1. Concept of transaction and states

3.2. Storage Operations

3.3. Crash recovery based on log

3.4. Crash recovery in commercial DBMS

3. 5. Backups

4. Optimization of the database

4.1 Physical model d data

4.2 Query optimization

5. Knowledge bases

5.1 The level of knowledge

5.2 Knowledge base design

5.3 Knowledge modelling languages: RDF and OWL

PRACTICES

Practice 1. Client Programming: JDBC and Data Sources

   1.1  Introduction to JDBC

   1.2 Manipulación basic data withJDBC

  1.3 Introduction to Java Data Sources

Practice 2. Stored Procedures

           2.1.Defining blocks in PL / SQL

           2.2.Declaration of constants and variables

           2.3.Control Structures

            2.4.Declaration and use of cursors

            2.5.Using SELECT within a block

            2.6.Declaration and use of stored procedures and functions

Practice 3. Triggers and privileges

3.1. Declaration and use of triggers

3.2. Managing security roles and privileges

4. Practice Management databases

4.1 Installing DB

4.2 Data Distribution

4.3 Space Management

4.4 Definition and user access

4.5 Data Recovery 

4.5 Configuring the Database

5. DDBB optimization

5.1 DDBB Physical model

5.2 Query optimization

6. Knowledge database

6.1 KB design

6.2 KB implementation

1. Lectures (theoretical-Lectures) (large group) Description:Presentation in the classroom of concepts of matter usingparticipatory methodology expository lectures and media. Evaluationand review of acquired skills. Purpose: To transmit the contents ofthe subject motivating students to reflection, facilitating thediscovery of relationships between different concepts and trainthem critical thinking

2. Practical activities (laboratory practicals) (small group)Description: Activities through which aims to show the students howto act on the application of the knowledge acquired Purpose:Development in students of instrumental skills The matter.

3. Seminars (small group) Description: organizational mode ofteaching and learning processes which deal in depth with a relatedsubject matter. It incorporates inquiry-based activities,discussion, reflection and exchange. Purpose: Development instudents of cognitive and procedural skills of matter.

4. No-class individual activities (Studio and self-employment)Description: 1) Activities (guided and unguided) proposed by theteacher through which individually and delves into specific aspectsof the subject enabling the student to move in acquisition ofcertain knowledge and procedures matter, 2) individualized study ofthe contents of the subject 3) evaluation activities (reports,surveys, etc) Purpose: To promote the student's ability toself-regulate their learning, planning it, by designing, evaluatingand adapting it to their particular conditions and interests.

5. No-class activities in group (Study and work in group)Description: Activities (guided and unguided) proposed by theteacher through which as a group and delves into specific aspectsof the subject allowing students to move in acquisition of certainknowledge and procedures matter. Purpose: To encourage students inthe generation and exchange of ideas, identification and analysisof different views on a topic, generalization or transfer ofknowledge and critical assessment of it.

Students with special educational needs should contact the Student Attention Service (Servicio de Atención y Ayudas al Estudiante) in order to receive the appropriate academic support

-Theory and practice exam (5 points each) It is mandatory to achieve a minimum score of 4 out of 10 on the theory and practice exam.

The following aspects will be considered for the benefit of the student, up to a maximum of two additional points on the score obtained from the sum of the theory and practice examination

• Participation in theory classes
• Exercises at the end of each theme
• Realization of practice scripts
• Accomplishment of some work related to the subject and its presentation in class.

The evaluation of the subject will be global, allowing the student to be evaluated without the need to take a single test. The activities carried out both in the theoretical and practical classes will be continuously evaluated.

The learning results 13 and the competences CB2R, CB3R, CB5R and CC12R, are evaluated by means of the aspects S1, S2, S3 and S4. However, both the instruments and the criteria are different. In aspects S3 and S4, practical development, defence and exposure are assessed, and in assessment aspects S1 and S2, theoretical knowledge is assessed.

For the section of the scenario sempiresencial or mixed:
Activities that cannot be carried out in person will be carried out in a semi-presential format with rotating assistance and the use of video-conference systems, provided that the capacity and infrastructure of the space assigned for teaching the subject allow it. The Centre may vary the percentage of attendance depending on the number of students and the capacity of the classroom/laboratory in accordance with health measures. In case of less than 100% attendance, there will be a periodic rotation of students as determined by the Center.

It is expressly forbidden to record by any means the face-to-face or non face-to-face synchronous activities.

Activities that cannot be carried out in person will be carried out by means of synchronous and/or asynchronous activities carried out through the virtual teaching platform.

It is expressly forbidden to record by any means the face-to-face or non face-to-face synchronous activities.

The system and assessment instruments will be the same as for the face-to-face mode, replacing the face-to-face tests with similar tests developed through the use of the online teaching platform, provided that the identity of the student is guaranteed.

Institution in charge of data processing: Universidad de Jaén, Campus Las Lagunillas, s/n, 23071 Jaén

Data Protection Delegate: dpo@ujaen.es

Purpose: In accordance with the Universities Law and other national and regional regulations in force, carrying out exams and assessment tests corresponding to the courses students are registered in. In order to avoid frauds while sitting the exam, the exam will be answered using a videoconference system, being able the academic staff of the University of Jaén to compare and contrast the image of the person who is answering the exam with the student's photographic files. Likewise, in order to provide the exam with evidential content for revisions or claims, in accordance with current regulation frameworks, the exam will be recorded and stored.

Legitimacy: compliance with legal obligations (Universities Law) and other national and regional regulations currently in force.

Addressees: service providers who are the owners of the platforms where the exams are carried out and with whom the University of Jaén has signed the corresponding data access contracts.

Storage periods: those established in current in force regulations. In the specific case of exam videoconference recordings, not before the examination records and transcripts are closed or the exam can still be reviewed or challenged.

Rights: you can exercise your right of access, amendment, cancellation, opposition, suppression, limitation and portability by sending a letter to the postal or electronic address indicated above. In the event that you consider that your rights have been violated, you may submit a complaint to the Andalusian Council for Transparency and Data Protection www.ctpdandalucia.es

Person in charge: Universidad de Jaén, Paraje Las Lagunillas, s/n; Tel.953 212121; www.ujaen.es

Data protection delegate (DPO): TELEFÓNICA, S.A.U. ; Email: dpo@ujaen.es

Procedure aim: To manage proper recordings of teaching sessions with the aim of facilitating learning process under a multimodal and/or online teaching

Period for record storage: Images will be kept during legal term according to regulations in force

Legitimacy: Data will be managed according to legal regulations (Organic Law 6/2001, December 21, on Universities) and given consent provided by selecting corresponding box in legal admission documents

Data recipients (transfers or assignments): Any person allowed to get access to every teaching modality

Rights: You may exercise your rights of access, rectification, cancellation, portability, limitation of processing, deletion or, where appropriate, opposition. To exercise these rights, you must submit a written request to the Information, Registration and Electronic Administration Service of the University of Jaen at the address above, or by e-mail to the address above. You must specify which of these rights you are requesting to be satisfied and, at the same time, you must attach a photocopy of your ID card or equivalent identification document. In case you act through a representative, legal or voluntary, you must also provide a document that proves this representation and identification. Likewise, if you consider that your right to personal data protection has been violated, you may file a complaint with the Andalusian Data Protection and Transparency Council www.ctpdandalucia.es