HDTenEightyP/NetNews huggingface dataset:
From: nh@cbnewsg.cb.att.com (nicholas.hounsome)
Subject: Re: Looking for literature on "moving from RDBMS to OODBMS"
Organization: AT&T
Distribution: comp
Date: Mon, 5 Oct 1992 07:45:28 GMT

From article <munish.718267593@eola.cs.ucf.edu>, by munish@cs.ucf.edu (Munish Jain):
> 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++".

I think that you are unlikely to come up with anything but 
I would be interested to here if you do. The reasons for
my pessimism are :

a) Everybody's OODB is different - not a bit different 
like different SQL based relational databases but very different.
I recently tried to evaluate a C++ based OODB by porting some
of an existing INFORMIX based product and found it impossible
to port more than a tiny part without a complete rewrite
of everything. When I then came to evaluate a second OODB, also
based on C++ I found that I had yet another huge chunk of work
to do to port the ported bit.

b) I am interested in OODBs more for their close integration
with C/C++ than for a lot of the advantages touted for them.
Many can be mapped almost seamlessly into C++ code (As part of
my evaluation I ported some existing C++ to ObjectStore and
although it would have needed more changes for performance
in a real system it worked and the port was simple and
mechanical). The down side of this is that you allow them to
permeate your code or lose this advantage (If you are going to
use accesss functions for everything you might as well use them
for a relational database instead.) This make writing the C++
code easy but porting to someone elses OODB will be that much harder.

c) The analogy with C to C++ is not a good one. Provided that you 
are using ANSI C with function prototypes specified then unless
you are unlucky enough to rely on one of the trivial differences
your C program can be compiled with a C++ compiler and run with no
change. This is firstly because C++ was designed to be compatible with
C and following form this they are both procedural languages. 
OOSQL is ,in every product I have seen, either nonexistent, unusable
or overly restrictive this means that you must adapt relational code
to procedural/navigational code - the two are very dissimilar . A tip -
do not try and implement a relational database in an OODB - OODBs allow
you both types of access but nobody seems to be able to optimize
for both and OODBs seem to be optimized for navigational access.

> 
> 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.
Xref: sparky comp.databases:7060 comp.databases.informix:2099
From: mendonza@apple.com (Jeff Mendonza)
Newsgroups: comp.databases,comp.databases.informix
Subject: Re: B+Tree/QuadTree
Date: 30 Sep 92 19:34:17 GMT
Distribution: na
Organization: ASS  Inc.

####

Can you send me a copy too?

Much obliged

Jeff M

email mendonza@apple.com

###
In article <1992Sep23.154346.14798@csx.cciw.ca>, u020@csx.cciw.ca (I. Wong) writes:
> 
> Does anybody know where I can get public domain of B+tree and QuadTree?
> I also need the source (preferably written in C or C++).
> I don't usually subscribe to this group. Pls send the information
> by e-mail to u020@csx.cciw.ca  
> Thank you.
Newsgroups: comp.databases
From: andrew@tagsys.com (Andrew Gideon)
Subject: Re: Sybase DB-library problems
Followup-To: comp.databases.sybase
Summary: a proposed solution to results pendinng
Keywords: dblib sybase results dbcancel dbresults
Organization: TAG Systems inc.
Date: Fri, 2 Oct 1992 20:44:49 GMT


In article <1992Oct1.163121.16881@sunova.ssc.gov> chow@slug.ssc.gov writes:
>   I am writing a program which works like isql* from Sybase
>(plus many other things not from Sybase).  My program works fine
>with all select/compute SQL statements.  However, when I send
>some non-select SQL statements, e.g. set showplan on, if...else...,
>etc.... It executes that and it "stops".  What I mean is I can't send
>any SQL after this kind of commands.
>The error I get is always:
>
>DB-Library error:
>        Attempt to initiate a new SQL Server operation with results pending.
>dbsqlsend failed  <-- my own debug statement.
>

It sounds like you've more than a single command in the buffer
being executed.  This results (pardon the pun) in having multiple 
results pending, waiting for a call to dbresults().  You should
have your program perform a while loop until the return from
dbresults() == NO_MORE_RESULTS.  Note that a return of FAIL does
not indicate that there are no more results; a single failed result
does not preclude later successful results.

If you do not wish to read all of the results, try the command
dbcancel().

Good luck.  I hope that this helps.

	- Andrew Gideon



=== 
 -----------------------------------------------------------
