Dec 282017
 
Music database manager - version 2.1, very good.
File MBASE21.ZIP from The Programmer’s Corner in
Category Databases and related files
Music database manager – version 2.1, very good.
File Name File Size Zip Size Zip Type
MBAS1TO2.EXE 5282 3456 deflated
MBASE.EXE 35272 15866 deflated
MBASE21.DOC 28173 8923 deflated

Download File MBASE21.ZIP Here

Contents of the MBASE21.DOC file






MBase: Music Database Management System

version 2.1
(C) 1988, Anthony Li, All Rights Reserved.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -






[ TABLE OF CONTENTS ]


Introduction...............................1

Files on the disk..........................1

Hardware requirements......................1

How MBase stores data......................2

Setting up MBase...........................4

Starting the program.......................5

The Main Menu..............................6

The Edit Records menu......................7

The Examine Records menu...................9

Hints......................................10

Note for MBase 1.0 users...................11

Technical stuff............................11

Warranty & Disclaimer......................12

License....................................12

Registration form..........................last page

[ 1 ]





[ INTRODUCTION ]

MBase (Music Database) is a database management program. A database is any
collection of information. You can use MBase to keep track of collections of
music. And you can look up the information that MBase holds on each piece of
music in a variety of ways. You can send pruned down or cross-referenced lists
to the screen, printer, or disk.





[ FILES ON THE DISK ]

Three files should be present on your MBase disk. (Or in the .ARC file,
if you've downloaded this program from a BBS.) They are:

MBASE .EXE Program file.
MBAS1TO2.EXE MBase 1.0 to 2.x converter.
MBASE .DOC Documentation file.

You may find some files named MUSIC.001, MUSIC.002, etc. if you downloaded
this. These are the program's data files. Someone may have created a database
and just included it in the .ARC file when he/she uploaded it.





[ HARDWARE REQUIREMENTS ]

To run MBase, you need:

IBM PC/XT/AT or compatible computer with at least 64k RAM.
Any graphics adapter.
1 disk drive.
a printer is optional but suggested if you want to make hard copies of
listings.

[ 2 ]


[ HOW MBASE STORES DATA ]

MBase uses its own kind of "index card" to hold data on each piece of music
that is typed into the computer. The information MBase holds on a piece of
music is called a record. Records can be added, deleted, or changed. They can
also be cross-referenced, viewed on the screen, and sent to the printer or to
a file on the disk.


The different categories of information in each record are called fields.
There are seven fields in an MBase record. They are:

Composer - generally, the last name of the composer. (e.g., "Bach")

Title - the name of the piece of music. (e.g., "Wachet auf")

Season - the season or category for which the music is used. This can
be an actual season ("Spring"), or a genre of music ("Rock"),
or whatever you want it to be. (e.g., "Christmas")

Extra - any extra notes about the piece of music.

Voices - the types of voices that are used in the piece of music. The
suggested format is SATB (or SSAATTBB), where "S" represents
soprano, "A" is alto, "T" is tenor, and "B" is bass.

Solo - similar to Voices, solo simply indicates the voices that play
solo parts in the piece of music.

Library number - The real, physical copies of your music are not stored
inside the computer. The computer merely acts as a card catalog,
allowing you to keep track of pieces of music. You can list the
catalog number of the piece of music in this field.

There is another field used only by MBase. It has nothing to do with music.
This field is called the Index Number. Every record has an index number. The
program uses index numbers to keep track of all of the music records.

Unlike the other fields, MBase assigns index numbers itself. The first
music record that is typed in to the program is given an index number of 1.
The next record is given an index number of 2. The next is given an index
number of 3, and so on.

MBase uses index numbers to keep track of records, but you won't have to
think about them at all unless you want to. The only time you might wish to use
index numbers would be if you were looking for a specific piece of music whose
index number you know. For example, you want to find a record that you know
had an index number of 2. (Because it was the second record added to MBase's
data). Instead of going through the somewhat longer processes of looking for
the record using the standard methods, you could simply tell MBase to find the
record with index number 2. This is the quickest and most foolproof method of
of looking up music records, but it is also the most complicated. Most of the
time, the effort required to look things up by their index numbers isn't
justifiable.

[ 3 ]


Index numbers are volatile. Records have a proclivity towards changing
their index numbers when a record is deleted. The reason -- MBase readjusts
its index numbers whenever a record is deleted. For example, if you have a
database of four music records (index numbers 1, 2, 3, and 4) and you delete
the music record with the index number of 2, MBase will do a few things.
First, it will get rid of the music record with the index number of 2. Then
it will change index number 3's index number to 2 and change index number 4's
index number to 3. The database will have three records, with three index
numbers (1, 2, and 3). Note that the only data that is destroyed is the record
that we wanted to delete in the first place. Of the other two records, only
the index number is changed.

In order to work within 64k of memory, MBase holds only 200 records in
memory at one time. The others are stored on disk in files. Each file holds
200 records and takes up 59200 bytes of disk space. Therefore, a regular 360k
floppy disk can hold 5 data files (1000 records) and the MBase program file
(MBASE.EXE).

If you have more than 1000 records, you'll need a larger disk. A PC/AT
high-density disk (1.2Mb) will hold 4000 records. 3-1/2" disks will hold
between 2000 and 4000 records. A fixed disk is recommended, though, for two
reasons: 1) you will be able to hold much more records, and 2) fixed disks
are much faster than floppy drives.

