HDTenEightyP/NetNews huggingface dataset:
From: dmmatt@bigez (Mike Mattix)
Subject: Re: References wanted on Distributed Databases
Organization: Monsanto Agricultural Company
Date: Wed, 16 Dec 1992 17:54:36 GMT

In article <Dec.15.16.02.57.1992.27495@andromeda.rutgers.edu>, holowcza@andromeda.rutgers.edu (Richard D Holowczak) writes:
> 
>   I think there is a big difference between distributed partitioned data and
> distributed replicated data.  I would be interested to know how Rdb (and
> others) handle site failures, communication failures and recovery.
> Any comments?
> 
> 
> 
> Rich Holowczak
> Rutgers University
> holowcza@andromeda.rutgers.edu

  Since I brought up Rdb (I just get sick of hearing about the NEW ADVANCED
features of Oracle/Ingres), I probably should take a stab at this.  The 
application we did originally had distributed partitioned data (multiple table of 
different data on different network nodes).  The application worked fine we ended
up consolidating the application on one node for performance reasons.  I don't 
believe many people will argue that distributed applications tend to perform worse
than applications where all the data resides on one node.  The failure of a node is 
handled by the two phase commit function during a transaction.  The failure of a node 
is handled by error trapping after that, ie the application will not be able to 
attach to the remote node and the remote database.  Running VMS and DECNet if an
alternate path to the database is available the application will be able to resume
as soon as that path is established.  Neither the programmer nor the system/network 
manager will need to do anything.

  I am not sure I have covered all you asked (I am not even sure I am qualified), 
however if more detail is needed, just post.

regards,

-- 
Mike Mattix
Agricultural Group of Monsanto
P.O. Box 174
Luling, LA 70070
INTERNET Address: dmmatt@bigez.monsanto.com
Newsgroups: comp.databases
From: kitchel@manta.dpsi.com (Sidney W. Kitchel)
Subject: Re: SQL-92
Organization: Data Parallel Systems, Inc
Date: Wed, 16 Dec 1992 20:13:07 GMT

athula@beta (Athula Herath) writes:

>Is the SQL-92 Standard published? If so does anybody know whether it is an
>ANSI standard (or ISO)? and the reference number for the standard?

	I phoned the ANSI publication office last week to order it.
They said that the new standard is finished but still being printed.
They advised that I wait a month or so and call back.

							--Sid
--
Sidney W. Kitchel  	    kitchel@cs.indiana.edu, kitchel@dpsi.com
Data Parallel Systems, Inc.  ============||  DPSI  ||===============
4617 E. Morningside Drive	                      (812) 334-8100
Bloomington, Indiana,  47408  USA		FAX:  (812) 334-8121
Xref: sparky comp.databases:8543 news.misc:2052
From: erani@moon.lannet.com (Eran Ishai)
Newsgroups: comp.databases,news.misc
Subject: Where are High Availabilty Systems discussed ??
Date: 16 Dec 92 10:20:11 GMT
Followup-To: comp.databases
Organization: Lannet Data Communications ltd., ISRAEL

Any pointer to a newsgroup which discusses this subject would be helpfull.

Thanx in advance,

	Eran Ishai
	Unix Network Administrator
	Lannet Data Communications Ltd., ISRAEL.

	E-mail:	erani@lannet.com
	Voice:  972-3-6458360
Newsgroups: comp.databases
From: a2509kan@cdf.toronto.edu (Damian R. Kanarek)
Subject: a simple distributed dbase - need help getting started
Originator: a2509kan@eddie.cdf.toronto.edu
Organization: University of Toronto Computing Disciplines Facility
Distribution: na
Date: Sat, 19 Dec 1992 08:07:02 GMT

Hiya all,

 I'm thinking about putting together a small distributed system from scratch. 
Before I commit myself, though, I'd like to flip through some literature to 
get an idea what I'd be getting myself into :-). Could someone recommend 
some reading material on the topic of distributed system, please? 
Something which a master's student could follow (ie doesn't have to be 
right on the edge of technology). Any tips would be much appreciated. 
Thanks,

