HDTenEightyP/NetNews huggingface dataset:
From: joeb@sequent.com (Joe Barger)
Subject: Re: Zip code data base wanted
Keywords: zip code, data base
Organization: Sequent Computer Systems Inc.
Distribution: usa
Date: Thu, 31 Dec 92 21:13:06 GMT

In article <106@timer1.UUCP> john@timer1.UUCP (john) writes:
>Hi, Netter :
>
>Our company is looking for a postal zip code database. We are willing
>to pay for a resonable price for it. It will be better if we can
>get updated if any change is made.
>
>Any pointer will be appreciated.
>
>John Chan

If accurate and up-to-date data is needed (and you are willing to pay
for it), then the US Postal Service is the best source.  Contact:

          National Address Information Center
          6060 Primacy Pkwy, Suite 101
          Memphis, TN 38188-001
          1-800-238-3150

To give you an idea of the prices:

          Product                     Price
	  -------------------------   --------------------------
	  City/State/ZIP file         $350/year  updated monthly
	  Five Digit file             $500/year  updated monthly
	  ZIP+4 file                  $900/year  updated monthly

Available on 9-track tape (1600 or 6250; EBCDIC or ASCII) or CD-Rom.

----
If this is too pricey for you check out:

          Melissa Data Corporation
          32122 Paseo Adelanto
          San Juan Capistrano, CA 92675-3600
          714-661-5885

They have sell several PC based ZIP code software programs with data for
as low as $150.

----
For those interested in Candian Postal Codes, contact:

          Mr. Lee Down
          Address Management
          Station 1036
          Canada Post Corporation
          720 Heron Rd
          Ottawa, ON  K1A 0B1
          CANADA
          613-734-3627


----
Disclaimer:  I in no way benefit from the sale of products mentioned in
	     this post.  I reserve the right to be wrong!
Newsgroups: comp.databases
From: ae2@cunixa.cc.columbia.edu (Amiran Eliashvili)
Subject: benchmarking DBMS tools
Reply-To: ae2@cunixa.cc.columbia.edu (Amiran Eliashvili)
Organization: Columbia University
Date: Wed, 23 Dec 1992 19:30:35 GMT


Hi all,


	I am looking for benchmarks , commercial and none commercial,
for DBMS. I heard that there are some on the net and there are
industry standard, TPC A and TPC B. Does anyone know from where to get
the benchmark -- ftp site, vendor phone and fax number?




					Many Thanks In Advance.

					`Amiran.




Please reply to :

ae2@cunixa.cc.columbia.edu
thanks.
Newsgroups: comp.databases
From: mccon@ssdd475a.erim.org (Joe McConnell)
Subject: Re: Adding text editor to a Paradox Application
In-reply-to: umnoor@ccu.umanitoba.ca's message of Tue, 22 Dec 1992 00:49:11 GMT
Organization: Environmental Research Institute of Michigan, Ann Arbor, Michigan
Date: 23 Dec 92 22:42:16

What is it you want to edit?  If you have a favorite text editor on the
system in question, you can invoke it like this:

    RUN BIG NOREFRESH "<name of your editor> " + <a variable containing
                                                   the name of a file to edit>
--
Joe McConnell  | Opinions expressed are the   | Don't blame me!  I voted for
mccon@erim.org | author's, not the employer's.| Stephen Maturin!
From: mireley@arnou.cem.msu.edu.brewery (John D. Mireley)
Newsgroups: comp.databases
Subject: UNIFY/ACCELL Mailing List
Date: 21 Dec 92 14:39:57 GMT
Reply-To: mireley@arnou.cem.msu.edu.brewery
Organization: Michigan State University Department of Chemistry
NNTP-Posting-Host: arnou.cem.msu.edu

I must have missed it. What was the address for the UNIFY/ACCELL
mailing list.

John Mireley
Dept. of Chemistry
Michigan State Univ.
Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: 500'000 records - who does best?
Organization: MIND LINK! - British Columbia, Canada
Date: Mon, 21 Dec 1992 19:45:03 GMT

500,000 records, averaging 30K *each*. Forget Sybase and Oracle on Suns;
go for a Teradata.

We run Sybase on Suns and RS6000's. We chose Sybase because, within our
domain, they beat Oracle down quite handily (they also didn't try to
fudge the benchmark). We put sales history in tables that typically
reach 400K-800K each, with rows of 100-300 bytes. For mass operations,
this is really pushing the limit; for retrieval of individual rows,
this is okay, but watch out on any "maintenance" operation --- updating
a field in all rows, adding a column, operations that implicitly
require temporary tables, etc. With 30K records, you are dealing
with blobs outside the normal record structure; you can run greater
risks. Working with multiple databases (we tie in to Teradata, DB2 and PC
databases), I offer the humble advice that you never want to run
a system within an order of magnitude of its performance limits,
and what you are suggesting is probably outside the envelope already.

Unless you have some well-defined, permanently restricted requirement
(e.g. you'd be happy to have all your data sit on CD-ROM, and just
do queries), you might well want to see what the big boys have.
--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
From: aahz@netcom.com (Mean Green Dancing Machine)
Newsgroups: comp.databases
Subject: Re: Paradox data for teaching
Keywords: Paradox data teaching
Date: 22 Dec 92 20:37:53 GMT
Organization: Don't blame me, I voted for Bill 'n' Opus

In article <1h68auINNi8t@uniwa.uwa.edu.au> crandolp@ec.uwa.oz.au (Cherry Randolph - mgmt_staff) writes:
>It would be much more meaningful and useful if we could present them with a    
>substantial database and ask them to perform operations on the data. (Instead
>of asking them to design and build a database and make up some data, in  which
>case they never get to work on a database of any size).
>Does anyone out there have a simple design - but logically sound - of around
>3 to 6 tables and 1000+ records in at least one table, that they are willing
>to donate to a good cause?

Why not just use the tables in the SAMPLE directory, and add additional
data if you need it?
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

Virtual anniversary: 9 days and counting
Newsgroups: comp.databases
From: pindar@uxmail.ust.hk (Wong Pindar)
Subject: Who's Who?
Organization: Hong Kong University of Science and Technology
Date: Mon, 21 Dec 1992 10:55:24 GMT




I'm sure you may have wondered just who are the 'key' people in each
of the major database areas and why are they considered 'key'? (
I deliberately leave the definition of 'key' up to *you* )

Now each of us probably have an idea on who we think are 'key' and
why - this will undoubtedly differ from person to person.

One possible definition of 'key' is an author of a article/book that
has been cited again and again. (eg. Ullman )

I would like to create a ranked list of "frequency of being cited" (
most cited to least cited ) of such authors and see what the resulting
list looks like.

Q:"Do you know if such a list already exists and where I can get a
copy of it?" 
		
Any suggestions? (Please reply by e-mail)

Thanks in advance!

Pindar

PS: I have asked a similar question in comp.software-eng for those who 
-- 
Pindar Wong                      |   The Hong Kong University of     | 
Internet: pindar@uxmail.ust.hk   |     Science and Technology        |
Phone:    (852) 358-7023         |  Department of Computer Science   |
Newsgroups: comp.databases
From: jeb@fig.citib.com (James E. Bergman)
Subject: Paradox Engine and Visual Basic
Originator: jeb@vulture
Reply-To: ibism!jeb
Organization: Citibank IBISM
Date: Mon, 28 Dec 1992 14:39:55 GMT


Hi. Happy holidays to everyone.

Has anyone out there tried the paradox engine calls PXRawPut and PXRawGet with Visual Basic. Are there any "tricks" in getting it to work. I seem to have a problem with the N (number) type fields.

Thank you.
Newsgroups: comp.databases
From: danny@pinet.aip.org (dan_eikenberry)
Subject: Re: Zip code data base wanted
Keywords: zip code, data base
Organization: American Institute of Physics
Distribution: usa
Date: Thu, 31 Dec 92 13:59:07 GMT

In article <106@timer1.UUCP> john@timer1.UUCP (john) writes:
>Our company is looking for a postal zip code database. We are willing
>to pay for a resonable price for it. It will be better if we can
>get updated if any change is made.
>John Chan

Well I don't have a name/address of where to get one, but I do know of
one.
There is a PC based packed (it might be called zipkey, but don't quote
me
on that).  From what I remember of it, you can look up by zipcode or
by town name or partial town name, etc..  It seemed quite complete.
I believe that the author offers yearly updates.  You can probably
find this program in any relatively large Public Domain/Shareware
catalog
and order a trial copy of it.  Paying the registration fee (very
reasonable
from what I remember) will of course get you the latest version of the
data files.   Hope this helps.


Dan
Newsgroups: comp.databases
From: brent@terminus.gatech.edu (Brent Laminack)
Subject: Re: 500'000 records - who does best?
Organization: Georgia Tech College of Computing
Date: Thu, 31 Dec 1992 01:45:47 GMT


>I believe that this thread started out as a "can anyone do this REASONABLY"

>UNIFY 2000 can handle this (500K rows @ 30K per row). If you have the disk space,
>we have the database. :-)

>Mischa is right... its not the users, it's the size of the database. The
>UNIFY 2000 database package can have individual table segments in the 16+Mb
>category, allowing over 500 rows per segment, so the table would only require
>10000 segments.

Is this the same Unify company that tells me to try to keep all tables
to 16 or fewer segments? After that performance is said to degrade? If
memory serves, 10000 >>> 16

>You would still have plenty of room for indices and the rest.

>Performance is impossible to judge without getting your hands a little dirty.
>It depends on hardware, access patterns, indexing strategies, and a whole lot
>more, but in general UNIFY 2000 is very hard to beat in the performance area.

There are other considerations, however. Ask Unify to do an outer join.
They can't.

No brag, just facts.

Brent Laminack (brent@cc.gatech.edu)


					
					-Brent Laminack (brent@cc.gatech.edu)
Newsgroups: comp.databases
From: jjfink@skcla.monsanto.com
Subject: XMas Wish List
Organization: Searle, Skokie, IL
Date: Tue, 22 Dec 1992 09:31:36 GMT

Database Wishlist
-----------------
All I want for Christmas is most of these features available at the same time.
I'm rating the criticality from 1 (it'd be nice) to 10 (absolute must)

1) Multiplatform compatability (8)
   I need to be able to create identical applications for
	MS Windows 3.1 (10)
	Macintosh (8)
	DOS (5)
	VAX/VMS dumb terminal (7)
	X-Windows (4)

   Lets add something fun:  For Mac, Win31 and DOS, the application must
   be portable, so that it can run on a single-user machine (9).

2) 4GL-level of power.  Even if a 3GL (or xBase-like) is generated, I don't
   want to worry about the fact that a screen field generates what part of
   a dynamic SQL statement (9).  Once I paint a screen, and indicate which
   fields are which, I shouldn't have to worry myself over commit phase
   coding either.

3) Subforms, not spreadsheets! (9)
   There are a few database systems (Approach, Paradox, Helix Express) which
   permit a repeating subform to be placed onto another form, to show several
   lines of data about each record in a one-to-many relationship.  A
   spreadsheet interface makes it easier to compare one record to another, but
   it is not always possible to show all data at once, or there may be a
   120-character description field for each record.

4) Reports that permit one-to-many-of-these-and-many-of-those relationships (8)
   In a clinical trial for new drug development, there are events tied to
   a patient visit, such as a physician's assessment, lab tests, examination,
   etc.  There are also 'asynchronous' events, such as side effects, other
   medications taken, etc.  It is nearly impossible in most systems to produce
   a report which has several subsections for each of these relations under
   each patient.

5) Object orientation (5).  A full ODBMS would be nice (or, at least
   interesting), but I'd settle for a database with a data dictionary with
   entity definitions that can be defined in one place and used in several
   (such as patient ID's, severity codes, etc. etc.), and understand the
   links between records, not just tables to be linked at my convenience.

6) A Pocket Guide I can fit in my Christmas stocking (8).  I do much of my
   development at home on a company laptop, I adjust things in demos on the
   road, and a high-quality pocket guide that's not unwieldy is awfully nice.

Hairy Wristwatch!!!

A Cool Yule, Dudes!!!

Joel
-- 
jjfink@skcla.monsanto.com
------------------------------------------------------------------------------
"I want peace on earth, and goodwill towards man."
"We don't do that kind of thing, we're the United States Government!"
  -- from _Sneakers_
Newsgroups: comp.databases
From: gboersma@sce.carleton.ca (Gerald Boersma)
Subject: Paradox 4.0 for DOS : New Features?
Keywords: Paradox, upgrade
Organization: Carleton University
Date: Tue, 29 Dec 1992 19:43:37 GMT

I currently have Paradox 3.5 and am considering upgrading to 4.0. I
have some major complaints with 3.5, and I am wondering if they are
fixed in Version 4.0. I would *greatly* appreciate any comments by
anyone who took the plunge, especially since here in Canada, the
distribution of 4.0 is so poor that I cannot even see the box before I
upgrade.

1. Although the fact that the user interface is slightly outdated for
3.5, with no mouse support, I will not upgrade if the only change in
4.0 is a mouse driven user-interface. Is this the case?

2. I find the design of forms, ESPECIALLY the way form functionality
is programmed, to be extremely clumsy in 3.5. The requirement that the
data entry toolkit has to be used drives me bananas. Is this still the
case in 4.0, or is the programming of forms much cleaner? Is it true
that it is OO?

3. Can C or PASCAL now be interfaced to PAL? (I doubt it, but it's
worth asking!)

4. Is PDOX 4.0 noticably faster?

5. What type of functions have been added to the PAL language?

THanks in advance for any advice. Post all replies to the net.

Gerald Boersma
------------------------------------------------------------------
Computer Systems Engineering	@sce.carleton.ca
Carleton University
Ottawa, Ontario
Canada 
------------------------------------------------------------------
From: klooster@mswe.dnet.ms.philips.nl
Newsgroups: comp.databases
Subject: SuperBase for Windows
Date: 22 Dec 92 06:56:38 GMT
Organization: Philips Medical Systems Nederland

I heard something about a new version of SuperBase for windows.
Are there people who have seen or worked with it? I would like
to have some more information. My most important questions are:
1) is it fast, compared for example with Clipper or Foxpro?
2) does it contain a good language, is it suited for developers
   or mostly for end-users?
3) can you link it with C programs?

All information is welcome.

Thank you very much,

Richard van der Klooster
Newsgroups: comp.databases
From: nigelc@cognos.com (Nigel Campbell)
Subject: ibCS2 compliant databases
Organization: Cognos Incorporated, Ottawa CANADA
Date: Thu, 24 Dec 1992 17:49:14 GMT


Which database managers are compliant with the Intel
Binary Compliance Standard ibCS2 ? As of which rev
of the software ? Thanks.
-- 
Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
Database and Connectivity MCI: nigel campbell || 307-4729 Ottawa, Ontario
UUnet: nigelc@cognos.COM                                  CANADA  K1G 3Z4
Newsgroups: comp.databases
From: paulr@bts.com (Paul Raulerson)
Subject: Re: Progress DBMS?? Info..
Organization: Bux Technical Services -- Doylestown, PA
Date: Mon, 21 Dec 1992 20:13:36 GMT

In article <1h3ug9INNco1@lester.appstate.edu> jvs@lester.appstate.edu (John V. Scalco) writes:
>
>	greetings,
>
>	Does anyone know what Progress DBMS is...what platform it
>	runs under, what it is like  etc.
>
>	appreciate any info you could provide.
>
>	please mail directly to me.......ahhhh you can post it if you
>	want to  ifyou want, I read this newsgroup all the time..
>
>	sincerely --- jvs
>	



Progress runs under just about any UNIX, DOS, BTOS, and bunches of 
other systems (including A/UX on Macintoshes). It is a very nice database,
with a beautiful 4GL and full SQL dialects. 

It has wonderful transaction capabilities, and a very good crash recovery
system. In most respects, it is quite comparable to Oracle.

-Paul
From: kavuri@hecto.cs.umn.edu (Sakuntala Kavuri)
Subject: Data mining??!
Keywords: Gigantic databases
Organization: University of Minnesota
Distribution: usa
Date: Tue, 22 Dec 1992 01:23:37 GMT


	Could someone throw some pinters to me as to
	what is "Data mining" in terabyte databases?

	Sakuntala.

Newsgroups: comp.databases.theory,comp.databases,de.comp.databases,uk.databases,aus.databases,eunet.misc
Newsgroups: comp.databases.theory,comp.databases
Date: Tue, 22 Dec 92 4:08:32 EST
From: Zhe Li <li@cs.columbia.edu>
Subject: Products Supporting Hashed Joins


Hi there:

I was wondering whether any commercial database system products actually
support hashed joins. If they do, what kind of hashed functions are widely
adopted? (Simple ones such as (Val mod K) or more complicated ones?) Is
order-preserving hashed function ever used in a DBMS implementation?

Any info./pointers/implementation experiences related to the above questions
are appreciated.

--lee
li@cs.columbia.edu (pls email)
Newsgroups: comp.databases.theory,comp.databases,de.comp.databases,uk.databases,aus.databases,eunet.misc
From: dzik@access.digex.com (Joseph Dzikiewicz)
Newsgroups: comp.databases.theory
Subject: formal semantics for data languages/models
Date: 1 Jan 1993 03:12:31 GMT
Organization: Express Access Online Communications, Greenbelt, MD USA
NNTP-Posting-Host: access.digex.com

I am looking for approaches to formally specifying the semantics of
an object oriented data model and of the associated data and query
languages.  The traditional methods of specifying semantics of
programming languages (denotational and axiomatic) seem more geared 
toward procedural languages.  Does anyone out there have any ideas
or pointers?

Newsgroups: comp.databases.theory
From: yab@cs.brown.edu (Yashesh Bhatia)
Subject: Data abstraction v/s information hiding
Organization: Brown Computer Science Dept.
Date: Tue, 22 Dec 1992 18:22:20 GMT




I was curious to know the differences between the 2 terms commonly used in the
fields of databases and software engineering. 

Data Abstraction & information hiding

Data abstraction, I feel is the hiding of the low level implentation of the 
data structure from the operations that are performed on it. 

I am not really sure as to what information hiding is, seems to be similar. 

Could someone let me know if there are dufferences between these two terms 
and if so what are the pro's and cons of using one for the other in the 
world of databeses and s/w eng.



thanks

-- 
- Yashesh Bhatia yab@cs.brown.edu
From: tener@cs.widener.edu (Stuart Tener)
Newsgroups: comp.databases
Subject: public domain unix databases
Date: 25 Dec 92 20:42:46 GMT
Organization: Widener University Department of Computer Science, Chester PA
NNTP-Posting-Host: pebbles.cs.widener.edu

Does anyone know of any public domain databases available for unix?
Just wondering if gnu had a relation 4GL or something like that.

thank you,

stuart
tener@cs.widener.edu
(215)-338-6005
From: nba2325@dsacng1.dsac.dla.mil (Cynthia Manring)
Newsgroups: dla.software,dod.uug,dod.3b2,dla.database,comp.databases
Subject: Regression Testing
Date: 31 Dec 92 17:49:35 GMT
Followup-To: poster
Organization: Defense Logistics Service Center, Battle Creek, MI


I am interested in any products that could be used to perform 
regression testing on both Unix - System V and Unify 2000.  We are
interested in creating keystroke files to enter on to a Unix system,
go through scripts that set parameters, and go into a Unify 2000 database
to test applications and produce output.  Does anybody have any ideas?
Thanks in advance for any information.


			

-- 
Cynthia Manring         PHONE:  +1616-961-5115   AV: 932-5115
Defense Systems Automation Center, Battle Creek, Mi.
dsacng1.dsac.dla.mil
From: john@timer1.UUCP (john)
Newsgroups: comp.databases
Subject: Zip code data base wanted
Keywords: zip code, data base
Date: 29 Dec 92 16:38:56 GMT
Distribution: usa
Organization: Rightime Econometrics, Inc., The Forst Pavilion, Wyncote, PA 19095-1596

Hi, Netter :

Our company is looking for a postal zip code database. We are willing
to pay for a resonable price for it. It will be better if we can
get updated if any change is made.

Any pointer will be appreciated.

John Chan
Newsgroups: comp.databases
From: nigelc@cognos.com (Nigel Campbell)
Subject: PIONEER + InterBase
Organization: Cognos Incorporated, Ottawa CANADA
Date: Mon, 21 Dec 1992 23:34:55 GMT

I am looking for an Inet address for someone at PIONEER
SOFTWARE to discuss their pending InterBase support - 
the same could be said of other companies planning
an InterBase interface (or have one).
 
thanks.

-- 
Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
Database and Connectivity MCI: nigel campbell || 307-4729 Ottawa, Ontario
UUnet: nigelc@cognos.COM                                  CANADA  K1G 3Z4
Newsgroups: comp.databases
Subject: <None>
From: ballpe@cbr2
Date: 24 Dec 92 12:58:07 GMT
Followup-To: comp.databases

In article <1720@tekgen.bv.tek.com>, robertj@tekgen.bv.tek.com (Robert Jaquiss) writes:
> 
>      I am looking for a database package that has Mac and
> IBM-PCversions.  I am working with a church group.  In order to
> maximize the available talent pool,I would like to be able to do
> development on either platform.  Idon't care whether the user
> interface is the same just as long asthe files move easily from one
> system to another.  Any informationwould be appreciated.  Thank
> you.
>      Robert Jaquiss
> 
> 
> Internet: robertj@tekgen.bv.tek.com

Robert,

I tried preparing a reply but I think it got lost. Mailing isn't working for me.
I'll make this one shorter.

Two choices are available to you, IMHO. Omnis 7 and Foxbase+ for the Mac.

Omnis 7 is a formidable development environment according to all reviews.
Highly recommended, with versions for Mac and Windows. Pricing is also
formidable (though not for larger companies, I'm sure). About AUS$1500 to
AUS$1900 depending where you shop. Runtimes are likewise expensive and so is
support. This ruled it out for me.

Foxbase+ also rates very highly (see comparative review of 5 packages in
Australian MacUser about two issues ago). It rated about 4 and 1/2 mice out of
5, from memory. Pricing is reasonable: about AUS$570 to $650 with the same
amount for unlimited runtime licence. Portable to IBM (Foxpro) and uses xBase
standard language and file formats. This is the one I chose for private use.

Good luck in choosing.

Merry Christmas!

Peter Ball
Information Services
Dept of Health, Housing and Community Services
Brisbane, QLD, Australia
"The views expressed above are my own and my employer wants nothing to do with
them!"

Newsgroups: comp.databases