HDTenEightyP/NetNews huggingface dataset:
From: draper@ais.org (Patrick Draper)
Subject: Network vs. Relational
Organization: UMCC
Date: Tue, 15 Sep 1992 17:59:54 GMT

Hi,

can someone run down the distinctions between network and relational
databases? I'm mostly familiar with relational model databases, and I can't
quite grasp how a network model is different.

If you've got a good reference to a book or something, that would also be
helpful.

Thanks,

------------------////////////////////\\\\\\\\\\\\\\\\\\\\------------------
| Patrick Draper           Disclaimer:  I can't control my fingers,        |
| draper@umcc.ais.org                   I can't control my toes! - Ramones |
| University of Michigan Computer Club                                     |
NO CARRIER                     We are a nation of laws, not people         |
------------------\\\\\\\\\\\\\\\\\\\\////////////////////------------------
Newsgroups: comp.databases
Date: Sat, 12 Sep 1992 00:17:27 -0400 
From: Massimo Bigliardo <mb7r+@andrew.cmu.edu>
Subject: IMI and temporal DB's

In the New York Times of Sunday Aug. 20th there was an article (p. 8
-Economics) a new DB for the Stocking Exchange Market, called IMI (Magic
Information Machine) developed by Logical Information Machines Inc.
Does anyone have detailed information?
And for that matter, does anyone knows if it is a temporal DB?
I am also collecting info on temporal DB's, and I found several papers
(7), most of which were a bit "too technical". I am interested in 
applications, future expandabilty on the theme "temporal ..." . I know
that the last Computing Surveys (Vol.23, no. 4) had a paper on temporal
database, but I couldn't find it.
Thank you
Massimo
From: copler@moose.cs.indiana.edu (judith copler)
Newsgroups: comp.databases
Subject: WORKSHOP ANNOUNCEMENT--RELATIONAL DATABASE ADMINISTRATION
Date: 14 Sep 92 22:39:13 GMT
Organization: Computer Science, Indiana University
X-Mailer: Mail User's Shell (7.2.3 5/22/91)


ANNOUNCEMENT of WORKSHOP

Relational Database Administration & Management

Friday, Oct 9, 1992
8:30AM - 4:30PM
Market Tower Conference Center, Indianapolis, IN

WORKSHOP OBJECTIVE

All participants should gain and understanding of the tasks
associated with database administration and management, the options
available for database back-up and recovery, the elements of
successful data securty and integrity policies, the measures
required to eliminate downtime and ensure efficient applications, 
and successful strategies for dealing with database vendors.  
Examples will focus on comparing and contrasting database
administration tasks and options associated with commercial
products such as DB2, Ingres, Oracle and Sybase.

Instructor:  Nancy Martin

Sponsored by the Indiana Center for Database Systems (Indiana
University/ Purdue University)

For more information contact:

Hallie Rose, Assistant to the Director
Indiana Center for Database Systems
812-855-2490
Newsgroups: comp.databases
From: durai@ORTTA (Appadurai V.)
Subject: Re: dbf format
Organization: U of Mn
Date: Wed, 9 Sep 1992 17:11:17 GMT

There was a request for dbf and index formats:

The following information is from Foxpro Developers Guide (Fox Software):
(Appendix B)


.dbf structure

A database file is made up of a header record and data records.  The header 
record defines the structure of a database and contains any other 
information related to the database.  It starts at file position zero.

The data records* follow the header, in consecutive bytes, and contain the 
actual text of the fields.  The length of a record, in bytes, is determined 
by summing the defined lengths of all fields.  Numbers in this file are 
represented in reverse bytes.

Data File Header Record:

Bytes   Description
00	Foxbase+/dbase III+, without memo:  0x03
	                     with memo   :  0x83
	Foxpro/dbase IV, without memo    :  0x03
	Foxpro, with memo                :  0xF5
	dbase IV, with memo		 :  0x8B
01-03   Last update (yymmdd)
04-07	Number of records in file     
08-09   Position of first data record
10-11	Length of one data record (including delete flag)
12-31	Reserved
32-n	Field subrecords**
n+1	Header record terminator (0x0D)

Field Subrecords***

Bytes	Description
00-10	Field Name (max 10 chrs - if less than 10, padded with null
		    chr (0x00))
11	Data Type (C: Chr, N: Num, L: Logical, M: Memo, D: Date)
12-15	Displacement of field in record
16	Length of field (in bytes)
17	Number of decimal places
18-32	Reserved

