Babase:

Technical Specifications for the Amboseli Baboon Project Data Management System

Jeanne Altmann, PhD.

Susan C. Alberts, PhD.

Jacob B. Gordon

Leah Gerber

ER Diagram conversion to Dia 

Leah Gerber

ER Diagram layout 

Karl O. Pinc

ER Diagram layout 

Anne Ndeti Hubbard

ER Diagram layout 

Anne Ndeti Hubbard

DocBook formatting 

Karl O. Pinc

DocBook formatting 

Document generated: 2024-03-06 15:02:16.

Copyright Notices

March 2, 2005


Acknowledgments

We gratefully acknowledge the support of the National Science Foundation for the supporting the collection of the majority of the data stored in the database; in the past decade in particular we acknowledge support from IBN 9985910, IBN 0322613, IBN 0322781, BCS 0323553, BCS 0323596, DEB 0846286, DEB 0846532 and DEB 0919200. We are also very grateful for support from the National Institute of Aging (R01AG034513-01 and P01AG031719) and the Princeton Center for the Demography of Aging (P30AG024361). We also thank the Chicago Zoological Society, the Max Planck Institute for Demographic Research, the L.S.B. Leakey Foundation and the National Geographic Society for support at various times over the years. In addition, we thank the National Institute of Aging (R03-AG045459-01) for supporting recent work extending the database to incorporate genetic and genomic data.

Any opinions, findings, conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation, the National Institute of Aging, the Princeton Center for the Demography of Aging, the Chicago Zoological Society, the Max Planck Institute for Demographic Research, the L.S.B. Leakey Foundation, the National Geographic Society, or any other organization which has supplied support for this work.

Table of Contents

1. Introduction
This Document
Conventions Used In This Document
A Guide for the Reader
System Design
To Start Babase
Other Resources
2. Babase System Architecture
Databases
The babase Database
The babase_copy Database
The babase_test Database
Users, Groups and Database Permissions
The babase_readers group
The babase_editors group
Schemas
The babase schema
The babase_something_views schemas
The babase_history schema
The babase_pending schema
The sandbox schema
The devel schema
The per-user schemas
Table Overview
The Sys_Period Column
Entity-Relationship Diagrams
Views
Special Values
Indexes
The Babase Program Code
3. Baboon Data: Primary Source Material
Group Membership and Life Events
ALTERNATE_SNAMES (Alternate Short Names)
BEHAVE_GAPS (Gaps in Behavior Observations)
BIOGRAPH (Baboon Biographical Data)
CENSUS (Group Membership)
CONSORTDATES (First Consortship Dates)
DEMOG (Demography Notes)
DISPERSEDATES (Dispersal Dates)
GROUPS (Groups)
MATUREDATES (Sexual Maturity Dates)
RANKDATES (Adult Rank Attainment Dates)
Physical Traits
WP_AFFECTEDPARTS (Body PARTS AFFECTED by Wounds/Pathologies)
WP_DETAILS (Wound/Pathology DETAILS)
WP_HEALUPDATES (Wound/Pathology HEAL UPDATES)
WP_OBSERVERS (Wound/Pathology OBSERVERS)
WP_REPORTS (Wound/Pathology REPORTS)
Sexual Cycles
CYCGAPS (Gaps in Female Cycle Observations)
CYCLES (Female Sexual Cycles)
CYCPOINTS (Female Sexual Cycle Events)
PREGS (Pregnancies)
REPRO_NOTES (Textual NOTES about REPROduction)
SEXSKINS (Sexskin Turgesence Measurements)
Social and Multiparty Interactions
ALLMISCS (Ad-libitum sample data)
CONSORTS (multiparty disputes over CONSORTshipS)
FPOINTS (Point data on Females)
INTERACT_DATA (Interactions)
MPIS (Multiparty InteractionS)
MPI_DATA (Multiparty dyadic Interactions)
MPI_PARTS (Multiparty Interaction PARTicipantS)
PARTS (Participants in interactions)
POINT_DATA (Point observation data)
NEIGHBORS (point observation data on Neighbors)
SAMPLES (all-occurrences Samples)
Darting
ANESTHS (Extra Sedation Administered During Darting)
BODYTEMPS (Darting Body Temperature Measurements)
CHESTS (Darting Chest Circumference Measurements)
CROWNRUMPS (Darting Crown-to-Rump Measurements)
DART_SAMPLES (Darting Tissue Sample Records)
DARTINGS (Baboon Darting Events)
DPHYS (Darting Physiological Measurements)
HUMERUSES (Darting Humerus Length Measurements)
PCVS (Darting Blood Measurements)
TEETH (Darting Tooth Data)
TESTES_ARC (Darting Testes circumference Data)
TESTES_DIAM (Darting Testes Diameter Data)
TICKS (Darting Tick and Parasite Data)
ULNAS (Darting Ulna Length Measurements)
VAGINAL_PHS (Darting Vaginal pH Measurements)
Inventory
LOCATIONS
NUCACID_CONC_DATA (NUCleic ACID CONCentration DATA)
NUCACID_CREATORS (NUCleic ACID CREATORS)
NUCACID_DATA (General information about NUCleic ACID samples)
NUCACID_LOCAL_IDS (LOCAL IDentifierS for NUCleic ACID samples)
NUCACID_SOURCES
POPULATIONS
TISSUE_DATA (General information about TISSUE samples)
TISSUE_LOCAL_IDS (LOCAL IDentifierS for TISSUE samples)
UNIQUE_INDIVS (All UNIQUE INDIVidualS)
SWERB Data (Group-level Geolocation Data)
AERIALS (Aerial photos)
GPS_UNITS (Individual GPS Devices)
QUAD_DATA (map Quadrants)
SWERB_BES (Begin/Ends: Uninterrupted bouts of group-level observation)
SWERB_DATA (Group Level GPS Point Samples)
SWERB_DEPARTS_DATA (Observation team departures from camp)
SWERB_DEPARTS_GPS (SWERB GPS Departure data)
SWERB_GWS (SWERB Grove and Waterholes)
SWERB_GW_LOC_DATA (SWERB Grove/Waterhole Location Data)
SWERB_LOC_DATA (LOCation-Specific DATA from GPS Points)
SWERB_LOC_GPS (Secondary Data for LOCations in GPS points)
SWERB_OBSERVERS
TREES
Weather Data
RAINGAUGES (Rain Measurements)
RGSETUPS (Rain Gauge Setups)
TEMPMINS (Minimum Temperature Measurements)
TEMPMAXS (Maximum Temperature Measurements)
DIGITAL_WEATHER (Digitally Collected Weather Data)
WREADINGS (Weather Readings)
4. Baboon Data: Analyzed
Darting
FLOW_CYTOMETRY
WBC_COUNTS (White Blood Cell Counts)
Group Membership and Life Events
DAD_DATA (Paternity analysis results)
MEMBERS (Day-by-day Group Membership)
RANKS (Rankings Within Groups)
RESIDENCIES (Group Residency, in bouts)
Physical Traits
HORMONE_KITS (KITS used to assay HORMONE concentration)
HORMONE_PREP_DATA (Lab PREParations performed on hormone samples)
HORMONE_PREP_SERIES (SERIES of Lab PREParations performed on hormone samples)
HORMONE_RESULT_DATA (RESULTs of HORMONE concentration assays)
HORMONE_SAMPLE_DATA (Tissue SAMPLEs used for HORMONE analysis)
HYBRIDGENE_ANALYSES
HYBRIDGENE_SCORES
SWERB Data
SWERB_LOC_DATA_CONFIDENCES
Interpolation
Interpolation's 3 Fundamentals
Interpolation Visualized
The Interpolation Rules
Expectations and Implications
The Social Group Residency Rules
Which Group?
The 15/29 test
The Residency Algorithm
The Sexual Cycle Day-By-Day Tables
CYCGAPDAYS (Day-by-day Periods of No Observation)
CYCSTATS (Female Fertility Cycle States)
MDINTERVALS (Mdate to Ddate Intervals)
MMINTERVALS (Mdate to Mdate Intervals)
REPSTATS (Female Reproductive States)
Sexual Cycle Determination
Automatic Sequencing
Automatic Mdate Generation
5. Support Tables
General Support Tables
BODYPARTS
LAB_PERSONNEL
OBSERVERS (Data Collection Staff)
OBSERVER_ROLES
UNKSNAMES (problem in identifying focal's neighbor or a lone male)
Group Membership and Life Events
BSTATUSES (Birth Accuracy Indicators)
CONFIDENCES (death cause (nature and agent), dispersal, and matgrp Confidence levels)
DAD_SOFTWARE
DCAUSES (Causes of Death)
DEMOG_REFERENCES (Demography Note References)
DEATHNATURES (Natures of Death Causes)
ENTRYTYPES (Categories of Entry to Study Population)
GAP_END_STATUSES (Explanations for Behavior Gap Ends)
MSTATUSES (Maturity Marker Statuses)
DAD_DATA_COMPLETENESS (Completeness Scores in Paternity Analyses)
DAD_DATA_MISMATCHES (Types of Genetic Mismatches)
RNKTYPES (Ranking Categories)
STATUSES (Indicators of Record and Baboon Vividity)
Physical Traits
HORMONE_IDS
HORMONE_PREP_PROCEDURES
HYBRIDGENE_SOFTWARE
MARKERS
WP_HEALSTATUSES
WP_REPORTSTATES
WP_WOUNDPATHCODES
Social And Multiparty Interactions
ACTIVITIES
ACTS (Interaction Types)
DATA_STRUCTURES (Data structures produced by Psion devices)
CONTEXT_TYPES (multiparty Interaction Context Categories)
FOODCODES (Food item Codes)
FOODTYPES (Food Types)
KIDCONTACTS (spatial relationship between mother and infant)
MPIACTS (Multiparty Interaction Types)
NCODES (Neighbor classifications)
PARTUNKS (problem identifying a multiparty interaction participant)
POSTURES
PROGRAMIDS (Program used on the device)
SAMPLES_COLLECTION_SYSTEMS
SETUPIDS (Setup files used in a data collection program)
STYPES (Focal Sample Types)
STYPES_ACTIVITIES (Activity values that are used with each SType)
STYPES_NCODES (Ncodes that are used with each SType)
STYPES_POSTURES (Postures that are used with each SType)
SUCKLES (infant suckling activity)
Sexual Cycles and The Sexual Cycle Day-By-Day Tables
PCSCOLORS (ParaCallosal Skin Colors)
Darting
DART_SAMPLE_CATS (Darting Sample Categories)
DART_SAMPLE_TYPES (Sample Types)
DRUGS (darting anesthetics)
LYMPHSTATES (Lymph node conditions)
PARASITES (Parasites and their indicators)
TCONDITIONS (Tooth Conditions)
TICKSTATUSES (parasite count classifications)
TOOTHCODES (kinds of teeth)
TOOTHSITES (Locations of deciduous or adult teeth)
TSTATES (State of Tooth existence)
Inventory
INSTITUTIONS
MISID_STATUSES (MISIDentification STATUSES)
NUCACID_CONC_METHODS (NUCleic ACID CONCentration quantification METHODS)
NUCACID_CREATION_METHODS (NUCleic ACID CREATION METHODS)
NUCACID_TYPES (NUCleic ACID TYPES)
STORAGE_MEDIA
TISSUE_TYPES
SWERB Data
ADCODES (SWERB Ascent and Descent relationships)
PLACE_TYPES (codes for various landscape features)
PREDATORS (codes for observed predators)
SWERB_LOC_CONFIDENCES (SWERB Location Confidence Values)
SWERB_LOC_STATUSES (SWERB Location Statuses)
SWERB_TIME_SOURCES (SWERB Time Sources)
SWERB_XYSOURCES (SWERB Time Sources)
Weather Data
WEATHER_SOFTWARES (Programs used for digital weather data reporting)
WSTATIONS (Weather Stations)
6. The Babase Views
Group Membership and Life Events
CENSUS_DEMOG (CENSUS extended with DEMOG information)
CENSUS_DEMOG_SORTED (CENSUS_DEMOG, Sorted)
CYCPOINTS_CYCLES (CYCPOINTS extended with CYCLES information)
CYCPOINTS_CYCLES_SORTED (CYCPOINTS_CYCLES, Sorted)
DEMOG_CENSUS (DEMOG, showing CENSUS information)
DEMOG_CENSUS_SORTED (DEMOG_CENSUS, Sorted)
GROUPS_HISTORY
PARENTS
POTENTIAL_DADS (Potential Dads)
PROPORTIONAL_RANKS (RANKS extended with calculated PROPORTIONAL ranks)
Physical Traits
ESTROGENS
GLUCOCORTICOIDS
HORMONE_PREPS
HORMONE_RESULTS
HORMONE_SAMPLES
PROGESTERONES
TESTOSTERONES
THYROID_HORMONES
WOUNDSPATHOLOGIES (All Wound/Pathology Data, Together)
WP_DETAILS_AFFECTEDPARTS (WP_DETAILS, extended with WP_AFFECTEDPARTS)
WP_HEALS (WP_HEALUPDATES, extended)
WP_REPORTS_OBSERVERS (WP_REPORTS, extended with WP_OBSERVERS)
Sexual Cycles
CYCLES_SEXSKINS (CYCLES extended with SEXSKINS information)
CYCLES_SEXSKINS_SORTED (CYCLES_SEXSKINS, Sorted)
MATERNITIES (completed reproductive events)
MTD_CYCLES (CYCLES and Mdate, Tdate, and Ddate CYCPOINTS data)
SEXSKINS_CYCLES (CYCLES extended with SEXSKINS information)
SEXSKINS_CYCLES_SORTED (SEXSKINS_CYCLES, Sorted)
SEXSKINS_REPRO_NOTES (SEXSKINS extended with REPRO_NOTES)
Social and Multiparty Interactions
ACTOR_ACTEES (Complete social interactions, INTERACT_DATA extended twice with PARTS)
INTERACT (INTERACT_DATA, with enhanced dates and times)
INTERACT_SORTED
MPI_EVENTS (Dyadic social interactions that comprise multiparty interaction collections, MPIS joined with MPI_DATA extended twice with MPI_PARTS)
POINTS (POINT_DATA, with enhanced times)
POINTS_SORTED (POINTS, Sorted)
SAMPLES_GOFF (SAMPLES, with the Group OF the Focal)
Darting
ANESTH_STATS (darting additional Anesthetic Statistics)
BODYTEMP_STATS (darting Body Temperature Statistics)
CHEST_STATS (darting Chest circumference Statistics)
CROWNRUMP_STATS (darting Crown-to-Rump Statistics)
DSAMPLES (darting sample records with columns for each sample type)
DENT_CODES (darting Dentition records with columns for each Toothcode)
DENT_SITES (darting Dentition records with columns for each Toothsite)
HUMERUS_STATS (darting Humerus length Statistics)
PCV_STATS (darting PCV Statistics)
TESTES_ARC_STATS (darting Testes circumference Statistics)
TESTES_DIAM_STATS (darting Testes Diameter Statistics)
ULNA_STATS (darting Ulna length Statistics)
VAGINAL_PH_STATS (darting Vaginal pH Statistics)
Inventory
LOCATIONS_FREE (LOCATIONS available for storage)
NUCACID_CONCS (NUCACID_CONC_DATA, extended)
NUCACIDS (NUCACID_DATA, extended)
NUCACIDS_W_CONC (NUCleic ACIDS With CONCentration data)
TISSUES
TISSUES_HORMONES
SWERB Data (Group-level Geolocation Data)
QUADS (map Quadrants)
SWERB (Group level gps point samples)
SWERB_DATA_XY (The SWERB_DATA table with separate X and Y coordinates)
SWERB_DEPARTS (SWERB observation team Departures from camp)
SWERB_GW_LOCS (SWERB Grove and Waterhole Locations)
SWERB_GW_LOC_DATA_XY (The SWERB_GW_LOC_DATA table with separate X and Y coordinates)
SWERB_LOC_GPS_XY (The SWERB_LOC_GPS table with separate X and Y coordinates)
SWERB_LOCS (placement of a group at a landscape feature)
SWERB_UPLOAD (facility for uploading data into SWERB)
Weather Data
MIN_MAXS (Manually collected minimum and maximum temperature and rain data)
MIN_MAXS_SORTED (MIN_MAXS, Sorted)
Views Which Add Gid To Tables
The BIRTH_GRP View
The ENTRYDATE_GRP View
The STATDATE_GRP View
The CONSORTDATES_GRP View
The CYCGAPDAYS_GRP View
The CYCGAPS_GRP View
The CYCSTATS_GRP View
The DARTINGS_GRP View
The DISPERSEDATES_GRP View
The MATUREDATES_GRP View
The MDINTERVALS_GRP View
The MMINTERVALS_GRP View
The RANKDATES_GRP View
The REPSTATS_GRP View
7. Data Entry
Data Entry Overview
Automatically Generated IDs
8. Babase Programs
Data Maintenance Programs
SWERB_UPLOAD: View to upload into SWERB
Upcen: Update CENSUS table
Upmpi: Upload Multiparty Interactions
Updart: Upload Darting Data
Uptick: Load darting parasite data
Psionload: Load Psion point/sample data
Upload: Upload Into Any Table or View
Useful Programs and Functions
Functions
Logout: Logout From Babase Custom Programs
Wwwdiff: World Wide Web based Difference program
Overview of Data Analysis Procedures
A. Manipulating Date and Time Values
B. Querying-All-Occurrences-Interactions
C. Alteration Of Sexual Cycle Ids (Cid)
D. Babase Revision History
Changes in Babase 5.x
Babase 5.0
Babase 5.1
Babase 5.2
Babase 5.3
Babase 5.4
Babase 5.5
Changes in Babase 4.x
Babase 4.0
Babase 4.1
Babase 4.2
Babase 4.3
Babase 4.4
Babase 4.4.1
Babase 4.5
Babase 4.6
Changes in Babase 3.x
Babase 3.0
Non-numbered backward in-compatible changes
Changes after Babase 2.0
Changes to Babase between 1.0 and 2.0
GROUPS
BIOGRAPH
Interpolation and MEMBERS
The Sexual Cycle Information
JPSAMPS and FPSAMPS (and POINT_DATA and FPOINTS)
Time Representation
The All-Occurrences Focal Point Data
Support Tables
The Addition of Views
E. DocBook, Styling and other issues
F. Restrictions: Things Not To Do
G. Database Transactions Explained
H. The Warning Sub-System
Introduction to the Warning Sub-System
An Overview of the Warning Sub-System Data Structures
The Warning Sub-System Main Tables
INTEGRITY_QUERIES
INTEGRITY_WARNINGS (Warning Sub-System Results)
Warning Sub-System Support Tables
IQTYPES (Integrity Query Types)
WARNING_REMARKS (Remarks Regards Warning Results)
The Warning Sub-System Functions (Activating The Warning Sub-System)
run_integrity_queries execute one or more of the queries stored in the INTEGRITY_QUERIES table
I. Temporal Tables and babase_history
Introduction to Temporal Tables
How it Works
Temporal Tables in Action
Querying the history
Specific Examples

List of Figures

2.1. Key to the Babase Entity Relationship Diagrams
2.2. Babase Group Membership Entity Relationship Diagram
2.3. Babase Life Events Entity Relationship Diagram
2.4. Babase Sexual Cycle Entity Relationship Diagram
2.5. Babase Sexual Cycle Day-To-Day Tables Entity Relationship Diagram
2.6. Babase Social Interactions Entity Relationship Diagram
2.7. Babase Multiparty Interactions Entity Relationship Diagram
2.8. Babase Darting Logistics and Morphology Entity and Relationship Diagram
2.9. Babase Darting Physiology Entity and Relationship Diagram
2.10. Babase Darting Samples Entity and Relationship Diagram
2.11. Babase Darting Teeth and Ticks Entity and Relationship Diagram
2.12. Babase Inventory Entity Relationship Diagram
2.13. Babase Physical Traits Hormone Data Entity Relationship Diagram
2.14. Babase Physical Traits Genetic Hybrid Score Data Entity Relationship Diagram
2.15. Babase Physical Traits Wounds and Pathologies Data Entity Relationship Diagram
2.16. Babase SWERB Core Tables Entity Relationship Diagram
2.17. Babase SWERB Grove/Waterhole Location Tables Entity Relationship Diagram
2.18. Babase Manual Weather Data Entity Relationship Diagram
2.19. Babase Digital Weather Data Entity Relationship Diagram
4.1. An Individual is Censused Present and Absent
4.2. Interpolating From Presences and Absences
4.3. Interpolating Group Membership
4.4. Computing Interp Values
4.5. The 14 Day Interpolation Limit
4.6. Interpolation at Birth
4.7. Alive and Present When Last Censused
4.8. Alive and Absent in Last Census
4.9. Interpolation to Statdate When Dead
4.10. Midpoint Days
4.11. The Midpoint Rule Adjusts Intervals
4.12. An Individual is Censused in 2 Groups
4.13. Interpolating Each Group Separately
4.14. A Closer Look at Intervals
4.15. Presence and Absence Interpolated Separately
4.16. Combining Presence and Absence Intervals
4.17. Group Membership Given Multiple Groups
4.18. Pre-Analyzed Data Truncates Interpolation Intervals
4.19. Pre-Analyzed Data Interrupts Interpolation
4.20. An example 15/29 test
4.21. 29-day windows at the end of a residency period
6.1. Query Defining the CENSUS_DEMOG View
6.2. Entity Relationship Diagram of the CENSUS_DEMOG View
6.3. Query Defining the CENSUS_DEMOG_SORTED View
6.4. Entity Relationship Diagram of the CENSUS_DEMOG_SORTED View
6.5. Query Defining the CYCPOINTS_CYCLES View
6.6. Entity Relationship Diagram of the CYCPOINTS_CYCLES View
6.7. Query Defining the CYCPOINTS_CYCLES_SORTED View
6.8. Entity Relationship Diagram of the CYCPOINTS_CYCLES_SORTED View
6.9. Query Defining the DEMOG_CENSUS View
6.10. Entity Relationship Diagram of the DEMOG_CENSUS View
6.11. Query Defining the DEMOG_CENSUS_SORTED View
6.12. Entity Relationship Diagram of the DEMOG_CENSUS_SORTED View
6.13. Query Defining the GROUPS_HISTORY View
6.14. Entity Relationship Diagram of the GROUPS_HISTORY View
6.15. Query Defining the PARENTS View
6.16. Entity Relationship Diagram of the PARENTS View
6.17. Query Defining the POTENTIAL_DADS View
6.18. Entity Relationship Diagram of the foundation of the POTENTIAL_DADS View
6.19. Entity Relationship Diagram of that portion of the POTENTIAL_DADS View which places the mother and potential father in the same group during the fertile period
6.20. Entity Relationship Diagram of that portion of the POTENTIAL_DADS View having easily computed columns
6.21. Entity Relationship Diagram of that portion of the POTENTIAL_DADS View involving social interactions
6.22. Query Defining the PROPORTIONAL_RANKS View
6.23. Entity Relationship Diagram of the PROPORTIONAL_RANKS View
6.24. Query Defining the ESTROGENS View
6.25. Entity Relationship Diagram of the ESTROGENS View
6.26. Query Defining the GLUCOCORTICOIDS View
6.27. Entity Relationship Diagram of the GLUCOCORTICOIDS View
6.28. Query Defining the HORMONE_PREPS View
6.29. Entity Relationship Diagram of the HORMONE_PREPS View
6.30. Query Defining the HORMONE_RESULTS View
6.31. Entity Relationship Diagram of the HORMONE_RESULTS View
6.32. Query Defining the HORMONE_SAMPLES View
6.33. Entity Relationship Diagram of the HORMONE_SAMPLES View
6.34. Query Defining the PROGESTERONES View
6.35. Entity Relationship Diagram of the PROGESTERONES View
6.36. Query Defining the TESTOSTERONES View
6.37. Entity Relationship Diagram of the TESTOSTERONES View
6.38. Query Defining the THYROID_HORMONES View
6.39. Entity Relationship Diagram of the THYROID_HORMONES View
6.40. Query Defining the WOUNDSPATHOLOGIES View
6.41. Entity Relationship Diagram of the WOUNDSPATHOLOGIES View
6.42. Query Defining the WP_DETAILS_AFFECTEDPARTS View
6.43. Entity Relationship Diagram of the WP_DETAILS_AFFECTEDPARTS View
6.44. Query Defining the WP_HEALS View
6.45. Entity Relationship Diagram of the WP_HEALS View, Overall
6.46. Entity Relationship Diagram of the WP_HEALS View for rows with an update to a wound/pathology report
6.47. Entity Relationship Diagram of the WP_HEALS View for rows with an update to a wound/pathology cluster
6.48. Entity Relationship Diagram of the WP_HEALS View for rows with an update to an affected body part
6.49. Query Defining the WP_REPORTS_OBSERVERS View
6.50. Entity Relationship Diagram of the WP_REPORTS_OBSERVERS View
6.51. Query Defining the CYCLES_SEXSKINS View
6.52. Entity Relationship Diagram of the CYCLES_SEXSKINS View
6.53. Query Defining the CYCLES_SEXSKINS_SORTED View
6.54. Entity Relationship Diagram of the CYCLES_SEXSKINS_SORTED View
6.55. Query Defining the MATERNITIES View
6.56. Entity Relationship Diagram of the MATERNITIES View
6.57. Query Defining the MTD_CYCLES View
6.58. Entity Relationship Diagram of the MTD_CYCLES View
6.59. Query Defining the SEXSKINS_CYCLES View
6.60. Entity Relationship Diagram of the SEXSKINS_CYCLES View
6.61. Query Defining the SEXSKINS_CYCLES_SORTED View
6.62. Entity Relationship Diagram of the SEXSKINS_CYCLES_SORTED View
6.63. Query Defining the SEXSKINS_REPRO_NOTES View
6.64. Entity Relationship Diagram of the SEXSKINS_REPRO_NOTES View
6.65. Query Defining the ACTOR_ACTEES View
6.66. Entity Relationship Diagram of the ACTOR_ACTEES View
6.67. Query Defining the INTERACT View
6.68. Entity Relationship Diagram of the INTERACT View
6.69. Query Defining the INTERACT_SORTED View
6.70. Entity Relationship Diagram of the INTERACT_SORTED View
6.71. Query Defining the MPI_EVENTS View
6.72. Entity Relationship Diagram of the MPI_EVENTS View
6.73. Query Defining the POINTS View
6.74. Entity Relationship Diagram of the POINTS View
6.75. Query Defining the POINTS_SORTED View
6.76. Entity Relationship Diagram of the POINTS_SORTED View
6.77. Query Defining the SAMPLES_GOFF View
6.78. Entity Relationship Diagram of the SAMPLES_GOFF View
6.79. Query Defining the ANESTH_STATS View
6.80. Entity Relationship Diagram of the ANESTH_STATS View
6.81. Query Defining the BODYTEMP_STATS View
6.82. Entity Relationship Diagram of the BODYTEMP_STATS View
6.83. Query Defining the CHEST_STATS View
6.84. Entity Relationship Diagram of the CHEST_STATS View
6.85. Query Defining the CROWNRUMP_STATS View
6.86. Entity Relationship Diagram of the CROWNRUMP_STATS View
6.87. Query Defining the DSAMPLES View
6.88. Query Defining the DENT_CODES View
6.89. Entity Relationship Diagram of the DENT_CODES View
6.90. Query Defining the DENT_SITES View
6.91. Entity Relationship Diagram of the DENT_SITES View
6.92. Query Defining the HUMERUS_STATS View
6.93. Entity Relationship Diagram of the HUMERUS_STATS View
6.94. Query Defining the PCV_STATS View
6.95. Entity Relationship Diagram of the PCV_STATS View
6.96. Query Defining the TESTES_ARC_STATS View
6.97. Entity Relationship Diagram of the TESTES_ARC_STATS View
6.98. Query Defining the TESTES_DIAM_STATS View
6.99. Entity Relationship Diagram of the TESTES_DIAM_STATS View
6.100. Query Defining the ULNA_STATS View
6.101. Entity Relationship Diagram of the ULNA_STATS View
6.102. Query Defining the VAGINAL_PH_STATS View
6.103. Entity Relationship Diagram of the VAGINAL_PH_STATS View
6.104. Query Defining the LOCATIONS_FREE View
6.105. Entity Relationship Diagram of the LOCATIONS_FREE View
6.106. Query Defining the NUCACID_CONCS View
6.107. Entity Relationship Diagram of the NUCACID_CONCS View
6.108. Query Defining the NUCACIDS View
6.109. Entity Relationship Diagram of the NUCACIDS View
6.110. Query Defining the NUCACIDS_W_CONC View
6.111. Entity Relationship Diagram of the NUCACIDS_W_CONC View
6.112. Query Defining the TISSUES View
6.113. Entity Relationship Diagram of the TISSUES View
6.114. Query Defining the TISSUES_HORMONES View
6.115. Entity Relationship Diagram of the TISSUES_HORMONES View
6.116. Query Defining the QUADS View
6.117. Entity Relationship Diagram of the QUADS View
6.118. Query Defining the SWERB View
6.119. Entity Relationship Diagram of the SWERB View
6.120. Query Defining the SWERB_DATA_XY View
6.121. Entity Relationship Diagram of the SWERB_DATA_XY View
6.122. Query Defining the SWERB_DEPARTS View
6.123. Entity Relationship Diagram of the SWERB_DEPARTS View
6.124. Query Defining the SWERB_GW_LOCS View
6.125. Entity Relationship Diagram of the SWERB_GW_LOCS View
6.126. Query Defining the SWERB_GW_LOC_DATA_XY View
6.127. Entity Relationship Diagram of the SWERB_GW_LOC_DATA_XY View
6.128. Query Defining the SWERB_LOC_GPS_XY View
6.129. Entity Relationship Diagram of the SWERB_LOC_GPS_XY View
6.130. Query Defining the SWERB_LOCS View
6.131. Entity Relationship Diagram of the SWERB_LOCS View
6.132. Query Defining the SWERB_UPLOAD View
6.133. Entity Relationship Diagram of the SWERB_UPLOAD View
6.134. Query Defining the MIN_MAXS View
6.135. Entity Relationship Diagram of the MIN_MAXS View
6.136. Query Defining the MIN_MAXS_SORTED View
6.137. Entity Relationship Diagram of the MIN_MAXS_SORTED View
6.138. Query Defining the BIRTH_GRP View
6.139. Entity Relationship Diagram of the BIRTH_GRP View
6.140. Query Defining the ENTRYDATE_GRP View
6.141. Entity Relationship Diagram of the ENTRYDATE_GRP View
6.142. Query Defining the STATDATE_GRP View
6.143. Entity Relationship Diagram of the STATDATE_GRP View
6.144. Query Defining the CONSORTDATES_GRP View
6.145. Entity Relationship Diagram of the CONSORTDATES_GRP View
6.146. Query Defining the CYCGAPDAYS_GRP View
6.147. Entity Relationship Diagram of the CYCGAPDAYS_GRP View
6.148. Query Defining the CYCGAPS_GRP View
6.149. Entity Relationship Diagram of the CYCGAPS_GRP View
6.150. Query Defining the CYCSTATS_GRP View
6.151. Entity Relationship Diagram of the CYCSTATS_GRP View
6.152. Query Defining the DARTINGS_GRP View
6.153. Entity Relationship Diagram of the DARTINGS_GRP View
6.154. Query Defining the DISPERSEDATES_GRP View
6.155. Entity Relationship Diagram of the DISPERSEDATES_GRP View
6.156. Query Defining the MATUREDATES_GRP View
6.157. Entity Relationship Diagram of the MATUREDATES_GRP View
6.158. Query Defining the MDINTERVALS_GRP View
6.159. Entity Relationship Diagram of the MDINTERVALS_GRP View
6.160. Query Defining the MMINTERVALS_GRP View
6.161. Entity Relationship Diagram of the MMINTERVALS_GRP View
6.162. Query Defining the RANKDATES_GRP View
6.163. Entity Relationship Diagram of the RANKDATES_GRP View
6.164. Query Defining the REPSTATS_GRP View
6.165. Entity Relationship Diagram of the REPSTATS_GRP View
H.1. Warning Sub-System Entity Relationship Diagram

List of Tables

2.2. The Main Babase Tables
2.3. The Babase Support Tables
2.4. The Babase Views
2.5. The table_GRP Views
6.1. Columns in the CENSUS_DEMOG View
6.2. Columns in the CENSUS_DEMOG_SORTED View
6.3. Columns in the CYCPOINTS_CYCLES View
6.4. Columns in the CYCPOINTS_CYCLES_SORTED View
6.5. Columns in the DEMOG_CENSUS View
6.6. Columns in the DEMOG_CENSUS_SORTED View
6.7. Columns in the GROUPS_HISTORY View
6.8. Columns in the PARENTS View
6.9. Columns in the POTENTIAL_DADS View
6.10. Columns in the PROPORTIONAL_RANKS View
6.11. Columns in the ESTROGENS View
6.12. Columns in the GLUCOCORTICOIDS View
6.13. Columns in the HORMONE_PREPS View
6.14. Columns in the HORMONE_RESULTS View
6.15. Columns in the HORMONE_SAMPLES View
6.16. Columns in the PROGESTERONES View
6.17. Columns in the TESTOSTERONES View
6.18. Columns in the THYROID_HORMONES View
6.19. Columns in the WOUNDSPATHOLOGIES View
6.20. Columns in the WP_DETAILS_AFFECTEDPARTS View
6.21. Columns in the WP_HEALS View
6.22. Columns in the WP_REPORTS_OBSERVERS View
6.23. Columns in the CYCLES_SEXSKINS View
6.24. Columns in the CYCLES_SEXSKINS_SORTED View
6.25. Columns in the MATERNITIES View
6.26. Columns in the MTD_CYCLES View
6.27. Columns in the SEXSKINS_CYCLES View
6.28. Columns in the SEXSKINS_CYCLES_SORTED View
6.29. Columns in the SEXSKINS_REPRO_NOTES View
6.30. Columns in the ACTOR_ACTEES View
6.31. Columns in the INTERACT View
6.32. Columns in the INTERACT_SORTED View
6.33. Columns in the MPI_EVENTS View
6.34. Columns in the POINTS View
6.35. Columns in the POINTS_SORTED View
6.36. Columns in the SAMPLES_GOFF View
6.37. Columns in the ANESTH_STATS View
6.38. Columns in the BODYTEMP_STATS View
6.39. Columns in the CHEST_STATS View
6.40. Columns in the CROWNRUMP_STATS View
6.41. Columns in the DSAMPLES View
6.42. Columns in the DENT_CODES View
6.43. Columns in the DENT_SITES View
6.44. Columns in the HUMERUS_STATS View
6.45. Columns in the PCV_STATS View
6.46. Columns in the TESTES_ARC_STATS View
6.47. Columns in the TESTES_DIAM_STATS View
6.48. Columns in the ULNA_STATS View
6.49. Columns in the VAGINAL_PH_STATS View
6.50. Columns in the LOCATIONS_FREE View
6.51. Columns in the NUCACID_CONCS View
6.52. Columns in the NUCACIDS View
6.53. Columns in the NUCACIDS_W_CONC View
6.54. Columns in the TISSUES View
6.55. Columns in the TISSUES_HORMONES View
6.56. Columns in the QUADS View
6.57. Columns in the SWERB View
6.58. Columns in the SWERB_DATA_XY View
6.59. Columns in the SWERB_DEPARTS View
6.60. Columns in the SWERB_GW_LOCS View
6.61. Columns in the SWERB_GW_LOC_DATA_XY View
6.62. Columns in the SWERB_LOC_GPS_XY View
6.63. Columns in the SWERB_LOCS View
6.64. Columns in the SWERB_UPLOAD View
6.65. Columns in the MIN_MAXS View
6.66. Columns in the MIN_MAXS_SORTED View
8.1. The Babase SQL Functions
8.2. Data Analysis Procedures
H.1. The Warning Sub-System Tables
H.2. The Warning Sub-System Support Tables

List of Examples

1.1. A note
1.2. A caution
1.3. A warning
1.4. Text denoted important
1.5. A tip
2.1. Creating table foo in the sandbox schema
2.2. Granting permission to table foo in the sandbox schema
2.3. Creating table foo in user mylogin's schema
3.1. Crossovers during a fusion
3.2. (Mis)Use of Significant Figures in NUCACID_CONC_DATA
4.1. An Agonism Matrix
4.2. Kits with no Correction, and NULL Correction
4.3. A familiar "series" of events
4.4. Determining the GrpOfResidency when absent
4.5. Resident in a nonexistent group
A.1. Using the Postgresql date_trunc() function to set seconds to zero
A.2. Using the Babase date_mod() function to return the minutes and seconds.
A.3. Using the Postgresql to_char() function to convert times to HH:MM text
B.1. Finding all the all-occurrences interactions
C.1. Splitting a sexual cycle in two
H.1. Inserting a query into INTEGRITY_QUERIES using dollar quoting
H.2. Executing all INTEGRITY_QUERIES
H.3. Executing a single INTEGRITY_QUERIES.Query
H.4. Executing INTEGRITY_QUERIES of the bdate type
I.1. Querying "as of" a date
I.2. Querying a table's history "as of" a date

Page generated: 2024-03-06T15:02:45-05:00.