| Andrew Gideon              |                              |
| Consultant                 |                              |
|                            |   TAG Systems inc.           |
| Tel: (201) 890-7189        |   D2-181 Long Hill Road      |
| Fax: (201) 890-1581        |   Little Falls, N.J., 07424  |
| andrew@tagsys.com          |                              |
 -----------------------------------------------------------
From: 9531mide@ucsbuxa.ucsb.edu (Curt A. Mideiros)
Newsgroups: comp.databases
Subject: FoxPro
Date: 30 Sep 92 19:33:19 GMT
Distribution: comp

We have a number of users at our site who use foxpro, and would
be interested in any mailing lists, newsgroups, listservers, or
ftp sites.  Any info would be appreciated.
Newsgroups: comp.databases
Subject: Re: Clipper Run Time Error
From: i899435@redgum.bcae.oz.au (I COUROULIS)
Date: 27 Sep 92 21:03:19 +0900
Distribution: world
Organization: UCNV, Bendigo, Victoria, Australia
Originator: i899435@redgum.ucnv.edu.auLines: 71



mel0083@mcnews.mcdata.com (Michael Lausin) writes:

ML>I have a clipper 5.0 app that has started giving me a runtime error:
ML>                                   
ML>__run(0) unrecoverable error 5313
ML>out of space for vm swap file
ML>
ML>I have looked in the clipper manual, and in the microsoft c manual for this
ML>error to no avail. Any ideas?
ML>
ML>By the way, this error only shows up on an xt without any expanded memory. I
ML>haven't seen it on any of our at's or xt's that have expanded memory. 
ML>
ML>Has anyone seen any listings of the runtime errors that can come up? I've
ML>looked on nanforum on cserve, and there's nothing there.

This is a problem prevalent with large Clipper applications.

RTLink's overlay manager ensures that unused code remains on disk until
needed,but it does not handle the program's data. (Nantucket has
implemented a virtual memory system in 5.x that performs a similar
function for data.)

You tell Clipper the maximum size of the disk file it can create by
setting the SWAPK parameter in the Clipper environment variable.

(Look at the Environment Section under the Language Menu in Norton
 Guides whilst the database "The Guide to Clipper 5.x" is selected.
 The SET CLIPPER command is what you want) 
  

Values from 256K to 64Meg are valid (Clipper uses 16Mb by default)

Also, the swap file is created in the current directory unless you
change this by setting the SWAPPATH parameter in the Clipper environment
variable.

Virtual Memory Manager can use up to 8 Mb of *expanded* memory (EMM)

I presume you have enough files open in CONFIG.SYS)
(Each DBF is a file, Each NTX is a file, a report is a file and the
 screen is a file))

Also check out the Clipper Environment varible for opening files.

C:\>SET CLIPPER=Fnn
   (no spaces - nn is ideally odd and 5 less than
    specified with the FILES= in CONFIG.SYS)

*before* you run your application.


NB Begin by changing CONFIG.SYS and setting CLIPPER=Fnn
   to see if this solves your problem and then start
   modifying the swap file size. (As I had the same problem
   and this seemed to miraculously solve it ! )



======================================================================
 _--_|\      Ian C. 
/      \     ianc@ironbark.ucnv.edu.au 
\_.--.*/     i899435@redgum.ucnv.edu.au 
      v      Dept. of Computing & Info. Science
             La Trobe Uni. College of Northern Victoria.
             Victoria. AUSTRALIA.
=======================================================================
Newsgroups: comp.databases
Subject: a dbase question
From: tvanes@eagle.wesleyan.edu
Date: 27 Sep 92 16:41:55 EDT
Organization: Wesleyan University

I am trying to figure out a practical way I can put information that is stored
in ascii files onto dbase. The idea is this: I have a dbase file that I made
which I would like to append information to. This information is older than
what I have in the dbase file, and futhermore, is not in the exact same order
as the dbase file is set up, so reading it in directly would not work, I don't
think. If you can offer me any suggestions, I would greatly appreciate them.
If you think you could help, but need more info, then email me, too!
Thanks in advance, 
Tasha
tvanes@eagle.wesleyan.edu

Xref: sparky comp.databases:7086 comp.object:3867
From: gh@seti.UUCP (gh)
Newsgroups: comp.databases,comp.object
Subject: Re: WANTED: Fax number of O2 Technology
Date: 6 Oct 92 09:08:55 GMT
Followup-To: comp.databases
Organization: INRIA Rocquencourt,Le Chesnay, France.

In article <1992Oct1.144237@cs.utwente.nl> skow@cs.utwente.nl (Jacek Skowronek) writes:
>Does anybody know it? Can You send it to me?
>
>Jacek
>-- 

Here is more than you are asking.


