SD-SQL Server: Scalable Distributed Database System

We present a scalable distributed database system called SD-SQL Server. Its original feature is the dynamic and transparent repartitioning of growing tables, avoiding the cumbersome manual repartitioning characterizing the current technology. SD-SQL Server re-partionns a table when an insert overflows its existing segments. This triggers the split resorbing the overflow by migrating tuples to new segments. With the comfort of a single node SQL Server user, the SD-SQL Server user disposes of larger tables or gets a faster response time through the dynamic query parallelism. We present the architecture of our system, its user/application interface, our implementation and its performance analysis. We show that the overhead of our scalable table management should be typically negligible.

• Type: Journal
• Year: 2007
• Where: IAJIT
• Authors: Soror Sahri
• Keywords: IAJIT 2007, Scalable Distributed Database, SD-SQL Server, Server User