HDTenEightyP/NetNews huggingface dataset:
From: v064qpfu@ubvmsb.cc.buffalo.edu (Christopher S. D'Arrigo)
Newsgroups: comp.databases
Subject: Foxpro - File Not Found Error
Date: 8 Apr 92 04:31:00 GMT
Organization: UB


Hello to all,
	Currently we are runnign Foxpro 1.2 at the office on a
     Netware Lan system.  I have noticed that whenever Foxpro starts
    up on the network It  always gives an error first of FILE WAS NOT
   Found. yet if I press enter, I can continue with the application.
   I dont know if its of any consequence but:

   1) Each application has its own subdirectory under Foxpro
      and the Foxpro Directory has been added to the search path

      For Example:

        F:/Foxpro/Payroll
     and PATH F:\;C:\;F:\Network; F:\Foxpro

   2) When I run Foxpro on our standalone station (used for Program
      development) I dont get this error ( The standalone station uses
       the same direcoty structure as above and Foxpro Root is added
       to the path)

      I know this is probably a long shot,but Does anyone know what file
      its referring to?  If so where is this file and how can I tell 
      Foxpro  where to find it.

      By the way, Im using Foxpro Lan 1.2 if that matters.. 

Thanks in advance,
*************************************************************************
Christopher D'Arrigo
SUNY@Buffalo
IN%"V064QPFU@UBVMSB"
**************************************************************************
From: awesley@vela.acs.oakland.edu (Tony Wesley)
Newsgroups: comp.databases
Subject: Re: Relational Systems set back DP by at least 10 yrs.
Date: 11 Apr 92 15:39:44 GMT
Article-I.D.: vela.14656
Organization: National Federation of Associations

bellamy@covax.commerce.uq.oz.au writes:

> chandra@cs.tamu.edu (Chandrasekaran Periannan) quotes Henry G. Baker:
>> most manufacturing databases of the late 1960's were of the "Bill of
>> Materials" type, which today would be characterized as
>> "object-oriented ". Parts "explosions" and budgets "explosions" were

>Parts explosions were one case were the hierarchical structure always had
>problems.  A part usually takes place in a many-to-many recursive relationship
>i.e. was part of other parts and was in itself made of many parts.

I've had the opportunity to see the same "Bill of Materials" database
implemented on three different machines with three different db
designs.  The source of the data was a hierarchical db for storing
paint formulations.  Paints are made of itermediates which are made of sub-
intermediates and this can go on for arbitrary N levels until you get
to intermediates that are composed of raw materials.

A copy of all the data was kept on a relational database for toxicological
processing.

Yet another copy of the database was kept on a network database for realtime
paint label processing.  

