DBTA E-EDITION
September 2018

Subscribe to the online version of Database Trends and Applications magazine. DBTA will send occasional notices about new and/or updated DBTA.com content.


Trends and Applications

The Open Mainframe Project has announced Zowe, an open source software framework that bridges the divide between modern applications and the mainframe, intended to provide easier interoperability and scalability among products and solutions from multiple vendors. Zowe is the first open source project based on z/OS.

Data lakes are a convenient and cost effective way to store a lot of data with completely diverse structures so that you don't have to build the model ahead of time, explained Paul Sonderegger, senior data strategist, Oracle, during Data Summit 2018. Data lakes are a convenient way and cost effective way to store a lot of data with completely diverse structures so that you don't have to build the model ahead of time, explained Paul Sonderegger, senior data strategist, Oracle during Data Summit 2018.

Every year, thousands of data experts and professionals from over 100 different countries converge at Oracle OpenWorld in San Francisco to discover the newest updates to Oracle's ecosystem of technologies. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand.

Data integration aims to provide a unified and consistent view of all enterprise wide data. The goal is to logically (and sometimes also physically) unify different data sources or data silos to provide a single unified view which is as correct, complete, and consistent as possible.  

Everyone wants to be part of a data-driven enterprise, and for good reason. Data analytics, when applied in a meaningful way, provides an enormous competitive advantage. There's a catch to this though that frequently gets overlooked amidst the glowing analyst projections and keynote speeches about a limitless future in which systems and machines do all the heavy lifting and thinking for businesses. Data—the right kind, in the right sequence, in the right context—doesn't just magically drop out of the cloud. It needs to be discovered, identified, transformed, and brought together for analysis, management, and eventual storage.

One of the most important shifts in data warehousing in recent times has been the emergence of the cloud data warehouse. Previously, setting up a data warehouse required a huge investment in IT resources to build and manage a specially designed on-premise data center. Now, several cloud computing vendors offer data warehousing functions as a service (DWaaS), accessible via an Internet connection. This model negates the costly capital expenditure and management required for an on-premise data warehouse.

As the industry embraces artificial intelligence and marches toward autonomous systems, some enterprises will still need to rely on traditional databases that must be managed, tuned, and secured to ensure the best performance. And while not all organizations will be able to make the autonomous transition quickly due to internal processes, there are a few tricks to optimize your old database with terabytes of data at speeds needed for everything from e-commerce to IoT and music streaming services on a global scale.

There's been a lot of discussion recently about autonomous databases, which offer the promise of keeping database systems stable and performant while alleviating much of the tuning and configuration drudgery that DBAs must typically slog through. It is important to note that an autonomous database needs to strike a balance between giving administrators too much and too little control. Too much control takes the form of endless configuration and tuning parameters that place the burden of performance and stability on the operator. Too little control takes the form of automated behaviors that reduce the predictability of the system to an unacceptable level.


Columns - Database Elaborations

In establishing a staging or landing area for a data lake, a data hub, or a quaint data warehouse environment, structures need to be established that will mimic source data in support of two very basic queries. The first is: "What does the current source dataset look like?" And the second: "What change activity has occurred against the source since the last time it was interrogated?"


Columns - DBA Corner

The current trend for software development teams is to adopt a continuous delivery approach based upon DevOps and agile development techniques. DevOps is relatively a new term, coined in 2009, defining software engineering practices that combine software development (Dev) and software operations (Ops). The general idea is not really all that new, but the adoption of agile techniques and modern tooling to automate software delivery is. The goal of DevOps is for developers and operations personnel to collaborate throughout the entire service lifecycle, from design through development and into production.


Columns - MongoDB Matters

The MongoDB 4.0 release introduced multi-document transactions to the popular open source NoSQL DB.  The lack of a transactional capability has been a key limiting factor in MongoDB uptake, so it's not surprising that the company, it's users and the technology press have been enthusiastic about this latest release. However, it's worth remembering that the transactional capabilities of MongoDB have been commonplace for many decades.


MV Community

Entrinsik is now an Oracle PartnerNetwork (OPN) Gold Level member, allowing Oracle customers to tap into Informer to combine data sources. Oracle customers can now purchase Informer to combine Oracle data with data from other sources throughout the organization for comprehensive analysis, whether that data is in the cloud, on premise, structured or unstructured.

Several MultiValue databases have been chosen as the best of the pack for this year's Database Trends and Applications Readers' Choice Awards. Each year, Database Trends and Applications magazine presents the Readers' Choice Awards, recognizing leading vendors across a variety of segments in the IT industry. Unlike any other awards programs conducted by DBTA, this one is special because the nominees are submitted and the winners are chosen by the experts—whose opinions carry more weight than all others—you, the readers.

ONgroup is enhancing its MultiValue platform, making upgrades that allow the platform to be a contemporary editor running in .NET. MVON# Netbuilder sites still get the benefits of an IDE, and now those running MV BASIC and related languages without Netbuilder can still get the benefit of this powerful MV# editor. Compiling with the MV# Developer Studio transpiles to C# and runs the MV code in .NET.

Sponsors