HDTenEightyP/NetNews huggingface dataset:
From: exuptr@exu.ericsson.se (Patrick Taylor)
Newsgroups: comp.databases
Subject: Re: Gupta Client Server
Date: 28 Sep 92 18:53:06 GMT
Organization: Ericsson Network Systems, Inc.
X-Disclaimer: This article was posted by a user at Ericsson in North America.
              The opinions expressed are strictly those of the user and
              not necessarily those of Ericsson.

In article <1992Sep28.153447.29746@zip.eecs.umich.edu> srawson@quip.eecs.umich.edu (Stephen Rawson) writes:

>We have just purchased Gupta's Novell NetWare NLM of SQLBase.  The
>software has not arrived yet, but should be here soon.  I have been
>evaluating a Single-user version of the product and the associated
>tools (SQL Windows, Quest, also PowerBuilder).  So far I am impressed
>with the stability of the product, but am by no means an expert.

>I would be interested in seeing a newsgroup devoted to Gupta and other
>client/server databases on the net, especially the Netware NLM-based
>ones (Gupta, Oracle, Sybase SQL Server, and MS SQL Server).  Gupta
>also runs on the Sun, while the other DBs mentioned above are much
>more multi-platform compatible.

>There is a good review of C/S databases for novell in the 9/15/92
>PC Magazine.  Gupta SQLBase gets high marks for technology and value.


Yes, well let me tell you that you are in for a bit of a ride in the 
technical support department.  They claim to be revamping the system, but 
they have been no less than offensive and useless on many occasions.

On the other hand, the SQL Windows 3.1.3 version works fairly well 
considering the maturity of the "OS".  Have you heard if they are doing 
anything for NT?

>                  Steve Rawson
>srawson@quip.eecs.umich.edu
>srawson@beach.utmb.edu
 ----------------------------------------------------------------------------
    "This must be Thursday.  I never could get the hang of Thursdays"
                                                       - Douglas Adams
  - Patrick Taylor                                       (Arthur Dent)
    Ericsson Network Systems
    exuptr@exu.ericsson.se                       "Don't let the .se fool you"
    or exuptr@ZGNews.Lonestar.Org, exu.exuptr@memo.ericsson.se
From: imn_ <Timothy Finin <finin@algol.cs.>
Date: Thu, 17 Sep 1992 19:43:16 GMT
Subject: CIKM-92  - Sept 25 deadline for early reg
Newsgroups: comp.databases
Organization:  Computer Science, University of Maryland Baltimore County


	       C A L L    F O R    P A R T I C I P A T I O N
				
				  CIKM-92
		     First International Conference on
		    INFORMATION AND KNOWLEDGE MANAGEMENT
				
			   November 8 - 11, 1992
		       Radisson Lord Baltimore Hotel
			  Baltimore, Maryland, USA
				
	   ***** deadline for early registration is 9/25/92 *****
				
CIKM-92 will provide an international forum for the presentation and
discussion of research on the management of information and knowledge.
The scope of the conference will cover the integration database
technology, knowledge representation and reasoning, information retrieval,
and techniques for locating and accessing relevant data and knowledge in
very large, distributed information systems.

The conference will include 18 invited talks, 68 submitted papers, 24 poster
presentations, panel sessions and tutorials. The keynote address will be by
Gio Wiederhold (DARPA/Stanford) on "Intelligent Integration of Diverse
Information Sources".  Other invited speakers include Maria Zemenkova (NSF),
Amit Sheth (Bellcore), Judea Pearl (UCLA), Peter Buneman (Pennsylvania),
Doug Terry (Xerox Parc), Bob Robbins (Johns Hopkins), Joan Sullivan (NIST),
Bharat Bhargava (Purdue), David Waltz (Thinking Machines/Brandeis), Len
Gallagher (NIST), Ahmed Elmagarmid (Purdue), Richard Soley (Object
Management Group), Larry Reeker (IDA), Bruce Blum (Johns Hopkins), and
Il-Yeol Song (Drexel).

