<?xml version="1.0" encoding="utf-8"?>
<TEI xmlns="http://www.tei-c.org/ns/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:hal="http://hal.archives-ouvertes.fr/" xmlns:gml="http://www.opengis.net/gml/3.3/" xmlns:gmlce="http://www.opengis.net/gml/3.3/ce" version="1.1" xsi:schemaLocation="http://www.tei-c.org/ns/1.0 http://api.archives-ouvertes.fr/documents/aofr-sword.xsd">
  <teiHeader>
    <fileDesc>
      <titleStmt>
        <title>HAL TEI export of hal-01513296v2</title>
      </titleStmt>
      <publicationStmt>
        <distributor>CCSD</distributor>
        <availability status="restricted">
          <licence target="https://creativecommons.org/publicdomain/zero/1.0/">CC0 1.0 - Universal</licence>
        </availability>
        <date when="2026-05-04T11:29:11+02:00"/>
      </publicationStmt>
      <sourceDesc>
        <p part="N">HAL API Platform</p>
      </sourceDesc>
    </fileDesc>
  </teiHeader>
  <text>
    <body>
      <listBibl>
        <biblFull>
          <titleStmt>
            <title xml:lang="fr">Bases de données relationnelles : une application web pour découvrir la concurrence d’accès</title>
            <author role="aut">
              <persName>
                <forename type="first">Julien</forename>
                <surname>Grynberg</surname>
              </persName>
              <idno type="halauthorid">612506-0</idno>
              <affiliation ref="#struct-476527"/>
              <affiliation ref="#struct-203447"/>
            </author>
            <editor role="depositor">
              <persName>
                <forename>Isabelle</forename>
                <surname>Rey</surname>
              </persName>
              <email type="md5">b7feb3f08710195373402652d8e5b7b9</email>
              <email type="domain">inria.fr.invalid</email>
            </editor>
          </titleStmt>
          <editionStmt>
            <edition n="v1">
              <date type="whenSubmitted">2017-04-25 09:20:40</date>
            </edition>
            <edition n="v2" type="current">
              <date type="whenSubmitted">2017-07-03 11:36:31</date>
              <date type="whenWritten">2017-04</date>
              <date type="whenModified">2026-03-16 16:28:05</date>
              <date type="whenReleased">2017-07-04 10:42:59</date>
              <date type="whenProduced">2017-06</date>
              <date type="whenEndEmbargoed">2017-07-03</date>
              <ref type="file" target="https://inria.hal.science/hal-01513296v2/document">
                <date notBefore="2017-07-03"/>
              </ref>
              <ref type="file" subtype="author" n="1" target="https://inria.hal.science/hal-01513296v2/file/RT-Bador-V2.pdf" id="file-1552498-1607319">
                <date notBefore="2017-07-03"/>
              </ref>
            </edition>
            <respStmt>
              <resp>contributor</resp>
              <name key="101713">
                <persName>
                  <forename>Isabelle</forename>
                  <surname>Rey</surname>
                </persName>
                <email type="md5">b7feb3f08710195373402652d8e5b7b9</email>
                <email type="domain">inria.fr.invalid</email>
              </name>
            </respStmt>
          </editionStmt>
          <publicationStmt>
            <distributor>CCSD</distributor>
            <idno type="halId">hal-01513296</idno>
            <idno type="halUri">https://inria.hal.science/hal-01513296</idno>
            <idno type="halBibtex">grynberg:hal-01513296</idno>
            <idno type="halRefHtml">[Rapport de recherche] Inria. 2017, pp.12</idno>
            <idno type="halRef">[Rapport de recherche] Inria. 2017, pp.12</idno>
            <availability status="restricted">
              <licence target="https://about.hal.science/hal-authorisation-v1/">HAL Authorization<ref corresp="#file-1552498-1607319"/></licence>
            </availability>
          </publicationStmt>
          <seriesStmt>
            <idno type="stamp" n="SHS">Sciences de l'Homme et de la Société</idno>
            <idno type="stamp" n="TICE">Bibliothèque TICE</idno>
            <idno type="stamp" n="INRIA">INRIA - Institut National de Recherche en Informatique et en Automatique</idno>
            <idno type="stamp" n="INRIA_TEST">INRIA - Institut National de Recherche en Informatique et en Automatique</idno>
            <idno type="stamp" n="TESTALAIN1">TESTALAIN1</idno>
            <idno type="stamp" n="INRIA2">INRIA 2</idno>
            <idno type="stamp" n="LARA">LARA</idno>
            <idno type="stamp" n="INRIA2017">INRIA2017</idno>
            <idno type="stamp" n="INRIA_WEB">Inria &amp; web</idno>
          </seriesStmt>
          <notesStmt>
            <note type="report" n="6">Research Report</note>
          </notesStmt>
          <sourceDesc>
            <biblStruct>
              <analytic>
                <title xml:lang="fr">Bases de données relationnelles : une application web pour découvrir la concurrence d’accès</title>
                <author role="aut">
                  <persName>
                    <forename type="first">Julien</forename>
                    <surname>Grynberg</surname>
                  </persName>
                  <idno type="halauthorid">612506-0</idno>
                  <affiliation ref="#struct-476527"/>
                  <affiliation ref="#struct-203447"/>
                </author>
              </analytic>
              <monogr>
                <imprint>
                  <biblScope unit="pp">12</biblScope>
                  <date type="datePub">2017-06</date>
                </imprint>
                <authority type="institution">Inria</authority>
              </monogr>
            </biblStruct>
          </sourceDesc>
          <profileDesc>
            <langUsage>
              <language ident="fr">French</language>
            </langUsage>
            <textClass>
              <keywords scheme="author">
                <term xml:lang="en"> django</term>
                <term xml:lang="en"> mysql</term>
                <term xml:lang="en"> isolation level</term>
                <term xml:lang="en"> application</term>
                <term xml:lang="en"> python</term>
                <term xml:lang="en">Database</term>
                <term xml:lang="en"> access concurrency</term>
              </keywords>
              <classCode scheme="halDomain" n="shs.edu">Humanities and Social Sciences/Education</classCode>
              <classCode scheme="halDomain" n="info.info-db">Computer Science [cs]/Databases [cs.DB]</classCode>
              <classCode scheme="halTypology" n="REPORT">Reports</classCode>
              <classCode scheme="halOldTypology" n="REPORT">Reports</classCode>
              <classCode scheme="halTreeTypology" n="REPORT.RESREPORT">Reports - Research report</classCode>
            </textClass>
            <abstract xml:lang="en">
              <p>As part of an MOOC on relational databases launched in January 2016, we developed a web application allowing each learner to test a succession of SQL queries. This interface proposes to execute requests on two parallel transactions, it allows students to play with database concurrency.The authors of the MOOC wanted to have a solution integrated into their course so that students could grasp complex theoretical notions by the practice, without having to leave the platform on which they were. This also allowed them not to mention installing an SQL environment that can be unpleasant to students.</p>
            </abstract>
            <abstract xml:lang="fr">
              <p>Dans le cadre d’un MOOC sur les bases de données relationnelles lancé en janvier 2016, nous avons développé une application web permettant à chaque apprenant de tester simplement une succession de requêtes SQL. Cette interface proposait d’exécuter des requêtes sur deux transactions parallèles afin de donner aux étudiants la possibilité d’appréhender la concurrence d’accès sur une base de données.Les auteurs du MOOC souhaitaient disposer d’une solution intégrée à leur cours pour que les étudiants puissent appréhender des notions théoriques complexes par la pratique, sans avoir à quitter la plateforme sur laquelle ils étaient. Cela leur permettait également de ne pas évoquer l’installation d’un environnement SQL qui peut être lourd et rebutant pour les étudiants.</p>
            </abstract>
          </profileDesc>
        </biblFull>
      </listBibl>
    </body>
    <back>
      <listOrg type="structures">
        <org type="researchteam" xml:id="struct-476527" status="VALID">
          <orgName>Inria Learning Lab</orgName>
          <orgName type="acronym">ILL</orgName>
          <desc>
            <address>
              <country key="FR"/>
            </address>
            <ref type="url">https://learninglab.inria.fr/</ref>
          </desc>
          <listRelation>
            <relation active="#struct-1159207" type="direct"/>
            <relation active="#struct-207728" type="indirect"/>
            <relation active="#struct-300009" type="indirect"/>
          </listRelation>
        </org>
        <org type="department" xml:id="struct-203447" status="OLD">
          <orgName>Service E-Information Scientifique et Multimédia</orgName>
          <orgName type="acronym">SEISM</orgName>
          <desc>
            <address>
              <addrLine>Inria Grenoble - Rhône-Alpes, Inovallée 655 avenue de l'Europe, Montbonnot 38 334 Saint Ismier Cedex</addrLine>
              <country key="FR"/>
            </address>
          </desc>
          <listRelation>
            <relation active="#struct-207728" type="direct"/>
            <relation active="#struct-300009" type="indirect"/>
          </listRelation>
        </org>
        <org type="department" xml:id="struct-1159207" status="VALID">
          <orgName>Direction de la Culture et de l’Information Scientifiques</orgName>
          <orgName type="acronym">DCIS</orgName>
          <desc>
            <address>
              <country key="FR"/>
            </address>
          </desc>
          <listRelation>
            <relation active="#struct-207728" type="direct"/>
            <relation active="#struct-300009" type="indirect"/>
          </listRelation>
        </org>
        <org type="laboratory" xml:id="struct-207728" status="VALID">
          <idno type="RNSR">196724818Z</idno>
          <orgName>Inria Siège</orgName>
          <desc>
            <address>
              <addrLine>Domaine de Voluceau 78150 Rocquencourt</addrLine>
              <country key="FR"/>
            </address>
          </desc>
          <listRelation>
            <relation active="#struct-300009" type="direct"/>
          </listRelation>
        </org>
        <org type="institution" xml:id="struct-300009" status="VALID">
          <idno type="ROR">https://ror.org/02kvxyf05</idno>
          <orgName>Institut National de Recherche en Informatique et en Automatique</orgName>
          <orgName type="acronym">Inria</orgName>
          <desc>
            <address>
              <addrLine>Domaine de VoluceauRocquencourt - BP 10578153 Le Chesnay Cedex</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.inria.fr/en/</ref>
          </desc>
        </org>
      </listOrg>
    </back>
  </text>
</TEI>