HDTenEightyP/NetNews huggingface dataset:
From: afataar@sun-4.cs.uct.ac.za (Aneekah Fataar)
Subject: SDM interface to a relational model
Summary: Honours Project 1992
Keywords: SDM, interfaces, relational db, mappings
Organization: University of Cape Town
Distribution: all
Date: 10 Apr 92 08:32:17 GMT

As an Honours project (at UCT, Cape Town) I have to construct an SDM interface to a relational database.  Although using the Entity realationship model has been suggested, I would rather use the model defined by Hammer and McCleod [ACM TODS 6].  The system must be interactive, executing a single data definition/insert/update/delete etc statement at a time.  The data will be stored in a conventional relational database ( I might use INGRES as I want to work with X windows).  The user deals with objects orga




nised in classes , comprising several attributes.  I must be able then to convert from SDM to a relational scheme and mappings from complex objects onto normalised relations.

I would appreciate any hints, suggestions or ideas on this matter.  

Please send all mail to : afataar@cs.sun-4.ac.za

Thanks!   
Aneekah Fataar (UCT)
Newsgroups: comp.databases
From: douglas@netcom.com (Doug - MIS x7889)
Subject: Re: Foxpro -- What are all these files?
Date: Sun, 12 Apr 92 00:08:15 GMT
Organization: Approach Software Corp.  Redwood City, CA  94063

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.

-DM


-- 
Douglas Mason                                    douglas@netcom.COM
Network administration / software development    douglas@netcom.UUCP
Approach Software Corporation                    +1 415.306.7889
From: mlw@gator.rn.com (Mike Willig)
Newsgroups: comp.databases
Subject: Oracle question
Date: 14 Apr 92 20:01:36 GMT
Organization: The Gator Public Access Unix Site

Anybody seen this before?
 
We are trying to bring oracle version 5.1.22 up
on a sun 3/160 running SunOS 3.5. Everytime that
we do an ior init we get the following...
 
ie0: spurious interrupt 
ie0: cmd not accepted
panic: iechkcca
syncing disks...
<< and a lot of other fun boot messages >> 
 
I know it looks like an ethernet problem, but we
swapped out the ethernet controller (cpu board)
and still get this. If we leave oracle down,
the 3/160 stays up and on the network just like
it sould.


Please email any response, as I don't subscribe to this
news group. Thanks in advance.

                                -Mike

--
Mike Willig
The Gator
219-289-0777/317-251-7391
internet: mlw@gator.rn.com
uucp: ..!uunet!trauma!mlw
From: smacleod@caper1.uccb.ns.ca
Newsgroups: comp.databases
Subject: Clarion Professional Forum
Summary: Starting a Clarion forum
Keywords: clarion
Date: 15 Apr 92 17:28:10 GMT
Organization: University College of Cape Breton

Hello Internet Users
Is there any interest in creating a user discussion area for Clarion 
Professional Developer users. I am a relatively new user on this NEWS 
service and so am not sure if there is some sort of protocol to be followed 
in starting a new discussion area. However by the look of some of the 
discussion topics on here I don't feel I am abusing this system by posting 
such a request. Thanks 
Newsgroups: comp.databases
From: zats@leland.Stanford.EDU (yuri zats)
Subject: DataEase & Novell 3.11
Organization: DSG, Stanford University, CA 94305, USA
Date: Tue, 7 Apr 92 17:34:57 GMT


I have upgraded my Novell network from ver 2.15 to 3.11. However,
I am experiencing problems running DataEase off the workstations
with the new shell (Database error 20 when logging in).         
Did anyone else have this problem, and what can be done about it ?
      
	Thanks in advance for response.


-- 
                        *    *    *    *    ******     *
		         *  *     *    *    *    *     *
			   *      *    *    ******     *
			  *       *    *    *   *      *
From: bill@chaos.cs.umn.edu
Newsgroups: comp.databases
Subject: Re: Implementing Referential Integrity ( Possible in Oracle ?)
Date: 15 Apr 92 09:40:03 GMT
Article-I.D.: chaos.bill.703330803
Distribution: usa
Organization: University of Minnesota, Minneapolis, CSci dept.

