HDTenEightyP/NetNews huggingface dataset:
From: mbrannigan@peg.pegasus.oz.au
Newsgroups: comp.databases
Subject: Re: Can E-R express this?
Date: 12 Apr 92 18:53:00 GMT
Nf-ID: #R:mindlink.bc.ca:11246:peg:131600006:000:1690
Nf-From: peg.pegasus.oz.au!mbrannigan    Apr 11 18:53:00 1992



The following "E-R" model (really an ENTITY model) is my suggestion.  Please
excuse the poor attempt at graphic conventions.  Briefly, "an ORDER may have many
INVOICES and an INVOICE must have one ORDER" is expressed where ---- means may and
===== means must.

Isn't it a matter of having ORDER# and PART# as foreign keys in INVOICE-DETAIL?
Then an INVOICE-DETAIL must be related to one ORDER-DETAIL.  Any attempt to delete
an ORDER-DETAIL would be disallowed because of the links to INVOICE_DETAIL.

Hope this helps.  In any event how do you express this algebraically?

Mark Brannigan






     +-------+                     +---------+          
     | order |                     | invoice |
     |       |                     |         |
     |       |-----------=========<|         |
     |       |                     |         |
     +-------+                     +---------+
         |                              |
         |           +-------+          |
         |           | part  |          | 
         |           |       |          | 
         ||          |       |          ||
         ||          |       |          ||
         ||          +-------+          ||
         ||           |     |           ||
         ||          |       |          ||
         ||         |         |         ||
         ||        |           |        ||
         ||       |             |       ||
         ^        ^             ^       ^
       +-------------+         +---------------+
       |order detail |         |invoice detail |
       |             |----====<|               |
       |             |         |               |
       +-------------+         +---------------+
From: Dora@cup.portal.com (Lin Dora Koeppel)
Newsgroups: comp.databases
Subject: Powerbuilder
Date: Wed, 15 Apr 92 16:15:45 PDT
Organization: The Portal System (TM)
Distribution: world

I am posting the following for a co-worker.  You may reply via email to
my address or by fax (see address below):

Currently Using Powerbuilder 1.0a with Microsoft SQL Server version 1.1 
running on a Hewlett Packard Vectra 486/33 under OS2 Version 1.21.  
We have the following questions.

Powerbuilder:

	How does one read and write Text Datatypes to the Database ?
	    
	How does one read and write Image Datatypes to the Database ?

	How does one retrieve information from a dataset and show it using a 
	dropdownlistbox ?

	How does one at runtime prompt for "Login" information ?

	How does one display a bitmap file ?

	How does one connect to multiple databases existing on different 
	systems ?

	How does one create an application using multiple master/detail 
	relationships.

I would greatly appreciate any hints or help that you might be able to share.        
Thanks in advance.
	James

------------------------------------------------------------------------------
James McGovern
Connecticut Community Care
43 Enterprise Drive
PO Box 2360
Bristol CT 06011-2360
Fax: (203) 589-3712
Newsgroups: comp.databases
From: wmac@elara.mitre.org (Bill Carpenter)
Subject: Re: Looking for a heterogeneous database server
Organization: The MITRE Corporation, Bedford, MA 01730
Date: Wed, 15 Apr 1992 19:19:16 GMT

In article <21212@hacgate.UUCP>, saint@mitchell.hac.com
(Kathy Saint) writes:
|> 
|> Like the subject says, we're looking for a database
|> server that can access
|> several databases of different types (i.e., relational,
|> hierarchical, textual).
|> 
|> If something like this exists, I'd appreciate a reply.
|> 

Have you looked at a company called Uniface?  They have  a
4GL product which supports heterogeneous distributed
database access.  Uniface appears to be a very mature
product.  Try contacting Don Graham 301-740-8745, email ???

Another company you might be interested in is data
Integration.  They have a product called InterViso (the
successor to the old Mermaid).  We have been dealing with
Marie Templeton, the president.  You can get her at
310-313-9150, or email margie@dii.com.  She is very
knowledgable.

