3rd Bachelor in Management Computing
Data organization and exploitation
< Back
| ECTS Credits | 6 |
|---|---|
| Number of Hours (h/year) | 75 |
| Teaching staff | HERBIET, Laurence |
| Course Unit | Compulsory |
| Term | Quad. 1 |
| Code | ECO-INF00018/3 |
| Prerequisite | Mastership of Entity-Relationship and relational models Knowledge of SQL and client/server model Mastership of a stored procedures definition language |
|---|---|
| Aims and Objectives | To master the fundamentals to normalize relational schema To master the object-relational model concepts To understand the advantages of a data exchange format “vendor-neutral” like XML and to study his integration in a relational database To handle the fundamentals of distributed databases To develop a WEB interface project in a multi-tier architecture with distributed databases |
| Description | The normal forms and the normalization algorithm. Functional dependence and multi-value dependence The object-relational extensions Various ways of storing and validating XML schemas and XML files Integration et generation of XML contents with SQL. Programming in dynamic SQL Definition of distributed databases Distributed databases architecture: Fragments, distribution transparency level Different techniques of replicated information. Grid databases architecture Application development with multi-tier architecture, WEB programming and distributed database |
| Bibliography | DELMAL (P.), SQL2-SQL3, Applications à Oracle, De Boeck Université, 2000. Oracle XML DB, Developper’s Guide, 10g Release 1, Oracle Press, 2003 |
| Teaching and Learning Methods | Lectures Tutorials Laboratory work Lectures and practical work |
| Assessment Methods | Written examinations Oral examinations Projects or practical work Continuous assessment Lectures : Oral examination Practical Work : continued evaluation |
| Notes | In part |
| Language | French |
The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.