For additional electronic information, send email to CIKM-INFO@CS.UMBC.EDU
to receive an automatic reply containing registration forms and a draft of
the advance program.  To receive a copy of the advance program or for
detailed information on registration, contact: Maryann Sullivan, ISMM, Six
Forks Road, Raleigh NC 27615 USA, voice: 919-847-3747, fax: 919-676-0666.

CIKM-92 is sponsored by ISMM and the University of Maryland Baltimore County
and held in cooperation with AAAI, IEEE, and ACM (SIGART and SIGIR).






Newsgroups: comp.databases
From: t_abraham@uimrl7.mrl.uiuc.edu ()
Subject: Wither my query?
Reply-To: t_abraham@ta1.cs.uiuc.edu
Organization: Dept. CS - UIUC
Date: Wed, 7 Oct 1992 02:11:47 GMT
Keywords: SQL, query


I am currently working on a paper concerning the process of handling SQL
queries.
I am seeking suggestions for sources for the paper. 

I would like to trace the query from the time it is entered by the user
until the result
is returned.  It would be good for purposes of uniformity to use the
same dialect, platform,
etc. for the whole procedure, but not entirely necessary. Information on
query parsing,
analysis, optimization, as well as interaction with the OS and other
concerns would be
the type of stuff I could use. 

I know this information is available in excruciating detail from 3 inch
thick textbooks and the
like, but this is only a 15-20 page paper, not a PhD thesis.  

Do any software developers make any of this kind of information
available - ie. not the
source code, just an idea of what is going on.

Any help on this 'self-inflicted' effort  is sincerly appreciated!

Regards,

Thomas W. Abraham

tabraham@ta1.cs.uiuc.edu

Newsgroups: comp.databases
From: kd1hz@anomaly.sbs.risc.net (Michael P. Deignan)
Subject: Re: Foxbase decompiler?
Organization: The Rhode Island Internet Systems Cooperative Network
Date: Thu, 01 Oct 1992 22:17:04 GMT

paul@csir.co.za (Paul Nash) writes:

>Foxbase seems to compile to a slightly tokenised form, which then goes
>through a run-time interpreter.  If this _is_ the case, it should not
>be too difficult to build a Foxbase de-compiler.  Before I start on this
>(to salvage a databane system where the source got badly trashed), I
>would like to know whether anyone else has done this. 

