Loading...
Posts on the
Design Decomposition Blog
Iridium Satellite Collision in Space
You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
(The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
Atomicity
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
Well-Formed Business Process Diagrams
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria from [...]
November 18, 2008
Recent Business Process Modeling Books
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There are [...]
October 9, 2008
The Design Decomposition Blog
is written by Doug Barry.
Loading...

Frequent use of type codes is a sign of complex data. Relational DBMSs do not handle types well. As a result, identification and processing of type codes must be done in program code when using an RDBMS.

Type codes

The figure at the left shows a "productType" field in a relational table that is used to differentiate processing for various types of products. Different type codes, for example, could identify types of sweaters and slacks in a clothing database.

To compare, in an ODBMS, types are an inherent part of the class hierarchy as shown in the figure below. In fact, the code for each type can be attached to the appropriate classes in the class hierarchy. In an ODBMS, the type codes are replaced with a class hierarchy with the method code attached. More on processing type codes.

Inheritance instead of type codes

Related content for: Frequent use of type codes

More detail for the current topic: Frequent use of type codes

More on the general topic: Complex data

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 50 pages on object-oriented database management systems.

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. You can see more detail by clicking on the arrows. This highlights the location of the current article: Frequent use of type codes.

Loading...

Related recent articles from Google News

Facebook Scores A Win In Patent Lawsuit
DaniWeb (blog)
The tool uses one or both of a relational and object database engine that facilitates at least many-to-many relationships among data elements. ...
and more »
29 Jul 2010 at 1:10pm
Stanford Hospital and Clinics Complete Rollout of InterSystems Ensemble
Financial Post
InterSystems CACHÉ® is a high performance object database that makes applications faster and more scalable. InterSystems Ensemble® is a seamless platform ...
and more »
13 Jul 2010 at 7:53am
Control Microsystems Releases ClearSCADA 2010
Water and Wastewater
In addition to standard features such as object-oriented database, scalable client/server architecture optimized for wide area networks and integrated ...
and more »
19 Jul 2010 at 11:42am
GIS Does Serviceability, Monitoring
Cable360.net
GE Smallworld is an object-oriented database that natively handles complex network topology, said Baker. The MSO has a fully connected topology from ...
and more »
19 Jul 2010 at 10:46am
Intersystems Ensemble integrated into Calif. healthcare network
CMIO
... to Ensemble for SHC began with integrating clinical applications to the hospital's EpicCare EMR system; built on the InterSystems Cache object database. ...

14 Jul 2010 at 11:26am
More related news on: "object database" OR "object-oriented database"

Related books at Amazon.com

The Object Data Standard: ODMG 3.0 (The Morgan Kaufmann Series in Data Management Systems)
The Object Data Standard: ODMG 3.0 (The Morgan Kaufmann Series in Data Management Systems)
by R. G. Cattell, Douglas K. Barry, Mark Berler, Jeff Eastman, David Jordan, Craig Russell, Olaf Schadow, Torsten Stanienda, Fernando Velez
Average Customer Review: 4 stars based on 2 reviews.
Customer Review: A well-written, concise reference covering a diverse range of topics that will be of interest to all who know the frustration of cramming complex OO systems into relational tables. From a complete design pattern for Object and Object Relational database systems, to design patterns for declarative language symantics; from C++ and Java...
Object-Oriented Database Design Clearly Explained
Object-Oriented Database Design Clearly Explained
by Jan L. Harrington
Average Customer Review: 3 stars based on 7 reviews.
Customer Review: "Object Oriented Database Design" is a book for beginners and, as far as I have been able to investigate, it is a perfect walkthrough along the background of object structures. Figures, exemples, syntax of codes and clear explanations lead the learner through theory towards practice. Exemples are often very nice.
Data Access Patterns: Database Interactions in Object-Oriented Applications
Data Access Patterns: Database Interactions in Object-Oriented Applications
by Clifton Nock
Average Customer Review: 4 stars based on 7 reviews.
Customer Review: I have to disagree with the previous review. I will try to explain why I think 'b88zhou' review is inadequate after presenting my overview of this book. After reading numerous pattern books, it is nice to see a pattern book with very good organization. Each pattern is presented with the following subsections. * Description * Context ...
More related books: Search Amazon.com for object database