TY - BOOK ID - 86142273 TI - Foundation Db2 and Python : access Db2 with module-base API examples using Python PY - 2021 SN - 148426942X 1484269411 PB - New York : Apress, DB - UniCat KW - Python (Computer program language). KW - Computers. KW - Management information systems. KW - Python. KW - Information Systems and Communication Service. KW - Enterprise Architecture. KW - Computer-based information systems KW - EIS (Information systems) KW - Executive information systems KW - MIS (Information systems) KW - Sociotechnical systems KW - Information resources management KW - Management KW - Automatic computers KW - Automatic data processors KW - Computer hardware KW - Computing machines (Computers) KW - Electronic brains KW - Electronic calculating-machines KW - Electronic computers KW - Hardware, Computer KW - Computer systems KW - Cybernetics KW - Machine theory KW - Calculators KW - Cyberspace KW - Scripting languages (Computer science) KW - Communication systems KW - Python (Computer program language) KW - Database management. KW - IBM Database 2. KW - Data base management KW - Data services (Database management) KW - Database management services KW - DBMS (Computer science) KW - Generalized data management systems KW - Services, Database management KW - Systems, Database management KW - Systems, Generalized database management KW - Electronic data processing KW - DB2 (Computer file) KW - Database 2 KW - DB2 universal database for OS/390 UR - https://www.unicat.be/uniCat?func=search&query=sysid:86142273 AB - 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 . ER -