Latest Oracle News

Latest SQL News

Latest IFS News

Case Studies

Market and Price Data Provider

Market and Price Data Provider – Oracle Advanced Replication Requirement

When our client needed a replicated database set-up to achieve good performance and data sharing across regions, Pro DBA’s Oracle Advanced Replication knowledge was called upon to design and implement a solution.

Challenging Business Requirements

Our client delivers commodity price data to clients, a time-sensitive service. To enable staff in different regions to work on the same data set without compromising performance, they needed three replicated databases (one in the USA and two in the EU). A prerequisite was that two databases would be in the cloud and one would be on-premise.

Pro DBA’s Solution

We designed a 3-way multimaster replication system using Oracle Advanced Replication on Oracle Database Enterprise Edition, logically grouping tables into multiple replication groups. This helped minimise the replication delay and maximised throughput.

We also implemented conflict resolution procedures for all replicated objects to avoid inconsistencies.

The Verdict

Changes are replicated across the client’s three sites in less than a minute.

The client is very happy, as we’ve improved system performance for staff in all regions, and also minimised data conflicts. Pro DBA continues to support the implemented solution on a 24/7 basis.

"What a great display on your skills!"

IT Director, Healthcare products company

"Have to say a big thanks to your teams for the support and works they have been providing. Both client and us are very pleased"

Senior Services Consultant, IT Services company

"Your out-of-hours DBA support is first class"

IT Manager, Derivatives Broker

"Pro DBA's service has always been excellent!"

IT Manager, UK University

"Many thanks for your help. Excellent, much appreciated!"

Head of IT Services, UK College

"I would like to thank Pro DBA for the professional work in setting up the databases. We would recommend your services and we are looking to using your company [more] in the future. We look forward to working with you again."

Senior Systems Engineer, Pharmaceuticals company

"We continue to be incredibly impressed by the Pro DBA service. We often hold you up to other suppliers of what good should feel like"

IT Director, Agronomy company

"Can you personally thank the Oracle team for me? We really do appreciate their expertise and advice"

Service Desk, IT Services provider

"I just wanted to pass on my thanks to Pro DBA for the support they give us. The team are fantastic to work with and are making us far more proactive"

Head of IT, Corporate Law firm

"Can I thank all your guys for their help this week? They have worked tirelessly to get these releases into the system"

IT Director, Automotive company

"I'm really impressed with the Pro DBA team, response times are amazing and very much appreciated"

IT Manager, UK Public Sector organisation

Thank you again for your help with the CRM SQL migration. I got really good feedback about how much you helped. I was really impressed by how you did not take any nonsense and gave the best solutions for the migration and supportability. It’s obvious you’re knowledgeable and passionate about your work and it has been a pleasure to have you as part of the project team.

Project Manager, Global Telecoms company

"Thank you for sorting this out, fantastic – I’ve just had a very happy client on the phone to say thanks"

IT Director, IT Services provider

"I just wanted to thank Pro DBA on our behalf. They’ve cracked our indexing problem resulting in a huge increase in performance. Well done, and thanks again."

IT Manager, Global Environmental Services provider

"We are very happy with the service you are providing"

IT Director, Healthcare products company

"Our system seems to be operating well on the new virtual server. Many thanks for your support. I have let our managers know we have received excellent service from you"

Business Analyst, Pharmaceuticals company

"Pro DBA are great!"

Chief Software Officer, Telecoms company

"10/10 for your consultant. His response time and knowledge has been right on point. I'm glad to have you guys on board, and brilliant timing!"

IT Manager, Metals and Mining company

"Your consultant is a legend!"

Head of IT, Investment Services company

"I just wanted to say that during my near 13 years here, it has been a pleasure dealing with all at Pro DBA. The support, guidance and willingness to help has always been at the highest level"

IT Manager, Global Telecoms company

"I really appreciate all the time and effort taken to make my visit and the upgrade operation from pre-upgrade tasks, during upgrade tasks, post upgrade tasks and upgrade performance issues pleasurable"

IT Manager, Sovereign wealth fund

"I had an urgent issue with one of my customers. I called the office directly and spoke with your consultant, who was extremely helpful and responded straight away. I wanted to highlight this to you as a positive first experience of using your services by myself and my customer"

Account Manager, Global ERP vendor

"Quick note, I’m always impressed with your service. Thanks again for everything you do."

CEO, London-based ISP

"You're worth your weight in gold!"

IT Sponsor, Agronomy company

"Thank you to you and your team for the fantastic job you have done in supporting us over the last week - it is much appreciated"

Director, NHS Trust