Re: Designing a CD Database - How to Start?

On 2005-08-29, Spam Scone <Spamscone@xxxxxxxxx> wrote:

> Any suggestions for designing a CD database? I'm starting to feel the
> need to have some sort of catalog of "the collection". I'm not a tech
> person so please keep all your suggestions basic. I suppose an Excel
> spreadsheet might serve..

My advice is to keep your schema as simple as possible. Be realistic about
how much info you want to enter for each CD. The one I'm using now is

composer
composer_id
composer_name
work
work_id
composer_id
title
subtitle (probably not really needed if you merge it with the title)
work_no (this is opus or other composer catalog number; also could be merged
with the title.)
label
label_id
label_name
disc
disc_id
label_id
catalog_no
recording
recording_id
work_id
disc_id
description (usually a short description of the artists involved)

This is probably inadequate for someone who needs timing info, or who wants
to be able to do complex searches on things like artists or genres. But I
just need a record of what works I have on what CDs, don't want to spend a
lot of time on data entry, and so I resisted the impulse to make a fancy
schema.

Here's the database in sqlite3 binary format:

http://members.cox.net/davecook/stuff/db.zip (878K)

To use this you need the very small and easy to install sqlite package
(version 3 or above):

http://sqlite.org

I wrote my own data entry GUI using this schema. Here are some
screenshots (warning: 1400x900 png files):

http://members.cox.net/davecook/stuff/discminder.png
http://members.cox.net/davecook/stuff/autocompletion.png
http://members.cox.net/davecook/stuff/worksearch.png

Dave Cook
.

Relevant Pages

  • Semantic of getTables
    ... java.sql.DatabaseMetaData#getTables(String, String, String, String) ... catalog - a catalog name; must match the catalog name as it is stored ... schemaPattern - a schema name pattern; must match the schema name as ... it is stored in the database; "" retrieves those without a schema; ...
    (comp.lang.java.databases)
  • Re: Catalog & Schema
    ... catalog = database, schema = schema ... you will need to run your own SQL for this. ...
    (comp.lang.java.databases)
  • Re: Catalog & Schema
    ... catalog = database, schema = schema ... SQL Server: catalog = database, ...
    (comp.lang.java.databases)
  • Re: Metadata versioning
    ... > growing database applications as clients evolve with versions. ... to store the metadata version information. ... I created a set of classes to completely describe the metadata or schema ... catalog tables, and schema reading routines, I can move between metadata ...
    (borland.public.delphi.non-technical)
  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)