kortikar@mipos2.intel.com (Aniruddha Kortikar) writes:

>Consider following tables

>Item-vendor table				Vendor Table
>-----------------------				----------------------------
>Item_code,vendor_code				vendor_code,name,address etc.

>Following rules have to observed

>1. Vendor can not be deleted if used in item-vendor table.
>2. every vendor in item-vendor table must be present in vendor table.

>Rule 1 - can be enforced by putting appropriate triggers (key-delrec etc)
>	 in data entry programs of vendor table.

>Rule 2 - this is a problem issue.


>Consider following scenario

>Time 	User1 Action			User 2 Action

>10:30   Selected Add data 
>        For Adding Data into 
>	Item-vendor table

>10:31  Checked existence of vendor     
>       code v1

>10:33					deleted vendor v1
>					(Succedded because there was
>  					 no entry in item-vendor table)

>					Commited.
>10:35  commited transaction.

>Now item-vendor table contains vendor which does not exist.

>Checking the reference at commit time also DOES NOT solve the problem, because
>there is still a time gap however small between two statements which check the
>existence of reference and commiting of data. (essentially the refrence checking
>and commit is not atomic.)

>If my understanding is correct Oracle does not allow me to put lock on a row
>so that user 2 will not be able to delete it. (select for update type of lock
>is no good becuase then TWO people can not add different items for same vendor)

>I need a lock of type xxx that will prevent write or delete or update but will
>allow another lock of type xxx (or any number of those.), hence the delete has 
>to fail if ANY occurance of xxx type of lock exists.

>there is no direct way of doing this by using oracle supplied lock(s).

>Is my understanding correct or am I missing something.

