Foundation DB2 and Python: Access DB2 with Module-Based API Examples Using Python
暫譯: 使用 Python 的模組化 API 範例訪問 DB2 的基礎知識
Ashley, W. David
相關主題
商品描述
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.
What You'll Learn
Python programmers and DB2 administrators interested in building application with Python and DB2
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.
What You'll Learn
- 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
Python programmers and DB2 administrators interested in building application with Python and DB2
商品描述(中文翻譯)
與 Db2 一起使用優化的程式碼撰寫 SQL 並訪問資料庫,以獲得最快的響應。本書將提供有關 IBM_db 模組的完整文檔,並提供多個範例來展示每個模組 API 的使用方法。
首先,獲取適用於 Linux 和 Windows 的 Db2 免費版本。雖然本書主要集中於 Db2 的 Linux 版本,但也涵蓋了足夠的 Windows 版本內容,以便您能夠輕鬆獲取和安裝 Db2 在您的 Windows 版本上。接下來,您將看到如何安裝隨 Db2 附帶的範例資料庫,並從網路上提取一些資料來設計一個資料庫,包括表格和索引。
為了讓 Db2 真正有用,您需要使用強大的 SQL 表達式。本書提供了具體的範例,說明如何避免使用可能導致查詢額外處理時間的劣質表達式。最後,您將查看 ibm_db 和 ibm_db_dbi 模組中的每個 API。此模組並未由 IBM 贊助,必須與 Db2 資料庫分開安裝。
閱讀完 Foundation Db2 and Python 後,您將能夠在 Windows 或 Linux 上安裝 Db2,並執行備份和恢復資料。
您將學到什麼
- 正確獲取和安裝 Db2 在 Linux 和 Windows 上
- 創建資料庫並在 Db2 上加載它們
- 使用 ibm_db 和 ibm_db_dbi API 模組進行 Python 開發
- 為 Db2 撰寫 SQL
- 回顧 ibm_db Python 模組的未來
對使用 Python 和 Db2 構建應用程式感興趣的 Python 程式設計師和 DB2 管理員
作者簡介
W. David Ashley is a technical writer for SkillSoft where he specializes in open source, particularly Linux. As a member of the Linux Fedora documentation team he recently led the Libvert project documentation, and wrote the Python programs included with it. He has developed in 20 different programming languages during his 30 years as a software developer and IT consultant, including more than 18 years at IBM and 12 years with American Airlines.
作者簡介(中文翻譯)
W. David Ashley 是 SkillSoft 的技術作家,專注於開源技術,特別是 Linux。作為 Linux Fedora 文檔團隊的成員,他最近負責了 Libvert 專案的文檔,並撰寫了隨附的 Python 程式。他在擔任軟體開發人員和 IT 顧問的 30 年職業生涯中,使用過 20 種不同的程式語言,其中包括在 IBM 工作超過 18 年,以及在美國航空公司工作 12 年。