O2 Technology,
7, rue du Parc de Clagny, 
78000 Versailles, France.

Phone: +33 (1) 30 84 77 77
Fax:   +33 (1) 30 84 77 90
email: o2@o2tech.fr


Gilbert Harrus					email:gh@o2tech.fr
Xref: sparky comp.databases:7022 comp.databases.oracle:1737 comp.databases.informix:2091
From: ccjg@kudu.ru.ac.za (John P. Goetsch)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.informix
Subject: ARCHIVE locations:-  oracle vs informix debate
Date: 1 Oct 92 13:06:01 GMT
Article-I.D.: kudu.ccjg.717944761
Organization: Rhodes University, Grahamstown, South Africa


Hi,

Can anyone tell me where the comp.databases*  groups are archived?


I am comparing oracle with informix, and I know it has all been through
the net so to avoid me asking for opinions, please point me in the right
direction.


Thanks in advance
John


--
John Goetsch                              Internet:  ccjg@kudu.ru.ac.za  
Computing Centre, Rhodes University       Fax:       (0461) 25049 
P.O. Box 94, Grahamstown, 6140, RSA       Telephone: (0461) 22023 ext 286
Newsgroups: comp.databases
From: srawson@quip.eecs.umich.edu (Stephen Rawson)
Subject: Re: Gupta Client Server
Organization: University of Texas Medical Branch, Galveston, TX
Date: Tue, 29 Sep 1992 22:01:38 GMT

In article <exuptr.732.717706386@exu.ericsson.se> exuptr@exu.ericsson.se (Patrick Taylor) writes:
>>There is a good review of C/S databases for novell in the 9/15/92
>>PC Magazine.  Gupta SQLBase gets high marks for technology and value.
>
>
>Yes, well let me tell you that you are in for a bit of a ride in the 
>technical support department.  They claim to be revamping the system, but 
>they have been no less than offensive and useless on many occasions.
>
>On the other hand, the SQL Windows 3.1.3 version works fairly well 
>considering the maturity of the "OS".  Have you heard if they are doing 
>anything for NT?
>
>    "This must be Thursday.  I never could get the hang of Thursdays"
>                                                       - Douglas Adams
>  - Patrick Taylor                                       (Arthur Dent)
>    Ericsson Network Systems
>    exuptr@exu.ericsson.se                       "Don't let the .se fool you"

Yes, I have heard some very negative reports about Gupta's tech support.
We'll see soon enough.  We bought the "Project Starter Kit" which includes
telephone hot line support.  My experiences with the sales staff and
others has been a bit disappointing.  There doesn't seem to be a lot
of communication among the various branches of Gupta.

I have not heard anything about a Windows NT versions yet.  We have joined
the beta test program, so I guess we'll hear about it if they beta test
something for NT.  We are also in the MS NT beta test program, though we
don't have the pre-release package yet. 

We have made contact with some very good consultants nearby who are
"Gupta Partners" and they should be able to help us out if things get
too impossible (for a price, of course).  Gupta is not very nice to
their Partners either.  They compete with them on software sales, play one off against the other, etc.

Gotta sign off.   Steve Rawson
From: debra@wsinis07.info.win.tue.nl (Paul De Bra)
Newsgroups: comp.databases
Subject: oracle 4 on 486
Summary: does not work
Date: 28 Sep 92 14:53:47 GMT
Reply-To: debra@info.win.tue.nl
Organization: Eindhoven University of Technology, the Netherlands

for historical (and educational) reasons we still have a (toy) database
in an ancient version of Oracle that runs on the IBM PC/XT (the one with
only 640K ram and a 8088 cpu)

This version works just fine on every PC i have tried so far which
has a 8088, 8086, 80286 or 80386.
On all (a few different) 80486 systems i have tried it hangs.
Does anyone have any idea why this might be the case? I have tried
both MD-DOS 3.3 and 5.0 with the same result.

This is what happens:
C: oracle
... some output, normal ...
C: ior w
... some output, normal again ...
C: ufi
system hangs here and does not respond to ctrl-alt-del, hard reset needed.

If i just try ufi without starting the database it does not hang (i.e.
it asks for username and password) but of course cannot connect to the server.

Any input is welcome. So far I thought the only important difference between
a 80[x<4]86 and the 486 would be speed. Now it seems there is a more
important one.

BTW, I tried disabling both internal and external cache and used low speed,
with no effect.

