1 / 7

How do large-scale sites and applications remain SQL-based?

How do large-scale sites and applications remain SQL-based?. G3 Alex Breyfogle & Kao-Ying Chen Rys , Michael. “Scalable SQL:How do large-scale sites and applications remain SQL-based?,” Communications of the ACM. Vol. 54 No. 6, Pages 48-53 10.1145/1953122.1953141. Web. 10 Feb. 2014.

laura-vincent
Download Presentation

How do large-scale sites and applications remain SQL-based?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How do large-scale sites and applications remain SQL-based? G3 Alex Breyfogle & Kao-Ying Chen Rys, Michael. “Scalable SQL:How do large-scale sites and applications remain SQL-based?,” Communications of the ACM. Vol. 54 No. 6, Pages 48-53 10.1145/1953122.1953141. Web. 10 Feb. 2014.

  2. Why does the industry still use SQL? • Relevance: Relational Databases, Usage. • NoSQL databases claim to have higher scalability than traditional SQL databases • Yet giant social media sites such as Facebook and Twitter still use SQL

  3. Parallel Processing to Scale-up SQL • Parallel Processing (chapter 15) • Relaxing Data Consistency Constraints (chapter 8)

  4. Relaxing Data Consistency • Data and Functional Partitioning can allow more data flexibility

  5. Scale-Up: Distributed Processing to Scale-up SQL • Service Broker allows for asynchrony and high scalability

  6. In the End • SQL is still used widely in large scale databases • SQL can be up-scaled by taking advantage of parallel processing and relaxed data consistency constraints

  7. Questions?

More Related