HDTenEightyP/NetNews huggingface dataset:
From: afataar@casper.cs.uct.ac.za (Aneekah Fataar)
Subject: sdm model to relational model
Keywords: conversion
Organization: Computer Science Department, University of Cape Town
Distribution: a
Date: Wed, 2 Sep 1992 15:58:23 GMT



 Hi there..

As part of an Honours project I have to convert (map) input from a
semantic database model to a relational model.  The SDM model serves
as the user interface.

I am using Informix with SQL.

Any references or ideas will be appreciated  ASAP.

Thanx.

Aneekah Fataar
Honours 1992
University of Cape Town
South Africa

From afataar Wed Sep  2 17:57:06 1992
From: afataar
Newsgroups: comp.databases
Distribution: a
Subject: SDM to relational model
Keywords: conversion



 Hi there..

As part of an Honours project I have to convert (map) input from a
semantic database model to a relational model.  The SDM model serves
as the user interface.

I am using Informix with SQL.

Any references or ideas will be appreciated  ASAP.

Thanx.

Aneekah Fataar
Honours 1992
University of Cape Town
South Africa


Newsgroups: comp.databases
From: jwd@rivm.nl (Jan Diesel)
Subject: dBase to Ingres conversion
Organization: R.I.V.M.
X-Newsreader: Tin 1.1 PL5
Date: Thu, 3 Sep 1992 11:25:40 GMT

I'm posting this for a colleague who expects to receive several
dBase III+ tables on a regular basis in the near future. Each
shipment consists of exactly one dBase III+ table.
We need to convert the dBase data to Ingres so we're looking for
software that creates and fills an Ingres table from the original
dBase data.
Does anyone know if something like this exists ?

Thanks in advance,
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Jan Diesel              jwd@rivm.nl           phone: ..(31) 30 - 742067
RIVM - National Institute of Public Health and Environmental Protection
       Informatics Service Centre
       P.O.Box 1, 3720 BA  BILTHOVEN, the Netherlands.
From: icarus!mbu@fokus.gmd.de (M. Burak)
Newsgroups: comp.databases
Subject: Re: printing memo fields in dbase4 v1.1
Date: 26 Aug 92 09:58:14 GMT
Followup-To: Re: printing memo fields in dbase4 v1.1
Organization: GMD-Fokus (Berlin)

In articel <14958@umd5.umd.edu> Chibuike O. Nwaeze writes:

>
>       Can someone tell me how to print memo fields in the report generator
> of Ashton Tate Dbase4.  I have 3 dbf files, one of the dbf files contains the
> memo field.  I have modified the report .FRM file to accept memo files which I
> believe have the template {VVVVVVV}.  However, whenever I run the program
> only the fields print out to the file.
>
>        any information will be appreciated.
>
>
> -Chibuike.

If you want to print memo fields use a command like "?? Variable_name FUNCTION "V70" AT 
Number" where Variable_name is the name of your memo field, V70 restricts the output
to 70 characters per line vertically and AT number means where the output starts. But
this is for .FRG files. If you want to enter data into a memo field, use the following:
"@ GET Variable_name". To enter data, press CTRL+Home.

Hope that helps,

Markus


--
Markus Burak 				burak@fokus.gmd.dbp.de
National Research Corporation		voice: +49-30-25499-262
for					FAX: +49-30-25499-202/168
Mathematics and Data Processing
(GMD-FOKUS)
Berlin Germany
	
		Research Center for Open Communication Systems
Newsgroups: comp.databases
From: roseberry@taney.uscghq.uscg.mil
Newsgroups: comp.databases
Subject: Databases using OSI
Date: 28 Aug 92 07:18:34 EST
Organization: United States Coast Guard


	What database products claim to have hooks into OSI ?

	Like a good little government office we are specify GOSIP
	but I don't recall any databases making claims for OSI
	although most seem to support TCP/IP.

	- Bert Roseberry
	  US Coast Guard

	  roseberry@taney.uscghq.uscg.mil
