HDTenEightyP/NetNews huggingface dataset:
From: rys@inf.ethz.ch (Michael Rys)
Subject: Re: Database Journals
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Mon, 25 Jan 1993 19:37:42 GMT


> Journals on database issues
> 
> SIGMOD Record - ACM
> Trans. on Knowlege and Data Engineering
> Trans on Database Systems - ACM
> Information & Software Technology (A Buttersworth journal)

The VLDB Journal (VLDB Endowment, Publisher: Boxwood Press)
Contact: Publication board: 	Arie Shoshani <shoshani@lbl.gov>, 
				Michael Rys <rys@inf.ethz.ch>
	 Editors-in-Chief:  	Hans Schek <schek@inf.ethz.ch>, 
				Fred Maryanski <fred@provost.vpa.uconn.edu>
Note:	 Reviewed Papers

many database conference proceedings:
VLDB (Publisher:Morgan-Kaufmann), PDIS, FODO, Data Engineering ...

> 
> Journals that take database stuff
> 
> Journal of Object-Oriented Programming
> Computer Journal - UK

ACM Computing Survey
Journal of the ACM
Communication of the ACM
IEEE Software
IEEE Computer

> I am particularly interested in national journals.

German Informatics Society (GI):
Datenbank Rundbrief
Language: mostly German, some English
Contact:  Wolfgang Benn <Wolfgang.Benn@fernuni-hagen.dbp.de>
Note:	  unreviewed

Swiss Informatics Society (SI):
DBTA-Forum (part of SI-Notizen)
Language: mostly German and French, some English
Contact:  Klaus Dittrich <dittrich@ifi.unizh.ch>
Note:	  Has only small articles due to space limitations. Unreviewed.


Hope that helps.

Michael

Disclaimer: ---------------------v
--
Michael Rys               Publication Board               The VLDB Journal
Voice: priv. +41 1 341 16 27   bus. +41 1 254 72 57   Fax: +41 1 262 39 73
    -- Wovon man nicht sprechen kann, darueber muss man schweigen. --
          Ludwig Wittgenstein, Tractatus logico-philosophicus
Newsgroups: comp.databases.theory
From: tlp@panix.com (Tracy Pendergast)
Subject: re; JOB OPPORTUNITIES IN THE NEW YORK CITY AREA
Date: Thu, 21 Jan 1993 16:32:27 GMT
Organization: PANIX Public Access Unix, NYC


If anyone has a copy of this original message,
would they please forward it to me???

Thanks!  --tl
From: srm@comp.lancs.ac.uk (Simon Monk)
Newsgroups: comp.databases.theory
Subject: List of Database Journals
Date: 28 Jan 93 14:09:04 GMT
Organization: Department of Computing at Lancaster University, UK.


I've compiled a first pass of the list of database journals. Many thanks
to all those who replied. In some places I only have a name for the journal
where that is the case, if you have further details that you can supply, they
would be appreciated.

Mr. S R Monk
Dept of Computing
Engineering Building
University of Lancaster
Lancaster
LA1 4YR
England
U.K.
Tel 44-524 65201 x 4117
Fax 44-524 381707
email srm@comp.lancs.ac.uk


Database Journals

SIGMOD Record - ACM 
Ed Arie Segev, Walter A Haas School of Business and Computer 
Science Research Dept, Lawrence Berkley Lab, 350 Barrows Hall, 
The University of California, Berkley, CA 94720. 
saseg@violet.berkley.edu

IEEE Trans. on Knowlege and Data Engineering
Ed. in ch., C V Ramamoorthy, Division of Computer Science, 
University of Berkley California, Berkley CA 94720, 
ram@ernie.berkley.edu

Trans. on Database Systems - ACM
Ed. in Ch., Won Kim, UniSQL Inc, 9390 Research Boulevard, Austin, 
Texas, TX 78759/512.  unisqllkim@cs.utexas.edu

Information and Software Technology - Butterworth Journal


