Angebote zu "Views" (4 Treffer)

Kategorien

Shops

Grundkurs Datenbanksysteme
29,90 € *
ggf. zzgl. Versand

- In diesem Lehrbuch finden Sie vor allem das für die Praxis wichtige Wissen rund um Datenbanken. - Viele Schritt-für-Schritt-Anleitungen und Beispiele erleichtern Ihnen den Zugang zu diesem Themengebiet. - Im Internet: Aufgaben zum Buch (incl. Lösungen), die SQL-Skripte zum Erzeugen der Demodatenbank, sowie der Quellcode aus dem Buch und Folien für Dozenten Datenbanken sind heute allgegenwärtig und gehören darum zum Pflichtprogramm für jeden angehenden und gestandenen IT-Profi. In diesem Grundkurs lernen Sie, was für die praktische Arbeit mit Datenbanken wichtig ist. Ganz ohne Theorie geht es nicht, deshalb lernen Sie zu Beginn die Konzepte relationaler Datenbanksysteme kennen. Im zweiten Teil des Buches geht es um die Modellierung und das Design von Datenbanken. Als nächstes erhalten Sie eine Einführung in die Datenbankabfragesprache SQL, beschäftigen sich vor allem mit der select-Anweisung und erfahren, wie Sichten auf Datenbanken realisiert werden. Ein wichtiges Thema des Buches ist das Aufsetzen von und die Anwendungsentwicklung für Datenbanken. Hier werden grundlegende Java-Kenntnisse vorausgesetzt. Abschließend blickt dieser Grundkurs über die Grenzen der relationalen Datenbankwelt hinaus und stellt objektorientierte Datenbanken, XML-Datenbanken und NoSQL in den Grundzügen vor. Mit Hilfe von Schritt-für-Schritt-Anleitungen und zahlreichen Beispielen führt der Autor Sie anschaulich in das Themengebiet ein. Aufgaben zum Buch finden Sie im Internet unter www.grundkurs-datenbanksysteme.de. So können Sie das Buch zum Selbststudium oder begleitend zu einer Vorlesung nutzen. AUS DEM INHALT: Relationale Datenbanken, Tabellen und Constraints, Normalisierung, Einfache select-Anweisungen, Funktionen in SQL-Anweisungen, Geschachtelte Abfragen, Views, Transaktionen, JDBC, Hibernate, XML-Datenbanken, NoSQL u.v.m.

Anbieter: buecher.de
Stand: 23.05.2019
Zum Angebot
Oracle SQL
69,90 € *
ggf. zzgl. Versand

Unverzichtbar für jeden Oracle-Datenbankentwickler! Einführung, Grundlagen, Referenz Inkl. Transaktionsverwaltung, Rechtevergabe, Optimierung Erweiterte SQL-Funktionalität, SQL/XML, Analytische Funktionen, Datenbank-Modellierung Wenn Sie sich professionell mit Oracle beschäftigen, sind umfassende Kenntnisse des entsprechenden SQL-Dialekts unverzichtbar. Jürgen Sieben, vielen bereits bekannt durch seine Bücher zu Oracle PL/SQL und Oracle APEX, hat nun auch sein Buch zu Oracle SQL aktualisiert. Er zeigt Ihnen, wie Oracle und SQL zusammenspielen und welche Strategien Sie nutzen können, um Daten in der Datenbank zu speichern, zu analysieren oder auch zu löschen. Neu in der 3. Auflage: Änderungen in Oracle 12.2. sowie ein Abschnitt zu analytischen Views. Aus dem Inhalt: Konzept einer relationalen Datenbank Grundlagen: Auswahl und Projektion Daten aus mehreren Tabellen lesen: Joins Zeilenfunktionen, Gruppenfunktionen, analytische Funktionen Unterabfragen Datenmanipulation Views, Tabellen und Indizes erstellen Einführung in die Rechteverwaltung von Oracle Hierarchische Abfragen und XML-Abfragen Die Model-Klausel Row Pattern Matching Pivotierung und Abfragetabellen Arbeit mit großen Datenstrukturen Performanzoptimierung von SQL-Abfragen Normalisierung von Datenmodellen Häufige Fehler der Datenmodellierung Parameter verwalten Multilinguale Daten

