Database Administration

Something you wish you knew about databases before you jumped in head-first? Share your insights with our readers!

Just getting started with databases? Here's a rundown of the top things that I wish I knew before I got started in the field. These facts are guaranteed to make your life easier!

Looking for a definition of NOT NULL constraints? Find it in the About Databases glossary!

Looking for a definition of unique constraints in databases? Find one in the About Databases glossary!

What is Log Shipping? Find out in the About Databases glossary.

What is transactional replication? Find out in the About Databases glossary

What is snapshot replication? Find out in the About Databases Glossary

What is merge replication? Find out in the About Databases glossary!

Database management systems (or DBMSs) can be divided into two categories -- desktop databases and server databases. Generally speaking, desktop databases are oriented toward single-user applications and reside on standard personal computers (hence the term desktop). Server databases contain mechanisms to ensure the reliability and consistency of data and are geared toward multi-user applications.

You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's actually a simple matter of deciding what features you need and choosing a product that meets your requirements and doesn't cause too much pain in your pocketbook.

A database management system (DBMS) is the software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.

Looking for a definition of database concurrency? Find it here!

Looking for a definition of data definition language (DDL)? Find it here in the About Databases glossary.

Looking for a definition of data manipulation language (DML)? Find it here in the About Databases glossary.

Looking for a definition of a database instance? Look no further!

Glossary of database related terms from your About.com Guide to Databases

Desktop databases offer simple, flexible solutions for data storage and retrieval. They're often quite sufficient to meet uncomplicated database requirements for both small and large organizations. If you're not sure if a desktop database is right for you, try reading the Choosing a Database series of articles which cover both desktop and...

Oracle, SQL Server, Access, MySQL, DB2, Paradox. There's a vast world of database products on the market today. Which one is best suited for your enterprise? We'll guide you through the selection process.

Triggers may be used to automate common database actions. Learn how to apply them effectively!

Wondering what an object is in database terms? Find out here!

Confused by the world of databases? Looking for a concise description of how databases work? Look no further! This article introduces you to the wonderful world of databases.

This article from the Microsoft Knowledge Base provides a lesson on the concepts of database replication with a focus on Microsoft Access.