Message-Id: <199706041528.IAA148780@dns.ccit.arizona.edu> Date: Wed, 4 Jun 1997 10:22:05 -0500 From: Steve Head <mailto:jshead@FACSTAFF.WISC.EDU> Subject: Re: database construction To: mailto:IMAGELIB@LISTSERV.ARIZONA.EDU
hi, I am very interested in your MS SQL/NT image management setup. We are in the process of setting one up also. Maybe we could exchange info.Are you using blobs? What language are you using for the application? Why are you moving to Oracle?
Thanks Steve Head Univ. of Wisconsin-Madison School of Education
---------- > From: Patricia Bruce <mailto:PBruce@SWRI.EDU>
> To: mailto:IMAGELIB@LISTSERV.ARIZONA.EDU
> Subject: Re: database construction
> Date: Monday, June 02, 1997 10:01 PM
>
> Thank you for your comments Mike. They are appreciated and welcome. We
are > working in new areas and hearing from others with similar ideas, is
> reassuring.
>
> We are using MS SQL on a NT server and when installed, Oracle. Access
> preparation included planned for the transition. I appreciate and
relish > suggestions, comments, advice, critical reviews and the opportunity to
learn > from others.
>
> Our Web-based catalog intends to provide full 3rd degree searchable
cataloging > information, a thumbnail of each image/digital design or graphic, and a
> request-for-services input form. (reprints, brochures, etc.)
> Account/charging, delivery, special instructions and requested due date
is > entered by our customers (in house). Account information is transmitted
to > the accounting department and order information to photography and
publication > departments.
>
> If anyone has seen such a system in operation or are currently designing
one, > I would enjoy and appreciate contact. Thank you!
> Patricia Bruce, Southwest Research Institute (nonprofit, R&D), San
Antonio, > Texas
> mailto:PBruce@swri.edu
> Mike Betz <mailto:betz@WLN.COM> Wrote:
> |
> | I would caution against using Access with "millions of
> | photographs". There
> | seems to be a limit around 500,000 where Access craps out,
> | and the
> | database self-destructs. Also, at half a million rows,
> | queries can take up
> | to 20 minutes against non-indexed fields. For a project
> | this size use a
> | real database, say MS SQL or Oracle.
> |
> | Mike Betz
> | mailto:betz@wln.com
> |
> |
> | On Mon, 2 Jun 1997, Patricia Bruce wrote:
> |
> | > Hello Katalin....I am doing the same thing here in
> | Texas, but with millions of
> | > photographs. I will be happy to correspond with you via
> | E-mail, concerning
> | > any questions you may have. We also are using Access,
> | 7.0 under Office 97,
> | > and will be planning our collection for in-house cross
> | platform use as well as
> | > use on the Web. Good luck and welcome!
> | > Patricia Bruce
> | > Southwest Research Institute
> | > San Antonio, Texas
> | >
> | > Katalin Fur <mailto:katalinf@ROM.ON.CA> Wrote:
> | > |
> | > | Hello Everyone,
> | > |
> | > | I am an intern at the Royal Ontario Museum and my
> | > | summer project
> | > | involves creating a finding aid for item-level
> | > | description of 1200
> | > | archival photographs. A selection of these will
> | be
> | > | digitized and the
> | > | finding aid will be available at our web site.
> | It is
> | > | hoped that the
> | > | successful outcome of this initiative will lead
> | to
> | > | the addition of
> | > | other finding aids from the collection. I will
> | be
> | > | using MS Access and
> | > | would appreciate all advice concerning
> | appropriate
> | > | field designations.
> | > | Thanks in advance
> | > |
> | > | Kathy Fur (mailto:katalinf@rom.on.ca)
> | > |
> | >
> |