Using Multidimensional Analysis for the Presentation of Zooarchaeological Data

Author(s): Thomas Ryan

Year: 2017


Management and dissemination of data has long been a challenge for archaeologists, and this challenge has increased in recent years with demands from various funding agencies for data management plans. Additionally, querying the complex datasets generated often results in iterative rounds of SQL code creation as each answer raises further questions. Online analytical processing (OLAP), a tool for multi-dimensional analysis used by many private companies for reporting, management, and forecasting, as well as by government agencies, such as the Department of Labor, to track the effectiveness of their programs, provides a possible solution to the difficulties in data management and querying in archaeology. Defining data in terms of dimensions and measures, OLAP allows rapid and complex querying without a developer anticipating the specific questions a researcher may ask. I will demonstrate the effectiveness of this tool for analyzing data using zooarchaeological data from the North Atlantic region. Using OLAP to present such data also can serve as an aid in outreach efforts to policy makers and researchers in related fields. The ability to integrate disparate datasets and create complex queries in an ad hoc fashion will also be shown.

Cite this Record

Using Multidimensional Analysis for the Presentation of Zooarchaeological Data. Thomas Ryan. Presented at The 81st Annual Meeting of the Society for American Archaeology, Vancouver, British Columbia. 2017 ( tDAR id: 429793)

This Resource is Part of the Following Collections


Geographic Keywords

Spatial Coverage

min long: -178.41; min lat: 62.104 ; max long: 178.77; max lat: 83.52 ;

Record Identifiers

Abstract Id(s): 16456