HilCo Software (no address/# available) has Foxbase decompilers available.
They range in price up to a couple hundred dollars. Work excellent, too!

MD
-- 
--  Michael P. Deignan                      / Sex is hereditary. If your 
--  Domain: mpd@anomaly.sbs.com            /  parents never had it, chances 
--    UUCP: ...!uunet!rayssd!anomaly!mpd  /   are you won't either...
-- Telebit: +1 401 455 0347              /
Newsgroups: comp.databases

Greetings,

I'm looking for access to GIS map data from the NET.  Anyone know what
newsgroup or who can supply? At present, I have no limitations re format. 

Also, I'd like to establish contact with others involved in GIS applications    
and related disciplines.

        email is arlie@hpsade2.sad.hp.com
        phone is (707) 794-3243

Here's hoping...

Regards,
Arlie
Newsgroups: comp.databases
From: richieb@bony1.bony.com (Richard Bielak)
Subject: Re: Object-Oriented DBMS's
Keywords: Object-Oriented,Database,Experience
Organization: multi-cellular
Date: Mon, 28 Sep 92 18:16:27 GMT


In article <1992Sep16.055623.23272@actrix.gen.nz> Des.Kenny@bbs.actrix.gen.nz writes:
>I am looking for any experience that people have had with OODBMS 
>systems. 
>
>Do you know of any projects using OODBMS systems?
> 

Yes. We're using Versant to build a pilot message switching system.
The data base will hold messages and queues.

[...]
>
>What advantages are able to be demonstrated?
>

The main advantage of using an OODBMS is that we can solve the
problem. We tried to implement a queue using a relational table,
but it  didn't work. 

>What problems are being encountered? Are the solutions
>to such problems likely in the near future?
>

We've run into interesting locking problems. But that's mostly due to
the fact that we are trying to build structures that can be
concurrently accessed by many programs.


>Is a general OO data model demonstrated by anyone yet?
>I have heard there are some questions about nested objects that
>may be difficult to search with an OOSQL type of language.
>

When programming with an OODB your programming language is also the
data base language (in our case its Eiffel). There is no need for a
separate query language to access the database.

Also, it's not clear to me that SQL-style retrieval language is
appropriate for OODB. There were some papers on that presented at
TOOLS USA '92.


>Do we really need nested objects? 
>

What are "nested objects"?

>I have not seen much discussion on OODBMS systems on the net.
>
>It seems like it may be worth considering if such systems are
>ready for real applications on a large scale. 
>

I think you'll find that the commercially available OODB system are
still fairly immature. Their state is a similar to RDBMS-es 10 years
ago.

OODB, as it exists today, might not be good enough to handle huge
database running on a mainframe, but it will do fine with small
databases distributed in a network of workstations.

...richie



-- 
* Richie Bielak   (212)-815-3072   |                                          *
* Internet:       richieb@bony.com | Rule #1: Don't sweat the small stuff.    *
* Bang {uupsi,uunet}!bony1!richieb | Rule #2: It's all small stuff.           *
*    - Strictly my opinions -      |                                          *
Newsgroups: comp.databases
From: dent@DIALix.oz.au (Andrew Dent)
Subject: Re: perspective in objects
Organization: DIALix Services, Perth, Western Australia
Date: Mon, 28 Sep 92 03:46:32 GMT

In <1992Sep25.170435.55462@qut.edu.au> bub@qut.edu.au writes:

>different purpose.  But actually they are the same in "data". Does we need some
>physical->mind->show convertion models or other kind of model to describe
>perspective insight? If we need, what is its fundamentalform?

In some ways this discussion belongs in comp.object.

However, it's good to bring it out into the database community - a lot of
the users of this group seem to be heavily into 4GL's like Clipper, Fox, 
Clarion etc.

Often these products, and their tutorials, seem to teach a "single view of
data approach", much as you are commenting.

With objects (and conventional records) there's no need to show all the
information at once - that's why a lot of database products have "views"
that can be defined to collate a number of related files.

The packaging of object-oriented technology means that the code for the view
can be incorporated within the object itself. Another (more common?) approach
is to have cooperative objects - Browsers and Viewers/Editors have a set of
messages with which they communicate with a data object.

The VERY nice thing about object oriented technology is that it lends itself
easily to extension or modification of the data model - the messages that old
Browsers etc. use can still be supported - without compromising existing code.

For the past two years I've been working (on and off) on a real estate
magazine printing program. The types of ads and their relationships have 
changed radically over time but the use of OOP has localized the impact of
that change.

Well, that's my 1.45 cents worth (Exchange rate).

>I like to write a report about this, I hope I can mention your name in my
>reports.
feel free

Andy Dent (A.D. Software - Mac & VAX programming)
94 Bermuda Dve, BALLAJURA  Western Australia  6066
Phone/Fax: 09 249 2719 (local)  +619 249 2719 (International)
       Internet: dent@DIALix.oz.au    Compuserve: 100033,3241
From: morgan@unix.SRI.COM (Morgan Kaufmann)
Newsgroups: comp.databases
Subject: Announcement of New Book on Database Transaction Models
Keywords: transaction processing, book
Date: 2 Oct 92 23:06:32 GMT
Organization: SRI International, Menlo Park, CA




          Morgan Kaufmann announces the publication of

                   DATABASE TRANSACTION MODELS
                    For Advanced Applications

                            edited by

                       Ahmed K. Elmagarmid
                       (Purdue University)


This book is the first collection of important new techniques in
transaction processing. It contains an introduction to traditional
transaction technology, and comprehensive descriptions of
commercial systems and research projects. It offers the reader a
broad survey of the role of transaction of the role of transaction
processing in current advanced computer applications. This volume
will help anyone interested in keeping up with new database
applications and the potential for transaction processing systems
to address the needs of OLTP, CAD, CASE, computer aided publishing,
heterogeneous databases, active databases, communications, systems
and other areas. For researchers, managers, software developers,
professionals in the data processing fields, or anyone interested
in a coherent overview of this new and fast growing area of
computer science.


                        Table of Contents

Foreword
     Jim Gray

Preface

Acknowledgments

 1 Transaction Management In Database Systems

 2 Introduction To Advanced Transaction Models

 3 A Cooperative Transaction Model for Design Database

 4 A Flexible Framework For Transaction Management In Engineering
Environments

 5 A Transaction Model For Active Distributed Object Systems

 6 A Transaction Model For An Open Publication Environment

 7 The ConTract Model

 8 Dynamic Restructuring Of Transactions

 9 Multidatabase Transaction and Query Processing in Logic

10 ACTA: The Saga Continues

11 A Transaction Manager Development Facility For Non Standard
Database Systems

12 The S-Transaction Model

13 Concepts and Applications of Multilevel Transactions and Open
Nested Transactions

14 Using Polytransactions To Manage Interdependent Data




Bibliography
Subject Index
Author Index

ISBN 1-55860-214-3   $49.95 U.S.   611 pages

Morgan Kaufmann Publishers, Inc

Ordering Information:

     Shipping: In the U.S. and Canada, please add $3.50 for the
     first book and $2.50 for each additional for surface shipping;
     for surface shipments to all other areas, please add $6.50 for
     the first book and $3.50 for each additional book.  Air
     shipment available outside North America for $35.00 on the
     first book, and $25.00 on each additional book.  

     American Express, Master Card, Visa and personal checks drawn
     on US banks are accepted.

     MORGAN KAUFMANN PUBLISHERS, INC.
     Department E7  
     2929 Campus Drive, Suite 260
     San Mateo, CA 94403
     USA
     
     Phone: (800) 745-7323 (in North America)
          (415) 578-9911
     Fax: (415) 578-0672
     email: morgan@unix.sri.com
From: al198723@next00.mty.itesm.mx (Eugenio Sanchez)
Newsgroups: comp.databases.theory
Subject: Query optimization using  a functional language
Summary: Looking for a good query optimizer for a functional language (say, Scheme)
Keywords: query, optimization, functional languaje
Date: 5 Oct 92 17:40:31 GMT
Article-I.D.: mtecv2.6089
Reply-To: al198723@academ01.mty.itesm.mx (Eugenio Sanchez)
X-Planation: Hey, I want to write my own 4GL! Is it too bad?

Hi, netters!

I'm looking for some sample code to optimize database queries expressed
in relational algebra. I'd like to write such a program in
Scheme (better yet: does it already exists? :] ). I don't want to
add complexity to this program giving it "semantic" optimization;
I only need basic syntactic transformations.

