Tag: database

Performance

Using MySQL 5.7 Generated Columns to Increase Query Performance

  In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance. Introduction About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been one of my favorite features in the MySQL 5.7 release. The reason …

Miscellaneous

Three Ways To Energize Your DBA Career In The Cloud

  Today we have a guest blog from Jeff Erickson, Director of Content Strategy at Oracle. It’s no secret that data is the new black gold—a source of wealth creation on par with financial capital, say some. So it’s a little ironic that a group of people who understand better than anyone how to manage …

Miscellaneous

The Rise of the Renaissance Database Administrator

  Today, I wanted to share, via our blog, a portion of our new whitepaper entitled “The Rise of the Renaissance Database Administrator: Cloud Opens Up New Career Vistas”.  For the complete whitepaper please download the asset in the resource section at the end of the blog. Introduction What do these market-defining trends have in …

Miscellaneous

Big Data at UPS. Interview with Jack Levis

  Today we have a guest blog interview featuring Roberto V. Zicari, editor of ODBMS.ORG (www.odbms.org). ODBMS.ORG is designed to meet the fast-growing need for resources focusing on Big Data, Data Science, Analytical Data Platforms, Scalable Cloud platforms, NewSQL databases, NoSQL datastores, In-Memory Databases, and new approaches to concurrency control.  In this blog Roberto interviews …

Miscellaneous

Storing JSON data in the Oracle database

In this posting  you learn how to: Store JSON data in the Oracle Database Pick a good data type for your JSON data Identify rows and columns  that contain JSON data Ensure that only JSON data can be inserted into a table Find all columns that store JSON data Prerequisites: You need the Oracle Database …

Miscellaneous

Forecast the Cost Benefits of Oracle Database Cloud Service with the New TCO Calculator

  When looking to migrate a workload to the cloud, one of the first business challenges can be quantifying the business value of the proposed move to the cloud. Many organizations are looking for tools that will help them build the business case for their management.  Oracle’s Data Management Cloud Services team has recently launched …

Miscellaneous

Oracle Ask TOM Office Hours Now Live!

  Hundreds of thousands of companies around the world rely on Oracle Database to power their mission-critical applications. Millions of developers and administrators rely on the Oracle Database dev team to provide them with the tools and knowledge they need to succeed. AskTOM Office Hours continues the pioneering tradition of Ask TOM. Launched in 2000 …

Miscellaneous

Why Move SAP Applications to Oracle Cloud?

  Today we have guest blogger, Bertrand Matthelie, Senior Principal Product Marketing Director, providing us with insights into the value of migrating your SAP applications to Oracle Cloud. SAP NetWeaver-based applications have last year been certified on Oracle Cloud Infrastructure. NetWeaver-based applications represent most of the deployed SAP applications, and the majority of them are powered …

Miscellaneous

Using Real Memory to Enhance Performance in Db2

As many enterprise applications mature, the increases in customers, functions, features and transaction rates require scaling up. Several alternatives for maintaining acceptable performance include installing or upgrading hardware resources such as CPU speeds, disk volume and computer memory. Of these, adding memory can sometimes be the cheapest and most convenient. In this article we review …

Miscellaneous, Software

Enhanced replication monitoring in ProxySQL 1.4.4

ProxySQL and pt-heartbeat The Percona toolkit provides a very useful script for more accurate replication lag monitoring called pt-heartbeat. The pt-heartbeat script provides replication lag metrics based on actual data that has been replicated and is more accurate than the Seconds_Behind_Master metrics gathered from the output of SHOW SLAVE STATUS. Seconds_Behind_Master relies purely on system …