There are others also.  ORACLE, Ingres, and Sybase are all
getting into the distributed heterogeneous database world to
varying degrees.  Their products may provide the support you
need.  Also, the folks at IBI (they brought you Focus) are
making a splash in the distributed heterogeneous world. 
These companies are large enough that you should be able to
find a local rep easily.
From: sie@fulcrum.bt.co.uk (Simon Raybould)
Newsgroups: comp.databases
Subject: PD database for PC.
Date: 6 Apr 92 14:44:26 GMT
Organization: Fulcrum Communications Ltd., Birmingham, England


Can someone point me to an FTP site that has a PD database for the PC.

The path would be useful also.

Thanks.

--Sie

--
Simon J Raybould    (sie@fulcrum.bt.co.uk)            //              {o.o}
"Only joking ... Or am I ?" - Vic Reeves            \X/AMIGA           \-/
===========================================================================
Fulcrum communications L.T.D., Fordrough Lane, Birmingham, B9 5LD, ENGLAND.
From: lobssuth@fig.citib.com (Lou Obssuth)
Newsgroups: comp.databases
Subject: RBASE API
Date: 15 Apr 92 14:12:17 GMT
Organization: Citibank IBISM
Originator: lobssuth@swcdev


	Does rbase have an API, if so where do you find it?
From: sena@infinet.UUCP (Fred Sena)
Newsgroups: comp.databases
Subject: Dynamic Programming with Ingres
Keywords: Ingres SQLDA
Date: 16 Apr 92 20:02:42 GMT
Organization: Teleglobe Communications, Inc.

Hi,

I am currently working on a project where we are considering making use of
the Ingres Dynamic Programming for transfer of data to/from database tables
and to/from database forms.  The product will run on a Sun spark with Ingres
6.4.

What I would like is any information that someone can provide about their
personal experiences using dynamic programming with Ingres.  Basically, was
it a joy or was it a pain (or both), and why?

Also, if anyone out there considered using Dynamic programming and chose NOT
to use it, I would like to hear their reasons for making that decision as
well.

Any information that you can provide will be gratefully appreciated.  If you
can, please respond via email and I will summarize.

	thanks,
	-fred

P.S.  We are in the process of making some decisions right now.
Unfortunately, I didn't think of sending this earlier.  Anyhow, I could use
the information by 4/22/92.	--thanks.

-- 
--------------------------------------------------
Frederick J. Sena                sena@infinet.UUCP
Memotec Datacom, Inc.  N. Andover, MA
"Computers are useless.  They can only give you answers." - Pablo Picasso
Newsgroups: comp.databases
From: kanarick@media.mit.edu (Craig M. Kanarick)
Subject: Who's who?
Organization: The Visible Language Workshop
Date: Tue, 7 Apr 1992 17:00:27 GMT


Are there any "Who's Who" type databases (i.e. biographical information)
online?

Does anyone have a good thesaurus on a UNIX system?

Thanks,

-- cmk

-- 
-----------------------------------------------------------------------------
Craig M. Kanarick			"Do I love you?  Yes I love you.
					 All this talking...talking...	
kanarick@media-lab.media.mit.edu	 is only bravado..."
From: vsystem@pa881a.inland.com
Newsgroups: comp.databases
Subject: Re: Borland Future Plans (Interbase)
Date: 8 Apr 92 13:30:02 GMT
Organization: Inland Steel Company, East Chicago, IN
Nntp-Posting-User: butzen

This is in answer to an inquiry concerning Interbase. At Inland Steel we
have been using the product for 2 years and are planning to use it in yet
another big project. The software product is excellent and delivers a terrific
bang for the buck. The product that runs very well on multiple platforms, VAX,
IBM, SG, HP, 80x86 etc. I like several features that make it outstanding,
Blobs, Event alerters, multi dimesioned arrays (accessible from command line!).
Sorry to sound like a vendor :-). Documentation with the product is sufficient
though it could be better presented. Support has been very good too. Future
plans, as far as we've been able to figure out, are for Borland to make
Interbase it's midrange database server. Tieups to Quattro Pro are in the wings.

							Adarbad Master