Do you know of sample papers on this subject? Do you know of any simple
program that do this?

If you can, e-mail me; anyway, I'll collect and summarize the responses.

Eugenio Sanchez (al198723@academ01.mty.itesm.mx)
From: John.Roddick@levels.unisa.edu.au
Newsgroups: comp.databases.theory
Subject: Re: BNCOD '93 - When is it?
Date: 30 Sep 92 17:00:08 +0930
Organization: University of South Australia

> Does anyone know when and where BNCOD is next year?  I can't find it in
> COMP.ANNOUNCE.CONFERENCES

Thanks to everyone who responded asking me to let them know when I found
out but I'm sorry, I received no reply with the answer.  Does anyone know,
even roughly ?

-------------------------------------------+----------------------------
John Roddick                               | Phone: (08) 302 3463
School of Computer and Information Science | Int.:  +61 8 302 3463
Faculty of Applied Science and Technology  | Fax:   (08) 302 3381
University of South Australia              | Email: Roddick@UniSA.Edu.AU
THE LEVELS      SA  5095                   |
SOUTH AUSTRALIA                            |
Newsgroups: comp.databases.theory
From: iqbal@cs.UAlberta.CA (Iqbal Goralwalla)
Subject: Distributed Rule Processing
Summary: Rule Processing in Distributed Databases ...
Keywords: Distributed, Database, Rules
Organization: University of Alberta, Edmonton, Canada
Date: Thu, 1 Oct 1992 00:16:33 GMT


