HDTenEightyP/NetNews huggingface dataset:
From: cae6824@ultb.isc.rit.edu (C.A. Egert)
Newsgroups: comp.databases,comp.unix.sysv386,misc.forsale.computers
Subject: FOR SALE : Unix stuff (database, OS, etc)
Date: 19 Aug 92 15:31:50 GMT
Article-I.D.: ultb.1992Aug19.153150.12086
Distribution: usa
Organization: Rochester Institute of Technology
Originator: cae6824@ultb

FOR SALE :

Recital 7.0 Database with 1 developer, 4 user license.  Runs under System
V R 3.2.  Purchased for $2100.  Asking $1000.

Esix System V R3.2D with Standand Manual Set, Extended Manual Set (all
man pages, programmers guide, users guide, streams/network guide), and
Motif/X pack X11R3 with docs.  Asking $800 or reasonable offer.

CMS Tape backup software for UNIX/XENIX - $70

Prices dot not include shipping charges (docs are REALLY heavy).  If 
interested, please send email at cae6824@ultb.isc.rit.edu.
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Newsgroups: comp.databases
Subject: Re: FoxPro 2.o and Win 3.1 ??
Date: 14 Aug 92 19:43:20 GMT
Organization: Colorado Software Solutions, Inc.


In article <1992Aug13.211229.1@acad3.alaska.edu>, fscll@acad3.alaska.edu (Christopher Lee Lott -- One foot in the grave and the other slipping) writes...
>I am sure this is probably an FAQ, but I am 
>trying to get FoxPro 2.0 to work with Windows 3.1
> 
>I used the install applications option in the setup and chose 
>the FoxPro Extended version, but when I try to run it the screen 
>goes black like it should right before it runs a dos app, but then it 
>bumps me back into windows.... 
> 
>does anyone know how I can get this working? I hate having to exit windows 
>all the time to get into My FoxPro database!
> 
>Thanks for your time and patience...
>chris
>poet and pauper

FoxPro Extended uses a DOS extender which is NOT compatible with Windows 3.1.
However, Fox, oops, I mean Microsoft, will soon have an update which is.
In the meantime, you have to run FoxPro standard under Windows.  All of this
refers to Windows in 386 mode, I believe.  In real or standard modes, I
don't think Windows has a conflict.

The problem is in management of extended memory.  The DOS extender used
by FoxPro doesn't support VCPI or one of those other standards which
Windows uses.

Randy
From: bob@bobsled.glv.com (Bob Lunney)
Newsgroups: comp.databases
Subject: Re: non-centralized concurrency control
Date: 19 Aug 92 17:28:33 GMT
Article-I.D.: glv.1992Aug19.172833.26455
Distribution: usa
Organization: Encompass

In article <1992Aug18.192031.18140@lmpsbbs.comm.mot.com>  
setzer@ssd.comm.mot.com (Thomas Setzer) writes:
> Does anyone know where I can get some info (textbook or paper or firsthand  
etc,
> etc) about non-centralized concurrency control mechinisms and  
implementations.
>  
> What I mean by this is that there are multiple users accessing a database
> but not having to go through a lock manager.  The locking is handled(I should
> say needs to be, as it is still being designed) by each individual task or
> process.  Any information on performance, contingency, implimentation or  
theory
> would be great.
>  
 [lots of stuff about tree based locking deleted...]

I attended a very interesting seminar at the University of North Carolina,  
Chapel Hill (UNC) on this subject.  The speaker was David B. Johnson of the  
Department of Computer Science at Rice University.  His methodology is  
basically a network model wherein a process requests state information from  
other processes that have a relationship with it.  The work was done on Sun  
3/60s running the V operating system (a research-oriented distributed OS).  The  
paradigm, however, appears portable to any reasonable (read preemptive  
multitasking) OS.
From: dannemil@sweetpea.jsc.nasa.gov (Denise Dannemiller 283-4364)
Newsgroups: comp.databases
Subject: OODBMSs at NASA
Date: 14 Aug 1992 15:31:27 GMT
Organization: McDonnell Douglas Space Systems Company