Damian

--
Damian R. Kanarek                      |"I am an insomniac-agnostic-egotist:
Faculty of Libr. & Information Science | I lie awake nights trying to figure
University of Toronto                  | out whether or not I believe that I'm
email -> kanarek@flis.toronto.edu      | as great as I am." - Frank   
Newsgroups: comp.databases
From: messina@netcom.com (Tony Porczyk)
Subject: Re: MICROSOFT ACCESS vs FOXPRO
Organization: Messina Software
Date: Sat, 12 Dec 1992 00:42:40 GMT

jcberger@grasp1.univ-lyon1.fr (Jean-Claude Berger) writes:

>Does anybody knows what will be the Microsoft policy about
>Access vs. FoxPro (for Win). Is Access an end user product and Fox a
>developper oriented one ? Are they aimed at the same market ?

I purchased Access solely based on the information from Miscrosoft that
they will have a distribution kit for it some time early next year, end
of January, early February.

t.
Newsgroups: comp.databases,comp.sys.ibm.pc.misc,comp.apps.spreadsheets,comp.databases.informix,comp.databases.oracle,comp.databases.ingres,comp.databases.sybase
From: rna@leland.Stanford.EDU (Robert Ashcroft)
Subject: Looking for database/stat/graphics applicatioN
Reply-To: biondim%brazil@uunet.uu.net
Organization: DSG, Stanford University, CA 94305, USA
Date: Sat, 19 Dec 92 00:16:34 GMT

We are looking for a software application for the PC with the following
characteristics:

Querying, regression analysis, statistical graphics preferably menu
driven (point and click).

For example we would like to read in some data, pull certain values that
match certain criteria, run regression analyses, and graph the data and
the regression easily.  It also has to run on a PC though this could be
as powerful a 486 as you like.

No single package that we are aware of is capable of doing all these things.
We'd be happy using a combination of two packages, so long as they mesh
well, if a single package is not available.  Ease of use is key.

PLEASE DO NOT REPLY TO THIS ACCOUNT!

Instead, please reply to: biondim%brazil@uunet.uu.net
                      or  uunet!brazil!biondim




Newsgroups: comp.databases
From: messina@netcom.com (Tony Porczyk)
Subject: Re: Microsoft Access
Keywords: SLOW
Organization: Messina Software
Date: Sat, 12 Dec 1992 20:35:13 GMT

rogers_m@watson.bms.com (MICHAEL ROGERS) writes:

>I got Access yesterday, dismayed to learn there is no runtime license 
>included, supposed to be a runtime kit in Feb. which will list for $495.
>The program is _S_L_O_W_.  It does disk read/writes while nothing seemingly is 
>going on, i.e., you're sitting there reading the help screen for a few 
>minutes, and the hard drive kicks in for a few seconds for no obvious reason.
>I admit I'm a newbie dbms user, but I never thought it would be like this.
>Wait for Paradox Win, seems this was rushed to market to get the jump on 
>Borland and still needs a good bit of optimization.  

Which I, frankly, find a perfect reason to buy it.  By the time you
have your first apps ready, an optimized version will be out :-)
I hate waiting.  Besides, if you want to talk about slow, take a look
at ObjectVision - now, *that* is _slow_ redefined.
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox 3.5 and SQLlink 4.0 and VAX/VMS rdb
Summary: SQL Link 4.0 => Paradox 4.0
Keywords: Paradox SQL SQLlink VAX/VMS rdb
Date: Wed, 16 Dec 92 19:56:04 PST
Reply-To: rhaven@cruzio.santa-cruz.ca.us



Yes, you need to upgrade to Paradox 4.0.  I don't mean to sound naive
about Boeing, but there are an awful lot of very high powered Paradox
developers up there; I'm surprised you don't have a local number to
call.

