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}
}
  • D. Chamberlin
  • Published 1 October 2012
  • Computer Science
  • IEEE Annals of the History of Computing
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

Chapter 2 : Traditional RDBMS Systems Introduced by Michael Stonebraker
TLDR
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
TLDR
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
TLDR
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
TLDR
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
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
TLDR
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
TLDR
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
TLDR
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
TLDR
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
TLDR
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.
...
1
2
...

References

SHOWING 1-8 OF 8 REFERENCES
SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control
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
TLDR
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
  • E. Codd
  • Computer Science
    SIGFIDET '71
  • 1971
TLDR
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
TLDR
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
TLDR
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