HDTenEightyP/NetNews huggingface dataset:
From: matt@bacchus.esa.OZ.AU (Matthew Atterbury)
Newsgroups: comp.databases,comp.databases.theory
Subject: Re: Hot Standby
Date: 23 Aug 92 22:36:54 GMT
Organization: Expert Solutions Australia.

In article <MATT.92Aug20090926@raven.bacchus.esa.OZ.AU> matt@bacchus.esa.OZ.AU (Matthew Atterbury) writes:
>     ... If anyone is interested, I have a
>     paper on it I can mail to you (nroff -mm or PS format). ...

    I have received 22 requests for this and have mailed it to these
    people. The following addresses do not work for my mailer. Please
    send me an alternative address that does not have '!'s in it:

        bosslog!tom@uunet.uu.net
        anasaz!qip.briand@enuucp.eas.asu.edu

    Alternatively, can mailers handle quoted parts (eg. would
    "bosslog!tom"@uunet.uu.net [literally] work?).

    I assume the next address is in the UK, but if so, it is not valid
    (.uk must be at the end). Please reword it and resubmit yr request.

        athula@uk.ac.kl.cs

    Thanks (especially for all the interest :-) ...
-- 
-------------------------------------------------------------------------------
Matt Atterbury [matt@bacchus.esa.oz.au]   Expert Solutions Australia, Melbourne
UUCP: ...!uunet!munnari!matt@bacchus.esa.oz.au            "klaatu barada nikto"
ARPA: ...!uunet!murtoa!bacchus.esa.oz.au!matt         "consider this a divorce"
Newsgroups: comp.databases
From: vhs@rhein-main.de (Volker Herminghaus-Shirai)
Subject: Re: Info on large, slow storage wanted (jukeboxes, etc.)
Reply-To: vhs@rhein-main.de
Date: Sat, 29 Aug 92 21:13:33 GMT

In article <1992Aug29.210553.8744@rhein-main.de> I wrote:

> 2) Use 1) for the less-often-retrieved data, and several 625MB-OD
>    jukeboxes with even more drives and a less intelligent scheduler.

The latter is used as a kind of cache for the most frequently retrieved
data.

Sorry to followup on my own post.

--
Volker Herminghaus-Shirai (vhs@rhein-main.de)
Newsgroups: comp.databases
Subject: Re: Ingres query optimisation timeout
From: brent@spss.com (Brent Lambert)
Date: Wed, 2 Sep 1992 15:45:46 GMT
Followup-To: comp.databases.ingres
Organization: SPSS, Inc. - portable code group

In article <1992Sep2.131607.2389@lsl.co.uk>, barron@lsl.co.uk writes:
> 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

I don't know the answer, but you might try re-posting this to
comp.databases.ingres, a newsgroup specifically for Ingres.  I'm not
saying that this is the wrong newsgroup for your question, just that a
lot of knowledgable people only read the newsgroups specific to their
own environment.  So you probably have a better chance of getting a
good answer from c.d.ingres.

Note: I redirected followups to c.d.ingres.


--
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.
Newsgroups: comp.databases
From: rmc@davidge.com (Robert Cianchette)
Subject: Re: free text indexing algorithm refs wanted...
Organization: Davidge Data Systems Corp., NYC, NY
Date: Fri, 28 Aug 92 13:38:25 GMT

In article <714787738snx@pizzabox.demon.co.uk> gtoal@pizzabox.demon.co.uk (Graham Toal) writes:
>Any pointers to papers or
>articles on different data structures for free text systems?
>
>Replies either here or by email gratefully received.

Would you please post a summary of responses? Much appreciated.

Thanks,

Robert

-- 
Robert Cianchette, Davidge Data Systems Corp., NYC | rmc@davidge.com
-------------------------------------------------------------------- 
 The information, questions, and opinions contained in this message 
  are mine and are not representative of Davidge Data Systems Corp.
Xref: sparky comp.databases:6349 comp.databases.theory:402 comp.databases.oracle:1388
From: hellers@wisc.edu (Joseph Hellerstein)
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
Subject: Re: Is this a bug or a limitation of the SQL language
Date: 26 Aug 92 21:27:13 GMT
	<JOEY.92Aug24091348@elysium.berkeley.edu>
	<BtJKIG.2K5@watdragon.uwaterloo.ca>
	<HELLERS.92Aug25181305@cleo.wisc.edu>
	<BtLuFp.Kp6@watdragon.uwaterloo.ca>
Organization: UW-Madison

