SQL: From Traditional Databases to Big Data
SQL: From Traditional Databases to Big Data
复制标题
DOI：
10.1145/2839509.2844560
复制
发表时间：
2016-02
期刊：
影响因子：
--
通讯作者：
Yasin N. Silva;Isadora Almeida;Michell Queiroz
中科院分区：
文献类型：
--
作者：
Yasin N. Silva;Isadora Almeida;Michell Queiroz
结构化查询语言(SQL)是设计用于管理存储在数据库系统中的数据的主要编程语言。虽然SQL最初只与关系数据库管理系统(RDBMS)一起使用，但随着新型数据库系统的出现，它的使用已显著扩展。具体地说，在处理大数据的高度分布式和可扩展系统中，SQL已被发现是一种强大的查询语言，即具有大容量、速度和多样性的数据集。虽然传统关系数据库现在只占数据库系统领域的一小部分，但大多数介绍SQL的数据库课程只考虑在传统关系系统环境中使用SQL。在本文中，我们建议将SQL作为一种通用语言进行教学，该语言可用于从传统RDBMS到大数据系统的各种数据库系统。本文提出了在新型数据库系统包括MapReduceNoSQL和NewSQL的环境中引入SQL的结构良好的指导方针。本白皮书的一个主要贡献是描述了一系列课程资源，例如，虚拟机、样例项目和课堂练习，以实现在广泛的现代数据库系统中使用SQL的实践体验。
The Structured Query Language (SQL) is the main programing language designed to manage data stored in database systems. While SQL was initially used only with relational database management systems (RDBMS), its use has been significantly extended with the advent of new types of database systems. Specifically, SQL has been found to be a powerful query language in highly distributed and scalable systems that process Big Data, i.e., datasets with high volume, velocity and variety. While traditional relational databases represent now only a small fraction of the database systems landscape, most database courses that cover SQL consider only the use of SQL in the context of traditional relational systems. In this paper, we propose teaching SQL as a general language that can be used in a broad range of database systems from traditional RDBMSs to Big Data systems. This paper presents well-structured guidelines to introduce SQL in the context of new types of database systems including MapReduce, NoSQL and NewSQL. A key contribution of this paper is the description of an array of course resources, e.g., virtual machines, sample projects, and in-class exercises, to enable a hands-on experience with SQL across a broad set of modern database systems.