Menu  
 

Inbound Marketing Blog

Database Basics

Database seems to be one of those magical words that everyone can use and understand the main concept. “It’s where my stuff is stored,” is the most basic definition of a database, and most people don’t look too far beyond that. But, for those of you that are curious, here is a basic overview of how a Database works:

First, let’s break down the hierarchy for a database.

  • A database server contains many (dozens, hundreds, thousands) databases.
  • A database contains many tables.
  • Each table can consist of a few or lots of columns.
  • Rows populate a database, giving a value to each column in the respective table.

This is really much simpler than it sounds. Essentially, each table in a database is just a large Excel-like spreadsheet. Here is a visual representation to help you out: http://screencast.com/t/3yKOrVn0l

As you can see, each table within a Database has a significant amount of rows. This is the actual “data” part of the database. Each row has several “fields” which represent a piece of information that relates to the column it is in. For example, if we have a Table called Customers, we would expect it to have columns like Name, Address, Phone Number, Email, etc. Each one of those columns would be considered a field. In this table we could have rows filling out those fields, like so:

Name

Address

Phone Number

Email

Mike 313 Happy Lane 333-444-1121 mike@yahoo.com
Chris 131 Main Street 414-131-1111 chris@email.com
Jacob 442 North Trail 800-111-3313 jsmith@northtrail.com

 

Pretty simple, right? Now keep in mind, that this is the top-most level of the database. There are many, many other operations going on behind the scenes to actually organize and locate the data so that it can be presented in this neat grid layout. Things like indexes, keys, stored procedures, and many other features. But that is a topic for another day.

Enjoy.

Topics: Marketing

MINDSCAPE

Written by MINDSCAPE

We work with companies and organizations who want to get the most out of their digital marketing: more leads, more sales, more profit. Our success is measured by the hundreds of millions of dollars we help our clients generate each year.

Join the conversation

Subscribe to Email Updates

Let's Talk