Subscribe to the DBTA E-Edition email newsletter

April 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

It's no secret that businesses have become more data-driven in recent years, with powerful big data analytics increasingly deliv­ering on the promise of adding business value. As a result, the quality and enrichment of data have become top priorities for business leaders on a global scale. In fact, according to a recent survey of chief data officers, 88% have started building auto­mation into their data management processes to help manage data quality.

As everyone pushes for real-time analytics, more responsive online services, and more protection against cybercrime, data resiliency has moved front and center. Put simply, data must be available at all times. This requires a shift in con­ventional thinking toward data resiliency strategies in rec­ognition of the fact that it is no longer a technical issue; it's a business issue.

It is well known that a database is the fundamental building block for any data-based initiative. Databases are used when collecting, storing, processing, and analyzing data. A database is the silent component that drives business decisions and operational improvements or simply keeps track of inventory. As much as the database should be the almost invisible part of these processes, it is crucial to make the right choice. While it might look easy to select a suitable database, there are a few things to evaluate when making a decision.

Enterprises are just scratching the sur­face of data-driven opportunities, and many simply aren't ready to leverage their data assets to lead their markets. There are concerns about the security of sharing data between organizations, as well as iden­tifying and building platforms to accomplish a data-driven infrastructure. These concerns may abate as data-driven partner ecosystems and benefits develop. 

Columns - Database Elaborations

Data architects live in a world caged by bars of process, standards, and documented procedures—things many would consider a high ceremony lifestyle. As an industry, information technology has been migrating more and more into agile frameworks for some time now. High ceremony is often seen as an earmark of "waterfall" approaches, which constitute the evil empire that agile frameworks are fighting to replace. The result of this opposition is that formal data architecture groups often do not fold easily into agile approaches.

Columns - DBA Corner

Data privacy regulations—coupled with the desire to pro­tect sensitive data—impose requirements on organizations to protect production data. Since many organizations rely on pro­duction data as a source for test data, techniques are needed to mask sensitive data elements from unauthorized viewing.

Columns - Quest IOUG Database & Technology Insights

Are you a developer who is using Oracle Database and is interested in learning more about Oracle Real Application Clusters (RAC)? At Quest's INSYNC conference, Anil Nair, prod­uct manager at Oracle, presented "A Developer's Guide to Oracle RAC." The session covered tips and tricks to ensure that develop­ers can benefit from features such as session failover and load balancing with minimal effort.

Columns - SQL Server Drill Down

Database applications have vastly improved in recent years, but despite our best efforts, they can still feel frustratingly slow. A report that is supposed to take minutes might instead (for unknown reasons) take 2 hours. Corporate teams complain that every time they work with the database, it gums up the works, leaving users grumpy and managers suspicious. This is no small matter. According to the SolarWinds Query Report 2021, nearly one-third of data pros sur­veyed manage more than 300 databases in their organization's environment.

Columns - Emerging Technologies

Although IPFS—the so-called Interplanetary File System— has far less name recognition than blockchain, it represents one of the essential technologies underlying the current boom in NFTs (non-fungible tokens).