DBMS
Title: Message I erased the exec clause and it worked. Sorry and tks Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Analyze Vs DBMS Stats Anomaly
Oracle 8161 ...
oraclei@orion sys
SQL*Plus: Release 8.1.6.0.0 - Production on Fri Aug 9 14:20:18 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected.
SQL create table raj_test (col1 varchar2(1));
Table created.
SQL insert into raj_test values('1');
1 row created.
SQL commit;
Commit complete.
SQL analyze table raj_test estimate statistics;
Table analyzed.
SQL select table_name, BLOCKS,AVG_ROW_LEN from dba_tables where table_name
= 'RAJ_TEST';
TABLE_NAME BLOCKS AVG_ROW_LEN
-- -- ---
RAJ_TEST1 5
SQL analyze table raj_test compute statistics;
Table analyzed.
SQL select table_name, BLOCKS,AVG_ROW_LEN from dba_tables where table_name
= 'RAJ_TEST';
TABLE_NAME BLOCKS AVG_ROW_LEN
-- -- ---
RAJ_TEST1 5
SQL exec dbms_stats.gather_table_stats('SYS','RAJ_TEST',NULL,20,FALSE);
PL/SQL procedure successfully completed.
SQL select table_name, BLOCKS,AVG_ROW_LEN from dba_tables where table_name
= 'RAJ_TEST';
TABLE_NAME BLOCKS AVG_ROW_LEN
-- -- ---
RAJ_TEST1 2 == different
result
==
Oracle 9.2
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Aug 9 14:35:13 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
SQL create table raj_test (col1 varchar2(1));
Table created.
SQL insert into raj_test values ('1');
1 row created.
SQL commit;
Commit complete.
SQL analyze table raj_test estimate statistics;
Table analyzed.
SQL select table_name, BLOCKS,AVG_ROW_LEN from dba_tables where table_name
= 'RAJ_TEST';
TABLE_NAME BLOCKS AVG_ROW_LEN
-- -- ---
RAJ_TEST1 5
SQL analyze table raj_test compute statistics;
Table analyzed.
SQL select table_name, BLOCKS,AVG_ROW_LEN from dba_tables where table_name
= 'RAJ_TEST';
TABLE_NAME BLOCKS AVG_ROW_LEN
-- -- ---
RAJ_TEST1 5
SQL exec dbms_stats.gather_table_stats('SYS','RAJ_TEST',NULL,0,FALSE,NULL);
PL/SQL procedure successfully completed.
SQL select table_name, BLOCKS,AVG_ROW_LEN from dba_tables where table_name
= 'RAJ_TEST';
TABLE_NAME BLOCKS AVG_ROW_LEN
-- -- ---
RAJ_TEST1 5
===
I did this test because when we did analyze using 'analyze table', things
were fine, but when we used (or tried to use) 'dbms_stats' the queries were
so slow that we could actually see packets moving across the fiber. Okay, we
didn't but a 20 minute query was transformed to a 2 hour 45 minute ordeal.
Bug# 1388282 concludes that in 8i, 'analyze table' was doing something wrong
in calculating average row length, except when used with 'compute statistics
for all columns;' clause, and that 'dbms_stats' was doing the right thing.
This sounds like BS, because it certainly didn't work for us.
Assuming the information in the BUS is true, why did Oracle did a turnaround
in 9i? BTW the results for 9.2 are applicable in 9012 as well. Any details
from 'the people in the know'?? Although our problems have gone away, I'd
like to find out what went wrong.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
*This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*2
Re: Re:RE: Difference Between DBMS/RDBMS
I think that 6.0.x was all there ever was on most platforms. I worked with Oracle on a smorgasboard of Unix-like platforms (AIX, Sun, Xenix, SCO, Unisys s5r4, etc.) all the way through Oracle6 and don't remember ever seeing anything beyond 6.0.36. That could be because either (1) we skipped later 6.x in favor of Oracle7.0.x or (2) what was in memory was swapped to disk and never needed again. ;-) I didn't work with VMS after Oracle 4 (!), but there was at least a 6.2 release on VMS - exclusively I think. [If I remember correctly (unlikely), the VMS release 6.x (x=2?) for the VAX cluster was the granddaddy of OPS]. I don't know about 6.1, but if there ever was such a critter, I suspect that it was VMS-only also. Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 12:08 PM There was a 6.1 and/or 6.2? I went from 6.0.36 straight to 7.2. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 8:18 AM A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
I missed this part in my previous response... Does anyone remember why there never was a 9.1? We seem to have gone directly from 9.0.x to 9.2.0! [Did I miss somethng while taking a nap sometime recently?] Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 11:18 AM A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
R: Difference Between DBMS/RDBMS
In Italy (and most of european countries) there's the new Euro currency, so you can't covert you USD to ITL any more. It's too late to become a millionaire... Armando -Messaggio originale- Da: Ferenc Mantfeld [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 26 giugno 2002 6.23 A: Multiple recipients of list ORACLE-L Oggetto: RE: Difference Between DBMS/RDBMS Also a bit about Larry luring IBM engeneers promising that they would become millionares with Oracle. He was right. [ Ferenc Mantfeld ] the surest way to have become a millionaire in the stock market over the last 2 years, was if you started out as a multi-millionaire. The surest way to instantly become a millionaire in today's climate is to take your next pay cheque and go to beautiful Italy (convert to Lire), though the experience may be short-lived. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MARCOTULLI ARMANDO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
No there was never a 6.1 or a 6.2 unless I missed a meeting. The latest version of 6 I worked on was 6.0.37. Regards, Mike Hately -Original Message- Sent: 25 June 2002 18:09 To: Multiple recipients of list ORACLE-L There was a 6.1 and/or 6.2? I went from 6.0.36 straight to 7.2. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 8:18 AM A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Oracle was the first commercial Realtional Database Management System. And it was relational from day one (version two :), and it was built with relational theory in mind. IBM was the first to implement RDBMS though. It was called System R, or something, later it became known as DB2. Take a look at this paper: http://www.mcjones.org/System_R/SQL_Reunion_95/index.html Very fascinating reading. They tell how Larry was trying to get tle list of DB2 error codes so that Oracle would be compatible with it. Also a bit about Larry luring IBM engeneers promising that they would become millionares with Oracle. He was right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
But there is Turkey where one dollar is around 160 Turkish Lira at the moment. So a thousand dollars makes 1.6 billion TL. We are all billionaires here. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 11:58 AM In Italy (and most of european countries) there's the new Euro currency, so you can't covert you USD to ITL any more. It's too late to become a millionaire... Armando -Messaggio originale- Da: Ferenc Mantfeld [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 26 giugno 2002 6.23 A: Multiple recipients of list ORACLE-L Oggetto: RE: Difference Between DBMS/RDBMS Also a bit about Larry luring IBM engeneers promising that they would become millionares with Oracle. He was right. [ Ferenc Mantfeld ] the surest way to have become a millionaire in the stock market over the last 2 years, was if you started out as a multi-millionaire. The surest way to instantly become a millionaire in today's climate is to take your next pay cheque and go to beautiful Italy (convert to Lire), though the experience may be short-lived. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MARCOTULLI ARMANDO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Difference Between DBMS/RDBMS
In fact, there was a 6.1. Lasted only less than a year. It was one of the very early Parallel Server versions available. Only ran on VMS, IIRC. At least, that's the only port of it I managed to install. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - No there was never a 6.1 or a 6.2 unless I missed a meeting. The latest version of 6 I worked on was 6.0.37. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
Maybe coz 9.2 sounds more reliable than 9.1 :) Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 10:58 AM I missed this part in my previous response... Does anyone remember why there never was a 9.1? We seem to have gone directly from 9.0.x to 9.2.0! [Did I miss somethng while taking a nap sometime recently?] Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 11:18 AM A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
Live and learn =) I wasn't using VMS at the time but all the same, I'm surprised I haven't heard about it. Many thanks, Mike -Original Message- Sent: 26 June 2002 11:18 To: Multiple recipients of list ORACLE-L In fact, there was a 6.1. Lasted only less than a year. It was one of the very early Parallel Server versions available. Only ran on VMS, IIRC. At least, that's the only port of it I managed to install. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - No there was never a 6.1 or a 6.2 unless I missed a meeting. The latest version of 6 I worked on was 6.0.37. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
The surest way to instantly become a millionaire in today's climate is to take your next pay cheque and go to beautiful Italy (convert to Lire), though the experience may be short-lived. In fact, since last January, Italy uses Euro ... and on the current trend it may not be long before a USD pay cheque becomes nominally even fewer Euros. Rather try Turkey or Vietnam (no coins, you got monstruous bundles of notes even when changing a small denomination western (currency doesn't matter) banknote). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
Didn't Larry call you direct to let you know Mike?. Very inconsiderate of him -Original Message- Sent: 26 June 2002 11:44 To: Multiple recipients of list ORACLE-L Live and learn =) I wasn't using VMS at the time but all the same, I'm surprised I haven't heard about it. Many thanks, Mike -Original Message- Sent: 26 June 2002 11:18 To: Multiple recipients of list ORACLE-L In fact, there was a 6.1. Lasted only less than a year. It was one of the very early Parallel Server versions available. Only ran on VMS, IIRC. At least, that's the only port of it I managed to install. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - No there was never a 6.1 or a 6.2 unless I missed a meeting. The latest version of 6 I worked on was 6.0.37. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
As I recall, the Dec product was called Rdb, and generally regarded as quite good. It was subsequently bought by Oracle. The old hierarchical and network systems did not require foreign keys, because all records were explicitly linked via hard-coded pointers. So you HAD to get your design right before building the data model, otherwise retrieval would be a nightmare. Because relational systems allow joins at query time, a major slackness has crept into database model design. Like not always protecting the integrity of PKs... Talking of working on small memory machines - here is a test for your age in the industry - all those who can remember writing overlays stand up! I suspect the current crop of PC software engineers have never encountered overlay programing. peter edinburgh -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: 25 June 2002 15:08 To: Multiple recipients of list ORACLE-L Subject: RE: Difference Between DBMS/RDBMS Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E
RE: RE: Difference Between DBMS/RDBMS
I was quite upset myself. It's like he just doesn't care any more. You were a VMS bloke at one point; Didn't you use 6.1? =) Mike -Original Message- Sent: 26 June 2002 12:14 To: Multiple recipients of list ORACLE-L Didn't Larry call you direct to let you know Mike?. Very inconsiderate of him -Original Message- Sent: 26 June 2002 11:44 To: Multiple recipients of list ORACLE-L Live and learn =) I wasn't using VMS at the time but all the same, I'm surprised I haven't heard about it. Many thanks, Mike to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re:RE: Difference Between DBMS/RDBMS
Don is right - there was a 6.2 on VMS - I worked on it! And it was the granddaddy of OPS. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 26, 2002 4:48 AM To: Multiple recipients of list ORACLE-L I think that 6.0.x was all there ever was on most platforms. I worked with Oracle on a smorgasboard of Unix-like platforms (AIX, Sun, Xenix, SCO, Unisys s5r4, etc.) all the way through Oracle6 and don't remember ever seeing anything beyond 6.0.36. That could be because either (1) we skipped later 6.x in favor of Oracle7.0.x or (2) what was in memory was swapped to disk and never needed again. ;-) I didn't work with VMS after Oracle 4 (!), but there was at least a 6.2 release on VMS - exclusively I think. [If I remember correctly (unlikely), the VMS release 6.x (x=2?) for the VAX cluster was the granddaddy of OPS]. I don't know about 6.1, but if there ever was such a critter, I suspect that it was VMS-only also. Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 12:08 PM There was a 6.1 and/or 6.2? I went from 6.0.36 straight to 7.2. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 8:18 AM A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
Would that be more unbreakable ??? -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Gorbatchev Sent: Wednesday, June 26, 2002 5:24 AM To: Multiple recipients of list ORACLE-L Maybe coz 9.2 sounds more reliable than 9.1 :) Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 10:58 AM I missed this part in my previous response... Does anyone remember why there never was a 9.1? We seem to have gone directly from 9.0.x to 9.2.0! [Did I miss somethng while taking a nap sometime recently?] Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 11:18 AM A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
slowly standing - trembling, with creaks and pops as he rises Overlays in Turbo Pascal One of the more challenging aspects of writing Pro*C user exit code for Forms 2.3 on a DOS client running against an Oracle 5 database was trying to link 1,000 or so C functions (at one function per file for modularity) to create a large iapx (?correct name for version?) executable within a segmented 16-bit architecture. [These young whipper-snappers today have it SO easy!] Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 6:20 AM As I recall, the Dec product was called Rdb, and generally regarded as quite good. It was subsequently bought by Oracle. The old hierarchical and network systems did not require foreign keys, because all records were explicitly linked via hard-coded pointers. So you HAD to get your design right before building the data model, otherwise retrieval would be a nightmare. Because relational systems allow joins at query time, a major slackness has crept into database model design. Like not always protecting the integrity of PKs... Talking of working on small memory machines - here is a test for your age in the industry - all those who can remember writing overlays stand up! I suspect the current crop of PC software engineers have never encountered overlay programing. peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Difference Between DBMS/RDBMS
could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh
R: Difference Between DBMS/RDBMS
DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 11.48A: Multiple recipients of list ORACLE-LOggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh
RE: Difference Between DBMS/RDBMS
full form i also knew. and also that all dbms have the features of rdbms also then, what is the difference ?? santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcello SavinoSent: Tuesday, June 25, 2002 4:58 PMTo: Multiple recipients of list ORACLE-LSubject: R: Difference Between DBMS/RDBMS DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 11.48A: Multiple recipients of list ORACLE-LOggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh
Re: Difference Between DBMS/RDBMS
i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
DBMS is broad term, It covers Relational, heirarchical and network database management systems. Regards Tripat Singh - Original Message - From: Marcello Savino To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 25, 2002 4:58 PM Subject: R: Difference Between DBMS/RDBMS DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 11.48A: Multiple recipients of list ORACLE-LOggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh
Re: Difference Between DBMS/RDBMS
Not all DBMS have features of RDBMS. dBase or IBM's IMS are that come to mind. There were hierachical databases, network databases, ISAM (Indexed Sequential Acess Method) but these days, yes, noDBMS can besuccessfull whitout `R'. - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 25, 2002 3:18 PM Subject: RE: Difference Between DBMS/RDBMS full form i also knew. and also that all dbms have the features of rdbms also then, what is the difference ?? santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcello SavinoSent: Tuesday, June 25, 2002 4:58 PMTo: Multiple recipients of list ORACLE-LSubject: R: Difference Between DBMS/RDBMS DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 11.48A: Multiple recipients of list ORACLE-LOggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh
Re: Difference Between DBMS/RDBMS
OK. First were pre-relational DBMS. Like fms, network, hierarchical; programmatic pragmatic. Different types. Some are still useful. Than Codd came with his 12 rules (12?) I believe INGRES was the fist onebased onhis research. Than (80's) came Oracle, Sybase, DB2, Informix. btw, I believe Oracle was not relational until version... mmm 6 or 7? was 6 relational? Than came post-relational dbms with extended semantic, rule-based, etc. 90's - object oriented DB, spatial, distributed db, multi-dimensional, data warehouses and data mining, AI. about 2000 came XML They all seem to be DMBS, but not all are RDBMS. In fact, can anybody name pure relational dbms? What did I forget, missed or make wrong? - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 25, 2002 2:18 PM Subject: RE: Difference Between DBMS/RDBMS full form i also knew. and also that all dbms have the features of rdbms also then, what is the difference ?? santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcello SavinoSent: Tuesday, June 25, 2002 4:58 PMTo: Multiple recipients of list ORACLE-LSubject: R: Difference Between DBMS/RDBMS DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 11.48A: Multiple recipients of list ORACLE-LOggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh
RE: Difference Between DBMS/RDBMS
-Original Message-From: Marcello Savino [mailto:[EMAIL PROTECTED]]Sent: 25 June 2002 12:28To: Multiple recipients of list ORACLE-LSubject: R: Difference Between DBMS/RDBMS DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. [Robson, Peter] Try Oracle * - hee hee hee ! More seriously - IMS is non-relational. I'm sure we will be inundated with other products. But there are three major types - Network, Hierarchical and Relational. (Oh all right, Object...). peter * ps - its a SQL DBMS . Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 11.48A: Multiple recipients of list ORACLE-LOggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk *
Re: Difference Between DBMS/RDBMS
Well,DBMS do NOT always have relational attribute. In the good old days there whereDBMS likeTotal or IMS which are hierarchical DBMS I am working on ADABAS on the mainframe. This DBMS have array and array of structure that exclude it from the relational model. One of the fastest in the mainframe world. Yechiel AdarMehish - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 25, 2002 2:18 PM Subject: RE: Difference Between DBMS/RDBMS full form i also knew. and also that all dbms have the features of rdbms also then, what is the difference ?? santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcello SavinoSent: Tuesday, June 25, 2002 4:58 PMTo: Multiple recipients of list ORACLE-LSubject: R: Difference Between DBMS/RDBMS DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 11.48A: Multiple recipients of list ORACLE-LOggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh
RE: Difference Between DBMS/RDBMS
Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
only fool's like you can point such differences...when not able to find valid differences. -Original Message- Sent: Tuesday, June 25, 2002 5:54 PM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
Ah yes, what newcomers to the computer age! The part I always find fascinating is that when the relational ideas were coming together around the time Codd made his 12 rules, the big question was: will a relational database ever be practical?. Another point is that there were many competitors to SQL as a relational database access language at one time. In the end, SQL won, many would claim not because it was the best, but because of a series of the right historical circumstances coming together. Now, of course, the SQL RDBMS rules the database kingdom. The non-SQL RDBMS is a historical artifact. The non-RDBMS DBMS is still widely used in the mainframe world. If you take a trip this summer, realize that your ticket is probably processed by a non-relational DBMS and your aircraft is tracked by a non-relational DBMS. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 8:33 AM To: Multiple recipients of list ORACLE-L OK. First were pre-relational DBMS. Like fms, network, hierarchical; programmatic pragmatic. Different types. Some are still useful. Than Codd came with his 12 rules (12?) I believe INGRES was the fist one based on his research. Than (80's) came Oracle, Sybase, DB2, Informix. btw, I believe Oracle was not relational until version... mmm 6 or 7? was 6 relational? Than came post-relational dbms with extended semantic, rule-based, etc. 90's - object oriented DB, spatial, distributed db, multi-dimensional, data warehouses and data mining, AI. about 2000 came XML They all seem to be DMBS, but not all are RDBMS. In fact, can anybody name pure relational dbms? What did I forget, missed or make wrong? - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 2:18 PM full form i also knew. and also that all dbms have the features of rdbms also then, what is the difference ?? santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Marcello Savino Sent: Tuesday, June 25, 2002 4:58 PM To: Multiple recipients of list ORACLE-L DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale- Da: Santosh Varma [mailto:[EMAIL PROTECTED]] Inviato: martedì 25 giugno 2002 11.48 A: Multiple recipients of list ORACLE-L Oggetto: Difference Between DBMS/RDBMS could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K ram !! -Original Message- Sent: 25 June 2002 15:58 To: Multiple recipients of list ORACLE-L Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538
Re: Difference Between DBMS/RDBMS
did you ever read a basic college level textbook on database technology? google search on codd date rdbms yielded the following: http://www.palslib.com/Fundamentals/The_Relational_Model.html enjoy, ep On 25 Jun 2002 at 1:48, Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Difference Between DBMS/RDBMS
Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Difference Between DBMS/RDBMS
Wang Basic (anyone else remember Wang computers?) in 64K of ram rather than rewrite the system when we maxed out on allowable datafiles, the manager of the system (can you say desperate for job security?) found a product which emulated the Wang machine on a VAX but allowed you to expand the number of datafiles. Still limited to 64K of memory though. --- [EMAIL PROTECTED] wrote: Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Difference Between DBMS/RDBMS
Santosh, byte me. Since if you got off your a$$ and did some research you'd find out the differences. joe Santosh Varma wrote: only fool's like you can point such differences...when not able to find valid differences. -Original Message- Sent: Tuesday, June 25, 2002 5:54 PM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
Oracle was the first commercial Realtional Database Management System. And it was relational from day one (version two :), and it was built with relational theory in mind. IBM was the first to implement RDBMS though. It was called System R, or something, later it became known as DB2. Take a look at this paper: http://www.mcjones.org/System_R/SQL_Reunion_95/index.html Very fascinating reading. They tell how Larry was trying to get tle list of DB2 error codes so that Oracle would be compatible with it. Also a bit about Larry luring IBM engeneers promising that they would become millionares with Oracle. He was right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
[EMAIL PROTECTED] wrote: [...snip...] Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. In 1967 I learned machine language programming on a Univac box with only 8K words. I was the Sys. Admin on a VAX 11/780 (VMS V1.3) in 1979 which had 256KB of RAM and supported a s/w development staff of more than a dozen programmers! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Difference Between DBMS/RDBMS
I've used Atari 800XL (still have it). JP On Tuesday 25 June 2002 17:13, you wrote: Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K ram !! -Original Message- Sent: 25 June 2002 15:58 To: Multiple recipients of list ORACLE-L Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re:RE: Difference Between DBMS/RDBMS
DOS 1.0 (based on CP/M) came in '81 (or '82?) along with 8086 and the Basic from M$ :). 8080 - CP/M? I remeber I loaded punched tape in refrigerator-sized heaters and entered loader's binary code in the middle 80's. :) That was 16 bytes. :) It's good to be young! but old enough to remember :-p -- Alexandre OCP DBA/Devel Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: RE: Difference Between DBMS/RDBMS
Heh, I started programming in PL/1 with DL/1 databases. All hierarchical and you had to navigate round the tree using calls like GN (get next) and GU (get unique). Oh the memories! Regards, Mike Hately __Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
Hello, I would have to look at my (very dusty) notes to check on the system attributes and other particulars, but I recall using a system called RAX (relational something something), running on a IBM mainframe (OS/MVS ?), in 1964, at the Univ. of R.I. The execute command was /end run. I can not remember anything else about RAX at this time. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K ram !! -Original Message- Sent: 25 June 2002 15:58 To: Multiple recipients of list ORACLE-L Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use
Re: RE: Difference Between DBMS/RDBMS
My Z-80 based PC had 64K (useful only 48). That was the standard architecture for Z80 4.77MHz 8-) -- Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 5:13 PM Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K ram !! -Original Message- Sent: 25 June 2002 15:58 To: Multiple recipients of list ORACLE-L Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received
RE: Difference Between DBMS/RDBMS
In 1982 ANSI charged its X3H2 committee with defining a standard relational database. IBM became committed to SQL as the standard database language. The resultind ANSI standard is largly based on DB2 SQL. Dave -Original Message- Sent: Tuesday, June 25, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
Title: RE: Difference Between DBMS/RDBMS That's nothing. I use to bang the rocks together to make the sand from which the silicon was extracted that was used to create the first memory chips Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145
RE: Difference Between DBMS/RDBMS
A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Oracle was the first commercial Realtional Database Management System. And it was relational from day one (version two :), and it was built with relational theory in mind. IBM was the first to implement RDBMS though. It was called System R, or something, later it became known as DB2. Take a look at this paper: http://www.mcjones.org/System_R/SQL_Reunion_95/index.html Very fascinating reading. They tell how Larry was trying to get tle list of DB2 error codes so that Oracle would be compatible with it. Also a bit about Larry luring IBM engeneers promising that they would become millionares with Oracle. He was right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
Ooh, someone needs a chill pill. I suggest when you are asking such a basic question you refrain from insulting one of the more respected members of this list. Regards Lee -Original Message- Sent: 25 June 2002 14:38 To: Multiple recipients of list ORACLE-L only fool's like you can point such differences...when not able to find valid differences. -Original Message- Sent: Tuesday, June 25, 2002 5:54 PM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
Tom I don't have the book here at work, so I'm doing this from memory. IBM created an experimental relational database named System R, which is usually acknowledged as the first RDBMS. Being a large bureaucratic organization that was making a fortune on non-relational databases, IBM did not swiftly move the RDBMS to production status. I recall System R used SQL as its query language. The historical irony is that a small organization rushed its SQL-based product, Oracle, into production well ahead of IBM. How the dates relate to DEC, I'm not sure. Also, I believe that Oracle was only available on small systems for a long time. I feel your statement that DEC had the first RDBMS on large systems is probably correct. I think Oracle's strength in the early days was in proliferation (many small systems), not large systems. I believe Oracle had four advantages which caused it to come out as the RDBMS leader: 1. VERY, VERY aggressive organization. At one time the industry leader was Ingres, now mostly a historical footnote. Read the book The Difference Between God and Larry Ellison. Fortunately Oracle seems to have tempered its aggressiveness as it grew large, unlike Microsoft. Or maybe Oracle simply hasn't achieved the monopoly status. 2. Ported its product to many, many platforms. 3. Was not a proprietary product. Many hardware companies like DEC, HP, IBM were run by hardware people that felt the sole purpose of software was to sell more hardware. I know, I used to work for a hardware company. Independent companies like Oracle didn't have these handicaps. 4. Selected SQL as the interface language. As SQL emerged as the standard RDBMS query language, Oracle was well-positioned. Other excellent companies that happened to select query languages that were technically superior to SQL were forced into awkward migrations. Interested in any other recollections. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re:RE: Difference Between DBMS/RDBMS
On 25 Jun 2002 at 7:33, Rachel Carmichael wrote: Wang Basic (anyone else remember Wang computers?) in 64K of ram First computer company to advertise during the Superbowl? My dad was the first guy to bring them into the Pentagon (document management system?), somewhere around 1972. When the incompetent secretaries got mad about being replaced with computers, and their union got pissy about same, he fired them. regards, ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Difference Between DBMS/RDBMS
There was a 6.1 and/or 6.2? I went from 6.0.36 straight to 7.2. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 8:18 AM A - but is a system truely Relational if they don't support foreign keys? That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 - I forget). Anybody remember why there was never a release 6.1 - we went from 6.0 directly to 6.2??? Correct answer gets a virtual beer. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Oracle was the first commercial Realtional Database Management System. And it was relational from day one (version two :), and it was built with relational theory in mind. IBM was the first to implement RDBMS though. It was called System R, or something, later it became known as DB2. Take a look at this paper: http://www.mcjones.org/System_R/SQL_Reunion_95/index.html Very fascinating reading. They tell how Larry was trying to get tle list of DB2 error codes so that Oracle would be compatible with it. Also a bit about Larry luring IBM engeneers promising that they would become millionares with Oracle. He was right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
AFAIK, RDB was DEC's Relational offering and was only available on VAXen, and eventually Alphas. It was preceeded by DEC's CODASYL DBMS, known generically as DBMS. Perhaps IBM had an RDB, too, since the names are generic enough. I worked extensively with DEC's DBMS and COBOL in my first programming job back in '88, but I'll be damned if I remember one bit of DBMS. I know that it shared a bunch of features (and probably code) with RDB, and was also acquired by Oracle in the RDB purchase back in '95. One of the coolest things with RDB that Oracle should've jumped on is the idea of SQL Modules for 3GL support, instead of the icky pre-compilers. Since all of your SQL was in a separate module, it was language independant. It was also nice from a development standpoint in that all of your SQL was in one module, instead of interspersed throughout your 3GL code. Oh well...back to truncating tables... ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Difference Between DBMS/RDBMS Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
Dave - And since Oracle had bet its company on the SQL language, it was well-positioned to ride that horse to victory. Ironic that for so many years it appears that Oracle reaped so much more benefit from SQL than IBM did. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 10:03 AM To: Multiple recipients of list ORACLE-L In 1982 ANSI charged its X3H2 committee with defining a standard relational database. IBM became committed to SQL as the standard database language. The resultind ANSI standard is largly based on DB2 SQL. Dave -Original Message- Sent: Tuesday, June 25, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
Nicolai, Thank you very much. Very interesting paper. mkb --- Nicolai Tufar [EMAIL PROTECTED] wrote: Oracle was the first commercial Realtional Database Management System. And it was relational from day one (version two :), and it was built with relational theory in mind. IBM was the first to implement RDBMS though. It was called System R, or something, later it became known as DB2. Take a look at this paper: http://www.mcjones.org/System_R/SQL_Reunion_95/index.html Very fascinating reading. They tell how Larry was trying to get tle list of DB2 error codes so that Oracle would be compatible with it. Also a bit about Larry luring IBM engeneers promising that they would become millionares with Oracle. He was right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
Title: RE: Difference Between DBMS/RDBMS Alexandre, CP/M. That brings back fond memories. Just last night I was looking for something in my attic and stumbled upon my first computer - an Amstrad PCW8256. If I remember correctly the 8 was for the Z80 chip and the 256 was the memory in KB. It used CP/M and Mallard Basic. I bet I could still PIP if I thought about it Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Alexandre Gorbatchev [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re:RE: Difference Between DBMS/RDBMS DOS 1.0 (based on CP/M) came in '81 (or '82?) along with 8086 and the Basic from M$ :). 8080 - CP/M? I remeber I loaded punched tape in refrigerator-sized heaters and entered loader's binary code in the middle 80's. :) That was 16 bytes. :) It's good to be young! but old enough to remember :-p -- Alexandre OCP DBA/Devel
RE: RE: Difference Between DBMS/RDBMS
3K of RAM available on the VIC-20. The other 5K were taken up by the operating system. I had a terminal emulator program that allowed me to dial-up at 300 baud and run an IBM mainframe from home. Real bleeding-edge stuff at the time (LOL). Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L lerobe [EMAIL PROTECTED] @acxiom.co.ukcc: Subject: RE: RE: Difference Between Sent by: rootDBMS/RDBMS 06/25/2002 11:13 AM Please respond to ORACLE-L Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K ram !! -Original Message- Sent: 25 June 2002 15:58 To: Multiple recipients of list ORACLE-L Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
RE: RE: Difference Between DBMS/RDBMS
When the incompetent secretaries got mad about being replaced with computers, and their union got pissy about same, he fired them. this explains a lot! take no prisoners! bargain with no-one! :) -Original Message- Sent: Tuesday, June 25, 2002 12:24 PM To: Multiple recipients of list ORACLE-L On 25 Jun 2002 at 7:33, Rachel Carmichael wrote: Wang Basic (anyone else remember Wang computers?) in 64K of ram First computer company to advertise during the Superbowl? My dad was the first guy to bring them into the Pentagon (document management system?), somewhere around 1972. When the incompetent secretaries got mad about being replaced with computers, and their union got pissy about same, he fired them. regards, ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference Between DBMS/RDBMS
1978, Boeing at Seattle. There was a product called RIM (relational information manager) that ran on IBM 370's. We didn't use it too much at Boeing because we had ARX which was sort of a first cousin. If Boeing could sell software the way that they sell airplanes I doubt if DB2 or Oracle would be more than an historical oddity. RIM migrated to PCs as RBase. There was at least one other SQL-based information manager running around at that time (on IBM mainframes) but I can't remember it's acronym. Heck, we didn't even know enough to call them Data Base Managers. We just called them Data Managers or Information Managers. As for banging rocks together to make silicon chips --- doesn't anyone remember why core memory is called core? Has anyone else every seen a real core meltdown? It's not a pretty picture but your CRT does some amazing things while it's happening. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L DWILLIAMS [EMAIL PROTECTED] @LIFETOUCH.COcc: M Subject: RE: Difference Between DBMS/RDBMS Sent by: root 06/25/2002 11:43 AM Please respond to ORACLE-L Tom I don't have the book here at work, so I'm doing this from memory. IBM created an experimental relational database named System R, which is usually acknowledged as the first RDBMS. Being a large bureaucratic organization that was making a fortune on non-relational databases, IBM did not swiftly move the RDBMS to production status. I recall System R used SQL as its query language. The historical irony is that a small organization rushed its SQL-based product, Oracle, into production well ahead of IBM. How the dates relate to DEC, I'm not sure. Also, I believe that Oracle was only available on small systems for a long time. I feel your statement that DEC had the first RDBMS on large systems is probably correct. I think Oracle's strength in the early days was in proliferation (many small systems), not large systems. I believe Oracle had four advantages which caused it to come out as the RDBMS leader: 1. VERY, VERY aggressive organization. At one time the industry leader was Ingres, now mostly a historical footnote. Read the book The Difference Between God and Larry Ellison. Fortunately Oracle seems to have tempered its aggressiveness as it grew large, unlike Microsoft. Or maybe Oracle simply hasn't achieved the monopoly status. 2. Ported its product to many, many platforms. 3. Was not a proprietary product. Many hardware companies like DEC, HP, IBM were run by hardware people that felt the sole purpose of software was to sell more hardware. I know, I used to work for a hardware company. Independent companies like Oracle didn't have these handicaps. 4. Selected SQL as the interface language. As SQL emerged as the standard RDBMS query language, Oracle was well-positioned. Other excellent companies that happened to select query languages that were technically superior to SQL were forced into awkward migrations. Interested in any other recollections. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I
RE: Difference Between DBMS/RDBMS
Dennis, I agree with everything you said - especially with regard to Oracle and how they developed. Larry saw the benefit of not being tied to one vendor and quickly changed his code-base to C to accomplish this. That, and the adherance to supporting SQL was the biggest selling point - plus, people were tired of paying absolute top dollar for proprietary software tools to access their data. I remember paying $90,000 a year for a maintenance contract for Cobol on the Burroughs A-Frame machine. Ridiculous amount of money. Along came Oracle. Pay them for the DB software, pick your own 3rd party development tool, and you were *way* ahead of the $ game. Tom -Original Message- Sent: Tuesday, June 25, 2002 11:43 AM To: Multiple recipients of list ORACLE-L Tom I don't have the book here at work, so I'm doing this from memory. IBM created an experimental relational database named System R, which is usually acknowledged as the first RDBMS. Being a large bureaucratic organization that was making a fortune on non-relational databases, IBM did not swiftly move the RDBMS to production status. I recall System R used SQL as its query language. The historical irony is that a small organization rushed its SQL-based product, Oracle, into production well ahead of IBM. How the dates relate to DEC, I'm not sure. Also, I believe that Oracle was only available on small systems for a long time. I feel your statement that DEC had the first RDBMS on large systems is probably correct. I think Oracle's strength in the early days was in proliferation (many small systems), not large systems. I believe Oracle had four advantages which caused it to come out as the RDBMS leader: 1. VERY, VERY aggressive organization. At one time the industry leader was Ingres, now mostly a historical footnote. Read the book The Difference Between God and Larry Ellison. Fortunately Oracle seems to have tempered its aggressiveness as it grew large, unlike Microsoft. Or maybe Oracle simply hasn't achieved the monopoly status. 2. Ported its product to many, many platforms. 3. Was not a proprietary product. Many hardware companies like DEC, HP, IBM were run by hardware people that felt the sole purpose of software was to sell more hardware. I know, I used to work for a hardware company. Independent companies like Oracle didn't have these handicaps. 4. Selected SQL as the interface language. As SQL emerged as the standard RDBMS query language, Oracle was well-positioned. Other excellent companies that happened to select query languages that were technically superior to SQL were forced into awkward migrations. Interested in any other recollections. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Re: RE: Difference Between DBMS/RDBMS
Well, I've found old benchmark from 01/1984 :-) http://www.gondolin.org.uk/hchof/reviews/text/yc-atari800xl.html JP On Tuesday 25 June 2002 17:58, you wrote: I've used Atari 800XL (still have it). JP On Tuesday 25 June 2002 17:13, you wrote: Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K ram !! -Original Message- Sent: 25 June 2002 15:58 To: Multiple recipients of list ORACLE-L Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now a days) predecessor of the laptop. If memory is serving I believe it was called an Osborne? RDB was offered on the IBM mainframe and there was a VAX version that I remember playing with as well. Yeah, it's good to be old and reflect on the twists turns we went through to make things work. Anyone remember programming with less than 1MB of ram? I remember trying to make things work on 16K. Dick Goulet Human memory is fragile, thank GOD! Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 6/25/2002 6:08 AM Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 25, 2002 8:24 AM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference Between DBMS/RDBMS
Mercadante, Thomas F wrote: Oh you bunch of young whipper-snappers! A long time ago in a place far-away, we started with simple File Systems. Then came ISAM file systems. These begate DBMS systems. Note there was no 'R' in original DBMS systems. Some of these were simply an extention to ISAM files that allowed (and demanded) a more formalized collection of files. In these files, there were tables and indexes and primary keys. I remember these as Hierarchical Database Systems. Still no such thing as foreign keys. Finally, I believe, DEC came out with the RBMS system which was (I know I will be corrected on this) one of the first Relational Database Managment Systems to be made available for large systems. (I have no knowledge of IBM products - anybody? When did DB2 make itself known?). On PC's there was also something called RDB I think. See, its good to be old! Tom Mercadante Oracle Certified Professional Tom, Codd's paper was published in 1970 - as it happens, Codd was an IBM Fellow. I think that work work on System*R in the IBM San Jose lab started around this date. The 'IBM Systems Journal' published the specs of SQL in 1976 I think, while Stonebraker al where working on Ingres (which initially used Quel, which was to SQL what Betamax was to VHS - only old-timers will understand I am afraid) at Berkeley. A small gang of chaps working on the IBM specs sold to Ford the first commercial RDBMS - then running on Digital PDP 11 machine - in 1979. This was Oracle's first steps in the world. Ingres became a commercial product shortly after, and so did IBM's SQL/DS and QMS - and DEC's RDB. DB2 was announced much later, in 1983, but was the first IBM product running on MVS (with a price to match). SQL/DS and QMS were running under VM/CMS. Where's my walking stick ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Difference Between DBMS/RDBMS
Oh you poor sap! At least I was able to save up enough to get the 8K expansion cart with all the cool new BASIC commands. And when I got a job at McDonalds ($3.05/hr), I bought a brand new C=64 with a 1541! Woo-hoo! No more cassette tape storage for me! Notch the cheap SSDs to use both sides, write a quickie ASM to sit on the 1541's 2K controller RAM so you didn't have to stomp over your program to get a disk listing...man, I was set! Fast forward 4 Amigas (A500, heavily expanded A1200, and two more A500s), and now I've got emulation for all the C= machines running under Win/Linux so I can relive those days gone by. A, I can almost hear that Vic's old cassette whir and whir before it said my program was lost... ;) BTW, my home mail is still YAM 2.0 on the Amiga (UAE). But I haven't been able to get a JDBC thin client working under it...yet! :D Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Difference Between DBMS/RDBMS 3K of RAM available on the VIC-20. The other 5K were taken up by the operating system. I had a terminal emulator program that allowed me to dial-up at 300 baud and run an IBM mainframe from home. Real bleeding-edge stuff at the time (LOL). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS Job vs C Daemon
dbms_job is the way to do since if you rollback the txn, then the job submission will also roll back hth connor --- Alroy Mascranghe [EMAIL PROTECTED] wrote: Several programs writes to a table. From that table a process has to be initiated. (Currently it is working on a trigger but this is causing locking problems). What would be the best way to do this - to read the table and start the process ? A PRO C daemon or a DBMS job ? What are the advantages and disadvantages of each ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: DBMS Job vs C Daemon
Possibly a candidate for Oracle Advanced Queueing? -Joe --- Connor McDonald [EMAIL PROTECTED] wrote: dbms_job is the way to do since if you rollback the txn, then the job submission will also roll back hth connor --- Alroy Mascranghe [EMAIL PROTECTED] wrote: Several programs writes to a table. From that table a process has to be initiated. (Currently it is working on a trigger but this is causing locking problems). What would be the best way to do this - to read the table and start the process ? A PRO C daemon or a DBMS job ? What are the advantages and disadvantages of each ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
I also agree, cron WORKS well ! The only thing I would add to cron jobs (shell scripts) is to use a semaphore file. e..g. --- semfile=/tmp/$0.RUNNING if [ -f $semfile ] ; then exit ; fi touch $semfile DO SOME SHELL STUFF rm $semfile exit --- This way no matter how frequent you run the job or how long it takes the job to run, it still works. I had a developer run a job every 5 mins but the job took 15 mins to run, so you can guess what begins to happen after a few days :-) Gene [EMAIL PROTECTED] 03/15/02 08:18AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS Job vs C Daemon
Raj, Was it some kind of patch for 9011 or 9012, which fixed dbms_job? Could you provide some details? It's very important for us, because we rely heavily on dbms_job (NT environment, looking to upgrade to 9i). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 15, 2002 8:18 AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
..which is why we have a shell script that runs out of cron and checks on database jobs. Here is the SQL that we use to find jobs with problems: /* Check for broken jobs or jobs that have failed more than 8 times. */ /* Also check for jobs that should have run in the last day, but haven't. */ select job, failures, broken from dba_jobs where failures 8 or broken = 'Y' or sysdate - next_date 1 spool check_jobs.lis / spool off Some jobs have to run in the database, such as snapshot refreshes. Jay [EMAIL PROTECTED] 03/15/02 08:18AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS Job vs C Daemon
We don't let developers run the job but your idea is good about semaphore Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, March 15, 2002 8:59 AM To: Multiple recipients of list ORACLE-L I also agree, cron WORKS well ! The only thing I would add to cron jobs (shell scripts) is to use a semaphore file. e..g. --- semfile=/tmp/$0.RUNNING if [ -f $semfile ] ; then exit ; fi touch $semfile DO SOME SHELL STUFF rm $semfile exit --- This way no matter how frequent you run the job or how long it takes the job to run, it still works. I had a developer run a job every 5 mins but the job took 15 mins to run, so you can guess what begins to happen after a few days :-) Gene *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: DBMS Job vs C Daemon
In the past, I have seen databases not shutdown immediate b/c dbms_jobs were running, not sure if still true w/ 8i 9i? [EMAIL PROTECTED] 03/15/02 10:13AM ..which is why we have a shell script that runs out of cron and checks on database jobs. Here is the SQL that we use to find jobs with problems: /* Check for broken jobs or jobs that have failed more than 8 times. */ /* Also check for jobs that should have run in the last day, but haven't. */ select job, failures, broken from dba_jobs where failures 8 or broken = 'Y' or sysdate - next_date 1 spool check_jobs.lis / spool off Some jobs have to run in the database, such as snapshot refreshes. Jay [EMAIL PROTECTED] 03/15/02 08:18AM While I agree that dbms_job is the right way, we had lots of problems with dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012 versions of database. Finally it was something to do with job queue processes, with the help of OWS we fixed it. BUT, I still don't trust dbms_job on our 9i production db and hence all critical jobs are run by our close friend 'cron', it works!. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS Job vs C Daemon
Several programs writes to a table. From that table a process has to be initiated. (Currently it is working on a trigger but this is causing locking problems). What would be the best way to do this - to read the table and start the process ? A PRO C daemon or a DBMS job ? What are the advantages and disadvantages of each ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
why no DBMS OUTPUT messages ?
Hi all: I have SET SERVEROUTPUT ON SIZE 9; at the beginning, and when the script runs, I can see DBMS output messages. However, there is only in one database when script runs nothing will show up, no DBMS output messages and no error message. Why? Where should I check for the problem? Thanks for the help Wendy __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wendy Y INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
