Skip navigation.
Home

Lewis Cunningham

Syndicate content
Lewis Cunningham is an Oracle ACE Director, Oracle 11g Certified Professional (OCP), Oracle 11g Certified Data Warehouse Implementation Specialist, Database Architect and self-professed database geek. Lewis has almost 20 years of database experience. Follow along as he builds a working Oracle encyclopedia, sharing his knowledge and experiences, and describing ways to integrate that technology in various projects and business areas.
URL: http://it.toolbox.com/blogs/oracle-guide
Updated: 14 hours 48 min ago

OTN Interview on Youtube

Sun, 2013-03-17 06:34

Last week, I was interviewed by Bob Ruhbart of the Oracle OTN blog. He's also known as oracletechnet on twitter.

 

We discussed the cookbook I recently edited and a bit about

When to consider sharding a MySQL database

Wed, 2013-03-13 05:00

When to consider sharding a MySQL database

 

Why should you not just design your applications from the start to account for data sharding? Sharding a database, that is horizontally partitioning tables among multiple databases, creates an added level of complexity that is not desirable in an application. However, there are times when sharding is required to maintain acceptable performance. So when is the right time to shard your database?

 

The Three Major Areas of Difference Between MariaDB and MySQL

Mon, 2013-03-11 05:00

This entry and my next will be a little different from what I normally write. This info comes from some research I did recently into MySQL.

 

The Three Major Areas of Difference Between MariaDB and MySQL

 

An unresponsive web site is as good as asking your customers to leave. According to surveys, almost 50% of web users expect a page to load in less than 2 seconds, and 4

8 Steps for Source Control Perfection

Fri, 2013-03-08 05:15

Red

What's all the fuss about Big Data?

Wed, 2013-03-06 06:47

What’s all the fuss about Big Data?


Big Data is the collective term for very large and potentially complex data sets that are deemed to be so large that it’s difficult to handle the data using traditional tools and applications such as Relational Database Management Systems. Scientists in the fields of physics, genetics and meteorology were previous examples of those that encountered Big Data.

 

However,

Oracle ACE Cookbook

Tue, 2013-03-05 05:08
This is a FOOD cookbook, not a code cookbook.

Netbeans 7.3 Available

Mon, 2013-02-25 01:58
Are you a netbeanie?

First 750 Books and Reviews

Sat, 2013-02-16 06:01
So I started a new web site called First 750. A blog really. It's a site where writers can list their books, where I will be doing book reviews and where others can submit reviews. I have a few author interviews coming soon.

10 Signs that your project may be doomed

Thu, 2013-02-14 03:00
Version control is a USB stick and a guy named Sahib

Interview with Yalim Gerger (CEO Formspider - the PL/SQL Web Framework)

Tue, 2013-02-12 03:00
In every other profession having a 20 year experience is a good thing, in ours you are treated as a has-been who is kept around only to maintain the legacy system. This is insane.

Beyond The Fence

Sun, 2013-02-10 07:15

My house butts up against a park. It's an animal and bird preserve and there s a spring that feeds the Alifia river.

 

I was sitting on the back swing with my younger son and something started shaking the bushes on the other side of the fence.We got to joking around and I said it was probably an escaped monkey. My older son came out and we started making jokes and decided it was probably a goblin.

 

From that I decided to write a short story

Tables of the Heapish Variety - Tables 101

Wed, 2013-01-30 07:21

A table is the basic storage unit in an oracle database. A table stores the data that you think of when you think of a database.

 

A heap table is the default table type in Oracle. When we refer to a table, we are usually refering to a heap table. A heap table is just a table that stores the data in no partiuclar order. It just heaps the data on.

 

A heap table can be a relational table or an object table. A relational table is a t