Apache Derby graduates with Sun onboard

RDBMS: is a data base management system implementing the 'Relational Data Model' (RDM).

A data model specifies
- how to define primitive data types,
- how to create various types of collections of aggregations of them, and
- what operations are acceptable against items and collections.

the RDM uses the relation as a basic collection of objects which can be visualized as a table with data 'attributes' in the columns and rows to represent an item belonging to this collection.

SQL is a (declarative) programming language in which you specify the various collections of your data, how they relate to each oter and wha operations to carry out (queries, insertions, deletions, modifications, etc.) for the RDM. There are other PLs that can bne used against the RDM but SQL is the most widely used one.

In a reasonable sense, to implement SQL you need to have a relational DB managed by an RDMBS. You could use SQL though with a backend that simulates an RDBMS and usees say indexed files. That would be very inefficient unless done properly, but then you would have already implemented an RDBMS all over again.; Posted by: michael_t Posted on: 08/04/05 You are currently: a Guest | Members login | Terms of Use

Reply to Story Reply to Message

Subscribe to this discussion via Email or RSS

A book you could read jorwell | 08/04/05

RDBMS michael_t | 08/04/05

To be relational jorwell | 08/04/05

What do you think?

Here to help you with your Document Management Needs
Check out Doc’s Blog on ZDNet
Help your company, help the earth I want to share with you the Environmental Defense Fund Paper Calculator, which allows you to gauge your organization's environmental impact.
Which is Greener: Paper or Digital? The Answer May Surprise You Anything we can do to reduce paper consumption is good. But what about the impact of digital waste?
Produced by
ZDNet and