schliessen

Filtern

 

Bibliotheken

Relational database design and implementation : clearly explained / Jan L. Harrington

Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provide... Full description

PPN (Catalogue-ID): 623041707
Personen: Harrington, Jan L.
Format: eBook eBook
Enthält: Front cover; Half title page; Relational Database Design and Implementation; Copyright page; Table of Contents; Preface to the Third Edition; Changes in the Third Edition; What You Need to Know; Acknowledgments; Part I Introduction; Introduction; Chapter 1 The Database Environment; Defining a Database; Lists and Files; Databases; Data "Ownership"; Service-Oriented Architecture; Database Software: DBMSs; Database Hardware Architecture; Centralized; Client/Server; Distributed; The Web; Remote Access; Other Factors in the Database Environment; Security; Government Regulations and Privacy.
Language: English
Published: Amsterdam [u.a.], Morgan Kaufmann Publishers/Elsevier, 2009
Edition: 3. ed.
Basisklassifikation: 54.64
RVK:

ST 270: Informatik -- Monographien -- Software und -entwicklung -- Datenbanken, Datenbanksysteme, Data base management, Informationssysteme -- Datenbanken, Datenbanksysteme, Data base management, Informationssysteme. Allgemein

Subjects:

Relationales Datenbanksystem / Datenbankentwurf

Notes: Rev. ed. of: Relational database design clearly explained. 2nd ed. 2002.
Includes bibliographical references and index.
Physical Description: Online-Ressource (XI, 420 S.)
ISBN: 978-1-282-25841-9
978-0-12-374730-3
0-08-088501-2
978-0-08-088501-8
Sekundärausgabe Online-Ausg., 2009

Similar Items

Vorhandene Hefte/Bände

more (+)

Informationen zur Verfügbarkeit werden geladen

