Message-Id: <199706031302.GAA295194@dns.ccit.arizona.edu> Date: Tue, 3 Jun 1997 03:01:05 UTC From: Patricia Bruce <mailto:PBruce@SWRI.EDU> Subject: Re: database construction To: mailto:IMAGELIB@LISTSERV.ARIZONA.EDU
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)
| > |
| >
|