I am doing database research using an OODBMS.  I work at MDSSC in Houston,
supporting JSC.  I am just curious to know if there are any others in the NASA
and NASA contractor community doing any type of work with OODBMSs.

Please respond directly to me at  dannemil@sweetpea.jsc.nasa.gov

Thank you in advance,
Denise
Newsgroups: comp.databases,comp.databases.theory
From: edwards@world.std.com (Jonathan Edwards)
Subject: Re: Relational Queues
Organization: The World Public Access UNIX, Brookline, MA
Date: Tue, 18 Aug 1992 12:59:55 GMT

In article <1992Aug16.062239.24049@oracle.us.oracle.com> mfriedma@uucp (Michael Friedman) writes:
[proposal to handle FIFO queues, particularly the dequeue operation, by
putting various tag columns into a relation]

Let me complicate the problem, by requiring TRANSACTION CONTROL of all
queue operations. Pretend that these queue entries are your paycheck being
direct-deposited [thats actually what my systems are used for]. So you want
to be able to dequeue from one queue and process the entry all as part of a
standard database transaction. Transactions eliminate the ability to use tags
to declare that certain entries are 'pending dequeue' as you propose.
How do I do an efficient dequeue operation that is transaction protected
and scales up to dozens of pending dequeues?

As far as I can see, there is no PRACTICAL way to do this in straight SQL.
Someone mentioned that PROGRESS' language can search for unlocked records.
And no one yet has addressed the issue of how to WAIT on an empty queue,
other than periodically polling, which (technically speaking) sucks.

>
>Well, considering that SQL is pretty much standard between Oracle and
>all of our significant competitors I'm not going to run arround
>making a fuss about how SQL can do the job.  It's an industry
>standard and we don't need to defend it any more.

Weak, weak. "Industry Standard" translates to: "Gee, software is just too
complicated to sell, so lets all agree on some simplistic solution and
claim that doing things the right way is actually wrong, because its
non-standard. We can sell a lot more software that way."

>
>As for "comp sci questions" versus real word questions, I really do
>believe there is a difference.  I'll admit that you've given a pretty
>good example of a need for a FIFO queue, but in the vast majority of
>applications you really don't need one.  [...]

Speak for your own real world applications. The ones I have been building
for fifteen years REQUIRE queues. I suspect that if
relational databases supported queues, they would be found to be widely
useful. IMAO, relational databases will eventually be seen as a mass
delusion, since they are not anywhere close to being a useful data model
for the vast majority of applications. How many wordprocessors or spreadsheets
or compilers or file systems use the relational model for their data?

Jonathan Edwards
IntraNet, Inc.
I DO speak for my company!

Newsgroups: comp.databases
From: cy@genghis.borland.com (Cy Shuster)
Subject: Re: Object What is an OODBMS?
Originator: cy@genghis.borland.com
Keywords: OODBMS, C++, POET
Organization: Borland International
Date: Thu, 13 Aug 92 17:00:24 GMT

[discusses limits of the relational model to store real world
relationships, such as many-to-many]

Have we really come full circle, back to Codasyl networked structures?
What about the vaunted features of ad hoc queries and on-the-fly
joins, over casting relations into concrete at schema design time?

--Cy--
cy@borland.com

Xref: sparky comp.databases:6160 comp.databases.theory:364
From: cimo@cs.montana.edu (Bob Cimikowski)
Newsgroups: comp.databases,comp.databases.theory
Subject: Database Textbook
Date: 13 Aug 92 20:23:08 GMT
Organization: CS

I am looking for a good textbook to use for a graduate database course.
I would like to cover relational theory, normalization, and distributed
databases, at the very least, and perhaps object-oriented, logic-based,
and semantic models as well.  I would prefer to have all of this in a
single book and would like to avoid using papers or books that are
compilations of papers.

Can anyone recommend a good text?

Thanks,

