Supporting Data Management

This section covers the foundational data that supports your music library: instruments, ensembles, genres, paper sizes, and part types. Understanding and properly managing this data is essential for effective library organization.

Table of contents

• Overview of Supporting Data
• Instruments
• Ensembles
• Genres
• Paper Sizes
• Part Types
• Best Practices

---

Why supporting data matters

Supporting data forms the foundation of an effective music library management system. When properly configured, this foundational information ensures consistency across all data entry, creating uniform standards that make your library reliable and professional. This organization becomes particularly valuable when generating reports and statistics, as meaningful analysis depends on consistent categorization and standardized terminology. Perhaps most importantly, properly configured supporting data streamlines the workflow for adding new compositions, reducing the time and effort required while minimizing errors that can occur when librarians must create new categories or classifications on the fly.

Describing supporting data

These are the settings that support all your other data entry. You typically set up these configurations once when first organizing your library, and they rarely need regular updates afterward. However, it’s important to configure these properly before adding compositions and parts, as they provide the structure and organization for everything else in your system. For example, before you can enter information about a part, you must find a part type. Before you create a part type, you assign it to one or more instruments.

• Paper sizes: Track the physical dimensions of your sheet music using standard and custom paper size definitions from this page. You record measurements for proper inventory management and storage organization, ensuring you know exactly what size folders or storage systems you need for each piece, and potentially how much storage space your library requires.
• Ensembles: Define the different performing groups in your organization such as Concert Band, Wind Ensemble, Brass Quintet, or String Orchestra through this page. You use these ensemble categories to tag compositions, indicating which groups can perform specific pieces. This helps users find repertoire appropriate for their particular ensemble configuration.
• Instruments: Maintain the master list of all instruments available in your organization using this page. You can organize instruments by family groups and set their orchestral collation order to ensure consistent presentation throughout the system. This helps standardize how instruments appear in reports and part assignments.
• Part Types: Define the types of instrument parts used in your compositions through this page. You create entries like “Flute 1”, “Trumpet 2”, and “Percussion” while setting their orchestral order, assigning default instruments, and organizing them by family. This setup is crucial because you must have part types defined before you can add individual parts to any compositions in your library.
• Genres: Set up your music classification system using categories like March, Jazz, Transcription, Holiday, or Pop from this page. You assign genres to compositions to help organize and filter your collection by musical style, making it easier for users to find pieces that fit their programming needs.
• Sections: Group your part types into logical sections such as Brass, Woodwinds, Percussion, and Strings through this page. You can assign section leaders and organize large ensembles more effectively by creating these groupings, which helps with rehearsal planning and music distribution.

Database overview

The following diagram shows how all the database tables relate to each other, helping you understand the complete data structure:

Figure 2: Complete database schema showing relationships between all tables

Key Relationships:

• Supporting data (orange) contains the main musical library data
• Performance data (purple) tracks concerts, programs, and recordings
• System tables (green) manage users, security, and downloads

---

Instruments

purpose of Instrument Management

The instrument list defines all possible instruments that can be assigned to musical parts. This creates consistency in naming and enables effective searching and filtering.

viewing Instruments

1. Navigate to MATERIALS > Instruments
2. Browse the complete list of available instruments
3. Use the search/filter to find specific instruments
4. View instrument categories and groupings

Figure 2: Instrument management interface

adding New Instruments

For Librarians and Managers:

1. Click “Add Instrument”
2. Fill in instrument details:
   • Name: Full instrument name (e.g., “Clarinet in B♭”)
   • Short name: Abbreviated version (e.g., “Cl”)
   • Category: Instrument family (woodwinds, brass, etc.)
   • Sort order: Position in lists
   • Active status: Whether to show in selections
3. Save the new instrument

Figure 3: Form for adding new instruments

instrument Categories

Common categories include:

• Woodwinds: Flutes, clarinets, saxophones, oboes, bassoons
• Brass: Trumpets, horns, trombones, tubas
• Percussion: Timpani, mallet instruments, auxiliary percussion
• Strings: Violin, viola, cello, bass (if applicable)
• Other: Piano, harp, electronics, vocals

managing Instrument Names

Best Practices:

• Use standard instrument names
• Include key/pitch designations (e.g., “Horn in F”)
• Be consistent with abbreviations
• Consider international naming conventions
• Include numbered parts (e.g., “Trumpet 1”, “Trumpet 2”)

---

Ensembles

purpose of Ensemble Management

Ensembles define which musical groups use your library. This helps organize compositions by intended performing group and manage access permissions.

common Ensemble Types

• Wind Ensemble: Standard concert band instrumentation
• Symphony Orchestra: Full orchestral forces
• Chamber Groups: Small ensembles (quintet, sextet, etc.)
• Jazz Ensemble: Big band and jazz combo arrangements
• Marching Band: Field show and parade music
• Choir: Vocal ensembles

adding Ensembles