From: doug.hewko@synapse.isis.org (Doug Hewko) 
Newsgroups: comp.databases
Subject: Re: Database library for
Date: 25 Aug 92 13:42:00 GMT
Distribution: world
Organization: SYNAPSE BBS - GATINEAU, QUEBEC - 819-561-4321
Reply-To: doug.hewko@synapse.isis.org (Doug Hewko) 

Is there a technique that is used by Systems Analysts that could help
me decide on the best searching procedure for a personal database system
that I am developing?  I am cr eating a database system to reference
various newspaper, magazine and trade journal articles, and I am
undecided between two methods.  BTW, I am using DataEase for this
project.

The first method is to use Keywords to reference the articles.  My
definition of a keyword is a very short (one or two word description)
of something, or the name of an itme (ie. company name, product name,
etc).

The other method is more complicated but would have abstracts (ranging
from one or two lines for newspapers and magazines to 500 words for 
trade journals) that would be searched.  The mechanics of the
searching procedure has not yet been decided upon.

Any assistance is appreciated.  Thanks.

..Doug Hewko
---
 . DeLuxe. 1.25 #483sa . The majority is always wrong.
                                                                                          
Xref: sparky comp.databases:6493 comp.databases.ingres:1283 comp.databases.informix:1861
From: aaj@cmutual.com.au (Tony Jambu)
Newsgroups: comp.databases,comp.databases.ingres,comp.databases.sybase,comp.databases.informix
Subject: Any Financial Institution out there?
Date: 2 Sep 92 05:19:06 GMT
Organization: Colonial Mutual Life Australia


Hi there netters,

I work for a financial institution (Colonial Mutual Life Assurance/Colonial
Mutual Investment Management) in Melbourne, Aust and am interested in
contacting other financial institutions that use relational databases.  By
financial intuitions, I mean banks, insurance companies and investment
houses.

There are really two reasons for this posting, the 1st is a request by my
company to enquire about what other financial institutions are using in
their company.  The second reason, which is what I am interested in is to
contact any investment houses out there that use RDBMS.

We are in the process of moving away from network databases to relational and
would like to know what everyone else is doing, the problem they have had, the
software they are using etc.

The following are some of the questions I have.  I would appreciate any
response you may have emailed directly to me.  If you are not a financial
institutions but know of other that use RDBMS, that information would be
useful.


1.  What is your company's name and where are you based?
2.  What line of business is your company in?
3.  How big are they?
4.  Where are you based?
5.  How big is you information technology division and the area you are in?
6.  What type of RDBMS do you use?
7.  What type of applications are they used for?
8.  Are they written in-house or third-party?
9.  How long have your company been using the RDBMS?
10. What are you hardware configuration:
	- networking architecture and protocol used
	- number of Workstations/PC's
	- type of servers/mainframes and Op/sys
11. Do you have gateways between different Op/systems and databases?
12. Experiences with the RDBMS you use?


I hope I am not asking too many questions?  If you feel that any of the
questions are confidential, please do not answer them.

regards
tony

-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
Xref: sparky comp.databases:6444 comp.databases.informix:1832
From: randall@informix.com (Randall Rhea)
Newsgroups: comp.databases,comp.databases.informix
Subject: Re: Informix vs. Oracle
Keywords: informix oracle database rdbms
Date: 27 Aug 92 22:54:12 GMT
Organization: Informix Software, Inc.

sethg@dcatlas.dot.gov (Seth Grimes) writes:
>I say this is a typical salesperson BS.  Oracle is out in the lead by far,
>especially because Informix has ignored or abandoned important market 
>sectors like VAX/VMS.  Informix is a Unix DBMS; Oracle is on loads of
>platforms.  Oracle is integrating their DBMS with lots of applications;
>does Informix sell anything but the DBMS. 

Informix made a deliberate decision not to support VAX/VMS.  This
policy allowed us to provide better database engines and development 
tools for UNIX.  To do otherwise, or to start developing applications
software, would have spread our resources too thin.  It was not
a bad decision; we have had record revenues for several quarters
in a row.   Our stock price, which was lower than Oracle's in early
1991, is now 2-1/2 times higher, and our earnings-per-share
is much higher than our competition.  It is now widely recognized that
the UNIX market is growing, and the VAX/VMS market is declining.
We also run on "loads of platforms", but all of them are UNIX
or DOS.

