Components Version 2007 Version 2025
File Counts Comments File Counts Comments
MySQL Tables: 3 Tables 1 table for user profile; 2 tables for attached info (study fields by animal breeds; academic degrees) 6 Tables
  • From the previous: Removed 2 tables; Used data from 1 table
  • Re-reasoned logistics; Added 5 new tables
  • Improved data normalizations and indexing
Style Sheets: 22 7,558 Lines 1 98 Lines
Java scripts: 58 19,462 Lines 2 42 Lines
PHP scripts: 51 6,689 Lines 17 2,917 Lines
Image files: 125   10  
All files: 256 33,709 Lines 30 3,057 Lines
All sizes: 29 Mb Used "Bootstrap": a third party php/web framework 1.3 Mb Self-sufficient css + necessary JavaScripts
Developed: Nov. 2007 - Dec. 2009 Aug - Nov. 2025
IMPROVEMENTS
( highlight )		 Limited improvements (2023-2024):
  • Simplified data input form format by grouping fields
  • Attempted making one data form to dynamically serve multiple purpose: for self, and for others
  • Created multiple pedigree "certificate" templates to display self-data

    • "Improvements" was stuck due to logistic limitations poor data normalizations in the original database design

 Re-developments (2025-2026)
  • Added ability to allow adding pedigree data both directions: ancestors, or children
  • Added layers of user privileges, introduced 'curator' role
  • Made the graph generation an on-the-fly process (owing to improved data structure and indexing) which was not practically doable in the previous database version
  • More efficient and robust user authentications and management by coupling with AGRC Directory
  • Experimentally succeeded with Cytoscape and Graphiz dot drawing dynamic pedigree diagrams
  • Successfully draw full pedigree with Cytoscape and Graphiz dot on-the-fly (previously not possible due to query in-efficiencies under the old table structure)
  • Added user activity logs