Database concepts and standards

These articles provide a basic background on concepts and standards for database management systems (DBMS). Many of these concepts apply to all forms of database management systems: relational (RDBMS), object (ODBMS), XML (XDBMS), and others as well as object-relational mapping and XML-mapping products. 

New articles will be added regularly. If you would like to be notified when new articles are available, add your name to our mail list.

Basic concepts for using a DBMS
ACID properties
Atomicity
Consistency
Isolation
Durability
Concurrency control and locking
Page locking
Cluster locking
Class or table locking
Object or instance locking
Database models
Object model concepts
Data Abstraction
Encapsulation
Inheritance
Relational model concepts
Comparing the object and relational models
Comparison of object and relational terminology
Comparison of object and relational concepts
DBMS standards
SQL-92
JDBC
SQLJ
SQLJ execution environment
Mapping SQL and Java data types
SQL:1999
ADO.NET
Java Data Objects (JDO)
JDO PersistenceManager
JDO identity models
JDO Query Language (JDOQL)
ODMG 3.0
Detailed comparison of ODMG 3.0 and JDO
Summary comparison of DBMS standards
Article suggestions

 

More articles on this site

Web Services articles
XML standards and vocabularies
Application server articles
Object database articles
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy

 

 

Copyright © 2000-2008 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.