Staff View
LEADER 16506cam a22020772 4500
001 623041707
003 DE-627
005 20190310023920.0
007 cr uuu---uuuuu
008 100406s2009 xx |||||o 00| ||eng c
020 |a 9781282258419  |c MyiLibrary  |9 978-1-282-25841-9 
020 |a 9780123747303  |9 978-0-12-374730-3 
020 |a 0080885012  |c electronic bk.  |9 0-08-088501-2 
020 |a 9780080885018  |c : electronic bk.  |9 978-0-08-088501-8 
035 |a (DE-627)623041707 
035 |a (DE-599)GBV623041707 
035 |a (OCoLC)845693357 
035 |a (EBR)ebr10378991 
035 |a (RPAM)cis10686966 
035 |a (EBC)EBC535142 
035 |a (EbpS)319641 
040 |a DE-627  |b ger  |c DE-627  |e rakwb 
041 |a eng 
044 |c XA-NL  |c XD-US  |c XA-DE 
050 0 |a QA76.9.D26 
082 0 |a 005.75/6  |2 22 
084 |a ST 270  |q BSZ  |2 rvk 
084 |a COM  |2 bisac 
084 |a 54.64  |2 bkl 
100 1 |a Harrington, Jan L. 
245 1 0 |a Relational database design and implementation  |b clearly explained  |c Jan L. Harrington 
250 |a 3. ed. 
264 1 |a Amsterdam [u.a.]  |b Morgan Kaufmann Publishers/Elsevier  |c 2009 
300 |a Online-Ressource (XI, 420 S.) 
336 |a Text  |b txt  |2 rdacontent 
337 |a Computermedien  |b c  |2 rdamedia 
338 |a Online-Ressource  |b cr  |2 rdacarrier 
500 |a Rev. ed. of: Relational database design clearly explained. 2nd ed. 2002. 
500 |a Includes bibliographical references and index. 
501 |a Front cover; Half title page; Relational Database Design and Implementation; Copyright page; Table of Contents; Preface to the Third Edition; Changes in the Third Edition; What You Need to Know; Acknowledgments; Part I Introduction; Introduction; Chapter 1 The Database Environment; Defining a Database; Lists and Files; Databases; Data "Ownership"; Service-Oriented Architecture; Database Software: DBMSs; Database Hardware Architecture; Centralized; Client/Server; Distributed; The Web; Remote Access; Other Factors in the Database Environment; Security; Government Regulations and Privacy. 
501 |a Legacy DatabasesFor Further Reading; Chapter 2 Systems Analysis and Database Requirements; Dealing with Resistance to Change; The Structured Design Life Cycle; Conducting the Needs Assessment; Assessing Feasibility; Generating Alternatives; Evaluating and Choosing an Alternative; Creating Design Requirements; Alternative Analysis Methods; Prototyping; Spiral Methodology; Object-Oriented Analysis; For Further Reading; Part II Database Design Theory; Database Design Theory; Chapter 3 Why Good Design Matters; Effects of Poor Database Design; Unnecessary Duplicated Data and Data Consistency. 
501 |a Data Insertion ProblemsData Deletion Problems; Meaningful Identifiers; Chapter 4 Entities and Relationships; Entities and Their Attributes; Entity Identifiers; Single-Valued versus Multivalued Attributes; Avoiding Collections of Entities; Documenting Entities and Their Attributes; Entities and Attributes for Antique Opticals; Domains; Documenting Domains; Practical Domain Choices; Basic Data Relationships; One-to-One Relationships; One-to-Many Relationships; Many-to-Many Relationships; Weak Entities and Mandatory Relationships; Documenting Relationships; The Chen Method; IE Style Diagrams. 
501 |a UML Style DiagramsBasic Relationships for Antique Opticals; Dealing with Many-to-Many Relationships; Composite Entities; Documenting Composite Entities; Resolving Antique Opticals' Many-to-Many Relationships; Relationships and Business Rules; Data Modeling versus Data Flow; Schemas; For Further Reading; Chapter 5 The Relational Data Model; Understanding Relations; Columns and Column Characteristics; Rows and Row Characteristics; Types of Tables; A Notation for Relations; Primary Keys; Primary Keys to Identify People; Avoiding Meaningful Identifiers; Concatenated Primary Keys. 
501 |a All-Key RelationsRepresenting Data Relationships; Referential Integrity; Foreign Keys and Primary Keys in the Same Table; Views; The View Mechanism; Why Use Views?; The Data Dictionary; Sample Data Dictionary Tables; A Bit of History; For Further Reading; Chapter 6 Normalization; Translating an ER Diagram into Relations; Normal Forms; First Normal Form; Understanding Repeating Groups; Handling Repeating Groups; Problems with First Normal Form; Second Normal Form; Understanding Functional Dependencies; Using Functional Dependencies to Reach 2NF; Problems with 2NF Relations; Third Normal Form. 
501 |a Transitive Dependencies. 
520 |a Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provides the conceptual and practical information necessary to develop a design and management scheme that ensures data accuracy and user satisfaction while optimizing performance, regardless of experience level or choice of DBMS. The book begins by reviewing basic concepts of databases and database design, then briefly reviews the SQL one would use to create databases. Topics such as the relational data model, normalization, data entities and Codd's Rules (and why they are important) are covered clearly and concisely but without resorting to "Dummies"--Style talking down to the reader. Supporting the book's step-by-step instruction are three NEW case studies illustrating database planning, analysis, design, and management practices. In addition to these real-world examples, which include object-relational design techniques, an entirely NEW section consisting of three chapters is devoted to database implementation and management issues. * Principles needed to understand the basis of good relational database design and implementation practices. * Examples to illustrate core concepts for enhanced comprehension and to put the book's practical instruction to work. * Methods for tailoring DB design to the environment in which the database will run and the uses to which it will be put. * Design approaches that ensure data accuracy and consistency. * Examples of how design can inhibit or boost database application performance. * Object-relational design techniques, benefits, and examples. * Instructions on how to choose and use a normalization technique. * Guidelines for understanding and applying Codd's rules. * Tools to implement a relational design using SQL. * Techniques for using CASE tools for database design 
520 |a Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provides the conceptual and practical information necessary to develop a design and management scheme that ensures data accuracy and user satisfaction while optimizing performance, regardless of experience level or choice of DBMS. The book begins by reviewing basic concepts of databases and database design, then briefly reviews the SQL one would use to create databases. Topics such as the relational data model, normalization, data entities and Codd's Rules (and why they are important) are covered clearly and concisely but without resorting to Dummies-style talking down to the reader. Supporting the book's step-by-step instruction are three NEW case studies illustrating database planning, analysis, design, and management practices. In addition to these real-world examples, which include object-relational design techniques, an entirely NEW section consisting of three chapters is devoted to database implementation and management issues. * Principles needed to understand the basis of good relational database design and implementation practices. * Examples to illustrate core concepts for enhanced comprehension and to put the book's practical instruction to work. * Methods for tailoring DB design to the environment in which the database will run and the uses to which it will be put. * Design approaches that ensure data accuracy and consistency. * Examples of how design can inhibit or boost database application performance. * Object-relational design techniques, benefits, and examples. * Instructions on how to choose and use a normalization technique. * Guidelines for understanding and applying Codd's rules. * Tools to implement a relational design using SQL. * Techniques for using CASE tools for database design. 
530 |a Electronic reproduction; Mode of access: World Wide Web. 
533 |a Online-Ausg.  |d 2009  |7 |2009||||||||||  |n Electronic reproduction; Mode of access: World Wide Web 
689 0 0 |D s  |0 (DE-588)4130535-8  |0 (DE-627)105701874  |0 (DE-576)209619821  |a Relationales Datenbanksystem  |2 gnd 
689 0 1 |D s  |0 (DE-588)4127613-9  |0 (DE-627)104707682  |0 (DE-576)209595043  |a Datenbankentwurf  |2 gnd 
689 0 |5 (DE-627) 
776 1 |z 0123747309  |9 0-12-374730-9 
776 1 |z 9780123747303  |9 978-0-12-374730-3 
776 0 8 |i Print version  |a Relational Database Design and Implementation  |d Clearly Explained 
856 4 0 |u http://site.ebrary.com/lib/alltitles/docDetail.action?docID=10378991 
856 4 0 |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=319641  |3 Volltext 
856 4 0 |u http://lib.myilibrary.com/detail.asp?ID=225841  |z Connect to MyiLibrary resource  |3 Volltext 
856 4 0 |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=319641  |3 Volltext 
856 4 0 |u http://gbv.eblib.com/patron/FullRecord.aspx?p=535142  |3 Volltext 
856 4 0 |u http://www.sciencedirect.com/science/book/9780123747303  |y ScienceDirect  |z An electronic book accessible through the World Wide Web; click for information 
856 4 0 |u https://ebookcentral.proquest.com/lib/gbv/detail.action?docID=535142 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_21 
912 |a SYSFLAG_1 
912 |a GBV_KXP 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_23 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_60 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_62 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_100 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_105 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_120 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_206 
912 |a H-ZDB-38-EBR 
912 |a H-ZDB-26-MYL 
912 |a H-ZDB-33-EBS 
912 |a H-ZDB-33-ESD 
912 |a H-ZDB-4-EBA 
912 |a H-ZDB-30-PQE 
912 |a H-GBV-MyiL-luen-2011 
912 |a GBV_ILN_252 
935 |h GBV  |i hybr 
936 r v |a ST 270 
936 b k |a 54.64  |j Datenbanken  |0 (DE-627)106410865 
951 |a BO 
980 |2 21  |1 01  |b 1144857236  |h ebook_2010_elsevier_EBSKauf  |k Freie Nutzung im Campusnetz der Universitaet und der Hochschulen im Lande Bremen  |x 0046  |y zza  |z 06-04-10 
980 |2 21  |1 02  |b 1838907912  |h ebook_2018_elsevier_freecollect  |k Freie Nutzung im Campusnetz der Universität und der Hochschulen im Lande Bremen  |x 0046  |y zza  |z 07-01-19 
980 |2 21  |1 03  |b 1850207291  |h ebook_2019_ebsco  |k Freie Nutzung im Campusnetz der Universität und der Hochschulen im Lande Bremen  |k <b><a href="http://elib.suub.uni-bremen.de/ebooks/ebsco.html" Target="_blank">Kann ich <font color="#ff0000">Drucken Speichern Kopieren?</font></a></b>  |x 0046  |y zza  |z 21-02-19 
980 |2 23  |1 01  |b 1610371569  |h olr-else  |k Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots  |x 0830  |y z  |z 16-04-16 
980 |2 60  |1 01  |b 160787587X  |l ElsevierE-Book  |x 0705  |y x  |z 29-03-16 
980 |2 62  |1 01  |b 1830705342  |h OLR-Elsevier-EBS  |k Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt.  |x 0028  |y z  |z 06-12-18 
980 |2 100  |1 01  |b 1369219881  |d eBook Elsevier (EBS 2012)  |h OLR-ELS-EBS-2012  |k Vervielfältigungen (z.B. Kopien, Downloads) sind nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots  |x 3100  |y z  |z 28-02-13 
980 |2 105  |1 01  |b 1464742693  |h OLR-ELV-TEST  |k Testzugang ZHB Lübeck 2014. - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots.  |x 0841  |y z  |z 22-03-14 
980 |2 120  |1 01  |b 1644071207  |k Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots.  |x 0715  |y z  |z 02-11-16 
980 |2 120  |1 02  |b 1752124499  |e n  |h alma  |x 0715  |y l02  |z 22-02-18 
980 |2 206  |1 01  |b 1549628992  |d Online-Ressource  |e g  |h OLR-EBL  |k Please send a request, if the ebook is not available!  |l E-Books (Schweitzer)  |x 3350  |y zh  |z 23-06-15 
980 |2 252  |1 01  |b 1423811232  |f Thünen-Institut  |d Online-Ressource  |e g  |h OLR-EBL  |k Ebook noch nicht erworben! Nach dem Kauf: Vervielfältigungen (z. B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte.  |l E-Books (Schweitzer)  |x 4252  |y zi070e  |z 08-08-13 
981 |2 21  |1 01  |r http://www.sciencedirect.com/science/book/9780123747303 
981 |2 21  |1 02  |r https://www.sciencedirect.com/science/book/9780123747303 
981 |2 21  |1 03  |r http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=319641 
981 |2 60  |1 01  |r http://www.sciencedirect.com/science/book/9780123747303 
981 |2 62  |1 01  |r http://www.sciencedirect.com/science/book/9780123747303 
981 |2 105  |1 01  |r http://www.sciencedirect.com/science/book/9780123747303 
981 |2 120  |1 01  |r http://www.sciencedirect.com/science/book/9780123747303 
981 |2 120  |1 02  |r http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991011173719703501 
983 |2 21  |1 00  |8 30  |a inf 530 rel 
983 |2 21  |1 00  |8 99  |a 92 
983 |2 120  |1 00  |8 99  |a ww 
983 |2 120  |1 02  |8 00  |a ww 
985 |2 23  |1 01  |a 2015-03069, 2015-03070, 2015-03071, 2015-03072, 2015-03073 
995 |2 21  |1 01  |a ebook_2010_elsevier_EBSKauf 
995 |2 21  |1 02  |a ebook_2018_elsevier_freecollect 
995 |2 21  |1 03  |a ebook_2019_ebsco 
995 |2 23  |1 01  |a olr-else 
995 |2 62  |1 01  |a OLR-Elsevier-EBS 
995 |2 100  |1 01  |a OLR-ELS-EBS-2012 
995 |2 105  |1 01  |a OLR-ELV-TEST 
995 |2 120  |1 02  |a alma 
995 |2 206  |1 01  |a OLR-EBL 
995 |2 252  |1 01  |a OLR-EBL 
998 |2 23  |1 01  |0 2016.04.16