Category: DB2

Feed: Databasejournal.com - Feature Database Articles. Author: . How many different database applications exist? Many people can name the most common ones such as MySQL, Microsoft SQL Server, and Oracle. Most good DBAs and programmers could likely rattle off a dozen different databases is you asked them to. This begs the question - how many can you name? Before looking at the list below or reading any further, I challenge you to consider a number. More so, I challenge you to then write your list to see if you can meet the number you selected! To be clear - SQL ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Relational databases catered to the need of backend database in application development arena for quite a long time, but there are other types of databases that have the potential to do the same. We should not overlook their merit while dealing with a RDBMS as they can serve similar purposes equally well, and possibly in a better way. These database models are related to the relational concepts in doing what they do best. This article provides a perspective on the philosophies of database systems that are designed to be different from the ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Visual Studio 2019 is a massive step forward in the developer spectrum. Not only has it shifted a lot of boundaries, but it has also made it easier to extend its interface.  In this article you will see tools – rather, extensions or add-ons - that can be added to the Visual Studio 2019 IDE to improve your database experience irrespective of what database it is. You should find these quite tools useful. MySQL Editor for Visual Studio Being a part time programming teacher, I always try to have good samples for ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Since late 2016, Db2 V12 for the z/OS platform has been generally available. Along with many new features, V12 was the last version on the z/OS platform to be delivered as a complete software upgrade. Future features will be delivered using a new system called continuous delivery, where subsets of features are delivered as “function levels”. Sites may then choose which features and functions they wish to implement. In this article some of the more useful features of Db2 and SQL that have been delivered as new functionality in the latest releases ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Analytical reporting against big data has become standard in many companies, along with embedding simple analytical queries in real-time applications. What’s next? Combining big data and on-line transaction processing methods into a single infrastructure, allowing transactional and analytical processing to co-exist. A Quick History of Analytics Several technologies such as Hadoop, NoSQL and database appliances are used to store and retrieve massive amounts of data using parallel I/O channels and proprietary hardware. The next step in this quest to squeeze value out of the company’s data was to have operational applications do ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . As recently as a decade ago, database administrators had to execute many complex and interesting tasks such as capacity planning, SQL performance tuning and most recently supporting business analytics in the big data environment. Today, however, most of these tasks are performed by artificial intelligence systems or the database itself. With so few important tasks left to perform, are DBAs really needed anymore? The Classic DBA As databases and their supporting software matured in the 1980s, IT departments had to grow or hire support staff to handle a large variety of technical ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . 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?  Big Data Evolution The first big data applications were for forecasting based on historical data. IT extracted operational data on a regular basis (usually nightly) to store within a stand-alone big data solution ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Featured Database Articles Posted April 23, 2019 By Marcin Policht Data imports represent some of the more commonly performed database management tasks. When importing data into Azure SQL Database, you can leverage a number of traditional SQL Server data import techniques. In this article, you will get an overview of these techniques and learn about the cloud-specific aspects of importing. The most straightforward methods that you can use in order to import data into tables hosted by an instance of Azure SQL Database include: Transact-SQL statements: You have the option of invoking ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Artificial Intelligence in IT Today Many IT departments have implemented software solutions that go beyond simple transaction and analytical processing. These packages contain models that describe certain data behaviors, and these models consume current data to see if these patterns of data behavior exist. If so, operational systems can use this information to make decisions. A good example of this is fraud detection. IT data engineers use analytics on historical data to determine when fraud occurred, code this into a model, and deploy the model as a service. Then, any operational system ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . In September 2018, IBM announced a new product, IBM Db2 AI for z/OS. This artificial intelligence engine monitors data access patterns from executing SQL statements, uses machine learning algorithms to decide on optimal patterns and passes this information to the Db2 query optimizer for use by subsequent statements. Machine Learning on the IBM z Platform In May of 2018, IBM announced version 1.2 of its Machine Learning for z/OS (MLz) product. This is a hybrid zServer and cloud software suite that ingests performance data, analyzes and builds models that represent the health ... Read More