Abstract
We present a scalable distributed database system called SD-SQL Server. Its original feature is dynamic and transparent repartitioning of growing tables, avoiding the cumbersome manual repartitioning that characterize current technology. SD-SQL Server re-partitions a table when an insert overflows existing segments. With the comfort of a single node SQL Server user, the SD-SQL Server user has larger tables or gets a faster response time through the dynamic parallelism. We present the architecture of our system, its implementation and the performance analysis. We show that the overhead of our scalable table management should be typically negligible.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Ben-Gan, I., Moreau, T.: Advanced Transact SQL for SQL Server 2000. Apress Editors (2000)
Gray, J., et al.: Data Mining of SDDS SkyServer Database. WDAS, Paris. Carleton Scientific (publ.) (2002)
Gray, J.: The Cost of Messages. In: Proceeding of Principles Of Distributed Systems, Toronto, Canada (1989)
Guinepain, S., Gruenwald, L.: Research Issues in Automatic Database Clustering. In: ACM-SIGMOD (March 2005)
Lejeune, H.: Technical Comparison of Oracle vs. SQL Server 2000: Focus on Performance (December 2003)
Litwin, W., Neimat, M.-A., Schneider, D.L.H.: A Scalable Distributed Data Structure. ACM-TODS (December 1996)
Litwin, W., Neimat, M.-A., Schneider, D.: Linear Hashing for Distributed Files. In: ACM- SIGMOD International Conference on Management of Data (1993)
Litwin, W., Rich, T., Schwarz, T.: Architecture for a scalable Distributed DBSs application to SQL Server 2000. In: 2nd Intl. Workshop on Cooperative Internet Computing (CIC 2002), Hong Kong (August 2002)
Litwin, W., Sahri, S.: Implementing SD-SQL Server: a Scalable Distributed Database System. In: Intl. Workshop on Distributed Data and Structures, WDAS 2004, Lausanne. Carleton Scientific (publ.) (to appear, 2004)
Microsoft SQL Server 2000: SQL Server Books Online
Rao, J., Zhang, C., Lohman, G., Megiddo, N.: Automating Physical Database Design inParallel Database. In: ACM SIGMOD 2002, USA, June 4-6 (2002)
Salzberg, B., Lomet, D.: Special Issue on Online Reorganization. Bulletin of the IEEE Computer Society Technical Committee on Data Engineering (1996)
Özsu, T., Valduriez, P.: Principles of Distributed Database Systems, 2nd edn. Prentice-Hall, Englewood Cliffs (1999)
Litwin, W., Sahri, S., Schwarz, T.: SD-SQL Server: a Scalable Distributed Database System. CERIA Research Report 2005-12-13 (December 2005)
Litwin, W., Sahri, S., Schwarz, T.: Architecture and Interface of Scalable Distributed Database System SD-SQL Server. In: The Intl. Ass. of Science and Technology for Development Conf. on Databases and Applications, IASTED-DBA 2006 (to appear, 2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Litwin, W., Sahri, S., Schwarz, T. (2006). An Overview of a Scalable Distributed Database System SD-SQL Server. In: Bell, D.A., Hong, J. (eds) Flexible and Efficient Information Handling. BNCOD 2006. Lecture Notes in Computer Science, vol 4042. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11788911_2
Download citation
DOI: https://doi.org/10.1007/11788911_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-35969-2
Online ISBN: 978-3-540-35971-5
eBook Packages: Computer ScienceComputer Science (R0)