Subscribe to the DBTA E-Edition email newsletter

March 2023

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

Organizations rely heavily on SAP systems and applications to run crucial business processes; securing these systems against cyber-attacks is vital. While several cybersecurity frameworks exist to manage cyber risks, they use generic wording that is hard to apply to application security and lack specific guidance to cover SAP environments. As a result, organizations must select the right frameworks to enhance their security posture and streamline complex security operations to safeguard critical assets from attacks.

Columns - Database Elaborations

Across database structures, dates are ubiquitous: sales date; order date; shipment date; receipt date; created date; last updated date. You might think that with such an abundant presence, dates would be well understood. Sadly, dates hide in the shadows—and many are confused over how dates work. People run a query, get a result, and seem to expect that what one sees, is what one gets. If they see a two-digit year, they believe that is exactly how the data is stored.

Columns - DBA Corner

This month, I want to take a higher-level view of database performance concepts and introduce a few themes that will likely follow you throughout your career working with database systems and applications. These themes should be viewed as guiding principles to keep in mind when confronted with database performance issues.

Columns - MongoDB Matters

A long, long time ago—in the early 90s—I first worked as a DBA with responsibility for enterprise databases. I will never forget how surprised and disappointed I was to discover that the data in the database files were completely unencrypted.  A system administrator with access to the database files could read the data in those files, even if they didn't have a database username and password.

MV Community

Entrinsik is releasing Informer 5.7, adding a new user interface that simplifies Informer with intuitive ways to navigate, design, and utilize the tool from the home screen. Also, Informer 5.7 features an enhanced workflow which has been redesigned to feel natural and provide a consistent experience, increasing the ease and effectiveness of accessing, analyzing, sharing, and automating data.

Evoke from BlueFinity allows MultiValue technologists to create native and web apps that are as modern as any app on a phone, tablet, or desktop. Evoke enables users to integrate MV data and legacy code, meaning faster to market with lower development cost and easier enhancement and modification, according to the vendor. Users can utilize tools such as chatbots, AI, ChatGPT, graphs, signature panels, retail card views, component libraries and much, much more without becoming a specialist in those technologies.

Rocket Software announced it will launch the first of its new MultiValue (MV) eLearning modules. Available in late February, the first module is an MV Foundation path that covers eight topics: querying files and records; editing records and fields; creating files; describing files, records, and fields with a dictionary; creating interactive (I-type) fields; manipulating selections of data with select lists; writing a simple program with prompts and conditional logic in a paragraph; and increasing performance with hashed files and indexes.

Rocket Software will present its roadmap for Q2 2023 during an upcoming livestream highlighting its MultiValue products. The livestream will include updates on Rocket UniVerse, Rocket UniData, Rocket D3, jBASE, OpenQM, AccuTerm, and MultiValue tools including the MultiValue Integration Server (MVIS) and the MV Experiences (MVX) as well as new e-Learning.

The Rocket Software MV team announced the release of UniVerse 11.3.5, increasing supportability, stability, and performance. UniVerse 11.3.5 contains a total of 70 bug fixes and 15 enhancements encompassing audit logging, Python, replication, security, encryption, and more.