[ 4 ]


[ SETTING UP MBASE ]

Instructions for setting up MBase on a floppy disk system:

1) You will need a diskette on which to store your music information, most
preferably a blank, formatted disk dedicated solely to MBase. With
a dedicated disk, you have more room to store data than if MBase was
running off a disk with other files on it. With large databases, disk
space is crucial.

2) If your disk is not formatted, you will need to format it. Here's how:

On a two disk drive system, place your DOS disk in drive A: and the
disk to be formatted in drive B:. Then, from the A> prompt, type:
"FORMAT B:"
and hit [Enter]. The FORMAT program will ready the disk for use. When
the formatting process is completed, the FORMAT program will ask you
if you wish to format another diskette. Answer "no" by typing "n" and
hitting the [Enter] key.

On a one disk drive system, place your DOS disk on the disk drive.
Then type:
"FORMAT B:"
and hit [Enter]. DOS will prompt you to insert the disk for drive B:
and strike any key when ready. Remove your DOS disk and insert the disk
to be formatted. Then hit any key. The FORMAT program will ready the
disk for use. When the process is complete, you will be asked whether
you wish to format another diskette. Answer "no" by typing "n" and
hitting the [Enter] key.

3) All that's left is to copy the program file onto your disk. Place the
original MBase disk in drive A:. If you are working with a two drive
system, place your data disk in drive B:. Then type:
"COPY MBASE.EXE B:"
and hit the [Enter] key. If you are working with a one drive system,
DOS will ask you to insert the disk for drive B: and strike any key
when ready. To do this, remove the original disk from the drive and
insert your MBase disk. Then hit any key.
You're done!

[ 5 ]


Instructions for setting up MBase on a fixed disk system:

1) You do not need a separate diskette to store the music data. MBase
will store all data on the fixed disk.

2) Create a sub-directory for MBase. First, make sure you are accessing
the correct drive. (i.e., if your fixed disk is C:, you should see the
"C>" DOS prompt.)
Then type:
"MD \MBASE"
and hit the [Enter] key. NOTE: You can replace the sub-directory name
"MBASE" with whatever legal name you want to use. Just remember to
use the corrent name when accessing the sub-directory, not "MBASE".

3) The last step is to copy the program file into your sub-directory.
To do this, insert your MBase original disk in drive A:, type:
"COPY A:MBASE.EXE C:\MBASE"
and hit [Enter]. If your fixed disk is not drive C:, replace the "C:"
with the correct drive letter. If you used a name other than "MBASE"
for your sub-directory, replace the "MBASE" of "C:\MBASE" with the
correct sub-directory name.
You're done!





[ STARTING MBASE ]

To start MBase from a floppy disk system:

1) Boot up DOS.
2) Replace the diskette in drive A: with your MBase diskette.
3) Type: "MBASE" and hit [Enter].

To start MBase from a fixed disk system:

1) Boot up DOS.
2) Make sure you are accessing the correct disk drive. If your MBase
sub-directory is in drive C:, make sure that you see a "C>" DOS
prompt.
3) Type "CD \MBASE" and hit [Enter]. This brings you into the MBase
sub-directory.
4) Type "MBASE" and hit [Enter].