The relational db ran circles around the heirarchical one.  A raw
material might be changed -- toluene might be substituted for xylene
(paint chemists out there, I know it ain't just that simple).  In the
heirarchy, a massive downward search of all paint formulations would
have to be done to find the toluene and change it to xylene.  There
were on the order of 5,000 paint formulations.  Because of the many cpu 
hours it took to accomplish this, only "active" formulas would be 
searched.  On the relational db, ONE record would have to be changed.
The record that identified raw material XXX would be changed from xylene
to toluene.

In my experience, implementing a Bill of Materials as a heirarchy is a
nice way to sell lots of cpu cycles and programmer years.  A good
relational db implementation of the problem works like a charm.  The
system, implemented on multics using MRDS and pl1, was finished
several years ago and continues to run like a charm.  With no
programmer attention.  

-- 
 Tony Wesley					 awesley@vela.acs.oakland.edu

   The right most valued by all civilized men is the right to be left alone.
							-- Louis Brandeis
Newsgroups: comp.databases
From: olhe4000@mailszrz.zrz.tu-berlin.de (Olaf Hendel)
Subject: database + GUI for MS-Windows
Organization: Technical University of Berlin
Date: Fri, 17 Apr 1992 09:32:17 GMT

Our problem is to develop an grafical user interface, which shows relations
between different objects (phases of produktion) and guides the user thru
diffrent levels of information (like ABC-Flowcharter). On the bottom level 
the interface should allow connection to specific sets of a database.
The hardware is fixed: 386/486 under Ms-Windows in a Novell-Net
The question is now, which sofware is practicable (for the Database and
the Interface-builder)?? We like to avoid programming in Turbo-Pascal,C++
etc. !
I think there are diffrent opinions on this subject, so please let me know.

Thanks

Olaf Hendel,
Technische Universitaet Berlin, Germany
Institut for Food- and Biotechnologie

Internet: hendel@zrz.tu-berlin.de
From: holder@cse.uta.edu (Larry Holder)
Newsgroups: comp.databases
Subject: Structural Databases
Date: 15 Apr 92 21:24:55 GMT
Organization: Computer Science & Engineering, Univ. of Texas at Arlington

We are looking for databases to be used for testing an intelligent
structural data analysis tool.  The database should be structural or a
flat representation of a structural environment (e.g., coordinates of
3d entities).  The database will be converted to a graph
representation for input to the system.  Any pointers to such
databases would be appreciated.

Thank you.

-- 
Larry Holder (holder@cse.uta.edu)

University of Texas at Arlington, Department of Computer Science Engineering
Box 19015, Arlington, TX 76019-0015, Phone: 817-273-2596, FAX: 817-273-2548
Newsgroups: comp.databases
From: christy@b8.ingr.com (Christine Gammage)
Subject: Re: Accessing dBASE files on VAX (UNIX too!)
Organization: Intergraph
Date: Thu, 16 Apr 1992 18:08:50 GMT

In article <1992Apr14.143508.6972@uoft02.utoledo.edu> grx1344@uoft02.utoledo.edu writes:
> Hi! I need source code in (C or Pascal) to allow me to access (read and
> write) dBASE files on a VAX. If anybody knows where I can find such
> code, please E-Mail me. Thanks
>	Nik Kalyani
>        GRX1344@UOFT02.UTOLEDO.EDU

Ditto for UNIX.  Are there any libraries / C code avaliable for
read/write of dBASE files on a UNIX system.

-----------------------------------------------------------------------
Christy Gammage              | Success:
(205) 730-8273               |  To laugh often and much ...
LR24A4                       |  To find the best in others ...
b24a!fozzie!christy          |  To leave the world a bit better ...
christy@fozzie.b24a.INGR.COM |  To know one life has breathed easier ...
#include <std_disclaimer.h>  |               Ralph Waldo Emerson
-----------------------------------------------------------------------
From: fdm1@wsinis02.info.win.tue.nl (Hans Senden)
Newsgroups: comp.databases
Subject: Combination Oracle/X Windows
Keywords: Oracle,X Windows
Date: 3 Apr 92 08:17:44 GMT
Reply-To: fdm1@info.win.tue.nl

Hello,
does anybody know how I can connect the X Window System and the Oracle RDBMS :
is there a possibility in Xlib to send a SQL-command to Oracle.

                                   Hans

Please send your message to : fdm1@info.win.tue.nl

P.S. Do articles or books exists about this subject ?
From: charath@cs.tamu.edu (Charath Ram)
Newsgroups: comp.databases
Subject: Public Domain DBMS on Unix???
Date: 8 Apr 92 13:36:33 GMT
Organization: Computer Science Department, Texas A&M University

Does anyone out there know of any public domain database packages that can run
on Unix? I would be interested in packages that could be ported to a few
different systems, but anything that runs on Sparc/Sun workstations should be
just fine.

Please reply by e-mail to charath@cs.tamu.edu

Thanks
- Charath Ram
  Texas A&M University
From: awesley@vela.acs.oakland.edu (Tony Wesley)
Newsgroups: comp.databases
Subject: Re: Clarion Professional Forum
Keywords: clarion
Date: 15 Apr 92 22:12:45 GMT
Organization: National Federation of Associations

smacleod@caper1.uccb.ns.ca writes:

>Is there any interest in creating a user discussion area for Clarion 
>Professional Developer users.

Yes!

-- 
 Tony Wesley					 awesley@vela.acs.oakland.edu

   The right most valued by all civilized men is the right to be left alone.
							-- Louis Brandeis
Newsgroups: comp.databases
From: godfrind@ricard.enet.dec.com (Albert Godfrind)
Subject: Re: insertions
Organization: Digital Equipment Corporation, Valbonne, France
Date: Fri, 17 Apr 1992 14:31:23 GMT


In article <nallappa.702006312@heawk1>, nallappa@heawk1.gsfc.nasa.gov (bhashyam nallappa) writes...
> 
> this question is  very fundamental to databases: how can one
>insert data into a table  efficiently ?
> 
>I work at a place where the data comes from sattelites and usually
>is 30,000 (rows ) by 23 (columns) and the attributes  are 
>everything ranging from char to real (float). In Ingres/sybase
>is there an efficient way of inserting such  kind of data?
>these data have no standard format and in Ingres (under Unix)
>I have been using embedded c with  basically a loop and the 
>standard features of c like fgets and fscanf and using
>the host variables to  execute an insert. In sybase i know
>there is bcp command but for some reeason does not work on
>our system. I tried using db-library and found that 
>sybase needs a quote around the characters to be inserted into
>tables. I would like to know if readers of this newsgroup had
>any similar experince 

I don't know enough about Sybase, but with ingres, you can use the COPY
command. It can be configured to allow all sorts of input formats. It should be
able to handle your input data - if the format is not too exotic. If it is, you
could change your program to generate output in a format acceptable to COPY. 

Otherwise, a loop in a program can be just as efficient, but you still have to
worry about a few things :

- is this table journaled ? If so consider disabling it during the load
- you should also commit at regular intervals, say after each 500 to 1000
  insertions. Otherwise, you may run out of space in the txn log.
- does this table have secondary indices ? If so, consider dropping them
  before the load and recreating them after. You would have to of course
  consider the time you gain in loading with the time it will take to 
  rebuild the new index. This will obviously depend on the total rows in the
  table.

/albert
--
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
From: vv@mbunix.mitre.org (Ventrone)
Newsgroups: comp.databases
Subject: Re: E-R modelling ?= 5th Normal Form
Date: 1 Apr 92 17:23:13 GMT
Organization: The MITRE Corporation, Bedford, MA

In article <873@6sceng.UUCP> blm@6sceng.UUCP (Brian Matthews) writes:
>In article <CIMSHOP!DAVIDM.92Mar27103128@uunet.UU.NET> cimshop!davidm@uunet.UU.NET (David S. Masterson) writes:
>|> What's Attribute Relationship Modeling?  Aren't attributes related
>|> directly to the entity?
>|Attribute Relationship modeling is something you would use when you don't
>|really know what entities exist in your data model.
>
...(stuff deleted)...

>If you try to come up with entities, a lot of them will probably result
>from collecting a group of attributes together and then replacing them
>with the entity.  Also, unless you're proficient with ER modeling, it
>can often be difficult deciding if something is an entity or how
>abstract to make entities.  It's usually much easier to come up with
>attributes.  Basically anything you want to store information about
>is an attribute.
>
>- A data model designed using Attribute Relationship modeling can
>  be normalized automatically because all of the necessary information
>  is present.
>
>- AR modeling deals with concrete things.  ER modeling deals with
>  abstract entities.  It's probably easier for people to collect
>  attributes than try to abstract things to the degree necessary
>  with ER modeling.  Also, existing processes use pieces of paper
>  just chock-full of attributes!


This thread has been quite interesting--particularly in that there seems to be
an underlying assumption that ER models are ONLY useful as design tools for
implementing a relational database.  That is probably how the technique is
most commonly used, but I believe the primary advantage of creating an ER model
at all is to provide an abstract view of data in some Universe of Discourse 
(indeed, I think that was the motivation of Chen's original paper).  So
references to primary keys and foreign keys seems strange--tends to mix
an abstract model with implementation issues.  ER models are probably rarely
used to implement, say, a CODASYL or O-O database--but they could (though in 
the O-O case it would be a poor fit since ER models have no constructs for
representing behavior).  There are various transforms that can be used
to turn ER models into relational tables, but I think it is useful to separate
these two:  the model and the implementation of the model.  There is no 
reason not to create entities that have no natural primary key--as long as
they can be identified SOME way and as long as they represent people, places
or things in the real world.


-- 
   Vince Ventrone
   The MITRE Corporation
   Bedford, MA 01730
   vav@mitre.org
From: jhingran@postgres.Berkeley.EDU (Anant Jhingran </>)
Newsgroups: comp.databases
Subject: Software for managing "reviewing" process for conferences?
Date: 16 Apr 92 22:59:29 GMT
Reply-To: jhingran@postgres.Berkeley.EDU (Anant Jhingran </>)
Distribution: usa
Organization: Postgres Research Group, UC Berkeley

Does anyone know of a software that manages "conference review" processing?
Take your favorite ACM conference, for example.  The program chair
sends out copies of over 200 papers to three reviewers each, and then
collects the reviews and tabulates the grades.  The grades need to
be accessed in at least the following orders:
1. Descending order of total rank (i.e. sum of the three reviewer scores)
2. By author
3. By reviewer
4. By paper title
5. By paper #
etc.
In addition, author's addresses etc. also need to be maintained.
Apart from using a standard RDB and writing one's own application to manage
the above, is there something available out there?
Thanks in advance, and please reply to anant@watson.ibm.com if not
posting on the net.
From: maurik@hope.pp.fi (Mauri Ketola)
Newsgroups: comp.databases
Subject: Re: E-R modelling ?= 5th Normal Form
Date: 8 Apr 92 22:48:52 GMT
Organization: Helsinki, Finland

In article <1992Apr2.160823.13712@pmafire.inel.gov> cdm@pmafire.inel.gov (Dale Cook) writes:
>As an example, if we have entities Employee and Organization, with a relation
>ship of Belonging, then we have 1 employee belongs to 1 organization, while
>1 organization has many employees belonging to it, would you put the key
>of employee in organization, or vice versa?  And in your terms, what's the
>"dominant" and "subordinate" enties here?

When finding out foreign keys you must resolve what is larger term. Think
it in a hierarcial order and you can see that organization is at higher level
than employee, so the table, where employees exist, must refer to organization.

So put foreign key, which is primary key in organization table, into the
table employee.

Think tables as father and child tables...

Mauri
-- 
	*********************************************************
	 Mauri Ketola, Helsinki Finland  ! life is hard and then  
	 domain maurik@hope.pp.fi        ! you die               
	*********************************************************
Newsgroups: comp.databases
From: rs@uni-paderborn.de (Ralf Seepold)
Subject: Distributed Monitor for OODBMS
Followup-To: poster
Keywords: monitor, debugger, OODB
Organization: Universitaet-Gesamthochschule Paderborn
Date: Tue, 14 Apr 1992 09:43:27 GMT



In our studies we design a distributed monitor and control system for
a distributed-object-oriented-database-system.

To support a fast and efficient development of our system we search further 
literature about:
 
  - debugging of distributed OODB
  - monitoring of distributed systems
  - realized distributed monitorsystems


Thanks in advance.
                         Thomas Wollny     (thw@uni-paderborn.de)
                         Ralf Seepold      (rs@uni-paderborn.de)
From: skow@cs.utwente.nl (Jacek Skowronek)
Newsgroups: comp.databases
Subject: QUESTION: Standards activities in Europe
Date: 12 Apr 92 14:15:18 GMT
Reply-To: skow@cs.utwente.nl
Organization: University of Twente, Dept. of Computer Science

I was recently on the kick-off meeting of X3H7 (Object Information Management)
technical committee of ANSI. This committee is concerned with the creation
of Interoperable Object Model. I would like to know if such activities are done 
in Europe also?
I mean standards activities in the area of object-oriented programming and databases.
Could You point me to some people I could contact ?

Jacek

---
-------------------------------------------------------------------
Jacek Skowronek				e-mail: <skow@cs.utwente.nl>
Departament of Computer Science
Twente University
Enschede, The Netherlands
From: lf@uk.ac.uea.sys (Luke Fitzgerald)
Newsgroups: comp.databases
Subject: Re: E-R modelling ?= 5th Normal Form
Date: 6 Apr 92 08:23:14 GMT
Organization: School of Information Systems

In article <1992Apr1.222033.29624@cs.sfu.ca> hall@cs.sfu.ca (Gary Hall) writes:

>[...] What I don't understand is how [business policy etc]
>are incorporated in the model, and how their representations are used
>in the process of designing and building databases/systems.  

>Can someone (Dale?) enlighten me or point me toward a good reference?

An example you might like to consider is this.  In many organisations, we do 
not care about the relationship between employees; whether they are married 
to each other, or one is the child of another, is irrelevant to the 
enterprise, and is therefore not reflected in the model.  If, however, we 
are dealing with a high-security organisation (the CIA, GCHQ, or whatever), 
we might well need to hold this information.  This will affect the E-R model.

Luke
From: maurik@hope.pp.fi (Mauri Ketola)
Newsgroups: comp.databases
Subject: Re: E-R modelling ?= 5th Normal Form
Date: 8 Apr 92 23:06:11 GMT
Organization: Helsinki, Finland

In article <626@6sigma.UUCP> clif@6sigma.UUCP (Clif McLaurin) writes:
>How exactly do you define the entities?  I mean, do you just plop related
>attributes together and hope that the model is somewhat cohesive?  What
>about eliminating 1) repeating groups of attributes ( 1NF ), 
>2) redundant data ( 2NF ), and transitive dependencies ( 3NF )?  And what
>relationships are you talking about?  I assume that you mean the relationships
>between the entities?  What about the associated relationships between
>attributes within an entity?

