Re: SQL
- From: "frebe" <fredrik_bertilsson@xxxxxxxxxxx>
- Date: 25 Jan 2006 06:43:38 -0800
>>Many RDBMS vendors supports distributed transactions (like XA). Other
>>resources, such as messages may also be part of the same transaction.
> But those aren't part of what the _RDBMS_ offers.
Yes, it is.
> You could certainly add transctions to a file system, just like they were
> once added to RDBMS:es.
A RDBMS such as Oracle already have support to participate in a XA
transaction. A file system such as NTFS does not. You need an extra
product/component to enbale NTFS to participte in a transaction.
> RDBMS:es only offer transaction support _for things within their domain_
Of course. Can you name any other product offering transaction support
for things not within their domain?
> Was SQL then defined before COBOL was?
No. In the old days COBOL program used hierachial databases such as
DB/1. But a hierachial database is still more high-leven than
list,maps,arrays.
> Also, what is considered to be 'high' and 'low' level, can sometimes
> depend a bit on your point of view.
Yes, but I think we can agree that:
lists,maps,array == low level
tables,relations,SQL == high level
>>> If you package up your data structures appropriately and offer suitable
>>> operations on them, you can end up with a system that becomes similarly
>>> easy to use as a database,
>Presuming I was using, say, Apple's Cocoa frameworks,
First you claim they you can end up with a system similary easy to use
as a database, just by packaging up your data structures. Now you need
an product (Cocoa) do it. Isn't Cocoa also a DBMS?
> each city will have to maintain a set of all the customers that live there
Sounds very similary to the obsolete network databases. Network
databases and hierachial databases (XML) have been popular again in the
OO subcommunity. Probably because most of the OO fans are too young to
remember the reasons why they were abandoned.
> It does mean, however, that you are placing your business logic no longer
> in your application, but in the RDBMS.
What if the difference? The RDBMS is a part of the application.
Fredrik Bertilsson
http://butler.sourceforge.net
.
- References:
- Prev by Date: Re: SQL
- Next by Date: Re: SQL
- Previous by thread: Re: SQL
- Next by thread: Re: SQL
- Index(es):
Relevant Pages
|
