The Database Knowledgebase on the Web

KNOWLEDGEBASE:

SQL

Oracle

MySQL

Postgres 

General topics 

Glossary 

Glossary

Select a letter to browse the glossary. You may also enter a search phrase in the Google search box below to search the entire site.

0 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z


Michael Stonebraker - Michael Stonebraker is a well known database guru having started Ingres and Postgres while at UC Berkeley. He's also commercialized Ingres, Illustra and now Vertica. He's also won a boatload of awards from various groups like IEEE & ACM. The short story is that he has an interesting and significant background.

Schema - A set of related database objects. An HR schema would store personnel and payroll information; a GL schema would store the chart of accounts, etc.

SQL Analytics - SQL Analytic Functions are a series of SQL functions introduced by Oracle in Oracle Database Server 8i. Analytic functions allow a query writer to aggregate data across a series of partitions in the data. Each function may be partitioned by a different set of criteria. Each row of a result set returns the aggregate for all partitions within the functions view.

Surrogate Key - A surrogate key is a sequential number that is meaningless. In oracle it's usually created by a sequence.

Contact: Lewis Cunningham
lewisc@databasewisdom.com

About us

Contact us

Support us

Authors, Share Your Book with Millions of Readers

Search Database Wisdom