Paul.
From: davidm@consilium.com (David S. Masterson)
Newsgroups: comp.databases
Subject: Re: Flat file database for Unix?
Date: 30 Sep 92 16:59:06 GMT
Distribution: comp
Organization: Consilium Inc., Mountain View, California
In-reply-to: arzt@enexte.dccs.upenn.edu's message of 30 Sep 92 03:27:49 GMT
X-Posting-Software: GNUS 3.13  [ NNTP-based News Reader for GNU Emacs ]

>>>>> On 30 Sep 92 03:27:49 GMT, arzt@enexte.dccs.upenn.edu (Noam H. Arzt)
>>>>> said:

> Believe it or not, I am looking for a SIMPLE flat file database for Unix.
> By simple, I mean it does not need to be relational, nor GUI. I mean a
> product like Filemaker on the Mac or any number of products on PC's
> (everything from PFS: File to Alpha Four). It occurred to me that given all
> the solutions available for all kinds of things, I could not think of a good
> way to deliver database application to terminal-based Unix users.

I don't have it in front of me, so excuse me if I get the reference wrong.
There is a book out called (I believe):

	Relational Database Management for UNIX
		by Rod Manis, etc.

that should be available in any good computer bookstore.  It describes setting
up a relational database using standard UNIX text files and (mostly standard)
command shells.  There is enough in the book that you could probably duplicate
some of it without too much trouble.  If you want the complete system, its
called /rdb and (I think) there is a way to order in the back of the book
cheaply.

Someone that I heard of at one time that supports /rdb is:

	Frits Levenbach
	Intelequest
	Palo Alto, CA
	(415) 968-3443