Bob Cimikowski
CS Dept.
Montana St Univ
e-mail: cimo@cs.montana.edu
Newsgroups: comp.databases
From: edwards@world.std.com (Jonathan Edwards)
Subject: Re: Hot Standby DBMS's
Organization: The World Public Access UNIX, Brookline, MA
Date: Thu, 20 Aug 1992 12:15:11 GMT

In article <1992Aug19.052516.24063@anasaz> briand@anasaz (Brian Douglass) writes:
>Another approach to this through the use of Transaction Managers (Tuxedo,
>Encina, Top-End under Unix).  These products, and their grandpappy, CICS,
>have the ability to distribute transactions among processors or machines be
>they 10 feet apart or 100 miles.  
>
>The general approach to your problem would be to have machine 1 (M1) receiving 
>and processing transactions.  A 100 miles away, you put machine 2 (M2).  A 
>wire runs between them.  Whenever a transaction comes into M1 for processing, 
>the same transaction is forwarded on to M2 for identical processing.  If M1
>goes down for some reason (Hurricane), M2 takes over processing.  Whether
>transactions arrive at it from M1, or straight from the source units across
>the net, they all look the same to it.  

I infer that you are using 'transaction processing' in the older usage, of
a unit of work to be processed, canonically a 3270 screen. Nowadays a
'transaction manager' usually means a system to support logical database
transactions with journaling and recovery, and does not refer to application
data flow. The ENCINA product is only the former, as far as I know.

Given a CICS-like environment, you propose splitting all input transactions
(3270 screens) across two systems (i infer). 
One of these system is 'muted' so that its outputs are
supressed. This is not quite perfect, though, due to the possibility of
timing differences on the two systems. Any transaction mix that leads to
lock races could have different outcomes on the two systems due to random
timing differences.

It seems to me that you have to base hot standby either on a copy of the
disk-write stream, or a copy of the journal stream, which is more efficient
and can more easily support catchup. I am basically trying to
find out if any commercial databases do replication based on the journal
stream.




Newsgroups: comp.databases
From: wai@csuvax1.csu.murdoch.edu.au (Julian Wai)
Subject: Remote Database Access
Organization: Murdoch University
Date: Mon, 17 Aug 92 08:51:09 GMT

Hi,

Does anyone know the current status of RDA.  Are there any references out
there?

Please email responses to address below.

Thanks in advance.

Julian
wai@csuvax1.csu.murdoch.edu.au
Newsgroups: comp.databases
From: srb@barakam.b17d.ingr.com (Sreedhar Barakam)
Subject: Sybase 4.2 BUG.  Is there anybody else who thinks this is a bug!!!
Organization: Intergraph Corp.,
Date: Wed, 19 Aug 1992 23:13:24 GMT

I have a Sybase 4.2 server(on SunOS 4.1.2) which has two tables
t1,t2. They are populated like this:

  t1  t2
  c1  c1
  1   1
      2
      3
      4
      5
      6
      7
      8
      9
     10

For the following query:

select * from t1 where c1 <any (select c1 from t2)

The results are:
 c1
 -----------
           1
           1
           1
           1
           1
           1
           1
           1
           1
If you have two 1's in t1 the results would be 1 being returned 18 times.
You could come up similar examples for operator >.    Imagine getting 10000
duplicate rows from a table which has one row when selected comparing its value
with another table having 10000 values.  When I contacted Sybase support says
they have to contact their engineers to decide whether this is a bug!  It just
baffles me no end.

We do not get comp.databases.sybase(is it out there yet?), hence I am 
posting here.

Sreedhar Barakam.
srb@barakam.b30.ingr.com

Newsgroups: comp.databases
From: Bob Gajarsky <gajarsky@pilot.njin.net>
Subject: WANTED: Market research on databases
Organization: Indiana University
Date: Thu, 13 Aug 1992 16:24:36 GMT

hi - i'm looking for someone to point me in the right direction.
 i need some concrete information on where i can find (publications,
 ftp sites, etc.) studies, or research, on database market
 statistics?  this would encompass the uses for applications,
 market shares of the different vendors and products, price, etc.

