HDTenEightyP/NetNews huggingface dataset:
From: mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney)
Subject: Re: Replicating Databases
Organization: Indiana University, Bloomington
Date: Mon, 31 Aug 1992 18:59:17 GMT

In article <1992Aug29.015046.1@gsbacd.uchicago.edu> cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes:
>In article <59970007@hpcc01.corp.hp.com>, amueller@hpcc01.corp.hp.com 
>(Amy Mueller) writes:
>> We are investigating different ways to perform database replication.  The
>> latest inquire_ingres newsletter had a good article describing the different
>> techniques.
>> 
>> Has anyone out there already done this?  If so, I'd like to learn of the
>> particular technique you used, and what works well and not so well.
>
>We've done this several times.  We use different methods depending on
>the need.  I think that the only Ingres-approved way is to use
>"unloaddb" to unload the database into data files, and then reload it
>into another one.  This is fairly robust, but slow.  Both "unloaddb" and
>"copydb" have a few bugs: (1) you can't have usernames that start with
>numbers (we do, of course); and (2) a table with more than one integrity
>on it gets all but the last integrity created twice.  Versions prior to
>release 6.4/01 had additional ones.

We just found another bug in the 6.4/01 version.  If you have a view that
references another view, they may be created out of order.  In that case,
the first view to be created (which references the second one) will abort
with a "non-existent table" error.  The second one will be created just fine,
and you'll have to manually create the first one.

I couldn't imagine too many people having views depending on views, though,
so I count this as only a borderline bug.

	Darrin
-- 

mdchaney@iubacs mdchaney@bronze.ucs.indiana.edu mdchaney@rose.ucs.indiana.edu

"It's a marvel of vegetable containment..."
From: mclo@rtf.bt.co.uk (John McLoughlin)
Newsgroups: comp.databases.ingres
Subject: Ingres 6.3 on SVR4
Date: 25 Aug 92 11:30:43 GMT
Organization: BT Customer Systems, Brighton, UK

Hello,

We are thinking of upgrading our SUN Sparc 2s from SUNOS 4.1.1 to Unix 
SVR4. We are currently running Ingres Release 6.3. on them.
Does anybody out there know of any problems / have any hints to
bear in mind while doing this.

Thanks in  advance,

John.
From: dtb@otto.bf.rmit.oz.au (David Bath)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres 6.3 on SVR4
Date: 27 Aug 92 01:10:59 GMT
Organization: RMIT Computer Centre, Melbourne Australia.

mclo@rtf.bt.co.uk (John McLoughlin) writes:

>Hello,

>We are thinking of upgrading our SUN Sparc 2s from SUNOS 4.1.1 to Unix 
>SVR4. We are currently running Ingres Release 6.3. on them.
>Does anybody out there know of any problems / have any hints to
>bear in mind while doing this.

Well -I came across a "RELIABLE RUMOR" that Ing 6.3 was not certified
for SUNOS 4.1 (aka Solaris 1), only 6.4 is.

Iw ould be surprised if 6.3 is certified by SVR4 (aka Solaris 2)

Any good info on this - let me know
regards

========================================================================
David T. Bath
email: 	dtb@otto.bf.rmit.oz.au
Work: 	Global Technology Corporation, Carlton, Vic, OZ  (03) 3477511
=======================================================================
Newsgroups: comp.databases.ingres,comp.databases.sybase
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: information request
Keywords: ingres, sybase
Organization: U.S Dept. of Transportation
Date: Mon, 31 Aug 1992 13:02:28 GMT

Customer support, software bug tracking, etc., are such common applications
that you should be asking not just what DBMS you should buy but what 
existing applications you can get your hands on and for how much.  For
instance, both database vendors you name undoubtedly have such applications
for their own internal use.  Get them to sell you the software along with
the DBMS.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Sciences Group (U.S. Dept. of Transportation)
From: beeram@next10.cs.umr.edu (Beeram Ranga Reddy)
Newsgroups: comp.databases
Subject: Need Info about the products of Gupta Technologies Inc.
Date: 4 Sep 92 20:02:01 GMT
Article-I.D.: umr.1992Sep4.200201.13320
Organization: University of Missouri-Rolla, Missouri's Technological University

I would like to know about the products of gupta technologies inc.
You could post in this group or mail to me.

Thanks.

Ranga Reddy Beeram