Notes
* The data in the data file starts at the position indicated in bytes 08-09 
of the header record.  Data records begin with a delete flag byte.  If this 
byte is an ASCII space (0x20) the record is not deleted; if the first byte 
is an asterisk (0x2A) the record is deleted.  The data from the fields named 
in the field subrecords follows the delete flag.

** The number of fields determines the number of field subrecords.  

*** Limitations on characters per record, max fields, etc are defined in the 
System Capacities section of the appendix.


.idx format

The manual deals quite comprehensively the different index formats.  Please 
refer to the book for the discussion.  < i might be violating copyright 
privileges here, if i reproduced the entire text, and secondly, its too 
lengthy a discussion. >



Newsgroups: comp.databases
From: francois@welchgate.welch.jhu.edu (Francois Schiettecatte)
Subject: oracle full text retrieval system
Organization: Johns Hopkins Univ. Welch Medical Library
Date: Sun, 13 Sep 1992 16:07:27 GMT

Hi

I remember seing some documentation and brochures for an oracle
full(?) text retrieval system about 3 years ago. I think it may
be called sql*text or oracle*text. I also think that the front-end
to it was built using sql*forms btu I am not sure. Does anyone have
any information about it, or even better does anyone use it. If there
is interest, I will post a summary back to the group.


thanks


francois


francois@welchgate.welch.jhu.edu


Newsgroups: comp.databases.ingres
From: Gavin Trigg <gavin@asis.unimelb.EDU.AU>
Subject: Re: Manually waking the archiver?
Organization: National Radio Astronomy Observatory
Date: Thu, 10 Sep 1992 21:29:17 GMT

> 
> So how does one manually wake up the archiver to start
> moving entries from the log file to the journal file?
> 
> One of our nodes has a 1 GB (yes, gigabyte) log file.  We are running
> 6.3/03 (vax.vms/01), and under this version, the smallest increment
> that will wake up the archiver is five percent of the log file.
> Occasionally we need to view recent transactions using AUDITDB, but we
> have to wait until an archiver wake-up.  As this node is a research and
> development machine, the time it takes reach the five percent varies
> greatly.
> 
> Isn't there a TRACE POINT that will force a wake-up?  I am aware that
> 6.4/01 will allow smaller increments, but even at one percent, we
> could be waiting a while.
> 
> FWIW, we're running VMS 5.4-2.
> 
>   Michael
> 
> Michael D. Shields      |  Internet: michael@cutler.com
> AVP, MIS                |  UUCP: ...hplabs!hp-pcd!orstcs!cutler!michael
> Cutler & Company, Inc.  |  Voice: (503) 770-9000
> Medford, OR  97504      |  FAX: (503) 779-0006
> 
Michael,

If your interested in records for a particular data base you could try
something like

sql foo << BAR
create view foo as select * from bar;
rollback
\p\g
BAR

which will cause a PURGEDB (and Consistency point?) to be taken.

-- 
Gavin Trigg	Internet: gavin@asis.unimelb.EDU.AU
		Telephone: +61 3 344 6003 	Fax +61 3 347 4803
Data Base Administrator, Information Technology Services (ASIS),
The University of Melbourne, Parkville, Australia.  3052.
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: QBF won't let me append thru a view?
Organization: Palmer & Associates, Inc.
Date: Fri, 11 Sep 1992 01:50:04 GMT

I belive I remember trying to append to a view through QBF and got the same
result.  I am on the road now so I don't have any way to verify this, but
I seem to remember that QBF makes an explicit check to see if you are using a
view and prevents you from appending/updating, even if it is a simple view.

The other thing that comes to mind is that you should check to see if the view
was created with the option that prevents inserting or updating a column if
that column appears in the view select where clause.  INGRES in general will
prevent the insert/update attempt if the view was created with this option
(I believe it is called "nocheck" option, but my memory is playing tricks on
me today).


-- 

Steve Caswell           |   (404) 448-7727    |  "The opinions expressed are my
Principal Consultant    |   sfc@tpghq.com     |   own.  They may not be perfect,
The Palmer Group        |   uunet!tpghq!sfc   |   but they're all I've got."
Newsgroups: comp.databases.ingres
From: Glenn Stauffer <stauffer@cc.swarthmore.edu>
Subject: Re: Need info on UNIX relational databases
X-Xxmessage-Id: <A6D1E5A64701433A@mac8.beardsley.swarthmore.edu>
X-Xxdate: Tue, 8 Sep 92 10:07:50 GMT
Organization: Swarthmore College Computing Center
X-Useragent: Nuntius v1.1.1d9
Date: Tue, 8 Sep 1992 09:08:20 GMT

