Information Management News

Sponsors

Trend-Setting Products in Data and Information Management for 2024

Data continues to grow and is poised to double in 2024. To help make the process of identifying useful products and services easier, each year, DBTA presents a list of Trend-Setting Products. These products, platforms, and services range from long-established offerings that are evolving to meet the needs of their loyal constituents to breakthrough technologies that may only be in the early stages of adoption. Read More

Data Quality is Slipping, Latest Unisphere Research Report Finds

Data quality is becoming a hot button issue as more and more businesses aggressively move into artificial intelligence (AI)—both generative and operational—which requires massive amounts of accurate and timely data. The rise of large language models (LLMs)—both publicly available as well as contained within enterprises—to support business decision making and customer communications means data is being pressed into service in new and highly demanding ways as training data and real-time streaming feeds. Read More

What is Data Mesh?

Data mesh is still in its infancy, and data personas and organizations are craving clarity and specificity. It is critical to be aware of the "why" and "what" and fully understand the role that knowledge graphs play when considering adopting a data mesh strategy. Read More

President Biden Issues Executive Order to Create AI Regulations

U.S. President Joe Biden signed an ambitious executive order on artificial intelligence that aims to balance the needs of cutting-edge technology companies with national security and consumer rights, creating an early set of guardrails that could be fortified by legislation and global agreements. The order is an initial step that is meant to ensure that AI is trustworthy and helpful, rather than deceptive and destructive. The order—which will likely need to be augmented by congressional action—seeks to steer how AI is developed so that companies can profit without putting public safety in jeopardy. Read More

Newsletters


Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • The Rationality of Surrogate Keys The original intention of surrogate keys across multidimensional database designs was to help optimize joins by keeping all keys, used for joining between facts and dimensions, both numeric and single-columned. Often such surrogates were generated as simple sequential numbers, 1, 2, 3…. Early versions of many relational database products had sub-optimal performance when joining data together via character strings—especially large quantities of data.
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • How Many DBAs Do You Need? An age-old question when it comes to staffing a DBA group is how to determine the right number of DBAs required to keep your organization's databases online and operating efficiently. Many organizations try to operate with the minimal number of DBAs that they can. The general idea here is that the fewer staff members you hire, the lower overall cost will be. However, that assumption is probably not entirely true. An overworked DBA staff can make mistakes that cause downtime and operational problems far in excess of the salary requirements of an additional DBA.
Recent articles by Craig S. Mullins
Kevin Kline

SQL Server Drill Down

Kevin Kline

  • New Troubleshooting Capabilities in SQL Server and Azure SQL 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.
Recent articles by Kevin Kline
Guy Harrison

MongoDB Matters

Guy Harrison

  • Atlas Online Archive Balances Storage Costs with Performance I can't remember the first time a database or storage vendor told me, "Disk is cheap," but it was probably in the 1990s.  Vendors like to say disk is cheap because it helps them sell more of it and to encourage bigger deployments. The fact is that data storage is getting cheaper all the time. When I entered the business, one GB of storage cost about $1000. Today, it's more like 10 cents—10,000 times less!
Recent articles by Guy Harrison
Recent articles by  

Trends and Applications