GeekInterview Learning Series

SQL Programming

Wed, 07 May 2008 06:56:06 -0400

SQL Programming Overview Anybody who has done something for a long time has probably wanted to change how things work at some point or another. A worker at a mill might have found a more efficient way of cutting logs, or a mathematics teacher might have had a hand in changing a school’s algebra curriculum. SQL lets you change how things work, too, with stored procedures. Essentially, a
Submitted by admin Category: Database

Distributed Databases

Mon, 05 May 2008 11:48:21 -0400

Distributed Databases Overview Suppose you created a database for a web application a few years ago. It started with a handful of users but steadily grew, and now its growth is far outpacing the server’s relatively limited resources. You could upgrade the server, but that would only stem the effects of the growth for a year or two. Also, now that you have thousands of users, you are worried
Submitted by admin Category: Database

Database Concurrency and Reliability

Mon, 05 May 2008 11:48:17 -0400

Database Concurrency and Reliability Overview Concurrency and reliability have long been “hot topics” of discussion among developers and users of distributed systems. The fundamental problem can be seen in a simple example, as follows. Suppose two users are working on the same part of a database at the same time. They both UPDATE the same row in the same table, but they provide di
Submitted by admin Category: Database

Relational Databases

Fri, 02 May 2008 21:19:08 -0400

What is a Relational Database? Popular, modern databases are built on top of an idea called “relational algebra”, which defines how “relations” (e.g. tables and sequences in databases) interact within the entire “set” of relations. This set of relations includes all the relations in a single database. Knowing how to use relational algebra is not particularl
Submitted by admin Category: Database

SQL Keys

Wed, 30 Apr 2008 04:50:59 -0400

SQL Keys Overview In SQL, keys are used to maintain referential integrity among relations. Put simply, this means keys allow tables to reference each other, and each reference will be “correct” every time. Referential integrity also prevents records from being “dangled” or “orphaned” by another record that has been deleted. Primary Keys and Foreign Keys: Th
Submitted by admin Category: Database

SQL Table Commands

Sun, 27 Apr 2008 07:19:37 -0400

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The “columns and rows” structure of the table allows data to be efficiently inserted, manipulated, updated, and deleted from the database. The three most important commands used to work with tables, CREATE TABLE, ALTER TABLE, and DROP TABLE, are covered in th
Submitted by admin Category: Database

SQL Overview

Thu, 24 Apr 2008 17:16:29 -0400

SQL Overview The SELECT command in SQL provides a robust means for retrieving data from a database. More specifically, SELECT returns a result set of zero or more rows from the database, and this result set corresponds to the query that was executed. The result set is calculated by the query optimizer inside the database system, based on the information inside the database. SELECT operates on bas
Submitted by admin Category: Database

Getting Ahead with Databases

Wed, 23 Apr 2008 17:44:46 -0400

Database Overview You have been using databases for a few years, and you think you are at the top of your game. Or, perhaps, you have been interested in databases for a while, and you think you did like to pursue a career using them, but you do not know where to start. What is the next step in terms of finding more rewarding education and employment? There are two routes people normally take
Submitted by admin Category: Database

Database Interaction

Sat, 19 Apr 2008 09:34:03 -0400

Database Interaction Overview Efficient interaction, efficient storage, and efficient processing are the three key properties of a successful database platform. In this article, we explore the first: efficient interaction. Interaction Category 1: Command Line Clients Many database platforms are shipped with a simple command line utility that allows the user to interact with the database. Postg
Submitted by admin Category: Database

SQL Standardization

Fri, 04 Apr 2008 17:44:02 -0400

Like any technology that strives to be interoperable among different implementations, SQL has been standardized. The first SQL standard was adopted and published by the American National Standards Institute (ANSI) in 1986. The standard was further ratified by the International Organization for Standardization (ISO) in 1987, and ISO continues to be the primary international standardization body for
Submitted by admin Category: Database