Follow these rules:

- first define larger entities, if you discover them right away
- if not, write down attributes, which have to be included 
- recheck those attributes and try to discover larger entities, which collects
  those attributes together
- if you find out after you have defined entities that some attributes
  are repeated needlessly, try to define child entity under those entities and
  put those attributes into them
- recheck that you have father and child tables OK and if you have, define
  primary keys and foreign keys, which refer to father tables.

Those rules may not all be in right order, but I think you get the picture.

Mauri
-- 
	*********************************************************
	 Mauri Ketola, Helsinki Finland  ! life is hard and then  
	 domain maurik@hope.pp.fi        ! you die               
	*********************************************************
From: rouet@vlsi.polymtl.ca (Marc Andre Rouet)
Newsgroups: comp.databases
Subject: Text retrieving system
Date: 14 Apr 92 00:40:41 GMT
Organization: Ecole Polytechnique de Montreal

Monday April 13 1992.


I will be responsible for the implantation of a database server for text
retrieval and I don't have a big knowlage of commercial products, neither
of general dbase system nor specialised ones (I suppose that a text oriented
system must be different from one that manages fixed lenght records).

The system will contain 10000 documents of a few pages and will have to serve
very few simultaneous users (under 10).

The pages will contain text and graphics, I don't need to be able to
retrieve a page from it's graphical information but the system must be able
to store both so that when a document is retrieved, the graphical information
can (optionnaly) be displayed as well.