I will be glad to do what I can to help you with Paradox.  I'm not an
official Tech Support (I work as a QA Engineer on Paradox DOS), so
I might not have the answers immediately.  I'm on use net about twice a
week and there are lots of others here too.

Cheers
Newsgroups: comp.databases
From: woan@exeter.austin.ibm.com (Ronald S. Woan)
Subject: Uniface experience anyone?
Date: Wed, 16 Dec 1992 21:27:04 GMT
Reply-To: woan@fearless.austin.ibm.com
Organization: Austin School of Hardknocks

Is there anyone out there with experience developing applications in
the Uniface environment that would be willing to share your
experiences? Especially any polyserver experience...

Thanks,
Ron
-- 
+-----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: podgorny@npac.syr.edu (Marek Podgorny)
Subject: Using an RDBMS for scientific apps?
Summary: Are there any projects doing this?
Keywords: RDBMS, scientific applications
Organization: Northeast Parallel Architectures Center at Syracuse University (NPAC)
Date: Wed, 16 Dec 92 11:56:08 EST

We are considering use of the Oracle RDBMS as database engine
for scientific applications (Earth science, physics). I would
appreciate any pointers to similar work, completed or in progress.
Oracle not essential, relational technology yes.
 
Marek Podgorny, NPAC, Syracuse University
Newsgroups: comp.databases
Subject: Criss Cross Directory ONLINE
From: sabarnett@ualr.edu
Date: 11 Dec 92 14:01:01 GMT
Organization: University of Arkansas at Little Rock


Can anyone tell me if a online
service exists that has Cris Cross Information like the 
book itself
From: price@helios.unl.edu (Chad  Price)
Newsgroups: comp.databases
Subject: Re: Advanced Revelation information request
Date: 17 Dec 1992 17:42:02 GMT
Organization: University of Nebraska--Lincoln	
NNTP-Posting-Host: helios.unl.edu

dirbze@doc.bmd.trw.com writes:

>.... and my $.02....

>In article <1globmINNn4t@crcnis1.unl.edu>, price@helios.unl.edu (Chad  Price) writes:
>> clinton@acs.ucalgary.ca writes:

>Hmmmm.... actually, I would say ARev _does_ support integrity rules in the
>dictionary... ARev data dictionaries contain 'Edit' constraints which can be
>any of a wealth of 'canned' constraints [dates, numeric fields, pattern
>matching, etc..] and can also contain custom constraints through "symbolics"...
>once you define these edits, they are bound to the data element in any future
>reference to that element - but this is limited to Paint... so a little caution
>is prudent - you CAN bypass the edits...

I guess we were using different assumptions about the meaning of the question.

dirbze@doc.bmd.trw.com is certainly correct that it is possible to define and
use referential integrity rules; however, many of the people I have talked to
in the last year or so are requiring that a database engine _enforce_
"referential integrity". That is to say, not only must there be a data
dictionary which contains executable rules, but all data accesses must be
filtered through these rules through an Active data dictionary.

ARev, in all of its versions, has what I call a passive data dictionary. The
rules and data dictionary can be put in place, but the user must explicitly
choose to use them. In particular, as mentioned, you can completely by-pass the
referential integrity rules. In fact, you can edit any record, including data
dictionary records and compiled code, using the ARev text editor. This can be
an advantage if somehow a record is corrupted and won't even display using the
data entry screen. If you know what belongs there, you can edit it and patch it
into displayable form.

A minor semantic point, but important if you are looking for a rules enforcer!

--
chad
price@helios.unl.edu
cprice@molecular.unmc.edu
Newsgroups: comp.databases.ingres
From: gribble@bronze.ucs.indiana.edu (steve gribble)
Subject: Re: OBDC from Ingres ?? Open .. Database .. something..???
Organization: Indiana University
Distribution: na
Date: Thu, 17 Dec 1992 14:14:35 GMT

