HDTenEightyP/NetNews huggingface dataset:
From: clark@netcom.com (Sue Clark)
Subject: Re: good database program
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Distribution: comp
Date: Sun, 4 Oct 1992 07:37:48 GMT

frank.rosenbaum@execnet.com (frank rosenbaum) writes:

>A3>z    Subject: Good Database program : any suggestions ?

>A3>I am responsible of keeping a registration database of a convention.
>A3>There are about 600 people in the convention. So, need a database
>A3>program that will let me store addresses, phone numbers, etc.
>A3>Something like FileMaker Pro. But I do not have FileMaker Pro. So, if
>A3>anyone have a suggestion, please mail then to me. I will be using IBM
>A3>compatible and I prefer windows software. And if possible, please put
>A3>down some shareware/public domain/ stuff too. Thanks.

>A3>-Azmi Hashim
>Azmi,  you might look at Approach for Windows.  It can be a very colorful
>program that is easy to set up and run.  I think it is around $150.00 or so
>and is well worth it.  I keep "Train Meet" information in two different
>databases, one for our vendors and one for our customers.  I set these up 
>in Q&A originaly, but we have been shifting as many of our applications
>over to Windows as we can.

>If you have further questions please feel free to ask, I love to brag(G)


> ^   ^
> 0   0
>   (
> \-/

>               Frank in White Plains, NY
>---
> ~ DeLuxe} 1.25 #1000 ~ Gotta go the baby is pulling on the plu{}(*&^$
>--
>Executive Network Information System  (914) 667-4567
>International ILink Host

I agree with Frank. I think you'll see that Approach is what FileMaker
should have been.  I've heard they'll have promos with version 2.0, due
to be out sometime this month.  Contact the company at 1-800-APPROACH.

Sue
-- 
-----------------
Sue Clark
clark@netcom.com
From: dang@njmsa.umdnj.edu (Anju Dang)
Newsgroups: comp.databases
Subject: Paradox 4.0 is SLOWER !! (Why)
Date: 6 Oct 92 02:02:34 GMT
Distribution: comp

Hi folks,

I have recently been involved in upgrading an application onto the
new version of Paradox (4.0).  To avoid recoding I am using the
compatible interface for the time being.  All intial tests are showing
that my application run appx 15% faster when running under Paradox 3.5.

The only changes that I have made are: 
     1. restructure all the tables.  &
     2. Add Setuidmode Compatible to my startup script.

If anybody has shared my experience or knows what I am doing wrong  - PLEASE 
let me know.  I was so eager to get the 10 times improvement in performance
as my upgrade notice had said.   FOLKS FROM BORLAND SHOULD NOTICE THIS.... 



Mukesh Dang

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| internet:   dang@umdnj.edu  | If you are not a part of the solution then    |
| compuserve: 74040,1643      |         you are a part of the problem         |
| genie:      xty72787        |                                               |
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Newsgroups: comp.databases,comp.binaries.ibm.pc.wanted
From: salomon@seas.gwu.edu (Alicia Lee Salomon)
Subject: Re: About SQL for PC
Organization: George Washington University
Date: Sat, 26 Sep 1992 13:14:29 GMT

>There is a package called SSQL, made by Steve Silva. It was built for
>teaching SQL, so I think it suites you. You can find SSQL from file
>ssql23.zip in simtel20.army.mil, directory PD1:<MSDOS.DATABASES>. As usual,
>look it from your local simtel20 mirror first.
>
This should be SSQL23.ZIP.1 in directory pd1:<msdos.database>


-- 
| Machines take me by surprise with  |     A. Lee Salomon
| great frequency.    - Alan Turing  |     salomon@seas.gwu.edu
From: adhir@cygnus.umd.ed (imn_)
Newsgroups: comp.databases
Subject: Looking for a good front end app
Date: 22 Sep 92 04:01:16 GMT
Organization: /etc/organization


