Message-Id: <199801101711.KAA70950@dns.ccit.arizona.edu> Date: Sat, 10 Jan 1998 09:09:24 -0800 From: Mike Betz <mailto:betz@WLN.COM> Subject: Re: database sofware To: mailto:IMAGELIB@LISTSERV.ARIZONA.EDU
I worked for the Washington State Attorney General. We have some rather large cases, ranging from 350,000 multi-page documents to 10 million single page images, all tiff group 4 files which have beeen burned onto CD-Rs. We have used Microsoft SQL on a server as the database (any industrial strength ansi sql compliant database will work), and also something called "Concordance".The CDs are used either locally at each work station, or in a centralized CD juke box. Anyway, if one uses pointers from the database to the location of the images on CDs, then I think disk usage is not as large a concern. Of course, one is presented with the cost of the CD juke box and attaching it to a server, but when faced with 50,000 plus images, this may be a more economical choice.
I think the 32 bit versions of Access (versions 7 and 8) are capable of using pointers. I'm not really sure.
Mike Betz mailto:betz@wln.com
On Fri, 9 Jan 1998, Terry Abraham wrote:
> We have a custom database in MsAccess that we are attempting to use for
> this purpose. At approx. 2000 records plus images it began to exceed the
> capacity of our 2.3 gig hard drive even though it was only about 1.1
> gigs.
>
> We've since moved to a 4 gig drive in the hopes of buying some more time
> in this fashion.
>
> As a "image catalog" only we purposely kept the images small and of low
> resolution.
>
> In the larger world of digital imaging, this is -- if you'll excuse the
> expression -- small potatoes; but it seems to work for us given the
> resource limitations we operate under.
>
> I'll be happy to answer questions on our efforts.
>
> ---Terry
>
> +---------------------------------------------------------------------+
> | Terry Abraham Special Collections U of Idaho mailto:tabraham@uidaho.edu |
> +-----------<http://www.lib.uidaho.edu/special-collections/>----------+
>
>
> On Fri, 9 Jan 1998, darren umney wrote:
>
> > I'm specifying an image database for our 50,000+ images but haven't come
> > across anything that seems ideal. Does anybody have experiences they
> > could share on this one or useful references?
> >
> > Any thing appreciated!
> >
> > Darren Umney
> > Societe Jersiase Photographic Archive
> > Channel Islands
> > UK
> >
>