Kooperativer Bibliotheksverbund

UID:

Format: XX, 425 S. : , Ill.

ISBN: 0-12-369389-6 , 978-0-12-369389-1

Series Statement: The Morgan Kaufmann series in data management systems

Note: Includes bibliographical references (p. 391-409) and indexes

Language: English

Subjects: Computer Science

Keywords: Datenbankentwurf ; Relationale Datenbank ; Datenbankentwurf

URL: Table of contents only

URL: Publisher description

URL: http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015756464&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA

URL: Table of contents only

URL: Publisher description

URL: Inhaltsverzeichnis

UID:

Format: 1 online resource (449 p.)

Edition: 1st edition

ISBN: 1-281-04654-X , 9786611046545 , 0-08-055231-5

Series Statement: The Morgan Kaufmann series in data management systems

Content: The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form

Note: Description based upon print version of record. , Front Cover; Physical Database Design; Copyright Page; Contents; Preface; Organization; Usage Examples; Literature Summaries and Bibliography; Feedback and Errata; Acknowledgments; Chapter 1. Introduction to Physical Database Design; 1.1 Motivation-The Growth of Data and Increasing Relevance of Physical Database Design; 1.2 Database Life Cycle; 1.3 Elements of Physical Design: Indexing, Partitioning, and Clustering; 1.4 Why Physical Design Is Hard; 1.5 Literature Summary; Chapter 2. Basic Indexing Methods; 2.1 B+tree Index; 2.2 Composite Index Search; 2.3 Bitmap Indexing , 2.4 Record Identifiers 2.5 Summary; 2.6 Literature Summary; Chapter 3. Query Optimization and Plan Selection; 3.1 Query Processing and Optimization; 3.2 Useful Optimization Features in Database Systems; 3.3 Query Cost Evaluation-An Example; 3.4 Query Execution Plan Development; 3.5 Selectivity Factors, Table Size, and Query Cost Estimation; 3.6 Summary; 3.7 Literature Summary; Chapter 4. Selecting Indexes; 4.1 Indexing Concepts and Terminology; 4.2 Indexing Rules of Thumb; 4.3 Index Selection Decisions; 4.4 Join Index Selection; 4.5 Summary; 4.6 Literature Summary , Chapter 5. Selecting Materialized Views 5.1 Simple View Materialization; 5.2 Exploiting Commonality; 5.3 Exploiting Grouping and Generalization; 5.4 Resource Considerations; 5.5 Examples: The Good, the Bad, and the Ugly; 5.6 Usage Syntax and Examples; 5.7 Summary; 5.8 Literature Review; Chapter 6. Shared-nothing Partitioning; 6.1 Understanding Shared-nothing Partitioning; 6.2 More Key Concepts and Terms; 6.3 Hash Partitioning; 6.4 Pros and Cons of Shared Nothing; 6.5 Use in OLTP Systems; 6.6 Design Challenges: Skew and Join Collocation , 6.7 Database Design Tips for Reducing Cross-node Data Shipping 6.8 Topology Design; 6.9 Where the Money Goes; 6.10 Grid Computing; 6.11 Summary; 6.12 Literature Summary; Chapter 7. Range Partitioning; 7.1 Range Partitioning Basics; 7.2 List Partitioning; 7.3 Syntax Examples; 7.4 Administration and Fast Roll-in and Roll-out; 7.5 Increased Addressability; 7.6 Partition Elimination; 7.7 Indexing Range Partitioned Data; 7.8 Range Partitioning and Clustering Indexes; 7.9 The Full Gestalt: Composite Range and Hash Partitioning with Multidimensional Clustering; 7.10 Summary; 7.11 Literature Summary , Chapter 8. Multidimensional Clustering 8.1 Understanding MDC; 8.2 Performance Benefits of MDC; 8.3 Not Just Query Performance: Designing for Roll-in and Roll-out; 8.4 Examples of Queries Benefiting from MDC; 8.5 Storage Considerations; 8.6 Designing MDC Tables; 8.7 Summary; 8.8 Literature Summary; Chapter 9. The Interdependence Problem; 9.1 Strong and Weak Dependency Analysis; 9.2 Pain-first Waterfall Strategy; 9.3 Impact-.rst Waterfall Strategy; 9.4 Greedy Algorithm for Change Management; 9.5 The Popular Strategy (the Chicken Soup Algorithm); 9.6 Summary; 9.7 Literature Summary , Chapter 10. Counting and Data Sampling in Physical Design Exploration , English

Additional Edition: ISBN 0-12-369389-6

Language: English

UID:

Format: 1 online resource (294 p.)

Edition: 4th ed.

ISBN: 1-280-96150-3 , 9786610961504 , 0-08-047077-7

Series Statement: The Morgan Kaufmann Series in Data Management Systems

Content: Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fourth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with

Note: Description based upon print version of record. , front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship , 2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow , 3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration , 4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation , 5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF , 6.5.4 Fifth Normal Form , English

Additional Edition: ISBN 0-12-685352-5

Language: English

UID:

Format: XVIII, 275 S. : Ill., graph. Darst.