In article <BtLuFp.Kp6@watdragon.uwaterloo.ca> gnpaulle@maytag.uwaterloo.ca (Glenn Paulley) writes:

>   > In article <BtJKIG.2K5@watdragon.uwaterloo.ca> gnpaulle@maytag.uwaterloo.ca (Glenn Paulley) writes:
>   >    > [I wrote:]
>   >    >   |select * from emp 
>   >    >   |where salary between
>   >    >   |(select salary from emp where ename = 'Larry')
>   >    >   |and
>   >    >   |(select salary from emp where ename = 'John')
>   > 
>   >    > You want to avoid subqueries whenever possible.  To get what you need,
>   >    > try the following:
>   > 
>   However, the scalar subqueries above are not correlated, so
>   I still fail to see how join processing could perform better than (basically)
>   a single scan- nested loops aren't required. Again, I'm assuming that 
>   ename is indexed, or in some way it's possible to determine Larry 
>   and John's salary quickly.

You're right -- in this example, since the subqueries are scalar and
not correlated, the expression above is as good as any other.  My
error.  It's still a healthy knee-jerk reaction to convert subqueries
to joins, but in this case it doesn't help.

Joe Hellerstein
Newsgroups: comp.databases
From: brendaa@MCES.MsState.Edu (Brenda Arnsdorff)
Subject: Foxpro 2.0 Question
Keywords: Foxpro Printer Driver
Organization: Mississippi Cooperative Extension Service
Date: Wed, 2 Sep 1992 16:56:05 GMT

When I run an EXE file created in Foxpro 2.0, I get an error "Unable to 
create printer Driver".  It doesn't happen when I run an APP, only an EXE.  
Anybody got any ideas?

Xref: sparky comp.databases:6343 comp.databases.theory:399 comp.databases.oracle:1382
From:  (Bill Winett)
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
Subject: Re: Is this a bug or a limitation of the SQL language
Date: 25 Aug 92 19:00:41 GMT
Organization: Apple

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
> 
Boy, my first response was really stupid.  Too bad I didn't realize it before
I sent it.  Let me try again:

