Category: DB2

Feed: Databasejournal.com - Feature Database Articles. Author: . Until recently, business analytics against big data and the enterprise data warehouse had to come from sophisticated software packages. This was because many statistical functions such as medians and quartiles were not available in basic SQL, forcing the packages to retrieve large result sets and perform aggregations and statistics locally. Today, many database management systems have incorporated these functions into SQL. This includes IBM's flagship product, Db2. Basic Analytics Many large IT shops implemented big data solutions over a decade ago. At that time, the science of statistics was well-established. Business analysts ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . A new separately-priced software offering from IBM on z/OS systems uses machine learning and artificial intelligence to assist the Db2 Optimizer in choosing high-performance access paths for SQL statements. Database Proliferation Affects DBAs At the enterprise level, it is now normal to expect that production applications issue hundreds of thousands (or even millions) of SQL statements every day. These statements run the gamut of complexity from single-row requests based upon a unique key to multi-table joins to business analytical queries involving scores of tables and potentially running for hours. Yet, despite decades ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Db2 Version 12, the latest version of IBM's flagship database management system for the z/OS hardware platform, includes many new and improved features specifically aimed at improving application performance. As today's development teams are driven to implement applications at a faster pace, the DBMS must support the ability to retrieve data quickly, while at the same time reducing overall resource usage. Here is a detailed look at some modern transactional data processing issues and how Db2 meets these challenges. The Challenge of the Data Archive Due to governmental regulations or compliance reasons, ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . IBM's Db2 Version 12 for z/OS was designed to synergize with new IBM z14 hardware, which includes several new and updated options for hardware-assisted data encryption and compression. These features can be used by the database management system to store and retrieve encrypted and compressed data transparently without application knowledge or intervention. This is a significant advance from prior software-based processes, which could be extremely CPU-intensive. By offloading encryption and compression work to specialized hardware, Db2 can reduce CPU costs while also shortening transaction times. Encryption Basics As children, many of us ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Background In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future.  On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc. In this article we will discuss what the steps that can be followed to migrate on-premise Oracle database to the SQL Server cloud database, Azure SQL Database. This technology migration requires ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Typical big data applications have a load phase, where a snapshot of data is extracted from operational systems, transformed and cleaned, and then loaded into your big data appliance. Analysts and data scientists can then execute business analytics (BI) queries against the data store in search of patterns and potential marketing opportunities and cost savings. One disadvantage of this architecture is that your appliance becomes more like a large data warehouse, in that it does not contain the most up-to-date data. IBM now provides an option to configure its Db2 version 11 ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Zero-latency HTAPAs big data applications matured one thorny performance issue remained: the data in the appliance was huge, and required time-consuming data load processes. For some customers it became like a large data warehouse, providing analytics against day-old data. Other customers attempted to load the appliance as soon as operational data was available. Still, there was a time delay while loading applications executed. Also, at times several loads were required to several tables to maintain data consistency. For example, one couldn’t load new orders into the Order table until the corresponding customers ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . News Via RSS Feed Featured Database Articles Posted April 19, 2018 By Lockwood Lyon 5 New Features for Db2 12 for z/OS SQL Pagination Syntax In the past, on-line applications provided search capabilities to users by permitting the entry of key subsets or wildcards on the screen. For example, one could request a search for customers with a last name of “Smith*”, where the asterisk indicated any combination of zero or more letters. The results would include names like Smith, Smithe and Smithson. Typically, the application would present these results in alphabetical ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); It's already two months since the last Db2 User Group meeting, time to point you to the next one. The German Db2 user group, DeDUG (Deutsche Db2 User Group) is going to meet next month, April 20th, in Munich. Henrik Loeser has all the details. DeDUG: Db2 User Group If you clicked the previous link, you should have gotten back to this blog entry. At the meeting, I am going to present on SQL ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Slackbot Architecture Last week, I introduced you to a new tutorial for a database-driven Slackbot. Today, I am going to discuss details of how the IBM Watson Conversation service is accessing a Db2 Warehouse service from within a dialog. It uses a serverless setup with IBM Cloud Functions. All the necessary credentials to execute the code and to access the Db2 database are automatically bound ... Read More