October 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

Digital transformation. Infrastructure modernization. Global data center demands. All these forces and more are driving enterprises around the world to seek out next generation cloud-based technologies for a wide range of applications—even those most critical to their business. In reality, however, migrating to the cloud or any other modern architecture is not as easy as it sounds.  

As more companies continue to rely on interconnected networks, virtualized cloud services, and IoT technologies, the potential for downtime and its costs will only rise. By achieving true network resilience, companies can focus on maintaining their services, removing single points of failure and having a plan to bring the network back up to continue normal operations—before it costs them.

Data continues to grow in volume, variety, and velocity, resulting in new data management technologies. Recently, Deepti Srivastava, product manager for Cloud Spanner at Google Cloud, discussed how database requirements are evolving and how Google's Cloud Spanner is advancing a relational-NoSQL-convergence approach by giving customers the combined benefits of relational database structure with non-relational horizontal scale.

Oracle has identified a need for "augmented" analytics, leveraging machine learning and AI throughout the analytics process to help drive up the impact and value of data, and enable knowledge workers to uncover more insights. Recently, Bruno Aziza, group VP, Oracle Analytics, described this new phase in analytics, the role that cloud plays in making it possible, and what the capabilities will enable for customers.

DevOps is now widely accepted in application development because, by introducing a culture of collaboration and cooperation between development and operations teams, it enables features to be released faster to end users. As DevOps grows, there is a corresponding need to ensure the database is included so that the entire development process is seamless and free of bottlenecks.

Columns - Database Elaborations

Certain kinds of issues in data modeling need to be addressed in specific ways. Many options may exist, but it is very rare for all the possible choices to be equally appropriate. The reasons for using a less-than-satisfactory path may be many. They may include a misguided concern for speed-to-completion or be a matter of the areas of control for those "in the loop" on the existence of the issue. Largely, this involves communication or, more precisely, the lack of communication.

Columns - DBA Corner

A "best practice" is a professional procedure or tactic that is accepted or prescribed as being correct or most effective. Take a moment to think about the things that you do, or want to do, on a daily basis to manage your database infrastructure. What are the main categories of "things" that you want to tackle with best practices?

Columns - Quest IOUG Database & Technology Insights

As the name implies, Object Storage is OCI's cloud object store and is comparable to Amazon's S3 storage service or Microsoft's Azure Storage. Object Storage can be accessed through myriad interfaces and tools including the OCI web portal, a command-line interface, a REST API, an Amazon S3-compatible API, a Swift API, and a number of SDKs. This article will be limited to using the web portal and the Swift API, which is used by Oracle Recovery Manager (RMAN) to interact with the Object Storage service.

Columns - SQL Server Drill Down

Back in the 1980s, a Stanford University computer scientist and professor named Donald Knuth introduced the concept of "literate programming," in which a computer program's logic is explained in a natural language such as English. The "literate" program would be further enriched with images, graphs, traditional source code, related macros, and scripts almost as if the programmer were writing an essay, and using all of these components together could still be compiled as usual. The most notable products to arise from this concept were notebooks, such as Azure Notebooks, Jupyter Notebooks, Apache Zeppelin, and the Apache Spark Notebook.

Columns - Next-Gen Data Management

Hard skills, while still valuable, are only part of the necessary skill set to be successful as a data professional. But hard skills have a ceiling. Hard skills can be replaced. Soft skills have no ceiling and offer more value than many hard skills.

Columns - Emerging Technologies

Regardless of its long-term prospects, Hadoop remains a pivotal technology in the history of databases. Hadoop was one of the key technologies that broke the stranglehold of relational databases, and it forced a shift in the way in which we think about and store data.

MV Community

Revelation is adding enhancements to its OpenInsight platform, enabling performance improvements across the solution. OpenInsight now provides an option to change the precision of mathematical operations. OpenInsight's RLIST functionality and performance have also been improved starting with the 10.0.7 release.The MultiValue BFS (MVBFS) connections for QM, D3, and U2 have been enhanced to submit multiple select lists to the "back end" host for bulk processing whenever possible.

Zumasys is updating the AccuTerm platform with security upgrades, a new UI, and the ability to run the platform through a web browser. AccuTerm8 features dozens of new features that give users access to their PICK system when and where they need it.