The VLDB Journal (VLDB Endowment, Publisher: Boxwood Press)
Contact: Publication board:     Arie Shoshani <shoshani@lbl.gov>,
                                Michael Rys <rys@inf.ethz.ch>
         Editors-in-Chief:      Hans Schek <schek@inf.ethz.ch>,
                                Fred Maryanski 
<fred@provost.vpa.uconn.edu>
Note:    Reviewed Papers

Distributed and Parallel Databases

Data Engineering


ACM Transactions on Information Systems (formerly Transactions 
on Office Information Systems)
Ed in Ch. Robert B Allen, Bellcore 2A-367/445 South St. 
Morristown NJ 07962-1910. rba@bellcore.com




Other Journals

Journal of Object-Oriented Programming - SIGS publications
Ed. Dr. Richard S Weiner, 135 Rugely Court, Colorado Springs CO 
80906.

BCS Computer Journal (UK) - CUP
Ed in Ch. P. Hammersley, Middlesex University, The Burroughs, 
Hendon, London, NW4 4BT  
P.Hammersley@uk.ac.middlesex.cluster

ACM Computing Survey
Ed in C. Richard R Muntz, Dept of Computer Science, University of 
California at Los Angeles, Los Angeles, CA 90024


Journal of the ACM



IEEE Software
Ed in Ch. Carl Chang, 10662 Los Vaqueras Circle, PO Box 3014, Los 
Alamitos, CA90720-1264

IEEE Computer
contact: Jon T Butler, Dept of Electrical and Computer Eng., code 
EC/Bu, Naval Postgraduate School, Monterey CA 93943-5004


German Informatics Society (GI):
Datenbank Rundbrief
Language: mostly German, some English
Contact:  Wolfgang Benn <Wolfgang.Benn@fernuni-hagen.dbp.de>
Note:     unreviewed

Swiss Informatics Society (SI):
DBTA-Forum (part of SI-Notizen)
Language: mostly German and French, some English
Contact:  Klaus Dittrich <dittrich@ifi.unizh.ch>
Note:     Has only small articles due to space limitations. 
Unreviewed.
From: srm@comp.lancs.ac.uk (Simon Monk)
Newsgroups: comp.databases.theory
Subject: Database Journals
Date: 25 Jan 93 11:02:18 GMT
Organization: Department of Computing at Lancaster University, UK.


Does any one have a list of database journals and journals that
take a reasonable proportion of papers on databases. I would like
to complie a list, so if you feel like sending me names and addresses
of your favourite journal, I am happy to compile and re-post the list.
At the moment my list is very meagre and comprises :-

Journals on database issues

SIGMOD Record - ACM
Trans. on Knowlege and Data Engineering
Trans on Database Systems - ACM
Information & Software Technology (A Buttersworth journal)

Journals that take database stuff

Journal of Object-Oriented Programming
Computer Journal - UK


I am particularly interested in national journals. I would be grateful 
for as complete information as possible on names and contact emails etc.


Simon Monk
Dept of Computing
Engineering Building
University of Lancaster
Lancaster
LA1 4YR
England
U.K.
Tel 44-524 65201 x 4117
Fax 44-524 381707
nemail srm@comp.lancs.ac.uk
From: fsbrn@brl.mil (Ferd S. Brundick)
Newsgroups: comp.databases
Subject: SUM in Pdox4.0 report
Date: 25 Jan 93 14:36:03 GMT
Reply-To: fsbrn@brl.mil
Organization: Army Research Laboratory

I have a simple report in Paradox 4.0 (running in compatible mode)
that is a group summary table.  I used summary fields to calculate 
the sum of each field I am interested in on a per-group basis in the
group band and overall in the report footer.  (The table band is
empty.)  My group subtotals and overall totals are correct.

My question involves percentages.  I need to calculate
Sum(group)/Sum(overall) for each group.  I tried Field/Place/Expression
with SUM([Rev],GROUP)/SUM([Rev]) but SUM([Rev]) is the sum *so far*,
not the total for all the groups.  The first group line is always
100%, the last one is always correct, and the ones in between are
wrong.

