July 2017 - UPDATE

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

Data modelers are responsible for creating and maintaining the conceptual, logical, and physical data models for an organization. These data models are used to define the data requirements that support the business goals, but business stakeholders often have difficulty understanding how these technical documents correlate to their business processes.

If there is a "bottom line" to measuring the effectiveness of your big-data applications, it's arguably performance, or how quickly those apps can finish the jobs they run. Let's consider Spark. Spark is designed for in-memory processing in a vast range of data processing scenarios. Data scientists use Spark to build and verify models. Data engineers use Spark to build data pipelines. In both of these scenarios, Spark achieves performance gains by caching the results of operations that repeat over and over again, then discards these caches once it is done with the computation.

Microsoft's SQL Server platform has been on a roll lately, with its smooth and feature-rich SQL 2016 release gaining accolades across the industry, including the DBMS of the Year award from db-engines.com. The company's increased focus on cloud, strong BI tool set, impressive functionality and emerging cross-platform capability with SQL on Linux has made this RDBMS a staple of database shops around the world.

Software audits are becoming a major risk to organizations. Microsoft, Oracle, SAP and other leading software vendors keep close tabs on their customers for potential license violations and true-up costs. A common occurrence is deploying more copies of software than the license agreement allows. But taking software inventory is a time-consuming and laborious process. A better approach is an integrated ITAM and asset information source.

MV Community

Zumasys, the parent company of jBASE and a provider of MultiValue software and cloud computing solutions, is collaborating with Indiana-based Ivy Tech Community College and Cook Medical to integrate jBASE into its Software Development certificate program to simulate real-world programming scenarios