December 2020

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

When was the last time you ran across a single-vendor data shop? With the proliferation of multiple database engines for multiple purposes, enterprises now take advantage of a range of database types—not to mention an increasing abundance of cloud services. The difficulty is managing these diverse environments—security, provisioning, and access—in a centralized fashion.

The year 2020 has been extremely eventful on many levels. Time­lines for digital transformation—supported by data analytics—suddenly had to accelerate from 5-year horizons to overnight implementations. Expect more of this continuing velocity in the year ahead, as companies fast-track their plans for initiatives ranging from AI to edge computing. These all require enor­mous volumes of quality data, meaning data managers will be quite busy in the months ahead. DBTA spoke to leaders across the industry to gain their perspec­tive on what to expect.

Columns - Database Elaborations

A recent study indicated that IT professionals were three times more likely to disagree with their leadership than professionals in other indus­tries. Identifying a three-times-more-likely differ­ence of opinion seems a significant variance. I don't know what detailed insights the study arrived at to account for this level of disagreeable­ness. Maybe the study considered IT folks as being more educated, more logical, and therefore more difficult?

Columns - DBA Corner

Due to the advent of client/server computing in the 1990s, then internet and web-connectivity driving development, and the more recent growth of NoSQL databases, we are now manag­ing more types of data on more platforms than we ever have before. And that means that managing data is a lot more complex. This also means that DBAs need to possess exper­tise in cross-platform management and administra­tion.

Columns - Quest IOUG Database & Technology Insights

Whether you're already using Oracle or currently considering database solutions for your business needs, Markus Michale­wicz, senior director of product management at Oracle, recently iden­tified five reasons why Oracle Database is the best option.

Columns - SQL Server Drill Down

Microsoft and Red Hat have collaborated for more than 4 years on SQL Server and have come up with a variety of ways to better manage the server internals for higher performance. For example, the Windows OS has Large Pages and an option called Lock Pages in Memory. In Linux, you have the same capabilities using Transparent Huge Pages via trace flag 834, and even more memory management options by tuning dirty page ratios to pre­vent disk swapping.

Columns - Next-Gen Data Management

COVID-19 is accelerating the drive toward SaaS apps and cloud adoption, and many companies are now adopting a hybrid cloud approach. Most are going about their transforma­tion wisely, with experienced personnel who are measured in their approach. But we've all heard of companies going dark when a cloud provider did the unthinkable and went down: Everything was great until it wasn't.

Columns - Emerging Technologies

Over the past 10 years we've seen a proliferation of non-re­lational database systems, usually based around a distributed, fault-tolerant architecture with flexible consistency models—databases such as DynamoDB, Cassandra, and Hadoop. However, in recent years, a new set of cloud-native, SQL-enabled databases have established significant traction.

MV Community

Entrinsik, Inc., a provider of intuitive business intelligence, achieved an outstanding 40 top rankings and overall best price to value of all 33 products analyzed in the BI & Analytics 2021 Survey. "The survey results for Informer are fantastic," said Doug Leupen, founder and CEO of Entrinsik. "Our customer first mindset is the key to our success, we put ourselves in their shoes and ask what do they need the software to accomplish, how can we make onboarding easy and what support will they need to be successful."

Revelation is releasing a "Roll Up" patch to OpenInsight version 9.4 that will enhance debug functionalities and improve operations.  This patch was made as a result of user reports and suggestions, said Mike Ruane, president and CEO of Revelation.

Zumasys is making several changes to AccuTerm 8 that will support enhanced MultiValue functions. Additionally, the company has revamped its licensing model for AccuTerm 8 to enable customers to purchase a single license key for the whole company.