Because Oracle runs on every platform under the sun, it takes them
forever to roll out a new product.   At my last company, Oracle salespeople
showed us a 35mm slide show about Oracle Version 7.  This was in 
July of 1990.  The product was not actually released until this
month ... two years later!   Talk about "vaporware!"  

I can tell you also that after working with Informix on a UNIX
platform, trying to develop applications with Oracle under VMS
was an eye-opening experience.   Not only is VMS an inferior
operating system for programmers (what?  No 'grep'?  No pipes?),
Oracle was a very complex, buggy, and frustrating product to
work with.  Their biggest weakness is the lack of a useful
4GL programming language.  We were left with only Oracle Cobol.
I made the wise move: I quit and started working for Informix.

>And lastly, Oracle has a great
>marketing department, although their hype caught up with them last summer
>when some of their accounting practices like premature recording of sales
>and penchant for vaporware became exposed.  How else could such a mediocre
>product have captured so much of the market?

That is quite correct: Oracle had the right marketing hype at the
right time.  Their "vaporware" and accounting practices got
exposed before last summer.  "Information Week" had a scathing cover
article in April of 1990, and several newspapers covered the
controversy in the summer of 1990.

-- 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Randall Rhea                                        Informix Software, Inc. 
Project Manager, MIS Sales/Marketing Systems    uunet!pyramid!infmx!randall
From: jeffs@matt.ksu.ksu.edu (Jeff Smith)
Newsgroups: comp.databases
Subject: Re: FoxPro vs Paradox
Date: 30 Aug 1992 16:56:24 -0500
Organization: Kansas State University
NNTP-Posting-Host: matt.ksu.ksu.edu

wcon9023@dsacng1.dsac.dla.mil (Frank Hardwick) writes:

>From article <1992Aug24.190545.28971@elroy.jpl.nasa.gov>, by baalke@kelvin.jpl.nasa.gov (Ron Baalke):
>> I've justed received from Borland an offer for Paradox 4.0 for $200.
>> It will retail for $795.  They also included literature saying how
>> much better and faster Paradox 4.0 is over FoxPro 2.0.  I would like
>> to see a comparison of these two products from a more objective source.
>> Anyone care to comment?
> 
> I also just saw an ad for Foxpro 2.0 for $199.00 with a free upgrade to 2.5
> when it ships.  I have been using FP 2.0 for about 6 months, but know
> nothing about Paradox.  I look forward to the same comments.

I just upgraded to Paradox 4.0.  The reason I went with Paradox is
becuase my clients require graphs to be made.  It seems that they
like to see their data displayed visually and they don't know
enough to do it using Spreadsheets so I automate everything using
a database.  I don't know if Foxpro allows graphs to be made or not....

Jeff Smith
jeffs@matt.ksu.ksu.edu

Xref: sparky comp.databases:6465 comp.databases.informix:1842
From: dtrum@jets.srg.af.mil (David E. Trum x4772)
Subject: Re: Informix vs. Oracle
Organization: ARINC Research, Corp.
Date: Thu, 03 Sep 92 21:02:33 GMT


Oracle version 6.0.33 on SCO Unix (386)or SunOS
is very simple to install.  It took me about 3 hours to
install it the first time from floppies (lot of them!)
including running the install both as "root" and as "oracle".

Now, after learning Oracle better I can install it from scratch
on a 486 in about 15 minutes (after reading the media).

Oracle version 6 is one of the most stable programs of
genre I've EVER run on a SCO box.

Further, it only took about 2 hours to install version 7
on a Sun Clone from a remote mounted CD-ROM while another
version 6 instance was running.

Oracle has its good and bad points, but it is definitely 
a rock solid piece of software that you can bet your business
on.

P.S.   It also helps if you know your O/S well.  For instance,
fiddling with /etc/passwd under SCO is not a good way to create
users (like on a Sun) because of the tcb stuff -- rather
use sysadmsh and /tcb/bin/authck.


