HDTenEightyP/NetNews huggingface dataset:
From: doug.hewko@synapse.isis.org (Doug Hewko) 
Newsgroups: comp.databases
Subject: DAL server for Sybase on
Date: 15 Aug 92 11:41:00 GMT
Distribution: world
Organization: SYNAPSE BBS - GATINEAU, QUEBEC - 819-561-4321
Reply-To: doug.hewko@synapse.isis.org (Doug Hewko) 

RM>Newsgroups: comp.sys.mac.databases,comp.databases
RM>From: robmacf@dep (Robert Macfarlane)
RM>Subject: DAL server for Sybase on Netware?
RM>Message-ID: <1992Aug11.193557.1943@sifon.cc.mcgill.ca>
RM>Followup-To: poster
RM>Keywords: DAL Sybase Netware
RM>Reply-To: robmacf@philo.mcgill.ca
RM>Date: Tue, 11 Aug 1992 19:35:57 GMT

What does all that eight lines mean?  I have sent a few messages on
this conference before and I have not received any replies.  Do I need
to send those lines to send a message??  Those lines are not 
included with any messages in any of the other conferences that I am
on.

..Doug Hewko
---
 . DeLuxe. 1.25 #483sa . I'm definitely positively maybe decisive.
From: joey@berkeley.edu (Joe Hellerstein)
Newsgroups: comp.databases
Subject: Re: nested SQL select
Date: 14 Aug 92 09:01:17
Organization: Postgres Research Group
	<1992Aug14.071343.1758@neptune.inf.ethz.ch>
NNTP-Posting-Host: elysium.cs.berkeley.edu
In-reply-to: marti@nugget.inf.ethz.ch's message of 14 Aug 92 07:13:43 GMT

In article <1992Aug14.071343.1758@neptune.inf.ethz.ch> marti@nugget.inf.ethz.ch (Robert Marti) writes:

>   Even Mike Stonebraker, whose QUEL
>   language design is regarded by most academics to be superior to
>   SQL, has termed SQL "intergalactic data speak".  (Sorry, I don't
>   remember where.)

Note that Stonebraker intends no praise of SQL as a language here.  He
is merely admitting its undeniable dominance of the market.  The
"intergalactic data speak" quip is from the Third Generation DBMS
manifesto, cited below.

I'm not aware that "most academics" feel that QUEL is superior to SQL.
It's simpler and hence closer to the relational algebra, but it's also
not as powerful as SQL (no subqueries, no duplicate semantics, etc.)

Joe Hellerstein

---------
@techreport{paper:3rd-gen-DB-Manifesto,
author  = "{Committee for Advanced DBMS Function}",
title = "{Third-Generation Data Base System Manifesto}",
type = "Memorandum No. UCB/ERL",
number =  "M90/28",
institution = "University of California, Berkeley",
year = 1990,
month = apr
}
From: doug.hewko@synapse.isis.org (Doug Hewko) 
Newsgroups: comp.databases
Subject: searching routines
Date: 15 Aug 92 11:41:00 GMT
Distribution: world
Organization: SYNAPSE BBS - GATINEAU, QUEBEC - 819-561-4321
Reply-To: doug.hewko@synapse.isis.org (Doug Hewko) 

Is there a techniques that is used by Systems Analysts that could help
me decided on the best searching procedure for a personal database
system that I am developing?  I am cr eating a database system to
reference varous newspaper, magazine, and trade journal articles, and
I am undecided between two methods.  BTW, I am using DataEase 4.2 for
this project.
 
The first method is to use Keywords to reference the articles.  My 
definition of a keyword is a very short (one or two word description)
of something, or the name of the item (ie. company name, product name,
etc).

The otehr method is more complicated but would require abstracts
(ranging from one or two lines for newspapers and magazines to 500
words for trade journals) that would be searched.  The mechanics of
the searching procedure has not yet been decided upon.

Any assistance would be appreciated.

..Doug Hewko
---
 . DeLuxe. 1.25 #483sa . Genius is often mistaken for insanity.
                                                                         
Newsgroups: comp.database,comp.databases,comp.robotics,wa.seminar
From: blackman@MATH.TAU.AC.IL (Blackman Uri)
Newsgroups: comp.databases
Subject: Re: Canned PARADOX scripts?
Date: 20 Aug 92 20:43:19 GMT
Organization: School of Math & CS - Tel Aviv University , Tel Aviv , ISRAEL.

Joe F. Junker (junkerj@ccmail.orst.edu) wrote:
: Does anybody know a source for canned PARADOX scripts or insightful
: techniques? 
: I would love to find a source for scripts or advise to:
... 
: In general I would be very greatful for any information on ftp sites, BBS,
: or discussion groups that are specific to PARADOX or might contain
: canned scripts.
: 
: Thanks for whatever help you can provide.
: 
: 
:  Joseph F. Junker

The PARADOX INFORMANT is a monthly guide to paradox:
10519 E. Stockton Blvd, Suite 142
Elk Grove, CA 95624-9743
Voice: 916-686-6610 FAX: 916-668-8497
BBS: 916-686-4740 (N81)

--
Uri Blackman                      
blackman@Math.Tau.Ac.IL          
blackman@Taurus.BITNET
From: edwards@world.std.com (Jonathan Edwards)
Newsgroups: comp.databases
Subject: Re: Hot Standby DBMS's
Date: 21 Aug 92 00:40:03 GMT
Article-I.D.: world.BtB5us.MsD
Organization: The World Public Access UNIX, Brookline, MA

In article <BtAMG4.3rF@cup.hp.com> dhepner@cup.hp.com (Dan Hepner) writes:
>From: edwards@world.std.com (Jonathan Edwards)
>
>>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.
>
>Since all locks need to be obtained on both systems before the 
>transaction is eventually committed, lock race conditions (defective
>design) result in deadlocks.  The system as a whole remains perfectly 
>serialized.
>
>Dan Hepner

Lock races are inherent functionally: what happens when two operators want
to update the same record. My point is that the winner will not necessarily be
the same on a system recieving a copy of the input stream.
From: TONY@SLACVM.SLAC.STANFORD.EDU (Tony Roder)
Newsgroups: comp.databases
Subject: Re: Alpha4
Date: 18 Aug 92 19:33:34 GMT
 <dwormuth-170892095758@134.174.81.96> <17AUG199212045286@amarna.gsfc.nasa.gov>
Organization: Stanford Linear Accelerator Center

In article <17AUG199212045286@amarna.gsfc.nasa.gov>,
dweissman@amarna.gsfc.nasa.gov (WiseGuy) says:
>
>Thanks for the info.  Is there a good source of info regarding ALPHA4
>(either book, magazine, or ftp site) for help in using the package?
>===============================================================================

Alpha Four is a commercial product, i.e. not available by ftp.  It is
available from Egghead [1-800-EGGHEAD] for less than $100 if you send in
the title page from any other database program... they'll explain the
details.  To the earlier recommendation, I might add that the manual is
excellent:  clear, good examples, to the point.  Their support is equally
good, especially if you contact them by fax with details of the problem.

-----------------------------------
Tony Roder, speaking his mind .....
Newsgroups: comp.databases
From: mrichter@oracle.uucp (Mark Richter)
Subject: Re: databases for visual basic
Organization: Oracle Corporation, Redwood Shores CA
Distribution: usa
Date: Tue, 18 Aug 1992 20:07:36 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

I recommend a Agility/VB. Great DBF support as well as others. A grid control
for VB that knocks your socks off. Contact Apex Software Corp, Pittsburgh, PA.
+1.412.681.4343.


Mark D. Richter                                             1.415.506.4852
Oracle Corporation, Desktop Products Division       mrichter@us.oracle.com
500 Oracle Parkway, Box 659409, Redwood Shores, CA 94065
------------ "Unlike leadership, golf builds character."------------------
Newsgroups: comp.databases
From: news@cam.compserv.utas.edu.au
Subject: Re: How to trim down dBASE IV database file ?
Keywords: dbase IV file
Organization: University of Tasmania at Launceston
Date: Thu, 20 Aug 92 03:41:59 GMT

This article was probably generated by a buggy news reader.
From: drake@Autodesk.COM (Dan Drake)
Newsgroups: comp.databases
Subject: Re: Foxpro2 Book
Date: 12 Aug 92 20:01:59 GMT
Organization: Autodesk Inc., Sausalito CA, USA

lindsey@tincup.enet.dec.com (Randy Lindsey) writes:
+ 
+ In article <BsMu6K.2xJ@acsu.buffalo.edu>, v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes...
+ > 
+ >     Hi All!
+ >             I've been working hard these last few weeks to learn
+ >     the new way of developing apps under Foxpro 2.0.  (It seems
+ >     wierd to me).  Im having some difficulty catching on, can some-one
+ >     recommend a book that could provide me with a more thorough tutorial
+ >     than the one provided in the system docs.  (Its too lacking for 
+ >     thick-heads like me :) )
+ > 
+ >     Thanks A Bunch!
+ > 
+ >      Ami
+ 
+ I don't have a good book either, although hopefully they exist.  But I found
+ that the example applications were quite helpful.  But I still don't get it
+ all yet either...
+ 
+ Randy

I don't have the reference handy, but --

The best book on the old Foxpro was by Olympia and Cey, published by
Addison Wesley and with some obviously recognizable title.  The contrast
with most other Fox books was the contrast you'd expect between, say,
Addison Wesley (sp?) and Sybex: the authors clearly know what they're
talking about.

But don't buy it; they've got a Foxpro 2 version out now, and presumably
it's as good as the old one but more relevant.  It ought to be easy
enough to find where good computer books are sold.  (Or mail order from
Computer Literacy?)

--
Dan Drake
drake@Autodesk.com
Newsgroups: comp.databases
From: tedboone@freezer.cns.udel.edu (Edward F. Boone)
Subject: Re: Foxpro 2.0 ??
Reply-To: tedboone@freezer.cns.udel.edu
Organization: University of Delaware
Date: Thu, 20 Aug 1992 19:12:34 GMT


In article 2237@news.cs.brandeis.edu, rahul@chaos.cs.brandeis.edu (Rahul Chawla) writes:
>Greetings :
>
>
>After struggling with Dbase IV I am finally inclinded to choose
>another package. I am interested in puchasing Foxpro 2.0 as I have
>heard a lot about. I would appreciate any comments on the following :
>
>1). Can FoxPro create stand alone executionable files, if so, is the
>compiler included with the regular version ?? ( I am interested in the
>LAN version.)

Yes, FoxPro CAN create stand alone executionable files, for both extended
and non-extended memory users.  However, this is not included in the 
normal package.  If memory serves me right, it runs about $150.  It works
nicely. 


>2). Any comments on the LAN version of Foxpro.

Sorry.  No help here... :)

Ted

Newsgroups: comp.databases
From: swispl%Solomon.Technet.sg (SW International)
Subject: Advice on Database Purchase needed
Organization: National University of Singapore
X-Newsreader: Tin 1.1 PL5
Date: Sat, 22 Aug 1992 02:13:35 GMT

Hi,

I need some advice/comments on my next purchase..... :-)

Can some people out there give me their comments on the following
products:

	* Gupta,
	* C-tree,
	* Empress.

I'm trying to do puddle some work on either DOS/UNIX, in both MS-Windows
3.1 and/or OSF/Motif environment. 

Are the the 4GL (non-GUI or GUI based) stuff up to scratch? Or has
anyone got a better product that they know about - without costing me an
absolute Bomb! By the way I'm running a i386 machine for both the DOS
and Unix.

Thank you in advance.


Alvino...


--
SW International Systems Pte Ltd     |  "I've got a plan so cunning 
    14, Science Park Drive           | you could put a tail on it and
    Singapore Science Park           | call it a weasel".. Black Adder
    Singapore 0511                   | 
    Tel: (65) 778-0066               |
    Fax: (65) 777-9401               | swispl@solomon.technet.sg
From: Bruce_H_Ring@cup.portal.com
Newsgroups: comp.databases
Subject: Re: SQL database vendors for Unix
Date: Sat, 22 Aug 92 16:28:23 PDT
Organization: The Portal System (TM)



In his posting that lists SQL database vendors,
thompson@stars.gsfc.nasa.gov (William Thompson) says:

> Nor do I claim that the list is complete.  If anyone
> knows of any other database engines meeting our base
> requirements (SQL, Unix) not listed here, I would be
> happy to hear about them.

Gupta Technologies  SQLBase runs on SPARCStations:

SQLBase                                 Gupta Technologies, Inc.
                                        1060 Marsh Road.
                                        Menlo Park, CA 94025

                                        800-876-3267 (in the USA)
                                        410-224-8315 (outside the USA)

Bruce Ring
Gupta Technologies, Inc.
bruce_h_ring@cup.portal.com
From: rmc@davidge.com (Robert Cianchette)
Newsgroups: comp.databases
Subject: Re: Text base
Date: 18 Aug 92 13:05:01 GMT
Organization: Davidge Data Systems Corp., NYC, NY

In article <1992Aug17.005434.1@lure.latrobe.edu.au> socwk@lure.latrobe.edu.au writes:
>I wonder if anyone can help me? 
>
>I'm looking for a text based data base management system to use on a PC 
>that will allow me to enter or translate text in a file of unlimited size. 
>I've looked at a few DBs but none quite fit the bill.  I've heard that Reflex
>might be an option but I need something that has structured fields with
>unlimited text entry.
>
>					Thanking you in advance
>							Walter

Check out askSam. It has an editor and can import ASCII files.  It also
allows for a variety of database record structures, including free-text and
structured.  It can handle any size file.

		askSam Systems
		P.O. Box 1428
		Perry, FL 32347
		(800) 800-1997
		(904) 584-7481 FAX

Robert (a satisfied customer)

-- 
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.
Newsgroups: comp.databases
From: afataar@casper.cs.uct.ac.za (Aneekah Fataar)
Subject: convert SDM model to relational database
Keywords: informix, SDM
Organization: Computer Science Department, University of Cape Town
Distribution: a
Date: Tue, 18 Aug 1992 10:14:22 GMT


 Hi there..

As part of an Honours project I have to convert (map) input from a
semantic database model to a relational model.  The SDM model serves
as the user interface.

I am using Informix with SQL.

Any references or code or ideas will be appreciated  ASAP.

Thanx.

Aneekah Fataar
From: rbw00@ccc.amdahl.com (  324  Richard Wilmot)
Newsgroups: comp.databases
Subject: Re: distributed transactions
Date: 23 Aug 92 04:05:58 GMT
Reply-To: rbw00@JUTS.ccc.amdahl.com (  324  Richard Wilmot)
Organization: Amdahl Corporation, Sunnyvale CA

In article <BtDA1n.JrB@world.std.com> edwards@world.std.com (Jonathan Edwards) writes:
>My original post was a query to find out if any commercial databases
>were capable of robust hot standby. So far, NOT. So far, there doesn't
>even seem much acknowledgement that this is a correct approach
>to the problem.

