Despite the attention given to new big data management technologies, Db2 remains one of the most widely used database management systems in the world and a fundamental component of many enterprise data architectures. Craig S. Mullins: Db2 is still one of the most powerful and most used database management systems in the world. It is for the most part, the only relational DBMS used on mainframes—and mainframes still power most of the Fortune , including major financial institutions and banks, airlines, retailers, telcos, and more.
|Published (Last):||25 April 2019|
|PDF File Size:||9.36 Mb|
|ePub File Size:||15.91 Mb|
|Price:||Free* [*Free Regsitration Required]|
Despite the attention given to new big data management technologies, Db2 remains one of the most widely used database management systems in the world and a fundamental component of many enterprise data architectures. Craig S.
Mullins: Db2 is still one of the most powerful and most used database management systems in the world. It is for the most part, the only relational DBMS used on mainframes—and mainframes still power most of the Fortune , including major financial institutions and banks, airlines, retailers, telcos, and more. From a big data perspective, organizations are looking to run analytical processes on many different types of data. That said, business transactions are usually at the top of the list of the type of big data that executives want to analyze.
CSM: It is not just transactions that drive big data. And Db2 is well-equipped to handle, manage, and optimize many disparate types of data, including unstructured and multimedia data, JSON, XML, and even temporal data. Db2 has also been optimized to support very high-speed processing for complex Db2 queries to support business-critical reporting and analytic workloads. So data management today is a world of polyglot persistence—the right database systems for the right applications—and Db2 is definitely a part of this world.
CSM: It is for developers and programmers and developing applications—not database and system administration. The sole purpose of the book is to provide expert guidance on application development procedures, techniques, and philosophies. The book will educate developers on how to write good application code that will perform optimally. By following the principles in this book you should be able to write code that does not require significant remedial, after-the-fact modifications by DBAs and performance analysts.
The techniques in this book are important to incorporate into your development strategies, especially in a DevOps environment, where continuous integration and delivery of application change is required. The last thing you want to do is to deliver inefficient code to production quickly, right? CSM: If you write code and access data in a Db2 database, then this book is for you.
When there are pertinent differences between the two it will be pointed out in the text. Readers should have basic SQL knowledge. Additionally, the book will not rehash material that is freely available in Db2 manuals that can be downloaded or read online. CSM: The performance of accessing and modifying data in the database has been important ever since the invention of the first database management system.
Assuring optimal performance of applications is a significant ongoing operational challenge. Every database application, at its core, requires three components in order to operate: the system, the database and the application. To deliver performance, we must be able to monitor and tune each of these components.
This is easier said than done. Of the three, the aspect that causes most performance problems is the application code. Using the wrong index or no index at all , inefficient access paths, bad optimizations, and more can cause problems. Quite frankly, basic SQL may be simple to learn and easy to start using, but using SQL effectively and efficiently is an art that takes years to master. This book offers guidance to make it easier to write efficient SQL.
CSM: Most other books focus on performance as a subset of the book, whereas this book is entirely devoted to the subject. And most other books focus on the topic of performance somewhat retroactively. By this I mean that they cover performance monitoring and tuning of existing applications instead of how to write applications to perform right from the start. To access the book, go to here. Applications Insight from Guy Harrison.
Big Data Notes from Guy Harrison. Emerging Technologies from Guy Harrison. Database Elaborations from Todd Schraml. Data and Information Management Newsletters. Cyber Security SourceBook. Artificial Intelligence. Data Center Management. Data Modeling. Data Quality. Data Warehousing. Database Security. Internet of Things. Master Data Management.
MultiValue Database Technology. In the new era of big data and cloud, where does Db2 fit in? What else is Db2 optimized for? What is the purpose of this book? Who is it targeted at? Why is database performance so critical now? What can happen? What is new in this book that is not in other Db2 books? Recent Big Data Quarterly Issues. White Papers. Data Warehouse Modernization. Data Sourcebook. Database Trends and Applications delivers news and analysis on big data, data science, analytics and the world of information management.
Problems with this site? Please contact the webmaster. Media Partner of the following user groups.
Craig S Mullins
Craig Mullins - IBM Gold Consultant
Craig S. Return to Home Page. Mullins As a professional DB2 developer your days are extremely busy. Not only do you need to understand DB2, but you also need to understand programming and design issues, SQL, data modeling, operating system internals, on -line transaction processing systems, performance monitors, third-party tools, distributed data, and office politics. Wouldn't it be nice if there were a place to turn for advice? Well, now there is!