Early History of SQL
@article{Chamberlin2012EarlyHO, title={Early History of SQL}, author={Donald D. Chamberlin}, journal={IEEE Annals of the History of Computing}, year={2012}, volume={34}, pages={78 - 82} }
One of the most important research areas in computer science in the early 1970s was the development of systems and languages for handling what computer scientists call persistent data. This term denotes data that remains in a computer system indefinitely, until it is explicitly deleted. Systems for managing persistent data were spreading quickly in the business world. A database management language proposed by the Codasyl Data Base Task Group (DBTG) was receiving a lot of attention. In this…
Tables from this paper
18 Citations
Chapter 2 : Traditional RDBMS Systems Introduced by Michael Stonebraker
- Computer Science
- 2016
The System R project started under the direction of Frank King at IBM Research probably around 1972, and quickly decided to implement SQL, which morphed from a clean block structured language in 1972 to a much more complex structure described in the paper here.
Supercomputing Technologies as Drive for Development of Enterprise Information Systems and Digital Economy
- Computer ScienceSupercomput. Front. Innov.
- 2020
The article justifies the importance of machine learning in the context of effective big data analysis and competitive gain for business, vital for both maintaining a leading position in the market and surviving in conditions of global instability and digitalization of economy.
Brief Review on SQL and NoSQL
- Computer Science
- 2017
An overview on CAP in GDB and ACID properties in RDBMS is given and then why both developers and enterprises typically aim at providing simple, yet very efficient, solutions for specific problems to speed, data flexibility and unprecedented levels of scale is given.
Migration of Legacy Web Application Using NoSQL Databases
- Computer Science
- 2013
The approach in this research incorporates document-oriented databases to enhance the process of data migration and the result is that the dynamic schema of document- oriented databases makes the migration process more agile and accurate.
Synthesis of SQL Queries from Narrations
- Computer Science2019 6th International Conference on Soft Computing & Machine Intelligence (ISCMI)
- 2019
Structured Query Language (SQL) remains a standard language used in Relational Database Management Systems (RDBMSs), and has found applications in healthcare (patient registries), businesses…
An Outlook to Declarative Languages for Big Steaming Data
- Computer ScienceDEBS
- 2019
This tutorial focuses on introducing various approaches for declarative querying of the state-of-the-art big data streaming frameworks using a variety of SQL-like languages, such as Flink-SQL, KSQL and Spark Streaming SQL.
Interdisciplinary programming language design
- Computer ScienceOnward!
- 2018
It is argued that the addition of user-oriented design techniques can be helpful at many different stages in the programming language design process.
S-NAR: generating narrations of SQL queries using regular expressions
- Computer ScienceSAICSIT '17
- 2017
A tool is designed, called S-NAR (or Sql-N ARrator), that reads queries and generates a narration of these queries using pre-defined templates and should find applications in aiding comprehension in the teaching of database courses at higher institutions of learning, and assisting the comprehension of legacy queries in data-centered industries.
Evaluation Performance evaluation User experiments Case studies Expert evaluation Formalism and proof ! alitative user studies Requirements and Creation Interviews Corpus studies Natural Programming Rapid Prototyping
- Computer Science
- 2018
It is argued that the addition of user-oriented design techniques can be helpful at many different stages in the programming language design process.
Research and Implementation of a New Retrieve for Auto Parts BOM
- Computer Science
- 2016
For wide varieties of auto parts and it is difficult to be managed, a new method was put forward based on the conventional depth retrieve method and breadth retrieve method, which improve search capacity and the efficiency of the retrieve system.
References
SHOWING 1-8 OF 8 REFERENCES
SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control
- Computer ScienceIBM J. Res. Dev.
- 1976
SEQUEL 2 is a relational data language that provides a consistent, English keyword-oriented set of facilities for query, data definition, data manipulation, and datac ontrol. SEQUEL 2 may be used…
Specifying queries as relational expressions: the SQUARE data sublanguage
- Computer ScienceCACM
- 1975
A data sublanguage called SQUARE, intended for use in ad hoc, interactive problem solving by non-computer specialists, and is shown to be relationally complete; however, it avoids the quantifiers and bound variables required by languages based on the relational calculus.
A data base sublanguage founded on the relational calculus
- Computer ScienceSIGFIDET '71
- 1971
Three principal types of language for data base manipulation are identified: the low-level, procedure-oriented, intermediate level, algebraic, and the high level, relational calculus-based data sublanguage, an example of which is described in this paper.
Database Systems: The Complete Book
- Computer Science
- 2001
This introduction to database systems offers a readable comprehensive approach with engaging, real-world examples, and users will learn how to successfully plan a database application before building it.
SEQUEL: A structured English query language
- Computer ScienceSIGFIDET '74
- 1974
The data manipulation facility for a structured English query language (SEQUEL) which can be used for accessing data in an integrated relational data base.
introduced the operators of relational algebra in ‘‘Relational Completeness
- October–December
- 2012
Does Your DBMS Run by the Rules?’
- Computer World,
- 1985
and D
- Chamberlin, ‘‘Using a Structured English Query Language as a Data Definition Facility,’’ IBM Research Report RJ1318, Dec.
- 1973