"All of the above is true, except what is false"
From: maurik@hope.pp.fi (Mauri Ketola)
Newsgroups: comp.databases
Subject: Re: Can E-R express this?
Date: 8 Apr 92 23:41:07 GMT
Organization: Helsinki, Finland

In article <11246@mindlink.bc.ca> Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
>In the  following, my shorthand is TABLE<PRIMARY KEY> NON-KEY ATTRIBUTES.
>
>ORDER<ORDER#>
>ORDER_DETAIL<ORDER#, PRODUCT#>
>INVOICE<INVOICE#> ORDER#
>INVOICE_DETAIL<INVOICE#, PRODUCT#>
>
>i.e. there is a one-to-many relationship between:
>ORDER and INVOICE
>ORDER and ORDER_DETAIL
>INVOICE and INVOICE_DETAIL
>... with which E-R diagrams have no problem. On the other hand,
>there is the referential integrity constraint that an INVOICE_DETAIL
>must have an ORDER_DETAIL. I can expres this algebraically, but the
>client doesn't dig algebra. What am I missing?
>Oh, and I do NOT intend to make ORDER# a phony (and abnormal)
>attribute of INVOICE_DETAIL.
>MTIA.
>--

If I fully understand what you want to hear, I suggest the following sollution

   +-------+         +-------------------------------+        +---------+
   ! order ! <---->> ! order_detail & invoice_detail ! <<---> ! invoice !
   +-------+         +-------------------------------+        +---------+

This can work only, if one order_detail has only one invoice_detail, but if
it can have many invoice_details, you have to do it in the following way

 +-------+        +--------------+        +----------------+        +---------+
 ! order ! <--->> ! order_detail ! <--->> ! invoice_detail ! <<---> ! invoice !
 +-------+        +--------------+        +----------------+        +---------+

I don't see there is any need to draw line right from invoice to order,
because you can get the same information by using this sollution.

I though this quite fast, so I'm sorry, if I made some mistakes...

Mauri
-- 
	*********************************************************
	 Mauri Ketola, Helsinki Finland  ! life is hard and then  
	 domain maurik@hope.pp.fi        ! you die               
	*********************************************************
Newsgroups: comp.databases
From: gregb@murphy.com (Greg Banschbach (Unigroup of New York))
Subject: postgres on SYSV R2
Organization: Murphy & Durieu, New York NY, Home of murphy's law
Distribution: usa
Date: Thu, 9 Apr 92 17:33:37 GMT