[ 6 ]


[ THE MAIN MENU ]

When MBase 2.1 is started, it first accesses the disk and looks up all of
the music records that it has stored during earlier uses. When the program is
finished with this, a title screen will be shown. To exit the title screen,
hit any key. You will enter the Main Menu.

The Main Menu is the top level of menu choices in MBase. From the Main Menu,
you can choose the basic things you want to do. Menu choices in all menus are
shown in the center of the screen. To make a choice, you just hit the function
key (abbreviated "[Fx]", as in [F1], [F2],...) that corresponds to the function
key number to the left of the choice. The main menu choices are:

[F1] Edit the records
"Edit the records" lets you change the information that MBase has recorded.
You can add new music records, change records that have already been entered,
and delete existing records.

[F2] Examine the records
In the "examine the records" part of MBase, you can look up or cross-
reference music records and print out your lists of music records to the
screen, printer, or a file on the disk.

[F10] Leave MBase
When you've finished your session with MBase, you can leave the program with
this menu choice. When you choose Leave MBase, a box on the screen will pop up
and prompt you to type "y" to verify your choice. If you hit "y" or "Y", you
will exit MBase. Any other key will be translated as "no, I don't want to leave
MBase." and MBase will resume normally.

[ESC] Help (Instructions)
The on-line Help function is the only menu choice that does not use the
function keys. It is called up by hitting the [ESC] key. When you choose Help,
a box filled with instructions will appear on the screen. In general, the MBase
help boxes give you instructions and tips on whatever you are currently doing.
The Main Menu Help gives you a summary of each command in the main menu and
tells you about the help screens. Help screens are available in most parts of
the program. Whenever you are stuck, try hitting [ESC]. In most cases, a help
box will appear with information that will, hopefully, help you.

[ 7 ]


[ THE EDIT RECORDS MENU ]

When you choose "Edit the records" from the main menu, another menu is shown
on the screen. This is the Edit the Records menu. In addition to a Help box
(called by hitting [ESC]), the menu has four choices:

[F1] Add a record
Lets you add music records to MBase's data.

When you choose this, a box will appear on the screen. It's similar to a
regular index card. On the "card" are the names of the music record fields. On
the top is "Composer", then "Title", all the way down to "Library Number". At
the top of the "card", there is a small tab, labeled "Index Number". The
index number of the music record is written to the right of this field. Except
for the index number, the "card" has no information on it yet. You will fill
in the information for the card.

Starting from the top, at "Composer", you will be prompted by the cursor
to type in information on the piece of music for each field. If you make a
typing error, hit the backspace key to erase the letter to the left of the
cursor. When you have completed a field, hit the [Enter] key. The cursor will
move to the next field. When all of the fields are filled in, the "card" will
disappear and the new music record will automatically be added.

IMPORTANT: Please keep all field information CONSTANT. MBase knows that
"advent", "Advent", and "ADVENT" are the same, but "1st day of Christmas" and
"2nd day of Christmas" have no relationship at all to the computer. The same
rule goes for all spelling errors.

[F2] Edit an existing record
Lets you redo an existing piece of music. After choosing Change Music, you
will be asked to identify the record that you want to change. There are four
different ways to locate a piece of music:

1) By composer and title
When you choose this method, a small box will appear on the screen.
You will be asked to type in the name of the piece of music and the
composer. MBase will locate the first record that matches the
composer's name and the title that you provide.

2) By library number
The program will locate the first record that has the library
number that you type in.

3) By index number
The program will use the record with the index number that you
type in. Make sure not to get library number and index number
confused. They are totally different fields. Be sure that you have
thoroughly read the section on index numbers and "How MBase Stores
Data".

[ 8 ]


4) Perform a manual search
This is the most sure method of locating a specific record, but
also the most tedious and time-consuming. With this method, the
computer does not automatically find the record for you. You must pick
through the records yourself using keyboard commands until you quit or
find the record that you want.


When you choose to perform a manual search, a new screen will be
drawn. The music record at the current index number is shown at the
top of the screen.

A command menu is at the bottom of the screen. To change the index
number, and, thus, change the currently displayed music record,
you must use keyboard commands. The "+" and "-" keys will increment or
decrement the index number by one. Other commands, also listed in the
command menu at the bottom of the screen, change the index number by
10's and 100's. When you find the record that you are looking for,
hit [Enter]. If you want to give up the search for any reason, hit
"q" or "Q" to quit the search.

When you find the record that you want to change, the program will display
more information. At the top of the screen will be the old information
for the record. At the bottom, you will see a blank "card". You just have to
fill in the blank card as if you were adding a new card, remembering to type
in the changes as you go along.

[F3] Delete a record
If a piece of music is lost, sold, thrown away, or otherwise not available,
but its information is recorded in MBase, the Delete A Record function will get
rid of the music record. This function uses the same procedures that were used
in the Change A Record function. You first find the record you want to erase,
then MBase will ask if you really want to get rid of the record. Hit "y" to
erase the record, or any other tell MBase to keep it. When you erase a record,
it is gone forever. The only way to get the information back into MBase is to
add it as a new record.

[F10] Return to the main menu
Returns MBase to the main menu. While you make changes to the data, MBase
only updates those changes in memory, not on disk. All changes are saved to the
disk when you return to the main menu. When the computer is turned off,
everything in memory is erased, but information on disks remain.

[ 9 ]


[ EXAMINE MUSIC ]

MBase's method of pruning down the list of music records can appear to be
quite complicated at first. But when you are accustomed to the method, it is
quick, easy, and very flexible.

The Examine Music menu is much more crowded than the other menus. The first
menu choice is Help. You can receive on-line instructions by hitting [ESC].
The menu choices that are on the left side of the screen represent the fields
of each music record. They are used to specify required values for lists. They
are:
[F1] Composer
[F2] Title
[F3] Season
[F4] Voices
[F5] Solo
[F6] Index Number
[F7] Library Number

When MBase looks up the music, a process called searching, it lists only the
records that meet the requirements of all the fields. You can change the values
of these fields by hitting the function key to the left of the field name.

For example, if you want to find all music by Bach, you should hit [F1] to
choose the Composer category and type in "Bach". When MBase starts searching,
it will create a list of all of the music in its records that were composed by
Bach.

If you only need music composed by Bach for Advent, you could also choose
[F3] (the Season field) and type in "Advent". Then MBase will only list the
records that are of music written by Bach for Advent.

The word "ANY" as a field value means that anything in that field is listed.
That is, there are no restrictions caused by that field. The categories that
deal with numbers - Library number and Index number - use ranges. MBase lists
only the records that fall between (and including) the lowest and highest
numbers.

When you hit a function key ([F1] - [F7]) that changes a field, MBase will
do one of two things. If the field is currently set to "ANY", the program will
ask you for the new value. If the field's value was anything else, MBase will
set it to "ANY".

When you first choose Examine Records from the main menu, all "name"
categories are set to "ANY" and the range categories are set to their minimum
and maximum possible values.

[ 10 ]


[F8] Change output destination
Toggles (switches, changes) the place to where the listings are sent.
Listings can be sent to the screen, the printer, or to a file named "MUSIC.LST"
on the disk.

When sending a listing to the printer, always make sure that the printer is
turned on.

You can send many listings to the disk file "MUSIC.LST". Each new listing is
added to the end of the file if the file already exists. Remember to prune down
or erase this file occasionally. It can get very large quickly.

[F9] Start searching
Starts the searching process. MBase will pick out all of the records that
match the specifications you have given. Then it will send the list to either
the screen, the printer, or the disk.

[F10] Return to the main menu
Returns MBase to the main menu. When you exit the Examine Records menu, all
field values are set to either "ANY" or, if they are numerical values, their
highest and lowest values.





[ HINTS ]

* Back up your data.

Few things are more frustrating than losing all of your data after spending
endless hours typing it into the computer. Data can be lost if a disk is
damaged, erased, or lost. However, if you always have a backup copy of your
data handy, this is not a big problem. You need only restore the data from your
backup disk onto your new data disk. To use a backup disk, you only need a disk
on which to copy your data. Copy your data to this disk whenever you make large
or important changes/additions to your database.

* Make sure new data is saved on the disk.

When entering new records, changing existing records, or deleting old
records, occasionally take a break and return to the Main Menu. Then reenter
the Edit Records menu.