You could also set something up with GNU Emacs, either as a front-end to the
system above (I believe there is a forms mode) or as something self contained
(I've been using BBDB as a rolodex in RMAIL/GNUS).

There is lots of possibilities for simple databases.  They're often so simple
that no company would support them, but put them together and they can be used
quite effectively.
--
====================================================================
David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
davidm@consilium.com				Mtn. View, CA  94043
====================================================================
I have a very strong record on the Environment in the United States
Senate.
       -- Vice President Dan Quayle
Newsgroups: comp.databases
From: gtoal@pizzabox.demon.co.uk (Graham Toal)
Subject: Flat file database for Unix? 
Distribution: world
Organization: Cuddlehogs Anonymous
Date: Fri, 2 Oct 1992 21:34:28 +0000


In article <90968@netnews.upenn.edu> arzt@enexte.dccs.upenn.edu writes:
>(everything from PFS: File to Alpha Four). It occurred to me that given  
>all the solutions available for all kinds of things, I could not think of  
>a good way to deliver database application to terminal-based Unix users.
>
>Am I missing something obvious?

Would WAIS & Gopher do for your application perhaps?

G
From: ch966@cleveland.Freenet.Edu (Jose M. Febus)
Newsgroups: comp.databases
Subject: Dbase & Informix
Date: 2 Oct 1992 12:41:58 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Hi all....
	I want to have an Informix Database converted to Dbase ( .DBF )
format. It"s a program that can do that???? 

	Any advice will be appreciated...

Jose Febus
-- 
	Jose Febus
	"Drinking at Yagrumo"
Newsgroups: comp.databases
Subject: UNIFY database problem
From: cjw@dme.nt.gov.au (Chris Wharton 95328)
Date: 29 Sep 92 17:40:30 +0900
Reply-To: cjw@dme.nt.gov.au
Distribution: world
Organization: Northern Territory Department of Mines & Energy

We are using the UNIFY database system, and are currently
having some problems. We are running some fairly complex
SQL stuff from within C programs, using ERIC routines,
and are occasionally getting the following error:

RPC error: timeout (prognum 1073742011, request sql_open())

The manual suggests this can be fixed by increasing the
value of the UNIFY_TIMEOUT environment variable, but
this does not seem to be working. The error only
occurs at certain times (ie. around 4:30 when people
are leaving).

Does anyone have any knowledge of this ? Is there some
sort of support available for UNIFY products ? Any help
or comments appreciated.


- Chris Wharton         email: cjw@celeste.dme.nt.gov.au
From: ch966@cleveland.Freenet.Edu (Jose M. Febus)
Newsgroups: comp.databases
Subject: Clipper 5.01 & Turbo C++
Date: 28 Sep 1992 14:32:26 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Hi...
	I want to know if i can use Turbo C, Turbo C++ or 
Borland C++ 3.1 . I don`t have Microsoft C and i don`t
want to buy it...
	any advice???
	thanks...

	Jose Febus
-- 
	Jose Febus
	"Drinking at Yagrumo"
From: gonzalod@amex-trs.com (Gonzalo Diethelm)
Newsgroups: comp.databases
Subject: RFI: BTree libraries
Date: 29 Sep 92 22:35:27 GMT



Distribution: world

Hello everyone,

I'm currently evaluating a set of libraries implementing B-Trees (B+)
on disk for DOS/Windows. I would like to hear opinions anybody
might have on some or all of them. The requirements include multiuser
support, so packages like the C Database Toolchest have been left out.

The libraries are:

Company         Product              Price w/src Remarks
--------------- ------------------- ------ ----- ----------------------------
RogueWave       Tools.h++              89    269 Support for multiusers?
Softfocus       ISAM/Btree           ~100      ? Ditto?
Trio Systems    CISAM/II+             600      ? Ditto?
?               DATAMAN                 ?      ?
South Mountain  Essential Btree 2.0   179      ?
Faircom         cTree Plus            476      ?


Please send responses through e-mail. This is the last stage on a long
research for the appropriate B-Tree library. Thanks in advance.

Oh, by the way, I'll summarize if I get good responses.


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: richieb@bony1.bony.com (Richard Bielak)
Newsgroups: comp.databases
Subject: Re: Object Oriented Databases
Date: 29 Sep 92 13:02:03 GMT
Organization: The Bank of New York

In article <1992Sep23.152738.21497@noose.ecn.purdue.edu> zentner@interval.ecn.purdue.edu (Mike Zentner) writes:
>I am seeking information on what kinds of object oriented
>databases are available which can interface readily with C++
>programs.  The desired platform is the Sun Sparc.  If anyone
>has any experience with specific commercial products, please
>email to me.  Thanks
>
>

Versant OODB runs on SUNs and supports C++, SmallTalk and C. I use
Versant with Eiffel. You can get in touch with Versant via e-mail.
They are osc.com.


...richie




-- 
* Richie Bielak   (212)-815-3072   |                                          *
* Internet:       richieb@bony.com | Rule #1: Don't sweat the small stuff.    *
* Bang {uupsi,uunet}!bony1!richieb | Rule #2: It's all small stuff.           *
*    - Strictly my opinions -      |                                          *
From: TONY@SLACVM.SLAC.STANFORD.EDU (Tony Roder)
Newsgroups: comp.databases
Subject: Re: Alpha Four V2 or Paradox 4.0
Date: 6 Oct 92 21:13:27 GMT
Article-I.D.: SLACVM.92280.131327TONY
Organization: Stanford Linear Accelerator Center

For a non-programmer, I recommend Alpha Four.  I am a non-programmer and
I ought to know....  I was able to work out a membership db with multiple
related files after a short learning period, and find that I can get
surprisingly sophisticated results as I continue.  A4 is all menu-driven,
and the manual is of textbook quality.

-----------------------------------
Tony Roder, speaking his mind .....
Newsgroups: comp.databases
Subject: Any good query tools out there?
From: benko_b@qis.dofasco.ca
Date: 6 Oct 92 07:37:05 GMT
Organization: Dofasco Inc, Hamilton, Ont. Can.
Nntp-Posting-User: benko_b

Has anybody evaluated any PC query tools or are currently using query tools 
to access SQL databases?

We are looking at end user query tools that run under DOS or WINDOWS. 
It would be nice if the user didn't have to know how to program in SQL but
could point-n-click or query by example. 

We would like to access SYBASE, INGRES and XBASE type databases.  It would be
an added bonus if the tools could access ADABAS, VSAM and CA-DATACOM/DB.   

If you can suggest any tools, it would be greatly appreciated. 

Thanks in advance. 


-- 
Brian Benko					DOFASCO INC. 
(benko_b@qis.dofasco.ca)			1330 Burlington Street East
(416) 544-3761 X6333				Hamilton, Ont. L8N 3J5 Canada
*****************************************************************************

The opinions expressed on USENET are mine, I do not speak for DOFASCO INC. 

*****************************************************************************
Newsgroups: comp.databases
From: fragante@unixg.ubc.ca (Gv Fragante)
Subject: Foxpro - help with radio button objects
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Mon, 5 Oct 1992 21:48:30 GMT

Does anyone have a method of deselecting a radio button ?

In my case, I have a set of radio buttons used for Yes/No questions. Sometimes
the user wants to unselect a Yes or No (i.e. - keep it blank or "unanswered").
Is there a built-in way to do this in FoxPro ? If not built-in, how can this
be achieved through programming ?

Also, is there a command/functions similar to OBJNUM() and _CUROBJ that can
tell me the type of control (i.e. - radio, push button, pop-up list) that
a field is using ?

Thanks in advance for any feedback.
Newsgroups: comp.databases