select * from emp
where salary >= (select min(salary)
                 from emp
                 where ename in ('Larry','John')
and   salary <= (select max(salary)
                 from emp
                 where ename in ('Larry','John')

Now, does that do it?
From: hroth@ncratl.AtlantaGA.NCR.COM (Harris Roth)
Newsgroups: comp.databases
Subject: Re: Yet Another Simple (?) Question on Paradox
Keywords: Unique Record Field, Paradox
Date: 4 Sep 92 14:31:08 GMT
Distribution: na
Organization: NCR Engineering and Manufacturing Atlanta -- Atlanta, GA

In article <1992Aug31.195806.13243@murdoch.acc.Virginia.EDU> cyj9h@csissun12.ee.Virginia.EDU (Charles Y. Choi) writes:
>Here's a question that I've yet to figure out.  When creating a new record,
>how can you get a field in that record (say ID) to automatically be filled
>in with the record number?  For example
>
>So what do I want?  All I really want to do is have an automated
>way of generating a unique ID for each record period.
>
>Can anybody here help?
>
>-Charles Y. Choi

If Nrecords( "Table") = 0 Then    ; no records yet?
 id = 1                           ; first id
Else
 id = Cmax( "Table", "ID") + 1    ; largest id + 1
EndIf

This will guarantee a unique id for each record regardless of the number
of records added or deleted.  There will be not be a coordination between
the record number and the ID but, why do you need that anyway?



-- 
Harris J. Roth, Senior Programmer Analyst |
System Software                           |   hroth@ncratl.atlantaga.NCR.COM 
Transaction Terminal Systems Division     |
NCR E&M Atlanta                           |
Newsgroups: comp.databases
From: couch@unislc.uucp (Keith Couch)
Subject: DataBoss 3.5 - Any Knowledge or Comments?
X-Newsreader: Tin 1.1 PL5
Organization: Unisys Corporation SLC
Date: Wed, 26 Aug 1992 17:24:38 GMT


I recently received a mail solicitation to purchase a database package
called "DataBoss 3.5". It is a menu driven relational database package,
that uses pulldown menus to develop an application. Each application
is then transferred to a source code generator which either creates
C/C++ or Pascal source code.

The user must have a compiler to take advantage of the source code.

Do any of the readers of this group have any experience with DataBoss?
Please email any comments to me. I'll summerize and post your comments.


-----
Keith Couch					(801) 594-6088
Senior Software Engineer			(801) 594-4861 FAX
Unisys Corporation				couch@unislc.slc.unisys.com
322 North 2200 West
MS-D1V03
Salt Lake City, Ut 84116

Newsgroups: comp.databases
From: pss6@quads.uchicago.edu (philip s stylianos)
Subject: OODB Sales reps (O2, ObjectStore)
Reply-To: pss6@midway.uchicago.edu
Organization: University of Chicago Computing Organizations
Date: Wed, 2 Sep 1992 21:18:32 GMT

Will someone please post or reply to me where I can contact sales 
representatives for the aforementioned OODBs? 

Also, if you have experience with either of these, or other OODBMs,
why don't you drop me a line?

Thanks.

------
PS

Newsgroups: comp.databases,comp.databases.informix
From: dbc@cyclone.larc.nasa.gov (Dave Cavitt)
Subject: Re: Informix vs. Oracle 
Organization: NASA Langley Research Center, Hampton, VA  USA
Date: Fri, 28 Aug 1992 16:00:39 GMT


|> Of course, there are the problems such as
|> bugs and lack of some features that would come in handy.  But it is a
|> product that you can pick up and get started in very quickly.
|> 
Given the size and development cycles of these DBMSes, it would be
crazy to assume software errors would not exist and some features would
not be available. But I concur with you, Informix is a much easier
product to use, from the gitgo.

Informix is a UNIX DBMS as far as their main engine (translation: highest
performance) is concerned, however you can get the Informix line of products
for the DOS operating system with there low end engine (Informix SE).

Its been my experience (I've administered both Oracle and Informix) that
the Informix is easier to administrate than Oracle and there is very little to do to tune the Informix On-line engine to increase performance. Of course, if
you use the Informix SE (standard engine) there is virtually no administration
necessary. 

Informix spent alot of time up front optimizing their engine to run on
UNIX boxes, and is playing catch up ball with some of the end user products
that present X-based user interfaces, where Oracle and Ingres went to the
market with these products before Informix (although Informix just released
a preprocessor for their 4GL product that generates GUI code. I guess
it comes down to want kind of application and data environment your working
in. Most of my work has been in large scientific databases that are more
of a decision support environment, embedded SQL in 3GL languages, and
modestly complex data models. Informix's support of binary and text streams
(BLOBs) has proved to be solid in our development of large databases and
the explicit support (in 5.0) of the primary/foreign key relationships 
has allowed us to provide some very dynamic user interface environments
that shelter engineers from having to know about underlying data models
and/or data access (SQL).

Of course, all the hype about Informix goes out the tube if your not
on one their supported platforms. 

These are just a few, disjointed comments from an old, biased
Informix fan.

dbc@cyclone.larc.nasa.gov
From: ageorge@ra.nrl.navy.mil
Newsgroups: comp.databases
Subject: Re: ORACLE newsgroup?
Date: 1 Sep 92 00:37:37 GMT
Reply-To: ageorge
Organization: Naval Research Laboratory, Washington DC
News-Software: VAX/VMS VNEWS 1.3-4

In article <1992Aug20.042112.12662@morrow.stanford.edu>, XB.K14@forsythe.stanford.edu (Pechler) writes...
> 
>Could anyone tell me whether or where I can find a newsgroup or
>mailing list for ORACLE users specifically?
> 
>Thanks, -Henk.



Henk,
	Try comp.databases.oracle.

	Arthur
Newsgroups: comp.databases,comp.databases.theory
From: jtt@tct.com (John Tombs)
Subject: Re: Entity Relation Category Diagram Question
Date: Tue, 25 Aug 1992 16:28:18 GMT
Organization: TC Telemanagement, Clearwater, FL

>... I've heard of Entity Relation
>Diagrams but what is different between an ER Diagram and an Entity 
>Relation Category Diagram?

The first is three nouns in a row, the second is four. And your Subject
line is five :)

-- 
John Tombs at Teltronics/TCT        <jtt@tct.com>,     <uunet!myrddin!tct!jtt>
                     Real Modem Users Do It Internally.
Newsgroups: comp.databases
From: ytsai@cbnewsf.cb.att.com (charles.tsai)
Subject: Re: Inserting charcters in typeahead buffer, DBASEIV
Organization: AT&T
Date: Thu, 27 Aug 1992 18:27:21 GMT

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


-- charles  ytsai@usl.com

# speak for himself #
Newsgroups: comp.databases
From: ddunlavy@casbah.acns.nwu.edu (Daniel Dunlavy)
Subject: CSA SilverRUN 2.1 <-> Paradox 3.5 Conversion
Followup-To: gorkon@nwu.edu 
Organization: Northwestern University, Evanston Illinois.
Date: Tue, 1 Sep 1992 16:55:34 GMT


Is there a simple way (or utility) to convert projects from
CSA (Computer Systems Advisers) SilverRun 2.1 for WIN3.x format 
Xref: sparky comp.databases:6463 comp.databases.informix:1841
From: dharper@hounix.org (David Harper)
Subject: Need code from IR book
Organization: Houston UNIX Users Group (HOUNIX), Houston, TX
Date: Sun, 30 Aug 1992 20:11:42 GMT

Netfolk:

I just purchased "Information Retrieval: Data Structures and 
Algorithms" edited by William Frakes and Ricardo Baeza-Yates 
(Prentice Hall, 1992). The Preface alludes to an 
accompanying code disk. My copy of this book did not come 
with a disk.

This book contains a lot of neat-o C code for implementing 
the latest information retrieval algorithms for text or 
document databases. I am hoping someone on the net knows the 
author/editors and can give me their E-mail address, or 
point me to an FTP site where the example code from the book 
may be found.

Best guess for the author's whereabouts are:

William B. Frakes
Software Engineering Guild
Sterling, VA

Ricardo A. Baeza-Yates
Depto. de Ciencias de la Compuntacion
Universidad de Chile
Santiago, Chile

I'll write to the publisher if all else fails.

Thanks, David Harper  dharper@hounix.org
From: amigan@cup.portal.com (R Michael Medwid)
Newsgroups: comp.databases
Subject: pcExpress Programmer Near San Mateo?
Date: Sat, 29 Aug 92 11:13:32 PDT
Organization: The Portal System (TM)
Distribution: ba

I am looking for a local consultant/programmer who is fluent in the 
pcExpress database language.  My company is developing a number of
applications on this platform.  I like to be aware of local resources
although I don't currently have a specific project.  Please e-mail
me with your experiences w/ pcExpress and your rates if you would
like to be on my file.  amigan@cup.portal.com
Xref: sparky comp.databases:6441 comp.databases.theory:430 comp.databases.oracle:1431
From: davidm@consilium.com (David S. Masterson)
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
Subject: Re: Objects and Oracle?
Date: 30 Aug 92 07:21:17 GMT
Distribution: comp
Organization: Consilium Inc., Mountain View, California
In-reply-to: jalbert@IRO.UMontreal.CA's message of 28 Aug 92 21:44:43 GMT
X-Posting-Software: GNUS 3.13  [ NNTP-based News Reader for GNU Emacs ]

>>>>> On 28 Aug 92 21:44:43 GMT, jalbert@IRO.UMontreal.CA (Francois Jalbert)
>>>>> said:

> Our company develops software to run under Windows using the toolbook
> package in the early development phases. We do everything using objects and
> fairly complex inheritance schemes. Our current task is to develop some
> software to act as a front end to some relational database system. We are
> currently trying to figure out if Oracle might do the job for us. We phoned
> the local Oracle outfit but their answers were very vague, to say the least.
> I hope that by asking to net, somebody out there will know more than our
> local Oracle folks.

Well, so far this is a very vague definition of what it is that you want to do
with the relational database.  I can understand Oracle's response.

> I guess what we need is a way to access the power of SQL and RDBMS from
> within our own Windows applications. If anybody has played with those ideas
> and has something to report, please do so! We are also thinking about some
> small independent products that also boast of full SQL support, but Oracle
> is a big name and might look good on our company's record. We hope it won't
> prove too closed for our need. We are really new to DB stuff.

I think you need to be more specific (at least to yourself):

1. By accessing "the power of SQL and RDBMS from within our own Windows
applications", do you mean that the users of your applications should be given
full access to SQL or you, in writing your applications, need full access to
SQL?  The answer to this question sets the audience for who is dealing with
the database interface.

2. If the former, of what importance is the C++ objects that you mentioned?
Are you going to represent data in the database as objects or, maybe, are you
going to represent an RDBMS as an object?  The answer to this says something
of the complexity of the application.

3. Is your application relational or object-oriented in nature?  Which way
does your users perceive it?  Which way do your developers perceive it?  The
answer to this ensures that everyone is speaking the same language.

Basically, think about what it is you want to do with a database system.  Be
sure that you are not just seeking to use such a system because its the new
industry buzzword.
--
====================================================================
David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
davidm@consilium.com				Mtn. View, CA  94043
====================================================================
If you're not part of the solution,
you must be part of the precipitate.
From: edwards@world.std.com (Jonathan Edwards)
Subject: Re: Hot Standby DBMS's
Keywords: X/Open, heuristic decisions
Organization: IntraNet, Inc.
Date: Sat, 29 Aug 1992 00:21:53 GMT

In article <1992Aug28.170456.12162@donner.SanDiego.NCR.COM> don@robin.SanDiego.NCR.COM (Don.Russell) writes:
>X/Open allows for heuristic transaction completion.  This could be a manual
>"breaking of locks".  The resource manager (DBMS) is required to
>remember the heuristic decision.  If the transaction coordinator times
>out the commit phase of the 2-phase commit, it tells the application
>that there is a heuristic hazard (possibility of non-atomic results).
>If the subordinate (broderage) takew a heuristic decision, it must
>remember it until told to forget it by the traansaction manager.  When
>communications is restored between the two systems, recovery will
>cause the commit to finish properly (if the brokerage blocked or took
>a heuristic commit), or recovery will detect that the brokerage took
>the wrong decision -- in this case: heuristic rollback.  At this
>point, an admiistrator can "fix" the problem.

OH PLEASE. All this does is guarantee to tell you at some later time
that you got screwed.
In the meantime, you had invalid data sitting in the database cascading
through other transactions. Getting an 'administrator' to 'fix' the
problem completely begs the question. In any realistically complicated
system this would require a programmer with detailed knowledge of the
database and applications to make the fix.
Maybe this is an adequate solution for simplistic systems with non-critical
data, but please don't run around talking 'mission critical'.





-- 
Jonathan Edwards				edwards@intranet.com
IntraNet, Inc					617-527-7020
Newsgroups: comp.databases
From: kevin@iti.gov.sg (Kevin Patt (SE))
Subject: Request for Information
Organization: Information Technology Institute, National Computer Board, S'pore
Date: Tue, 1 Sep 1992 05:42:23 GMT

Hi,

   Hope some body can help me out.  I am looking for systems or softwares
that does the following:

   a.   Allow users to specify queries.
   b.   Monitors the queries against a database/real time datafeed.
   c.   If the query is satisfied, it should allow certain programmable
        actions to be taken.
   d.   The info base can be structured or unstructed.

   The above sounds a little bit like dyanbases or text retrieval systems
except that it must constantly monitor the databases.

   The system would preferably runs on unix, but even PC products are of
interest. I appreciate if anyone can provide any pointers. Thanks!

-- 
Kevin Patt                                     Information Technology Institute
Associate Member of Technical Staff            Singapore 
Email: (Internet) kevin@iti.gov.sg             Tel: (065) 772-0471 
       (BITNet)   kevinpatt@itivax.bitnet      Fax: (065) 779-5966
From: t9214309@phillip.edu.au
Newsgroups: comp.databases
Subject: Mailing lists in OODBMs or OOM ?
Date: 4 Sep 92 17:26:39 GMT
Organization: RMIT (Bundoora Campus)

Dear Netters:
Is there any mailing list for OODBMs or OOM?
If so, how does one enlist in the mailing list?
Thanx in advance
Nagesh
Email:    t9214309@phillip.edu.au
Newsgroups: comp.databases
From: dent@DIALix.oz.au (Andrew Dent)
Subject: Re: Is Foxpro available for unix?
Organization: DIALix Services, Perth, Western Australia
Date: Wed, 26 Aug 92 12:56:56 GMT
Keywords: Unix Fox FoxPro

2.5 provides a code base for WINDOWS, DOS, Mac & Unix and the WINDOWS
version will be out this year - order of Mac/Dos/Unix is anyone's guess!

Andy Dent (A.D. Software - Mac & VAX programming)
94 Bermuda Dve, BALLAJURA  Western Australia  6066
Phone/Fax: 09 249 2719 (local)  +619 249 2719 (International)
       Internet: dent@DIALix.oz.au    Compuserve: 100033,3241
From: mjducey@rodan.acs.syr.edu (Matthew "The Daddy" Ducey)
Newsgroups: comp.databases
Subject: Paradox Support/Developers Group
Date: 1 Sep 92 00:37:29 GMT
Organization: Syracuse University, Syracuse, NY

Is there such an animal?  Seems I'm becoming a developer in Paradox.  I'd 
like to find a place to get my questions answered, any ideas?

Matthew
--
 Syracuse University               mjducey@rodan.acs.syr.edu  CIS 70521,373
 Management Information Systems                                     HP 48SX
 Then I said,"But Sgt. Airborne, look how high we are!"    Gateway 2000 486