Hi everyone,

I am in the process of carrying out research on (distributed) rule 
processing in a Distributed Database environment. If anyone has any
information on the subject, i.e., pointers to publications and the
state of the research at present, I will be very grateful if you could
spare a couple of minutes and send me (or post to the news group)
whatever info. you have on the subject. 
Thanks a lot ... (iqbal@cs.ualberta.ca)

Hoping to hear from some of you soon ...

Iqbal


Xref: sparky comp.databases.theory:499 comp.ai:3680 aus.ai:146
From: gjohnson@ssdsun.asl.dl.nec.com (Gloria Johnson)
Subject: Re: Inductive Learning and Relational Databases
Organization: NEC America, Inc. Irving, Texas
Date: Wed, 30 Sep 1992 13:02:52 GMT

This is just a test ....

-- 
_______________________________________________________________________________ 
Gloria Johnson                      NEC America, Inc 
 gjohnson@ssd.dl.nec.com            1525 Walnut Hill Lane
                                    Irving, Texas  75038
Newsgroups: comp.databases.theory
From: sivaram@a.cs.okstate.edu (SIVARAMAKRISHNAN S)
Subject: Literature on the design and implementation of OODBMS using C++
Organization: Oklahoma State University, Computer Science, Stillwater
Distribution: usa
Date: Fri, 2 Oct 92 19:00:32 GMT

Hi,
        I am looking for reference material and literature on 
        the design and implementation of a simple OODBMS using
        C++.
        Thanks.
From: chiueh@sprite.Berkeley.EDU (Tzi-cker Chiueh)
Newsgroups: comp.databases.theory
Subject: Reference on database for 2-D and 3-D computer graphics
Date: 2 Oct 92 16:24:48 GMT
Organization: U.C. Berkeley Sprite Project

Can anyone on the net point me to related references on database systems
that are designed specifically for 2D and 3D computer graphics.
For example, how do virtual reality people handle their storage problem?
Thanks.

Tzi-cker Chiueh

Newsgroups: comp.databases.theory
From: MARK@deimos.ucc.umass.edu (MARK T DUQUETTE)
Subject: Information on Multiple query optimization
Organization: University of Massachusetts at Amherst
Date: Tue, 6 Oct 1992 21:16:43 GMT
X-News-Reader: VMS NEWS 1.20

Hi all -

  I am looking for information on optimizing multiple queries.  The areas which
  interest me are the theory behind optimizing such queries as well as
  the actual process of optimizing a multiple query written in some language 
  such as SQL.

  I would also be interested in any information anyone has on the process
  Borland uses to optimize queries (if they do optimize them) written using
  the Paradox Application Language (PAL).

  The names of any papers or books written on the subjects above would be
  most helpful.  I am working with the Relational data model, however any
  information which is related to any other data model would also be helpful.

  Thanks to all in advance

   -Mark

----
   mark@titan.ucc.umass.edu			mark@deimos.ucc.umass.edu
                
  	        	University Computing Services
                   University of Massachusetts at Amherst

Newsgroups: comp.databases.theory
From: geppert@ifi.unizh.ch (Andreas Geppert)
Subject: Re: SUMMARY: Logging/Recovery in Optimistic Concurrency Control
Reply-To: geppert@ifi.unizh.ch
Organization: University of Zurich, Department of Computer Science
Date: Mon, 28 Sep 1992 10:09:25 GMT

In article 14931@schaefer.math.wisc.edu, horn@schaefer.math.wisc.edu (Jeffrey Horn) writes:
>his is a summary of replies to my posting requesting papers and/or
>implementations of database systems using optimistic concurrency control.
>I was especially interested in techniques for logging and recovering
>transactions in such a system.
>
>If anybody has anything else to add about experiences with optimistic
>concurrency control, papers or implementations, responses will be greatly
>appreciated!
>

Two more papers on optimistic concurrency control:
M. Herlihy:  Optimistic Concurrency Control for Abstract Data Types.  5. ACM Principles of Distributed Computing Conference, 1986 (Also in S.B. Zdonik, D. Maier:  Readings in Object-Oriented Database Systems.  Morgan Kaufmann Publishers,  San Mateo, CA, 1987.)

M. Herlihy:  Apologizing Versus Asking Permission: Optimistic Concurrency Control for Abstract Data Types.  ACM ToDS 15:1, 1990.

Have fun
Andreas 

------------------------------------------------------------
Andreas Geppert
Institut fuer Informatik
Universitaet Zuerich            Phone         +41-1-257 4576
Winterthurerstr. 190            Telefax       +41-1-363 0035
CH-8057 Zuerich                 Telex        817 251 unii ch
Switzerland                     E-mail  geppert@ifi.unizh.ch
------------------------------------------------------------
From: lk1j+@andrew.cmu.edu (Lawrence Kim)
Newsgroups: comp.databases
Subject: Info Requested
Date: 4 Oct 92 13:48:40 GMT
Article-I.D.: andrew.IenqOsm00iUyA3PmUj
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA


   
I am looking for any information on a PC software package called OBJECT
1. I think this a database/screen builder product. I will  greatly
appreciate ahy responses. Also, if at all possible please CC: me a
response to this mail address.

Thank You
Lawrence D. Kim
From: DonD@cup.portal.com (Don Robert DeCosta)
Newsgroups: comp.databases
Subject: Re: Data Base design pet peeve
Date: Mon, 28 Sep 92 21:51:00 PDT
Organization: The Portal System (TM)
  <1992Sep25.140930.24262@linus.mitre.org>
  <1992Sep28.142908.10702@bcrka451.bnr.ca>

>But one thing I don't understand in your example.  In what way is this
>arbitrary number useful?  Why is it visible?  It doesn't have much bearing
                           ^^^^^^^^^^^^^^^^^^

*I* never said is was visible, discounting this whole "CPU-time used to
prepare external format" argument.

>to anything in the real world.  Are customer numbers really the right
>approach?  Do you really find your customers through some number?   So,
>I don't even buy your instructor's argument about point#1: modelling.

>[I hate customer numbers!  Every number that I have, I need another
>card for, cluttering up my wallet.  And if I was a business, I would 
>want my business name to identify me.  Customer numbers are object ids
>that should be totally hidden from both me and you!]

>Stuart
>--
>: Stuart MacMartin                          

Now, come one! You know better than that!  The key item has to be unique
and YOU may think Stuart MacMartin is unique but I guarantee that as soon
as *I* decide to use it as a key there'd be two of you!

I don't even want to think about the the system that has your name as the
key item repeated in every "video_rented" transaction so that if you rent
25 videos this year they've got your name stored 51 times (once in the
customer record, 25 times in each video_rented transaction and another
25 times in the customer_id-to-video_rented foreign index).  A good
system would use some arbitrary customer_id and allow the clerk to search
by your name to get to your records.

Don DeCosta           |The nice thing about sanity is|  VM/Nomad2
DonD@cup.portal.com   |you can lose it more than once|  Amiga/Imagine
Newsgroups: comp.databases