HDTenEightyP/NetNews huggingface dataset:
From: yoly@vax2.concordia.ca (YOLY YOUNG, MANAGER SOFTWARE GROUP)
Newsgroups: comp.databases
Subject: ROSS RDB site
Keywords: ROSS, Rdb
Date: 10 Apr 92 19:39:00 GMT
Distribution: usa
Organization: Concordia University
News-Software: VAX/VMS VNEWS 1.41

I would like to contact other ROSS sites with the RDB version of their
software.  The intention is basically to compare notes and possibly get a
few answers to some of our questions.  If you are such a site, then I would
very much like to talk to you.  I may be contacted in any form
indicated in my signature, after which I will contact you by phone.
Thank you in advance.
===========================================================================
Yoly Young                        e-mail: yoly@vax2.concordia.ca
Concordia University              voice:  (514) 848-7620
Computing Services                fax:    (514) 848-7622
1440 St. Catherine Str.
Montreal, Quebec 
Newsgroups: comp.databases
From: dtk@kepler.unh.edu (David T Kao)
Subject: *** Postgres ***
Organization: University of New Hampshire  -  Durham, NH
Distribution: usa
Date: Fri, 10 Apr 1992 00:33:11 GMT

What is the most recent version number of Postgres? Where can
I get a copy of it (either ftp or tape)? Thanks.


-- 
----------------------------------------------------------------
David T. Kao       dtk@cs.unh.edu  | This space is available for
                   (603) 659-2737  |           rent.
----------------------------------------------------------------
From: daz@csc.liv.ac.uk (Mr. D.S. Imrie)
Newsgroups: comp.databases
Subject: information wanted
Date: 7 Apr 92 10:05:41 GMT
Organization: Computer Science, Liverpool University
Nntp-Posting-User: daz

Can anyone send me any references on the use of binary relational 
databases?  Especially useful would be their application to the areas
of speech or vision processing, but any info. is greatly appreciated.

Many thanks,

Darren Imrie,
Department of Computer Science,
University of Liverpool.

E-Mail: daz@uk.ac.liverpool.dcs
From: SMITHBS@PURCCVM.BITNET (Barry Smith)
Newsgroups: comp.databases
Subject: Network data model (IDMS/Focus) - what is it?
Date: 12 Apr 92 14:07:39 GMT
Organization: Purdue University

I will be working for GEIS this summer and want to "study up" on some
concepts I will be dealing with.  Does anyone have any documents on
what a Network Data Model is?  I will be working with this model in IDMS
and Focus.
From: cimshop!davidm@uunet.UU.NET (David S. Masterson)
Newsgroups: comp.databases
Subject: Re: E-R modelling ?= 5th Normal Form
Date: 6 Apr 92 22:23:45 GMT
	<1992Apr1.222033.29624@cs.sfu.ca>
	<1992Apr2.155043.13129@pmafire.inel.gov> <626@6sigma.UUCP>
Distribution: comp
Organization: Consilium Inc., Mountain View, California
In-reply-to: clif@6sigma.UUCP's message of 3 Apr 92 18:05:52 GMT
X-Posting-Software: GNUS 3.13  [ NNTP-based News Reader for GNU Emacs ]

>>>>> On 3 Apr 92 18:05:52 GMT, clif@6sigma.UUCP (Clif McLaurin) said:

> I believe, though I wait to be corrected :-), that business rules are really
> a part of the application, not of the data model.  Business rules help
> clarify the flow and control of the application through implementation of
> those rules.  They seem necessary only at a very high level, which the
> data model proper is not.

The database should represent the central repository of information on *all*
of a business's applications.  Therefore, any knowledge that is business wide
should be collected and managed in this central repository as well.  This
prevents different applications from developing their own rules of dealing
with the data model that are mutually conflicting.  The data model, therefore,
as the high level representation of the database, should also express the
rules for dealing with the data (the data model is a very high level
representation).

--
====================================================================
David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
uunet!cimshop!davidm				Mtn. View, CA  94043
====================================================================
"We will rediscover a [New York City] river so extravagantly polluted that new
 life forms will emerge from it spontaneously, demanding welfare and voting
 rights."