Greetings,
	I have a question which maybe is in a FAQ somewhere, but 
	please bear with me 8-) 
	
	About six months ago I got a tape with postgres on it.  I
	loaded it on a UNISYS U5000/55 ( a.k.a NCR 32/650 )
	and then I read the first readme file.   It said that I 
	must have a System 5 R3 level version of "make" to run
	the install script.   Well, I tried to sneak around this
	but to no success :(    

	Has anyone ever successfully installed Postgres on my 
	machine?  I know it was REALLY designed for BSD and 
	is ported to ULTRIX and SUN-OS.   

	#2	I would like to take advantage of all of this 
	great source written for BSD & Sun but everyone 
	says the porting is a bear because there is no set of headers 
	with nice   #ifdef SYSV  // #ifdef BSD  etc.....
	If someone knows of a book which explores porting between
	BSD and AT&T SYS5 please let me know.....It would be worth
	having ( what do those software companies do ? ).


	Thanks very much people.....

	Greg Banschbach ( gregb@murphy.com )
	voice (212) 292-9000   ext. 57    8-4pm  EST.
From: perrocho@inf.ethz.ch (Louis Perrochon)
Newsgroups: comp.databases
Subject: Re: E-R modelling ?= 5th Normal Form
Date: 13 Apr 92 07:42:09 GMT
Organization: Dept. of Computer Science, Swiss Federal Institute of technology (ETH), Zurich

I followed this thread for many articles now, learned a lot about pros'n'cons
of ARM and ERM, but still I don't know, how ARM works.
Could someone please tell me, where I can get this Information? 
Any books, papers, ... wil be fine.

Louis


-- 
+-------------------------------------------------------------------------+
| Louis Perrochon, Institut fuer Informationssysteme, Zurich, Switzerland |
|              voice: ++1 254 7282 email: perrochon@inf.ethz.ch           |
+-------------------------------------------------------------------------+
From: v064qpfu@ubvmsb.cc.buffalo.edu (Christopher S. D'Arrigo)
Newsgroups: comp.databases
Subject: Foxpro -- What are all these files?
Date: 11 Apr 92 19:16:00 GMT
Organization: UB


Howdy!
	Can someone tell me what all these files are in my Foxpro
	directory.  I have a gazillion of them.  Their names
        are made up of strcitly numbers and have no extensions.
        Strangely enough, they are all either 0 bytes or 400K large

	What are these files?  Can I remove them?  If So, when..

				Thanks!
				
************************************************************************
Christopher D'Arrigo
SUNY@Buffalo
In%"V064QPFU@UBVMSB"
************************************************************************
Newsgroups: comp.databases
From: idmrmb@gsusgi1.gsu.edu (Mark Buffington)
Subject: SYBASE open gateway?
Keywords: sybase,gateway
Organization: Georgia State University
Date: Tue, 14 Apr 1992 15:26:47 GMT

Hello. Can someone let me know if they have heard of a SYBASE
open gateway connection to CA-IDMS R12.0 SQL? The latest release
of the CA-IDMS software has a true SQL engine. It is supposed to
support ANSI at least as well as DB2 does. My only hesitancy about
this product is a perceived lack of front-end tools by 3rd party
software vendors. Please let me know if you are aware of any tools
for this suite of products (future or current). Thanks! /Mark...

-- 
  __        __
 |__) |\/| |__)    R. Mark Buffington    <  idmrmb@gsusgi1.gsu.edu
 |  \ |  | |__)    DBA - Database Group  <  GSU Wells Computer Center
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 "I'm not bad, I'm just drawn that way." - Jessica Rabbit
From: v106padf@ubvmsb.cc.buffalo.edu (MIKE CARGIAN)
Newsgroups: comp.databases
Subject: Question: Databases for small insurance agency
Date: 6 Apr 92 23:37:00 GMT
Organization: University at Buffalo
News-Software: VAX/VMS VNEWS 1.41

My brother has a small insurance agency, in which we are trying to
get all of his clients records and billing information into his computer.
We have looked at specific agency software that can cost up to $10,000.00
to do these tasks which is too expensive for such a small office.  

What I am really wondering is whether or not we can we use a database 
and something like Visual Basic or Object Vision to create a system 
that would keep client information (Names, policies, etc.) and 
be able to do simple billing as well.  Perhaps linking the database 
to an accounting package to keep track of accounts recievable.  I don't
really know too much about database capabilities for something like this.

Any ideas would be greatly appreciated.

Thanks in advance!

-----------------------------------------------------------------------
Michael Cargian 		Mechanical and Aerospace Engineering
V106PADF@UBVMS.BITNET		State University of New York at Buffalo
-----------------------------------------------------------------------
From: rts@cs.arizona.edu (Rick Snodgrass)
Newsgroups: comp.databases
Subject: Re: T-SQL ?
Date: 6 Apr 92 16:51:49 GMT
Article-I.D.: optima.14908
Reply-To: rts@cs.arizona.edu (Rick Snodgrass)
Organization: U of Arizona, CS Dept, Tucson

