Relational Database Programming

Relational Database Programming-PDF Download

  • Date:19 Jan 2020
  • Views:52
  • Downloads:0
  • Pages:21
  • Size:656.49 KB

Share Pdf : Relational Database Programming

Download and Preview : Relational Database Programming


Report CopyRight/DMCA Form For : Relational Database Programming


Transcription:

Relational Database Programming,Stefan Ardeleanu,Bucharest Romania. ISBN 13 pbk 978 1 4842 2079 5 ISBN 13 electronic 978 1 4842 2080 1. DOI 10 1007 978 1 4842 2080 1,Library of Congress Control Number 2016945177. Copyright 2016 by Stefan Ardeleanu, This work is subject to copyright All rights are reserved by the Publisher whether the whole or part. of the material is concerned specifically the rights of translation reprinting reuse of illustrations. recitation broadcasting reproduction on microfilms or in any other physical way and transmission. or information storage and retrieval electronic adaptation computer software or by similar or. dissimilar methodology now known or hereafter developed Exempted from this legal reservation are. brief excerpts in connection with reviews or scholarly analysis or material supplied specifically for. the purpose of being entered and executed on a computer system for exclusive use by the purchaser. of the work Duplication of this publication or parts thereof is permitted only under the provisions. of the Copyright Law of the Publisher s location in its current version and permission for use must. always be obtained from Springer Permissions for use may be obtained through RightsLink at the. Copyright Clearance Center Violations are liable to prosecution under the respective Copyright Law. Trademarked names logos and images may appear in this book Rather than use a trademark. symbol with every occurrence of a trademarked name logo or image we use the names logos and. images only in an editorial fashion and to the benefit of the trademark owner with no intention of. infringement of the trademark, The use in this publication of trade names trademarks service marks and similar terms even if they. are not identified as such is not to be taken as an expression of opinion as to whether or not they are. subject to proprietary rights, While the advice and information in this book are believed to be true and accurate at the date of.
publication neither the authors nor the editors nor the publisher can accept any legal responsibility. for any errors or omissions that may be made The publisher makes no warranty express or implied. with respect to the material contained herein,Managing Director Welmoed Spahr. Lead Editor Jonathan Gennick,Development Editor Douglas Pundick. Technical Reviewer Bradley Beard, Editorial Board Steve Anglin Pramila Balen Aaron Black Louise Corrigan Jonathan. Gennick Robert Hutchinson Celestin Suresh John Nikhil Karkal James Markham. Susan McDermott Matthew Moodie Natalie Pao Ben Renow Clarke Gwenan Spearing. Coordinating Editor Jill Balzano,Copy Editor Mary Behr. Compositor SPi Global,Indexer SPi Global,Artist SPi Global.
Distributed to the book trade worldwide by Springer Science Business Media New York. 233 Spring Street 6th Floor New York NY 10013 Phone 1 800 SPRINGER fax 201 348 4505 e mail. orders ny springer sbm com or visit www springer com Apress Media LLC is a California LLC and. the sole member owner is Springer Science Business Media Finance Inc SSBM Finance Inc SSBM. Finance Inc is a Delaware corporation, For information on translations please e mail rights apress com or visit www apress com. Apress and friends of ED books may be purchased in bulk for academic corporate or promotional. use eBook versions and licenses are also available for most titles For more information reference our. Special Bulk Sales eBook Licensing web page at www apress com bulk sales. Any source code or other supplementary material referenced by the author in this text is available to. readers at www apress com For detailed information about how to locate your book s source code. go to www apress com source code,Printed on acid free paper. The application developer sees himself as a rider on the row. But the row is not a horse it s a donkey,Contents at a Glance. About the Author xiii,About the Technical Reviewer xv. Introduction xvii,Chapter 1 The Concept of Style 1.
Chapter 2 SQL Beauty and the Beast 17,Chapter 3 A Holistic Vision of the Data 31. Chapter 4 Data by Set or by Row 43,Chapter 5 Data Transfer Paradigm 53. Chapter 6 The Challenge of Scalar Functions 81,Chapter 7 Writing SQL vs Writing Procedurally 103. Chapter 8 Row Triggers and the Need for Atomic Solutions 127. Chapter 9 Final Reflections and Thoughts 137,About the Author xiii. About the Technical Reviewer xv,Introduction xvii,Chapter 1 The Concept of Style 1.
Style of Development Is Dynamic 1,SQL Requires Its Own Style 2. Style and Quality 2,A Programmer s Own Style 3,Common Styles of Development 3. Multitasking 4,Team Organization 4,The Visual Experience 5. Common Models in Programming 5,Object Oriented Programming 6. Structured Programming 6,An Alternate Model 7,Can One Model Fit All 7.
Starting with Table Design 8,The Table as an Entity 8. The Table As A Sum of Columns 9,Database Constraints 9. What Developers Must Know 11,Let s Begin Coding 12. Revisiting the Example 13,Good Design May Be Wrongly Implemented 14. Are You Ready for SQL 15,Chapter 2 SQL Beauty and the Beast 17.
Can a Query Language Be So Important 17,Databases Require a Language 17. SQL Is a Useful Language 18,Programmers Must Adapt 18. A Different Style Is Needed 19,Understanding What SQL Is and Is Not 19. SQL Is Not Classical Programming 19,SQL Is About Querying 20. Components of the SQL Language 21,Queries and Clauses 22.
Inserting Updating and Deleting 23,What About Programming 24. The Advantage of a Standard 26,Programming Is a Practical Activity 26. Is Database Programming Special 27,The SQL Shop Metaphor 28. An Example of Bad Practice 29,Chapter 3 A Holistic Vision of the Data 31. The Concept of the Data Set 31,The Importance of the Data Set 31.
SQL and the Data Set 32,A Mix of Art and Science 32. SQL and Portability 33,Operating on Data Sets 33,Two Approaches 33. Data Sets as Atomic Units 34,Like a Chameleon 34,Thinking in Data Sets 35. Take Style Seriously 35,Understanding the Data Set 36. The Importance of Style 36,Programming as a Distinct Path 37.
Promoting the Holistic Style 37,The Benefits 38,Be Independent 38. Visual vs SQL Development 39,Choosing a Tool or a Language 40. Use SQL 41,Chapter 4 Data by Set or by Row 43,Choosing the Level of Detail 44. Working Atomically 44,Row by Row Performance 45,Writing Out of Habit 45. Blocked into Poor Performance 46,Performance Relies on a Holistic Style 46.
Querying All the Time 47,What Do Programmers Do 47. How Do Programmers Do It 49,Revisiting the SQL Shop 49. The Use of Scalar Functions 50,Set Based Debugging Is Simpler 51. Your Role as a Database Developer 52,Practice Time 52. Chapter 5 Data Transfer Paradigm 53,About the Examples 53.
Format of the Examples 54, Example 1 A Full Data Transfer Between Two Systems 54. Business and Technical Description 55,Prerequisites 55. Sample of the Data 59,An Example Insert Script 60,Filtering for English and French 61. Try It on Your Own 69,Some Conclusions 69,Example 2 Incrementally Update a Target 70. Changes to the Source 70,The Atomic Approach 71,The Holistic Solution 76.
Chapter 6 The Challenge of Scalar Functions 81,Cursors Have Their Place 81. The Lure of Functions 82,Divide and Conquer 82,Example 3 Filtered Full Data Transfer 83. The Atomic Solutions 84,The Holistic Solutions 91,Example 4 A Simple Query 94. New Example Set 94,Business Requirement 96,The Atomic Solutions 97. A Mixed Approach 99,The Holistic Solutions 100,Chapter 7 Writing SQL vs Writing Procedurally 103.
An Example of an Update 103,An Atomic Solution 104. A Holistic Solution 106,The Power of a Union 108,Taking a SQL Based Approach 108. A Specific Example 108,Union vs if else 109,Write Accurate Code First 112. Embedded SQL vs Dynamic SQL 112,The Normal Approach 113. Uncertainty at Runtime 113,The Use of SQL Generators 113.
An Example 114,The Explanation 116,Other Holistic Solutions 119. Temporary Tables 120,Table Functions 120,One Last Atomic Example 121. The Holistic Solution 123,The Atomic Solution in SQL Server 124. The Holistic Approach in SQL Server 125, Chapter 8 Row Triggers and the Need for Atomic Solutions 127. The Use of Row Triggers 127,The Seduction 127,The Trap of Row Triggers 128.
Some Example Triggers 128,A Revised Solution 129,The Disaster 130. The Necessity of the Atomic Approach 132,Analyzing the Example 132. Reviewing the Solution 135,Wrap Up on Atomic Operations 136. Chapter 9 Final Reflections and Thoughts 137,The Principle of Division 137. The Concept of a SQL Template 138,Writing Horizontally vs Vertically 139.
My Reason Against Tools 140,Specific Software Applications 141. SQL Itself Can Be Improved 142,Performance Oh Performance 143. Just the First Step 144,Pure SQL is the Way 145,About the Author. Stefan Ardeleanu was born in Bucharest Romania,in 1967 He studied math and philosophy and he was. a math teacher for 10 years Afterwards he started a. career in software development He was attracted to. databases from the beginning so his entire career in. software industry is related to databases and especially. to database development and design,Stefan Ardeleanu is a database specialist a.
database architect and a developer He has worked,in various systems such as Oracle SQL Server DB2. and PostgreSQL He has experience in OLTP data,warehouse and replication systems. Stefan is a passionate SQL guy and he has a specific. style of development This style is reflected in his. various projects including replication systems and data. migration systems where this style is highly required. Stefan is also a database trainer and he delivers, courses in Oracle chain as a partner especially database. development courses and BI courses,About the Technical. Bradley Beard is a software engineer with more than. 15 years experience writing dynamic interactive web. sites using ColdFusion and SQL Server He graduated. from Florida Institute of Technology in 2007 with a. Master of Science in Computer Information Systems,and studied for his undergraduate degrees in CIS.
and Technology Management at Herzing University,In 2013 he earned the MCSA SQL Server 2012. certification from Microsoft and in 2016 he earned the. MCSE Business Intelligence certification as well,His continual quest for learning has earned him. shelves full of books at home and at work most of,which are about SQL Server ColdFusion and general. web architectures and frameworks, He lives in Palm Bay Florida with his wife Jessica and children Josh Kaylee. Matthew and Emma He also apparently runs an animal shelter made up of his dogs. Lady and Bella and cats Spice Simba Mercury and Dobby He enjoys fishing and. spending time with his wife and kids, Bradley is available for consultation and third shift remote employment on.
ColdFusion and SQL Server Contact him at bradley beard gmail com. databases from the beginning so his entire career in software industry is related to databases and especially to database development and design Stefan Ardeleanu is a database specialist a database architect and a developer He has worked in various systems such as Oracle SQL Server DB2 and PostgreSQL He has experience in OLTP data

Related Books