Foundation Db2 and Python : access Db2 with module-based API examples using Python / W. David Ashley.
2021
QA76.9.D32 A75 2021
Linked e-resources
Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks
Details
Title
Foundation Db2 and Python : access Db2 with module-based API examples using Python / W. David Ashley.
Author
Ashley, W. David, author.
ISBN
9781484269428 (electronic bk.)
148426942X (electronic bk.)
9781484269411
1484269411
148426942X (electronic bk.)
9781484269411
1484269411
Published
[Berkeley] : Apress, [2021]
Copyright
©2021
Language
English
Description
1 online resource : illustrations
Item Number
10.1007/978-1-4842-6942-8 doi
Call Number
QA76.9.D32 A75 2021
Dewey Decimal Classification
005.75/65
Summary
Work with Db2 to write SQL and access databases using optimized code for the fastest response. This book will give you complete documentation on DB2 via Python for the IBM_db module and provide a number of examples for the usage of each module API. Begin by getting your free version of Db2 for Linux and Windows. While the book concentrates more on the Linux version of Db2, it also covers enough of the Windows version so that you're comfortable with obtaining and installing Db2 on your version of Windows. Next, you'll see how to install the sample database that comes with Db2, and take some data from the web to design a database around it, including tables and indexes. For Db2 to be really useful you need to use strong SQL expressions. This book provides specific examples of how to avoid using poor ones that can cause extra processing time for the query. Lastly, you'll look at each API in the ibm_db and ibm_db_dbi module. This module is not sponsored by IBM and must be installed separately from the Db2 database. After reading Foundation Db2 and Python you'll be able to install Db2 on Windows or Linux, and perform backups and restore data. You will: Obtain and install Db2 properly on Linux and Windows Create databases and load them on Db2 Work with ibm_db and ibm_db_dbi API modules for Python Write SQL for Db2 Review the future of the ibm_db Python module.
Note
Includes index.
Access Note
Access limited to authorized users.
Source of Description
Online resource; title from PDF title page (SpringerLink, viewed August 19, 2021).
Available in Other Form
Print version: 9781484269411
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
All Resources
Table of Contents
Chapter 1: Introduction to Db2 for Linux and Windows
Chapter 2: Installing Db2 Db2 on Linux and Windows
Chapter 3: Db2 Management
Chapter 4: Database Physical Design
Chapter 5: Db2 Utilities
Chapter 6: Business Rules and Constraints
Chapter 7: Writing Good SQL for Db2
Chapter 8: Python and Db2
The ibm_db Module
Chapter 9: ibm_db Module Documentation
Chapter 10: Where Is The ibm_db Module Going?
Chapter 2: Installing Db2 Db2 on Linux and Windows
Chapter 3: Db2 Management
Chapter 4: Database Physical Design
Chapter 5: Db2 Utilities
Chapter 6: Business Rules and Constraints
Chapter 7: Writing Good SQL for Db2
Chapter 8: Python and Db2
The ibm_db Module
Chapter 9: ibm_db Module Documentation
Chapter 10: Where Is The ibm_db Module Going?