E-Mail: beeram@cs.umr.edu
Phone : (314)-364-5231

1803 Vichy Road
Rolla-MO 65401.
From: gonzalod@amex-trs.com (Gonzalo Diethelm)
Newsgroups: comp.databases
Subject: Btree/B+tree libraries
Date: 27 Aug 92 21:54:21 GMT



Distribution: world

Hello everyone,

I'm looking for a Btree or B+tree library, hopefully with source
code. The requirements are:

* Callable from C/C++.
* Usable under MS-Dog and MS-Windows 3.1
* Stores data and indexes in disk (as opposed to an in-memory
  implementation).
* Well documented... 8^)

Any help is appreciated. I did a search through Archie, but I couldn't
decide what could and could not be helpful. Public domain preferred,
shareware/commercial products are OK. Send responses through e-mail,
will summarize if there is enough volume. Thanks in advance and regards.


gonzalod@amexphx.amex-trs.com
Gonzalo A. Diethelm                 (602)375-8410  home
16220 N 7th St Ap 1314              (602)492-3536  office
Phoenix, AZ 85022                   (602)492-4248  FAX

gonzalod@amexphx.amex-trs.com
Gonzalo A. Diethelm                 (602)375-8410  home
16220 N 7th St Ap 1314              (602)492-3536  office
Phoenix, AZ 85022                   (602)492-4248  FAX
From: sandyc@elroy (Sandy Cox )
Newsgroups: comp.databases
Subject: FoxPro2 & Paradox 3.5 questions -
Date: 27 Aug 92 23:10:22 GMT
X-Newsreader: Tin 1.1 PL4


		I would appreciate any one who has had experience
	With FoxProx (2.0) and Paradox (3.5)  answering some questions
	for me.  My company is researching both Database products.

	1)  In FoxPro is it possible to call an external 'C' function
	from inside the FoxPro code?  Does it have to be a Whatcom C routine?
	and how do you do it?

	2)  Does FoxPro have complex string functions similair to Paradox?  


  	3) In FoxPro documentation it seems fairly easy to create screens and
	menus.  I can't see anywhere in Paradox documentation how one would
	create a screen ( not a form) and if you have a way could you please
	give a straight forward example..?

	4)  What are the pros and cons of one database package over another?
	I mean when one gets into the nitty gritty development, which one
 	is better?  and faster to develop in...

	Thank you for your answers in advance.  WE don't have a direct
	internet connection... if you don't want to respond to the mail
	system i am 
	
	sandyc@dsinet.uucp

	Thanks again.

Newsgroups: comp.databases
From: M14465@mwvm.mitre.org
Subject: Re: Q+E over a DDE link
Organization: The MITRE Corporation, McLean VA 22102
Date: Mon, 31 Aug 1992 11:21:16 GMT

The note above should have the signature Char Wales, MITRE Corp., e-mail
address:  charwing@mitre.org.  Forgive a netnews neophyte!
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
From: darius@edm.isac.ca (Darius S. Naqvi)
Subject: Re: Is this a bug or a limitation of the SQL language
Organization: ISA Corporation, Edmonton, AB
Date: Wed, 26 Aug 92 16:26:06 GMT

In article <1992Aug23.074048.16681@prism.poly.edu> sjha@prism.poly.edu (Salil Kumar Jha) writes:
>I tried to do this query in Oracle and DB2 and both failed. I know its
>not allowed but why not?
>
>Assume the use of the classic oracle emp table
>
>select * from emp 
>where salary between
>(select salary from emp where ename = 'Larry')
>and
>(select salary from emp where ename = 'John')
>
>Isnt this the best way of finding all people whose salaries lie between those
>of Larry and John (without knowing whose is larger)
>
>sjha@prism.poly.edu
>

Even if the syntax were allowed, you would still have to know that
John's salary were greater than or equal to Larry's, because

    where salary between x and y

is simply an abbreviation for

    where salary >= x and salary <= y

If x > y, the where clause will always fail, so you get no rows
selected.
-- 
Darius S. Naqvi              mail at work: darius@edm.isac.ca
ISA Corp.                    mail at home: darius%naqvi.uucp@isac.ca
Edmonton, Alberta, Canada           phone: (403) 420-8081 
Newsgroups: comp.databases
From: toddwall@rock.concert.net (Todd R Wall -- Catholic Diocese of Raleigh -- Computer Services)
Subject: Professional file <-> WP Sec converter
Organization: CONCERT-CONNECT -- Public Access UNIX
Date: Wed, 26 Aug 1992 15:37:13 GMT


	Does anyone know of a software package that will convert a 