>(In any case how do other major RDBMS's handles issue of refrence checking ?)

>Thanks In Advance. 

i believe that informix currently allows rules to be instilled in the
database, and that oracle v7 will also allow it, don't know the status of
ingress on this topic. i.e. stored procedures
someone correct me if i'm wrong :) yea right as if anyone would let
me slide :-{)>

--
bill@chaos.cs.umn.edu
From: wildman@athena.mit.edu (Timothy Worsley)
Newsgroups: comp.databases
Subject: Re: E-R modelling ?= 5th Normal Form
Date: 17 Apr 92 03:19:44 GMT
Reply-To: eprice@sql.sybase.com
Organization: Massachusetts Institute of Technology

cdm@pmafire.inel.gov (Dale Cook) wrote:

 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?

maurik@hope.pp.fi (Mauri Ketola) responded:

 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...

NO NO NO NO NO NO NO NO NO NO! and not just because of the sexism in that
remark...

Models of reality are always a matter of taste.  However, I think
there is far too much emphasis on "heirarchical" structures in RDBMS
design.  The R in RDBMS means "relational"! In fact, "Employment" is a
*relationship* between a person and an organzation.  Why not model it
that way?  For example:

ORGANIZATION (ID, NAME, ...)
PERSON (ID, NAME, ...)
EMPLOYEE (ID, ORGANIZATION-ID, PERSON-ID, START-DATE, END-DATE)

for those who like ASCII boxes:

+---+    +---+    +---+
|Org|---
---|Per|
+---+    +---+    +---+

Now there is none of this stupid dominant/subordinate issue to worry
about.

I generally try to stay out of these kinds of discussions...  but I
have seen far too many people who build really stupid applications
because they were not thinking in terms of entity-relationships but in
entity-heirarchies.

As an aside:  this applies perhaps even more strongly to the design of
a front end to a database.  I *hate* front ends that are based on a
"screen heirarchy".  I want to be able to traverse the relationships
between the entities in the database.  Seems reasonable to me!

-Ed Price
eprice@sql.sybase.com
NB I am speaking for myself.  This is all IMHO, but based on experience.
From: deej@cbnewsf.cb.att.com (david.g.lewis)
Newsgroups: comp.dcom.telecom
Subject: Re: ISDN in Houston, Texas
Date: 7 Apr 92 13:51:03 GMT
Article-I.D.: eecs.telecom12.302.3
Organization: AT&T
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 302, Message 3 of 10

In article <telecom12.299.4@eecs.nwu.edu> hd@rice.edu writes:

> Does anyone KNOW what is involved in upgrading a DMS-100 from POTS
> to ISDN?

Disclaimer: since I work for AT&T, I obviously don't KNOW what is
involved in upgrading a DMS-100 from POTS to ISDN. However, I have
some anecdotal evidence.  In a previous life, I had a customer who
operated a Northern Telecom SL-100 PBX, which is the PBX incarnation
of the DMS-100.  They wanted to upgrade it to ISDN and were told that
it would require an upgrade to a DMS SuperNode (which, someone from
NTI correct me if I'm wrong, is essentially a brain transplant), which
would cost in seven figures.

That's why they became my customer ;-)


dave
From: john@zygot.ati.com (John Higdon)
Newsgroups: comp.dcom.telecom
Subject: Re: Pac*Bell Employees Win Big From Radio Station's Contest Lines
Date: 12 Apr 92 18:03:00 GMT
Reply-To: John Higdon <john@zygot.ati.com>
Organization: Green Hills and Cows
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 315, Message 5 of 11

slr@cco.caltech.edu (Steve L. Rhoades) writes:

> This could give the callers an advantage if 800-232 was set up as a
> "Choke" prefix; i.e.  Returning an "All Circuts are Busy" to those
> callers routed through AT&T.  (But wait, I didn't think AT&T was
> allowed to carry INTRA-Lata traffic?!)

It could also be a Pac*Bell 800 number where PB carries the intra-LATA
traffic and AT&T handles the rest. I have such a number (800-282) and
the payment goes to Pac*Bell. It is directed to a dedicated POTS
number, which the "insiders" probably looked up.

However, as a sidebar, I assume you were joking about IEC's not being
allowed to carry intraLATA traffic. Technically, the tariffs only
prohibit the IEC from OFFERING to carry or advertising that they will
carry intraLATA traffic. The hard reality is that many larger firms
routinely use AT&T, MCI, Sprint and others to carry all of their
intraLATA calls. And they save a bundle doing so. All it takes is a
trunk-side connection to one of the IEC's switches and the deed is
done. And Pac*Bell cannot do anything about it (except use harsh
language on occasion).

This is the main reason that Pac*Bell is so desperate to get its
"intraLATA competition" package passed by the PUC. It is not trying to
save anyone money; it simply wants to hold onto the business that is
steadily slipping away as more and more companies are fed up with the
confiscatory rates for intraLATA calls. Nearby toll call prices in
California are the biggest ripoff in the country. Pac*Bell has learned
the hard way that no matter what the rules or tariffs, if you price a
commodity far enough above reasonable market value, there will be
those who find a workaround.

> The radio station, K-EARTH 101, stated it would withold the prize
> awards until this mess is straightened out.

As well they should! I guess ripping the station off for its nearby
toll calls was not enough!


        John Higdon         |   P. O. Box 7648   |   +1 408 723 1395
    john@zygot.ati.com      | San Jose, CA 95150 |       M o o !
From: johng.all_proj@comm.mot.com (John)
Newsgroups: comp.dcom.telecom
Subject: Cellphone ESN Xfer
Date: 9 Apr 92 18:52:31 GMT
Article-I.D.: eecs.telecom12.311.4
Organization: Motorola, Inc. LMPS
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 311, Message 4 of 11

In article <telecom12.298.9@eecs.nwu.edu> wmartin@STL-06SIMA.ARMY.MIL
(Will Martin) writes:

> Monty Solomon <monty@proponent.com> wrote:

>> They are offering a new service called Maintenance Plus with the following
>> benefits for $5/month:

>>    Use of a loaner phone (same number) if repair will take > 1hr;
>>    ...      ^^^^^^^^^^^^^^^^^^^^^^^^^
>                   NOTE

> Hmmm. A loaner phone with the same number. This means two cellular
> phones with the same number, at least on a temporary basis. Doesn't
> this conflict with all the previous traffic on how it was impossible
> or would create unresolveable conflicts?

> Or are these people updating the cellular database during the period
> the loaner is in force to change the pointer from phone number to
> serial number to that of the loaner, and then changing it back again
> after the loaner is returned? If so, that proves this database update
> is so trivial that no cellular company has any business charging
> anything for doing this when a new phone is "installed" ... :-)

Newer models of Motorola phones have a service feature where the ESN,
NAM and repertory memory can be transferred from a broken phone into a
"Universal loaner." This is done over the radio bus using a special
transfer cable kit.  After the personality is transferred to the
loaner, the ESN in the broken unit changes to FFFFFFFF.  The serial
number in the broken phone will be reset to 00000000 by the Motorola
depot after the phone is repaired.  The ID of the receiving unit must
be 00000000 to receive a new ESN.
   

               BROKEN PHONE    UNIVERSAL LOANER
ESN             821EBED4        00000000     before
transfer        FFFFFFFF        821EBED4     after
to loaner

repair at       00000000        
depot
                                
ESN transfer    00000000        821EBED4    before
to customer     821EBED4        00000000    after

If the processor or memory has died and transfer doesn't work, the
phone must be returned to the Moto depot and a new ESN may come back
on the phone.


John Gilbert  KA4JMC                           
Secure and Advanced Conventional Sys Div   
Motorola Inc, Land Mobile Products Sector  
Schaumburg, Illinois johng@ecs.comm.mot.com
From: bruce@zuhause.MN.ORG (Bruce Albrecht)
Newsgroups: comp.dcom.telecom
Subject: Re: Harassed by Mystery Fax/Modem Calls
Date: 1 Apr 92 05:53:42 GMT
Article-I.D.: eecs.telecom12.298.8
Organization: TELECOM Digest
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 298, Message 8 of 9

>> [Moderator's Note: We had a FIDO BBS here in Chicago about five or six
>> years ago which was placing calls in the middle of the night to a
>> 79-year old woman ... for a month straight. IBT put the BBS out of
>> business; showed the sysop no mercy at all when the lady indicated she
>> wanted to prosecute. Hint: keep those phone numbers accurate, folks!  PAT]

There was a case in Minnesota a year or two back, where someone's BBS
called a correctly dialed phone number for about three days, and kept
getting incorrectly switched to someone's phone.  He reported it to
the phone company, they fixed the problem, and the city attorney had
him arrested for making harrassing phone calls.  Don't know the final
outcome, though.


bruce@zuhause.mn.org
From: oilean.oilean!joe@uunet.UU.NET (Joe McGuckin)
Newsgroups: comp.dcom.telecom
Subject: Seeking Used Teltone Line Simulator
Date: 9 Apr 92 04:54:07 GMT
Article-I.D.: eecs.telecom12.311.2
Organization: Island Software
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 311, Message 2 of 11

I guess the subject says it all. I could use either the two line or
the four line version.


Joe McGuckin      oilean!joe@sgi.com
Island Software   (415) 969-5453
From: rop@hacktic.nl (Rop Gonggrijp)
Newsgroups: comp.dcom.telecom
Subject: Re: Caller*ID Stops a Telemarketer
Date: 8 Apr 92 22:11:32 GMT
Organization: Hack-Tic Magazine
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 307, Message 1 of 10

nagle@netcom.com (John Nagle) once wrote ...

> If you are called by a junk caller, you post the number to a USENET
> group.  An application then downloads all junk numbers identified by
> anyone on the net, and applies them to your incoming calls.  If this
> could be made effortless, it could be really useful.

What stops me or anyone else from sticking all the numbers for people
I don't like on the list (from a forged address?)? And more pressing,
what stops the people that don't like me from doing that to me? ;-)

You could design a system with public-key crypts so that you could
only trust numbers that came with signatures of people you trust, or
even groups of whom you trust the 'caretaker', who re-signs all the
numbers.

Then again: this whole discussion is one of finding the most
frustrating thing in life. If telemarketers went out, many people on
this forum would lose large part of their daily activities, if I
believe some of the posts here.


Rop Gonggrijp (rop@hacktic.nl), editor of        | fax:   +31 20 6900968
Hack-Tic Magazine (only on paper, only in Dutch) | VMB:   +31 20 6001480
From: wdp@gagme.chi.il.us (Bill Pfeiffer)
Newsgroups: comp.dcom.telecom
Subject: Re: Future of fax
Date: 9 Apr 92 07:27:13 GMT
Article-I.D.: eecs.telecom12.308.3
Organization: TELECOM Digest
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 308, Message 3 of 11

It amazes me how much variation there is in the quality of
transmission/recep- tion there is with different fax machines.  I
often wonder whether it is the scanning of the transmitted page or the
printing at the receive end which causes the bulk of this
inconsistancy.

I have send faxes which show up on the other end _better_ looking than
the original, and some which are darned near unreadable.  I guess it
(fax transfer) still beats the US Snail-Mail for routine
corespondance, or something which has immediate urgency and must be
delivered immediately, but until the quality can become more uniform,
and more comparable with, say, photocopying, it will still be, IMHO, a
poor second to an actual mailed piece.

It seems like, for the price, these machines could produce a far
better end product than is generally realized.


William Pfeiffer    wdp@airwaves.chi.il.us
Date: Sat, 11 Apr 1992 17:41:49 GMT
From: sdpage@andersen.co.uk (Stephen Page)
Newsgroups: comp.dcom.telecom
Subject: Re: Voice Drop-Outs on International Link
Organization: Andersen Consulting (UK Practice)
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 309, Message 8 of 8

In article <telecom12.245.2@eecs.nwu.edu> is written:

> from Australia (where I am!). ... -- it drops out when you stop
> talking, and there is a noticeable delay before the voice circuit
> re-opens, which chops off the first syllable of the next word. 

I got fed up with this a few years ago, especially as I was paying A$2
per minute for my calls between UK and Australia. In particular, it
annoyed me that only one person could speak at a time. Just for the
hell of it I wrote a complaint to the manager of the Overseas
Telecommunications Commission in Brisbane, and he (J.L. Banks) replied
as follows:

"The phenomena you query is [sic] caused by the need to include 'echo
suppressors' on all long-distance telephone circuits. As you may know,
a proportion of the 'received' signal in any telephone service tends
to be picked up by the transmitter and is therefore amplified and
re-transmitted back to the sender. In normal circumstances this is
virtually simultaneous with the main conversation and causes no
problem.

In a long-distance circuit, however, there is a finite delay in the
above and an 'echo' is the result, particularly when a satellite path
is in use. To reduce the echo problem an echo is used on each circuit
to cancel this echo.  Unfortunately this has the effect you describe
of an apparent 'half-duplex' circuit, even though we do in fact use a
full four-wire system for all international calls.

Development of more efficient equipment -- including echo suppressors
 -- is an ongoing challenge and it is probable that substantial
improvements may eventuate when ISDN or digitized voice channels
become the norm in the early '90s but until then I'm afraid you will
have to paraphrase Figaro -- 'one at a time for clarity's sake'."

Well, that was written on 2 January 1987 -- and his predictions
certainly haven't come true yet! (Although the letter is a model of a
helpful explanation ...)
From: arielle@taronga.com (Stephanie da Silva)
Newsgroups: comp.dcom.telecom
Subject: Re: Caller*ID Stops a Telemarketer
Date: 11 Apr 92 05:27:33 GMT
Organization: Taronga Park BBS
X-Submissions-To: telecom@eecs.nwu.edu
X-Administrivia-To: telecom-request@eecs.nwu.edu
X-Telecom-Digest: Volume 12, Issue 307, Message 5 of 10

In article <telecom12.298.11@eecs.nwu.edu>, john@zygot.ati.com (John
Higdon) writes:

> I suspect that if one would add up all the "phantom hangup callers"
> and all the telemarketing people that I might block from my residence,
> the number would be closer to 100 than 10.

You get to block ten numbers?  Consider yourself fortunate.  I only get
to block three (I haven't used any of them yet).


Stephanie da Silva     Taronga Park * Houston, Texas
arielle@taronga.com        568-0480   568-1032   


[Moderator's Note: We get ten here in Chicago also.   PAT]