June 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

Broadcom Inc., a global technology provider that designs, develops, and supplies semiconductor and infrastructure software solutions, announced it is acquiring VMware, Inc., an innovator in enterprise software. Broadcom will acquire all of the outstanding shares of VMware in a cash-and-stock transaction that values VMware at approximately $61 billion, based on the closing price of Broadcom common stock on May 25, 2022. In addition, Broadcom will assume $8 billion of VMware net debt.

With greater automation and more robust cloud services, today's data professionals are seeing their roles elevated, working more closely with their businesses to deliver data-driven capabilities. At the same time, they, too, are feeling the effects of "The Great Resignation," reporting higher-than-usual turnover and increased pressure on overworked staffs.

There are so many new buzzwords lately, including the data lakehouse, data mesh, and data fabric, just to name a few. But what do all these terms mean, and how do they compare to a data warehouse? This presentation covers all of them in detail and explains the pros and cons of each, with suggested use cases so attendees can see what approach will really work best for their big data needs.

As we advance deeper into the digitally roaring 2020s, data executives and profession­als are seeing change on a scale never seen before in their careers. A new generation of technologies that often build on previous solutions means new ways of working and ensuring performance for today's increasingly data-driven enterprises. We asked industry leaders for their views on what technology is enhancing enterprises' ability to compete on data.

Companies now collect more data than ever before, but challenges remain for accessing and analyzing them. David Armlin, VP solution architect and customer success, ChaosSearch, discussed "Learn, Unlearn, Relearn: Embracing the Future of Cloud Analytics," during his Data Summit 2022 session.

Data fabrics are an emerging technology, a modern distributed data framework encompassing architecture as well as data management and integration software, designed to help organizations manage their data. Data fabrics can help get more—and more relevant—data into workflows faster for business intelligence and reporting. Much the way businesses use IT architectures to manage and maintain IT assets, data fabrics help businesses manage and get value from data.

To serve the data analytics and applications for business growth and operational needs, data lakes are being widely adopted as the data infrastructure because of their scalability and flexibility. Data lakes are strong at parking petabytes of data and production delivery as a result of their "schema-on-read" structure. But every coin has two sides. Data lakes, as a semantically flexible data store and bypassed governance efforts, have been seen as muddy swamps and inefficient in data management.

Columns - Database Elaborations

Data modeling is the process of defining datapoints and struc­tures at a detailed or abstract level to communicate information about the data shape, content, and relationships to target audiences. Data models can be focused on a very specific universe of discourse or an entire enterprise's informational concerns. The final product for a data modeling exercise varies from a list of critical subject areas, an entity-relationship diagram (ERD) with or without details about attributes, or even a data definition language (DDL) script contain­ing all the SQL commands to build a set of physical structures within some chosen database management system (DBMS).

Columns - DBA Corner

Data archiving is an important aspect of data governance and data management. Not only does archiving help to reduce hardware and storage costs, but it is also an important aspect of long-term data retention and a key participant in regu­latory compliance efforts. When long-term data retention is imposed on your data—anything more than a couple of years—then archiving it can be the most optimal solution.

Columns - Quest IOUG Database & Technology Insights

Oracle Application Express (APEX) is a low-code develop­ment platform that enables you to build scalable, secure enter­prise apps with world-class features that can be deployed anywhere. Using APEX, developers can quickly create and deploy compelling apps that solve real problems and provide immediate value.

Columns - SQL Server Drill Down

Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Man­aged Instances. This DMV consolidates and simplifies telemetry from SQL Server ring buffers, applies heuristics, and provides a result set. The DMV stores a record for each out-of-memory (OOM) event that occurs within the database, providing details about the OOM root cause, the memory consumption of database engine components at that point in time, potential sources of memory leaks, and more.

Columns - Next-Gen Data Management

Data plays a vital role in any successful business. Protect­ing this data is mission-critical, and it falls to database administrators (DBAs) to organize, maintain, and secure it. The most effective way for DBAs to protect data is through database backups, a process designed to copy the data and schema from an existing database and save it else­where for future retrieval. Like any process in IT, however, there are a few factors to consider when devising a database backup strategy to ensure it meets your business needs.

Columns - Emerging Technologies

The SQL language served as a universal language for data­base manipulation from the mid-1980s until NoSQL data­bases started gaining strength about 12 years ago. However, after a short period in the wilderness, SQL is back and possibly more vital than ever.

MV Community

Entrinsik is offering native support for jBase, enabling users to speak directly to their target database in the appropriate query language. Entrinsik already provides native support for UniData and UniVerse.

Rocket Software is introducing the Rocket MV BASIC for Visual Studio Code 1.6.0 extension, now available on the Visual Studio Code Marketplace. Rocket MV BASIC for VS Code (MVVS) allows BASIC developers to edit, compile, and now debug their BASIC applications in Microsoft Visual Studio Code.

Zumasys is acquiring the assets of PPI Information Systems, a PICK software house located in St. Louis, Missouri. PPI is a proven provider of software services offering programming services in PICK and Microsoft .NET using SQL or Universe as databases.