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

 

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.

Search this site for more articles

Custom Search

Browse this site for more articles

Click on the topics below to browse the articles on this site.The arrows show the path to the current article: Database concepts and standards.

Web Services and Service-Oriented Architectures
Online briefings
Search results
Online articles -->
Consulting
Mentoring
Speaking
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards
Object database articles
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy

 

 

Copyright © 2000-2009 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

 

 

Newletter Sign Up

 

 

Barry & Associates, Inc.