In article <lanmsiINN2j2@jethro.Corp.Sun.COM> Jon Roland,
jdr@starflight.Corp.Sun.COM writes:
>Ingres Corporation
>1080 Marina Village Parkway
>Alameda, CA 94501 USA
>510/769-1400
>Ingres Relational DBMS
>SQL-based RDBMS
>
>Oracle Corporation
>500 Oracle Parkway MD 40P-690
>Redwood Shores, CA 94065 USA
>415/506-7000
>Oracle
>SQL-based RDBMS
>

I am currently being presented with a choice between these two products 
for installation on our Ultrix systems.  At the moment, our interest is 
not based on a particular application, but on the installation of one of 
these products to explore its use for internally developed applications 
and, most importantly, for educational purposes.  Our desktop machines
are 
all Macintosh, so support on that end plays a big part (in this respect,
I 
know that Oracle offers many MacOS products - I don't know how well they 
work in practice).

Any tips on the relative advantages/disadvantages of either product 
especially relative to performance, market penetration, and support for 
Macintosh workstations would be much appreciated.

If anyone can point to any recent publications carrying a comparison 
between these products or a review of one or the other, that would be 
very helpful and save you some typing.

Glenn Stauffer
Swarthmore College Computing Center
Newsgroups: comp.databases.ingres
From: rana@cs.uwa.oz.au (Ranadeva Peries)
Subject: Ingres FRS (Forms) question
Summary: Ingres FRS help needed
Keywords: FRS, File Descriptors
Organization: Dept. Computer Science, University of Western Australia.
Date: Tue, 15 Sep 1992 09:42:16 GMT

Hi,

   How does INGRES FRS determine the output stream for
   it's forms display.

   I would like to run an Ingres forms application within a 
   XVIEW tty subwindow (similar to a Sun Shelltool or cmdtool).
   This requires me to set up the file descriptors so that
   INGRES FRS knows which FDs to use.

   Thanks in advance for any help.

   Please send replies to the following address.
_________________________________________________________________________
 Ranadeva Peries (Rana)               |  Internet:  rana@cs.uwa.oz.au
 Department of Computer Science       |
 The University of Western Australia  |  
 Nedlands 6009,                       | Tel: +61-9-3802878 
 W. Australia.                        | FAX: +61-9-3801089
_________________________________________________________________________
Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: INGRES/VMS
Organization: U.S Dept. of Transportation
Date: Fri, 4 Sep 1992 12:54:45 GMT

akk9180@ritvax.isc.rit.edu writes:

>We are currently running INGRES on DECstation 5000s under ULTRIX.  We
>are seriously evaluating a platform/o.s. change.  VAX/OPEN VMS.  SUN.
>Long term we are planning on Alpha/OSF.  However, we are going to
>need more horsepower before DEC will be ready with or we will be
>comfortable with Alpha/OSF.  How about some feedback from some users
>about their platforms.  We would need connectivity with our other DECstation
>file servers serving Pathworks (TCP or DECNET).  Thanks!

