Relational Database Programming

A Set-Oriented Approach



Bookstore > Books > Relational Database Programming

Price$34.99 - $40.09
Rating
AuthorStefan Ardeleanu
PublisherApress
Published2016
Pages176
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-10148422079X
ISBN-139781484220795
EBook Hardcover Paperback

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.





4 5 2

Similar Books


PostgreSQL 11 Server Side Programming Quick Start Guide

PostgreSQL 11 Server Side Programming Quick Start Guide

by Luca Ferrari

PostgreSQL is a rock-solid, scalable, and safe enterprise-level relational database. With a broad range of features and stability, it is ever increasing in popularity.This book shows you how to take advantage of PostgreSQL 11 features for server-side programming. Server-side programming enables strong data encapsulation and coherence.The ...

Price:  $39.99  |  Publisher:  Packt Publishing  |  Release:  2018

Introductory Relational Database Design for Business

Introductory Relational Database Design for Business

by Jonathan Eckstein, Bonnie R. Schultz

Relational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less background, but they focus pr...

Price:  $80.00  |  Publisher:  Wiley  |  Release:  2018

Practical Database Programming with Visual Basic.NET, 2nd Edition

Practical Database Programming with Visual Basic.NET, 2nd Edition

by Ying Bai

Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual S...

Price:  $59.45  |  Publisher:  Wiley  |  Release:  2012

The Relational Database Dictionary, Extended Edition

The Relational Database Dictionary, Extended Edition

by C. J. Date

Chris Date, one of the founders of the relational model, has updated and expanded his relational database dictionary to include more than 900 terms.Over 900 relational database terms defined; Precise and concise definitions, unlike those found on Wikipedia and other sources; Clear examples used where appropriate; Hyperlinks included in th...

Price:  $16.51  |  Publisher:  Apress  |  Release:  2008

Pro SQL Server 2012 Relational Database Design and Implementation

Pro SQL Server 2012 Relational Database Design and Implementation

by Louis Davidson, Jessica M. Moss

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a soli...

Price:  $31.12  |  Publisher:  Apress  |  Release:  2012

Apache Sqoop Cookbook

Apache Sqoop Cookbook

by Kathleen Ting, Jarek Jarcec Cecho

Integrating data from multiple sources is essential in the age of big data, but it can be a challenging and time-consuming task. This handy cookbook provides dozens of ready-to-use recipes for using Apache Sqoop, the command-line interface application that optimizes data transfers between relational databases and Hadoop.Sqoop is both powe...

Price:  $12.99  |  Publisher:  O'Reilly Media  |  Release:  2013

The New Relational Database Dictionary

The New Relational Database Dictionary

by C.J. Date

No matter what DBMS you are using - Oracle, DB2, SQL Server, MySQL, PostgreSQL - misunderstandings can always arise over the precise meanings of terms, misunderstandings that can have a serious effect on the success of your database projects. For example, here are some common database terms: attribute, BCNF, consistency, denormalization, ...

Price:  $23.40  |  Publisher:  O'Reilly Media  |  Release:  2015

Learning PostgreSQL

Learning PostgreSQL

by Salahaldin Juba, Achim Vannahme, Andrey Volkov

PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. ...

Price:  $31.51  |  Publisher:  Packt Publishing  |  Release:  2015