pg.ddx.io University INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database
help / color / mirror / Atom feedIs Progress Good for Teaching Database Subjects?
4+ messages / 4 participants
[nested] [flat]
* Is Progress Good for Teaching Database Subjects?
@ 1995-11-30 00:00 John Olle <J.Olle@bendigo.latrobe.edu.au>
1995-11-30 00:00 ` Re: Is Progress Good for Teaching Database Subjects? gsmith@westnet.com
1995-11-30 00:00 ` Re: Is Progress Good for Teaching Database Subjects? mcolton@illustra.com
1995-12-01 00:00 ` Re: Is Progress Good for Teaching Database Subjects? peter@prospect.anprod.csiro.au
0 siblings, 3 replies; 4+ messages in thread
From: John Olle @ 1995-11-30 00:00 UTC (permalink / raw)
To: pwg@ironbark; olle@redgum; retallic@redgum
I teach a number of database subjects for:
2nd year Bachelor Computing
3rd year Bachelor Business
Post Graduate Diploma in Computing
Honors/Masters in Computing
Master of Business.
Currently we use Ingres as the main teaching software tool. Ingres is fine. We
have used Unify and that was fine. I have considerable experience with Informix and
that would be fine too.
My question, as the heading states is: Is Progress good for teaching database
subjects?
I have no intention of teaching Progress per se. I never taught Unify and I don't
teach Ingres. My concern is to teach database, mainly relational database.
In the undergraduate courses the emphasis is on relational database. Chris Date's
"An introduction to database systems", 6th ed, 1995, is the set text and these
subjects follow this reasonably closely. The software, I try to treat as much as
possible generically, i.e. I stress the standard/common features of all/most
implementations and deal with specific local features sparingly. It is the concepts
that are important to me. I wish my students to be able to become familiar with a
new relational implementation with ease should they later be required to do so.
SQL is crucial to these subjects. I am not a big fan of SQL regarding its quality,
capability, consistency, simplicity etc. but I am a huge fan of SQL because it is
one of the few true computing and in particular database standards. SQL will play a
crucial part of the undergraduate subjects.
Other subjects consider OODB and other issues.
I have reasons for concern about the use of Progress:
Reading Progress documentation and manuals makes me feel that SQL is almost
considered to be a disease rather than a standard tool.
Reading the Progress FAQ confirms this feeling.
This to me, I could live with if I can treat Progress as a generic relational
database engine which is based around SQL.
THE BIG QUESTION:
=================
Can I use Progress as a generic database engine which is based around SQL?
I would appreciate any followup opinions, advice, suggestions, particularly from
other academics who are doing something similar.
I expect non academics would also be interested as SQL and the generic philosophy
implies portability and evolution which the Progress philosophy does not seem to
support.
Thank you in advance.
John Olle
^ permalink raw [nested|flat] 4+ messages in thread
* Re: Is Progress Good for Teaching Database Subjects?
1995-11-30 00:00 Is Progress Good for Teaching Database Subjects? John Olle <J.Olle@bendigo.latrobe.edu.au>
@ 1995-11-30 00:00 ` gsmith@westnet.com
2 siblings, 0 replies; 4+ messages in thread
From: gsmith@westnet.com @ 1995-11-30 00:00 UTC (permalink / raw)
Sure, Progress supports SQL to some degree, but you're right that it's
never the main focus of the product. As far as learning with it goes, I
spent a year writing Progress programs before taking any database theory
courses, and when I did I found that I already knew all the material
(except the trivialities of SQL syntax) from having worked with it, so as
far as I'm concerned it's an excellent learning tool for the subject.
Now, if I was going to teach SQL specifically, I probably would use some
PC based, smaller SQL package rather then one of the biggies. It's easy
to get spoiled by having non-SQL stuff available to you; I know it's
very difficult to go back to just about any other method after using the
Progress 4GL to write programs in, I just get disgusted at how much more
difficult some things are.
--
* Greg Smith gsmith@westnet.com Baltimore, MD
* Computer consultant, speaker builder, rock music fanatic
* Check out http://www.westnet.com/~gsmith for information about
* the Progress 4GL/RDBMS and UnixWare/NetWare connections
^ permalink raw [nested|flat] 4+ messages in thread
* Re: Is Progress Good for Teaching Database Subjects?
1995-11-30 00:00 Is Progress Good for Teaching Database Subjects? John Olle <J.Olle@bendigo.latrobe.edu.au>
@ 1995-11-30 00:00 ` mcolton@illustra.com
2 siblings, 0 replies; 4+ messages in thread
From: mcolton@illustra.com @ 1995-11-30 00:00 UTC (permalink / raw)
In article <49j19i$l9f@sheoak.bendigo.latrobe.edu.au>, John Olle
<J.Olle@bendigo.latrobe.edu.au> wrote:
> I teach a number of database subjects [ ...]
> My question, as the heading states is: Is Progress good for teaching database
> subjects?
>
> I have no intention of teaching Progress per se. I never taught Unify
and I don't
> teach Ingres. My concern is to teach database, mainly relational database.
> [ ... ]
G'Day John,
I read your message about teaching RDBMS concepts at Latrobe. Given your
reservations about Progress, I gather it is being pushed on you for
political or budgetary reasons. Two products you might like to consider
instead are Postgres (which unfortunately uses Post-Quel as its query
language, but on the other hand, the product is free) and Illustra, which
is the SQL-3 based productization of Postgres. Let me hasten to add that I
am no disinterested spectator to this discussion: I work for Illustra.
The value of using something like Illustra is that it has all the
classical RDBMS features but extends relational DBMS into the object
world. With Illustra, you can create abstract datatypes of arbitrary
complexity and use them to create columns in tables. You can also store
the methods that manipulate these datatypes in the DBMS, where they become
extensions to the SQL language, a la SQL-3. In our view, this is the
future of RDBMS technology, and many industry analysts agree. See for
example, the Dec 1995 issue of DBMS Programming and Design, the Seybold
Distributed Computing monitor, Vol 10, No 2 of Feb 1995. Gartner Group has
also said nice things about us, but I don't have the ref to hand. In the
Sep IEEE Computer special issue on image management, the keynote article
describes the requirements for a true image management system, and could
have been taken from our collateral. There is also a lot of information on
our web page at www.illustra.com.
If you would like more info, please email me at mcolton@illustra.com.
- malcolm
--
Malcolm Colton
Director of Multimedia mcolton@illustra.com
Illustra Information Technologies http://www.illustra.com
1111 Boradway, Suite 2000 (510)869-6377
Oakland CA 94607
^ permalink raw [nested|flat] 4+ messages in thread
* Re: Is Progress Good for Teaching Database Subjects?
1995-11-30 00:00 Is Progress Good for Teaching Database Subjects? John Olle <J.Olle@bendigo.latrobe.edu.au>
@ 1995-12-01 00:00 ` peter@prospect.anprod.csiro.au
2 siblings, 0 replies; 4+ messages in thread
From: peter@prospect.anprod.csiro.au @ 1995-12-01 00:00 UTC (permalink / raw)
If you need SQL (and I think you do), the answer is NO. Progress SQL is
only at ANSI 89 (not even 92 Entry Level) and is notoriously buggy. The
server engine doesn't have dictionary-level referential integrity
enforcement, triggers or stored procedures.
Progress has a very good record (ie row) oriented 4GL which is excellent
for dealing with real-world data but if you want to teach set theory and
encourage your students to think of databases in terms of information
sets, Progress is a poor choice.
Look at Interbase from Borland. This is SQL 92 and a pretty good product
for teaching. I wouldn't want to build a gigabyte level production
database with it but for the price and in a teaching environment, it's
tops. Especially if you get Delphi which will include a local Interbase
server at student-level prices so they can play at home.
Peter Wiley
^ permalink raw [nested|flat] 4+ messages in thread
end of thread, other threads:[~1995-12-01 00:00 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-11-30 00:00 Is Progress Good for Teaching Database Subjects? John Olle <J.Olle@bendigo.latrobe.edu.au>
1995-11-30 00:00 ` gsmith@westnet.com
1995-11-30 00:00 ` mcolton@illustra.com
1995-12-01 00:00 ` peter@prospect.anprod.csiro.au
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox