A Full-Scale Implementation of the Napp 1880 U.S. Census Data Set Using Dimensional Modeling and Data-Warehousing Technology
Bibliographic Data
| ID | 11253247 |
|---|---|
| Authors | Richard Healey (0000-0001-6872-4900, University of Portsmouth, corresponding author), Richard G Healey |
| Year | 2011 |
| Volume | 44 |
| Issue | 2 |
| Pages | 95-105 |
| Publication date | 2011-04-01 |
| Peer Reviewed | Yes |
| Open Access | No |
| Type | ARTICLE |
| Venue | Historical Methods A Journal of Quantitative and Interdisciplinary History (JOURNAL) |
| Journal identifiers | ISSN: 0161-5440 • E-ISSN: 1940-1906 |
| Publisher | Informa UK Limited (PUBLISHER • GB) |
| DOI | 10.1080/01615440.2010.506417 |
| OpenAlex | W1993596621 |
| Language | EN |
| Citations received | 3 |
| References cited | 4 |
Data warehousing is a high-performance database technology for the processing of complex data cubes that can be aggregated and crosstabulated in a wide variety of ways. Individual-level U.S. 1880 census records can be analyzed using this technology to extract information not available from printed census volumes, if hierarchically structured code lists for numerical census variables can be converted into analytical dimensions that drive the crossclassification methods. Problems encountered in the construction of a full-scale warehouse, containing millions of records for Northeastern industrial states, are examined and resolved. Also, deficiencies in census-supplied information on occupations are identified, and a new occupational-coding system is implemented to facilitate remedying of these deficiencies in future, as new information from noncensus data sources becomes available
Cartography · Census · Coding (social sciences · Data mining · Data science · Data set · Data warehouse · Database · Geography · Population · Scale (ratio · Set (abstract data type · Statistics · Advanced Database Systems and Queries · Computer Science · Data Management and Algorithms · Data Quality and Management · Mathematics · Artificial Intelligence
| Unique citing works | 3 |
|---|---|
| Citations per year | 0.21 |
| Citation span | 2012 - 2015 (4) |
| Citation velocity | historical |
| Highly cited | No |
| Citation types | Neutral: 3 |