home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!spool.mu.edu!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!usenet.ins.cwru.edu!agate!apple!apple!cambridge.apple.com!@RIVERSIDE.SCRC.Symbolics.COM:Kevin@SCANDIUM.MKS.DIALNET.SYMBOLICS.COM
- From: Kevin@SCANDIUM.mks.dialnet.symbolics.com (Kevin G. Joback)
- Newsgroups: comp.lang.lisp.mcl
- Subject: Database Implementation Naivete
- Message-ID: <19921109063538.2.KEVIN@SCANDIUM.mks.dialnet.symbolics.com>
- Date: 9 Nov 92 06:35:00 GMT
- Sender: info-mcl-request@cambridge.apple.com
- Lines: 26
- Approved: comp.lang.lisp.mcl@Cambridge.Apple.C0M
- Original-To: slug%ai.sri.com@riverside.scrc.symbolics.com
- Original-Cc: info-mcl%cambridge.apple.com@riverside.scrc.symbolics.com
-
- I am considering implementing a database in lisp for managing
- information on chemicals. Till now I have been saving objects to files
- and then reloading them. With the number of chemicals now approaching
- 2000 this process takes too much time. Additionally I never take
- advantage of having all the information loaded.
-
- My needs are quite minimal. No transaction restarts or SQL (yet).
-
- I thought a file in a specified, fixed format could be used to store the
- information. The FILE-POSITION function would be used to move around the
- file. READ-CHAR, WRITE-CHAR, READ, WRITE, etc. used to retrieve and store
- information.
-
- Being inexperienced in this area I have several questions:
-
- 1) Is this approach likely to work? I know commercial databases offer
- numerous capabilities which probably make them very complex to implement
- but can one start small?
-
- 2) Are there any references which discuss the implementation of simple
- databases? I have found countless books on database architecture and
- implementation issues but none on how to sit down and start coding.
-
- I thank you in advance for any comments and advice.
-
- Kevin G. Joback
-