Cargando…

Relational database programming : a set-oriented approach /

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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Ardeleanu, Stefan (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Place of publication not identified] : Apress, 2016.
Colección:Expert's voice in databases.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000Ii 4500
001 OR_ocn963965933
003 OCoLC
005 20231017213018.0
006 m o d
007 cr unu||||||||
008 161122s2016 xx o 000 0 eng d
040 |a UMI  |b eng  |e rda  |e pn  |c UMI  |d TOH  |d STF  |d DEBBG  |d OCLCF  |d DEBSZ  |d OCLCQ  |d CEF  |d KSU  |d OCLCQ  |d UAB  |d SFB  |d HS0  |d OCLCO  |d OCLCQ 
019 |a 1165392552 
020 |a 148422079X 
020 |a 9781484220795 
020 |z 9781484220795 
020 |a 1484220803 
020 |a 9781484220801 
024 7 |a 10.1007/978-1-4842-2080-1.  |2 doi 
029 1 |a DEBBG  |b BV043970597 
029 1 |a DEBSZ  |b 485810719 
029 1 |a GBVCP  |b 882761765 
035 |a (OCoLC)963965933  |z (OCoLC)1165392552 
037 |a CL0500000802  |b Safari Books Online 
050 4 |a QA76.9.D32 
072 7 |a UM.  |2 bicssc 
072 7 |a COM051000.  |2 bisacsh 
082 0 4 |a 004 
049 |a UAMI 
100 1 |a Ardeleanu, Stefan,  |e author. 
245 1 0 |a Relational database programming :  |b a set-oriented approach /  |c Stefan Ardeleanu. 
264 1 |a [Place of publication not identified] :  |b Apress,  |c 2016. 
264 2 |a New York, NY :  |b Distributed to the Book trade worldwide by Springer Science+Business Media 
264 4 |c ©2016 
300 |a 1 online resource (1 volume). 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a The expert's voice in databases. 
588 0 |a Online resource; title from cover (Safari, viewed November 21, 2016). 
505 0 |a 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. 
520 |a 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. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a Relational databases. 
650 6 |a Bases de données relationnelles. 
650 7 |a Relational databases.  |2 fast  |0 (OCoLC)fst01093575 
776 |z 1-4842-2079-X 
830 0 |a Expert's voice in databases. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781484220801/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
994 |a 92  |b IZTAP