thanks in advance for any help - best, bob gaj

Newsgroups: comp.databases.oracle
From: wjb@cscsun2.larc.nasa.gov (William J. Bene)
Subject: Nexpert and SQL*Net
Reply-To: wjb@cscsun2.larc.nasa.gov (William J. Bene)
Organization: NASA Langley Research Center, Hampton, VA USA
Date: Wed, 12 Aug 1992 17:04:16 GMT

Is anybody using Neuron Data's Nexpert Object V2.0b and SQL*Net V1.5?
After upgrading SQL*Net, I keep getting bus errors when Nexpert tries to 
retrieve data from a remote ORACLE database.  It looks like a version 
incompatability problem, but I'm not sure yet.  Any insight would be 
appreciated.

Thanks, 

Will

===================================
William J. Bene
Computer Sciences Corporation
wjb@cscsun2.larc.nasa.gov


Newsgroups: comp.databases.oracle
From: mcglough@glas.rtsg.mot.com (Mark McGloughlin)
Subject: Re: Are Oracle in England on email?
Organization: Motorola Ireland Ltd., Cork, Ireland.
Date: Fri, 14 Aug 1992 08:42:21 GMT

carol@ee.uts.edu.au (Carol Gibson) writes:

>I'm trying to track down someone in England. I know he works
>for Oracle. Does anyone know how I could go about finding out
>his email address?

I communicate with one or two Oracle employees in the UK and the
email address I use is user@uk.oracle.com. I also noticed that they
seem to use <firstInitial><familyName> as mail accounts. Thus, if I
worked for Oracle UK, my address would be mmcgloughlin@uk.oracle.com

Of course I am just speculating about the username - I have just seen
some addresses that look this way.

Mark...
-- 
   _   _     Mark McGloughlin            | Ph:   +353-21-357101
 _/ \_/ \_   Motorola Ireland Ltd.       | Fax:  +353-21-357635        
/ \_/ \_/ \  Cellular Infrastructure Div | UUCP: uunet!motcid!glas!mcglough 
\_/ \_/ \_/  Blackrock, Cork, Ireland.   | Inet: mcglough@glas.rtsg.mot.com
Newsgroups: comp.databases.oracle
From: frozzboz@zork.demon.co.uk (Keith Davidson)
Subject: Naming database files - are there rules? 
Distribution: world
Organization: zork
Date: Thu, 13 Aug 1992 21:01:48 +0000


In article <1992Aug13.114248.1@jaguar.uofs.edu> littlec1@jaguar.uofs.edu writes:

> 
> I am about to create a database instance on a VMS system and don't want to use
> the conventional filenames for files such as the system tablespace file
> (ORA_SYSTEM.DMS), or the redo log files.  This is because we have multiple
> database instances and want to precede the names of their files with unique
> identifiers so that they can ne recognised easily.  For example I'd like to

Why bother, they (instances) are created down directories specific to the
instance.

I run ten services on the same cluster this way, no problem identifying the
files, the associated files on other disks have service specific directory
names, which makes life easier to move the files.
My tip is don't over complicate the setup, its hard enough as it is!!

--
frozzboz@zork.demon.co.uk  (Keith Davidson)

Watch out The Borg are about
Newsgroups: comp.databases.oracle
From: p202@uni05.larc.nasa.gov (Bill Sneddon)
Subject: Oracle & Motif on RISC 5000(addendum)
Keywords: Oracle & Motif on RISC 5000 
Reply-To: p202@uni05.larc.nasa.gov (Bill Sneddon)
Organization: NASA Langley Research Center, Hampton, VA USA
Distribution: comp.databases.oracle 
Date: Tue, 18 Aug 1992 17:42:07 GMT

Correction to first message:  we ARE planning on using Mac-X and DEC's eXcursion........


Newsgroups: comp.databases.oracle
From: tssmith@netcom.com (Tim Smith)
Subject: Re: How many bytes are required for numeric data ?
Date: Thu, 20 Aug 92 01:44:47 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 