I realize I can run a query to calculate the totals, and replace my
expression with SUM([Rev],GROUP)/[Answer->SumRev].  Does anyone know
an easier (more efficient, whatever) way to do this?  Thanks.

                                        dsw, fferd
                                        Fred S. Brundick
                                        USARL, APG, MD.
                                        <fsbrn@brl.mil>
From: ddaye@magnus.acs.ohio-state.edu (David C Daye)
Newsgroups: comp.databases
Subject: dBase IV on VMS question
Date: 27 Jan 93 19:13:15 GMT
Organization: The Ohio State University

Hi; I'm forwarding this post from bit.listserv.database-l to comp.databases.
David Daye.
-------------

As the subject line says, I'm running dBase IV (1.1, I believe is the
version) on a VAX VMS system. 

I have a few questions pertaining to the creation of files on the VAX
which are destined for PC DOS use, but they're very specific to the VMS
environment.

Please e-mail me if you're running dBase IV VMS and are willing to try
your hand at a few questions. 

Thanks.
David Daye
DAYE.1@OSU.EDU
---------------
Newsgroups: comp.databases
From: bjroche@unix1.tcd.ie (One Cool Guy)
Subject: test
Organization: Trinity College, Dublin
Date: Wed, 27 Jan 1993 12:46:58 GMT

This just a test transmission.!





Newsgroups: comp.databases
From: jrawles@leland.Stanford.EDU (jody rawles)
Subject: MUMPS info. wanted
Organization: DSG, Stanford University, CA 94305, USA
Distribution: usa
Date: Tue, 26 Jan 93 21:12:17 GMT

Can anybody recommend some reference material to me
regarding the MUMPS data base system and programming 
language?  (Do I even have this right?).  Are there 
documents available via ftp?  I might have to write
my own report program in the next few months and I
know nothing of MUMPS.

-- 
Jody M. Rawles			email: jrawles@leland.stanford.edu
Stanford University 		voice: (415) 858-3914
Stanford, CA 94305 USA		fax:   (415) 493-4901
Newsgroups: comp.databases
From: rkng@rd.hydro.on.ca (Ron Ng)
Subject: Re: Paradox: table and index with different sort orders
Organization: "Ontario Hydro - Research Division"
Date: Fri, 22 Jan 93 17:10:11 GMT

rkng@rd.hydro.on.ca (Ron Ng) writes:
: gordon@chmeds.ac.nz writes:
: : One of our users has many tables which he cannot access because of a common 
: : error: "table and index have different sort orders". This is probably because 
: : the files have been moved between different PCs with differently configured 
: : Paradox setups.
: : 
: : Is there an easy way to fix this problem?  The only suggestions I have so far 
: : involve reentering many sets of data manually. That has been described as 
: : character-building. 
: :
: This problem was caused by two different PARADOX.SOR (or PDOXRUN.SOR if
: you are using the runtime version) files residing in the two machines.
: I recommend you to ask the user to remove the current PARADOX.SOR file
: (or renaming it) and copy one of ASCII.SOR, INTL.SOR, NORDAN4.SOR, 
: NORDAN.SOR and SWEDFIN.SOR as PARADOX.SOR depending on which sort order
: were used when installing Paradox in the machine where the tables are 
: copied from.
: 
: Ron.K.Ng@hydro.on.ca
:
... and remove the appropriate index files. 
Newsgroups: comp.databases
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: Revelation paint -- Define Page
Keywords: Revelation Paint
Organization: Iowa State University, Ames IA
Date: Wed, 27 Jan 1993 03:29:21 GMT

In <1993Jan26.215020.2065@massey.ac.nz> DTodd@massey.ac.nz (D.M. Todd) writes:

>Cliff,

>You hit the nail on the head on my "define page" problem.  If there
>is a label in the area that is selected, you just get a 4 option
>popup on F2 (object options: drag, color, copy, delete).  Guess I'll
>have to move all my labels off the screen to define pages.

>Thanks very much.

>David

David,

You can just select the prompts.  Hold down the shift key while clicking
on each prompt you need separately.  Be careful of your mouse action as you
can easily move a prompt this way if you do drag while the button is down.
This allows you to select any selection of window items without them 
being in a "select box" as when using the mouse to drag out a rectangle.
This method of being able to pick and choose the selected items is quite
handy.  Thanks for including it Scott.

Clif
-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
From: fsbrn@brl.mil (Ferd S. Brundick)
Newsgroups: comp.databases
Subject: Re: menu
Date: 21 Jan 93 16:02:54 GMT
Reply-To: fsbrn@brl.mil
Organization: Army Research Laboratory

In article <1993Jan21.074103.1@helix.mgh.harvard.edu>, brousseau@helix.mgh.harvard.edu writes:
|> I've encountered a problem with PAL that I need help with. Simply,
|> how can I perform a query / endquery, using a string variable which
|> contains operators? 
|> Example, I want to ask the user to input a (limited) range of 
|> days by checking a box either Y = Yes, include Monday or N = No, 
|> do not include Wednesday. I've gone through the response and
|> made a string that would look something like this: "..MON.. AND NOT ..WED..",
|> placed it into the query form, Database | ~string |, but it doesn't work.
|> I think it is because the query is looking for a literal interpretation of
|> the string, instead of parsing the data and operators. Anyone? The best I
|> can think of at the moment is multiple queries, but that can take a _long_
|> time. Thanks.

Build your query the usual PAL way with Query/Endquery.  Then stuff
the pattern in the desired field with a field assignment statement.
Suppose your field is named WorkDay and the string variable is
WhichDays.  The statement would be:
  [WorkDay] = WhichDays
The variable WhichDays gets expanded, so you're putting the literal
text in the query, not a tilde variable.

I used this in a case where the user may optionally restrict a query
to a certain value.  I found out a tilde variable didn't work if the
value was a null string -- pdox returned all the records with a null
field (none).  Instead I say
  IF NOT ISBLANK(InvCat) THEN  [Category] = InvCat  ENDIF
btw, the field does not have to appear in the original query/endquery.

                                        dsw, fferd
                                        Fred S. Brundick
                                        USARL, APG, MD.
                                        <fsbrn@brl.mil>
Newsgroups: comp.databases
From: jig1@crux3.cit.cornell.edu (Julian Gorfajn)
Subject: Re: Help converting Clarion databases
Organization: Cornell Information Technologies
Distribution: usa
Date: 28 Jan 93 20:41:51 GMT

wdieteri@wrdis01.af.mil (Will Dieterich) writes:

>I am looking for a program to convert Clarion version 2.1 databases files, to
>text files or to dbase files.  If you know of a ftp site that has such a
>program please e-mail me.

Such a program is part of the Clarion Professional Developer package.

/-------------------------------------------------------------------------\
|  XXXXXXXXXX                                 |   CCCCC   \               |
|      XX                                     |  C     C   \    999  6    |
|  x   XX   x  Julian I. Gorfajn              |  C  U     U \   9 9  6    |
|  X   XX   X           jig1@cornell.edu      |  C  U  C  U |   999  666  |
|  XXXXXXXXXX                                 \   CCUCC   U |     9  6 6  |
|----------------------------------------------\    U     U |     9  666  |
|  Cornell University, School of Engineering    \    UUUUU  |             |
\-------------------------------------------------------------------------/
From: jfc@nic.cerf.net (Co Ho)
Newsgroups: comp.databases
Subject: Re: Clipper compatible DBMS under UNIX ?
Date: 25 Jan 1993 17:27:38 GMT
Organization: CERFnet Dial n' CERF Customer Group
NNTP-Posting-Host: nic.cerf.net

	I would suggest the following steps:

1) Call up Sequiter Software, buy their CodeTranslator product to
translate your Clipper code to C

2) Buy their CodeBase/portable version, put it on the UNIX box then
recompile it for UNIX.

3) Recompile your application code (now C code) on the UNIX box with
CodeBase library.

	Good Luck!

-- 
Co Ho  - FJC Software Development | "..is there a vision that I can call my
321 E. Chapman Fullerton CA 92632 | own? Feel like I'm looking for a reason
(714) 992-7274 BBS:(714) 992-7754 | -roaming through the night-  to find my
Alt.Addr=xcho@ccvax.fullerton.edu | place in this world.."   MichaelW.Smith
From: cpetersn@iastate.edu (Clifton R Peterson)
Newsgroups: comp.databases
Subject: Re: Revelation paint -- Define Page
Keywords: Revelation Paint
Date: 26 Jan 93 05:16:54 GMT
Organization: Iowa State University, Ames IA

In <1993Jan26.032116.14607@massey.ac.nz> DTodd@massey.ac.nz (D.M. Todd) writes:

>How do you define pages in paint in 3.xx?  The manual says to select
>the prompts to fit on a "page" and press F2 and select Define Page.
>I don't get a Define Page option.

>TIA

I don't know what the problem is with your installation.  On my 3.01, If I
select 1 prompt, press F2, I get a popup with about 15 items, numbers 10 and
11 are Define Page and Undefine Page.  Pressing F1 from the popup gives a
help message for PROMPTOPTS2.  If I select multiple prompts and press F2, I
get a popup with only 13 items (I think, didn't jot the number down), again
with 10 and 11 as above and the popup help is for PROMPTOPTS4.

Are you selecting labels along with prompts before pressing F2?  I don't know
if this is different (not multitasking so I can't switch back to AREV) than
selecting only prompts as regards the Options.

Clif
-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
Newsgroups: comp.databases
From: roto@elena.dei.unipd.it (Roberto Totaro)
Subject: DBIII compatible database engine
Organization: Universita' di Padova, Italia
Date: Tue, 26 Jan 1993 09:31:19 GMT

	Hello, I'm searching for a DBIII compatible, C callable database
	engine for Windows 3.1 (Microsoft C 7.0) and Unix (Sun
	SparcStation II).

	Is anybody out there with any idea?

	E-mail answers will be very apreciated! Thanks in advance,

					Roberto Totaro

	E-mail to: roto@elena.dei.unipd.it
Newsgroups: comp.databases
From: kxs5829@ultb.isc.rit.edu (K.X. Saunders)
Subject: Re: Counting Null Values in an SQL Query
Keywords: I am a Beginner
Organization: Rochester Institute of Technology
Date: Fri, 22 Jan 1993 13:15:33 GMT

In article <1993Jan20.233912.13272@mnemosyne.cs.du.edu> afadel@nyx.cs.du.edu (Ayman Fadel) writes:
<The problem is I'm also supposed to count the
<number of patients in each unit form whom no
<value of acuity was entered, ie. level is null.
<
<Everything is good except that I cannot get a count for the
<number of patients without an acuity.
<
<Any help?

	Instead of count(level), try count(*).

	- Kyle

-- 
_,--\_/>>    kxs5829@ultb.isc.rit.edu                   // Amiga weenie        
`"""-(_-\    kyle@nick.csh.rit.edu                  \\ //                     
  _,// \_\                                           \X/                      
*""'     "" not representing Phoenix Systems Inc.                             
Newsgroups: comp.databases
From: "Michael Vogt" <vogt@cs.indiana.edu>
Subject: Paradox/SQL
Organization: Indiana University, Bloomington
Distribution: na
Date: Wed, 27 Jan 1993 14:37:32 -0500

Hi,  Novice Paradox question follows...
Is Paradox, by itself w/o 3rd party tools, SQL complient today?

I've got the following situation:
A client has a database that will be capturing about 8000 records a
day of approximately 3 Meg of data a day.  The internal information
center is trying to get us to use Paradox instead of SQL Server.
There are 24 users, hooked up to a MS LANMGR Lan, who will be
accessing the data server.  The data server must be SQL compliant,
and support windows 3.1.  SO will Paradox be an adequate data
server?

Thx
-Mike
Newsgroups: comp.databases
From: timmer@fwi.uva.nl (Ralf Timmer (I89))
Subject: What is an OODBMS?
Organization: FWI, University of Amsterdam
Date: Thu, 21 Jan 1993 12:03:20 GMT

Hi,

My question is in the subject!

-- 
Ralf Timmer                                     Department of Computer Science
Email: timmer@fwi.uva.nl                        University of Amsterdam
--
Newsgroups: comp.windows.ms.programmer,comp.databases
From: rpeterse@watserv1.uwaterloo.ca (Raymond Petersen)
Subject: Re: ESQL products for windows ???
Organization: University of Waterloo
Date: Sat, 23 Jan 1993 20:34:10 GMT

In article <C18JzM.LDM@ucunix.san.uc.edu> link@ucunix.san.uc.edu (Virginia Link) writes:
>
>
>   I am interested in developing a product on windows in C++ that uses
>   a database.  I would like to have  use some type of embedded C
>   from which to access the database.  Some obvious choices are Ingres
>   and oracle.  They are also very expensive.  The database must offer
>   all the usual locking required for a multiuser system.
>   What would be some suggestions for product that support embedded
>   code and possibly SQL ?
I use WATCOM SQL (both the DOS and Windows version)  I don't know what the
Windows version was priced at but the DOS version was $395 ($199 if you owned
WATCOM C)  They support Embedded SQL in C and provide you with an SQL
pre-processor.  They also have a distributable run-time for $99.
Their Windows version allows up to 10 applications to use the database engine
on a single machine and you can set the level of locking that you wish.
They also have a network version that allows Windows clients to run off the
database Server.

>   Unfortunately, products like FoxPro limit the developer to using
>   FOXpro for the rest of the products life by making one develope in
>   their language.  Not very Appealing to any serious development.
>   I am sure they don't have any problems with this, as
>   it makes it impossible to ever switch databases...
>   But I do want the ability to switch databases at some point...if the
>   need ever arises.
If it gives you any consolation we converted a very large program from another
SQL database engine to WATCOM SQL in less than 3 days.  The thing to watch
is that you do not use features of a product that are not widely supported by
other vendors.


Raymond Petersen
MicroComputer Centre
The Mutual Group   (Standard employer/employee warnings apply)
From: torbecvs@ucbeh.san.uc.edu
Newsgroups: comp.databases
Subject: dBASE III+/Foxbase Question
Date: 22 Jan 93 10:35:46 EST
Summary: Sending a report/ouptut to a file
Distribution: world
Organization: Univ. of Cincinnati

To whomever can possibly help me,
	I am using dBASE III+ and Foxbase.  Simple question (I hope!).

	How do you send output to a file?  To be a little more specific, I
would like to give the user the option to output send to the screen, to a
printer, or to a user specified filename.  I figure that it has something to do
with: 
	SET PRINTER TO (<device>
		or
	redirecting using a DOS command

Am I close?!  Thanks ahead for any help,
	VST
Newsgroups: comp.databases
From: mike@vpnet.chi.il.us (michael kamlet)
Subject: Help with SQL statement
Reply-To: mike@vpnet.chi.il.us
Organization: Vpnet Public Access
Distribution: na
Date: Fri, 22 Jan 1993 21:10:51 GMT

I'm having a problem writing an SQL statement for the following situation
(and I'm not sure its really possible)

I have 2 tables lets say I have a Customer table and an order table.
I want to query the database for all customers and show their orders
for the past month.  I may have more than 1 order for a customer.

The problem is that if I don't have an order for a customer, the join will
not find a match and that customer will be left out of the report.

I still want to show the customer even if no orders are present.

Is this possible with SQL ??  was my explanation clear enough ??

Thanks 

   Mike Kamlet
   mike@vpnet.chi.il.us
Newsgroups: comp.databases
From: zilio@sys.toronto.edu (Danny Zilio)
Subject: Pedro Celis's email address
Organization: University of Toronto
Distribution: na
Date: 26 Jan 93 20:46:25 GMT

I am trying to find out some information about Tandem's
reorganization and data placement process. Pedro Celis
gave a tutorial in SIGMOD 1992 about this so I am
trying to find his e-mail address or any info
on Tandem's operation in these topics.

Thanks
Daniel Zilio

P.S. Please e-mail me at "zilio@csri.utoronto.ca" or
"zilio@sys.toronto.edu"
Xref: sparky comp.databases:9288 comp.databases.sybase:712 alt.cad:493