Dynamic analysis of some relational data bases parameters, Theoretical Computer Science (A).pdfVIP

Dynamic analysis of some Relational Data Bases parameters I I Equijoin and semijoin Daniele GARDY Guy LOUCHARDy February Abstract In a relational database submitted to a sequence of queries and up dates we show that we can describ e a couple of relations by a bidimensional sto chastic pro cess We then prove that the size of their equijoin or semijoin can b e describ ed asymptotically by a gaussian nonmarkovian pro cess Keywords relational database derived relation gaussian pro cess join size Intro duction This pap er is a sequel to the rst pap er which deals with pro jections Here we consider joins equijoin and semijoin The rst pap er will b e denoted by G L The present pap er is organized as follows Section presents the joins and urns mo dels Section describ es the new twodimensional pro cesses related to the total numb er of balls Section deals with a preliminary lemma generalizing Lemma of G L Section analyzes the nonrandom static structure related to the the join mo del Section presents the main result of this pap er corresp onding to the complete random structure Section concludes the pap er An App endix provides the dierent supplementary asymptotic formulae we need for the join mo del Lab oratoire PRISM Universite de Versailles SaintQuentin Versailles France This research was partly supp orted by ESPRIT I I IBasic Research Action ALCOM I Ino by the CNRS PRC MathematiqueInformati que and by a co op eration b etween the CNRS and the FNRS y Departemen t dInformatique Universite Libre de Bruxelles Bruxelles Belgique This research was partially supp orted by a co op eration b etween the FNRS and the CNRS