Hello all.  I have been assigned the task of writing a front end (basically
input) system for an inventory database for our computer science department.
Presently, we are looking at Objectvision to do it, but I was wondering if
the net.wisdom could recommend a better package with which I could
set up as simple a system as possible.  That is, where non-computer-types
have to do as little as possible to enter the data.  I want things like
selecting from lists for items, automatic input generation from previous
inputs, etc.  I was wondering if a package to help me write such a
system exists for DOS?  Then we wouldn'tt be tied to machines capable of
running Windows effectively (read "fast") to do the input.  Also,
Objectvision seems somewhat limiting in a number of ways.  I have designed
most of it in O.V. already and have run into numerous pitfalls in terms of
things O.V. just can't do.  How about other packages for Windows that
are better...I have heard of things like Approach, and Actor...and somone
even recommended Visual Basic.  What do you all think?  I'd [refer to use
a DOS based system, but haven't found anything like what I need...


--
 ============================================================================
 Al Dhir                      			   Technical Consulting Staff
 Internet: adhir@cygnus.umd.edu	  	 University of Maryland, College Park
 Bitnet:   adhir%cygnus.umd.edu@Interbit      (301) 405-1500 * (301) 405-3014
Newsgroups: comp.databases
From: ejh@khonshu.colorado.edu (Edward J. Hartnett)
Subject: any good (cheap) databases available for the sun (i.e. unix)?
Organization: CIRES, University of Colorado
Date: 6 Oct 92 15:58:03

Hi! I don't read this group, and maybe this is only for PC-type
people, but I need a database on my Sun IPC. Money is not freely
available to pay for it, and my needs are quite simple - I just need
to keep a database of a tape library, print out labels, etc. Can
anyone offer any suggestions? Please email me since I usually don't
read this group. Thanks.
--
Edward Hartnett			ejh@khonshu.colorado.edu
From: alan@edstar.ucsb.edu (Alan Moses)
Newsgroups: comp.databases
Subject: Re: Paradox 4:Which version? Windows/DOS?
Date: 29 Sep 92 13:16:49 GMT
Organization: UCSB Graduate School of Education

In <Bv56Cr.7GH@borland.com> cy@borland.com (Cy Shuster) responds
to the question in the subject iine:

>That's easy: Paradox for Windows is not yet available. Go ahead with
>Paradox 4 for DOS ... and then take a look at the upgrade
>offers to the Windows version when it comes out. 

Since I'm facing the same decision, I must point out a problem,
which is to what extent an application developed on the DOS
version is portable to the Windows version. I asked Borland tech
support about this **and data file compatibility**, and their
reply was that they don't comment on unreleased products.
Although I would be surprised if there were data file problems,
the question still remains whether using the DOS version now
means writing the application twice. I've decided to wait, which
I know is a luxury that not all share.

- Alan

Alan Moses
Graduate School of Education		alan@edstar.gse.ucsb.edu
UC Santa Barbara   			UCSB PROFS: AMOSES 
Santa Barbara, CA 93106-9490  		Voice: (805) 893-8031
Xref: sparky comp.databases:7066 comp.databases.ingres:1522 comp.databases.informix:2102
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Newsgroups: comp.databases,comp.databases.ingres,comp.databases.informix
Subject: Re: QUEL query language
Date: 4 Oct 92 17:12:00 GMT
Distribution: na
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
News-Software: VAX/VMS VNEWS 1.4-b1

In article <1992Oct3.182845.12304@dcatlas.dot.gov>, sethg@dcatlas.dot.gov (Seth Grimes) writes...
>norton@csd4.csd.uwm.edu (Glenn A Norton) writes:
> 
>>  Are there any QUEL references available on the network, or any books availableon the subject?
> 
>Do you mean Ingres QUEL or Postgres QUEL?  What are you looking for beyond
>manuals, if you mean Ingres?  For either, you can probably find copies of
>research papers.
> 
>Seth Grimes, dcatlas!sethg@uunet.uu.net

