Beginning DB2 (eBook)
XXVI, 515 Seiten
Apress (Verlag)
978-1-4302-0548-7 (ISBN)
IBM's DB2 Express Edition is one of the most capable of the free database platforms available in today's marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you'll find:
- A friendly introduction to DB2 Express Edition, an industrial-strength, relational database from IBM
- Dozens of examples so that you are never in doubt as to how things work
- Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more
The book is aimed at developers who want a robust database to back their applications.
Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.
IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find: A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more The book is aimed at developers who want a robust database to back their applications.
Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.
Contents at a Glance 5
Contents 7
About the Author 19
About the Technical Reviewer 20
Acknowledgments 21
Introduction 22
Getting Started 24
What Is DB2 and Where Can I Get It? 25
Installing DB2 for Linux and Windows 32
Beginning Administration with DB2 Express Edition 57
DB2 Wizards: The Fast Path to Working with Your New Database 58
Controlling Your Environment with DB2 Control Center and Command-Line Tools 81
Database Fundamentals with DB2 Express Edition 104
IBM Data Studio 105
SQL for DB2: Part 1 126
SQL for DB2: Part 2 142
Developing Functions and Stored Procedures in DB2 158
Controlling Access to DB2 177
Securing Data in DB2 190
Using XML with DB2 208
Indexes, Sequences, and Views 228
Programming with DB2 Express Edition 251
PHP with DB2 252
DB2 on Rails 274
DB2 Development with Microsoft Visual Studio.NET 289
Developing Java Applications with DB2 310
Exploring More DB2 Development Options 332
Ongoing Database Administration with DB2 344
Database Creation and Configuration 345
DB2 Backup and Recovery 366
Sharing Your DB2 Environment 391
Moving Data in Bulk with DB2 413
Working with Design 433
Moving Up to More Advanced DB2 447
Monitoring and Tuning DB2 Performance 465
Index 496
| Erscheint lt. Verlag | 20.11.2008 |
|---|---|
| Zusatzinfo | 544 p. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► DB2 |
| Schlagworte | ACCESS • Database • database administration • Interface • .NET • Performance • Python • Relational Database |
| ISBN-10 | 1-4302-0548-2 / 1430205482 |
| ISBN-13 | 978-1-4302-0548-7 / 9781430205487 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 12,3 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Zusätzliches Feature: Online Lesen
Dieses eBook können Sie zusätzlich zum Download auch online im Webbrowser lesen.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
