HDTenEightyP/NetNews huggingface dataset:
From: dhepner@cup.hp.com (Dan Hepner)
Newsgroups: comp.databases
Subject: Re: Hot Standby DBMS's
Date: 26 Aug 92 00:30:14 GMT
Organization: Hewlett-Packard
X-Newsreader: Tin 1.1scd1 PL4

From: chris@yen.imsi.com (Chris Payne)

> One clean solution to the hot-backup equivalence problem is to
>serialize the request stream.  Guarantee that when a credit precedes a
>debit on one db server, it precedes the debit on all active servers.

If this advice "credit must always precede debit" is not followed you 
might get deadlocks even without replication.  However, this is insufficient 
to prevent the other kind of out-of-order deadlocks.  What you have to 
guarantee is that a transaction will acquire locks in a specified order 
across copies.  I.e. execution of credit on copy 1 must always complete 
before beginning on copy 2.

>If you want to catch-up a server which is down periodically, keep a
>copy of the request stream.

How would you guarantee that transactions will be executed in the same
serial order as was implied by the online system?  As has been pointed
out, such a guarantee is required to keep the copies synchronized.

Dan Hepner
Newsgroups: comp.databases
From: M14465@mwvm.mitre.org
Subject: Q+E over a DDE link
Organization: The MITRE Corporation, McLean VA 22102
Date: Mon, 31 Aug 1992 11:07:25 GMT

Need help using Q+E to interact with Microsoft SQL Server.  Am writing an
application in WordBasic in which I retrieve data from a remote database in
SQLServer using a DDE link with Q+E.  I find that I can send fairly simple SQL
commands over the DDE link to Q+E such as SELECT * FROM [Database] but if I try to get
fancy by adding a WHERE clause it can't do it.  I've checked to see if I Q+E
can handle such a command by entering it directly in Q+E and find that it does.
 
Anyone with experience in this area?  Thanks in advance!
 
Newsgroups: comp.databases,comp.os.vms,comp.windows.misc
From: mccrohan@salthl.enet.dec.com ()
Subject: Re: Windows DAL client wanted for VAX/VMS RDB Database
Reply-To: mccrohan@salthl.enet.dec.com ()
Organization: Digital Equipment Corporation
Date: Fri, 4 Sep 1992 08:49:10 GMT


DECreport might be an option for you. From the Users Guide:.....

"
Overview


DECreport for Microsoft Windows is a fuIl- featured report writer
for personal computer (PC) users. DECreport provides an easy
to use yet powerful visual interface which allows you to create
custom printed reports using data from dBase database and
EXCEL spreadsheet files on your PC

 When used with DECquery for Windows Version 20 DECreport
can also use the data retrieved from remote or local database
queries Through DECquery, you can use relational data from
the following types of databases in your reports.
                  VAXRdb/VMS
                  VAX RMS (through RdbAccess for VAX RMS)
                 . ORACLE (through RdbAccess for ORACLE on VMS)
                  IBM DB2 (Through VIDA for D62)
                  local dBase files
                  Microsoft SQL Server
                  Novell Netware SQL
                                                      "

Mail me direct if you want more info and I'll point the experts
in your direction if you wish.

Regards,
Mike MCROHAN@SALTHL.ENET.DEC.COM
Newsgroups: comp.databases
From: msf@world.std.com (Michael S Feinstein)
Subject: Image data in Sybase
Organization: The World
Distribution: comp
Date: Wed, 2 Sep 1992 18:53:22 GMT


	I am currently experiencing some perplexing (both to me and to
Sybase Tech. Support) problems regarding the storage of the image
datatype in a table.  I am running  SQL Server version 4.2 on a
SPARCstation 2 running SunOS 4.1.1b.  It seems as though every time a
few of these rows are written to the table, the entire database gets
corrupted (605 and 823 error codes).
	I realize that my desription is vague.  To get into gory
details could take months :).  If anyone has ANY ideas, suggestions,
prayers, etc. that may help, please submit them (either publicly or
via Email) to me.  I am willing to try almost anything, as Sybase has
been of little or no help.
	Thanks in advance for anything you can provide (even a sad
anecdote might help).

		-Michael Feinstein
		 mike@blackhawk.com
Newsgroups: comp.databases
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: Simple Question on Paradox
Organization: U.S Dept. of Transportation
Date: Thu, 27 Aug 1992 20:29:35 GMT

naren@tekig5.pen.tek.com (Naren Bala) writes:

>For those of you who are experts at using paradox, I had a simple question.
>I have started using paradox. Can anyone tell me how to merge 2 tables into
>one table ?  Any help will be appreciated. 

More information is needed.  Do the tables have the same structure?  If so,
you can use Tools|More|Add.
Are you adding the fields of one table to the second?  Create a query using
an example element to link the tables.  See chapter 4 of the Paradox Users
Manual about joins, and details on keeping repeating values and dealing with
missing values.  After you press Do_it! and get an Answer table, use
Tools|Rename to save it as a permanent table.
If this merged table is one that will be recreated _temporarily_ for reports,
based on the second example above; create the table as above, then Empty it
*BUT DO NOT REMOVE THE TABLE*.  Create your reports using that table and
save them.  Then, in the future, each time you create a new Answer table,
copy the desired report from the empty table with the same structure to
Answer and run it.  The only purpose for the empty table is to hold the
report definitions for the structure you desire, but this is a necessary
purpose.
Hope this helped; feel free to ask if you need clarification or more
information.

-JTT

Newsgroups: comp.databases
From: rcbc@fafnir.cs.cornell.edu (Robert Cooper)
Subject: Re: Hot Standby DBMS's
Reply-To: rcbc@cs.cornell.edu
Organization: Cornell Univ. CS Dept, Ithaca NY 14853
Date: Wed, 26 Aug 1992 18:06:18 GMT

> >Isis atomic multicast guarantees to deliver the messages in the same order
> >at both primary and backup.
> >        -- Robert Cooper
> 
> Does Isis guarantee atomic commit across both copies?

The "Atomic" in atomic multicast means:

(1) a total order on message delivery at all destinations. So if 
    two clients send atomic broadcasts to a set of 3 servers, all servers
    will see the two messages in the same (arbitrary) order. This ensures
    coordinated input streams in the replicated DBs.
(2) atomic delivery. Either all destinations will receive the message, or
    none of them will. This handles cases where the sender fails part way
    through sending the message, e.g. it broadcast the message, but one
    recipient dropped it because of a buffer overrun and before the 
    sender can retransmit, the sender crashes. Isis will make on of the other
    recipients forward its copy of the message to the receiver that needs
    it in this case.

So, no, it doesn't guarantee atomic commit. When Isis is treating the DBs
as black boxes, you have to convince yourself that both DBs will carry out
the same action (abort or commit) on the same input data. That's why we
have to be very careful about the input stream the DBs see so that they
really are deterministic. In the limit this means having the front end
apply update transactions one-at-a-time and exclude read-only transactions
while this is happening. Typically, in a controlled environment, and with
application level knowledge about the transaction stream, we can make some
valid assumptions about the DBs being deterministic. But not in the general
case, which is why we don't try to package this up as a generic solution,
but rather help the customer do this on a case-by-case basis. Or, in other
cases the application can take explicit recovery if the one DB aborts and
the other commits. 

We do have a general transaction tool in Isis that solves these problems by
running a 2PC protocol with the DBs. Obviously in this case the DBs aren't
black boxes. The X/Open standards in this area are very interesting to us.

        -- Robert
--
-- 
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: Wed, 26 Aug 1992 20:52:19 GMT

In article <1992Aug25.201150.22996@fig.citib.com> gjb@fig.citib.com (Greg Brail) writes:
>There may well be philosophical aspects to "system autonomy" that make
>it a good thing, but distributed transactions as implemented by Tuxedo
>or Encina do not cause the problems you describe above. If, for argument's
>sake, we describe a "physical transaction" as an atomic action managed
>by the transaction management system, then we will begin the physical
>transaction, debit the account, and send a message asking the brokerage
>application to purchase the stock. We wait for the brokerage to respond --
>if something goes wrong, we abort the whole transaction and the bank
>debit (along with whatever may have happened of the stock purchase) are
>completely undone. No locks need be forcibly broken.

Does the brokerage application makes changes to its own database as part
of a distributed transaction that includes changes in the requesting system?
If so, you have the well known problem that a 2-phase commit protocol can
block due to failure situations. This forces locks on one system to be held
till the other has recovered; manually breaking those locks can leave the
distributed transaction non-atomic: only parts of it completed. This is the
problem I was referring to. Tuxedo and Encina do not have a solution to this
problem, or at least if they do, they had better patent it cause its worth
a fortune! It seems to me that a lot of people are trying to sweep this
problem under the rug because it would be so much more convenient that way.



-- 
Jonathan Edwards				edwards@intranet.com
IntraNet, Inc					617-527-7020
Newsgroups: comp.databases
From: don@robin.SanDiego.NCR.COM (Don.Russell)
Subject: Re: Hot Standby DBMS's
Summary: blocking 2-phase commit
Keywords: X/Open, heuristic decisions
Reply-To: don@robin.SanDiego.NCR.COM (Don.Russell)
Organization: NCR Corporation, Rancho Bernardo
Date: Fri, 28 Aug 1992 17:04:56 GMT

In article <BtLzB8.H9J@world.std.com> edwards@world.std.com (Jonathan Edwards) writes:
>
>Does the brokerage application makes changes to its own database as part
>of a distributed transaction that includes changes in the requesting system?
>If so, you have the well known problem that a 2-phase commit protocol can
>block due to failure situations. This forces locks on one system to be held
>till the other has recovered; manually breaking those locks can leave the
>distributed transaction non-atomic: only parts of it completed. This is the
>problem I was referring to.
(stuff deleted)
>
>
>
>-- 
>Jonathan Edwards				edwards@intranet.com
>IntraNet, Inc					617-527-7020

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

No patents are necessary here since it is covered by the X/Open XA
Specification.  TOP END is a transaction manager implementing the XA
interface.

Don Russell
TOP END Distributed Transaction Management
NCR Corporation
San Diego, CA

don.russell@SanDiegoCA.NCR.COM
Newsgroups: comp.databases,comp.unix.ultrix
From: rmc@davidge.com (Robert Cianchette)
Subject: Re: Bibliography Database
Organization: Davidge Data Systems Corp., NYC, NY
Date: Fri, 28 Aug 92 13:34:35 GMT

In article <1272@niktow.canisius.edu> pavlov@niktow.canisius.edu (Greg Pavlov) writes:
>
>  I believe I have seen postings on this before but I didn't retain them:
>  does anyone know if there are any packages out there that will manage
>  (well, help one manage...) a bibliography database ?  Needs to run on
>  DEC/RISC ULTRIX systems, preferably, tho a dos-based system may do in 
>  a pinch...

In terms of DOS applications, Pro-Cite from PBS in Ann Arbor, MI is very
good.  It includes lots of report choices pre-formatted to conform with
all kinds of standardized bibliography styles (Chicago Manual of Style,
professional journal styles, etc.)

If you plan to have an annotated bibliography with extensive notes or abstracts,
you would be better off to look at some kind of full-text information manager,
such as askSam from askSam Systems, Perry, FL (800-800-1997).

I strongly suggest you stick with an application written to manage textual
information.  Even the best and brightest database products are practically 
useless when it comes to functionallity for managing text.

Robert

-- 
Robert Cianchette, Davidge Data Systems Corp., NYC | rmc@davidge.com
-------------------------------------------------------------------- 
 The information, questions, and opinions contained in this message 
  are mine and are not representative of Davidge Data Systems Corp.
Newsgroups: comp.databases
From: zygote@cs.uiuc.edu (The seed of all life)
Subject: Re: Mailing lists in OODBMs or OOM ?
Organization: University of Illinois, Dept. of Comp. Sci., Urbana, IL
Date: Fri, 4 Sep 1992 13:05:19 GMT

t9214309@phillip.edu.au writes:

>Dear Netters:
>Is there any mailing list for OODBMs or OOM?
>If so, how does one enlist in the mailing list?
>Thanx in advance
>Nagesh
>Email:    t9214309@phillip.edu.au

Could you (or any replyer) post the info?

thanks

Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: SQL queries, and the amount of data passed
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Thu, 3 Sep 1992 22:12:00 GMT

I was just talking to someone about the difference between using a database
manager and a transaction manager.  One of the points he made was that when
using an SQL database manager, and sending SQL commands from a client machine
to the server machine, a lot more data than what one wants may be sent from the
server to the client, which then filters the data down to what satisfies the
request, and returns it to the application.

I'm in the process of trying to select a database product for a project I'm
working on.  The database would catalog information about some scientific data
that would collected over several years.  When querying the database, one
generally would be looking at some restricted time frame, and I anticipate that
the file would be indexed chronologically (perhaps along with other properties)
for faster access.

My anticipation was that when using SELECT or FETCH (and please excuse me if I
use the wrong terms; I don't know much SQL-speak), and the filter (e.g. WHERE
clauses, views, whatever) matched the indexing scheme, then the database engine
would automatically retrieve only the data matching the view.  More
specifically, if I was only interested in the data for November, and the data
was indexed chronologically, then the server would be able to skip directly to
the data for November through something like a binary search.  I guess it makes
sense to me that view conditions that don't match the indexing scheme might be
processed on the client.

Am I thinking of this correctly?

Bill Thompson
From: einhorn@apsicc.aps.edu (The Einhorn Family)
Newsgroups: comp.databases
Subject: Re: FoxPro 2.5
Date: 25 Aug 92 19:41:00 GMT
Organization: Albuquerque Public Schools - Career Enrichment Center
News-Software: VAX/VMS VNEWS 1.41

In article <1992Aug24.230708.1849@tdkcs.waterloo.on.ca>, timk@tdkcs.waterloo.on.ca (Tim Kuehn) writes...
> 
>In a recent advertisement in PC Mag, Microsoft said anyone who's running
>any other dbase language could get a copy of Foxpro for $199 US, and the
>next version (2.5) for free.
> 
>Any word on what kind of offer those of us who've had Fox SW for eons and 
>have paid all the upgrade fees/etc. will have to pay to get Foxpro 2.5? 
> 
>

Also, what new features will 2.5 include and when is it due out?
Newsgroups: comp.databases
From: nett@technix.mn.org (Jerry Nettleton)
Subject: Network database model - Raima Data Manager (db_VISTA III)
Organization: Private System - Saint Paul, MN
Date: Thu, 03 Sep 1992 02:54:16 GMT

Being new to network database model, I have a question related to
sorting members of a set.  If I want to merge 2 records with their
associated member records, how would I sort the members records as
they are added to the record to be saved?  Or how to sort the
members of a single record?  The only way I can think of is to
disconnect all members and the reconnect them sequentially after
finding the proper insertion point.  Does anyone have any source
they could share (or public domain)?

-- 
Jerry Nettleton
email: nett@technix.mn.org
       ...!uunet!cs.umn.edu!kksys!edgar!technix!nett
From: 2pereira_f@spcvxb.spc.edu
Newsgroups: comp.databases
Subject: SuperNOVA Dbase Package (NEW)
Date: 1 Sep 92 14:32:22 GMT
Organization: St. Peter's College, US

Has anyone heard of SuperNOVA Dbase Package?
It's is a new object oriented database Package which
interfaces with 'C' and Teradata, Informix, Oracle Databases.
I can be run on PC and genaraly used with UNIX Systems.

If you have heard of this package, what do you think of it?

see ya,
Felix   
E-mail: 2pereira@spcvxb..s
Newsgroups: comp.databases,comp.lang.eiffel
From: stevef@bony1.bony.com (Steve Faiwiszewski)
Subject: Re: Persistent Eiffel?
Keywords: persistence ODBMS Eiffel
Organization: Lost in NYC
Date: Tue, 1 Sep 92 22:30:08 GMT

