HDTenEightyP/NetNews huggingface dataset:
From: gsipe@pyrtech.pyramid.com (George M. Sipe)
Newsgroups: comp.databases,comp.sources.wanted
Subject: seeking unencumbered, simple, keyed data manager
Summary: looking for unencumbered data manager
Keywords: ISAM
Date: 16 Apr 92 17:28:30 GMT
Article-I.D.: pyramid.181102
Reply-To: gsipe@pyramid.com (George M. Sipe)
Organization: Pyramid Technology Corp., Mountain View, CA

Many times I find myself with a need for a simple data manager.
Usually I use dbm(3) or one of its clones.  Does anyone know
of anything better which is unencumbered (i.e. public domain or
free-use-without-restriction copyright)?

Generally, something along the lines of:
	o  basic ISAM record access
	o  suitable for up to maybe 100k records
...would be terrific.

Not necessary, but potentially useful:
	o  variable length data records
	o  key compression (leading component)
	o  multiple index (more than one key) capability
	o  any type of concurrency

Do you know of anything which fits this profile (I checked with archie
and didn't find anything)?
Is this something many people would like to have?
Are my only choices to do it myself or use encumbered code?

Your thoughts on this topic would be appreciated.
From: richardj@uhunix.uhcc.Hawaii.Edu (Richard Jablonka)
Newsgroups: comp.databases
Subject: Ingres Phone Number
Date: 6 Apr 92 23:37:21 GMT
Article-I.D.: news.1992Apr6.233721.727
Organization: University of Hawaii at Manoa

I am determining what database prodcut to buy. I have a Vax 6310
running VMS, I have 60 macs, and I have 25 pcs. I plan to have the Vax
as the server. I have heard good things about Ingres, additionally I
have heard taht Informix doesn't have a VMS server.  I will be having
databases which may contain pictures. Can someone compare and contrast
the leading databases available and make reccommendations.
Additionally can you comment on ease of developing and porting
applications over the three platforms.

PS: Does anyone have the number for Ingres and Oracle and Informix
sales depts.  

                 Thanks for your help.....
                   richardj@uhunix
From: cy@dbase.a-t.com (Cy Shuster)
Newsgroups: comp.databases
Subject: Re: dBASE IV v1.5: any news?
Date: 10 Apr 92 00:01:58 GMT
Organization: Borland
Originator: cy@genghis

In article <1992Apr3.161923.1@kean.ucs.mun.ca> roger@kean.ucs.mun.ca writes:
>	What is the latest information on dBASE IV  version 1.5?
>Has it been released?   What are its features (compared to 1.1)?
>What does the upgrade cost?

dBASE IV 1.5 began shipping within the last month. New features include
40 work areas; editable multifile forms; mouse support (without any
changes to .PRGs); automatically optimized queries; an "Open Architecture
Control Center": you can define procedures to be called whenever certain
Control Center functions are executed, so you can customize it;
low-level file I/O; improved BLANK support; SET KEY TO range, which 
dramatically increases performance over SET FILTER or INDEX FOR;
linking on calculated fields; and the installer now automatically
detects extended or expanded memory, and installs the disk cache
when appropriate. And, we've improved performance.

Upgrade prices vary, but are generally $99: call 800-331-0877 (or
408-438-8400 from overseas) for exact details. There is no longer
a separate Developer's Edition: the template compiler is now part
of dBASE IV, and RunTime is a separately purchased product. There
is a special upgrade available to prior owners of the D.E.

--Cy--
DISCLAIMER: Sr. Developer, Borland: I worked on it.
cy@genghis.a-t.com
Newsgroups: comp.databases
From: cedr132@hermes.chpc.utexas.edu (Ta-Yin Hu)
Subject: RDBMS in UNIX system
Keywords: RDBMS, UNIX
Organization: The University of Texas System - CHPC
Date: Wed, 8 Apr 92 22:32:36 GMT


Hi :

   I am looking for a suitable relational data base management system
   on UNIX environment, and I have no idea about any RDBMS on UNIX.

   Could someone can point out where to find some references about
   this issue.

   Thank You !!



Newsgroups: comp.databases
From: mattw@picasso.cssc-syd.tansu.oz.au (Matthew Watson)
Subject: Re: oodb
Organization: Telecom Australia
Date: Tue, 7 Apr 92 22:54:15 GMT

bemlbk@nuscc.nus.sg (Liew Beng Keat (Mr)) writes:

>Can anyone provide me with a list of oodb's currently available in the
>market e.g oodb, company, address, price etc. In particular any info on
>GEMSTONE. Thanks!

Form an old posting...

Here's a list of vendors that I have. It hasn't been updated for  
several months so I'm sure there are new vendors to be added.

Object-Oriented Database Vendors:

Itasca Systems
2850 Metro Drive
Suite 300
Minneapolis, MN  55425
Phone: 612-851-3158

Object Design
1 New England Executive Park
Burlington, MA  01803
Phone: 617-270-9797

Objectivity
800 El Camino Real
Fourth Floor
Menlo Park, CA  94025
Phone: 415-688-8000

Ontologic
Three Burlington Woods
Burlington, MA  01803
Phone: 617-272-7110

Servio Corporation
1420 Harbor Bay Parkway
Suite 100
Alameda, CA  94501
Phone: 415-748-6200

Versant Technology
4500 Bohannon Drive
Menlo Park, CA  94025
Phone: 415-325-2300


For information on standardization activities contact:

Object Management Group
Framingham Corporate Center
492 Old Connecticut Path
Framingham, MA  01701
Phone: 508-820-4300



This is  probrably out of date...
-------------------------------------------------------------------------------
     -  Matthew Watson -  	   | MHSnet: mattw@cssc-syd.tansu.oz.au
     Australian and Overseas	   |
  Telecommunications Corporation   | Snail : 9th Floor, 320 Pitt Street
         Network Services	   |        Sydney, Australia 2000.
  Customised Software Solutions    |  or 115 Mitchell Rd Alexandria 2015.
From: hgork@iesd.auc.dk (Birgitte Krogh)
Newsgroups: comp.databases
Subject: Re: T-SQL ?
Date: 31 Mar 92 16:16:21 GMT
	<890179s.701876689@aucs>
Organization: Mathematics and Computer Science, University of Aalborg

>>>>> On 29 Mar 92 13:44:49 GMT, 890179s@aucs.acadiau.ca (Michael Smith) said:
Michael> rvinluan@cs.cornell.edu (Rolando Vinluan) writes:
.
.
.
>Now, what's a temporal database anyway? 

Michael> A temporal database (from what I've read which isn't much is a
Michael> database that involves the additional field of time , kind of turning
Michael> the database from 2 to 3 dimensions with time being the additional
Michael> dimension.

... and quite possibly with 2 time dimensions (`valid time' and
`transaction time') making the whole thing 4 dimensional and thus
conceptually more difficult to handle (and more interesting and useful
as well, of course). Want references?

'gork
--
 
 ######################################################################### 
 #                                   #                                   #
 #                             /     #  "Hvorfor er det lyst, naar       #
 #   /                        /      #   solen skinner? Og hvorfor       #
 #   '  / __   / __   / ___, / _     #   er det moerkt, naar der er      #
 #     /   /  /   /  /      /   '    #   TV-avis?"                       #
 #    /___   /_____ /_     /_  |_    #                                   #
 #       /                           #                fra brev til       #
 #   ____,                           #                  `Spoerg Olivia'  #
 #                                   #                                   #
 #########################################################################
From: osa379p@vaxc.cc.monash.edu.au
Newsgroups: comp.databases
Subject: Bad performance of S1032 version 8 Value command
Date: 15 Apr 92 11:16:31 GMT
Organization: Computer Centre, Monash University, Australia

Database: version 8 of S1032, we cannot upgrade in the near future.  Running on
a microvax 3800.

We have a dataset containing around 140,000 records.  The dataset has three
variables, VAR1 Text 16 keyed, VAR2 Integer keyed range 1:21001231, var3 text
50.  The problem is when we try to VALUE VAR1.  For example

S1032> FIND VAR1 A
16 records found
S1032> VALUE VAR1
A   (16)
S1032>

The values command uses around 45 seconds real time, 20 seconds CPU, and 1500
I/O operations!  We tried raising $BUF_NUMBER and $CLUSTER_LIMIT but that did
not change the resources needed.  We used the account we run backups on, with
its' large process quotas, but no change.  The statistics from "monitor disk",
"sh dev d/ful" and "sh proc/acc" indicates the majority of the I/O's are direct
not buffered.  (the account that logged on, went into 1032, opened the database
then executed the command twice had 165 buffered and 3157 direct I/O's since
login)

Is there any remedy for this problem?  Are their some variables, like
$BUF_NUMBER we can change to make the operation less expensive? A VALUE VAR2
took around 140 I/O's and less than 2 seconds, so is this just a problem with
text variables?

Another point is that a FIND LAST command is more expensive, at least while we
have a large number of users.  FIND VAR1 A B C took less time than a FIND NOT
ALL, FIND LAST OR VAR1 A B C, when there were a large number of users, but not
noticeably during our out of hours testing.  Is there some sort of common work
space buffer and, if so, how can we make it bigger?

If there is enough interest I will post a summary of the replies.


Geoff Sinclair

Internet: GSINCLAIR@vaxc.cc.monash.edu.au
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases
Subject: How To Obtain Write Prevent Locks (Row Level) in Oracle v 6 ?
Date: 8 Apr 92 22:37:55 GMT
Reply-To: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Organization: Microprocessor Component Group, Intel Corp., Santa Clara, CA

I would like to know if there is anyway of obtaining write prevent locks.
My problem is as follows -

time	User 1.						User No 6.

t1	locks row no 3 in table t1.			
					No update allowed until user 1 lock
t2					is released.

t3	Now user 2 must be able to lock
	the SAME row 3 in table t1.

t4					No update allowed until user 1 & 2 BOTH
					release their locks.


To summarise How Do I allow multiple users to put some kind of lock on same row
which will prevent other user from updating the row if any of the locks exists.

I guess this is called write prevent lock .

I use Oracle 6.0.33 with TPO on Unix 5.4 
 
Any help will be apreciated.

Aniruddha Kortikar (kortikar@mipos2.intel.com)
From: gold@ilp.mit.edu
Newsgroups: comp.databases
Subject: Seeking Scheduling Software
Date: 10 Apr 92 05:36:52 GMT
Article-I.D.: ilp.1992Apr10.003652.1
Organization: MIT Industrial Liaison Program

I am interested in obtaining "scheduling" database software for a 
small community college.  The "scheduling" database is to be used to 
schedule classes for the college.  The database software must be 
MSDOS compatible.  It also must be able to help schedule daily 
classes by tracking:
                        Teacher Availability
                        Required Courses
                        Classroom Space Availibility
                        Groups of Students by
                            Graduation Date (we have
                            one group starting every
                            1-1/2 months -- nine/year)

Preferably, the database should be written in something like dbase or 
Paradox or some other popular PC database package, although we would 
look at others too.  We would like to either purchase the source code 
with the software or the software must allow some customization.

IF ANYONE KNOWS of any companies that sell scheduling databases for 
schools (or hospitals), PLEASE let me know the company's name and 
phone so I can contact them for more information.

Thank you inadvance for your assistance.
		 - Mark Gold
		GOLD@ILP.MIT.EDU
From: jja@amy (Joseph Alotta)
Newsgroups: comp.databases
Subject: Re: Sybase Mailing List
Keywords: sybase
Date: 8 Apr 92 20:07:50 GMT
Organization: First National Bank Of Chicago, Chicago IL, USA

In article <WFINNERT.92Apr2190629@larry.shearson.com>  
wfinnert@larry.shearson.com (Warren Finnerty) writes:
> 
> >   Could we perhaps set up a comp.databases.sybase in a similar fashion  
to the
> >   oracle and informix groups??
> 
> >   Melinda Fox 
> 
I would also want to be included in a Sybase group.

--
Joe Alotta
First Chicago Corp.
jja@fnbc.com
(312)732-3439

"Wisdom is better than gold and understanding more valuable than silver."
From: rick@rick.cs.man.ac.uk (Rick Dipper)
Newsgroups: comp.databases.oracle
Subject: Re: Moving data from Ingres -> Oracle ??
Date: 7 Apr 92 10:07:41 GMT
Reply-To: rick@uk.ac.man.cs
Organization: University of Manchester, Dept. Computer Science

In article <50614@seismo.CSS.GOV>, cooper@beno.CSS.GOV (Dale Cooper) writes:
|> In article <1992Apr3.104852.9555@covax.commerce.uq.oz.au> bellamy@covax.commerce.uq.oz.au writes:
|> >
|> >We have the need to convert data from a colleague's Ingres database to a
|> >database using Oracle.  The database is fairly large (about 500Mb) so
|> >an efficient method would be appreciated (although any will do :-)).  This is
|> >likely to be an annual effort.  Do either Oracle or Ingres provide tools for
|> >this (the Oracle manuals which we have make no mention of Ingres).
|> 

Can I suggest you look at Sybase, as this can communicate with both Ingres
and Oracle.
-- 
RICK DIPPER, Unix Systems Administrator                       rick@uk.ac.man.cs
Department of Computer Science, University of Manchester           061-275-5725
.............................Meemberrr the of Fumblee Ingers Culb..............
Newsgroups: comp.databases.oracle
From: dmichell@cbnewsk.cb.att.com (donald.a.michelli)
Subject: calculating business days (help)
Organization: AT&T
Distribution: att
Date: Wed, 8 Apr 1992 14:16:43 GMT

Does anyone have a function or method to determine the number of business
days when given a start date and an ending date?

Replies to :attmail!psds!michelli or michelli@psds.att.com
Newsgroups: comp.databases.oracle
From: lvc@cbnews.cb.att.com (Larry Cipriani)
Subject: Re: How to avoid appending matching records ?
Organization: Ideology Busters, Inc.
Distribution: usa
Date: Thu, 16 Apr 1992 13:45:25 GMT
Keywords: inserts

In article <1992Apr16.011759.6548@cbnews.cb.att.com>, lvc@cbnews.cb.att.com (Larry Cipriani) writes:
> I have two tables A and B which share a common schema.
> In that schema I have 60 fields, f1, f2, ... f60.
> 
> Basically, I want to append A - B to A, but I want the

Oops, that should say, B - A not A - B.

> difference to operate only on two fields f1, and f2.  From
> what I can tell, 'MINUS' operates on entire records.
> 
> Or ...
> 
> If I have a unique index i_a on fields f1 and f2 of A and
> then insert all of B into A the whole insert will fail if
> there is one record from B that matches an indexed record
> in A.  Is there a way to make sqlplus keep going and ignore
> the duplicate indexes errors ?  That is, inserts on other
> records should succeed but the duplicates should be thrown
> away ?
-- 
Larry Cipriani, att!cbvox1!lvc or lvc@cbvox1.att.com
"Be wary of strong drink.  It can make you shoot
at tax collectors - and miss." -- Lazarus Long
From: swhite@fncduc (Stephen White)
Newsgroups: comp.databases.oracle
Subject: Table space Usage
Summary: How do I obtain the current bytes/blocks of one or more tables?
Date: 16 Apr 92 20:08:23 GMT

In order to allocate space properly I need a way to determine the amount of     bytes and blocks used by each table in the DB.  Can anyone give me a query whichreturns this data?

Oh yeah, I'm using version 6.0.33.1.1.


-------------------------------------------------------------------------------

Stephen P. White		| 
Computing Division              |     [This space intentionally left blank]
Fermilab			|

-------------------------------------------------------------------------------
From: sondereg@forty2.physik.unizh.ch (Markus Sonderegger)
Newsgroups: comp.databases.oracle
Subject: How to suppress form feeds in SQL*REPORTWRITER?
Keywords: REPORTWRITER
Date: 8 Apr 92 11:15:03 GMT
Organization: Physics Institute University Zuerich, Switzerland

How to avoid Formfeeds <FF> and the two leading empty lines in an ASCII-file
created by Oracle REPORTWRITER?

Thanks for your suggestions!


-- 
Markus Sonderegger                      sondereg@physik.unizh.ch
Swiss Federal Institute for 
Forest, Snow and Landscape Research     Tel.: +41-1-7392-497
Switzerland
From: kcameron@erc.cat.syr.edu (Ken Cameron)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*ReportWriter Question
Keywords: continuous forms
Date: 9 Apr 92 03:00:48 GMT
Article-I.D.: newstand.1992Apr8.230048.6026
Organization: Electronic Resource Center; Syracuse, NY

In article <1992Apr3.170458.1803@pencom.com> dae@pencom.com writes:
>Anybody out there in net-land know how to tell the report writer to NOT
> put out a formfeed?  
I found that creating a bunch of printer types was needed. I have a bunch.
Just tell it your size and the init and trail sequences. Like define the
formfeed as being null.

-- 
-ken cameron. SkyDiver: Zoo-602, A-8596, D-11839. Skier.
Employer: Computer Task Group.  /cny UNIX Users Group Director.
Disclamer: "I said it, when I said it, so what! Now is different!"
Internet: kcameron@erc.cat.syr.edu
Newsgroups: comp.databases.oracle
From: lwv26@cas.org (Larry W. Virden)
Subject: SQL Forms 3.0 and the Copy/Name_in procedure/functions
Reply-To: lwv26@cas.org (Larry W. Virden)
Organization: Nedriv Software and Shoe Shiners, Uninc.
Date: Tue, 14 Apr 1992 15:16:55 GMT

I have a series of blocks in a form which have the same field names within
each.

I would like to write a procedure which, when given the name of a block
as an argument, would perform some action on the fields in that block.

What I am trying to do is something like:

procedure tst_cp (blk in char) is
begin
   copy(':' || name_in(blk) || '.par_id', :global.par_id);
end ;


and then I want to call this procedure as:

tst_cp('junk');

so that :junk.par_id is copyed into the global variable par_id.

The problem is that when I get to the copy statement, I get an Undefined
field or variable reference error from Sql Forms 3.0 .

Anyone have any ideas on what I might be doing wrong here?

I tried changing the above to :

procedure tst_cp is
begin
	copy(':" || name_in(:global.blk) || '.par_id', :global.par_id);
end;

and then

:global.blk := 'junk';
tst_cp;

and got the same results.


-- 
Larry W. Virden			UUCP: osu-cis!chemabs!lvirden
Same Mbox: BITNET: lwv26@cas    INET: lvirden@cas.org
Personal: 674 Falls Place,   Reynoldsburg,OH 43068-1614
America Online: lvirden
Newsgroups: comp.databases.oracle
From: waider@glas.rtsg.mot.com (Ronan Waide)
Subject: Re: Help with compiling XWindows-to-C-to-Oracle
Organization: Motorola Ireland Ltd., Cork, Ireland.
Date: Thu, 16 Apr 1992 08:03:01 GMT

bergstro@src.honeywell.com (Pete Bergstrom) writes:


>Can you give more information on what Oracle doesn't like?  What do
>you mean by its "access section"?

>I've been writing a lot of embedded SQL in the last six months and
>there shouldn't be anything different between what you're doing and
>what my stuff does.

>Pete

Well, it's like this:

[declarations etc]
main()
[more C]

[embedded SQL to access a database]

[more C]


will compil okay, but if I change main() to readDataBase(), and leave out _any_
main() procedure (which obviously makes it 'not a program' :-) ) it gives some
linker errors along the lines of 'undefined : _pcisyn' and about 6 or 7 others.
Okay. So then I make a second file with my main() in it and a call to readData
Base stuck inside it. I use the compiler to compile & stick the whole lot
together, and run the executable. BOOM! Core dumped, illegal instruction.

Help?



--
Ronan Waide, Motorola Ireland Ltd.
From: heijink@pttrnl.nl (Heijink R.J.)
Newsgroups: comp.databases.oracle
Subject: Re: What is PL/SQL?
Date: 8 Apr 92 06:37:10 GMT
Organization: PTT Research

bengsig@dk.oracle.com (Bjorn Engsig) writes:

>|PL/SQL is part of SQL*Forms 3.
>No, not really.  PL/SQL is a procedural extension to SQL with a pascal
>like syntax.  It is a separate product that can be included in both
>SQL*Forms 3 and in the Oracle kernel.  In the former case, it means that
>a large number of calculations often done in triggers can be performed
>locally, so the oracle kernel is only consulted for true SQL operations.
>PL/SQL may also be used from other product like SQL*Plus and the precompilers.

What really interests me is, is PL/SQL a "private" development from Oracle, or is it an
international standard? Do other database suppliers provide similar products?

The same question applies to the PRO* interfaces to 3rd generation languages.

Rudolf J. Heijink


--
Rudolf J. Heijink               phone : +31 70 332 5709
PTT Research POB 421            fax   : +31 70 332 6477
2260 AK  Leidchsendam  E-Mail: R.J.Heijink@research.ptt.nl (internet)
Netherlands                     ...!hp4nl!dnlunx!heijink (UUCP)
From: ccvern@uqvax.cc.uq.oz.au (Vern Bawden  Prentice Centre  UQ)
Newsgroups: comp.databases.oracle
Subject: Space left in database (V6)
Date: 16 Apr 92 18:30:16 AEST
Organization: University Of Queensland

Has anyone written an SQL*Plus script which will tell you how much
space is still available for user objects in a given database (or
tablespace? If this is documented please point me at the manual.
How do you monitor the need to enlarge the database (add more files
etc)?

We are running ORACLE V6.0.30 under VAX/VMS.

Thanks for any help.  

   Cheers,
  ..Vern..

----------------------------------------------------------------------------
 Vern Bawden  Prentice Centre  The University of Queensland  4072 AUSTRALIA
     v.bawden@cc.uq.edu.au  phone: +61 7 365 4168  fax: +61 7 365 4477
From: bengsig@dk.oracle.com (Bjorn Engsig)
Newsgroups: comp.databases.oracle
Subject: Re: What is PL/SQL?
Date: 7 Apr 92 09:29:16 GMT
Reply-To: bengsig@dk.oracle.com (Bjorn Engsig)
Organization: Oracle Denmark

In article <1992Mar27.174137.5277@fmsrl7.srl.ford.com> hugh@slee06.srl.ford.com (Hugh Fader) writes:
|>I have some literature from Oracle which describes a product called
|>PL/SQL. [what is it?]
|
Article <1992Apr3.115047.9048@jyu.fi> by hkau@jyu.fi (Harri J Kaukovuo) says:
|PL/SQL is part of SQL*Forms 3.
No, not really.  PL/SQL is a procedural extension to SQL with a pascal
like syntax.  It is a separate product that can be included in both
SQL*Forms 3 and in the Oracle kernel.  In the former case, it means that
a large number of calculations often done in triggers can be performed
locally, so the oracle kernel is only consulted for true SQL operations.
PL/SQL may also be used from other product like SQL*Plus and the precompilers.
--
Disclaimer:  Although I work for ORACLE, I am sending this only in my technical
	     interest to help fellow Netlanders.  I am not involved in sales
	     or any customer support.  All opinions expressed above are my own.
-- 
Bjorn Engsig    -    ORACLE Corporation.             | Editor of FAQ-list
Internet: bengsig@oracle.com, uunet!oracle!bengsig   | for comp.unix.aix
Private : bjorn@login.dkuug.dk.
Newsgroups: comp.databases.oracle
From: fragante@unixg.ubc.ca (Gv Fragante)
Subject: Changing the WHERE/ORDER BY clause in SQL*FORMS
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Tue, 14 Apr 1992 00:02:09 GMT

First of all, I'd like to inform everyone that my previous problem with the
:SYSTEM.LAST_QUERY variable has been fixed by Oracle with an update disk for
SQL*FORMS and SQL*MENU.

My question now is, has anyone used the pound (#) operator to dynamically
change the default WHERE/ORDER BY clause of FORMS ? There are examples given
in the documentation "Advanced SQL*FORMS technique", but I cannot understand 
how it works.

Thanks for any feedback on the matter.