HDTenEightyP/NetNews huggingface dataset:
From: anand@gemed (Anand A. Deshpande 5-4246)
Newsgroups: comp.databases
Subject: ANSI, RDA
Date: 28 Sep 92 21:12:40 GMT
Reply-To: anand@gemed.ge.com (Anand A. Deshpande 5-4246)
Distribution: usa
Organization: GE Medical Systems, Milwaukee,  WI


	I am looking for ISO's RDA standards. Is there a
	document ? Does ANSI have a document addressing
	the same topic- Remote Data Access ?
	I have ANSI's  USMail address (1430 Broadway, NY, NY
	10018) Is this correct ?
	I would like the phone number of their publication's
	dept. and e-mail address if possible.

	I am posting this message to comp.databases since
	I am looking for RDA standards and I know that
	there is a sizable group of enlightened people who
	can show me the way.

    - anand

--
               |\/\/\/|      
               |Anand |     
               |      |    
               | (o)(o)   
               C      _) 
                | ,___| 
                |   / 
From: imn_ <Gv Fragante <fragante@unixg.ub>
Date: Thu, 17 Sep 1992 19:25:26 GMT
Subject: FoxPro newgroup/mailing list exist ?
Newsgroups: comp.databases
Organization:  University of British Columbia, Vancouver, B.C., Canada


Is there a newsgroup devoted to FoxPro ? How about a mailing list ?

I need some assistance with regards to building data entry screens. I am
experienced in xBASE, but currently on a learning curve as far as FoxPro's
new sophisticated READ command is concerned - still learning all the new
tricks it can do.

If anyone can help, please send me e-mail. Thanks.

fragante@unixg.ubc.ca
From: yoram@frcs.Alt.ZA (Yoram Tal)
Newsgroups: comp.databases
Subject: Sybase users group
Summary: sybase users
Keywords: SYBASE
Date: 29 Sep 92 09:19:03 GMT
Article-I.D.: frcs.1992Sep29.091903.28749
Organization: M*N*E*T Pay TV


Hi !!!!


Is there a sybase users group out there ??? If so, Can I be added to
the list ?  

Name: Yoram Tal
I-net address: yoram@frcs.alt.za

thanks in advance...


yoram 
 
yoram tal 
standard disclaimer applies            
yoram@frcs.alt.za   phone: (home) +27 11 783-2433  (Johannesburg,South Africa) 
-------------------------------------------------------------------------------
From: rfrx@vax5.cit.cornell.edu
Newsgroups: comp.databases
Subject: Reading/Writing Textfiles from Postgres
Date: 29 Sep 92 16:14:50 EDT
Distribution: comp
Organization: Cornell University

How does one use Postgres to read/write textfiles?
Our group has access to the university (public domain) version (4.0.1).
We haven't get got a copy of the reference manual.

Anthony K. Yan
RFRX@Vax5.cit.Cornell.edu
SIDEV group

Xref: sparky comp.databases:7089 comp.databases.theory:512
From: j.barbier@sprintintl.sprint.com
Newsgroups: comp.databases,comp.databases.theory
Subject: Locking systems
Date: 6 Oct 92 14:18:11 GMT
Followup-To: comp.databases
Organization: US Sprint Intern., Reston, VA


I'm looking for information about distributed locking systems., any reference
of books, articles, applications will be welcome. 
Please send your answer to j.barbier@sprintintl.sprint.com

Thank you
Jean-Yves
--
Florence Riviere-Barbier 		riviere@seismo.css.gov
Center for Seismic Studies		(703)276-7900
Xref: sparky comp.databases:7065 comp.databases.informix:2101 comp.databases.ingres:1521 comp.databases.oracle:1750 comp.databases.sybase:107
From: woan@exeter.austin.ibm.com (Ronald S. Woan)
Newsgroups: comp.databases,comp.databases.informix,comp.databases.ingres,comp.databases.oracle,comp.databases.sybase
Subject: Choosing a UNIX based database and development tools
Summary: Need help in a hurry
Date: 2 Oct 92 21:10:22 GMT
Reply-To: woan@fearless.austin.ibm.com
Organization: Austin School of Hardknocks


I belong to a group that is in the situation that we need to come to
some fast conclusion as to what database to choose for a variety of
applications.  I'd be interested in any comments on how to go about
this or sources of information (bibliographic references) from the
masses out there that have already undergone the selection process.
Also if any of you have any feedback in the quality of support from
the various database vendors, I'd be interested in hearing about it.