-- 

#########################################################
David E. Trum
Database Administrator		Email:  uunet!srg!dtrum
ARINC Research Corporation	Phone:  (410)266-4772
2551 Riva Road  MS 5-230	Fax:    (410)573-3024
Annapolis, MD  21401-7461
#########################################################
--

#########################################################
David E. Trum
Database Administrator		Email:  uunet!srg!dtrum
From: wilsonl@iscsvax.uni.edu
Newsgroups: comp.databases
Subject: Paradox: Listing .VAL and .SET files HOW?
Date: 1 Sep 92 11:55:35 -0500
Keywords: paradox
Organization: University of Northern Iowa

Does anyone know of a way to list all the editing constraints developed for a
table in PARADOX?  These would the the constaints contained in the .VAL and
.SET files?  Help would be appreciated.

Leslie Wilson
University of Northern Iowa
From: bengsig@dk.oracle.com (Bjorn Engsig)
Newsgroups: comp.databases
Subject: Re: Is this a bug or a limitation of the SQL language
Date: 31 Aug 92 11:09:47 GMT
Reply-To: bengsig@dk.oracle.com (Bjorn Engsig)
Organization: Oracle Denmark

Article <87029@netnews.upenn.edu> by limsoon@saul.cis.upenn.edu (Limsoon Wong)
asked where this is found:
|>>>   The problem is that SQL is a poorly defined laguage.  Read Date's
|>>>   "Critique Of The SQL Language".  There are numerous examples like yours.
I have my copy in "C. J. Date, Selected Writings", published by Addison-Wesley.
The article itself originally occured in ACM SIGMOD Record 14, No. 3 (Nov 84).
-- 
Bjorn Engsig,		Internet: bengsig@oracle.com
ORACLE Corporation.	BANG-net: uunet!oracle!bengsig
			Private : bjorn@login.dkuug.dk.
From: chris@yen.imsi.com (Chris Payne)
Newsgroups: comp.databases
Subject: Re: Hot Standby DBMS's
Date: 25 Aug 92 16:30:32 GMT
	<1992Aug20.192538.17842@cbnewsl.cb.att.com> <BtB7Lo.26u@world.std.com>
Organization: Moore Capital Management
In-reply-to: edwards@world.std.com's message of 21 Aug 92 01:17:47 GMT
Originator: chris@yen


 One clean solution to the hot-backup equivalence problem is to
serialize the request stream.  Guarantee that when a credit precedes a
debit on one db server, it precedes the debit on all active servers.
If you want to catch-up a server which is down periodically, keep a
copy of the request stream.

 Ken Birman's (?) group at Cornell has a product called ISIS which
provides just this functionality.  I think the firm is called Isis
Development Corp.

/c
Newsgroups: comp.databases
From: jka@windshear.larc.nasa.gov (J. Keith Alston)
Subject: Re: Inserting charcters in typeahead buffer, DBASEIV
Organization: NASA Langley Research Center, Hampton, VA  USA
Date: Fri, 28 Aug 1992 12:50:11 GMT

In article <1992Aug27.182721.27790@cbfsb.cb.att.com>, ytsai@cbnewsf.cb.att.com (charles.tsai) writes:
|> In article <BtnCCq.D9L@news.larc.nasa.gov> jka@windshear.larc.nasa.gov (J. Keith Alston) writes:
|> >HI,
|> >    I'm trying to insert characters into the typeahead buffer in a DBASEIV
|> >    application. I'm looking for something that does what the "keyboard"
|> >    command in clipper or foxpro does. Any ideas on this would be greatly
|> >    appreciated. Thank-you.
|> >
|> >-- 
|> >************************      Don't just do it!     ***********************
|> >Lockheed Eng. and Sci. Co./Nasa Larc|J. Keith Alston jka@windshear.larc.nasa.gov
|> 
|> Keith,
|> 
|> Are you sure you have dBASE IV installed?  The "keyboard" command
|> is just several fingertips away!
|> 
|> In my previous message, I include an example of using the "keyboard"
|> command.  Have you tried it???
|> 
|> Please don't tell me you can't find it in dBASE IV reference book!!!
|> 

