animal models play a critical role in biomedical research because of their experimental tractability and their genetic and physiological similarity to humans . as outlined by russell and burch ( 1959 ) ,
the generally accepted principles for the ethical use of animal models in research include the three  rs  : replace , reduce , and refine ( richmond 2000 ) .
effective data management is key for implementing the principle of using only those animals that are necessary for achieving the goals of a particular experimental design ( i.e. , reduce ) . despite the importance of data management
, many researchers use handwritten notebooks or spreadsheet applications for managing small- and medium - sized animal colonies .
such ad hoc data management approaches are simple to adopt but do not scale well and are error prone .
both paper records and spreadsheets are difficult for multiple people to access simultaneously , and paper records need to be physically moved from one location to another and can easily be misplaced .
in addition , data collected with such approaches are not amenable to searching , lack sophisticated data transaction controls , typically lack the use of controlled vocabularies or business rules , and are highly vulnerable to human error .
spreadsheets , in particular , are not well - suited for managing the complex data structures ( such as breeding schemes ) required for effective scientific data and colony management . according to silver ( 1995 ) ,
 an ideal record - keeping system would allow one to keep track of : ( 1 ) individual animals , their ancestors , siblings and descendants ; ( 2 ) matings between animals ; ( 3 ) litters born from such matings , and the individuals within litters that are used in experiments or to set up the next generation of matings ; and ( 4 ) experimental material ( tissues and dna samples ) obtained from individual animals . ideally , one would like to maintain records in a format that readily allows one to determine the relationship , if any , that exists between any two or more components of the colony , past or present .  a number of software solutions have been implemented that are specifically designed for the management of animal husbandry and phenotyping data .