I am also looking at GUI application development tools (Uniface in
particular for the moment) and would be interested in any comments
from users of the various systems out there.

If I get sufficient response, I will summarize.

Thanks much,

-- 
+-----All Views Expressed Are My Own And Are Not Necessarily Shared By------+
+------------------------------My Employer----------------------------------+
+ Ronald S. Woan                       woan@cactus.org or woan@vnet.ibm.com +
+ other email addresses             Prodigy: XTCR74A Compuserve: 73530,2537 +
Newsgroups: comp.databases
From: Cy Shuster <cy@borland.com>
Subject: Re: Paradox 4.0 is SLOWER !! (Why)
X-Xxmessage-Id: <A6F72ACAD6010A2D@cy3.borland.com>
X-Xxdate: Tue, 6 Oct 92 19:36:42 GMT
Organization: Borland International
X-Useragent: Nuntius v1.1.1d10
Date: Tue, 6 Oct 1992 18:32:08 GMT

I work on dBASE, not Paradox, but my first guess on why your performance is
slower is because of the 3.5 compatibility you asked for. Any emulation or
non-native processing will be slower than the real thing, and the user
interface is central to Paradox, not just in appearance, but in the
functionality of the language engine.

Try recoding one small piece in 4.0, and test that. Also, Tech Support will
have tips on improving performance.

--Cy--
cy@borland.com                        DISCLAIMER: My opinions only.
Xref: sparky comp.databases:7047 comp.object:3821
From: mao@triplerock.CS.Berkeley.EDU (Mike Olson)
Newsgroups: comp.databases,comp.object
Subject: Re: RDB vs. OODB: Designing a queue
Followup-To: comp.databases
Date: 2 Oct 1992 17:00:20 GMT
Organization: University of California at Berkeley
Distribution: world
NNTP-Posting-Host: triplerock.cs.berkeley.edu

In <1992Sep30.202315.9819@bony1.bony.com>, richieb@bony1.bony.com (Richard
Bielak) describes a particular data modelling problem he wanted to solve.
he says:

> In a earlier positing I mentioned that we were unable to design a
> queue, using a relational database, and that this was the reason for
> moving to OODB.

and then follows it with a good description of the problem he wanted
to solve.

i've stated before, and want to reiterate, that this is NOT a problem
with the relational model.  if you have an extensible system, then you
can write code to manage a queue with high-concurrency locking.  bielat
succeeded in doing so in his oodb because he could write the queue data
type himself, *not* because he had inheritance, message-passing, and
polymorphic functions.

if your database system is extensible, you can write code that can be
linked into the dbms and executed there, and you can implement a queue.
whether the dbms is object-oriented or relational (or, for that matter,
network or flat-file) is irrelevant.

it's possible to build the queue datatype into postgres, because postgres
is extensible.  commercial ingres is also extensible, and should be able
to support queues, as well.

					mike olson
					project sequoia 2000
					uc berkeley
					mao@cs.berkeley.edu
Newsgroups: comp.databases
From: jfr@RedBrick.COM ()
Subject: Re: Simple? SQL query??
Organization: Red Brick Systems, Los Gatos, CA
Date: Sun, 27 Sep 1992 23:55:37 GMT

In article <1992Sep26.234548.731@panix.com> awerman@panix.com (Aaron Werman) writes:
>In <19t1sjINNdak@escargot.xx.rmit.OZ.AU> arthur@otto.bf.rmit.oz.au (Arthur Adamopoulos) writes:
>
>>...  I've got tables similar to the following:
>
>>  student(student_no,surname)
>>  stusub(student_no,subj_num)
>>  subject(subj_num,subj_name)
>
>>  What I want to get is a listing that looks something like this:
>
>>     Student Number  Surname  Subject  Subject Name
>>                              Subject  Subject Name
>>                              Subject  Subject Name
>
>	I've seen a few follow-ons to this question, and would like to add
>	my two-cents. Several people have pointed out that the formating issue
>	is a reporting front issue rather than a SQL query problem. SQL, though,
>	is capable of generating this report (don't try this at home, this
>	should be only attempted by theoreticians...).
 
  Good point and nice warning... :-)
>
>		SELECT 'Student Number', 'Surname', 'Subject', 'Subject Name'
>			FROM student  /* title line */
>			WHERE student_no = max(student_no) /* arbitrary */
>		UNION ALL
>		SELECT student_no, surname, sub_no, subj_name
>			FROM student...
>			WHERE subj_no = max(subj_no) 
>				/* I'm resorting to a trick: get only one
>				   row with full qualification */
>			  AND <join criteria>
>		UNION ALL
>		SELECT '       ', '        ', sub_no, subj_name
>			FROM student...
>			WHERE subj_no < max(subj_no) 
>				/* I'm resorting to a trick: replace the
>				   offending data with literals   */
>			  AND <join criteria>
 
  Excuse me while I blow chunks... :-)
