Bases de données
120 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.
The document is an exam from the Université Virtuelle de Tunis focused on NoSQL concepts, specifically MongoDB operations and MapReduce. It includes three exercises covering CRUD operations for employee data, menu ingredient calculations, and building surface analysis. The methodology involves writing queries for specific tasks, including data insertion, filtering, aggregation, and surface calculations using MapReduce. The findings involve scenarios like updating MongoDB collections and performing data aggregation for decision-making processes.
This document provides an in-depth exploration of MongoDB, a NoSQL document-oriented database system designed for scalability and flexibility. It describes MongoDB's architecture based on BSON (Binary JSON), its unique querying language, and its schema-free model. It also details CRUD operations, sharding, replication, and the practical tools like MongoDB Compass, MongoDB Atlas, and the Shell interface. Real-world examples demonstrate filtering, querying, and inserting JSON data with robust data management techniques.
MongoDB is one of the most popular NoSQL systems, based on a semi-structured data model and JSON encoding. It has no fixed schema, ensuring complete flexibility, and utilizes a unique query language. MongoDB is designed as a scalable, distributed system with features like sharding and replication for fault tolerance.
This document outlines the steps for preparing a virtual environment to study NoSQL databases, incorporating the setup of VirtualBox and a virtual Ubuntu 20 machine. It describes VirtualBox's networking modes, guides users through obtaining an Ubuntu ISO, creating and running a virtual machine, and provides essential terminal commands for updating packages and setting up network tools. The document is designed as a hands-on reference for students or practitioners in virtual environment preparation within database contexts.
This document outlines the preparation of the environment for a NoSQL database module using VirtualBox. It includes steps for installing VirtualBox, creating a VM with Ubuntu 20, and preparing the VM with essential network configuration tools. The instructions are intended for students to set up their environment for further database-related tasks.
This document introduces the fundamentals of NoSQL databases, explaining their significance in managing large and diverse datasets such as Big Data. It discusses various types of NoSQL databases—key/value, document-oriented, column-oriented, and graph-based—highlighting their unique roles in addressing challenges posed by semi-structured data and scaling. The CAP theorem is introduced, outlining trade-offs between consistency, availability, and partition tolerance in database systems. Examples of implementations for each type of NoSQL database are provided, alongside associated use cases an...
This document contains the questions and problems from the entrance exam for engineering cycles in Tunisia for the year 2019. It includes programming problems primarily in Python as well as relational algebra and SQL tasks. Students are required to demonstrate their understanding of algorithms and database management through practical coding exercises and query formulations.
This document provides a comprehensive guide to SQL as a Data Manipulation Language (DML). It covers the essential SQL clauses such as SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY, along with their syntax, application, and use cases in querying relational databases. Examples demonstrate data extraction, aggregation functions, filters, logical operators, and table joins to facilitate understanding. The material also emphasizes conditions, NULL values, and advanced techniques like concatenation and reflexive joins while illustrating real-life database queries using an employee database.
This document introduces the fundamental aspects of databases, emphasizing their definition, benefits, and design methodologies. Key methodologies include collecting user requirements, conceptual modeling, logical schema generation, and physical schema implementation. The Entity-Relationship model is extensively discussed with concepts like entities, attributes, associations, and cardinalities. Examples and exercises further demonstrate creating entity-association schemes for real-world applications like managing cinemas, book loans, and corporate personnel systems.
This document introduces the relational model as a core concept for organizing data in database systems using tables. It outlines rules for transitioning from an Entity-Relationship model to a relational model, such as entity translation and handling associations of different cardinalities. Examples illustrating n-ary associations and special cases like binary associations are provided alongside exercises for developing relational and entity-relationship models. It emphasizes the importance of primary and foreign keys in maintaining data integrity and enabling relationships between tables.
This document discusses the implementation of an incremental ETL process focused on extracting modified data from source systems. It outlines various techniques such as using DateTime columns, Change Data Capture, and Change Tracking to efficiently manage data extraction. The objectives aim to equip learners with the knowledge to extract modified records and implement effective ETL solutions.
This document contains a series of exercises related to database management, focusing on the representation and management of books, transport companies, library systems, and materials management. Each exercise outlines specific entities and relationships required for proper database schema design. The exercises also emphasize the importance of well-structured data management and client handling.
This document presents the concepts and issues surrounding distributed databases, highlighting the challenges posed by large volumes of information and high access rates. It discusses potential solutions, such as distributing data across multiple locations to improve access times. The document also outlines the functions of Database Management Systems (DBMS) and the processes involved in database design.
This document outlines the correction for Lab TP2 regarding data dictionaries in Oracle. It includes steps to connect and manage database instances, roles of various system tables, and SQL commands to describe data structures. Additionally, it provides instructions for creating storage spaces and retrieving instance information.
This document outlines the creation of SQL tables for a cycling event database, including teams, countries, riders, stages, and timing. It provides SQL commands for inserting data into these tables as well as queries for data retrieval. The focus is on relational database design and querying techniques in SQL.
Ce document contient des questions de correction pour un TD sur l'architecture des bases de données ORACLE. Il explore les composants clés d'un SGBD Oracle, y compris l'instance, la mémoire SGA et les processus en arrière-plan. Des détails sur les fichiers associés et les structures de stockage logiques sont également fournis.
Ce TP a pour objectif de permettre aux étudiants d'écrire des requêtes SQL avancées en utilisant des constructions complexes telles que GROUP BY, HAVING, et des sous-requêtes. Les étudiants travailleront avec une base de données importée pour répondre à diverses questions concernant des coureurs et des étapes. Les exercices incluent des fonctions d’agrégation et des requêtes imbriquées.
This document provides a series of exercises related to SQL queries for managing a database of culinary dishes. It includes requirements for creating tables, querying for expensive dishes, listing ingredients, and deleting unused items. Each exercise emphasizes correct SQL syntax and the use of specific functions.
This document provides an overview of PL/SQL, a procedural extension for SQL by Oracle. It explains the integration of SQL with procedural constructs to create complex database operations. Additionally, it covers variable declarations, data types, and examples of use in PL/SQL.
Ce document est un TD sur l'architecture d'Oracle Database. Les étudiants doivent compléter des phrases en se basant sur leurs connaissances des composants et processus d'un SGBD Oracle. Cela inclut des éléments comme la mémoire SGA, les processus en arrière-plan, et les stratégies de journalisation.
This document contains a series of exercises on database dependencies and normalization. It includes problems related to functional dependencies, key identification, and normalization forms for various relations. Each exercise presents distinct scenarios and challenges within the field of database management.
Ce document traite des bases de données Oracle et de l'importance du dictionnaire de données pour leur administration. Il vise à familiariser les étudiants avec la structure du dictionnaire et les requêtes SQL pour son interrogation. À travers des activités pratiques, les étudiants apprendront à utiliser les fonctionnalités de consultation disponibles dans Oracle.
This document provides answers to questions related to database administration, transaction management, and SQL view creation, as part of a database examination from the academic year 2014-2015. It includes a range of topics such as transaction control, system views, and data recovery methods.