DBTA E-EDITION
August 2019

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

While IT has evolved significantly in the past decade as hardware and software innovations accelerate and customers seek solutions that increase efficiencies and lower costs, one aspect has remained the same: backup. And as the dependence on data grows for business insights and analytics, backup will only become more important in IT.

As access to data and data sources continues to explode, businesses are being forced to rethink their data strategies to consider more information and power real-time intelligent decisions. That is, however, easier said than done. With the amount of data available that is pouring in from a myriad of sources, it can be difficult to identify what provides value, and what is just noise. Increased data and cloud growth has led to data integration challenges.

We've reached the point where hybrid cloud arrangements have become commonplace in enterprises, and with this trend come implications for databases and data management. The rise of both hybrid and multi-cloud platforms means data needs to be managed in new ways, industry experts point out. And, there are lingering questions about which data should go into the cloud, and which should stay on-premise.

No single tool can ensure perfect security. That's why layering multiple tools and approaches is considered a best practice to reduce vulnerability to attacks. It has become more apparent in recent years that management tools form a vital security layer. Think of it this way: A window lock is a security tool. Closing the windows is management. Neither is enough by itself.

With the emergence of data-intensive activities such AI and the Internet of Things, workloads are getting heavier for data managers. Data managers have seen increases in data volume over the last 3 years and expect this trend to continue. They are also finding it difficult to keep up with this growth. Many DBAs manage more than 10 databases, with some handling hundreds.

"Hey Google, what's the cost of noncompliance?" Failing to comply can cost you $56.8 million—the dollar figure Google owes for breaking the EU's General Data Protection Regulation (GDPR). While this multi-million dollar mistake delivers a hit to the tech giant's reputation and checkbook, it has far-reaching implications for any organization with an online presence.


Columns - Database Elaborations

An effective approach to processing and transforming large datasets is likely comprised of multiple steps. The large data will likely be split apart into several smaller sets, maybe even in a couple of differing fashions with a common and understandable theme. But there should not be too many split-apart variants; rather, as with the three bears, it should be just the right number of smaller datasets. And then, similar to solving a Rubik's Cube, a twist or two at the very end brings all the new and old datapoints together in a complete and organized fashion.


Columns - DBA Corner

Unless you've been living in a cave somewhere, you've certainly heard news about stolen and hacked data, commonly referred to as data breaches. They occur with great regularity, and there is no indication that the frequency of data breaches is slowing down. Organizations must take more aggressive actions to prevent the sensitive information in their care from being stolen and abused.


Columns - Quest IOUG Database & Technology Insights

In previous articles, we looked at creating and managing Oracle Cloud Infrastructure (OCI) database and compute instances through the web UI. The UI is ideal for a new user and occasional management of a cloud environment. When a cloud administrator is managing and automating dozens or hundreds of instances, manually clicking through the UI becomes untenable. Oracle supports and maintains a number of developer tools to solve this problem.


Columns - SQL Server Drill Down

Maybe you are still getting up-to-speed with the whole concept of cloud computing. If so, I have a lot of sympathy for you because there is so much to learn and because cloud technologies advance so rapidly. Here's one more important concept to add to that pile of things to learn—edge computing.


Columns - Next-Gen Data Management

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when it comes to optimizing and tuning your SQL Server database performance.


Columns - Emerging Technologies

After almost a generation of relative stability, database technology has been rocked over the past decade by two megatrends—the end of the one-size-fits-all RDBMS model and the rise of cloud computing.


MV Community

Revelation is known for its OpenInsight NoSQL MultiValue database development suite that provides Windows, Web 2.0, and .NET tools to develop and deploy mission-critical applications. In addition to OpenInsight 10, Revelation offers OpenInsight for Web (O4W) which is a rapid web application development tool that lets users generate responsive forms, reports, and dashboards.

Established in 1875, Heritage Bank is Australia's largest customer-owned bank with 60 branches in Queensland and broker distribution staff in Brisbane, Sydney, and Melbourne. The Rocket MultiValue Application Platform makes it easy to manage data, regardless of structure, without requiring expensive DBA support.

Zumasys, a provider of NoSQL databases for business-critical Pick applications, is collaborating with ONgroup to release new Pick MultiValue developer extensions for Visual Studio Code, the free open-source editor created by Microsoft for Windows, Linux and macOS. Committed to bringing new developers into MultiValue, ONgroup, and Zumasys hope to enrich the community and improve the development experience for both seasoned Pick veterans and for the next generation of MultiValue programmers.

Sponsors