>
>	With a little clean-up, (e.g. qualify the nonunique column names,
>	add an ORDER BY) and the job is done.
 
  Voila!  But I want it to page break every 40 lines and repeat the titles
  on each page and make sure no student's data gets spread across a page
  break and ... :-) :-) :-)

  For the humor-impaired, the above paragraph was intended as a joke.
  As was Aaron's entire post, right Aaron? Even though it DOES work.
  Ugggh...  This is what gives relational theorists their bad name. :-)

Jon Rosen
jfr@redbrick.com
-----------------------------------------------------------------
"Where is the wisdom? Lost in the knowledge.
  Where is the knowledge? Lost in the information." -- T.S. Eliot
"Where is the information? Lost in the data.
  Where is the data? Lost in the #@$%?!& database." -- Joe Celko
-----------------------------------------------------------------
Xref: sparky comp.databases:7075 alt.sources.d:1185 sci.materials:749
Newsgroups: comp.databases
Subject: Date's 12 Rules for DISTRIBUTED databases
Date: Mon, 05 Oct 1992 16:49:40 -0500

Disclaimer:  I work for Computer Associates (CA).

 TC> In article <a#4nvr=.tcox@netcom.com> tcox@netcom.com (Thomas Cox) writes:

>  The most functionally complete distributed RDBMS today (to the best of
>my knowledge) is INGRES.

 TC> I wanted to expand on this and wasn't able to immediately.  Since I've
 TC> gotten a flurry of confused e-mail on it, here is a fuller treatment of
 TC> the issue.

 TC> The topic had been commercial products, so I spoke only of commercial
 TC> products -- Ingres 6.4, Informix 5.0, Sybase 4.x, and the like,
 TC> including Oracle 6.0 and 6.2.  If one allows non-commercial software to
 TC> be considered, the unquestioned winner must be Oracle v7.  (Some of you
[A TC> wondered if I thought otherwise.  Hardly.)

 TC> The classic rule of thumb evaluation of a distributed relational
 TC> database was offered by C.J. Date in his "12 Rules for Distributed
 TC> Database", a follow-on to Codd's earlier 12 rules for relational.

 TC> Here is a re-posting of Date's 12 Rules, and my own evaluations as to
 TC> how Ingres and Oracle stack up.  

 TC> The quick score:   Oracle 6, 6.0 rules (8 if you're generous)
 TC>    Ingres,   6.5 rules (7 if you're generous)
 TC>    Oracle7, 10.0 rules (10.5 if you're generous)

By my reckoning, CA-Datacom/DB with CA-DB/STAR, which currently runs on IBM
mainframes and PCs (other platforms are under development) does at least as well
as these.

Rules Satisfied: 0, 1, 2, 3, 4, 5, 6, 8, 10: total 9.
Rules Partially Satisfied: 7, 9, 12*: total 1.0 or 1.5
Rules that I'm not qualified to judge: 11: we'll assume a total of 0.

Rule 12, Hardware Independence, is problematical because of the limited hardware
platforms that Datacom runs on.  The PC and mainframe versions of it can
function as equals in most or all respects, though (I believe).

Overall total: 10 or 10.5, equal to the best that you have listed above.  Not
bad. . .
From: vax_toledo@uoft02.utoledo.edu
Newsgroups: comp.databases
Subject: FOR SALE:  copy of Dbase IV
Date: 6 Oct 92 15:30:27 EST
Reply-To: pettrey@ohio.gov
Keywords: sale, sell, dbase
Distribution: world
Organization: University of Toledo, Computer Services

I have a copy of DBase IV, Version 1.0, still in the shrink wrap, that I'll
sell for $100.

Rob Pettrey
telephone       (419)244-3900 x 107
internet        pettrey@ohio.gov

-------------------------------------------------------------------------------
seen on the john wall           God is dead             Nietzsche is dead
at Oberlin College:                     - Nietzsche             - God
-------------------------------------------------------------------------------
Newsgroups: comp.databases,comp.object
From: geppert@ifi.unizh.ch (Andreas Geppert)
Subject: Re: Comparison of OODBMS
Reply-To: geppert@ifi.unizh.ch
Organization: University of Zurich, Department of Computer Science
Date: Mon, 28 Sep 1992 17:29:50 GMT

Many postings in comp.object and comp.databases ask for references on ooDBMS
or information on public domain or product ooDBMS, and many replies are something
like "I would be interested, too". Hence, why not make a FAQ out of it?
I cannot remember regular postings with FAQs in these groups, but I guess
it would be worth the effort, and answers would be more comprehensive
(guess most of us  do not have the time to answer the same question over and 
over again).

------------------------------------------------------------
Andreas Geppert
Institut fuer Informatik
Universitaet Zuerich             Phone         +41-1-257 4576
Winterthurerstr. 190             Telefax       +41-1-363 0035
CH-8057 Zuerich                 Telex             817 251 unii ch
Switzerland                          E-mail    geppert@ifi.unizh.ch
------------------------------------------------------------

Newsgroups: comp.databases
From: rols@tk1003.noname (Roland King)
Subject: Re "Bits per Second"
Organization: /home/rols/.organization
Distribution: comp.databases
Date: Fri, 2 Oct 1992 13:44:46 GMT

In article <1992Sep30.203709.5419@TorreyPinesCA.ncr.com> ray@TorreyPinesCA.ncr.com (Ray Shapouri 3547) writes:


   I am trying to locate a British company:
	   Bits Per Second 

   They have a product which is called "DGE" that provides
   a graphic mode for DBs on IBM based machines.

   Any help is greatly appreciated.


Hi, yes I used their product called dGE back in 1988 when it was at version 3. I remember
it as pretty good, but it was a long time ago and I assume that the product has changed
beyond recognition now. In 1988, the address was :-

	Bits Per Second Ltd.
	P.O. Box 180
	Brighton
	BN1 3NB
	England

If this address is still correct, I'll be most surprised as most companies in Britain
seem to have gone to the wall since 1988, but if that address doesn't cut it, and they're
still around, you could try directory enquiries for Brighton.

Happy hunting ... Rols
From: ivang@cup.portal.com (Ivan - Godard)
Newsgroups: comp.databases
Subject: Re: RDB vs. OODB: Designing a queue
Date: Sat,  3 Oct 92 09:04:24 PDT
Organization: The Portal System (TM)
  <1ahv74INNjfr@agate.berkeley.edu> <1992Oct2.194614.18863@panix.com>

>>In article <1ahv74INNjfr@agate.berkeley.edu> mao@triplerock.CS.Berkeley.EDU (
Mi
>>ke Olson) writes:
    >>i've stated before, and want to reiterate, that this is NOT a problem
    >>with the relational model.  if you have an extensible system, then you
    >>can write code to manage a queue with high-concurrency locking.  bielat
    >>succeeded in doing so in his oodb because he could write the queue data
    >>type himself, *not* because he had inheritance, message-passing, and
    >>polymorphic functions.
>>    
        	        	>>mike olson
	                        >>project sequoia 2000
				>>uc berkeley
				>>mao@cs.berkeley.edu
>>
>>In fact, not only aren't OO features required, but extensible database
>>features are not required either. I know, because we implemented just
>>such a queueing system on top of Sybase using nothing more than C. The
>>key is to provide a central lock manager process, which grants clients
>>locks on fields, records, and/or tables, as well as assigns uniqiue
>>ID's for records. This strategy can be made sufficiently robust to
>>support any degree of concurrency...our system supports over 150 users
>>in three countries (using three databases, slaved together[NOT
>>multi-phase commit], but that's another story) for a real-time trading
>>system.
>>
>>Stored proceedues and the like are not required, but they may make
>>life easier...
>>

>>-- 
>>-frank
>>(fhd@panix.com)


if you have hand written in C a unique id generator and central lock
manager (presumably with a transaction interface), then what is Sybase
giving you other than raw storage? Why not put the messages on raw
files and say that you have implemented your own OO database? There
may be more to your system, but as briefly described it has nothing
to do with relational models any more except as a lookup and storage
mehansim which couls be ISAM as well. Seems the original posting 
asserted that queue management is a good example of what can't be done
with out-of-the-bos relational, and you have confirmed this assertion.
Newsgroups: comp.databases
From: siva@a.cs.okstate.edu (KAVUTURU SIVA RAMA)
Subject: search for literature on OODBMS package development
Followup-To: sivaram@a.cs.okstate.edu  siva@a.cs.okstate.edu
Organization: Oklahoma State University, Computer Science, Stillwater
Date: Thu, 1 Oct 92 20:04:20 GMT

    Hai,
         I am trying to develop an OODBMS package. I am searching for
         some literature on this topic. I am starting from basics.
         Please help me in finding some practical material which helps
         me in understanding the concepts easily.

         I am interested to develop this through C++.

         Thank you.

-- 
Siva Rama Krishna Kavuturu       308, N.Husband, Apt# S-3, Stillwater, OK-74075.
E-mail: siva@a.cs.okstate.edu
Home:(405)-624-3330                                       Office:(405)-744-6010
Keep on Exploring new things. Otherwise there won't be any thrill in the life.
From: b_lmcgilve@cpvax.cpses.tu.com
Newsgroups: comp.databases
Subject: Re: Data Base design pet peeve
Date: 29 Sep 92 10:12:52 CDT
Organization: Texas Utilities, Glen Rose TX 

In article <66577@cup.portal.com>, DonD@cup.portal.com (Don Robert DeCosta) writes:
> This is one of my Data Base design pet peeves and it just came up again
> during an "Introduction to SQL" seminar, I wanted to bounce it off you
> folks to see if I'm wrong (NEVER!).
--Stuff deleted--
> decides the item is a 2 character string limited to numerals, he says
> you make this decision because this data item will never be manipulated
> as numeric, you don't SUM customer_id, you don't AVG customer_id, etc.
> 
Well,  I may want to do something like show me the first 25 customers or
something like that... much easier to compute with a number field.  He's right
as far as I don't see me summing or averaging it, but I'm with you on 
storage.  We use numeric keys, and our tables have 300-500K rows.  The
storage savings made a big difference in real-life tables.

If it looks like, smells like, etc it is a number not a character.  Besides,
let's remember who's going to input this data.  To a data-entry clerk,
1 is a number not a character. 

Laurel McGilvery			Not only do I not speak for the
CPSES (temporarily)			company, the company does not
Bechtel Corporation			speak for me. 

		"We only glow in the light of the moon"

All opinions expressed are obviously mine.  Who else would own up to them?
Newsgroups: comp.databases
From: map@sequent.com (Michael Perry)
Subject: Re: Flat vs Relational ??
Organization: Sequent Computer Systems Inc.
Date: Thu, 1 Oct 92 13:38:20 GMT

In article <90777@netnews.upenn.edu> rpatel@eniac.seas.upenn.edu (Rachana D Patel) writes:
>
>This is a simple question but could someone tell me the advantages
>of having a relational database versus a flat database.

It sells more hardware  :)

Mike
Newsgroups: comp.databases
From: munish@cs.ucf.edu (Munish Jain)
Subject: Looking for literature on "moving from RDBMS to OODBMS"
Summary: literature on "moving from RDBMS to OODBMS"
Keywords: RDBMS, OODBMS
Organization: University of Central Florida
Distribution: comp
Date: Mon, 5 Oct 1992 06:46:33 GMT

hi

I have seen a couple of articles on RDBMS and OODBMS but
haven't seen ones on "Migrating from Relational to
Object model". As most sites have relational databases
installed and what are the problems that they are facing
to move to OODB. An analogy is "moving from C to C++".

If somebody can give me pointers to literature that is
available on this topic, I'd appreciate it.

I will post a summary of replies.

munish
--
Every program has (at least) two purposes: the one for which it was
written and another for which it wasn't.
Newsgroups: comp.databases
From: stevedav@netcom.com (Steve Davidson)
Subject: Public domain DATABASE SYSTEM.
Keywords: database public domain copyleft
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 1 Oct 1992 23:52:08 GMT

Can anyone suggest a free, public domain, or copylefted
database system that meets the following requirements:

It is multi-user with record locking.
It must have fast indexing including a B-tree and a hash.
It needs to maintain a large and growing collection of data.
It should interface well with Unix utilities.

Any suggestions are appreciated.

I will re-post results if anyone shows interest.

Steve Davidson
steved@cfcl.com
From: snowden@cray.com (Jim Snowden)
Newsgroups: comp.databases
Subject: Alpha Four V2 or Paradox 4.0
Date: 6 Oct 92 16:18:15 GMT
Organization: Cray Research, Inc.

Hi

I am looking to get a database system that makes it easy to write
my own applications (like a library cataloguing system, membership
database).  I'm not a programmer, but I can write some programs
in BASIC.

Now, I have two special offers for databases.  One for Alpha Four V2
and one for Paradox 4.0.  I am fairly familiar with Paradox, but does
anyone have any opinions on Alpha Four V2?

Thanks

Jim Snowden
snowden@hemlock.cray.com
Newsgroups: comp.databases