Tag Archives: SQL

The Always-On Business Requires Oracle GoldenGate (OGG)

By Sandrine Riley-Oracle on Oct 05, 2016

“Always-on, data-driven, and real-time have truly become table stakes for enterprises in today’s global economy. The challenges for getting a consistent, up-to-date picture are compounded as enterprises embrace cloud deployments.” Tony Baer states it plainly.

To succeed in today’s competitive environment, you need real-time information – it really is that simple. This requires a platform that can unite information from disparate systems across your enterprise without compromising availability and performance. Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems. Oracle GoldenGate facilitates high-performance, low-impact data movement with low latency to a wide variety of databases and platforms while maintaining transaction integrity – and that is the key. With the help of Ovum’s Tony Baer, we have further explored how businesses value their data in this changing environment. Businesses need to continuously innovate, but execute at the same time. This whitepaper explores the realities of today, and those coming tomorrow. Real-time is crucial and an essential ingredient to driving key advances in everyday business.

Image result for Oracle GoldenGate

Read this newly released whitepaper for key insights into how:

  • Real-time is driving service-level expectations, even for offline workloads
  • With enterprises embracing hybrid cloud deployment, the need to keep data in sync, in real time between cloud and on-premise systems becomes table stakes
  • Real-time data integration is not simply a technology argument; it is essential to the ability to execute faster, which can lead to bottom-line cost reductions and top-line creation of new business and revenue opportunities
  • Supporting real-time business requires a data-replication technology that is flexible, scalable, performant, and platform-independent, with little to no overhead.

Tony interviews a handful of Oracle GoldenGate customers, and found valuable insights into the uniqueness and flexibility Oracle GoldenGate provides to today’s market.

To learn more about Real-Time Data Integration & Replication – Oracle GoldenGate – visit us here. This short video: Chalk Talk: Boost Big Data Solutions with Oracle GoldenGate might be of interest as well.

We hope you find this research exciting! Click for the WHITEPAPER.

Original Post

About the Author:

Sandrine Riley

Product Management – Data Integration Solutions at Oracle

Sandrine Riley

VIDEO: Resurrection of SQL with Big Data and Hadoop

Did you really think that SQL was going away? Attend this session to learn how SQL is a vital part of the next generation of data environments. Find out how you can use your existing SQL tools in the big data ecosystem.

Oz Basarir is the product manager of Embarcadero’s database management and development tools. Having worked over the last two decades with databases at a spectrum of companies as small as his own to as large as Oracle and SAP, he has an appreciation for diversity of the data ecosystems as well as for the tried-and-true languages (SQL).

Learn more about DBArtisan and try it free at http://embt.co/DBArtisan
Learn more about Rapid SQL and try it free at http://embt.co/RapidSQL

Resurrection of SQL with Big Data and Hadoop
by Oz Basarir – Embarcadero

Oz Basarir

See more Data U Conference session replays and download slides at http://embt.co/DBDataU

DB Optimizer – Database Performance and SQL Tuning

DB Optimizer – Database Performance and SQL Tuning

DB Optimizer is a database optimization tool that maximizes database and application performance, reliability, and availability by profiling, tuning, and load testing SQL code.

DB Optimizer – Introduction

Part 1 of 5 | 3 min 46 sec
Get started with a brief introduction to DB Optimizer’s features and capabilities, an overview of the GUI and how to get started by adding data sources.

DB Optimizer – SQL Editing

Part 2 of 5 | 1 min 29 sec
Take a look at the SQL editing capabilities in DB Optimizer’s IDE. Organize the result sets, scroll through value and rewrite queries.

DB Optimizer – Tuning

Part 3 of 5 | 10 min 24 sec
Learn how to use DB Optimizer to tune SQL. Generate cases and perform detailed analysis with visual cues to quickly optimize SQL code. Also, watch how Visual SQL Tuning gives DBAs an advantage when it comes to tuning!

DB Optimizer – Profiling

Part 4 of 5 | 5 min 16 sec
See DB Optimizer profile databases to quickly identify bottlenecks and other problem areas. This video shows how DBAs can capture profiling details, address wait times and report via XML files.

DB Optimizer – SQL Loading

Part 5 of 5 | 3 min 54 sec
Watch the demonstration around conducting load testing for performance optimization. Load testing helps makes sure any SQL code is able to handle the rigors of the most hectic database environments.