A bibliography of many of the papers written on time in databases
is available via anonymous ftp from cs.arizona.edu, under bib/time.bib
Corrections and additions would be appreciated, and may be sent to me.
This file contains over 500 references, including all papers mentioned
in the various bibliographies on this subject that have appeared in
ACM SIGMod Record, the last being

	M. Soo, "Bibliography on Temporal Databases," SIGMod Record,
	Vol. 20, No. 1, March, 1991, pages 14-23.

To get an overview of the field, you might want to scan

	R. Snodgrass, "Temporal Databases: Status and Research
	Directions," SIGMod Record, Vol. 19, No. 4, December, 1990,
	pages 83-89.

Richard Snodgrass		Internet: rts@cs.arizona.edu
Department of Computer Science
University of Arizona		AT&T: (602) 621-6370
Tucson, AZ 85721		FAX:  (602) 621-4246
Newsgroups: comp.databases
From: rhart@magnus.acs.ohio-state.edu (Ronald T Hart)
Subject: Tracking Software
Organization: The Ohio State University
Date: Thu, 16 Apr 1992 23:44:03 GMT


I'm interested in suggestionsfor a database product that would tracld track a
customer application through it's various approval stages.
It would have to run on a Novell network and perferamouse driven.
Applications run about 500-700 a week.  The tracking information on a certain
indivdual must be easily accessed by a user.  Imput boxes and stuff like that.
I also would like to do calculations on information - like number of 
applications in a week from various regions.

Thanks for your time.
From: progress@thinc.COM (Progress@THINC.COM)
Newsgroups: comp.databases
Subject: PROGRESS Email Group
Keywords: PROGRESS
Date: 13 Apr 92 11:22:04 GMT
Organization: Tomorrow's Horizons, Inc., Bethesda, MD


We take great pleasure in announcing the establishment of a
Email User Group devoted exclusively to the discussion of all 
relevant aspects of the PROGRESS(tm) RDBMS.  Discussion may 
include any topic related to PROGRESS(tm).  

Coordinator: Ethan A. Lish (Ethan.Lish@THINC.COM)

To subscribe send Mail to:

To: Progress@THINC.COM
Subject: Add User 

Full Real Name : ___________________________________________
Net Address (From uunet) : _________________________________
Company Name : _____________________________________________
Company Address : __________________________________________
Voice Phone Number : _______________________________________



-- 

The PROGRESS EMail Group is provided by:
Tomorrow's Horizons, Inc., 4938 Hampden Lane, No. 330, Bethesda, MD 20814
From: AL380182@VMTECCHI.CHI.ITESM.MX
Newsgroups: comp.databases
Subject: Information about FREENET
Date: 10 Apr 92 17:47:37 GMT
Organization: ITESM Campus Chihuahua

I know that here is not the place to search for information about freenet but
I want to know in which discussion list I have to put my question.
What I want to ask is about the password of FREENET, if I have to subscribe or
how can I get in, and  something like a FREENET user's guide.
      Thank you in advance,
             Alejandra Almada (al380182 at vmtecchih)
From: bill@chaos.cs.umn.edu
Newsgroups: comp.databases
Subject: Re: Client-Server-based DBMS question
Keywords: SQL Server, API, Oracle
Date: 7 Apr 92 12:35:16 GMT
Article-I.D.: chaos.bill.702650116
Organization: University of Minnesota, Minneapolis, CSci dept.

yk7m@uvacs.cs.Virginia.EDU (Young-Kuk Kim) writes:

>Hi, Database gurus:

>I have some questions about client-server model of DBMS.
>I am developing an experimental muti-user relational database management 
>system, based on a single-user relational database management system.
>I am going to make it a server and provide an interface to the clients.
>My question is what kind of programming interface the database server
>should provide for the clients.
>Currently, the single-user version provides a CURSOR-based API (Application
>Programming Interface) (OPEN, FETCH, PUT, GET, INSERT, UPDATE, and CLOSE).
>Do you think I should (or can) provide the same interface for multi-user
>version ?
>How can I specify a transaction in a client program ?

