skip to content
Relational database programming : a set-oriented approach Preview this item
ClosePreview this item
Checking...

Relational database programming : a set-oriented approach

Author: Stefan Ardeleanu
Publisher: [Berkeley, CA] : Apress, New York, NY : Distributed to the Book trade worldwide by Springer 2016. ©2016
Edition/Format:   eBook : Document : EnglishView all editions and formats
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,  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Printed edition:
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Stefan Ardeleanu
ISBN: 9781484220801 1484220803 148422079X 9781484220795
OCLC Number: 952706050
Description: 1 online resource (xxi, 149 pages) : color illustrations
Contents: 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.
Responsibility: Stefan Ardeleanu.

Abstract:

Tagline: Database performance through set-based development practices  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Related Subjects:(2)

User lists with this item (1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/952706050> # Relational database programming : a set-oriented approach
    a schema:CreativeWork, schema:MediaObject, schema:Book ;
    library:oclcnum "952706050" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/3313641628#Topic/relational_databases> ; # Relational databases
    schema:about <http://dewey.info/class/005.756/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/3313641628#Topic/computers_programming_languages_sql> ; # COMPUTERS--Programming Languages--SQL
    schema:author <http://experiment.worldcat.org/entity/work/data/3313641628#Person/ardeleanu_stefan> ; # Stefan Ardeleanu
    schema:bookFormat schema:EBook ;
    schema:datePublished "2016" ;
    schema:description "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."@en ;
    schema:description "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."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/3313641628> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/3313641628#CreativeWork/> ;
    schema:name "Relational database programming : a set-oriented approach"@en ;
    schema:productID "952706050" ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1261445> ;
    schema:url <http://dx.doi.org/10.1007/978-1-4842-2080-1> ;
    schema:url <https://link.springer.com/openurl?genre=book&isbn=978-1-4842-2079-5> ;
    schema:url <http://proquest.safaribooksonline.com/9781484220801> ;
    schema:url <http://link.springer.com/10.1007/978-1-4842-2080-1> ;
    schema:url <http://resolver.library.cornell.edu/cgi-bin/EBookresolver?set=Books24x7&id=115819> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=4573578> ;
    schema:url <http://link.springer.com/openurl?genre=book&isbn=978-1-4842-2079-5> ;
    schema:url <http://www.books24x7.com/marc.asp?bookid=115819> ;
    schema:url <http://www.myilibrary.com?id=938383> ;
    schema:url <https://grinnell.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-2080-1> ;
    schema:url <https://proquest.safaribooksonline.com/9781484220801> ;
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=4573578> ;
    schema:url <https://0-link-springer-com.pugwash.lib.warwick.ac.uk/book/10.1007/978-1-4842-2080-1> ;
    schema:url <http://sfx.carli.illinois.edu/sfxwhe/sfx_local?genre=book&sid=Voyager:WHE&sfx.ignore_date_threshold=1&svc.fulltext=yes&rft.isbn=978-1-4842-2080-1> ;
    schema:workExample <http://worldcat.org/isbn/9781484220795> ;
    schema:workExample <http://worldcat.org/isbn/9781484220801> ;
    schema:workExample <http://dx.doi.org/10.1007/978-1-4842-2080-1> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/952706050> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/3313641628#Person/ardeleanu_stefan> # Stefan Ardeleanu
    a schema:Person ;
    schema:familyName "Ardeleanu" ;
    schema:givenName "Stefan" ;
    schema:name "Stefan Ardeleanu" ;
    .

<http://experiment.worldcat.org/entity/work/data/3313641628#Topic/computers_programming_languages_sql> # COMPUTERS--Programming Languages--SQL
    a schema:Intangible ;
    schema:name "COMPUTERS--Programming Languages--SQL"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/3313641628#Topic/relational_databases> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;
    .

<http://resolver.library.cornell.edu/cgi-bin/EBookresolver?set=Books24x7&id=115819>
    rdfs:comment "Connect to full text. Access restricted to authorized subscribers." ;
    .

<http://worldcat.org/entity/work/data/3313641628#CreativeWork/>
    a schema:CreativeWork ;
    schema:description "Printed edition:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/952706050> ; # Relational database programming : a set-oriented approach
    .

<http://worldcat.org/isbn/9781484220795>
    a schema:ProductModel ;
    schema:isbn "148422079X" ;
    schema:isbn "9781484220795" ;
    .

<http://worldcat.org/isbn/9781484220801>
    a schema:ProductModel ;
    schema:isbn "1484220803" ;
    schema:isbn "9781484220801" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.