Anbieter: buecher.de
Stand: 23.05.2019
Zum Angebot
Database Systems: Pearson New International Edi...
76,99 € *
ggf. zzgl. Versand

For Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. Written by well-known computer scientists, this introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems. The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. It covers the latest database standards SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. The second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor. It focuses on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques. Resources: Open access Author Website ¿http://infolab.stanford.edu/~ullman/dscb.html ¿includes Power Point slides, teaching notes, assignments, projects, Oracle Programming Guidelines, and solutions to selected exercises. Instructor only Pearson Resources: Complete Solutions Manual (click on the Resources tab above to view downloadable files) Features + Benefits Many real-world examples. Offers a readable and engaging presentation. Extensive treatment of database modeling?Includes detailed and separate explanations of how to use E/R and ODL to design databases. Teaches about this important first step of the planning process. Excellent, up-to-date and detailed coverage of SQL?Includes coverage of object-relational systems and many aspects of the new SQL:1999 standard. Provides a more extensive treatment of query processing than other books on the market. Discussion of the technologies used to connect database programming with C or Java code?Includes discussions of SQL/PSM, SQL/CLI, and JDBC. Gives students practical advice on integrating state-of-the-art technologies with databases. Coverage of advanced issues important to database designers and users. Includes discussions of views, integrity constraints, assertions, triggers, transactions, authorization, and recursion in SQL:1999. Discussions of how to successfully plan a database application before building it. Reflects how these plans are developed in the real world. Coverage of topics such as designing storage structures and implementing a variety of indexing schemes. Shows students how to build efficient database management systems. Extensive coverage of query processing and optimization. Shows students how to fine tune database systems to improve performance. Comprehensive coverage of transaction processing mechanisms for concurrency control and recovery, including distributed and long-duration transactions. Shows how to design complex database systems that can handle real-world business applications. Coverage of information integration, including data warehousing, mediation, OLAP, data-cube systems, and data mining. Exposes readers to cutting edge technology used in business applications. Extensive exercises?In almost every section. Provides students with the opportunity to practice and apply the concepts they´ve learned in each chapter. Please note that GOAL/Gradiance is no longer available with this book. TABLE OF CONTENTS 1 The Worlds of Database Systems 1.1 The Evolution of Database Systems 1.1.1 Early Database Management Systems 1.1.2 Relational Database Systems 1.1.3 Smaller and Smaller Systems 1.1.4 Bigger and Bigger Systems 1.1.5 Information Integration 1.2 Overview of a Database Management System 1.2.1 Data-Definition Language Commands 1.2.2 Overview of Query Processing 1.2.3 Storage and Buffer Management 1.2.4 Transaction Processing 1.2.5 The Query Processor 1.3 Outline of Database-System Studies 1.4 References for Chapter 1 PART I: Relational Database Modeling 2 The Relational Model of Data 2.1 An Overview of Data Models 2.1.1 What is a Data Model? 2.1.2 Important Data Models 2.1.3 The Relational Model in Brief 2.1.4 The Semistructured Model in Brief 2.1.5 Other Data Models 2.1.6 Comparison of Modeling Approaches 2.2 Basics of the Relational Model 2.2.1 Attributes 2.2.2 Schemas 2.2.3 Tuples 2.2.4 Domains 2.2.5 Equivalent Representations of a

Anbieter: buecher.de
Stand: 25.05.2019
Zum Angebot
NoSQL Distilled
41,99 € *
ggf. zzgl. Versand