-- Douglas Adams
From: cis01643@stat.appstate.edu
Newsgroups: comp.databases
Subject: Native American Databases?
Date: 16 Apr 92 00:53:47 GMT
Organization: Appalachian State University

Are there any databases dealing with Native Americans?  If so, please provide
Internet address.  Thamks.
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Newsgroups: comp.databases
Subject: Sybase Open Gateways ... experiences.
Date: 15 Apr 92 02:56:36 GMT
Organization: MIND LINK! - British Columbia, Canada
Distribution: world

I'm sussing out a project that would integrate a Sybase SQL server
with a database we developed in-house -- a sort of humongous
three-dimensional spreadsheet. Simply migrating the data to Sybase
is not an option --- 20Mb ballooned out to 600Mb when I tried a
non-normal conversion, and the normalized version would have been
truly horrid. I have a "select" verb parser, and I would like to
make the tables accessible to Sybase users; i.e. allow joins,
etc. As far as I can tell, if Sybase (the company) itself implements
bridges to foreign db's accessible at the join level, then there is
a protocol SOMEWHERE as to how the server addresses low-level queries
to some other Open Server. Does anyone know how this is done?
Has anyone had experience with it? After some dismal responses
from Sybase Tech Support (sorry, Sean) regarding pretty basic stuff
(finding onesself explaining the difference between a key and an
index, and no, primary keys are not the same as clustered indices),
I'd like to solicit information from a broader readership.
Many thanks in advance.
--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
From: adf@cs.utexas.edu (Angela Dappert-Farquhar)
Newsgroups: comp.databases
Subject: schema integration
Date: 7 Apr 1992 07:46:20 -0500
Organization: CS Dept, University of Texas at Austin
NNTP-Posting-Host: earth.cs.utexas.edu

I would like to get some hands-on experience in integrating
independently modelled databases that cover related applications.

Please let me know if you know of any databases that model realistic
applications that I could access for that purpose.

   Thank you,

     Angela

----------------------------------------------------------------
Angela Dappert-Farquhar                        adf@cs.utexas.edu
Department of Computer Sciences                   (512) 471-9576
Taylor Hall 2.124
The University of Texas at Austin
Austin, TX 78721
From: zdeng@cis.umassd.edu (Zhan Deng)
Newsgroups: comp.databases.ingres
Subject: Need FAQ of this group
Date: 17 Apr 92 20:44:56 GMT
Organization: University of Massachusetts Dartmouth


	I am beginner of Ingres. Is there a FAQ available in any sites? 
So I could ftp it.
	Thanks

Deng.
Newsgroups: comp.databases.ingres
From: godfrind@ricard.enet.dec.com (Albert Godfrind)
Subject: Re: Features Ultrix/SQL (Ingres 6.2)
Organization: Digital Equipment Corporation, Valbonne, France
Date: Fri, 17 Apr 1992 13:21:56 GMT