1. Navigate to MATERIALS > Ensembles
2. Click “Add Ensemble”
3. Enter ensemble information:
   • Name: Full ensemble name
   • Short name: Abbreviation
   • Description: Details about the group
   • Active status: Whether currently in use

Figure 4: Ensemble setup and configuration

ensemble Assignment

• Compositions are typically assigned to one primary ensemble
• Some pieces may be suitable for multiple ensembles
• Assignment affects search filtering and organization
• Users may have access restricted by ensemble membership

---

Genres

purpose of Genre Classification

Genres help categorize musical styles and make it easier for users to find appropriate repertoire for their needs.

standard Genre Categories

Common genres include:

Concert Music

• Wind Ensemble: Standard concert band repertoire
• Symphonic Transcription: Orchestra pieces arranged for band
• Contemporary: Modern classical compositions
• Light Classical: Accessible classical works

Popular and Seasonal

• March: Military and concert marches
• Christmas: Holiday and seasonal music
• Pop/Show Tunes: Popular and Broadway arrangements
• Film Music: Movie soundtrack arrangements

Educational and Functional

• Method Book: Educational materials
• Warm-up: Exercises and technical studies
• Ceremonial: Processionals, hymns, patriotic music

managing Genres

1. Go to MATERIALS > Genres
2. Review existing categories
3. Add new genres as needed for your collection
4. Organize by frequency of use

Figure 5: Genre categories and their organization

---

Paper sizes

purpose of Paper Size Tracking

Paper sizes help librarians manage physical storage, copying, and distribution of printed music.

common Paper Sizes

• Folio (9” x 12”): Most common for band and orchestral music
• Letter (8.5” x 11”): Standard copy paper size
• Legal (8.5” x 14”): Extended length for complex scores
• Tabloid (11” x 17”): Large format for full scores
• A4 (210mm x 297mm): International standard
• Custom sizes: For special or historical materials

paper Size Management

1. Navigate to MATERIALS > Paper Sizes
2. View existing size definitions
3. Add custom sizes if needed
4. Set default sizes for different types of music

Figure 6: Paper size definitions and settings

impact on Library Management

• Storage planning: Calculate shelf space requirements
• Copying costs: Different sizes have different costs
• Distribution: Affects packaging and mailing
• Digital scanning: Determines scan settings and file sizes

---

Part types

purpose of Part Type Classification

Part types categorize the different kinds of musical parts and materials in your library.

common Part Types

• Individual Parts: Single instrument parts
• Condensed Score: Reduced score for conductor reference
• Full Score: Complete conductor’s score
• Piano Reduction: Piano accompaniment version
• Vocal Parts: Choral or solo vocal lines
• Method Materials: Educational and exercise materials

managing Part Types

1. Go to MATERIALS > Part Types
2. Review current categories
3. Add specialized types for your collection
4. Set ordering preferences for display

Figure 7: Part type categories and configuration

part Type Applications

• Inventory tracking: Know what materials you have
• Distribution planning: Different types have different distribution needs
• Access control: Some types may be restricted to certain users
• Workflow organization: Different processes for different part types

---

Best practices

data Consistency

• Standardize naming conventions across all supporting data
• Use complete, descriptive names rather than abbreviations when possible
• Be consistent with capitalization and punctuation
• Consider future needs when creating categories

regular Maintenance

• Review supporting data periodically for accuracy and completeness
• Remove unused categories to keep lists manageable
• Update names and descriptions as standards evolve
• Document decisions about naming and categorization

user Training

• Train all librarians on proper use of supporting data
• Create quick reference guides for common categories
• Establish approval processes for adding new categories
• Share decisions with all users who enter data

integration Considerations

• Plan for data imports from other systems
• Consider export needs for reports and analysis
• Think about integration with other music software
• Plan for system migrations and data preservation

Figure 8: Workflow for maintaining supporting data quality

---

Impact on library operations

search and Discovery

Well-organized supporting data enables:

• Precise filtering by instrument, genre, or ensemble
• Consistent search results across different users
• Predictable navigation through the library
• Effective recommendation systems

reporting and Analysis

Good supporting data supports:

• Usage statistics by category
• Collection analysis and gap identification
• Planning reports for acquisitions
• Performance tracking by ensemble or genre

workflow Efficiency

Proper setup enables:

• Faster data entry with predictable choices
• Reduced errors through standardized options
• Streamlined processes for adding new materials
• Consistent user experience across the system

---

Getting help

common Questions

• Missing instruments: Contact your librarian to add new instruments
• Genre classifications: Discuss with other librarians for consistency
• Paper size questions: Check with administrators about standards
• Part type confusion: Review examples and ask for clarification

who to Ask

• System setup: Managers and administrators
• Music-specific questions: Experienced librarians
• Technical issues: System administrators
• Policy questions: Organizational leadership

---

Next steps

With supporting data properly configured:

1. Learn Composition Management - Add and edit musical works
2. Explore Parts Management - Handle individual parts and files
3. Review Search Features - Use your organized data for better searching

---

Continue to the next section: Compositions to learn about managing musical works and their metadata.