Modeled after UML Distille Product Description The need to handle increasingly larger data volumes is one factor driving the adoption of a new class of nonrelational ?NoSQL? databases. Advocates of NoSQL databases claim they can be used to build systems that are more performant, scale better, and are easier to program. NoSQL Distilled is a concise but thorough introduction to this rapidly emerging technology. Pramod J. Sadalage and Martin Fowler explain how NoSQL databases work and the ways that they may be a superior alternative to a traditional RDBMS. The authors provide a fast-paced guide to the concepts you need to know in order to evaluate whether NoSQL databases are right for your needs and, if so, which technologies you should explore further. The first part of the book concentrates on core concepts, including schemaless data models, aggregates, new distribution models, the CAP theorem, and map-reduce. In the second part, the authors explore architectural and design issues associated with implementing NoSQL. They also present realistic use cases that demonstrate NoSQL databases at work and feature representative examples using Riak, MongoDB, Cassandra, and Neo4j. In addition, by drawing on Pramod Sadalage?s pioneering work, NoSQL Distilled shows how to implement evolutionary design with schema migration: an essential technique for applying NoSQL databases. The book concludes by describing how NoSQL is ushering in a new age of Polyglot Persistence, where multiple data-storage worlds coexist, and architects can choose the technology best optimized for each type of data access. Preface xiii Part I: Understand 1 Chapter 1: Why NoSQL? 3 1.1 The Value of Relational Databases 3 1.2 Impedance Mismatch 5 1.3 Application and Integration Databases 6 1.4 Attack of the Clusters 8 1.5 The Emergence of NoSQL 9 1.6 Key Points 12 Chapter 2: Aggregate Data Models 13 2.1 Aggregates 14 2.2 Key-Value and Document Data Models 20 2.3 Column-Family Stores 21 2.4 Summarizing Aggregate-Oriented Databases 23 2.5 Further Reading 24 2.6 Key Points 24 Chapter 3: More Details on Data Models 25 3.1 Relationships 25 3.2 Graph Databases 26 3.3 Schemaless Databases 28 3.4 Materialized Views 30 3.5 Modeling for Data Access 31 3.6 Key Points 36 Chapter 4: Distribution Models 37 4.1 Single Server 37 4.2 Sharding 38 4.3 Master-Slave Replication 40 4.4 Peer-to-Peer Replication 42 4.5 Combining Sharding and Replication 43 4.6 Key Points 44 Chapter 5: Consistency 47 5.1 Update Consistency 47 5.2 Read Consistency 49 5.3 Relaxing Consistency 52 5.4 Relaxing Durability 56 5.5 Quorums 57 5.6 Further Reading 59 5.7 Key Points 59 Chapter 6: Version Stamps 61 6.1 Business and System Transactions 61 6.2 Version Stamps on Multiple Nodes 63 6.3 Key Points 65 Chapter 7: Map-Reduce 67 7.1 Basic Map-Reduce 68 7.2 Partitioning and Combining 69 7.3 Composing Map-Reduce Calculations 72 7.4 Further Reading 77 7.5 Key Points 77 Part II: Implement 79 Chapter 8: Key-Value Databases 81 8.1 What Is a Key-Value Store 81 8.2 Key-Value Store Features 83 8.3 Suitable Use Cases 87 8.4 When Not to Use 87 Chapter 9: Document Databases 89 9.1 What Is a Document Database? 90 9.2 Features 91 9.3 Suitable Use Cases 97 9.4 When Not to Use 98 Chapter 10: Column-Family Stores 99 10.1 What Is a Column-Family Data Store? 99 10.2 Features 100 10.3 Suitable Use Cases 107 10.4 When Not to Use 109 Chapter 11: Graph Databases 111 11.1 What Is a Graph Database? 111 11.2 Features 113 11.3 Suitable Use Cases 120 11.4 When Not to Use 121 Chapter 12: Schema Migrations 123 12.1 Schema Changes 123 12.2 Schema Changes in RDBMS 123 12.3 Schema Changes in a NoSQL Data Store 128 12.4 Further Reading 132 12.5 Key Points 132 Chapter 13: Polyglot Persistence 133 13.1 Disparate Data Storage Needs 133 13.2 Polyglot Data Store Usage 134 13.3 Service Usage over Direct Data Store Usage 136 13.4 Expanding for Better Functionality 136 13.5 Choosing the Right Technology 138 13.6 Enterprise Concerns with Polyglot Persistence 138 13.7 Deployment Complexity 139 13.8 Key Points 140 Chapter 14: Beyond NoSQL 141 14.1 File Systems 141 14.2 Event Sourcing 142 14.3 Memory Image 144 14.4 Version Control 145 14.5 XML Databases 145 14.6 Object Databases 146 14.7 Key Points 146 Chapter 15: Choosing Your Database 147 15.1 Programmer Productivity 147 15.2 Data-Access Performance 149 15.3 Sticking with the Default 150 15.4 Hedging Your Bets 150 15.5 Key Points 151 15.6 Final Thoughts 152 Bibliography 153 Index 157 Modeled after

Anbieter: buecher.de
Stand: 23.05.2019
Zum Angebot