Blog - comments

Hi goog article can we install avdf firewall with flat network if it's possible please let me know ?

Thilina
First, thank you for your interrest in this blog.Yes, the byte code will be interpreted each time bu...
BIEHLER Stephane
Pretty sure this is wrong:> already said that JVMs interprets the generated byte code - that's true...
Gs
Michael, great article, however, I would disagree on DRS/Host Affinity. You are legally only requir...
David Bradshaw
Hi lauri, db_file_multiblock_read_count is still used in exadata smartscan because it defines the si...
Blog Nicolas Jardot Oracle Open World 2013: Final day - Database as a service and replication fundamentals

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

Oracle Open World 2013: Final day - Database as a service and replication fundamentals

My final day at Oracle OpenWorld 2013, less sessions and less people but still a big day after almost one week in San Francisco. In this blog I'll focus on the private cloud with databases as service and the fundamentals about replication. To conclude on Oracle OpenWorld, I would say that there are three big news - more on these at the end of this posting.

On Thursday, there are less people in the sessions and there is a reason: on Wednesday, everyone was invited on Treasure Island for 2 concerts. And with famous bands: Maroon 5 and the Black Keys.

b2ap3_thumbnail_OOW_concerts.JPG

Each day showed that OpenWorld is a really big event, but let's start with the interesting concept of private cloud.

 

Database as a Service

In a "hands on lab" session with Mark Scardina, Director of Quality of Service Management at Oracle, we had 2.5 hours to test Real Application Cluster with 2 features to insure service distribution:

  1. QoS management Policy
  2. Policy-managed Database

Those features are not completely new because those have been introduced in 11.2. But if we combine services and consolidation with the multitenant option, we have a kind of private cloud with databases distributed to the applications as services.

The goal was to show how to create a QoS policy to ensure the priorities between the services and meet the SLAs. With a policy-managed database and a defined QoS management policy, it's easy to give some service a higher priority, then all services are monitored and in a Dashboard, Enterprise Manager gives us advices to keep the performance defined in QoS policy.

Speakers told also a little about Application Continuity. That 12c feature added to the others, application should always be running whatever happens on a specific node if there is still another node to handle the service.

 

Replication fundamentals

The speaker was Arjen Visser, founder of Dbvisit software. There are two replication concepts: physical and logical and he focused on the logical replication principles. He was explaining how products like GoldenGate or Dbvisit Replicate work.

Unlike physical replication where all blocks are identical, logical replication consists in having the same data but on a totally independent database. It's quite often used for reporting purposes whereas physical replication is used for Disaster and Recovery.

There are 3 kew concepts to enable logical replication:

  1. Conversion: DML statements have to be catched on source database and converted into row-by-row operations. It's because the products don't have a way to get SQL statements but only the changes from in redo logs.
  2. Identification: Following the first principle, each operation should affect one row so each row in a table has to be identified uniquely.
  3. Conflict: If an operation changes 0 row or more than 1 rows, the synchronization between source and target is compromised. The replication product has to have a mechanism to detect, handle the conflits

 

Conclusion

I noticed that Oracle keeps the strategy of engineered systems, they can provide the full stack from the hardware to the software with machines tuned to run Oracle databases. Several appliances were available on demo during that week. Using such solutions also allows a full management in Enterprise Manager 12c that would be the only place to manage the entire infrastructure.

It seems we are in a cycle, from mainframe to servers and we may be in a way to go again in kind of mainframe where the machines including the processors (software on chips) are designed to run certified software.

But finally, there are 3 big news in that OpenWorld:

  1. Oracle Database and Java available in Windows Azure
  2. Oracle Database and Java available in Oracle's public cloud
  3. New In-Memory option. I really hope that I'll be able to test it soon.
Rate this blog entry:
2

Nicolas Jardot has more than two years of experience in Oracle database management and Microsoft application development. He is specialized in Oracle tuning as well as in the Oracle Optimizer. Nicolas Jardot perfectly masters the behavior of the Oracle Optimizer, holding speeches on the topic at the Oracle OpenWorld 2013 and the UKOUG 2013. He is also specialized in C++ development and masters the programming of requests in SQL language. Nicolas Jardot has a solid experience in the virtualization and centralization of applications. He has developed several PL/SQL packages aimed to simplify the administration of database applications and maintains the DMK_SQL package of dbi services' Database Management Kit. Nicolas Jardot is Oracle Certified Professional 11g (OCP 11g) and ITIL Foundation V3 certified. He holds an Engineer's Degree in Computer Science from the University of Technology of Belfort-Montbéliard (F). His branch-related experience covers Pharma, Public Sector, Health, Real Estate, Automotive, etc.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Sunday, 26 October 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter