What I Wish I Knew About Databases
Something you wish you knew about databases before you jumped in head-first? Share your insights with our readers!
Top Things Beginners Need to Know About Databases
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!
NOT NULL Constraints
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
Snapshot Replication Definition
What is snapshot replication? Find out in the About Databases Glossary
What is merge replication? Find out in the About Databases glossary!
Choosing a Database for Your Organization
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.
Database Software Options
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.
Database Management System
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!
Data Definition Language
Looking for a definition of data definition language (DDL)? Find it here in the About Databases glossary.
Data Manipulation Language Definition
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
Top 5 Desktop 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...
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.
What is Database Replication?
This article from the Microsoft Knowledge Base provides a lesson on the concepts of database replication with a focus on Microsoft Access.
Verifying Credit Card Numbers with the Luhn Algorithm
All valid credit card numbers are creating using an internal checksum that helps merchants quickly determine if a card number contains typographical errors. This checksum appears as the last digit of the credit card number and is calculated using a process known as the Luhn algorithm. In this article, we examine how the Luhn algorithm works so that database developers may use it to perform a cursory inspection of credit card numbers.