Research papers?!  Just the thing somebody starting out wants to hear!

I do know that C.J. Date has a very readable book out on Ingres QUEL.  I
believe it's just called "Ingres".

Bill Thompson
From: chad@src.umd.edu (R Michael McMahon)
Newsgroups: comp.databases
Subject: PC Dbase(?) application devel. suggestions
Date: 27 Sep 92 19:19:25 GMT
Reply-To: chad@src.umd.edu (R Michael McMahon)
Organization: College of Engineering, Maryversity of Uniland, College Park

I'm working on a PC database application to track various engineering projects.
I am an experienced C++/Unix/X-Windows programmer, and need some advice on the
right software tools to do this job on a PC.

First off, I feel very limited by the "command" language built into a package
like Dbase IV: the interpreted runtime policy is a big turn-off, and the lack 
of good graphical support (no mouse, no buttons, limited srolling lists, etc)
as found in X-Windows Widget sets. While I can use Dbase IV to define file 
structures and make command line querries, I don't see the point in using 
Dbase IV once past the development stage.

I prefer NOT to go with MS Windows as a graphical shell. Are there any developers
packages to provide a good DOS graphical interface (mouse, scrolling lists, etc)
and a C/C++ library into Dbase files? 

Any opinions will be appreciated.

Mike McMahon	chad@src.umd.edu
From: fhd@panix.com (Frank Deutschmann)
Newsgroups: comp.databases
Subject: Re: RDB vs. OODB: Designing a queue
Date: 2 Oct 92 19:46:14 GMT
Organization: PANIX Public Access Unix & Internet, NYC

In article <1ahv74INNjfr@agate.berkeley.edu> mao@triplerock.CS.Berkeley.EDU (Mike Olson) writes:
	i've stated before, and want to reiterate, that this is NOT a problem
	with the relational model.  if you have an extensible system, then you
	can write code to manage a queue with high-concurrency locking.  bielat
	succeeded in doing so in his oodb because he could write the queue data
	type himself, *not* because he had inheritance, message-passing, and
	polymorphic functions.
	
						mike olson
						project sequoia 2000
						uc berkeley
						mao@cs.berkeley.edu