Althought the input process I am considering may be more in the field of
those registered to Comp.Graphics.ImageProcessing, I hope to get
more down to earth advices here :

I am interested in scanning the documents, have the image processed by an
OCR system (character recognition) so that I have the text in an ASCII file
and the graphics in another file.

The database system will have to store informations concerning
the formating of the document (text and graphics), so that reconstruction of
the original pages is possible.

I would prefer an integrated system, althought I am prepared to interface
several products. I hope to find commercial products that fits my needs and
that interface well.

Wednesday, I am supose to see a demonstration of XEROX DSR system witch is
suppose to solve my dbase and input process problems.

I would like to have suggestion FAST!! ( because I have to make choices by
the end of next week) on possible solutions to my problem, some comments
on XEROX's system, some general suggestions concerning commercial products
in that particular field.

			 My only limit is a budget of 130 000 $ (Canadian).

Please also mail a copy to:       rouet@info.polymtl.ca

												thanks! :)
From: awerman@panix.com (Aaron Werman)
Newsgroups: comp.databases
Subject: IBM RDBMS use of links (was Re: Relational Systems set back DP)
Date: 14 Apr 92 11:56:18 GMT
Organization: PANIX Public Access Unix, NYC

In <29e9f3ff.1599@orchid> lchirica@orchid (Laurian Chirica) writes:

>     ...  It is interesting to recall that IBM's System R designers
>proposed the use of "links" (really DBTG sets) in the relational model
>implementation.  Somewhow links were left out in the commercial IBM 
>offerings (SQL/DS, DB2).  I do not know if the latest releases of
>these systems use links.

	The system catalog of these products do indeed use links, which
	are pairs of row pointers from different tables.
-- 
Aaron Werman
awerman@panix.com
{cmcl2,apple}!panix!awerman
From: galitz@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Wampum and reading files
Keywords: Wampum, PcFile, memo, file, text
Date: Mon, 06 Apr 92 13:21:52 PDT
Reply-To: galitz@cruzio.santa-cruz.ca.us


	Does anyone know I how I might be able to read a file into
a memo field in Wampum or Pcfile v5.0?  If there isn't a way, does
anyone have any recommendations on databases that will allow me to 
do so?


Thanks....
-- 
------------------------------------------------------
Is it Love, or is it the idea of being in Love?
galitz@cruzio.santa-cruz.ca.us

Xref: sparky comp.databases:4175 comp.sources.wanted:2544