In article <Bt8v0D.uE@nntp-sc.Intel.COM> kortikar@mipos2.intel.com () writes:
>Oracle manual states following
>
>numeric data can use upto 21 bytes (22 bytes including length).
>
>all I could deduce was following
>in any numeric data 
>1  byte is required for exponent+sign (what if the format is "9999" ?)
>1  byte is required for length
>>1 byte(s) for actual data.
>in this case vsize(column) should return minimum of 3. it seems to return 2.
>secondly is there any simple way by which given a format I can found out
>bytes required for that column. i.e picture '9999.99' -> 4 bytes
>				          '999999.99' -> 5 bytes etc.
>
>thanks in advance.
>
>Aniruddha Kortikar (kortikar@mipos2.intel.com)

If you can get hold of a late V6 or any V7 OCI manual, look at the
description of the VARNUM external datatype (Chapter 3).

There are several examples there that show how many bytes are required
for various numbers, and an explanation of how NUMBERs are stored.

--Tim (tssmith@oracle.com)
From: ram%artecon@hp-sdd.sdd.hp.com
Newsgroups: comp.databases.oracle
Subject: *Time in SYSDATE: Mystery solved*
Date: 12 Aug 1992 19:04:22 -0500
Organization: UTexas Mail-to-News Gateway
NNTP-Posting-Host: cs.utexas.edu


Andy Finkenstadt,

	You are right! I felt soooooo stupid after I got the replies.
	I just figured that if HH stands for hours 
			and    SS stands for seconds
			then   MM should be months.

	AAaaaaaarrrrgggghhhh!

						*Stupid and sorry*

ps
	Thanks for all those who replied. 
-- 
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
      Dont trust the "From" address above. Use any of the following:
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
 Ramesh S Rao :::::           hp-sdd!artecon!ram                      :::::
 619/931-5500 :::::      ram%artecon@hp-sdd.sdd.hp.com                ::::: (T)
 619/931-5527 :::::         ram%artecon@sdd.hp.com                    ::::: (F) 
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*

Newsgroups: comp.databases.oracle
From: sjs@netcom.com (Stephen Schow)
Subject: READ ME---READ ME -- - READ ME -- READ ME
Date: Thu, 20 Aug 92 18:08:18 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 

I would like to suggest to everyone that is reading this group that they
try to forward their responses to questions back to the group instead of
just replying to the individual users.

Whenever I ask a specific question, I always get 4-5 responses, which are
very helpful to me, but not to anyone else who is reading the list and may
also have interest in the topic.

I know there are many times when I see someone ask a question and I wish
I could see the responses he got.

What do ya think?
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
               | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: gheeong@rhea.trl.OZ.AU (Ghee Ong)
Subject: upgrade to 6.0.34.2
Keywords: oracle,upgrade
Organization: Telecom Research Labs, Melbourne, Australia
Date: Mon, 17 Aug 1992 08:08:02 GMT

Hi there,

I am thinking of upgrading our system from 6.0.33.2 to 6.0.34.2.2.
My questions - Are you using (or had used) this release and do you encounter
any (serious) problems with it (and associated products, mainly forms,plus,
rpt,pro*c,sqlload,export/import) ?

We operate Oracle on Ultrix 4.2.

I am aware that 6.0.36 is available but requires Ultrix 4.3. Should I wait and
are there major differences between 6.0.34 and 6.0.36 ?

--
Ghee Ong
(g.ong@trl.oz.au)
Newsgroups: comp.databases.oracle
From: steve@sdz01.uu.ch ()
Subject: Control files on Ultrix
Date: Wed, 19 Aug 1992 07:39:36 GMT
Organization: Sandoz Technology Ltd.
Keywords: Oracle can't find 'em

I am having a small problem with control files.

