May 2022

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 is one of the most valuable assets your company owns. Database management, however, is undifferentiated heavy lifting that incurs high operational costs. Management of your database, such as applying patches, managing backups and failovers, is not where you provide value to your customers.

The volume, velocity and veracity of today's data deluge has put immense pressure on underlying data platforms and organizations' abilities to manage them effectively. And the pandemic has only exacerbated the problem. According to a 2021 survey, nearly half of digital architects are under high or extremely high pressure to deliver digital projects, but 61% blame legacy technology for making it difficult to complete modernization efforts. That said, databases of all types—SQL, NoSQL, or NewSQL—be they on-prem, cloud, hybrid, or edge, are struggling to navigate this new reality.

PostgreSQL compatibility is a no-brainer for any modern database offering a unique feature set. Every modern database vendor is now offering some level of compatibility to reach developers and increase adoption. Recently, Google Spanner announced compatibility, saying, "PostgreSQL has emerged as the ‘API' for operational databases." But, even if a database claims compatibility, it can be difficult to decipher what that means in relation to another database, as not all "compatibility" is created equal.

No other subject seems to capture the attention of IT leaders right now like database migrations. If there were an IT theme for 2022, it would be: Enterprises migrate from legacy data warehouses to the cloud. And it is no longer just the "early adopters" but the entire customer base that is looking to make the move to cloud-based systems. Let's examine the three most common problems that hamper the execution of migration projects and what can be done to avert migration disasters.

The 9th annual Data Summit conference will be held May 17-18, 2022, at the Hyatt Regency Boston. Pre-conference workshops will take place on May 16, 2022. The program is available for review and a variety of pass options are available to suit individual requirements.

Your database environment is getting more complex. If that sounds like old hat, that's because it is.For years, articles like this have warned of the dangers of increasingly convoluted database environments. They've discussed how Database Administrators (DBAs) are now tasked with managing thousands of databases and supporting technologies. They've lamented over increasing fragmentation and workflow-stymying bottlenecks, which have, among a whole list of things, significantly hampered developer velocity. And they've explained that opting for specialized databases and tools for every need can quickly spiral into vendor lock-in, swelling support contracts, and surrendered control over your data.

Columns - Database Elaborations

The value of normalization is in understanding the data well enough to create the normalized design. Pulling out the business rules, business terms, and relationships from the mass of jumbled together raw content is critical. The business rules that result from performing the normalization exercise establish the requirements that need to be satisfied by solutions, whether they are either built or purchased. When an organization creates and maintains a normalized design for the data within the important areas of their business, they reduce work on all future systems.

Columns - DBA Corner

Operational databases continue to expand, with database sizes growing in most organizations. In terms of performance, the more data in the operational database, the less efficient transactions running against that database tend to be. The other impact, database administration complexity, causes longer processing time and outages to perform traditional DBA tasks. But as important as operational performance and administration issues are, frequently they are ancillary to the regulatory issue of preserving authentic data over time.

Columns - Emerging Technologies

MongoDB's recent enhancements are definitely of the perfective variety—broadly improving on the initial implementations of new features of 5.0. However, they go a long way toward enhancing the capabilities of 5.0 and creating a significant advantage for users of the MongoDB Atlas cloud.

MV Community

BlueFinity is giving users the option of developing a native or web app with Evoke. With a low-code platform, such as Evoke from BlueFinity, the developer can generate and deploy native (as well as web apps) to run on all devices, operating systems and browsers, all from the same app design and code.

Rocket Software is launching the latest version of the MultiValue Performance Experience (MVX: Performance) platform, delivering increasing value to customers and addressing issues and bugs in the code faster. The latest MVX: Performance 1.2.0 release continues to add metrics customers are interested in monitoring.