What Ingres is writing is the Ingres ODBC driver.
ODBC (Open Database Connectivity) is Microsoft's specification
for a SQL Call-Level Interface.  It is a superset of the SQL Access
Group's proposed spec.  MS is a member of SAG and has submitted ODBC
to the group for consideration.

What this means for the developer is they have a single SQL API to program to.
For the end-user it provides a way for any Windows application that writes
to the ODBC spec to access any database for which a driver has been
written.  The stack on a PC for Ingres looks vaguely like this:

Win App
ODBC Manager
Ingres ODBC Driver 
Ingres/Net

Yes, you still need Ingres/Net.  The only application that currently supports
ODBC as far as I know is Access from MS.  There will be many others soon though.
Early next year you should be able to use Excel to get directly at Ingres data.


steve gribble
indiana university
Newsgroups: comp.databases.ingres
From: melkor!valandil!mal (Michael A Leo)
Subject: Re: Raw Datafiles on Ingres??
Organization: National Radio Astronomy Observatory
Date: Mon, 14 Dec 1992 19:47:27 GMT

    In article <rule-091292172916@17.9.6.35> rule@apple.com (Jeff Rule) writes:
    >In article <1992Dec9.172402.3908@sequent.com>, map@sequent.com (Michael
    >Perry) wrote:
    >> However, you can turn on Direct I/O by using:
    >> 
    >>    ingsetenv II_DIRECT_IO y
    >> 
    >> and restarting your server(s). Tthis will help your file-system I/O.
    >> 
    >
    >Tell me more!  How is this different from the "normal" way ingres is doing
    >I/O?  What are the tradeoffs?  Is this documented anywhere?
    
    This way Ingres bypasses the Unix buffer cache and writes directly to
    the cooked file.  There is a performance increase but I haven't
    measured it.
    
    I believe it is documented in the I&O Guide.
    
    Mike
    -- 
        "Life's a bench, then you die!"


Alas, I called Ingres tech support, and this only works on Sequent machines.
As it indicates, Ingres will bypass the file system.  According to Ingres
the performance increase is quite substantial.  

Could this be why Ingres benchmarks so well on Sequent ;-?

Mike Leo
mike.leo@adc.com
From: pavlov@niktow.canisius.edu (Greg Pavlov)
Newsgroups: comp.databases.ingres
Subject: INGRES SERVERS
Date: 11 Dec 92 22:21:18 GMT
Organization: Canisius College, Buffalo NY. 14208


   Our server is quickly running out of gas (cpu-wise) and we need to upgrade.
   Our estimate is that we need a server with at least twice the cpu through-
   put of our current one.  Further, we would prefer such an increase in 
   single-stream performance, since we have a long sequential batch process
   stream that must be run each night and that must be finished by the time
   that interactive users begin to pound away in the morning.  But we can try
   to parallelize some of it if necessary (we would rather not).


   Our current server is a DEC 5000/240 running ULTRIX and INGRES 6.4 .  It
   is almost certain that the successor to this machine will have to come from
   another vendor:  DEC's MIPS RISC upgrade is way behind schedule, INGRES
   will not be available under ALPHA/VMS until next summer at the earliest,
   and a port to ALPHA/OSF/1 is at least a year away.  Schedules slip.

   Looking at INGRES's "first tier" ports, it appears that our most likely 
   choices (running UNIX) are SUN, HP, and IBM.  I would appreciate
   hearing from anyone who:

     1. has evaluated these three for INGRES and their conclusions;

     2. is already using INGRES version 6.n in a mixed environment such as
        this  (we did so with version 5, but INGRES was a different system
        then);

     3. has a good sense of how well INGRES "takes advantage" of a multi-cpu
        system, when that system is dedicated to INGRES server processes
        (we use INGRES/NET).


   I will honor any requests to keep answers confidential.



   Thank you,

    Greg Pavlov
    pavlov@karloff.fstrf.org
Newsgroups: comp.databases.ingres
From: "Anthony J. Rzepela" <rzepela@hal.hahnemann.edu>
Subject: Re: Need help with GROUP BY clause
Organization: National Radio Astronomy Observatory
Date: Sat, 12 Dec 1992 18:41:05 GMT

 In article <2953@dwrsun4.UUCP> perl@dwrsun4.UUCP (Robert Perlberg) writes
 about needing to group his securites by year, and then performing
 a summary function (totalling some dollar amounts) on another field. 
 
 He was dismayed because GROUP BY was insufficient, and was worried that
 he would havee to go to some non-SQL forum.  Well, with *SOME* ongoing
 work required (updateing the SQL statement every year) one can avoid
 dummy fields, auxiliary tables, and the like. 
 
 One can use summary functions in the select-list clause of subqueries in
 a UNION query.  
 
 For example, the following query:
 
 
 select year = 1990, total_number_studies = count(study_date)
 from   studies
 where  study_date > '31-dec-1989' and study_date < '1-jan-1991'
 
 union
 
 select year = 1989, total_number_studies = count(study_date)
 from   studies
 where  study_date > '31-dec-1988' and study_date < '1-jan-1990'
 
 produces a two-line result, with the year, and summary function, in each row. 
 UNION queries have their own behaviour peculiarities, and there are other 
 shortcomings to this method which should be fairly obvious, but it IS a 
 short term-solution to doing it in pure SQL.  
 
 NB: for an ongoing thing, one could use the REPORT WRITER to automatically 
 generate an SQL statement like the one above which would produce no 
 "zero" rows, and would not require the ongoing maintenance.   In *ANY*
 case, long story short is that it *CAN* be done in SQL. 
 
 
 ---------------------------------------
 Tony
 
Newsgroups: comp.databases.ingres
From: nowacki@porsche.net.com ( Michael Nowacki I.T. Database Contractor)
Subject: Re: Snapshots in Ingres ?
Organization: Network Equipment Technologies, Redwood City
Date: Wed, 16 Dec 1992 23:21:02 GMT

In article <1992Dec16.191519.65@ittpub.nl> david@ittpub.nl (David P. Morgan) writes:
>
>Does Ingres have any facility like Snapshots in Rdb ?
>
>Snapshots allow a readonly non-locking user to keep private copies
>of pages which may be modified by locking users. This restores
>consistency to readlock=nolock situations.

no. remember all those files names *.snp ? They were copies of data used in
the snapshot mechanism.

This is one Rdb tool to optimize concurrency, by limiting the lock and i/o
contention incurred by read only transactions.

You can also locate them on disks other than where the table file lives.
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: HELP! SQL (Ingres) problem
Date: 13 Dec 92 17:18:07 GMT
Article-I.D.: gsbacd.1992Dec13.111807.1

In article <1992Dec9.123448.10686@vax.oxford.ac.uk>, mjl@vax.oxford.ac.uk 
writes:
> As far as I can see SQL is not following simple logic here. The first 
> query is , two clauses A and B, which each evaluate to TRUE or FALSE. 
> The number of rows returned by the query 'A OR B' should be AT LEAST as 
> many as the sum of 'those returned by clause A run separately and the 
> number of rows returned by clause B run separately'. This is dictated
> by standard boolean logic.
> 
> As the second and third queries show, this is not the case. The sum of clause 
> A and clause B separately is 3930, but the query A OR B is only 1273.
> 
> Is Ingres giving me incorrect unlogical results or am I missing some 
> Ingres feature.

I may be barking up the wrong tree, but whenever I see weird behavior
like this, I suspect nulls.

Can you supply us with full table definitions ("create table" statements
from the "copydb" utility) and some sample data?

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
Newsgroups: comp.databases.ingres
From: david@ittpub.nl (David P. Morgan)
Newsgroups: comp.databases.ingres
Subject: Snapshots in Ingres ?
Date: 16 Dec 92 19:15:19 WET+0100
Organization: ITT Publitec R+D BV, Amsterdam