In fact, not only aren't OO features required, but extensible database
features are not required either. I know, because we implemented just
such a queueing system on top of Sybase using nothing more than C. The
key is to provide a central lock manager process, which grants clients
locks on fields, records, and/or tables, as well as assigns uniqiue
ID's for records. This strategy can be made sufficiently robust to
support any degree of concurrency...our system supports over 150 users
in three countries (using three databases, slaved together[NOT
multi-phase commit], but that's another story) for a real-time trading
system.

Stored proceedues and the like are not required, but they may make
life easier...


-- 
-frank
(fhd@panix.com)
Newsgroups: comp.databases
From: andersen@reality (Robert Andersen)
Subject: Re: Sybase DB-library problems
Organization: Encompass
Date: Thu, 1 Oct 1992 19:05:23 GMT

In article <1992Oct1.163121.16881@sunova.ssc.gov> chow@slug.ssc.gov (Ivan Chow)  
writes:
> The error I get is always:
> 
> DB-Library error:
>         Attempt to initiate a new SQL Server operation with results pending.
> dbsqlsend failed  <-- my own debug statement.
> 
> Is there any way to solve this kind of problems?
> Thanks for any info.

The problem you're having is that you're not reading in all of the results from  
the non select statements you are using.  When you are processing results you  
need to set up a loop to continue until all results are read in.  You can  
always issue the cancel command to clear the buffer, but that's a hack and you  
should really do it the other way.  If you look in the Sybase manuals it shows  
an example, I don't have a copy of the manual but I think its under  
dbresults().
--
Robert John Andersen           
(919) 380-6523 (v,w)
andersen%reality@glv.com - NeXT mail!

Outside of a dog, a book is man's best friend.
Inside of a dog it's too dark to read.
Newsgroups: comp.databases
From: jamesc@genghis.borland.com (James Chuang )
Subject: Re: We need dBaseIV help!
Originator: jamesc@genghis.borland.com
Organization: Borland International
Date: Wed, 30 Sep 1992 04:46:38 GMT

dBase IV ver 1.5 supports mouse.  There is no SET MOUSE ON command,  all
you need is to load the mouse driver before starting dbase.

If I understand your second question correctly, you want to have some date
like:

	01/01/**

dbase will not allow the storage of such dates into the date field.  YOu may
want to consider using a character field, properly formatted and validated,
for your purpose.

jamesc

-- 
If someone asks if you are a god, you say YES!
Newsgroups: comp.databases
From: chanhc@iscs.nus.sg
Subject: Re: Simple? SQL query??
Reply-To: CHANHC@NUSDISCS.BITNET
Organization: Dept. of Information Systems and Computer Science, National University of Singapore
Date: Sat, 26 Sep 1992 01:22:25 GMT

I don't think there's anything in "normal" SQL that can give
that sort of result. SQL fills up every field in every row of
the result.
From: "rick menaul" <rick.menaul@channel1.com>
Newsgroups: comp.databases
Subject: hosp. census database
Date: 1 Oct 92 23:38:47 EST
Reply-To: "rick menaul" <rick.menaul@channel1.com>
Distribution: comp
Organization: Channel 1 Communications

I would like to know how to acquire the Hospital Census Database.

I believe it can be accessed through IQuest on CompuServe, but
where can I get my own copy on disk?

                             -= Rick Menaul =-
                                Boston, Massachusetts
              Internet address: rick.menaul@channel1.com
---
  DeLuxe 1.20 #5318  
--
Channel 1 (R)   Cambridge, MA

Newsgroups: comp.databases
From: dmarble@magnus.acs.ohio-state.edu (Duane F Marble)
Subject: Re: CfP: The VLDB Journal: Special Issue on Spatial Database Systems
Organization: The Ohio State University
Date: Fri, 2 Oct 1992 11:59:13 GMT

It is interesting that the list of suggested topics does not include
anything on the design of these databases. Good design is critical if
efficiency is to be attained in the use of the spatial database.
-- 
Duane F. Marble			       E-mail: dmarble@magnus.acs.osu.edu
Department of Geography                Telephone: (614) 292-2250
The Ohio State University
Columbus, Ohio 43210                   Fax: (614) 292-6213
Newsgroups: comp.databases.oracle
Subject: How to gracefully kill background tasks
From: suskind@bbs.mdcbbs.com
Date: 30 Sep 92 08:26:46 GMT
Organization: E-SYSTEMS
Nntp-Posting-User: suskind

When you use the Oracle PIPE driver and your foreground process running
IAP or SQLPLUS aborts due to the user terminating his connection to the
system, the background ORACLE shadow process exits gracefully.

The same is not true when running the FAST driver. These background
tasks just sit there and consume shared memory and other resources.

Another system administrator has created a script that will look for 
these processes and kill them. This process also releases the shared
memory segments and semaphores that were allocated.

I was told by a person fairly familar with ORACLE that it was very bad to
kill these background tasks as you can lock out portions of the database
because ORACLE was not given the chance to release temporary space used
when building queries. 

Given all of this:

1. How DO I kill these jobs?
2. Is the point of locking out portions of the database just rubbish?

+---------------------------------------------------------------------+
Barry A. Suskind                  Internet:   suskind%edoras@mdcbbs.com
MaBell: 703-560-5000x2348             UUCP: uunet!mdcbbs!edoras!suskind
E-Systems / Melpar Division 7700 Arlington Blvd, Falls Church, VA 22046
JSNM                                             Just Stark Naked Magic
From: jared.hecker@factory.com (Jared Hecker) 
Newsgroups: comp.databases.oracle
Subject: Re: SQL*ReportWriter ord
Date: 28 Sep 92 22:14:00 GMT
Distribution: world
Organization: Invention Factory's BBS - New York City, NY - 212-274-1243v.32bis
Reply-To: jared.hecker@factory.com (Jared Hecker) 

TO: andy@homebase.vistachrome.com (Andy Finkenstadt)
AF> Subject: Re: SQL*ReportWriter order by clause (PLEASE HELP)

AF> 1: "select lname, fname from master order by FNAME"

Andy, the reason this takes so long is that you are using a full table 
scan.  Oracle will only use an index if you are selecting at least the 
first column.  You need a second index here, by fname.

AF> 2: "select lname, fname from master order by lname"

This will work fast under any scenario because you are using the 
index! - though if the table were small and took < 5 blocks it wouild 
be faster without one...

AF> 3: but in Reportwriter the same "select" is SLO-O-O-W.
AF> 

It sounds like Reportwriter may not have enough sort space, and so
must do several 'intermediate runs'.  Check out your temporary 
segemnts area.

hth

jh
---
 . RoseReader 1.70 G002691
                                                  
Newsgroups: comp.databases.oracle
From: janis@solbourne.com (Janis Griffin)
Subject: Re: Sql-Loader
Organization: Solbourne Computer, Inc.
Date: Wed, 30 Sep 1992 18:33:19 GMT



I have been successful in loading negative numbers with sqlloader.
However, my script looks like your script except that the negative sign
goes in front of the number.

For example, table temp has a column 'COL1' defined as a number(10,2).

My control file looks like:

load data
into table temp
        (col1 position (01:10) decimal external,
         col4 position (31:41) date)

The datafile looks like: 
			
-1111111111-DEC-92
  44.444412-AUG-92


Jan Griffin, DBA
Solbourne Computers
303-678-4331
Newsgroups: comp.databases.oracle
From: rwm26@cas.org (Ron McCamish)
Subject: pro*c 1.4?
Keywords: pro*c
Reply-To: rwm26@cas.org
Organization: Chemical Abstracts Service
Date: Wed, 30 Sep 1992 19:20:01 GMT

  Is anyone running Pro*C 1.4?  If so, on what platform and how long?  
  
  thanks, ron....

---
Ron McCamish
BITNET: rwm26@cas.bitnet
UUCP:   ...!osu-cis!chemabs!rwm26
INET:   rwm26@cas.org

Newsgroups: comp.databases.oracle
From: xili@seas.smu.edu (Xi Li)
Subject: Oracle for MOTOROLA machine
Organization: School of Engineering and Applied Science
Distribution: usa
Date: Thu, 1 Oct 1992 19:59:05 GMT



We are considering to buy a RDBMS for our MOTOROLA delta series with
UNIX operating system.  We are wondering if Oracle can
run on this machine.  Can somebody help?  

Any suggestion or advice is welcome to email us at xili@seas.smu.edu.


Xref: sparky comp.databases.oracle:1757 comp.databases.theory:511
From: marti@nugget.inf.ethz.ch (Robert Marti)
Newsgroups: comp.databases.oracle,comp.databases.theory
Subject: Re: Oracle Optimizer Questions.
Date: 5 Oct 92 21:28:46 GMT
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH

In article <1ahve6INNjgv@agate.berkeley.edu>, mao@triplerock.CS.Berkeley.EDU
(Mike Olson) writes:
|> the oracle version 6 optimizer doesn't use cost analysis.  oracle does
|> "semantic" query optimization, which is to say, it executes joins in
|> the order in which you write them, and will use an index if one happens
|> to be around.  it doesn't reorder the query in any way.
|> 
|> i believe that version 7 provides cost-based optimization.

I guess you wanted to say that the Oracle V6 optimizer is a _syntactic_
optimizer.  From what I understand, it does not take the actual
distribution of the data into account as some of the cost-based
("statistical") optimizers do.

Most people use the term semantic query optimizer to mean that some of
the semantics of the database is taken into account when optimizing
queries.  Unfortunately, "semantics" is a somewhat fuzzy term.  One
example of semantic query optimization is to use (semantic) integrity
constraints in order to "simplify" given queries.  Simplification in
this case means the following:  given a database consisting of (1) a
set of facts, (2) a set of deduction rules, and (3) a (nonempty!) set
of integrity constraints, and given a query Q, find a query Q' which
is cheaper to evaluate than Q and returns the same result as Q,
provided that all integrity constraints are satisfied.  (A simple
example is the following:  assume you have a constraint which says
that all oil tankers weigh more than 10 tons and assume that you
want a list of all oil tankers which weigh less than 8 tons.  Then
it is obvious that if the constraint is satisfied you will get an
empty list as an answer, provided that the constraint is not violated.)

I do not know of any commercial systems which perform this kind
of semantic query optimization.  (Indeed, I do not know a commercial
system which allows the specification of purely declarative integrity
constraints which go beyond what Codd has termed entity integrity and
referential integrity.)

Papers on semantic query optimization are J.J. Kings 1981 (?)
VLDB paper on his QUIST system and Chakravarthy's paper in Minker's
"Foundations of Logic Programming and Deductive Databases".
(Sorry, I don't have the references handy at the moment.)

-- 
Robert Marti                    |  Phone:    +41 1 254 72 60
Informationssysteme             |  FAX:      +41 1 262 39 73
ETH-Zentrum                     |  E-Mail:   marti@inf.ethz.ch
CH-8092 Zurich, Switzerland     |
From: simon.rear@almac.co.uk
Newsgroups: comp.databases.oracle
Subject: storage parameters
Date: 1 Oct 92 12:00:16 GMT
Distribution: comp
Organization: ALMAC BBS Ltd

Hi all,

I'm using oracle v6 for netware. While busily calculating the storage
parameters for my first oracle system and creating the tables I noticed
something strange perhaps some of you oracle guru's could explain ??

Within the system there are a couple of very small static tables which will
hold at most 30 or 40 records, hence the storage parameters are small ie

CREATE TABLE CATEGORY
 (CATEGORY_REF  CHAR(2) NOT NULL,
  CATEGORY_DESC CHAR(15))
 STORAGE (INITIAL      4096
          NEXT         4096
          MINEXTENTS   1
          MAXEXTENTS   1
          PCTINCREASE  0)

After creating the table and querying USER_EXTENTS I find that the above table
actually occupies 8192 bytes not 4096 ie 2 oracle blocks ?!?!

The remaining larger tables size is expected, as per the create table
statement.

I also confirmed that the oracle block size for the database was 4096 with the
sqldba show parameters command.

Not a major problem I admit, but I'd like to know why this happens....

Any ideas?

Simon.Rear@Almac.co.uk
---
 ~ OLX 2.1 TD ~ Thesaurus: Ancient reptile with excellent vocabulary
--
ALMAC BBS Ltd. 0324-665371
Dos based USENET access,  call for details!
From: curt@emory.edu (Curt Stauffer)
Newsgroups: comp.databases.oracle
Subject: Selecting Oracle - Would you do it again?
Date: 6 Oct 92 13:12:49 GMT
Organization: Emory University

Emory University is looking for a UNIX database as part of a right-
sizing initiative. We would like to know what tools you are using to
develop applications to use with Oracle. What has your experience
been with this database and these tools? If you were going to choose a
UNIX database today, would you buy Oracle again? Why or why not?

Please reply to the following e-mail address rather than posting a
followup article.

Thank you in advance,
Curt
--
Curt Stauffer
Emory University Information Systems
Atlanta, GA
curt@emoryu1 (Bitnet)
curt@emory.edu (Internet)