Bases de données
153 documents à télécharger gratuitement
Cours, examens, TD, TP et exercices de bases de données. Thèmes couverts : SQL, MySQL, Oracle, modèle relationnel, SGBD, MERISE.
This lab focuses on developing a data warehouse schema for Adventure Works Cycles, enabling analytical reporting and data analysis. Participants will implement both star and snowflake schemas to support the company's reporting requirements. Key exercises include preparing the lab environment, creating dimension and fact tables, and modifying database diagrams.
The document outlines an examination from the Université de Monastir, focusing on database design and relational queries. It includes two problems that require creating and transforming data models for museums' art collections and industrial logistics data, along with SQL-based database manipulation. Problem 1 emphasizes designing an Entity-Relationship model and deriving a relational schema, while Problem 2 provides SQL challenges covering creation, modification, and query operations. The goal is to assess students’ understanding of database structuring, constraints, and SQL proficiency.
Ce document propose une série de problèmes de révision sur la modélisation des bases de données. Les élèves doivent créer un modèle Entité-Association, formuler des contraintes d'intégrité et transformer le modèle en relationnel. Il aborde également des questions de création et de manipulation de tables SQL.
This document introduces MongoDB, a NoSQL database system designed for high performance, scalability, and automatic data management. It covers MongoDB installation, configuration, and basic administration with commands like data insertion and querying. It discusses MongoDB's JSON-like data model and how to create and manage collections, execute advanced queries, and import/export datasets. Additionally, it touches on MongoDB's lack of schema constraints and transactional support, which offloads application-level data control.
Télécharger en PDF Introduction SQL = Structured Query Language un langage de d ́efinition de donn ́ees (LDD), un langage de manipulation de donn ́ees (LMD), un langage d’interrogation de donn ́ees (LID), un langage de contrˆole de donn ́ees (LCD) DDL = Data Definition Language (Langage de D ́efinition de Donn ́ees LDD) Cr ́eation d’une structure de donn ́ees (Create) Modification de la structure d’un objet de la base de donn ́ees (Alter) Suppression d’une structure de donn ́ees(Drop ) Cr ́eation de table CREATE TABLE <nom table> (<nom colonne> type , <nom colonne> type , .
This document outlines the conceptual EER schema design and its implementation in ODL for a UNIVERSITY database system. It explains the transformation of entity types into ODL classes, the use of extensions for inheritance, and the handling of composite multivalued attributes through separate classes like 'Diplome.' Additionally, it delves into the mapping of M:N relationships using intermediate classes such as 'Note' and provides specific inverse relationship implementations. The document also discusses the hierarchical structuring of entities such as 'Personne,' 'Etudiant,' and 'Professeu...
This document describes the design of an EER schema for a university database, covering entities like PERSONNE, PROFESSEUR, ETUDIANT, DEPARTEMENT, COURS, SESSION, and SUBVENTION. It defines relationships between professors, students, departments, and courses using cardinalities and subclass structures, including specific attributes for each entity. The methodology outlines a structured entity hierarchy with inheritance for attributes and roles in the university's academic, administrative, and research data. Findings include representations of relationships like teaching, enrollment, departm...
This document outlines four practical exercises aimed at querying and manipulating data within a MongoDB NoSQL database. Methods include selection queries, conditional filtering, and updating document structures. The specifics include retrieving titles based on collection content, filtering documents by price ranges, and adding key-value pairs to targeted documents using MongoDB operations.
This document is an exam on NoSQL databases focusing on MongoDB queries. Students are required to write specific queries related to a books collection. The exam includes inserting documents and retrieving specific information from the database.
This document analyzes the usage and design of database systems using Object Database Language (ODL) and Object Query Language (OQL). It explores entity relationships such as vehicles, persons, employees, and their associated behaviors. Key methodologies include schema creation, multiple class inheritance, and complex OQL queries for data manipulation and analysis. The report also demonstrates advanced querying techniques to solve real-world problems like filtering and aggregating data based on conditions.
This document is an advanced database exercise designed for students in a professional Master's program in free software. It elaborates on object database schemas using ODL notation to model real-world scenarios involving associations between entities like people, cars, apartments, and wine consumption. The exercise tasks involve defining a schema, implementing OQL queries to retrieve various dataset insights, and creating specific database views for scenario-based operations. It aims to enhance comprehension of complex schema design and querying strategies within object-oriented database m...
This document provides an in-depth analysis of object-oriented database standards based on the Object Data Management Group (ODMG) model. It covers core concepts like DatabaseFactory and Database interfaces, object binding operations, and their usage in object-oriented database systems. Additionally, it illustrates conceptual modeling for a university database using the Entity-Relationship (EER) and Object Definition Language (ODL), addressing entity types, relationships, and inheritance. A detailed schema for a University database is presented, including attributes, relationships, and obje...
This document introduces the foundational concepts of object-oriented databases, emphasizing the ODMG model and its interfaces, such as DatabaseFactory and Database. It provides an analysis of the design for an 'UNIVERSITE' database, detailing various entities and their relationships, including PERSONNE, PROFESSEUR, ETUDIANT, and DEPARTEMENT. The document also explains the Object Definition Language (ODL) used to create object database schemas compatible with CORBA IDL and illustrates inheritance and schema representation. Finally, it covers semantic constructs, relationships, and advanced...
This document provides an in-depth exploration of the object model defined by the ODMG consortium, emphasizing the importance of standards in ensuring portability and interoperability. The core concepts include defining objects and literals, their structures, and identifying unique properties such as object identifiers. The document extensively discusses the Object Definition Language (ODL) and Object Query Language (OQL), as well as standardized interfaces for object-oriented database software. It concludes with detailed definitions of interfaces for collections and iterators, offering exa...
This document explores the key aspects of the ODMG standard for object-oriented databases, which aims to ensure portability, interoperability, and comparability among database systems. It introduces the object model of the ODMG, which provides the foundation for object definition (ODL) and query (OQL) languages. The methodology emphasizes the definition and manipulation of objects and literals, distinguishing between object persistence and structures. Findings highlight the importance and operations of collections like SET and iterators for managing data, showcasing how adherence to standar...
This document details the principles and implementation of object-relational databases using Oracle, with a focus on SQL3 methods and object views. It introduces encapsulation, method overloading, and object comparison using MAP and ORDER functions. Practical examples include type creation, member procedure definitions, and implementations such as constructors and static methods. Moreover, the concept of object views is explored, emphasizing their utility for transitioning relational schemas to object-oriented applications.
This document provides practical examples of querying operations on MongoDB collections. Using examples with Cinema and Collaborateurs collections, it demonstrates basic and advanced query techniques, such as filtering, logical operators, and projections. Methodologies include retrieving specific documents based on attributes (e.g., year or salary range), leveraging comparison operators, and structuring result sets for projection. The examples emphasize flexible querying to handle real-world use cases effectively while demonstrating best practices.
This document introduces the principles and architecture of NoSQL databases, focusing on their ability to accommodate large-scale, diverse, and real-time data. It discusses the limitations of traditional relational databases and contrasts them with NoSQL's flexible schema, distribution mechanisms, and scalability. Core topics include NoSQL database categories such as key-value stores, document stores, graph databases, and time-series databases, with examples of their structures and use cases. Critical principles like the CAP theorem and BASE vs. ACID are also examined, alongside specific da...
This document provides an introduction to MongoDB, a NoSQL database. It explains the structure and types of documents stored in MongoDB, including BSON types and nested document usage. Key CRUD operations like inserting, updating, retrieving, and deleting documents are described alongside batch processing capabilities. Additionally, it presents the concept of collections, highlighting their schema-free nature and flexibility for storing heterogeneous documents.
This document presents the correction for Activity 3.2 from the Advanced Databases course. It introduces custom SQL object types and tables for managing hierarchical relationships and data modeling, specifically centered on athletes, teams, and their respective doping controls. Detailed SQL scripts are provided for creating types, tables, and inserting hierarchical data, along with a variety of queries demonstrating data retrieval and aggregation techniques. Additionally, database update operations such as insertions, deletions, and updates are highlighted to modify the existing records eff...
This document provides a detailed guide for designing and operating a database system under Oracle to manage antidoping data for international sports competitions. It covers UML class diagrams to represent entities and relationships, SQL commands for table creation and data manipulation, and complex query scenarios to extract relevant insights. Further, it details updates and operations for nested tables to dynamically manage data and highlights optimization with pseudojoining and nested cursors. The methodology ensures a structured and multi-tiered database implementation aligned with real...
This document provides an in-depth guide to implementing collections in SQL3, discussing different types of collections, including embedded tables, pre-dimensioned arrays, and multi-level collections. It explores their storage mechanisms, such as relation tables, object tables, and nested tables, with a focus on creating and updating these structures using SQL queries. Methods for querying collections, including pseudojoin techniques and nested cursors, are detailed, alongside advanced implementations of multi-level collections with nested references. The document aims to equip students wit...
This document presents a hands-on assignment aiming to implement the UML conceptual schema provided for managing simplified classroom planning. It focuses on applying object-oriented features of SQL3. Tasks include creating classes and associations, defining object tables, ensuring referential integrity, and implementing constraints using triggers. The document concludes with performing complex queries over the planning and classroom data while utilizing advanced SQL3 concepts such as TREAT(), IS OF(), and DEREF().
This document provides a detailed design and query exercise for an advanced object-oriented database schema using ODL (Object Definition Language). The schema models real-world entities, including people, vehicles, apartments, and their relationships. The document includes specific tasks such as designing an ODL schema, defining queries in OQL (Object Query Language), and creating database views to extract and analyze data. It also introduces practical scenarios like retrieving information based on various attributes and relationships, making it an essential learning resource for database p...