existing software solutions for data management vary significantly in terms of cost , implementation requirements , flexibility , and level of user support .
a summary of some of the currently available mouse colony management applications , both commercial and academic , is provided in table  1.table  1examples of currently available colony management applicationsapplicationurllicense feeoperating systemsdata storageuser support and trainingcommentsbig bench mousehttp://www.bigbenchsoftware.com/$545 per seatwindows , macintoshpanoramauser guide and tutorialsmulti - user configurations possible .
fully functional software available for 30-day trialfacilityhttp://www.locustechnology.com / facility.htmlinformation not availableinformation not availableinformation not availablephone and email user support .
web - based and on - site trainingmouse trakkerhttp://www.cshl.edu / ott / html / mousetrakker.htmlinformation not availableinformation not availableinformation not availablefees include 20  h of consultinglicense allows unlimited number of users per laboratorymosaic vivariumhttp://www.virtualchemistry.com / vci / products / mosaicvivarium.aspxinformation not availableinformation not availableinformation not availablephone and email user supporthosted options availablemlimshttp://www.bioinforx.com / web / product_mlims.phpinformation not availableinformation not availableinformation not availablephone and email user support .
clients use web browser to access database via the web . designed for mouse and rat colony
managementscionhttp://www.topazti.com / products / scion.htminformation not availableinformation not availableinformation not availablephone and email user supportvillagerhttp://www.transgenic - software.com / default.htminformation not availablewindows 2000 , windows xporacle , sql server , or sybasephone and email user supportdesigned specifically for workflows associated with transgenic animal production and gene knockout projectsjcmshttp://colonymanagement.jax.org / freewindows , macintosh , web browserms access or mysqlphone and email user support . web - based user forums .
instructor - led course availablemiddleware required for web browser , macintosh , and handheld computersmausdbhttp://jupiter.helmholtz - muenchen.de / index.htmlfreelinux host with web browser interfacesmysqlphone and email user supportcan be adapted to work with multiple platforms and database enginesmouseekhttp://www.nervenet.org / main / databases.htmlfreewindows , macintoshfilemaker proemail user support .
web - based user forumson - line videos and tutorials available upon registrationmusdbhttp://www.brc.riken.jp / lab / gsc / mouse / freeinformation not availableoraclenonecustomized for the mutagenesis program at the riken institute . software customization requires software development expertise.macintosh and web supported by middleware examples of currently available colony management applications macintosh and web supported by middleware we describe here the jackson laboratory colony management system ( jcms ) .
jcms is a relational database application that was developed specifically to meet biomedical research community demands for a well - engineered flexible database system supporting mouse animal husbandry and data management .
jcms meets the criteria for an ideal record - keeping system as outlined by silver ( 1995 ) , with additional functionality that supports the management of experimentally derived data as well as standard animal husbandry data .
the application can also be configured for access via web browsers from pc , macintosh , or linux computers by incorporating a middleware solution ( discussed below ) into the setup .
the functional features of jcms include support for controlled vocabularies , multiuser capabilities , quick and accurate data reporting , pedigree tracking , animal husbandry workflow , sample tracking , and experimental data capture .
the expected benefits for users of jcms are improved vivaria efficiency , improved quality control for experimental studies , and flexible data reporting and retrieval .
the user community for the software has grown steadily since its initial release in 2005 ; there are currently over 900 active subscribers to the jcms user support list .
the jcms software application and associated tools and documentation are freely available from the project web site ( http://colonymanagement.jax.org/ ) .
the jcms web site includes an online discussion forum for users that is monitored by the jcms development team .
jcms employs a normalized relational data model that can be hosted on either microsoft access or mysql databases . the complete jcms data model is included with the application .
the relational data model that underlies jcms minimizes data redundancy , enforces data integrity , leverages controlled vocabularies , and enables accurate data retrieval against large data sets .
the software architecture for jcms allows for addition of new functionality and enhancement of existing functions without major modifications to the basic application infrastructure .
the extensibility of jcms ensures that the system can adapt readily to changing user needs .
the user interfaces for jcms have been implemented with the microsoft access graphical user interface ( gui ) design tool and powered with program code written in visual basic for applications .
transaction management control in the program code ensures safe multi - user concurrent data entry and editing .
jcms can be set up to run as a stand - alone database on a personal computer running windows or as a server to support small- to medium - sized work groups .
an overview of the three primary configurations for jcms is shown in fig .  1 .
in server configuration , jcms can be deployed using middleware solutions such as citrix presentation manger and deployed from a web interface and accessed from a computer running the macintosh , linux , or windows operating system .
macintosh users can also use microsoft windows pc virtualization software program such as parallels or vmware to run jcms directly on a modern intel macintosh computer .
any wireless internet - capable device with appropriate user authentication capabilities running a middleware session client ( such as citrix ) can run a jcms session .
handheld computers that have been tested with jcms include the symbol mc50 from motorola and the 7535g2 from psion teklogix .
the cost of hosting jcms will vary depending on the system configuration deployed and which middleware solution ( if any ) is used ; free middleware solutions such as sun microsystems virtualbox ( http://www.virtualbox.org/ ) are available and may be deployed for single - user configurations on macintosh computers .
middleware is only required for jcms to run on handheld devices and macintosh computers ( fig . 
( 1 ) jcms can be used as a stand - alone application for a single user , or ( 2 ) in a multi - user networked configuration .
the most flexible configuration , ( 3 ) shows jcms accessible via the web and accessed from multiple operating system platforms ( linux , windows or macintosh ) .   in the multi - user configuration examples ,
the black dots indicate that there may be any number of users , not just three users as depicted in the illustration illustration of the three primary installation configurations for the jcms application .
( 1 ) jcms can be used as a stand - alone application for a single user , or ( 2 ) in a multi - user networked configuration . the most flexible configuration , ( 3 ) shows jcms accessible via the web and accessed from multiple operating system platforms ( linux , windows or macintosh ) .   in the multi - user configuration examples ,
the black dots indicate that there may be any number of users , not just three users as depicted in the illustration
the jcms application is composed of four integrated software modules : ( 1 ) colony management , ( 2 ) experiment management , ( 3 ) sample tracking , and ( 4 ) reports and queries .
the jcms tool suite includes several supporting applications , including a pedigree tracking tool ( jpt ) , programs for upgrading to the latest released versions of jcms , and an application that converts existing jcms instances to use a mysql relational database management system ( rdbms ) .
gui forms are used to add data to the database , edit existing database records , or as a template for database queries and reports .
the jcms user guide includes a section on  getting started  with jcms that highlights key aspects of the setup process .
the first step in configuring the jcms application is to specify the roles of the individuals who will be using the software ( see the jcms security model subsection below for descriptions of the concept of user roles ) .
if used as a stand - alone software application for a single user , jcms can be easily installed without special networking skills or knowledge . if used in one of the multiclient modes ( fig .  1 )
once the software is configured and launched , the user is presented with a function bar that provides access to the software modules . the main function bar and two of the jcms data entry forms , add mouse and edit mouse , are shown in fig . 
2screen shots of the jcms welcome page ( a ) , main function bar ( b ) and forms for adding ( c ) and editing ( d ) information about mice .  
function buttons are designed to support numerous workflows and are organized by task on the function bar screen shots of the jcms welcome page ( a ) , main function bar ( b ) and forms for adding ( c ) and editing ( d ) information about mice .  
function buttons are designed to support numerous workflows and are organized by task on the function bar although all of the jcms functions are readily accessible from the function bar , a typical jcms user will use a subset of the jcms functions ( forms ) to support their daily workflow and functionality requirements .
figure  3 illustrates a typical animal breeding workflow with optional data entry and report steps .
for example , the design - mating form allows users to plan matings and record them in the database in advance of implementing the actual matings in the mouse room .
it is equally acceptable to skip the design step and record matings in the database after they are implemented .
data on litters may be recorded at the time of birth or when the pups are weaned.fig . 
optional database entry tasks ( design mating , and record litters ) and reports ( check mating , wean work ) are shown with dashed outline .
wean work reports can only be generated if the jcms user records litters when they are observed in the mouse room .
regardless of which jcms functions used , the mouse room activities ( illustrated as trapezoids ) are the same in each workflow .   some database entry steps ( illustrated as rectangles with solid boarders )
are required in the workflow to ensure the colony data are stored in the jcms database typical animal husbandry workflow supported by jcms .   optional database entry tasks ( design mating , and record litters ) and reports ( check mating , wean work ) are shown with dashed outline . wean work reports can only be generated if the jcms user records litters when they are observed in the mouse room .
regardless of which jcms functions used , the mouse room activities ( illustrated as trapezoids ) are the same in each workflow .   some database entry steps ( illustrated as rectangles with solid boarders )
are required in the workflow to ensure the colony data are stored in the jcms database jcms allows users to design and print cage cards with information derived from the database about the mice housed in the cage ( fig . 
cage numbers printed on each card may be bar - coded and allow users to track information from the cage back to the database .
three classes of cage cards are defined : ( 1 ) mating cards that list litter numbers and pertinent information about the parental mice in the mating ( e.g. , genotype , strain , and sex ) , ( 2 ) detail cards that list information about each individual mouse housed in a cage , and ( 3 ) wean cards that are designed for groups of mice housed together from the same litter .
new designs for cage cards are submitted periodically by the jcms user community and distributed with updates to the application.fig . 
cage cards can be custom formatted in any size or layout orientation that is supported by the printer an example cage card for a cage holding three mice .
cage cards can be custom formatted in any size or layout orientation that is supported by the printer the jcms colony management module the central entity of the jcms colony management module is the mouse .
every entity in this module ( e.g. , mating , litter ) has a relationship with the mouse table which facilitates complete pedigree tracking over unlimited breeding generations ( from matings to litters to mouse ) , timed matings ( plug dates ) , genotype tracking , mouse scheduling , and tracking mouse caging . leveraging the jcms extensible data architecture ,
design efforts are underway to extend the data model such that the central entity is  organism  rather than mouse .
this change in the underlying model for jcms will enable future versions of the application to be used with other model organisms , including rat and zebrafish .
animal husbandry workflows are supported by form - driven user interfaces with controlled data entry points .
for example , a mating trio is entered into jcms by selecting dams and sires from pulldown menus .
litter strain and breeding generation terms can be calculated to reduce the potential for data entry errors .
the jcms experimental data module jcms includes an experiment management module that allows users to link mice to experiments , group tests into experiment plans ( i.e. , protocols ) , and associate experimental data with a specific mouse and test .
experiment plans are composed of one or more scheduled experiment tests . for each experiment test
there is a user - configurable data descriptor record that defines the data type ( integer , text ) , names , and limit constraints of each data element in an experimental data record .
when a test is conducted , the data are entered manually or bulk loaded into jcms . to load experimental data into the database
, users can use the bulk data - load operations in jcms that support both flexible file format specification and preload data - checking scripts .
preload data checking verifies that data records are complete , associated with mouse records , and have not already been loaded and that data values are within appropriate ranges .
a data review report is generated by the system before data are loaded into the database .
data loads are transactional , so either all valid records load correctly , or the entire transaction is rolled back .
future development of the jcms application will include associating input parameters with tests ( such as test setup specifications ) , creating the concept of a data group so that many data records can be analyzed as one measurement ( e.g. , time - course data ) , scheduling treatment , and developing the ability to associate experimental records with samples as well as mice .
the jcms sample tracking module in jcms , a sample is a unit of biological material associated with mouse , mating , or litter records in the database .
samples may be divided into subcollections ( e.g. , multiple histology slides derived from a single mouse lung ) .
sample attributes such as type of sample , weight , collection date , collection method , preservation method , and age of mouse at time of collection are associated with each sample record .
sample storage locations are user - defined hierarchies and can be configured to arbitrary levels of specificity .
, jcms supports arbitrary numbers of storage units and definition of the structure within the units to any level of detail .
figure  5 illustrates a sample hierarchy with one facility ( there can be many facilities ) and several rooms with aisles and freezers in the each room .
the sample tracking module allows one to easily locate specific samples or generate inventory reports for storage facilities.fig . 
the left panel is the navigation tree ;   in the right panel is a list of all samples stored in the selected node . if the  recurse 
checkbox is selected , all samples in the selected node and all sub - nodes are displayed ( as in the above diagram , where all samples in isle-1 are displayed the jcms sample storage browser .
the left panel is the navigation tree ;   in the right panel is a list of all samples stored in the selected node . if the  recurse  checkbox is selected , all samples in the selected node and all sub - nodes are displayed ( as in the above diagram , where all samples in isle-1 are displayed jcms reports and queries jcms provides extensive reporting capabilities for colony managers and investigators conducting experiments .
two ad - hoc report forms allow users to design their own reports from an extensive set of data filters and data output options ( fig
jcms also provides a number of precompiled work reports to help guide mouse - room activities , including weaning , timed matings , mouse line viability monitoring , and mouse testing .
6ad - hoc mouse query form and an example output table . in this example query
we have selected live mice with ids that have ex in the name and are in the stock igf1<tm1ts>/imj strain .
the report output fields are selected by check - box selection on the right side of the form .
the remaining fields on the form are query filters which allow the user to apply highly specific criteria for the report output .
this query form also allows the user to press a button and associate groups of mice with experiments ad - hoc mouse query form and an example output table . in this example query
we have selected live mice with ids that have ex in the name and are in the stock igf1<tm1ts>/imj strain .
the report output fields are selected by check - box selection on the right side of the form .
the remaining fields on the form are query filters which allow the user to apply highly specific criteria for the report output .
this query form also allows the user to press a button and associate groups of mice with experiments the jcms pedigree tracking tool ( jpt ) the jcms tool suite includes a separate application called the jcms pedigree tracking tool that connects to any jcms database and graphically displays pedigree trees ( fig . 
the jpt can also produce html or text formatted files for future reference or analysis .
jpt allows you to select any mouse i d and draw an ancestor or progeny tree using the selected mouse as the focal point . for each mouse
litter number tor progeny or mating number for ancestor can also be optionally displayed in the pedigree tree.fig . 
7jpt ancestor tree for mouse bw - l160 - 6 . from right to left , each generation is represented by columns .
thus , mouse bw_1w0001 and bw_1w0006 are parents of mouse bw - l160 - 6 and br_wr002 and hh - w0004 are grandparents .  
br_wr0002 has three parent mouse records ( trio mating ) : hh - w0002 , hh - w0003 , and hh - w0004 .
genotype , sex , and strain information are also displayed for each mouse in the tree .
the bottom panel shows details for selected mouse jpt ancestor tree for mouse bw - l160 - 6 . from right to left , each generation is represented by columns .
thus , mouse bw_1w0001 and bw_1w0006 are parents of mouse bw - l160 - 6 and br_wr002 and hh - w0004 are grandparents .  
br_wr0002 has three parent mouse records ( trio mating ) : hh - w0002 , hh - w0003 , and hh - w0004 .
genotype , sex , and strain information are also displayed for each mouse in the tree .
the bottom panel shows details for selected mouse the implementation and use of controlled vocabularies is an essential element of good data management practice and facilitates accurate and complete data access and retrieval .
jcms is distributed with some commonly accepted vocabulary terms such as coat color , gene class , and strain .
future releases will include more vocabularies in the distribution such as terms from the mouse anatomical dictionary ( http://www.informatics.jax.org/searches/anatdict_form.shtml ) .
the designated jcms administrator ( see  jcms security model  below ) has control over the terms that are used in the jcms database and may add or remove terms as needed . by limiting edit privileges for controlled vocabularies
, jcms provides an important tool for lab managers to ensure consistent common annotations for all mice in the database .
the jcms supports a simple security model that provides for three levels of security clearance for modifying existing data and/or adding new data records .
jcms owners are allowed to enter mice , matings , litters , experiments , samples , and any associated data .
every mouse , sample , and experimental data record in jcms is associated with an owner .
an owner can edit his / her data but can not edit other owners data .
it is also possible for one owner to be a secretary of another owner , thereby having data edit capabilities for someone else s data . at the main application level , each form is configurable to have one of three security access levels : mtsadmin , owner , or secretary .
the jcms application is composed of four integrated software modules : ( 1 ) colony management , ( 2 ) experiment management , ( 3 ) sample tracking , and ( 4 ) reports and queries .
the jcms tool suite includes several supporting applications , including a pedigree tracking tool ( jpt ) , programs for upgrading to the latest released versions of jcms , and an application that converts existing jcms instances to use a mysql relational database management system ( rdbms ) .
gui forms are used to add data to the database , edit existing database records , or as a template for database queries and reports .
the jcms user guide includes a section on  getting started  with jcms that highlights key aspects of the setup process .
the first step in configuring the jcms application is to specify the roles of the individuals who will be using the software ( see the jcms security model subsection below for descriptions of the concept of user roles ) .
if used as a stand - alone software application for a single user , jcms can be easily installed without special networking skills or knowledge . if used in one of the multiclient modes ( fig .  1 )
once the software is configured and launched , the user is presented with a function bar that provides access to the software modules . the main function bar and two of the jcms data entry forms , add mouse and edit mouse , are shown in fig . 
2screen shots of the jcms welcome page ( a ) , main function bar ( b ) and forms for adding ( c ) and editing ( d ) information about mice .  
function buttons are designed to support numerous workflows and are organized by task on the function bar screen shots of the jcms welcome page ( a ) , main function bar ( b ) and forms for adding ( c ) and editing ( d ) information about mice .  
function buttons are designed to support numerous workflows and are organized by task on the function bar although all of the jcms functions are readily accessible from the function bar , a typical jcms user will use a subset of the jcms functions ( forms ) to support their daily workflow and functionality requirements .
figure  3 illustrates a typical animal breeding workflow with optional data entry and report steps .
for example , the design - mating form allows users to plan matings and record them in the database in advance of implementing the actual matings in the mouse room .
it is equally acceptable to skip the design step and record matings in the database after they are implemented .
data on litters may be recorded at the time of birth or when the pups are weaned.fig . 
optional database entry tasks ( design mating , and record litters ) and reports ( check mating , wean work ) are shown with dashed outline .
wean work reports can only be generated if the jcms user records litters when they are observed in the mouse room .
regardless of which jcms functions used , the mouse room activities ( illustrated as trapezoids ) are the same in each workflow .   some database entry steps ( illustrated as rectangles with solid boarders )
are required in the workflow to ensure the colony data are stored in the jcms database typical animal husbandry workflow supported by jcms .   optional database entry tasks ( design mating , and record litters ) and reports ( check mating , wean work ) are shown with dashed outline . wean work reports can only be generated if the jcms user records litters when they are observed in the mouse room .
regardless of which jcms functions used , the mouse room activities ( illustrated as trapezoids ) are the same in each workflow .   some database entry steps ( illustrated as rectangles with solid boarders )
are required in the workflow to ensure the colony data are stored in the jcms database jcms allows users to design and print cage cards with information derived from the database about the mice housed in the cage ( fig . 
cage numbers printed on each card may be bar - coded and allow users to track information from the cage back to the database .
three classes of cage cards are defined : ( 1 ) mating cards that list litter numbers and pertinent information about the parental mice in the mating ( e.g. , genotype , strain , and sex ) , ( 2 ) detail cards that list information about each individual mouse housed in a cage , and ( 3 ) wean cards that are designed for groups of mice housed together from the same litter .
new designs for cage cards are submitted periodically by the jcms user community and distributed with updates to the application.fig . 
cage cards can be custom formatted in any size or layout orientation that is supported by the printer an example cage card for a cage holding three mice .
cage cards can be custom formatted in any size or layout orientation that is supported by the printer the jcms colony management module the central entity of the jcms colony management module is the mouse .
every entity in this module ( e.g. , mating , litter ) has a relationship with the mouse table which facilitates complete pedigree tracking over unlimited breeding generations ( from matings to litters to mouse ) , timed matings ( plug dates ) , genotype tracking , mouse scheduling , and tracking mouse caging . leveraging the jcms extensible data architecture ,
design efforts are underway to extend the data model such that the central entity is  organism  rather than mouse .
this change in the underlying model for jcms will enable future versions of the application to be used with other model organisms , including rat and zebrafish .
animal husbandry workflows are supported by form - driven user interfaces with controlled data entry points .
for example , a mating trio is entered into jcms by selecting dams and sires from pulldown menus .
litter strain and breeding generation terms can be calculated to reduce the potential for data entry errors .
the jcms experimental data module jcms includes an experiment management module that allows users to link mice to experiments , group tests into experiment plans ( i.e. , protocols ) , and associate experimental data with a specific mouse and test .
experiment plans are composed of one or more scheduled experiment tests . for each experiment test
there is a user - configurable data descriptor record that defines the data type ( integer , text ) , names , and limit constraints of each data element in an experimental data record .
when a test is conducted , the data are entered manually or bulk loaded into jcms . to load experimental data into the database
, users can use the bulk data - load operations in jcms that support both flexible file format specification and preload data - checking scripts .
preload data checking verifies that data records are complete , associated with mouse records , and have not already been loaded and that data values are within appropriate ranges .
a data review report is generated by the system before data are loaded into the database .
data loads are transactional , so either all valid records load correctly , or the entire transaction is rolled back .
future development of the jcms application will include associating input parameters with tests ( such as test setup specifications ) , creating the concept of a data group so that many data records can be analyzed as one measurement ( e.g. , time - course data ) , scheduling treatment , and developing the ability to associate experimental records with samples as well as mice .
the jcms sample tracking module in jcms , a sample is a unit of biological material associated with mouse , mating , or litter records in the database .
samples may be divided into subcollections ( e.g. , multiple histology slides derived from a single mouse lung ) .
sample attributes such as type of sample , weight , collection date , collection method , preservation method , and age of mouse at time of collection are associated with each sample record .
sample storage locations are user - defined hierarchies and can be configured to arbitrary levels of specificity .
, jcms supports arbitrary numbers of storage units and definition of the structure within the units to any level of detail .
figure  5 illustrates a sample hierarchy with one facility ( there can be many facilities ) and several rooms with aisles and freezers in the each room .
the sample tracking module allows one to easily locate specific samples or generate inventory reports for storage facilities.fig . 
the left panel is the navigation tree ;   in the right panel is a list of all samples stored in the selected node . if the  recurse 
checkbox is selected , all samples in the selected node and all sub - nodes are displayed ( as in the above diagram , where all samples in isle-1 are displayed the jcms sample storage browser .
the left panel is the navigation tree ;   in the right panel is a list of all samples stored in the selected node . if the  recurse  checkbox is selected , all samples in the selected node and all sub - nodes are displayed ( as in the above diagram , where all samples in isle-1 are displayed jcms reports and queries jcms provides extensive reporting capabilities for colony managers and investigators conducting experiments .
two ad - hoc report forms allow users to design their own reports from an extensive set of data filters and data output options ( fig
jcms also provides a number of precompiled work reports to help guide mouse - room activities , including weaning , timed matings , mouse line viability monitoring , and mouse testing .
6ad - hoc mouse query form and an example output table . in this example query
we have selected live mice with ids that have ex in the name and are in the stock igf1<tm1ts>/imj strain .
the report output fields are selected by check - box selection on the right side of the form .
the remaining fields on the form are query filters which allow the user to apply highly specific criteria for the report output .
this query form also allows the user to press a button and associate groups of mice with experiments ad - hoc mouse query form and an example output table . in this example query
we have selected live mice with ids that have ex in the name and are in the stock igf1<tm1ts>/imj strain .
the report output fields are selected by check - box selection on the right side of the form .
the remaining fields on the form are query filters which allow the user to apply highly specific criteria for the report output .
this query form also allows the user to press a button and associate groups of mice with experiments the jcms pedigree tracking tool ( jpt ) the jcms tool suite includes a separate application called the jcms pedigree tracking tool that connects to any jcms database and graphically displays pedigree trees ( fig . 
the jpt can also produce html or text formatted files for future reference or analysis .
jpt allows you to select any mouse i d and draw an ancestor or progeny tree using the selected mouse as the focal point . for each mouse
litter number tor progeny or mating number for ancestor can also be optionally displayed in the pedigree tree.fig . 
7jpt ancestor tree for mouse bw - l160 - 6 . from right to left , each generation is represented by columns .
thus , mouse bw_1w0001 and bw_1w0006 are parents of mouse bw - l160 - 6 and br_wr002 and hh - w0004 are grandparents .  
br_wr0002 has three parent mouse records ( trio mating ) : hh - w0002 , hh - w0003 , and hh - w0004 .
genotype , sex , and strain information are also displayed for each mouse in the tree .
the bottom panel shows details for selected mouse jpt ancestor tree for mouse bw - l160 - 6 . from right to left , each generation is represented by columns .
thus , mouse bw_1w0001 and bw_1w0006 are parents of mouse bw - l160 - 6 and br_wr002 and hh - w0004 are grandparents .  
br_wr0002 has three parent mouse records ( trio mating ) : hh - w0002 , hh - w0003 , and hh - w0004 .
genotype , sex , and strain information are also displayed for each mouse in the tree .
the implementation and use of controlled vocabularies is an essential element of good data management practice and facilitates accurate and complete data access and retrieval .
jcms is distributed with some commonly accepted vocabulary terms such as coat color , gene class , and strain .
future releases will include more vocabularies in the distribution such as terms from the mouse anatomical dictionary ( http://www.informatics.jax.org/searches/anatdict_form.shtml ) . the designated jcms administrator ( see  jcms security model 
below ) has control over the terms that are used in the jcms database and may add or remove terms as needed . by limiting edit privileges for controlled vocabularies
, jcms provides an important tool for lab managers to ensure consistent common annotations for all mice in the database .
the jcms supports a simple security model that provides for three levels of security clearance for modifying existing data and/or adding new data records .
jcms owners are allowed to enter mice , matings , litters , experiments , samples , and any associated data .
every mouse , sample , and experimental data record in jcms is associated with an owner .
an owner can edit his / her data but can not edit other owners data .
it is also possible for one owner to be a secretary of another owner , thereby having data edit capabilities for someone else s data . at the main application level , each form is configurable to have one of three security access levels : mtsadmin , owner , or secretary .
the jcms web site ( http://colonymanagement.jax.org ) provides access to several resources for jcms users .
all jcms tools are posted on the web site for download , including the jcms application , the upgrade utilities for mysql and microsoft access , the pedigree tracker , cage card templates , tutorials , and the mysql conversion tool ( access to mysql ) .
each new release of jcms is accompanied with two upgrade programs ( one for mysql users and one for access users ) .
the jcms upgrade utility installs the new jcms application , upgrades the database schema , and migrates data as necessary so that existing jcms users can take advantage of the latest jcms release features without loss of data .
user support for jcms is provided through a group email list and a monitored community electronic discussion forum ( http://community.jax.org/forums/default.aspx?groupid=7 ) .
the jcms web site also includes an faq page that addresses most common issues with installation and use of the application .
problems that are not quickly resolved via email are followed up with a telephone call from a member of the jcms development team .
the jackson colony management system ( jcms ) is designed to meet a wide variety of colony management and phenotype data management needs for small- to medium - sized laboratories and work groups .
jcms provides a carefully crafted data management solution that can increase both workflow efficiency and data security and thus produce significant cost savings and enhanced scientific results .
the application can be downloaded , installed , administered , and run with minimal technical expertise .
jcms is unique among the current offerings for colony management software because it is both free and well supported .
a training database with courses , a comprehensive user guide , and online support is readily available at the jcms web site .
the application was designed with extensive input from end users and new features and functionality are driven , in large part , by user requests .
the jcms core design was engineered to be extensible , allowing for continued upgrades in both functionality and technology .
major areas of planned new functionality for jcms include support for additional model organisms ( e.g. , zebrafish , rat ) , enhanced vivaria management functions ( e.g. , cage tracking ) , and support for associating samples with specific experiments .
near - term releases of the jcms application will include new cage management functions with historical usage reporting , support for assisted reproductive technology matings ( e.g. , in vitro fertilization ) , and advanced experimental data management functionality .
longer - term plans for jcms development include implementing support for multiple workgroups sharing a single jcms instance and support for complete transaction logging capabilities as recommended in the federal drug administration s good laboratory practices guidelines for nonclinical laboratory studies ( glp ; http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfcfr/cfrsearch.cfm?cfrpart=58 ) .
the next - generation jcms design will leverage open - source technologies such as jboss , mysql , and java to deliver an easy - to - deploy , platform - independent application capable of being hosted on macintosh or pc computers with web browser user interfaces that can be deployed without concern for software licensing issues .
 the jackson laboratory colony management system ( jcms ) is a software application for managing data and information related to research mouse colonies , associated biospecimens , and experimental protocols . 
 jcms runs directly on computers that run one of the pc windows operating systems , but can be accessed via web browser interfaces from any computer running a windows , macintosh , or linux operating system . 
 jcms can be configured for a single user or multiple users in small- to medium - size work groups . 
 the target audience for jcms includes laboratory technicians , animal colony managers , and principal investigators . 
 the application provides operational support for colony management and experimental workflows , sample and data tracking through transaction - based data entry forms , and date - driven work reports . 
 flexible query forms allow researchers to retrieve database records based on user - defined criteria . 
 recent advances in handheld computers with integrated barcode readers , middleware technologies , web browsers , and wireless networks add to the utility of jcms by allowing real - time access to the database from any networked computer . 
Introduction
Materials
Methods and design
JCMS application overview
Management of controlled vocabularies
JCMS security model
Software availability and user support
Discussion