Bases de données
121 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 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...
This document provides a corrected solution to Activity 3.1 within the Advanced Databases course for a Master's program in open-source software. It defines hierarchical database object types using SQL, creating and extending objects like classrooms and teaching assignments. Primary keys, constraints, triggers, and object references are implemented to ensure data integrity and relationship consistency. Additionally, various SQL queries demonstrate data retrieval, type filtering, and the use of object-oriented database features like inheritance and object references.
This document outlines the implementation of a UML conceptual schema for managing room scheduling at an institution using SQL3 object-oriented features. It provides definitions for classes, associative materializations, and object tables for data storage. Additional requirements include referential integrity, custom triggers for primary key constraints, and object-oriented queries addressing room planning and teaching requirements. The computational methods leverage advanced database functionalities such as object references, inheritance, and specific SQL3 features like TREAT() and IS OF().
This document explores object-relational databases, an extension of the relational model incorporating object-oriented concepts like abstraction, inheritance, and methods. It covers the advantages, including data encapsulation and SQL3 extensions, while also addressing limitations like the lack of a unified theoretical model and challenges of backward migration. Examples of object creation, inheritance, and references are presented, alongside discussions on implementation aspects like persistence, object storage, and referential integrity management. The document concludes with advanced top...
This document introduces a relational schema with six key entities: IMMEUBLE, APPARTEMENT, PERSONNE, ÉCOLE, CLASSE, and ENFANT. It provides details on their relationships and attributes, including primary keys and functionality. The document poses intricate SQL queries designed to retrieve and manipulate data within the schema, touching on scenarios such as filtering by construction date, occupant details, property ownership, empty apartments, and hierarchical relationships. The practical exercises aim to enhance comprehension of relational database design and SQL implementation.
This document outlines a practical exercise in advanced database schemas and SQL query operations within an Oracle SQL+ environment. It begins with the creation of database tables with appropriate primary and foreign key specifications based on given data, followed by a series of SQL queries addressing data ordering, filtering, aggregation, and modification tasks. The exercise delves into analyzing medication costs, disease treatment associations, and performing operations like price adjustments and record eliminations. These tasks aim to strengthen understanding of relational database desi...
This document provides an SQL-focused assignment for 1st-year MP2L students at ISI, centered on analyzing medicine data schemas and relationships. It requires creating tables with defined primary and foreign keys, writing SQL queries to extract insights from data, and performing specified database operations like price adjustments and filtering. The assignment highlights practical applications in database management and Oracle SQL+ syntax for advanced querying and manipulation.
This document outlines the installation process of Oracle Database 11g Express Edition (XE), a lightweight and beginner-friendly database version, and provides insights into its key functionalities. Detailed instructions are given for setting up the software, using its system command menus, accessing the database homepage, and creating and managing database users. Additionally, step-by-step examples, such as creating a user, assigning privileges, and unlocking sample databases like HR, are included to enhance database use and management efficiency. The document serves as an introductory gui...
This document provides a structured guide on defining, creating, and manipulating data tables in SQL. It describes the creation of tables, emphasizing constraints such as integrity and domain restrictions and detailing operations like altering and deleting structures. A methodology for naming constraints is offered for clarity and consistency. Practical SQL examples include temporary tables, composite keys, and constraint-based validation checks for ensuring data reliability and adherence to rules.
This document covers an in-depth exploration of relational database concepts. It elaborates on translating Entity-Relationship (ER) schemas into relational schemas, defining domains and constraints, and the application of rules for modeling relationships (e.g., binary, ternary). Examples present complex database schemas and their translations into relational tables, including key considerations like referential integrity and optimizing performance through minimizing table join operations. Core methodologies highlight the flexibility and precision of relational models in data representation...
This document serves as an educational guide introducing relational databases, including the Entity-Relationship (ER) model and its essential concepts. It focuses on defining entities and their attributes, relationships and associations, cardinalities, and advanced concepts like the Extended Entity-Relationship (EER) model. The material includes practical examples, methodologies for schema design, and critical considerations for avoiding design errors. Additionally, evaluation metrics such as expressivity, minimality, and simplicity are discussed for optimizing ER/EER models.
Academic document imported into UniversityLib: introduction aux bases de données.