I can't find it in the reference book, because its not there.
I've tried using the keyboard command and I get:

  unrecognized command verb. 

I think that the problem may be that I'm running with an older version
of Dbase IV. It's version 1.0. Maybe later versions of DBaseIV have the
"keyboard" command. But this version doesn't. Can this be true? Any comment
you DBASE IV experts out there?
-- 
************************      Don't just do it!     ***********************
Lockheed Eng. and Sci. Co./Nasa Larc|J. Keith Alston jka@windshear.larc.nasa.gov
From: aahz@netcom.com (Aahzmandius)
Newsgroups: comp.sys.novel,comp.databases
Subject: Re: Unexpected Errors with Paradox on Novel
Date: 24 Aug 92 03:13:28 GMT
Organization: Bill 'n' Opus for Prez

In article <1992Aug21.142816.9227@eng3.sci.com> joe@eng3.sci.com (Joe LaRocque) writes:
>We are having some problems in running Paradox 3.5 on a Novell 3.1 network.
>When executing Paradox we sometimes receive 'unexpected errors' and are
>dropped back to DOS.  The error codes we are seeing are:
>
>	1.  4C7CGP0057
>	2.  0492GP14D7
>	3.  02E6GP00FF
>		or
>	4.  469DGP1B57

The info from Borland tech support is that the "GP" in the middle stands
for "General Protection fault", which is an abort signal from the
processor after an illegal memory address.  The two four-digit hex
numbers on each side are the address itself.

Essentially the numbers are meaningless without knowledge of what steps
occurred before the error.  Supposedly, running with the -real option
can report better error messages.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

So much Astroglide.  So little time.
Newsgroups: comp.databases,comp.software-eng
From: ylee@bronze.ucs.indiana.edu (Yao-Chung Lee (Raymond))
Subject: WANTED:  Info on Client-Server CASE Develop. and Mgmt tools
Summary:  Development and Project Management CASE Tools
Organization: Indiana University
Date: Mon, 24 Aug 1992 00:42:00 GMT

Greetings Netlanders,

	I am looking for Client-Server CASE and Project tools which will
aid our downsizing process.  If you have experience with any, could you
please email me the vendor's name/tel.  Thank you in Advance.  I will
post a summary if there is sufficient interest.


-- 
-------------------------------------------------------------------------------
Raymond Lee                   	Bitnet  : ylee@iugold.bitnet 
     				Internet: ylee@ucs.indiana.edu
                                UUCP: {ames,rutgers,att}!iuvax!silver!ylee
Newsgroups: comp.databases
From: gtoal@pizzabox.demon.co.uk (Graham Toal)
From: mathews@bones.ecs.umass.edu (Mathew J Mathews)
Subject: Informix vs. Oracle 
Keywords: informix oracle database rdbms
Organization: University of Massachusetts, Amherst
Date: Wed, 26 Aug 1992 23:13:13 GMT

My boss was recently told by a salesman that Informix would soon be the new
RDBMS standard on top of Oracle.  Needless to say, she asked me to investigate.
I have not been able to find very much written on Informix.  Could anyone
give me their 2 cents, and/or point me to a good source of info?

Thanks,

Mathew J. Mathews
Univ. of Massachusetts at Amherst
mathews@risky.ecs.umass.edu

#disclude <inclaimer.h>




Newsgroups: comp.databases,bit.listserv.sas-l
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: DB/statistical sw called FAME?
Organization: U.S Dept. of Transportation
Date: Sat, 29 Aug 1992 21:32:24 GMT

If anyone has heard of or knows anything about data management and
statistical analysis software called FAME, I'd like to hear the 
basics and get contact information on the company that sells it.
Please e-mail to me at dcatlas!sethg@uunet.uu.net.
Thanks,

Seth Grimes, Automated Sciences Group (U.S. Dept. of Transportation)
From: wcon9023@dsacng1.dsac.dla.mil (Frank Hardwick)
Newsgroups: comp.databases
Subject: Re: FoxPro vs Paradox
Date: 28 Aug 92 00:01:49 GMT
Organization: Defense Logistics Service Center, Battle Creek, MI