>Especially, I need some help from the people who have experience with
>Oracle API (or other server-based commercial DBMS API). 
>Oracle API seems to fit my purpose, but I don't have any document
>about the system.

i maybe wrong but it seems to me that the sql*proc manuals will
provide the information that you want.

--
bill@chaos.cs.umn.edu
From: shevett@dworkin.UUCP (Dave Shevett)
Newsgroups: comp.databases
Subject: Re: Foxpro -- What are all these files?
Date: 13 Apr 92 05:00:05 GMT
Reply-To: Dave Shevett <shevett@Amber.mccc.edu>
Organization: CSAccess BBS, Lawrenceville, NJ

douglas@netcom.com (Doug - MIS x7889) writes:
>In article <1992Apr11.182121.25772@acsu.buffalo.edu> v064qpfu@ubvmsb.cc.buffalo.edu (Christopher S. D'Arrigo) writes:
>>
>>	Can someone tell me what all these files are in my Foxpro
>>	directory.  I have a gazillion of them.  

>Chances are these are just index files, so you should be able to blow
>them away at any time -- if you have the program somehow auto-indexing,
>they should be re-created.  I think that there are seperate files for
>each field that you are indexing on for finds.

Bzzzt!  only partially right.  The files you are seeing are temporary
work files created by Fox usually when shelling out (executing a ! or
RUN command).  The 400000 byte files are 'foxswap' images.  If you are
running FoxPro 2.0, it will sometimes invoke FoxSwap, which swaps out
the low-memory resident portion of FoxPro to a temporary disk file,
freeing up lots of low ram.  

However, if a) your program craps out in the foxswap, or b) you shut 
the machine down before it can 'house clean', then they stay around on
the system until you delete them (look for .TMP files also).  Usuaally
a quick DEL *. will get rid of them.

Oh, by the way - run a CHKDSK /F while you're at it.  If you're gettting
lots of temp files, chances are your crapping out a lot, or you are
shutting the machine down before it's had a chance to exit cleanly.  Doing
this also leaves clusters open all over the place.  Run the chkdsk, then
check for .CHK file in the root directory (C:\) - betcha you'll find a lot
of them.

.------------------------------------------------------------------------.
| Dave Shevett  Lawrenceville, NJ | FoxPro mailing list -- Mail for info |
| shevett@dworkin.Amber.mccc.EDU .---------------------------------------+
+-------------------------------/  "Have you ever heard of the Murk?"    |
| 10 points if you can ID this --> "Sure!  That's first year stuff..."   |
`------------------------------------------------------------------------'
Newsgroups: comp.databases
Subject: SQL Time Conversions (EST<->DST)
From: luther_b@eis.dofasco.ca
Date: 7 Apr 92 09:36:16 GMT
Organization: Dofasco Inc, Hamilton, Ont. Can.
Nntp-Posting-User: luther_b

We store dates and times in our database in Eastern Standard Time. When
Daylight savings time kicks in, we need to convert it. We have some 3GL
functions that will do it in our applications, but what about the general SQL
user? Has anyone written some SQL code to output a date/time in Daylight
Savings Time? If so, we would appreciate a look, if that's possible. We are
using SYBASE SQL Server under VMS.

Thanks,
Brian

-- 
/------------------------------------------------------------------------------\
| Brian Luther                                   Dofasco Inc.                  |
| (luther_b@eis.dofasco.ca)                      IAS - Beach Rd.               |
| (416)548-4610                                  1330 Burlington St. E.        |
|                                                Hamilton, Ont. L8N 3J5 Canada |
\------------------------------------------------------------------------------/
 \        The opinions expressed on USENET are mine, and mine alone.          /
  \                  I do not speak for DOFASCO Inc.                         /
   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^