RE: Database language

[zoltan dot tomory at mobot dot org]

Hi Everybody!

I would love it if it happened too. I hope Bill's contact was wrong & the
perception of movement of only "supporting databases" is a perception that
things are being changed by dribs and drabs over an extended period. Perhaps
even if it is just a matter of implementing new tables as part of routine
upgrades at first, it could be part of a slow and orderly change. Time will
tell. I hope they are. I remember how databases used to be altered before
SQL. Not pretty.

Requesting the change also sounds great. If we do that, please be sure to
request how you want the change made. I'm no SQL expert, but if I recall
correctly, part of SQL's Data Definition Language allows for
granting/revoking of specific rights to specific users/classes of users. We
would need to specify a generous standard for rights to read specific
tables, or the net result could be nothing more than a black box that is
easier for them to maintain.

Bill, when you say "dbase", I take it you meant database in a generic sense,
as opposed to dBase, the 3rd party database manager born in the '80s, right?


I'd love it if we could have the SQL functionality, though Create Lists
really isn't bad and it does simplify what could be some inconvenient joins
in an intuitive way.


Thanks,

Zoltan



-----Original Message-----
From: Adriene Lim [mailto:ab7155 at wayne dot edu]
Sent: Monday, February 14, 2005 4:20 PM
To: mtruitt at uh dot edu; 'IUG INNOPAC List'
Subject: RE: Database language


I would LOVE this if it happened!  WSU could gain all of the benefits of a
fully functional, fully populated relational database, and using SQL,
without having to use the "Oracle option," if this were done. 

- Adriene, WSU

 

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Marc Truitt
Sent: Monday, February 14, 2005 5:11 PM
To: IUG INNOPAC List
Subject: Re: Database language

hi bill and zoltan,

has this ever been pushed as an enhancement request?  is there any reason it
could not be?

how about a virtual show-of-hands from those sites on this list that would
be seriously interested seeing Innovative migrate to an open-source
SQL-compliant back end?

UH would certainly support such an effort.

- mt

--
*************************************************************************
Marc Truitt
Assistant Dean for Systems                      Voice  : 713-743-8979
University of Houston Libraries                 e-mail : mtruitt at uh dot edu
114 University Libraries                        fax    : 713-743-9811
Houston, TX 77204-2000    [note new number!] -> cell   : 713-201-0351 


"Well I left my happy home to see what I could find out
I left my folk and friends with the aim to clear my mind out
Well I hit the rowdy road and many kinds I met there
Many stories told me of the way to get there ..."
                                 -- Cat Stevens
*************************************************************************


Bill Hudson wrote:
> Hi Zoltan,
> I thought the same thing about the mysql migration after IUG last year,
but
> my sales rep checked for me and says that's not the case. There are
numerous
> supporting databases in the system that are/will be converted, but the
core
> dbase will not be converted. I was not happy to hear that as we would love
> SQL compliance without having to pay for Mr. Ellison's sailing hobby.
> 
> If anyone has heard anything different from a reliable source, I would
> definitely like to know about it.
> Thanks,
> BH
> 
>  
>
****************************************************************************
> 
> Bill Hudson, Manager
> Information Technology Services
> Library System of Lancaster County
> 1866 Colonial Village Lane, Suite 107
> Lancaster, PA 17601
> V. 717.207.0500 F.717.207.0500
> 
> 
>>-----Original Message-----
>>From: innopac-bounces at innopacusers dot org [mailto:innopac-
>>bounces at innopacusers dot org] On Behalf Of zoltan dot tomory at mobot dot org
>>Sent: Monday, February 14, 2005 3:08 PM
>>To: innopac at innopacusers dot org
>>Subject: RE: Database language
>>
>>Future plans seem to be that Millennium will be converted to a MySQL
>>database based system over something like a five or ten  year timeframe,
>>phasing out the existing proprietary database/database language, if my
>>recollections from IUG'04 are accurate.
>>
>>Writing their own database--that's gutsy!
>>Changing a database--equally gutsy!
>>
>>One thing from the technical information was not clear to me: The Java
>>Virtual Machine is platform independent & runs on a variety of platforms
>>including Windows, Mac, and a bunch of others. So how come the Java
>>clients
>>typical of Millennium don't do Mac? The purpose of the JVM is to translate
>>Java code to machine code of whatever platform there exists a JVM for with
>>complete integrity & my understanding is that Sun, author of Java, has
>>suffered to keep it so.
>>
>>Zoltan Tomory
>>
> 
> 
> ---
> [This E-mail scanned for viruses by Declude Virus]
> 
> --
> This message was distributed through the Innovative Users Group INNOPAC
list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac
> 
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac


--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---