Edition: 4. ed.

ISBN: 978-0-12-685352-0

Language: English

Subjects: Computer Science

Keywords: Datenbankentwurf ; SQL ; Datenbanksystem

UID:

Format: XVIII, 275 S. , Ill., graph. Darst.

Edition: 4. ed.

ISBN: 0126853525

Language: English

Subjects: Computer Science

Keywords: Datenbankentwurf ; SQL ; Datenbanksystem

UID:

Format: XVIII, 275 Seiten , Ill., graph. Darst.

Edition: 4th ed.

ISBN: 9780126853520 , 0126853525

Series Statement: The Morgan Kaufmann series in data management systems

Note: Literaturverz. S. 239 - 247 , Text engl.

Language: English

Keywords: Relationales Datenbanksystem

UID:

Format: xx, 427 p. : , ill.

Edition: Electronic reproduction. Ann Arbor, MI : ProQuest, 2015. Available via World Wide Web. Access may be limited to ProQuest affiliated libraries.

Series Statement: The Morgan Kaufmann series in data management systems

Language: English

Keywords: Electronic books.

URL: Click to View

UID:

Format: xviii, 275 p. : , ill.

Edition: 4th ed.

Edition: Electronic reproduction. Ann Arbor, MI : ProQuest, 2016. Available via World Wide Web. Access may be limited to ProQuest affiliated libraries.

Language: English

Keywords: Electronic books.

URL: Click to View

UID:

Format: 1 online resource (xv, 438 p.) : , ill.

Edition: 1st edition

ISBN: 0-13-706547-7 , 1-282-59207-6 , 9786612592072 , 0-13-706545-0

Content: The Software Insider’s Guide to Getting Hired and Getting to the Top! Here’s all the information you need to jumpstart your software career: the best ways to get hired, move up, and blaze your way to the top! The software business has radically changed, and this book reveals today’s realities–everything your professors and corporate managers never told you. In his 20 years at IBM as a software architect, senior manager, and lead programmer, Sam Lightstone has briefed dozens of leading companies and universities on careers, new technology, and emerging areas of research. He currently works on one of the world’s largest software development teams and spends a good part of his time recruiting and mentoring software engineers. This book shares all the lessons for success Sam has learned…plus powerful insights from 17 of the industry’s biggest stars. Want to make it big in software? Start right here! Discover how to • Get your next job in software development • Master the nontechnical skills crucial to your success • “Work the org” to move up rapidly • Successfully manage your time, projects, and life • Avoid “killer” mistakes that could destroy your career • Move up to “medium-shot,” “big-shot,” and finally, “visionary” • Launch your own winning software company Exclusive interviews with Steve Wozniak , Inventor, Apple computer John Schwarz , CEO, Business Objects James Gosling , Inventor, Java programming language Marissa Mayer , Google VP, Search Products and User Experience Jon Bentley , Author, Programming Pearls Marc Benioff , CEO and founder, Salesforce.com Grady Booch , IBM Fellow and co-founder Rational Software Bjarne Stroustrup , Inventor, C++ programming language David Vaskevitch , Microsoft CTO Linus Torvalds , Creator, Linux operating system kernel Richard Stallman , Founder, Free software movement Peter Norvig , Google’s Director of Research Mark Russinovich , Microsoft Fellow and Windows Architect Tom Malloy , Adobe Chief Software Architect Diane Greene , Co-founder and past CEO of VMware Robert Kahn , Co-inventor, the Internet Ray Tomlinson , Inventor, email

Note: Bibliographic Level Mode of Issuance: Monograph , English

Additional Edition: ISBN 0-13-706736-4

Additional Edition: ISBN 0-13-705967-1

Language: English

UID:

Format: 1 online resource (1 volume) : , illustrations

Edition: 1st edition

Content: UPGRADE TO THE NEW GENERATION OF DATABASE SOFTWARE FOR THE ERA OF BIG DATA! If big data is an untapped natural resource, how do you find the gold hidden within? Leaders realize that big data means all data, and are moving quickly to extract more value from both structured and unstructured application data. However, analyzing this data can prove costly and complex, especially while protecting the availability, performance and reliability of essential business applications. In the new era of big data, businesses require data systems that can blend always-available transactions with speed-of-thought analytics. DB2 10.5 with BLU Acceleration provides this speed, simplicity, and affordability while making it easier to build next-generation applications with NoSQL features, such as a mongo-styled JSON document store, a graph store, and more. Dynamic in-memory columnar processing and other innovations deliver faster insights from more data, and enhanced pureScale clustering technology delivers high-availability transactions with application-transparent scalability for business continuity. With this book, you'll learn about the power and flexibility of multiworkload, multi-platform database software. Use the comprehensive knowledge from a team of DB2 developers and experts to get started with the latest DB2 trial version you can download at ibm.com/developerworks/downloads/im/db2/. Stay up to date on DB2 by visiting ibm.com/db2/.

Note: Bibliographic Level Mode of Issuance: Monograph , English

Additional Edition: ISBN 0-07-182349-2

Additional Edition: ISBN 0-07-182354-9

Language: English