Does Ingres have any facility like Snapshots in Rdb ?

Snapshots allow a readonly non-locking user to keep private copies
of pages which may be modified by locking users. This restores
consistency to readlock=nolock situations.

Thanks in advance

--------------------------------------------------------------------------------
David P. Morgan                        Internet: david@ittpub.nl
ITT Publitec R+D BV                    UUCP:     ...!sun4nl!ittpub!david
Amsterdam                              PSI:      020412905761212::DAVID
Newsgroups: comp.databases.ingres
From: gbull@advtech.uswest.com (Gerald Bull)
Subject: Re: Need help with GROUP BY clause
Originator: gbull@scrappy
Organization: U S WEST Advanced Technologies
Date: Fri, 11 Dec 1992 14:07:46 GMT

In article <2953@dwrsun4.UUCP> you write:
>Configuration:
>	INGRES SunOS Version 6.4/02 (su4.u42/00)
>	SunOS 4.1.2
>	SPARCstation 2
>
>I have a table of securities listing the issue date and dollar amount
>of each.  I want to get a subtotal of the value of all of the
>securities in each year.  I've tried this query:
>
>	select
>		year = date_part('year', issue_date),
>		volume = sum(issue_size) / 1000000
>	from abpv_deals
>	group by year
>	order by year desc
>
>but I get the error:
>
>	E_US0836 line 1, Column 'year' not found in any specified table.
>
>It seems that Ingres won't let me put anything but real table columns
>into the GROUP BY clause.  I can do this easily in QUEL with:
>
>	range of d is abpv_deals
>
>	ret(year = date_part("year", d.issue_date),
>		volume = sum(d.issue_size by date_part("year", d.issue_date)))
>	sort by year:d
>
>I really don't want to have a combination of SQL and QUEL code in one
>application.  Is there a way to do this in SQL (without creating views
>or temporary tables)?
>
>Robert Perlberg
>Dean Witter Reynolds Inc., New York
>{murphy | philabs}!dwrsun4!perl
>	-- "I am not a language ... I am a free man!"

In SQL you must include all selected columns in the group by clause.  In this
case it would be the issue_date.  The problem with this is that you need to
group by the year that it was issued, and the only way to make SQL do this is
to either add a column to your table that is the year of the issue_date, or
to create a view or temporary table that does this transformation for you.
Unfortunately, QUEL has this power without going to such drastic measures and
INGRES has not included this functionality with SQL.


-------------------------------------------------------------------------------
Jerry Bull,  MTS			voice: 	  (303) 541-6611
U S WEST Advanced Technologies		fax:   	  (303) 541-6441 
4001 Discovery Drive Suite 390		internet: gbull@advtech.uswest.com
Boulder, CO  80303
-------------------------------------------------------------------------------


Newsgroups: comp.databases.ingres
From: sctconno@kraken.itc.gu.edu.au (Dave Connors)
Subject: Visual programming with Ingres...
Organization: ITC, Griffith University, Brisbane, Australia
Date: 21 Dec 92 01:12:58 GMT

Howdy folks,

I have to write a database system for a friend of mine to do some job
tracking. The sys has to run on a Sun 3/60 - so with ``cheapness'' in mind
we decided to opt for Ingres. 

I got a book out of the library called ``A Guide to Ingres'' (The Relational
Institute and the Codd and Date Consulting Group). It describes a visual 
forms based interface to developing applications in Ingres. After having 
compiled Ingres on this Sun I have not come across this visual interface,
just a daggy CLI. 

Am I missing something? Doesn't Univeristy Ingres have a forms interface?

Any advice would be greatly appreciated.

Thanks for your time.


   Dave Connors - D.Connors@sct.gu.edu.au     Griffith University, Australia
 - -- ---=-==-=================================================-==--=--- -- -
      " Committee:  A group of men who keep minutes and waste hours. "
                               - Milton Berle
 - -- ---=-==-=================================================-==--=--- -- -