In article <1992Aug27.144915.17853@nntp.nta.no> olea@hal.nta.no (Ole J. Anfindsen FDA) writes:
>Can someone tell me whether or not an Eiffel-based ODBMS (persistent Eiffel)
>is available?
>
>-- 
>Ole J. Anfindsen 
>Norwegian Telecom Research
>E-mail:  ole.anfindsen@nta.no
>


You probably should have crossposted to comp.lang.eiffel.

There's one OODBMS called O2, which supposedly works with Eiffel.
Another, Versant, will in the future: ISE and Versant will develop an
Eiffel interface jointly.  In the meantime, we've been using Versant's
C interface to build our own Eiffel interface.  While not, completely
transparent or automatic, our interface is quite usable.

	- Steve -
-- 
Internet: stevef@bony1.bony.com   |  ____________________________
bang : {uupsi,uunet}!bony1!stevef | / If cows could fly, everyone \
                                  ||| would carry an umbrella     ||
  Opinions? What opinions?        | \_____________________________/
Newsgroups: comp.databases
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: Q&A question?
Organization: U.S Dept. of Transportation
Date: Fri, 28 Aug 1992 14:01:36 GMT

alessio@cs.columbia.edu (Eduardo Alessio) writes:

>	When printing in a landscape mode with Q&A DB, the printer
>ignores the program settings:

>	paper width: 110
>	paper length: 51
>	cpi	    : 17 (compressed)
>	left margin : 1
>	right margin: 110

>	The output comes out in landscape but prints only half of the
>page. 	Printer is an Epson Lasser JetII; Is there something else that
>should be specified?, has anyone had experience with this?.

Yes.  You need to check the settings for that particular report.  They
override any defaults.  I believe you want Ctrl-F6 (Q&A and template not
here at the moment) to get to the page definition for that report.

-JTT
From: dclunie@ucs.adelaide.edu.au (David Clunie)
Newsgroups: comp.dcom.isdn
Subject: ISDN in Australia
Date: 31 Aug 92 09:58:00 GMT
Organization: Her Master's Voice


I have recently moved to Australia and understand that ISDN services
are available here. Does anyone have any experience with them and
know what sort of setup costs and usage charges are incurred for
local access and international usage (ie. to the states, say to PSI).

I am not really familiar with ISDN but I understand it provides a
relatively high bandwidth switched network that one can just plug
into and make "calls" to other nodes ? Am I wrong ?

-- 
David Clunie (dclunie@itd.adelaide.edu.au)
From: gtoal@ibmpcug.co.uk (Graham Toal)
Newsgroups: comp.dcom.isdn
Subject: Re: ISDN in Australia
Date: 31 Aug 92 17:50:58 GMT
Organization: The IBM PC User Group, UK.

In article <8380@sirius.ucs.adelaide.edu.au> dclunie@ucs.adelaide.edu.au (David Clunie) writes:
:
:I have recently moved to Australia and understand that ISDN services
:are available here. Does anyone have any experience with them and
:know what sort of setup costs and usage charges are incurred for
:local access and international usage (ie. to the states, say to PSI).
:
:I am not really familiar with ISDN but I understand it provides a
:relatively high bandwidth switched network that one can just plug
:into and make "calls" to other nodes ? Am I wrong ?

Unfortunately you are since ISDN is really point to point - it's just
a very good telephone connection in essence.  However, you *may* be
lucky enough to find some internet provider with dial-in ISDN access.

I don't know of any though, but I'm sure they'll happen Real Soon Now...

G
--
From: clarke.stevens@gtri.gatech.edu (Clarke Stevens)
Newsgroups: comp.dcom.isdn
Subject: ISDN on Macintosh
Date: 27 Aug 92 14:41:50 GMT
Followup-To: comp.dcom.isdn
Organization: GTRI/AERO

Does anyone have experience using an ISDN card for the Mac?  I would be
interested in hearing how well this solution works.  Do you get direct
Internet access?  How do ISDN phone rates compare to normal phone rates? 
Any information would be helpful.

Thanks in advance,
Clarke

------------------------------------------------------------------
J. Clarke Stevens               |  Georgia Tech Research Institute
clarke.stevens@gtri.gatech.edu  |  (404) 528-3254
Newsgroups: comp.dcom.isdn