The reason -- When making changes to the database of records, MBase usually
makes all of the changes in memory. Memory is erased when the computer is
turned off (or is reset by power disturbances). MBase does not update the
information on the disk until you exit to the Main Menu. This cuts down on
time-consuming disk usage during the editing of the database.

That means, if the computer were turned off in the Edit Records menu while
you were making changes, you would lose all of the changes. But if the computer
were turned off in the Main Menu, no changes would be lost.

[ 11 ]


[ FOR MBASE 1.0 USERS ]

MBase's data structure has been totally redone. MBase 1.0 was written for
a computer with 640k RAM. It could hold only a small number of records (about
1000) and when working on computers with 64k ram, MBase 1.0 could hold only
about 100 records!

Now, MBase (version 2.x, currently 2.0 and 2.1) can use up to 65535 records
on a PC equipped with 64k RAM.

To convert your old MBase 1.0 format database to the 2.x format, run the
program MBAS1TO2.EXE on the disk/directory where the file is located. This
program will create the file "MUSIC.001" for the first 200 records, "MUSIC.002"
for the next 200, and so on.





[ TECHNICAL STUFF ]

MBase was written in Turbo Pascal v4.0.

It can store a maximum of 65,535 records on disk in groups of 200 records
in each file. Each file takes up 59200 bytes of disk space. MBase keeps 200
records in memory at one time.

Below is the file data structure used in Turbo Pascal v4.0:

CONST
MaxRecords = 200; (* Number of records in each file. *)
NameStringLength = 68; (* For composer, title, & season. *)
VoicesStringLength = 8; (* For voices and solo. *)

TYPE
TypeNameString = STRING [NameStringLength];
TypeVoicesString = STRING [VoicesStringLength];
TypeMusicRecord = RECORD (* This is the data structure *)
Composer, (* for each music record. *)
Title,
Season,
Extra : TypeNameString;
Voices,
Solo : TypeVoicesString;
LibraryNumber : WORD
END;
TypeMusicArray = ARRAY [1..MaxRecords] OF TypeMusicRecord;
TypeMusicFile = FILE OF TypeMusicArray;

[ 12 ]


[ WARRANTY ]

This version of MBase is provided AS IS without any warranty, expressed
or implied. Anthony Li claims no responsibility for any losses incurred or
alleged to be caused by use of the program. If you have a problem, comment,
or suggestion, feel free to call.

Please call if you have need of a customized program or utility for MBase.
I will do my best to serve.




[ LICENSE ]

This is a user-supported product. It is copyrighted 1988 by Anthony Li.
All rights are reserved by the author. You may use, copy and distribute
MBase provided that:

1) If you use this program regularly and find it of use to you, please
register by sending $15.00 to Computer Typesetting. (see address
below). Registration grants you free upgrades for a one year time
span from the date of payment. Also,

2) No fee over $3.00 is charged for copying and distribution and

3) It is not modified in any way.




[ REGISTRATION FORM ]

Please print out the form below, complete it, and mail it, with your
registration fee, to:

Computer Typesetting
49 Stonegate Drive
Silver Spring, MD 2O9O4
Phone: (3O1) 384-596O


MBase version 2.1
-*- Registration Form -*-




Anthony T. Li makes no warranties, either expressed or implied, regarding
the MBase software program or its fitness for any particular purpose. He claims
no responsibility for any losses incurred or alleged to be caused by use of
this program. If you have a comment, complaint, or suggestion, feel free to
call Computer Typesetting.

This is a user-supported product. It is copyrighted 1988 by Anthony Li.
All rights are reserved by the author. You may use, copy and distribute
MBase version 2.1 provided that:

1) You register by sending $15.00, check or cash, to Computer
Typesetting and signing this agreement if you use this program
regularly,

2) No fee over $3.00 is charged for copying and distribution, and

3) It is not modified in any way.

Registration grants you free upgrades for a one-year time span from the
date of registration.

I have read the above registration agreement in full and hereby agree to
the terms provided:


Name: __________________________________________________________________


Address: _______________________________________________________________


City, State, Zip: ______________________________________________________


______________________________________________________


Phone Number: (____________) ____________ - ________________


Date: ________/ ________/ 19________



-*- THANK YOU FOR SUPPORTING MBASE! -*-


 December 28, 2017  Add comments

Leave a Reply