You should consider getting a VAXstation 4000/90.  It's a workstation,
but it has the same chipset as the VAX 6000/610 and is rated at about
90% (I don't remember exactly) of an HP 9000, something like 30 times
a VAX-11/780.  There were rumors/news that DEC was going to sell an
8 user license with it, which is probably enough if you've been running
on a DECstation 5000.  Best of all, it's supposed to be board-swap
compatible with Alpha -- it has a very promising upgrade path -- and
it's comparatively cheap.  Obviously, you could use Pathworks.

One thing about Sun:  Ingres/Net doesn't work with DECnet for the Sun.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Sciences Group (U.S. Dept. of Transportation)
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Manually waking the archiver?
Organization: Palmer & Associates, Inc.
Date: Fri, 11 Sep 1992 02:03:33 GMT

I don't know of a trace point that will do this, but you can easily do this
by using the ckpdb utility.  The ckpdb utility has to drain the log file before
the checkpoint is taken, so it drains the log file.  If you don't want to
run a real checkpoint, you can get around this by altering the ckeckpoint
command procedures.  Remember that the ckpdb utility actually calls a set of
.COM files to run the actual checkpoint.  You could modify these command
procedures to look for existence of a logical name or file on disk or some
other method of communication.  If the procedure finds the logical name, it
simply skips the actual backup command.  Then when you want to just drain
the log file, create the logical name and run the checkpoint utility, not
forgetting to unset the logical name when finished.

-- 

Steve Caswell           |   (404) 448-7727    |  "The opinions expressed are my
Principal Consultant    |   sfc@tpghq.com     |   own.  They may not be perfect,
The Palmer Group        |   uunet!tpghq!sfc   |   but they're all I've got."
From: copler@moose.cs.indiana.edu (judith copler)
Newsgroups: comp.databases.ingres
Subject: WORKSHOP ANNOUNCEMENT--RELATIONAL DATABASE ADMINISTRATION
Date: 14 Sep 92 22:39:13 GMT
Organization: Computer Science, Indiana University
X-Mailer: Mail User's Shell (7.2.3 5/22/91)


ANNOUNCEMENT of WORKSHOP

Relational Database Administration & Management

Friday, Oct 9, 1992
8:30AM - 4:30PM
Market Tower Conference Center, Indianapolis, IN

WORKSHOP OBJECTIVE

All participants should gain and understanding of the tasks
associated with database administration and management, the options
available for database back-up and recovery, the elements of
successful data securty and integrity policies, the measures
required to eliminate downtime and ensure efficient applications, 
and successful strategies for dealing with database vendors.  
Examples will focus on comparing and contrasting database
administration tasks and options associated with commercial
products such as DB2, Ingres, Oracle and Sybase.

Instructor:  Nancy Martin

Sponsored by the Indiana Center for Database Systems (Indiana
University/ Purdue University)

For more information contact:

Hallie Rose, Assistant to the Director
Indiana Center for Database Systems
812-855-2490
From: michael@cutler.com (Michael D. Shields)
Newsgroups: comp.databases.ingres
Subject: Manually waking the archiver?
Date: 9 Sep 92 20:22:29 GMT
Article-I.D.: cutler.1992Sep9.132229.292
Organization: Cutler & Company, Inc., Medford OR (503) 770-9000

So how does one manually wake up the archiver to start
moving entries from the log file to the journal file?

One of our nodes has a 1 GB (yes, gigabyte) log file.  We are running
6.3/03 (vax.vms/01), and under this version, the smallest increment
that will wake up the archiver is five percent of the log file.
Occasionally we need to view recent transactions using AUDITDB, but we
have to wait until an archiver wake-up.  As this node is a research and
development machine, the time it takes reach the five percent varies
greatly.

Isn't there a TRACE POINT that will force a wake-up?  I am aware that
6.4/01 will allow smaller increments, but even at one percent, we
could be waiting a while.

FWIW, we're running VMS 5.4-2.

  Michael

Michael D. Shields      |  Internet: michael@cutler.com
AVP, MIS                |  UUCP: ...hplabs!hp-pcd!orstcs!cutler!michael
Cutler & Company, Inc.  |  Voice: (503) 770-9000
Medford, OR  97504      |  FAX: (503) 779-0006
Xref: sparky comp.databases.ingres:1363 comp.databases.informix:1923 comp.databases:6715 comp.databases.oracle:1573
From: hart@andromeda.rutgers.edu (Hart)
Newsgroups: comp.databases.ingres,comp.databases.informix,comp.databases,comp.databases.oracle
Subject: Re: Need info on UNIX relational databases
Date: 14 Sep 92 02:34:59 GMT
Followup-To: comp.databases.ingres
Organization: Rutgers Univ., New Brunswick, N.J.

We have been evaluating SQL RDBMS's very recently and found that DBMS
magazine has articles on both Ingres and Oracle 7(not available until
end of this year or beginning of next year) in Feb 92 and Aug 92
respectively.
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Newsgroups: comp.databases.ingres
Subject: Re: databases & ethics teaching
Date: 8 Sep 92 13:41:39 GMT
Article-I.D.: news.1992Sep8.134139.29787
Organization: Columbia University

In article <1571@eagle.ukc.ac.uk> dl1@ukc.ac.uk (Duncan Langford) writes:
> We are putting together an introduction to computer ethics, to be
> given to third-year computer science students. The 'umbrella' for
> our course is to be the final year database sessions...
> 
> Are there any issues which database specialists feel should be
> particularly addressed in an ethics course? We don't want to  
automatically
> go through the 'hackers' approach, and are badly in need of some
> specialist input from practitioners in the, uh, 'real world'.
> 
> Any suggestions, case histories or comments appreciated!
> 
> duncan langford
> judith wusteman

How about, "Don't use the power of the relational JOIN to learn things
that you shouldn't know about people."  JOINing two different databases
about people (employees, students, customers, etc.) on a common attribute
like the US Social Security Number is an example of this.  Is it really
appropriate to know that two customers on different lists are the same
person?  Maybe yes, maybe no.  Depends on how slimey you are -- as in
Lotus Households or a company called TRW....
/a
Newsgroups: comp.databases.ingres
From: chou@csd.hku.hk (Chou Sui Lin)
Subject: Database Procedure
Organization: National Radio Astronomy Observatory
Date: Sun, 6 Sep 1992 03:17:56 GMT


Sorry for not giving specific details  to the problem. Here is the excerpt
from the errlog.log file after trying to add the database procedure 
via sql.

      ::[1036            , 00ABA040]: Wed Sep  2 18:17:47 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
      ::[1036            , 00744CE0]: Wed Sep  2 18:19:22 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
      ::[1036            , 00ABCE40]: Wed Sep  2 18:22:04 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
      ::[1036            , 00A920C0]: Wed Sep  2 18:25:07 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.
      ::[1036            , 00A920C0]: Wed Sep  2 18:26:08 1992 E_PS0F02_MEMORY_FULL	There is no more available memory. Try again later.

chou@csd.hku.hk
Xref: sparky comp.databases.ingres:1324 comp.databases.informix:1889 comp.databases:6579 comp.databases.oracle:1514
From: vp0o+@andrew.cmu.edu (Victoria Leigh Phillips)
Newsgroups: comp.databases.ingres,comp.databases.informix,comp.databases,comp.databases.oracle
Subject: Need info on UNIX relational databases
Date: 6 Sep 92 14:48:24 GMT
Article-I.D.: andrew.keecese00iUy82XYgq
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA


I am doing a project at CMU for Computer Services.  To be more specific,
they used to have a database on Informix and lost it.  Now they are
asking my group to rebuild it.  However, it is not restricted to
Informix.  They would like it to be a relational database on the UNIX
platform.  The database is to keep track of all computers on campus
including serial numbers, service contract information, etc.  It should
also produce any number of queries for the user.  I was wondering what
else is out there, including the pros/cons and estimated cost of each. 
Any further information would be wonderful, including other sources of
information.  Please reply to vp0o@andrew.cmu.edu.

Thank you,
Victoria Phillips
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: Manually waking the archiver?
Date: 10 Sep 92 06:59:16 GMT

In article <1992Sep9.132229.292@cutler>, michael@cutler.com
(Michael D. Shields) writes:
> So how does one manually wake up the archiver to start
> moving entries from the log file to the journal file?

Try taking an offline checkpoint of a very small (or empty) database
that has journaling enabled.  You always get that message about
"archiver must drain log records...".

> One of our nodes has a 1 GB (yes, gigabyte) log file.

1 gigabyte.  Yow!  You must have some mondo transactions.

> We are running
> 6.3/03 (vax.vms/01), and under this version, the smallest increment
> that will wake up the archiver is five percent of the log file.

Maybe iibuild won't accept a smaller value, but what if you do
"rcpconfig/init" manually?  Will _it_ take you down to 1%?  Or you could
edit ii_system:[ingres]iircpconfig.com_<node> directly, and then run
iistartupinit.com.  Don't forget to get a clean shutdown first.

> Occasionally we need to view recent transactions using AUDITDB, but we
> have to wait until an archiver wake-up.  As this node is a research and
> development machine, the time it takes reach the five percent varies
> greatly.
>
> Isn't there a TRACE POINT that will force a wake-up?  I am aware that
> 6.4/01 will allow smaller increments, but even at one percent, we
> could be waiting a while.

I think trace points operate exclusively on the dbms server, while what
you're looking for has to do with the logging/locking system.  If there
_were_ something like a trace point, it would probably have to go
through the DMFJSP program (which is for infodb, auditdb, ckpdb, and
rollforwarddb--check the symbols).

> FWIW, we're running VMS 5.4-2.
>
>   Michael
>
> Michael D. Shields      |  Internet: michael@cutler.com
> AVP, MIS                |  UUCP: ...hplabs!hp-pcd!orstcs!cutler!michael
> Cutler & Company, Inc.  |  Voice: (503) 770-9000
> Medford, OR  97504      |  FAX: (503) 779-0006

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.