edu.wright.hendrix11.familyTree.dataBean.mining

Class AgesDataBean

java.lang.Object

edu.wright.hendrix11.familyTree.dataBean.mining.AgesDataBean

public class AgesDataBean
extends Object

This class performs queries to three different views in the database: the AGE_VIEW, AGE_TO_BIRTH_YEAR_VIEW, and AGE_TO_DEATH_YEAR_VIEW. The latter two views actually reference the first view.

The select statement for these views are defined as follows:

AGE_VIEW

 SELECT B.PERSON_ID,
 	  (D.YEAR-B.YEAR) AS AGE,
 	  B.YEAR AS BIRTH_YEAR,
 	  D.YEAR AS DEATH_YEAR
 FROM EVENT B,EVENT D
 WHERE B.PERSON_ID=D.PERSON_ID
 	AND B.TYPE='birth'
 	AND D.TYPE='death'
 	AND B.YEAR IS NOT NULL
 	AND D.YEAR IS NOT NULL;
 

AGE_TO_BIRTH_YEAR_VIEW

 SELECT AVG(AGE) AVG_AGE, MEDIAN(AGE) MEDIAN_AGE, BIRTH_YEAR
 FROM AGE_VIEW
 GROUP BY BIRTH_YEAR
 ORDER BY BIRTH_YEAR;
 

AGE_TO_DEATH_YEAR_VIEW

 SELECT AVG(AGE) AVG_AGE, MEDIAN(AGE) MEDIAN_AGE, DEATH_YEAR
 FROM AGE_VIEW
 GROUP BY DEATH_YEAR
 ORDER BY DEATH_YEAR;
 

Author:

Joe Hendrix

Constructor Summary

Constructors

Constructor and Description
AgesDataBean()

Method Summary

Modifier and Type	Method and Description
int	ageQuartile(int quartile) Returns the specified age quartile.
Map<String,Integer>	ages() Returns a map of ages to number of people who lived to be that age.
double	averageAge() Returns the average age in the database.
int	maxAge() Returns the maximum age in the database.
Map<String,Integer[]>	meanMeadianAgesPerBirthYear() Returns a map of years to the mean and median ages of people who where born that year.
Map<String,Integer[]>	meanMeadianAgesPerDeathYear() Returns a map of years to the mean and median ages of people who died that year.
double	medianAge() Returns the median age in the database.
int	minAge() Returns the minimum age in the database.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

AgesDataBean

public AgesDataBean()

Method Detail

averageAge

public double averageAge()

Returns the average age in the database. This average is calculated using the database's AVG() function, and only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Returns:

the average age in the database

medianAge

public double medianAge()

Returns the median age in the database. This median is calculated using the database's MEDIAN() function, and only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Returns:

the median age in the database

minAge

public int minAge()

Returns the minimum age in the database. This minimum is calculated using the database's MIN() function, and only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Returns:

the minimum age in the database

maxAge

public int maxAge()

Returns the maximum age in the database. This maximum is calculated using the database's MAX() function, and only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Returns:

the maximum age in the database

ageQuartile

public int ageQuartile(int quartile)

Returns the specified age quartile. Being a quartile, the parameter should range from 1 to 4. This method uses a nested query (SELECT AGE, NTILE(4) OVER (ORDER BY AGE) AS QUARTILE FROM AGE_VIEW) to assign each value to a quartile, then selects the maximum value from the specified quartile.

This method only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Parameters:

quartile - an integer, which should range from 1 to 4.

Returns:

the specified age quartile

Throws:

IllegalArgumentException - if the quartile is less than 1 or greater than 4

ages

public Map<String,Integer> ages()

Returns a map of ages to number of people who lived to be that age. Internally this is a LinkedHashMap. The ages are recorded as a String while the count of people is recorded as a Integer.

This method only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Returns:

a map of ages to number of people who lived to be that age

meanMeadianAgesPerBirthYear

public Map<String,Integer[]> meanMeadianAgesPerBirthYear()

Returns a map of years to the mean and median ages of people who where born that year. Internally this is a LinkedHashMap. The year is represented by a while the mean and median is represented by an Integer array of length 2. The zeroth value of the array is the mean, while the last value is the median.

This method only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Returns:

a map of years to the mean and median ages of people who where born that year

meanMeadianAgesPerDeathYear

public Map<String,Integer[]> meanMeadianAgesPerDeathYear()

Returns a map of years to the mean and median ages of people who died that year. Internally this is a LinkedHashMap. The year is represented by a while the mean and median is represented by an Integer array of length 2. The zeroth value of the array is the mean, while the last value is the median.

This method only accounts for those ages that can be calculated, i.e. ages of persons that have both a known birth and death date.

Returns:

a map of years to the mean and median ages of people who died that year