databases

Preface PL/SQL is one of the top twenty programming languages in the world. While I’m no Matthew Symonds, and this is no Softwar, the history of PL/SQL deserves a helluva lot more than, “Oracle 7 had an advanced architecture and, like Sybase, was fully programmable via its elegant new PL/SQL programming language.” That’s why, during the process working on […]

The post A (Not So) Brief But (Very) Accurate History of PL/SQL appeared first on Oracle Internals.

Preface PL/SQL is one of the top twenty programming languages in the world. While I’m no Matthew Symonds, and this is no Softwar, the history of PL/SQL deserves a helluva lot more than, “Oracle 7 had an advanced architecture and, like Sybase, was fully programmable via its elegant new PL/SQL programming language.” That’s why, during the process working on […]

The post A (Not So) Brief But (Very) Accurate History of PL/SQL appeared first on Oracle Internals.

I’ve received a few questions in regard to the state of my company, NEXTGRES, and why the site now only contains a terse reference to the Janus Database Compatibility System. While it’s not specifically related to Oracle Database internals, as it’s been discussed on my blog and Twitter for many years, here’s an update. MisconceptionsOver […]

The post What happened to NEXTGRES? appeared first on Oracle Internals.

I’ve received a few questions in regard to the state of my company, NEXTGRES, and why the site now only contains a terse reference to the Janus Database Compatibility System. While it’s not specifically related to Oracle Database internals, as it’s been discussed on my blog and Twitter for many years, here’s an update. MisconceptionsOver […]

The post What happened to NEXTGRES? appeared first on Oracle Internals.

Many people these days don’t know InnoDB was originally developed as an independent database engine apart from MySQL. Its author, Heikki Tuuri, modeled InnoDB after Transaction Processing: Concepts and Techniques, the seminal transaction processing book authored by Turing Award laureate James “Jim” Gray and Andreas Reuter. It wasn’t until later InnoDB was integrated with MySQL. While InnoDB […]

The post Revisiting Embedded InnoDB appeared first on Oracle Internals.

Many people these days don’t know InnoDB was originally developed as an independent database engine apart from MySQL. Its author, Heikki Tuuri, modeled InnoDB after Transaction Processing: Concepts and Techniques, the seminal transaction processing book authored by Turing Award laureate James “Jim” Gray and Andreas Reuter. It wasn’t until later InnoDB was integrated with MySQL. While InnoDB […]

The post Revisiting Embedded InnoDB appeared first on Oracle Internals.

There’s something for having job security and many of the solutions that I see offered for RDBMS challenges offer just that. With compliance with EU’s GDPR, (General Data Protection Regulations) just around the corner, (mark you calendar, May 25, 2018) you’d think we’d all be scrambling for a simpler solution to discovering and addressing all that GDPR data.

Quick refresher for those of you going, “What is GDPR?”

Data security is a known focus of GDPR when you talk to folks, but it’s much more than just security.  It’s about extended rights of the individual in the EU. There’s four areas as a DBA, you need to really concern yourself with: