Re: Creating & accessing a database across CDs

More information should be provided. For instance, are these CD's going to be updated? You would need CD/RW. Are they going to be marketed? Personally, I would always choose Hard Drives over CD-ROM even for database retrieval because you can not only update the database, but access time is much faster, and there is better support for mirroring spanned databases across hard drives. I can't imagine constantly creating a "fixed database" on CD-ROM, since things always change. CD could be used as a backup tool, but again, I would use tape backup systems, or possibly CD/RW. This technology needs CD-RW readable CD-ROMS to play back, which there are only three drives currently on the market...

Timothy Atwood

Co-Author Teach Yourself PL/SQL in 21 Days, available 10/31/97 by SAMS

Alexander Vos <alv_at_wup.de> wrote in article <341014FA.7485B625_at_wup.de>...
> I don't know if i got to realize Drews problem.
>
> But i think he wants to run his db from the cd's.
> With Access db's that wont work, because each mdb creates an ldb file
> while opening. (locking mechanism).
>
> But if you attach these DB to access and the db files are in a different
> format there could be a workaround.
> If youre db contains different tables, split these Tables to diferent
> dbs and store each db on a different CD.
> In youre access db attach them and set the desired relationships.
> This could work, I think.
>
> This should also work when using Powerbuilder
> Let Powerbuilder access youre little and smal lokal Access.mdb files.
>
> alv
> alv_at_wup.de
>
> >
> > I'm not sure if you've tried it yet ... but a couple of options...both
 deal
> > with compression.
> >
> > Create an install of your DB using 'whatever' ....it should have an
 option
> > for a single flat file ... even install builder does....
> >
> > Or just zip it....
> >
> > I had a 128MB DB ... actually, an ORACLE .dmp file .... and zipped it
 down
> > to about 20MB. .. given a compression ratio of about 6X .... then a
 ~3.9GB
> > DB should be able to be compressed down to fit on 1 CD(650MB)
> >
> > ....and I'm no expert on them ... but I've read that DVDs can handle
> > 4.6GB...although $$$$
> >
> > ..and worse case, you can use a tape backup .... I know there are tape
 ....
> > > I'm trying to create a series of 6 CDs containing a database of names
> > > and addresses.... the amount of data is quite huge -- about 3-4 gig
 --
> > > and it consists of many tables with links to be accessed using
> > > Powerbuilder....
> ..
>
  Received on Sat Sep 06 1997 - 00:00:00 CDT