001432946 000__ 04544cam\a2200637\a\4500 001432946 001__ 1432946 001432946 003__ OCoLC 001432946 005__ 20230309003541.0 001432946 006__ m\\\\\o\\d\\\\\\\\ 001432946 007__ cr\un\nnnunnun 001432946 008__ 201216s2021\\\\xxu\\\\\o\\\\\001\0\eng\d 001432946 019__ $$a1227392706$$a1228844191$$a1232856835$$a1236895082$$a1237454742$$a1240528593$$a1302263628 001432946 020__ $$a9781484264973$$q(electronic bk.) 001432946 020__ $$a1484264975$$q(electronic bk.) 001432946 020__ $$a9781484264980$$q(print) 001432946 020__ $$a1484264983 001432946 020__ $$z1484264967 001432946 020__ $$z9781484264966 001432946 0247_ $$a10.1007/978-1-4842-6497-3$$2doi 001432946 035__ $$aSP(OCoLC)1227063708 001432946 040__ $$aYDX$$beng$$epn$$cYDX$$dGW5XE$$dOCLCO$$dERF$$dEBLCP$$dUPM$$dOCLCF$$dVT2$$dOCL$$dLVT$$dOCLCQ$$dOCLCO$$dCOM$$dOCLCQ 001432946 049__ $$aISEA 001432946 050_4 $$aQA76.73.S67 001432946 050_4 $$aQA76.9.D3 001432946 08204 $$a005.75/85$$223 001432946 08204 $$a005.74$$223 001432946 1001_ $$aDavidson, Louis. 001432946 24510 $$aPro SQL Server relational database design and implementation :$$bbest practices for scalability and performance /$$cLouis Davidson. 001432946 250__ $$a6th ed. 001432946 260__ $$a[Place of publication not identified] :$$bApress,$$c2021. 001432946 300__ $$a1 online resource 001432946 336__ $$atext$$btxt$$2rdacontent 001432946 337__ $$acomputer$$bc$$2rdamedia 001432946 338__ $$aonline resource$$bcr$$2rdacarrier 001432946 347__ $$atext file 001432946 347__ $$bPDF 001432946 500__ $$aIncludes index. 001432946 5050_ $$a1. The Fundamentals -- 2. Introduction to Requirements -- 3. The Language of Data Modeling -- 4. Conceptual and Logical Data Model Production -- 5. Normalization -- 6. Physical Model Case Study -- 7. Physical Model Implementation -- 8. Data Protection Patterns with Check Constraints and Triggers -- 9. Patterns and Anti-Patterns -- 10. Database Security and Security Patterns -- 11. Data Structures, Indexes, and Their Applications -- 12. Matters of Concurrency -- 13. Coding Architecture -- 14. Appendix A: Scalar Datatype Reference. 001432946 506__ $$aAccess limited to authorized users. 001432946 520__ $$aLearn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. You will: Develop conceptual models of client data using interviews and client documentation Implement designs that work on premises, in the cloud, or in a hybrid approach Recognize and apply common database design patterns Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Understand the concepts of concurrency 001432946 588__ $$aOnline resource; title from PDF title page (SpringerLink, viewed February 26, 2021). 001432946 63000 $$aSQL server. 001432946 650_0 $$aClient/server computing. 001432946 650_0 $$aRelational databases. 001432946 650_0 $$aDatabase management. 001432946 650_6 $$aArchitecture client-serveur (Informatique) 001432946 650_6 $$aBases de données relationnelles. 001432946 650_6 $$aBases de données$$xGestion. 001432946 655_0 $$aElectronic books. 001432946 77608 $$iPrint version:$$aDavidson, Louis.$$tPro SQL Server relational database design and implementation.$$b6th ed.$$d[Place of publication not identified] : Apress, 2021$$z1484264967$$z9781484264966$$w(OCoLC)1191704210 001432946 852__ $$bebk 001432946 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-6497-3$$zOnline Access$$91397441.1 001432946 909CO $$ooai:library.usi.edu:1432946$$pGLOBAL_SET 001432946 980__ $$aBIB 001432946 980__ $$aEBOOK 001432946 982__ $$aEbook 001432946 983__ $$aOnline 001432946 994__ $$a92$$bISE