DATABASE

Building your music library can be an intensely rewarding experience. Dedicated DJ media players use a robust Microsoft Access database (dj.mdb) that can easily catalog and quickly retrieve music from collections of 10,000 titles or more. Music is stored on your computer or network in a standard manner. The database simply contains information on the songs location as well as containing numerous description fields and various tables to describe how the music will be played.

Dancing DJ Suite comes with a sample database containing 4 short songs. Adding more music from your collection can be done from the Music Organizer , by scanning your computer or network drives using the Crawler or by using iTunes2ddj to import iTunes playlists.

Four main tables

Table Contents
Music  Master table, music titles, descriptions, path.etc.
Genre genre name and allowed tempo range
GenreOrder A simple ordered list of play preferences such as Waltz, Rumba, Tango and Jive... useful for assembling Playlists
Playlist Specific title selection, ordering and settings

The Music table is the master table. It contains a complete description of all available titles including such information as, artist, genre, tempo, as well as the storage location of the actual music or video file.

The Genre table describes your music categories (dance categories). This table stores information on the appropriate tempo ranges for each genre category so your music will meet the dance standard.

The GenreOrder table(s) is a simple single field list which contains a only a genre name. In our example the category is a dance name but it could as well be categories of Blues, Rock and Roll, Classical, etc, or Trains, Jackhammers and Howling dogs if that is your listening pleasure. The GenreOrder table is useful when constructing and organizing playlists and can be used to automatically generate a random playlist.

 Playlist tables are subsets of the Music table. They contains most of the Music table description fields and some or all of the music records. In addition, they have a numeric play order field. Playlists also contain fields that override the music default such as volume or rate and others as well as other such as start and stop position.

There is no limit to the number or length of PlayList_{Description} or GenreOrder_{Description} tables. Construct as many of these tables, as desired. Note, however, the naming convention for both Playlists and GenreOrders that require  "_" in your custom list names.

Dedicated DJ media players & dj.mdb
Dedicated DJ player databases are typically accessed using the Music Organizer interface. This interface allows simple record additions, modifications and deletions to each of the major tables as well as providing powerful playlist assembly capabilities. There are no proprietary aspects of our database. You may choose to do your own custom reporting or even modify dj.mdb using Microsoft Access.


Free Database Tools

No specialty tools, including Microsoft MS Access, are required to use ddj products. Still, specialty reporting  or database modifications might be required for your application. While we recommend MS Access as the best product to customize the ddj database other less pricey options exist.

OpenOffice.org  (OOo) Free comprehensive, open source office application suite courtesy of Sun Microsystems. Includes support for Microsoft Office compatibility  including MS Access.

MDB View
Download v1.0 This program comes Mat Software at www.matsoftware.com  MDB View is a free MS Access viewer that can load Access databases and display tables and data information. While this program is not necessary for any ddj operations it might be useful to those wanting to explore the dj.mdb tables and newly added data. Paradoxically the official link to this site contains nothing but ads.