I have sent a database (created with Oracle v. 6.0.27) to a customer
who has v. 6.0.34 (DEC Ultrix 4.2a). I sent what I believed were all the required 
files, that is, the contents of the database directory, and
instructions on how to get the db up and running. I had
previously done the same thing with the same customer
without any problem, so I wasn't expecting trouble. However,
when the customer tries to start the database, he gets an error
"ORA-00205: error in identifying control file". As far as I can
tell, ORACLE_HOME and ORACLE_SID are properly set, and everything
seems to be in order, except the database won't start. What am I missing?

Steven Husting
Pinck Softech AG
Reinach, Switzerland


Newsgroups: comp.databases.oracle
From: alfred@bambi.CS.MsState.Edu (Alfred Wu)
Subject: Execution file is too big for execution.
Organization: Mississippi State Univ.
Date: Mon, 17 Aug 1992 21:41:20 GMT


	I am currently modifying a natural language interface for Oracle RDBMS. 
The old version of the program was written with Microsoft C 5.1, Oracle Pro*C
with Oracle 5.1 and C-scape 2.2.  In order to meet the system requirements of
the client, we upgrade our software packages.  Currently, I am using Microsoft
C 6.0, Oracle 6.0 and C-scape 4.0.  Unfortunately, the execution file
becomes so big that it can not be executed during the integration.
The dynamic memory available on the my 386 is only 2KB immediately after the 
start of execution.  
These amount of memory is hardly enough for dynamic 
creation of an simple entity in C-scape.

Does any people has similar problems before or has some ideas about how to
solve the problem?  Please send me a e-mail.

My e-mail address: alfred@walt.cs.msstate.edu

Thanks in advance.

Alfred Wu
Mississippi State University

P.S. 1. In order to make my system work, I have to run the tcp/ip protocool for
        for SQL*Net.  
     2. I have QEMM installed in machine.
     3. I use large mode to compile my program.
     4. There are 580 KB real memory available after machine boot-up.
     5. There are 446 KB real memory available after running sqlpme and sqltcp.
     6. I have 1 MB extended memory on my machine.

I tried to load both sqlpme and sqltcp into high-memory by using QEMM, however,
there are no enough blacks in the high RAM for me to do it.
From: asymes@nl.oracle.com (Andy Symes)
Newsgroups: comp.databases.oracle
Subject: Please ignore, just a test
Keywords: test nosie junk garbage noise spelling
Date: 17 Aug 92 14:51:57 GMT
Organization: Oracle Europe

Just a test

Standard disclaimers, etc

Newsgroups: comp.databases.oracle
From: logier@cheops.qld.tne.oz.au (Rob Logie)
Subject: Renameing oracle users
Summary: How do you rename a Oracle user
Organization: Telecom Australia, TNE Computer Support Services
Date: Thu, 20 Aug 1992 21:31:53 GMT

Is there any easy way to rename a Oracle user account.  This should be able
to handle any grants that have been made to the User account etc.


Thanks in Advance



-- 
Rob Logie                         | The opions expressed are mine alone and in
AOTC  ( A.C.N. 051 775 556 )      | no-way reflect the views or policies of the
TNE Computer Support Services     | Australian and Overseas Telecommunications
EMAIL: logier@cheops.qld.tne.oz.au| Corporation. "These are my opinions alone"
Newsgroups: comp.databases.oracle
From: Hans Kristian Ruud <hkr@ifi.uio.no>
Subject: User exits
Organization: Dept. of Informatics, University of Oslo, Norway
Date: Wed, 12 Aug 1992 18:18:26 GMT
Originator: hkr@narve.ifi.uio.no

Hello.

I have an application that employs OCI C calls to perform certain
operations on an ORACLE database. I would like to call this
application from an ORACLE FORM; using the Query capabilities in FORMS
to find the objects (ie table entries) I would like to operate on, and
then transferring the appropriate parameters to this application.
According to the manual, parameters are transferred to OCI C programs
in the same manner as to Pro*C programs. However, the documentation of
how to combine FORMS and Pro*C (or OCI C) is not very clear (to me).
Could someone please enlighten me by posting a set of instructions?

Oh, yes, the instruction set might be included in the FAQ, when it
eventually makes its appearance.

Hans Kristian.