• français
    • English
  • English 
    • français
    • English
  • Login
JavaScript is disabled for your browser. Some features of this site may not work without it.
BIRD Home

Browse

This CollectionBy Issue DateAuthorsTitlesSubjectsJournals BIRDResearch centres & CollectionsBy Issue DateAuthorsTitlesSubjectsJournals

My Account

Login

Statistics

View Usage Statistics

Design of a Scalable Distributed Database System: SD-SQL Server

Thumbnail
View/Open
sd_sql_server_interface_res_rep.pdf (74.52Kb)
Date
2006
Dewey
Organisation des données
Sujet
Scalable table; dynamic table; partitioning; scalable database; scalable distributed data structure
DOI
http://dx.doi.org/10.1109/ICTTA.2006.1684877
Conference name
Information and Communication Technologies, 2006. ICTTA '06
Conference date
04-2006
Conference city
Damas
Conference country
Syrie
Book title
Information and Communication Technologies, 2006. ICTTA '06. 2nd (Volume:2 )
Publisher
IEEE
Year
2006
ISBN
0-7803-9521-2
URI
https://basepub.dauphine.fr/handle/123456789/13470
Collections
  • LAMSADE : Publications
Metadata
Show full item record
Author
Litwin, Witold
Saari, Soror
Schwarz, Thomas
Type
Communication / Conférence
Item number of pages
2918-2919
Abstract (EN)
To prove the feasibility of an SD-DBS, we have built a prototype called SD-SQL server. The system generalizes the basic SQL server capabilities to scalable tables. We have chosen SQL server since, to the best of our knowledge, it was the only DBMS proposing the updatable distributed union-all partitioned views. SD-SQL server runs on a collection of SQL server linked nodes. For every standard SQL command under SQL server, there is an SD-SQL server command for a similar action on scalable tables or views. There are also commands specific to the management of the SD-SQL server client image or SD-SQL server client node. In this paper, we present the architecture of our prototype and its application command interface in its 2005 version. This architecture contains more features than the reference architecture in "architecture for a scalable distributed DBSs application to SQL server 2000" by Litwin et al. (2002) and "implementing SD-SQL server: a scalable distributed database system" by Litwin and Sahri (2004). We discuss the syntax and semantics of the commands. Numerous examples illustrate their actual use. We hope to convince the reader that the use of the scalable tables is in practice as simple as that of static tables, despite some limitation of our current interface. We view our current prototype as a proof-of-concept system.

  • Accueil Bibliothèque
  • Site de l'Université Paris-Dauphine
  • Contact
SCD Paris Dauphine - Place du Maréchal de Lattre de Tassigny 75775 Paris Cedex 16

 Content on this site is licensed under a Creative Commons 2.0 France (CC BY-NC-ND 2.0) license.