Sorry, vacation prevented me seeing the original post. Remote
distributed databases may not have a fail-over capability but 
IBM has the Extended Recovery Facility which allows their IMS/VS
database system to take over for another failing IMS database
system. BUT the recovering system must be cabled to the same 
database disk drives and logging (journaling) disk drives. The journal
files may be duplicated (but still need to be accessible to both
computer systems). The cabling can be out to 9 km (?? at home
so don't have reference material).

IMS is not a relational database but I expect IBM to equip their
DB2 relational product also with Extended Recovery. I would also
expect the distance to be wider as IBM changes disk protocols.

Neither IMS nor DB2 run under Unix (TM). They need IBM's MVS operating
system which runs on IBM, Amdahl, or Hitachi machines.

Another requirement of Extended Recovery is that there be a double
cabled communication controller. Special changes were required to
communication protocols (e.g. don't ask user to log on to the alternate
system as it takes over) and I would expect startup of the failover
process to be extremely interesting: Are you (primary system) really
dead? If processing 500 transactions at the time of a failure then
500 transactions will need to be backed out and restarted and more
than 500 user sessions will need to be established before any user
sees any new stuff on their screens. This should provide interesting
times indeed.

-- 
  Dick Wilmot  | I declaim that Amdahl might disclaim any of my claims.
                 (408) 746-6108
From: briand@anasaz (Brian Douglass)
Newsgroups: comp.databases
Subject: Re: Hot Standby DBMS's
Date: 19 Aug 92 05:25:16 GMT
Organization: Anasazi, Inc.  Phoenix, Az

In article <Bt6IsC.F00@world.std.com> edwards@world.std.com (Jonathan Edwards) writes:
>In article <9208172103.AA04378@hplwk.hpl.hp.com> albert@HPLWK.HPL.HP.COM (Joseph Albert) writes:
>>
>>Jonathan Edwards writes:
>>
>>>In the transaction-processing world, there is the concept of a 'hot standby'
>>>system, which is a geographically separated system containing a copy of the
>>>database, and capable of coming online very quickly. The replicated data must
>>>be close to current, and guaranteeing complete synchronization is required
>>>by some applications. A further feature is the ability to 'catchup'
>>>incrementally to missed changes after an outage, without a complete database
>>>copy. Our database (homebrew non-relational) does this.
>>>Are there any other databases that can do this?
>>
>>A more reliable fault-tolerance would be obtained from redundancy at a
>>level which is lowered than the level of abstraction of the database.
>>Disks can be made redundant by having 2 or 3 physical disks, with
>[...]
>
>Yes, this is 'remote mirroring', which I discussed in my post.
>Note that I am talking about keeping the systems 100 miles apart. To do disk
>mirroring over that distance is EXTREMELY expensive: you basically need a
>fiber optic cable. Sending the journal stream of the database requires an
>order of magnitude (or two) less bandwidth.

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.  

Now of course some additional programming is necessary on both M1 and M2 so
that when one or the other is down, a sync log is created.  Once the down
machine is resurrected, the sync log is read and transactions are fed to
the revived machine until is catches up, and the sync process can go back
to sleep.

People from all three of these companies are listening and I'm sure they'd
be happy to post their addresses, phone numbers and contacts if people are
interested.

-- 
"... For I have sworn upon the alter of god, eternal hostility against
every form of tyranny over the mind of man."  Thomas Jefferson
Brian Douglass		briand@anasazi.com 	602-870-3330 X657
From: villas@ax.apc.org
Newsgroups: comp.databases
Date: 21 Aug 92 15:49 PDT
Subject: Re: Database library for DOS and Unix w
Nf-ID: #R:1992Aug20.204344.26061@smallo.bo:-139645537:ax:49800005:004:461
Nf-From: ax.UUCP!villas    Aug 21 15:49:00 1992


You can use CodeBase. I think it's current version is 4.5, it is
very portable and uses dBase files. We use it here on MS-DOS and
SunOS plataforms.

-----------------------------------------------------------------------------
Marcos Villas                                       Internet: villas@ibase.br
Instituto Brasileiro de Analises Sociais e Economicas, Rio de Janeiro, Brasil
-----------------------------------------------------------------------------

Newsgroups: comp.databases
From: Yanzhang.Lu@bbs.oit.unc.edu (Yanzhang Lu)
Subject: Re: FOXPRO 2 - HELP - REDIRECTING  "?" OUTPUT TO TEXT FILE
Summary: OUTPUT FILE, Printer
Organization: Extended Bulletin Board Service
Date: Thu, 13 Aug 1992 00:11:55 GMT

In article <i13.1@cs-acad-lan.Lakeheadu.Ca> i13@cs-acad-lan.Lakeheadu.Ca writes:
>I need to redirect the output from the question mark command (eg. ? recno(),
>? "I NEED HELP!!!!") to a text file.  The command SET DEVICE TO FILE 
><FILE NAME> only redirects output produced by the @...SAY command.
>Other commands such as DISPLAY have their own parameters to redirect 
>output to a file.  Nobody seems to know how to redirect the output of "?"
>to a text file.  Any ideas would be greatly appreciated.
>
>Thanks a million!!!!
>Dan Sullivan
----------------------------------------------------------
Well, I know how to do it.
Asuming your output text file is test.txt.
Put following statement in your program:
set printer to test
set printer on
? "the first line"
? "the second line"
You can use "set printer to" to close the file test.txt.
Good luck.

--
   The opinions expressed are not necessarily those of the University of
     North Carolina at Chapel Hill, the Campus Office for Information
        Technology, or the Experimental Bulletin Board Service.
           internet:  bbs.oit.unc.edu or 152.2.22.80
Newsgroups: comp.databases
From: prinz@hephaistos.gmd.de (Wolfgang Prinz)
Subject: Re: Help: Ontos and SunOS 4.1.2
Organization: GMD, Sankt Augustin, Germany
Date: Wed, 19 Aug 1992 11:17:41 GMT

igrdb@informatik.tu-chemnitz.de (Ingo Gringer) writes:

>since a few days we have run the version 4.1.2 of SunOS. Our Ontos
>2.2 runs under the antecedent OS  without problems, but now every
>trial to get a compiled application fails.

>The errors I receive are no of reloc y !=  no of reloc z, segmentation
>fault, arithmetic exeception and other probably accidently failures.

>The software distributor told me that there is a bug in the new SunOS 
>which will repaired by a patch from SUN (which?).

>Has anyone get a application ready under this circumstances?
>HOW??? Static linking and use the old linker of 4.1.1 generates other
>errors (again no of reloc.. and version mismatch in compiler/linker).

Just today I've experienced the same problem when I switched from
static binding to dynamic binding. After some testing I've found out
that it is the ONTOS library that causes the problems. The workaround I
use is to link this library statically by explicitly refering to
libONTOS.a instead of -lONTOS.

A colleague of mine had the same problems with other libraries. His
assumption is that this behaviour is caused by "extern" definition
which cannot be resolved correctly in the shared library. The old SunOS
4.1.2 linker didn't probably check this. However the error message
produced by the linker seems to be very strange.

Hope this helps


Wolfgang Prinz
GMD
Schloss Birlinghoven		Tel.: +49 2241 14 2730
5205 St. Augustin, Germany	mail: prinz@fit.gmd.dbp.de
--

Newsgroups: comp.databases
From: albert@HPLWK.HPL.HP.COM (Joseph Albert)
Newsgroups: comp.databases
Subject: distributed transactions
Date: 21 Aug 92 02:44:47 GMT

edwards@world.std.com (Jonathan Edwards) writes:

>Distributed transactions have the well-known effect
>of eroding system autonomy. If one system goes down, it can leave various
>locks on the other which can not be broken until the system is recovered
>(unless they are forcibly broken, resulting in possible inconsistent databases
>requiring manual resolution).

If a non-blocking commit protocol is used, any transaction started at
a remote site which went down can be aborted, releasing its locks, and
leaving the database in a transaction-consistent state.

Joseph Albert