professional file 2.0 database to a Word Perfect 5.1 secondary file??

	Please E-mail me if you know of one.

	Thanks.

o o ______           _     _____  _  _ o o  "But the fruit of the Spirit is
' '   /       /   / ' )   /      // // ' '   love, joy, peace, patience,
     / ______/ __/   / / / __.  // //        kindness, goodness, faithfulness,
   _/ (_) (_/_(_/_  (_(_/ (_/|_</_</         gentleness and self-control."
toddwall@rock.concert.net & todd@beretta.bacchus.org ^- Galatians 5:22-23 -^

-- 
o o ______           _     _____  _  _ o o  "But the fruit of the Spirit is
' '   /       /   / ' )   /      // // ' '   love, joy, peace, patience,
     / ______/ __/   / / / __.  // //        kindness, goodness, faithfulness,
   _/ (_) (_/_(_/_  (_(_/ (_/|_</_</         gentleness and self-control."
Newsgroups: comp.databases
From: mr@ogre.cica.indiana.edu (Michael Regoli)
Subject: Re: Inserting charcters in typeahead buffer, DBASEIV
Organization: Indiana University
Date: Mon, 31 Aug 1992 17:43:27 GMT

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.

--
michael regoli
mr@cica.indiana.edu
regoli@iubacs.BITNET
..{ames, rutgers}!iuvax!cica!mr
Newsgroups: comp.databases
From: marti@nugget.inf.ethz.ch (Robert Marti)
Subject: Re: nested SQL select
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Wed, 26 Aug 1992 07:21:42 GMT

In article <87028@netnews.upenn.edu>, limsoon@saul.cis.upenn.edu
(Limsoon Wong) writes in response to my article:
<1992Aug25.161811.6054@neptune.inf.ethz.ch:
|> >Editorial comment:  This posting is more of an academic exercise
|> >than of practical interest.  All I am trying to show is that any
|> >_pure_ relational algebra expression can be translated into a
|> >single SQL SELECT-statement -- for what it's worth ...
|> >
|> [stuff deleted]
|> >
|> >  project[...](R - S)  ---->  project[...](R) - project[...](S)
|> 
|> This one is not correct under the usual set-based semantics,
|> since after the omission of some columns, previous distinct
|> rows in R can become identified.

Oops.  Yes, you are right of course.  As far as I can see, my
argument that any pure relational algebra expression can be
translated into a single SQL SELECT-statement is still true
if the algorithm I proposed is modified as follows:

Don't use the incorrect transformation rule above.  Instead,
translate an RA-expression of the form

  project[<attribute-list>](R - S)

directly into an SQL SELECT-statement of the form

  SELECT <attribute-list>
  FROM   R
  WHERE  NOT EXISTS (SELECT * FROM S)

If R and S stand for more general RA-expressions than relation
names, the SQL SELECT-statement becomes somewhat more complicated:

  SELECT DISTINCT <attribute-list>
  FROM   ...
  WHERE  ...
  AND    NOT EXISTS (SELECT ...
                     FROM   ...
                     WHERE ...)

with the dots being filled in when recursively translating the
expressions corresponding to R and S.

I hope I didn't overlook something else.  Since -- as I said --
this is an academic exercise, I don't want to put any more of my
time into this.  (Do I hear sighs of relief out there? ;-)
Thanks for the correction, anyway.

-- 
Robert Marti                    |  Phone:    +41 1 254 72 60
Informationssysteme             |  FAX:      +41 1 262 39 73
ETH-Zentrum                     |  E-Mail:   marti@inf.ethz.ch
CH-8092 Zurich, Switzerland     |
Newsgroups: comp.databases
From: afataar@casper.cs.uct.ac.za (Aneekah Fataar)
Subject: SDM to relational model
Keywords: conversion
Organization: Computer Science Department, University of Cape Town
Distribution: a
Date: Wed, 2 Sep 1992 15:57:07 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

Newsgroups: comp.databases
From: linstee@dutecaj.et.tudelft.nl (Erik van Linstee)
Subject: Distributed databases question.
Organization: Delft University of Technology, Dept. of Electrical Engineering
Date: Thu, 03 Sep 1992 06:35:39 GMT

Can someone tell me how Progress (or Oracle) let you use a database
on another machine (over a network of course). Do they have utilities
(command line or interactive) that let you set up a query, and how
do they connect to the database (over novell netware or TCP/IP).
If you can give me a detailed description please do. I would specifically
like to know about Progress and Oracle, and do not hesitate to
get technical :-)

Erik

Delft University of Technology
Computer Science
Newsgroups: comp.databases
From: aahz@netcom.com (Aahzmandius)
Subject: Re: Listing .VAL and SET files HOW?
Date: Wed, 02 Sep 92 18:24:59 GMT
Organization: Bill 'n' Opus for Prez

In article <01GOB1CS55QQ0009KU@NAUVAX.UCC.NAU.EDU> DEVRIES@NAUVAX.UCC.NAU.EDU (Ernie DeVries) writes:
>Paralex by Kallista is a commercial product that does this quite well.

I'm sure that Alan Zenreich and Dan Ehrmann would both be much amused to
see this: Paralex by Zenreich is from Pal By Example, and Desktop by Dan
Ehrmann is from Kallista.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

So much Astroglide.  So little time.
Xref: sparky comp.databases:6321 comp.databases.theory:389 comp.databases.oracle:1375
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Subject: Re: Foxpro 2.0 ??
Organization: Colorado Software Solutions, Inc.
Date: Thu, 27 Aug 1992 23:34:49 GMT


In article <1992Aug27.211512.16246@magnus.acs.ohio-state.edu>, mtaghavi@magnus.acs.ohio-state.edu (Amir Taghavi) writes...
>In article <BtAqoy.FqJ@news.udel.edu> tedboone@freezer.cns.udel.edu writes:
>>
>>In article 2237@news.cs.brandeis.edu, rahul@chaos.cs.brandeis.edu (Rahul Chawla) writes:
>>>
>>>After struggling with Dbase IV I am finally inclinded to choose
>>>another package. I am interested in puchasing Foxpro 2.0 as I have
>>>heard a lot about. I would appreciate any comments on the following :
>>>
>>>1). Can FoxPro create stand alone executionable files, if so, is the
>>>compiler included with the regular version ?? ( I am interested in the
>>>LAN version.)
>>
>>Yes, FoxPro CAN create stand alone executionable files, for both extended
>>and non-extended memory users.  However, this is not included in the 
>>normal package.  If memory serves me right, it runs about $150.  It works
>                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>>nicely. 
> ^^^^^^
> 
> Do you know the name of the package? I am interested to buy it.

It is the FoxPro Distribution Kit, and includes the run-time compiler
(linker, really).  The Lan version will cost more than $150, but less than
$600.  We use the Lan version, and it works fine.  Quite quick, relatively
bugfree, reliable, and it handles multi-user conflicts well.  The automatic
conflict resolution can either keep trying or return an error for you to
handle.  In either case, it displays a message box telling you about it,
and letting you decide whether to keep trying.

Randy
From: on@uta.fi (Ossi Numminen)
Newsgroups: comp.databases
Subject: Georgia Tech
Date: 3 Sep 92 05:35:26 GMT
Distribution: world
Organization: University of Tampere, Finland

Please, forgive me for using this newsgroup to this kind of question,
but this is my last possibility...

I've tried to send some e-mail to the address mister_x@cc.gatedi.edu.
This place is supposed to be College of Computing, Georgia Institute
of Technology in Atlanta, Georgia. No success. My mail keeps bouncing
back by saying: Unknown host. Anybody over there in the Atlanta area,
does this seem to be a correct address?

Thanks,
       Ossi
From: e-l@speed.harvard.edu (e-l account for Cheatham)
Newsgroups: comp.databases
Subject: Database-Tuning Tutorial Notes Available
Summary: notes for a tutorial on database tuning are available.
Keywords: database tuning, index selection, database design
Date: 4 Sep 92 16:00:52 GMT
Article-I.D.: das.1992Sep4.160052.26164
Reply-To: shasha@cs.nyu.edu
Followup-To: shasha@cs.nyu.edu
Organization: Courant Institute, New York University, New York NY



in case you didn't see this on dbworld....

dear colleagues,

at this year's sigmod and vldb, i presented tutorials on database tuning (t
vldb, steve rozen was co-presenter).

many people have asked me for electronic copies of the tutorial notes.  if you
would like a copy, please send me email and i'll send them to you.

the figures are missing, but you can find them (and much more stuff) in my book

  database tuning: a principled approach, 
  prentice-hall, 1992, isbn: 0-13-205246-6
  tel. (americas): (1-) 201-767-5937; (europe): (44-) 442-881-9000.

you may use the tutorial notes for non-commercial, university teaching purposes
provided you leave the copyright intact.

thanks,
dennis shasha
shasha@cs.nyu.edu
Newsgroups: comp.databases
From: law@eclipse.stanford.edu (Kincho Law)
Subject: ASME Engineering Database Symposium, 1993
Organization: Stanford University
Date: Wed, 2 Sep 1992 19:34:50 GMT


                        CALL FOR PAPERS

 American Society of Mechanical Engineers Engineering Database Program
              Seventh Annual Engineering Database Symposium on
      "Engineering Data Management: Key to Success in a Global Market"
                            August 9-11, 1993
                     to be held in conjuction with
    Thirteenth Annual ASME International Computers in Engineering Conference
        Loews Coronado Bay Resort, San Diego, California, U.S.A.

The  purpose  of  the  engineering  database symposium  is  twofold:  to
publicize recent industry and business successes in implementing 
engineering data management strategies for product conceptualization,
design, development and support, and to present advances in research
relevant to product engineering that are vital to survival in the 
competitive global market environment.

Papers are solicited in the general area  of engineering data management.
Topics of interest include (but are not limited to):

- Engineering database implementation experiences
- CALS initiative and industrial enterprise integration programs
- Implementation of STEP/PDES and other product data exchange standards
- Integration frameworks and application interfaces
- Evaluation of vendor database products
- Database support for concurrent engineering
- Engineering applications of object oriented database technologies
- Engineering product and data modeling
- Engineering database performance, integrity and security
- Engineering document storage systems
- Hypertext and hypermedia support for engineering information system
- Management of legacy data

All papers will be given a thorough peer review. Accepted papers will be
published in a separate bound symposium proceedings. Papers which
are deemed to have lasting or archival quality will be forwarded to 
Engineering with Computers, an International Journal for Computer Aided
Mechanical and Structural Engineering, for potential publication.

Deadlines for Technical Papers:

Submission  of  abstracts:  November  1, 1992
Submission  of  four  copies  of  paper: January  15,  1993
Notification  of  acceptance  to  authors:  March  1,  1993
Submission  of  final  paper  on  mats: April  1,  1993

Symposium Technical Program Organizer:

Kincho  H.  Law
Department  of  Civil  Engineering
Stanford University
Stanford,  California  94305-4020
Phone:  (415)  725-3154
Fax:    (415) 725-8662
E-mail: law@cive.stanford.edu
From: TONY@SLACVM.SLAC.STANFORD.EDU (Tony Roder)
Newsgroups: comp.databases
Subject: Re: Database library for
Date: 26 Aug 92 23:35:10 GMT
Organization: Stanford Linear Accelerator Center

In article <301.1359.uupcb@synapse.isis.org>, doug.hewko@synapse.isis.org (Doug
Hewko) says:
>
>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.

By coincidence, I was just about to post a message to ask exactly the same
question (perhaps not as well...).  I plan to use Alpha Four, but that should
not affect the technique.  Please respond to the net if possible, or e-mail
me as well as the initial poster.

Any assistance is doubly appreciated.  Thanks. Thanks.
>

-----------------------------------
Tony Roder, speaking his mind .....
Xref: sparky comp.databases:6501 bit.listserv.dbase-l:895
Organization: University of Illinois at Chicago
Date: Wednesday, 2 Sep 1992 11:33:17 CDT
From: Ron Vyhmeister <U53805@uicvm.uic.edu>
Newsgroups: comp.databases,bit.listserv.dbase-l
Subject: Re: Clipper: Backup/Restore routines for BIG files...

One methodology I have seen used is to do the following

1.  Find out how many free bytes there are on the floppy disk
2.  Using the HEADER() and RECLEN() functions, figure out how many records
    can be copied to that floppy disk.
3.  Create a .DBF with the first however many records you can fit.
4.  Repeat step 3 as many times as needed.

Hope this helps.