structured query language
TRANSCRIPT
![Page 1: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/1.jpg)
• Structured Query Language
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 2: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/2.jpg)
Database model Relational model
1 The most common query language used with the relational model is the Structured Query Language (SQL).
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 3: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/3.jpg)
Column (database)
1 Coding involved: SQL [Structured Query
Language]
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 4: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/4.jpg)
SQL
1 SQL (/ˈɛs kjuː ˈɛl/ "S-Q-L", sometimes pronounced /ˈsiːkwəl/ "sequel";
Structured Query Language) is a special-purpose programming
language designed for managing data held in a relational database management system (RDBMS).
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 5: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/5.jpg)
Data manipulation language
1 A popular data manipulation language is that of Structured Query
Language (SQL), which is used to retrieve and manipulate data in a
relational database. Other forms of DML are those used by IMS/DLI,
CODASYL databases, such as IDMS and others.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 6: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/6.jpg)
Data definition language - History
1 Later it was used to refer to a subset of Structured Query Language () for
creating tables and constraints
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 7: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/7.jpg)
Object-relational mapping - Overview
1 However, many popular database products such as structured query language database
management systems (SQL DBMS) can only store and manipulate scalar values such as integers and strings organized within tables.
The programmer must either convert the object values into groups of simpler values for storage in the database (and convert them back upon
retrieval), or only use simple scalar values within the program. Object-relational mapping
is used to implement the first approach.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 8: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/8.jpg)
Information technology
1 The relational database model introduced a programming-language
independent Structured Query Language (SQL), based on relational
algebra.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 9: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/9.jpg)
Structured analysis - Structured query language
1 The structured query language (SQL) is a standardized language for querying information from a
database
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 10: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/10.jpg)
Acronym - Comparing a few examples of each type
1 SQL: ([siːkwəl] or ess-cue-el) Structured Query Language.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 11: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/11.jpg)
Computer appliance - Appliances in industrial automation
1 EATMs (enterprise appliance transaction modules) - Enterprise appliance transaction
modules are appliances that affect data transactions from plant floor automation systems to enterprise business systems.
They communicate to plant floor equipment through various vendor automation protocols,
and communicate to business systems through database communication protocols such as JMS (Java Message Service) and SQL
(Structured Query Language).
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 12: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/12.jpg)
Null (SQL)
1 'Null' is a special marker used in SQL|Structured Query Language (SQL) to indicate that a data value does not
exist in the database
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 13: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/13.jpg)
Temporal database
1 A 'temporal database' is a database with built-in support for handling data involving time, for
example a temporal data model and a temporal version of Structured
Query Language (SQL).
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 14: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/14.jpg)
Microsoft Access - Features
1 One of the benefits of Access from a programmer's perspective is its relative compatibility with SQL (structured query language) —
queries can be viewed Graphical user interface|graphically or edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modular programming|Modules to
manipulate Access tableshttps://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 15: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/15.jpg)
MySQL
1 'MySQL' ( My S-Q-L, officially, but also called My Sequel) is (as of July
2013) the world's second most widely used open-source relational
database management system (RDBMS). It is named after co-
founder Michael Widenius's daughter, My. The SQL phrase stands for Structured Query Language.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 16: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/16.jpg)
MySQL - History
1 They created a new Structured Query Language|SQL interface, while keeping the same Application
programming interface|API as mSQL
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 17: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/17.jpg)
Search oriented architecture
1 Queries for information which would usually be performed using
Structured Query Language (SQL) are replaced by keyword or fielded (or
field-enabled) searches for structured, Semi-structured model|
semi-structured, or unstructured data.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 18: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/18.jpg)
Object-PL/SQL
1 'Object-PL/SQL' ('Object-oriented programming|Object-Procedural
Language/Structured Query Language' or simply 'O-PL/SQL') is a methodology of using the Oracle
Corporation's Procedural programming|procedural extension programming language|language for SQL and the Oracle Database|Oracle relational database. The additional
features from version 7 and other improvements, lead to one of the large-scale environment implementations of the object-
oriented database paradigm.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 19: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/19.jpg)
Tableau Software - History
1 Together, they combined a structured query language for databases with a descriptive language for rendering graphics and invented a database visualization language called VizQL
(Visual Query Language)
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 20: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/20.jpg)
HTSQL
1 'Hyper Text Structured Query Language' (HTSQL) is a schema-driven URI-to-SQL query
language that takes a request over HTTP, converts it to a SQL query, executes the query against a database, and returns the results in a
format best suited for the user agent (CSV, HTML, etc.) http://htsql.org/ The HTSQL language is
implemented on HTSQL servers, which use HTSQL to convert web requests into equivalent SQL,
executes requests on a server-side database, and returns results in XML, HTML, Comma-separated
values|CSV, JSON, or YAML formats
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 21: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/21.jpg)
Data Definition Language - History
1 Later it was used to refer to a subset of Structured Query Language (SQL) for creating Table (database)|tables and Integrity constraints|constraints
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 22: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/22.jpg)
T-SQL
1 SQL, the acronym for Structured Query Language, is a
SQL#Standardization|standardized computer language that was
originally developed by IBM for querying, altering and defining
relational databases, using Declarative programming|declarative
statements
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 23: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/23.jpg)
Strozzi NoSQL (RDBMS)
1 Its file name NoSQL merely reflects the fact that it does not express its
queries using Structured Query Language; the NoSQL RDBMS is
distinct from the circa-2009 general concept of NoSQL|NoSQL databases,
which are typically non-relational, unlike the NoSQL RDBMS
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 24: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/24.jpg)
IBM Informix C-ISAM - History
1 It provided the underlying file storage mechanism for the popular
first generation Informix RDBMS (Relational Database Management
System), which allows data manipulation by way of the SQL
(Structured Query Language) protocol
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 25: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/25.jpg)
Oracle Rdb - Data access
1 Interactive access to the Oracle Rdb can be by SQL (Structured Query
Language), RDO (Relational Database Operator), or both.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 26: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/26.jpg)
Database transactions - Transactional databases
1 In a database system a transaction might consist of one or more data-manipulation
statements and queries, each reading and/or writing information in the database. Users of database systems consider Data consistency|
consistency and data integrity|integrity of data as highly important. A simple
transaction is usually issued to the database system in a language like Structured Query
Language|SQL wrapped in a transaction, using a pattern similar to the following:
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 27: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/27.jpg)
Data retrieval
1 A query language, such as Structured Query Language (SQL), is used to
prepare the queries. SQL is an American National Standards
Institute (ANSI) standardized query language developed specifically to write database queries. Each DBMS
may have its own language, but most relational DBMSs also support SQL.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 28: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/28.jpg)
SQL/XML
1 'SQL/XML' or 'XML-Related Specifications' is an extension to the
Structured Query Language (SQL) specification, which defines the use of XML in conjunction with SQL. The XML data type is introduced, as well as several routines, functions, and XML-to-SQL data type mappings to
support manipulation and storage of XML in a SQL database.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 29: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/29.jpg)
Greenplum - Technology
1 In addition to traditional SQL|Structured Query Language (SQL), in
2008 support was announced for MapReduce queries within a parallel
dataflow engine, to run analytics against datasets stored in and
outside of the Greenplum Database.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 30: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/30.jpg)
PL/SQL
1 'PL/SQL' ('Procedural Language/Structured Query Language') is Oracle Corporation's
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 31: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/31.jpg)
Btrieve
1 The Btrieve front-end supported the Btrieve API and the other front-end
was called Scalable SQL, a relational database product based upon the MKDE that used its own variety of
Structured Query Language, otherwise known as SQL
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 32: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/32.jpg)
Aster Data Systems - Products
1 Aster Data created a framework called SQL-MapReduce that allows
the SQL|Structured Query Language (SQL) to be used with the MapReduce
paradigm from Google.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 33: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/33.jpg)
Delete (SQL)
1 In the database structured query language (SQL), the 'DELETE' statement
removes one or more records from a Table (database)|table. A subset may be defined for deletion using a condition,
otherwise all records are removed. Some DBMSs, like MySQL, allow to delete rows
from multiple tables with one DELETE statement (this is sometimes called
multi-table DELETE).
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 34: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/34.jpg)
IBM Rational Software Architect - Overview
1 ### UML to structured query language (SQL)-based logical data
models as supported by IBM Rational Data Architect software.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 35: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/35.jpg)
PeopleCode
1 Other language features, such as PeopleCode data types and
metastrings, reflect the close interaction of PeopleTools and
Structured Query Language (SQL)
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 36: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/36.jpg)
Data Control Language
1 A 'data control language' ('DCL') is a syntax similar to a computer
programming language used to control access to data stored in a
database. In particular, it is a component of Structured Query
Language (SQL).
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 37: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/37.jpg)
Donald D. Chamberlin - Biography
1 Chamberlin is probably best known as co-inventor of SQL (Structured
Query Language), the world's most widely used database language
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 38: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/38.jpg)
Donald D. Chamberlin - Biography
1 In 2009, he was made a Fellow of the Computer History Museum for his fundamental work on structured
query language (SQL) and database architectures.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 39: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/39.jpg)
Object-relational mapper - Overview
1 However, many popular database products such as structured query language database management
systems (SQL DBMS) can only store and manipulate Scalar (computing)|scalar values such as integers and
strings organized within Table (database)|tables
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 40: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/40.jpg)
IBM SQL/DS
1 'SQL/DS' (Structured Query Language/Data System), released in
1981, was IBM's first commercial relational database management system. It implemented the SQL
database query language.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 41: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/41.jpg)
Microsoft Query by Example
1 The QBE system converts the user input into a formal database query
using SQL|Structured Query Language (SQL) on the backend,
allowing the user to perform powerful searches without having to explicitly compose them in SQL, and without
even needing to know SQL
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 42: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/42.jpg)
Rainstor - Product
1 RainStor's database product can reportedly load ~1m records per second. The database
uses a row/columnar hybrid repository, which activates 20x to 40x compression
and data retrieval. The access to the archived data is completed using Structured
Query Language (SQL), a programming language used for managing data. RainStor
software uses partition filtering, which excludes certain records from processing.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 43: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/43.jpg)
Grid Laboratory Uniform Environment - Technologies
1 The abstract schema can be mapped into specific data models using XML|Extensible Markup Language (XML),
Lightweight Directory Access Protocol (LDAP), or SQL|Structured Query
Language (SQL)
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 44: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/44.jpg)
Standard Interchange Language
1 It is a subset of SQL (Structured Query Language) and acts as an
interface standard for transferring data between proprietary store
systems like Direct Store Delivery|DSD (Direct Store Delivery) and Point
of sale|POS (Point Of Sale)
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 45: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/45.jpg)
SQL PL
1 'SQL PL' stands for SQL|Structured Query Language Procedural Language and was
developed by IBM as a set of commands that extend the use of SQL in the IBM DB2 (DB2 UDB
Version 7) database system.[http://publib.boulder.ibm.com/infocente
r/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.sql.doc/doc/
c0011916.htm IBM Info Center] It provides procedural programming|procedural
programmability in addition to the querying commands of SQL
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 46: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/46.jpg)
Mondrian OLAP server
1 * Parsing the MDX language into Structured Query Language (SQL) to
retrieve answers to dimensional queries
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 47: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/47.jpg)
Network appliance - Appliances in industrial automation
1 # 'EATMs (enterprise appliance transaction modules)' - Enterprise appliance transaction
modules are appliances that affect data transactions from plant floor automation systems to enterprise business systems.
They communicate to plant floor equipment through various vendor automation protocols,
and communicate to business systems through database communication protocols such as JMS (Java Message Service) and SQL
(SQL|Structured Query Language).
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 48: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/48.jpg)
TurboIMAGE
1 Today it is known as 'IMAGE/SQL' because it includes an SQL
(Structured Query Language) frontend and client-server support for
PC accessors.
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 49: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/49.jpg)
HOLMES 2 - Technical details
1 While searches themselves were tuned at the SQL (Structured Query Language) level, additional indexes
on the Relational database management system|RDBMS
(relational database management system) tables were deployed.For
further information about the technical details of the system see
http://www.holmes2.com/holmes2/whatish2/techdetail/
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 50: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/50.jpg)
Digital History - Technology
1 Databases with features like Structured Query Language (SQL) and Extensible Markup Language
(XML) arrange materials in a formal manner and allow precise searching for keywords, dates, and other data
characteristics
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 51: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/51.jpg)
List of Stanford University people - Computer science and electrical engineering
1 *Donald D. Chamberlin (M.S., Ph.D in EE), coinventor of SQL (Structured Query Language), SIGMOD Edgar F.
Codd Innovations Award
https://store.theartofservice.com/the-structured-query-language-toolkit.html
![Page 52: Structured Query Language](https://reader035.vdocuments.us/reader035/viewer/2022070406/56649e0e5503460f94af80a8/html5/thumbnails/52.jpg)
For More Information, Visit:
• https://store.theartofservice.com/the-structured-query-language-toolkit.html
The Art of Servicehttps://store.theartofservice.com