From article <1992Aug24.190545.28971@elroy.jpl.nasa.gov>, by baalke@kelvin.jpl.nasa.gov (Ron Baalke):
> I've justed received from Borland an offer for Paradox 4.0 for $200.
> It will retail for $795.  They also included literature saying how
> much better and faster Paradox 4.0 is over FoxPro 2.0.  I would like
> to see a comparison of these two products from a more objective source.
> Anyone care to comment?
 
 I also just saw an ad for Foxpro 2.0 for $199.00 with a free upgrade to 2.5
 when it ships.  I have been using FP 2.0 for about 6 months, but know
 nothing about Paradox.  I look forward to the same comments.
 Frankk
______________________________________________________________________________
Frank Hardwick
Wilson Hill Associates, INC>
(616)961-4053
InterNet: wcon9023@dsacng1.dsac.dla.mil

My opinions are not even my own, certainly not anyone elses!!
______________________________________________________________________________
Newsgroups: comp.databases
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Biographical/Historical database?
Organization: U.S Dept. of Transportation
Date: Thu, 27 Aug 1992 02:11:08 GMT

dbeedle@rs6000.cmp.ilstu.edu (Dave Beedle) writes:

>   I'm not sure how to describe this but...I've got a user who whould like a 
>database system to track biographical and historical type information.  The 
>data she has collected does not fit well into the typical database structure; 
>some of it does but one part in particular is pretty much free form text.  
>This text is biographical or historcal in nature.  I'm familiar with dBase and 
>in those terms a  memo  field would be the closest thing.  The probem with 
>memo fields is manipulating and printing them out...they are also not big 
>enough.  Any body got any ideas as to a database which might handle this kind 
>of information best?  Thanks!

You should look into a text-retrieval system.  Topic from Verity, Inc., is an
example.  We run it at my site although I don't use it myself.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Sciences Group (U.S. Dept. of Transportation)
Newsgroups: comp.databases
From: ytsai@cbnewsf.cb.att.com (charles.tsai)
Subject: Re: Inserting charcters in typeahead buffer, DBASEIV
Organization: AT&T
Date: Mon, 31 Aug 1992 20:40:25 GMT

In article <mr.715283007@ogre> mr@ogre.cica.indiana.edu (Michael Regoli) writes:
>In <Btp2Bo.4yC@news.larc.nasa.gov> jka@windshear.larc.nasa.gov (J.
>Keith Alston) writes: 
>
>>I can't find it in the reference book, because its not there.
>>I've tried using the keyboard command and I get:
>
>>  unrecognized command verb. 
>
>>I think that the problem may be that I'm running with an older version
>>of Dbase IV. It's version 1.0. Maybe later versions of DBaseIV have
>>the "keyboard" command. But this version doesn't. Can this be true?
>>Any comment you DBASE IV experts out there?
>
>
>Indeed.  The "keyboard" command is new with dBaseIV 1.5.

Nope, it has been there since dBASE IV 1.1.

>--
>michael regoli
>mr@cica.indiana.edu
>regoli@iubacs.BITNET
>..{ames, rutgers}!iuvax!cica!mr

-- Charles Tsai  ytsai@usl.com
# speak for himself #
From: barron@lsl.co.uk
Newsgroups: comp.databases
Subject: Ingres query optimisation timeout
Date: 2 Sep 92 12:16:07 GMT
Organization: Laser-Scan Ltd., Cambridge

Hello,
      I am using Ingres (ver 6.3) on VAX-VMS (ver 5.5). I would like to
increase the timeout period for Ingres query optimisation. I tried
DEFINE ING_SET "set joinop notimeout", but query optimisation ran out of
virtual memory. I need to know the current value of the timeout period to
get a feel for what to change it to (documentation says timeout period is
CPU time, but milliseconds, microseconds?). I can set it, but how do I
get the current (default) value?

   Thanks,
          Barry
Xref: sparky comp.databases:6445 comp.databases.informix:1833