Go to main content

Relational database programming [electronic resource] : a set-oriented approach / Stefan Ardeleanu.

Ardeleanu, Stefan, author.
2016
QA76.9.D32
Available Online
Formats
Format
BibTeX
MARCXML
TextMARC
MARC
DublinCore
EndNote
NLM
RefWorks
RIS
Add to Basket
Cite
Citation

Linked e-resources

Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks

Details

Title
Relational database programming [electronic resource] : a set-oriented approach / Stefan Ardeleanu.
Author
Ardeleanu, Stefan, author.
ISBN
9781484220801 (electronic book)
1484220803 (electronic book)
9781484220795
DOI
https://doi.org/10.1007/978-1-4842-2080-1
Published
[Berkeley, CA] : Apress, 2016.
Distributor
New York, NY : Distributed to the book trade worldwide by Springer,
Copyright
©2016
Language
English
Description
1 online resource (xxi, 149 pages) : color illustrations.
Item Number
10.1007/978-1-4842-2080-1 doi
Call Number
QA76.9.D32
Dewey Decimal Classification
005.75/6
Summary
Learn the best way of writing code to run inside a relational database. This book shows how a holistic and set-oriented approach to database programming can far exceed the performance of the row-by-row model that is too often used by developers who haven't been shown a better way. Two styles of programming are encountered in the database world. Classical programming as taught in many universities leads to an atomic, row-oriented, and procedural style inspired by the structured models of programming. In short, many application developers write in the relational database exactly like in the user interface. The other style of programming is holistic, data set oriented, and coded mainly in SQL. This is the style of the database developer. The set based and holistic style of development is not promoted enough in universities, and many application developers are not fully aware of it. There are many performance issues all over the world in relational databases due to the use of the atomic and inappropriate style of programming. This book compares the two styles, and promotes the holistic style of development as the most suitable one. Examples are given to demonstrate the superiority of a set-based and holistic approach. Compares the two styles of development Shows the performance advantages of set-based development Solves example problems using both approaches.
Note
Includes index.
Access Note
Access limited to authorized users.
Digital File Characteristics
text file PDF
Source of Description
Online resource; title from PDF title page (SpringerLink, viewed July 12, 2016).
Available in Other Form
Print version: 9781484220795
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
Introduction
1. The Concept of Style
2. SQL: Beauty and the Beast!
3. A Holistic Vision Against the Data
4. Data by Set or by Row?
5. Data Transfer Paradigm
6. The Challenge from Scalar Functions
7. Writing SQL versus Writing Procedurally
8. Row Triggers and the Need for Atomic Solutions
9. Final Reflections and Thoughts.

Browse Subjects

Show more subjects...

Statistics

from
to
Export