dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
Free Newsletters:



DatabaseUpdate  

News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

DB2 management, tutorials, scripts, coding, programming and tips for database administrators

DB2

The Demise of the DBA 06/17/2019

Today most of the tasks done by traditional DBAs are performed by artificial intelligence systems or the database itself. With so few important tasks left to perform, are DBAs really needed anymore?

The Demise of Big Data 05/24/2019

Big data as an application (or as a service) is being supplanted by artificial intelligence (AI) and machine learning. Few new requirements for a big data solution have arisen in the past few years. All the low-hanging fruit (fraud detection, customer preferences, just-in-time re-stocking and delivery, etc.) have already been big data-ized. Is this the end of big data?

IBM Improves IT Operations with Artificial Intelligence 04/18/2019

IBM has enhanced its Operations Analytics software on the IBM Z platform by leveraging IBM Watson Machine Learning (WML) for z/OS. WML is implemented as a service that interfaces with several varieties of data, creates and trains machine learning models, scores them and compares the models with live metrics. The operations analytics software then classifies and analyzes the results to detect and predict problems. Read on to learn more!

Data Masking in the World of GDPR 03/21/2019

Your production database environment stores personally identifiable information in an encrypted form, limits access to these fields and masks them when displayed. However, some types of data encryption create potential performance problems as well as security issues. Your data may be at risk unless you mask it effectively.

IBM Db2 Query Optimization Using AI 02/18/2019

IBM’s machine learning is being used to improve the performance of analytical queries as well as operational queries and their associated applications. This requires management attention, as you must verify that your business is prepared to consume these ML and AI conclusions. Learn more…

Top 10 Databases for 2019 01/31/2019

A look at ten top databases fighting for mind-share in 2019.

HTAP - Hybrid Transaction and Analytical Processing 01/10/2019

The IT enterprise has grown, databases are bigger, companies have more product lines, more services, more customers and more transactions. Business analysts used to be satisfied with subsets of only certain data elements for their queries, and now they want it all. Now they want more....

Big Data: Health Checking Your System 12/18/2018

As big data solutions grow in size and complexity, concerns can rise about future performance. One way to assess the potential effects is to measure your big data application’s health.

IBM Db2 Statistical Functions for Analytics 11/27/2018

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, including IBM's flagship product, Db2.

IBM Offers AI-Assisted SQL Tuning 10/18/2018

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.

Db2 Application Performance Enhancements 09/17/2018

Db2 Version 12 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.

High-Performance Data Encryption and Db2 08/16/2018

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. Read on to learn more.

Big Data Analytics on Current Data 07/16/2018

IBM now provides an option to configure its Db2 version 12 for z/OS and complementary IBM Db2 Analytics Accelerator (IDAA) to permit concurrent transactional processing of operational data with analytics processing of data in the appliance. This new feature, zero-latency HTAP (hybrid transactional analytical processing) provides a patented replication process that propagates native Db2 table changes to the IDAA data store. This then allows BI queries to act on up-to-date data.

DB2 Archives