Monthly Archives: December 2008

Upcoming Conference Schedule for 2009

I have recently been informed that several of my submissions have been accepted for presentation at theSoutheastern Oracle Users Conference and for Collaborate 2009 (IOUG).  As such, my 2009 conference schedule will include attendance and presentation of the following:

  • The Life of a Query (DBA/Developer Track)
    – Southeastern Oracle Users Conference–February 25-26, 2009
    – IOUG Collaborate 2009 (Session #399)–May 7, 2009

    Have you ever wondered what happens when you execute a query?  In this session, we’ll take a walk through the Life of an Oracle Query from beginning to end.  Not only does this help you better understand the various steps in the execution of your query, but it will also give you a good appreciation for the architecture of the Oracle Database server and, in particular, of the query optimizer.  You will gain valuable information that will allow you to solve performance issues and write more efficient queries going forward.  Additionally, I will share some of my insights into the Oracle optimizer as we move through this discussion.  This discussion is also a great refresher for those of you familiar with Oracle concepts and architecture.
  • Database Benchmarking: Methodologies, Tools, and Techniques (DBA/Developer Track)
    – Southeastern Oracle Users Conference–February 25-26, 2009
    – IOUG Collaborate 2009 
    (Session #107)–May 4, 2009
    While we’re all familiar with the term benchmarketing, how do you tell fact from fiction? Planning and performing a proper, accurate, and scientific database benchmark isn’t always easy. And, while database benchmarks are performed for many different reasons, this session would cover the proper techniques, methodologies, and tools for performing the most common database benchmarking scenarios: hardware configuration comparison, database release comparison, and internal application benchmarking. Tools covered will include the Oracle Linux Test Suite (OLT), Real Application Testing, and Quest Software’s Benchmark Factory.
  • Introducing the Oracle Call Interface (Developer Track)
    – IOUG Collaborate 2009 (Session #537)–May 6, 2009
    Often overlooked, the Oracle Call Interface (OCI) has long-since been a high performance, low-level data access API for Oracle. Unfortunately, many people shy away from using OCI simply because of its perceived complexity. However, this session will illustrate that anyone with a little knowledge of C can harness the power of OCI in their own applications. It will also demonstrate two of the most popular OCI wrapper libraries for those who just want to get their feet wet.

I’m also submitting several presentations to New York Oracle Users Group’s Spring General Meeting, and will hopefully be seeing some of you there again.

SibylNet, Oracle/Postgres Benchmark, Password Cracker for Oracle, Storage Engines…

It’s been quite awhile since I last wrote a blog entry. For that, I apologize. I’ve been extremely busy at work and haven’t been able to spend much time on Oracle stuff lately. Regardless, this is what I’ve been up to and what you can expect to see soon.

SibylNet & Unofficial Specification of the Oracle Network Protocol

Oracle has given me permission to proceed with releasing my open source client software for Oracle, SibylNet. As such, I’ve been combining all of my past research into a single protocol specification and client library which I hope to release in Q1 2009.

Oracle vs. Postgres Benchmark

To end a long-running dispute I’ve had with the Postgres community regarding over-reliance on the operating system to achieve good database performance, I’ve performed a comparison benchmark between Oracle8i Standard Edition (circa 1999) and Postgres 8.3/8.4-dev (the latest version) on the exact same hardware. The results may or may not surprise you.

A Fast Password Cracker for Oracle

Years ago I had written a password cracker for Oracle8i/9i, but had given up on it. Though, after playing with Laszlo Toth’s woraauthbf awhile back, I decided to update mine to take full advantage of newer multi-core systems. After a bit of redesign, it now makes use of multi-threaded parallel processing, lock-free/nearly-wait-free cache-optimized hash tables, and atomic locking. I now believe I have the world’s fastest password cracker for Oracle… but I’ll leave that to others to test. I’m currently getting this re-ported to Windows and after letting a few select people test it, will release it as open source.

A three-part series of articles pertaining to database frontends for custom storage engines

In today’s business environment, most companies prefer to buy software rather than build it. However, over the past year and a half, I’ve been approached by three different companies looking for a good database frontend with which they could integrate their own internally-developed storage engines. As each of these companies ran into several of the same issues, I thought that this topic would make for a good series of articles not only for those generally interested in databases, but specifically those who may find themselves in the same situation. The three articles (and products mentioned) are as follows:

  • Just What the Doctor Ordered (Dr. DeeBee Driver Kit)
  • Swimming with the Dolphin (MySQL)
  • An Elephant in the Room (Postgres)