Database administration is a complex, often thankless chore. The collection of links on this page will help you keep your DBMS humming along at peak performance
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 server databases in depth
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.
Craig Mullins' article provides a concise definition of the terms associated with measuring database performance. These concepts are central to the development of a database performance plan.
This lengthy article offers a comprehensive look at designing a database disaster recovery plan. A Microsoft Word disaster recovery plan template is available for download.
Confused about Enterprise Java Beans? Chris Kempster's article provides an introduction for Oracle database administrators.
Orac provides a suite of database administration tools for users of Oracle, Sybase and Informix products. This freeware program is distributed under the GNU Public License.
This article from the Microsoft Knowledge Base provides a lesson on the concepts of database replication with a focus on Microsoft Access.
