edu.wright.hendrix11.familyTree.dataBean.mining

Class NamesDataBean

java.lang.Object

edu.wright.hendrix11.familyTree.dataBean.mining.NamesDataBean

public class NamesDataBean
extends Object

This class queries the database to get the most common names.

Author:

Joe Hendrix

Constructor Summary

Constructors

Constructor and Description
NamesDataBean()

Method Summary

Modifier and Type	Method and Description
Map<String,Integer>	firstNameFrequency() Returns a map of first names to the number of occurrences of that first name.
Map<String,Integer>	lastNameFrequency() Returns a map of last names to the number of occurrences of that last name.

Methods inherited from class java.lang.Object

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

Constructor Detail

NamesDataBean

public NamesDataBean()

Method Detail

firstNameFrequency

public Map<String,Integer> firstNameFrequency()

Returns a map of first names to the number of occurrences of that first name.

Internally this is a LinkedHashMap. It only returns at most the top 20 names. Since the entire name is stored in the database as a single field, a regular expression is used in a view inside the database itself to count the first names.

The select statement defining the view appears as follows:

 SELECT COUNT(FIRST_NAME) COUNT, FIRST_NAME
 FROM (SELECT REGEXP_SUBSTR(NAME,'^\w+') AS FIRST_NAME FROM PERSON)
 GROUP BY FIRST_NAME
 ORDER BY COUNT DESC;
 

Returns:

a map of first names to the number of occurrences of that first name

lastNameFrequency

public Map<String,Integer> lastNameFrequency()

Returns a map of last names to the number of occurrences of that last name.

Internally this is a LinkedHashMap. It only returns at most the top 20 names. Since the entire name is stored in the database as a single field, a regular expression is used in a view inside the database itself to count the last names.

The select statement defining the view appears as follows:

 SELECT COUNT(LAST_NAME) COUNT, LAST_NAME
 FROM (SELECT REGEXP_SUBSTR(NAME,'\w+$') AS LAST_NAME FROM PERSON)
 GROUP BY LAST_NAME
 ORDER BY COUNT DESC;
 

Returns:

a map of last names to the number of occurrences of that last name