In article <1992Apr15.130028.54510@cc.usu.edu>, sljn6@cc.usu.edu writes...
> 
>I got a copy of Ultrix/SQL  S/W.  but have not got all the manuals
>etc. The operations manual says the release is based on Ingres 6.2
>I was wondering as to what all features of Ingres  does the Ultrix/
>SQL support.  I could see that as far as architecture is concerned
>it is almost ingres but I could not locate the 4GL features and 
>vifred (or any other form's editor).  Besides I would like to know
>what all Language interface's does this provide.(3GL)

Ultrix/SQL 1.0 (the one you get with Ultrix 4.0 and 4.1) is Ingres 6.2. With
Ultrix 4.2, you will get Ultrix/SQL 2.0, which is Ingres 6.3

As you noticed Ultrix/SQL is Ingres with some repackaging - but it is only the
database engine. As such it only allows you to run applications that you
already have developped. If you want the 4GL and other tools, you will have to
buy them from Ingres (just make sure to ask for the Ingres tools for
Ultrix/SQL). The same is true for the precompilers - but those you can either
buy from Digital or Ingres
--
Albert Godfrind                            
Digital Equipment Corporation      INET:  godfrind@beagle.enet.dec.com
European Technical Center                 Albert.Godfrind@vbo.mts.dec.com
BP 027                             Voice: [+33] 92.95.51.63
F-06901 Valbonne, France           FAX:   [+33] 93.65.34.24
Those are my views, not my employer's
Newsgroups: comp.databases.ingres
From: thomasl@mtl.mit.edu (Thomas J Lohman)
Subject: metering ingres
Organization: MIT Microsystems Technology Laboratories
Date: Mon, 13 Apr 1992 21:59:38 GMT


We've been running an application which uses Ingres 6.3/01
on a Sun SPARC station 2 running OS4.1.1.  Ingres is actually
a NFS Mount installation setup.  We're wondering what tools are available
to meter Ingres' performance because lately there have been times
when the application has been quite slow when in the past it has
been quite fast.  Basically we want to do some benchmark analysis
in order to determine what could be slowing it down.  We have many layers
of software running including a homegrown object oriented system which
runs atop of Ingres, and a LISP interface, which are both used by our
application to do database access.


--tom
From: salnick@dejavu.spk.wa.us (Bob Salnick)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres/Net Management
Date: 16 Apr 92 06:16:15 GMT
Organization: Not Organized

In article <1992Apr09.031257.3095@demon.co.uk> rayt@cix.compulink.co.uk (Ray
Turner) writes:
>
>Does anyone know of any tools, or ideas for tools to manage Ingres/Net
>configuration for 100+ users. If you set up global vnodes its not to
>bad, but if you want each user to be connected with his/her own logon
>you have to run netu from each user account. This seems to be a
>management nightmare as the netu passwords have to be kept in step
>with the unix passwords.
>
>Ray
>
>rturner@cix.compulink.co.uk

I submitted a SIR on this last summer.  Basically asking Ingres to use the
mechanism buried inside the -u flag to pass the username returned by
username() to the remote backend.  This way, a single guest account could be
used by all users, and their identities would be preserved at the backend.  I
am told that this is under condideration...

I don't think it would hurt any if you were to add your voice too, if you
think this would be agood idea...

bob
--
Bob Salnick, Spokane,WA |  USENET: oliveb!isc-br!tau-ceti!DejaVu!salnick
  Amiga 1000, WB 1.3    |  INTERNET: salnick@DejaVu.spk.wa.us
      WA9BVE            |
From: rayt@cix.compulink.co.uk (Ray Turner)
Newsgroups: comp.databases.ingres
Subject: Ingres/Net Management
Date: 9 Apr 92 03:12:57 GMT
Reply-To: Ray Turner <rayt@cix.compulink.co.uk>
Organization: Gated to News by demon.co.uk


Does anyone know of any tools, or ideas for tools to manage Ingres/Net
configuration for 100+ users. If you set up global vnodes its not to
bad, but if you want each user to be connected with his/her own logon
you have to run netu from each user account. This seems to be a
management nightmare as the netu passwords have to be kept in step
with the unix passwords.

Ray

rturner@cix.compulink.co.uk
From: hevern@cac.washington.edu (M. Hevern)
Newsgroups: comp.databases.ingres
Subject: Concurrency (was Re: Row level locking?)
Date: 14 Apr 92 22:44:42 GMT
Organization: U.W. Information Systems

In article <5413@otc.otca.oz>, alexk@otc.otca.oz.au (Alex Kowalenko) writes:
> In the ULTRIX/SQL version of Ingres, I haved noticed that there is no row level locking.
> 
> Page locking yes - 2048 bytes of data can be locked at a time, by not at row level. :-(
> 
> Anyone over come this "feature" without making all rows pages?

Here is a solution not yet mentioned. We're using VAX/VMS 5.4-3 and Ingres 6.3/03 (vax.vms/01). Our applications are being developed using Vision, some heavily customized template files, and a few post parsers (6 months of my life).

The way we assure concurrency is by selecting all data available for modification from a row into temporary variables, and when the row is updated we use them all in the where qualification. This way if someone modified a field in a table from a screen that has no effect on the data you were currently working on there would be no adverse effect. If the data was updated by someone else before you got around to updating you would get a message indicating you were out of luck.

This is tedious and painfull for a developper, but Vision does all of the work. It is a bit of a performance damper, but it is full proof. There are no kludes involving filler fields to break the 1024 byte barrier and no bogus control fields.

Your mileage may vary,
-- 	MH
       *--------------------------------*------------------------------*
       | Michael Hevern			| Voice: (206) 685-3229        |
       | University Of Washington	| * "I can't dance...          |
       | Information Systems		|    I can't talk...           |
       | 4545 15th Ave. NE		|    The only funny thing about|
       | Seattle, WA 98105		|    me is the way I walk."    |
       | Mail Stop: JE-41               |       -- Genesis             |
       *--------------------------------*------------------------------*
	Disclaimer: If I said it I probably meant it.  My employer isn't
		responsible for my opinions.
Newsgroups: comp.databases.ingres
From: eric@brolga.cc.uq.oz.au (Eric Halil)
Subject: Security of setuid W4GL frame?
Organization: Prentice Centre, University of Queensland
Date: Mon, 13 Apr 1992 23:55:03 GMT

Hi,

I'm working on a Windows 4GL frame which is effectively a Unix login frame to
run on a Sun4 (SunOS 4.1.2).  You enter a user name/password and if successful
I do a setuid() to the correspinging uid.  This program, of course, needs to be
setuid root to work.  

My setup in a bit more detail:  There are only two fields on my frame.
One each for user name and password.  They are simple text fields.
There are two buttons, 'Quit' and 'Continue' (which checks the password
and changes uid if OK).  People will also be able to change their
passwords from this frame.  User name/passwords are kept in /etc/passwd
(i.e. they are standard Unix logins).

I'm wondering about how secure such a setuid root frame would be???  I'm not
very familar with W4GL but I can see some possible problems.  Is it possible to
start up an editor from the described setup?  What about the heaps of
environment variables that Ingres has (and possibly setting them to
mischievious values).

Any other problems/comments/suggestions would be very welcome!

Thanks,
Eric.
--
Eric Halil                           |Internet/CSnet:         eric@cc.uq.oz.au
Prentice Centre                      |Bitnet:    eric%cc.uq.oz.au@uunet.uu.net
University of Queensland    4072     |UUCP:        uunet!munnari!cc.uq.oz!eric
AUSTRALIA --   Phone: +61 7 365 3610 |JANET:        eric%cc.uq.oz.au@uk.ac.ukc
Newsgroups: comp.databases.ingres
From: mmr@asgserver.canberra.edu.au (Micheal Rainford-Watson)
Subject: Compressing Checkpoints
Keywords: checkpoint compress
Organization: University of Canberra
Date: Tue, 7 Apr 92 08:24:40 GMT


Has anyone tried compressing their checkpoints as it's being created.
ie by editing the ../files/cktmpl.def file and running it through
a compression program or by using a different backup program which
has a compression feature. We aren't interested in compressing the 
checkpoint after it's been created.

We are running INGRES 6.3/01 on Unix (Dynix V3.0)


Newsgroups: comp.databases.ingres
From: jwp@chem.ucsd.edu (John Pierce)
Newsgroups: comp.databases.ingres
Subject: Re: Row level locking?
Date: 16 Apr 1992 16:53:24 GMT
Organization: Chemistry Dept, UC San Diego
NNTP-Posting-Host: chedccf0.ucsd.edu

cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes:
 > 3. ... UPDATE so that its WHERE clause includes all of the original data
 > that was SELECTed, and any data that will be UPDATEd, as Michael Hevern
 > has suggested.

This was the route I took in building our "quasi-generic" table editor
that allows master-to-many-detail views of our admin database.  The
performance doesn't seem to be too bad, and getting around the really
idiotic restriction of having only a single master-detail structure is
more than worth the pain.  Given xterminals, I can put up *everything*
we care about on an employee in a single 132x54 window containing a
simple-field "master record", and two simple-field and 6 table-field
detail records; no switching between forms for users, etc, and applying
the generic part to a new set of tables takes maybe a week of building
the data-specific initialization for the structures involved.

-- John Pierce, Chemistry, UC San Diego
   jpierce@ucsd.edu
Newsgroups: comp.databases.ingres
From: leath@atlas.cs.upei.ca (Stephen Leath)
Subject: Re: Concurrency (was Re: Row level locking?)
Organization: University of Prince Edward Island
Date: Wed, 15 Apr 1992 11:30:21 GMT

In article <1992Apr14.224442.25890@u.washington.edu> hevern@cac.washington.edu (M. Hevern) writes:
>In article <5413@otc.otca.oz>, alexk@otc.otca.oz.au (Alex Kowalenko) writes:
>> In the ULTRIX/SQL version of Ingres, I haved noticed that there is no row level locking.
>> 
>> Page locking yes - 2048 bytes of data can be locked at a time, by not at row level. :-(
>> 
>> Anyone over come this "feature" without making all rows pages?
>
>Here is a solution not yet mentioned. We're using VAX/VMS 5.4-3 and Ingres 6.3/03 (vax.vms/01). Our applications are being developed using Vision, some heavily customized template files, and a few post parsers (6 months of my life).
>
>The way we assure concurrency is by selecting all data available for modification from a row into temporary variables, and when the row is updated we use them all in the where qualification. This way if someone modified a field in a table from a screen th
>at has no effect on the data you were currently working on there would be no adverse effect. If the data was updated by someone else before you got around to updating you would get a message indicating you were out of luck.
>
>This is tedious and painfull for a developper, but Vision does all of the work. It is a bit of a performance damper, but it is full proof. There are no kludes involving filler fields to break the 1024 byte barrier and no bogus control fields.
>

How does this get around page locking, does it not only postpone it to a
later date. ? If so why not save the updates in script form and perform them
in order later. ?

Steve
From: rudomet@eltamin.usc.edu (Steve Rudometkin)
Newsgroups: comp.databases.ingres
Subject: Re: XView vs Windows 4GL - SUMMARY
Date: 15 Apr 1992 15:41:50 -0700
Organization: University of Southern California, Los Angeles, CA
Distribution: na
NNTP-Posting-Host: eltamin.usc.edu

In article <74107@netnews.upenn.edu> jarnot@kin.lap.upenn.edu (Kevin J. Jarnot) writes:
>Here's the summary posting that many of you asked for regarding my question
>about implementing embedded SQL in XView vs Windows 4GL.
>
>Well, it seems that Windows 4GL has many fans out there.  The overwhelming 
>majority of responses were in favor of implementing X/Ingres projects with
>W4GL as opposed to C with an X library...
>
>
>W4GL - 
>Pro: 

[...] yes, I agree.  I am learning it all from scratch with no help.

>Con:
>	+ Only Motif - no OpenLook

I am developing applications that will run on both X11 and Openwindows.

Windows 4gl works with OpenLook.  I have been using Windows4gl on X11 (twm) and
on Openwindows-2 and Openwindows-3 (olwm) on Sun Elc and 490.   There are a
few differences between the way things work.  One difference is that the Sun4 
keypad arrow keys  don't work on Openwindows-2 (works on openwin-3).  Another 
difference is the size of the fonts between the 2 systems which makes the 
Openwindows forms appear smaller.

>	+ Heavy on system resources
>	+ Limited to whatever X resources are provided with it
>	+ Slow application start-up time

I feel in general that Openwindows itself has a slow startup time.  It does 
take more time to run in Openwindows vs X11.  When I switched some of our 
users from Sunview to Openwindows they thought something was wrong because
it took so much longer!

-- 
Steve Rudometkin                            ,__o              |]]]]]]]]]]|
University Computing Services             _-\_<,              |          |
University of Southern California   .... (*)/'(*)             |          |
Los Angeles CA 90089-0251           (213)740-2870        rudomet@skat.usc.edu
From: rayt@cix.compulink.co.uk (Ray Turner)
Newsgroups: comp.databases.ingres
Subject: 100+ User MIS Servers
Date: 9 Apr 92 03:12:37 GMT
Reply-To: Ray Turner <rayt@cix.compulink.co.uk>
Organization: Gated to News by demon.co.uk


I am trying to find out what size machines people are using to
support 100+ Ingres users running MIS type applications. This
would just be for the database server, with front end applications
connected via Ingres/Net.

Is a large single processor box better than a multi-processor?

How much dmf cache do you find useful to set up?

How many different disk spindles do you have?

What are the major issues in running a large Ingres system.

Ray

rturner@cix.compulink.co.uk