An Overview of a Scalable Distributed Database System SD-SQL Server

Litwin, Witold; Sahri, Soror; Schwarz, Thomas

doi:10.1007/11788911_2

Cited by 9 publications

(17 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…SD-SQL Server [9] also proposes dynamic reorganization of the segments of scalable tables. The reorganization is, however, issued on the SQL front-end level, which requires special SQL syntax when queries are posted against scalable tables.…”

Section: Related Researchmentioning

confidence: 99%

Self-organizing strategies for a column-store database

Ivanova¹,

Kersten²,

Nes³

2008

Proceedings of the 11th International Conference on Extending Database Technology Advances in Database Technology - EDBT '08

View full text Add to dashboard Cite

Column-store database systems open new vistas for improved maintenance through self-organization. Individual columns are the focal point, which simplify balancing conflicting requirements. This work presents two workload-driven selforganizing techniques in a column-store, i.e. adaptive segmentation and adaptive replication. Adaptive segmentation splits a column into non-overlapping segments based on the actual query load. Likewise, adaptive replication creates segment replicas. The strategies can support different application requirements by trading off the reorganization overhead for storage cost. Both techniques can significantly improve system performance as demonstrated in an evaluation of different scenarios.

show abstract

Section: Related Researchmentioning

confidence: 99%

Self-organizing strategies for a column-store database

Ivanova¹,

Kersten²,

Nes³

2008

Proceedings of the 11th International Conference on Extending Database Technology Advances in Database Technology - EDBT '08

View full text Add to dashboard Cite

show abstract

“…Most of scalable commands apply also to static tables and views. Details of all the SD-SQL Server commands are in [12,13,14]. The rule for an SD-SQL Server command performing an SQL operation is to use the SQL command name (verb) prefixed with 'sd_' and with all the blanks replaced with '_'.…”

Section: Overviewmentioning

confidence: 99%

“…The image internal name is SD.Dell3_Photoobj, as we discuss in [10]. Once the Ceria1 user does not need its image anymore, s/he may remove it through the command:…”

Section: Sd_create_index 'Run_index On Photoobj (Run)'mentioning

confidence: 99%

“…The query measures included the overhead of the image checking alone, of image adjustment and of image binding for various queries, [12,13]. Here, we discuss this query:…”

Section: Performance Analysismentioning

confidence: 99%

“…Whenever an adjustment is needed, the database administrator needs to manually repartition. Our proposal, SD-SQL Server, avoids this cumbersome task by dynamically adjusting table growth through autonomous splitting of table segments [9,11,12,13,14]. SD-SQL is a distributed system that uses the services of SQL server.…”

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

Scalable Web Services Interface for SD-SQL Server

Sahri

Litwin

Schwarz

2008

Proceedings of the Third International ICST Conference on Scalable Information Systems

Self Cite

View full text Add to dashboard Cite

SD-SQL Server is a scalable distributed database system. Its original feature is dynamic and transparent repartitioning of growing tables. It avoids the cumbersome manual repartitioning necessary with current technology. SD-SQL Server re-partitions a (distributed) table when an insert overflows existing segments. To its user, SD_SQL offers the comfort of a single node, while allowing the larger tables and faster response time made possible by dynamic parallelism. We present the architecture of our system and its command interface. We present the Extended Web Services (EWS) Interface we have recently added to SD-SQL Server. We study the relative EWS query speed. It remains insufficient for larger data sets to be retrieved.

show abstract

Flexible and Efficient Information Handling

2006

Lecture Notes in Computer Science

View full text Add to dashboard Cite

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.

show abstract

An Overview of a Scalable Distributed Database System SD-SQL Server

Cited by 9 publications

References 5 publications

Self-organizing strategies for a column-store database

Self-organizing strategies for a column-store database

Scalable Web Services Interface for SD-SQL Server

Flexible and Efficient Information Handling

Contact Info

Product

Resources

About