-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have charged with writing a ruby-on-rails (RoR) web app for reporting usage statistics that we supply to end users. I have written one that we currently use, but the data comes from a different scheduler/resource manager system. We do not currently use slurm, but it is under very active testing, and so far we have not encountered any deal-breakers that would prevent us from adopting slurm, hence my assignment.
Outside of the slurm source, and simply examining the tables and their columns in our MariaDB database, is there any documentation about the nature of the data stored, the table structures, the interrelationships (i.e., data integrity rules) between tables and the relationships between the two databases slurm_acct_db and slurm_jobcomp_db? Rather that hitting the two databases directly, I will probably do a nightly extract into a third database that de-normalizes the data somewhat (i.e., a data-warehouse), but I want to make sure that the data slurm captures is accurately reported. Any pointers would be gratefully appreciated. Charles - -- Charles Johnson, Vanderbilt University Advanced Computing Center for Research and Education 1231 18th Avenue South Hill Center, Suite 146 Nashville, TN 37212 Office: (615) 343-4134 Cell : (615) 478-7788 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJUZjLUAAoJEAk9vftsV0ONAiUP/1BI+ZfDX2leZ39OVydRvx+m Q76sbS+J1tMbhjC2dLOXA1gAVZ/PYqak4MmJueP4Deo/S1gwHCfG1kUf+Jl6c19U uf1MZi0kRnuAhPVBaydQT0aMxM4Lsg81+6HNBqUU0eTJZf58rogo6yNEaW1tBpaq jwmHXB93eCgOnJdI/R8x//37YvlckcpriP3ZuVvtbVrmd7HoeEEnn+U3JxZ9xuDH eAJ+/n+gVhD1c+Iqyrn3u23gtDBqONcVPwTu/HzzVaFFUjZLtG6nmdj/bAOjTbuQ hiN3ICViD4WrDomV5Dw6dxygg2Wy2YiHAza/sKT9gRdi3IHnjjE9odkbrVmJ09u6 6Or88OYHZ2cqic+bjyTHqlJDSEDZUCtqgzfIwdZQUjilGR4Fk+GWqvgvMRiJzQ4V d7DzLtKwV7OC2MNM4oUEMSIfl9JUebo0yxgsbRactrssYxiogbEqrPzpYC2dKqr4 Rlgk0B8m6/9bi8WVJ9/1xOthD5zXNLOaMLEJ7tjN2mLPGDQW8G3ZZ1s0ij3cQEax uGwHMG7uRH/cseiwa7aCSUWldeg6jdW0DN/frKElpW+VVz4lJhQzfhpb5SoUFeGU 1INOFtzRtNPhjdFsdE8KfQen+gzEldHXTn8gCJewZ3aQlGza94T9HHWL/9ua2EoH 5MTN21TIX0L26cVPJfoY =ubom -----END PGP SIGNATURE-----
