Patrick Barel

Get your money’s worth out of your Database

Patrick Barel
Qualogy

The database is one of the most important assets to your application. Besides being one of the most important assets it is also one of the most expensive parts in your application. Most organizations don’t get the most out of their database license and treat it like a simple bit bucket. The modern Oracle database can do so much more than just store data.

Features you can use ‘in the database’ include:

  • Flashback queries (what did my data look like at a certain moment in time)
  • Data Security (only read and write data you are authorized for)
  • Performance increase (Set based operations, regular expressions, analytics)
  • EBR (near zero downtime application upgrades or support for parallel database worlds)
  • Data integrity/quality (Single Point Of Data Integrity)
  • Special SQL features like paginating your result.
This presentation will show these features as well as some of the enhancements in the Oracle 12c Database including:
  • Identity columns (12c)
  • Invisible columns (12c)
  • Whitelisting PL/SQL program units (12c)
  • Improvement of execution of PL/SQL in a SQL query (12c)
  • Cross session Result cache (both SQL and PL/SQL) (11g)


Informacije o predavanju / Information

Jezik / Language: ENG


O Avtorju / About author

Patrick Barel is a PL/SQL Developer for Qualogy in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins for PL/SQL Developer. He publishes articles on his own blog. In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019 he has been promoted to ACE Director.
  • # Oracle
  • # PLSQL