Smithsonian National Museum of Natural History logo

Osteoware: Standardized Skeletal Documentation Software

Osteoware: Standardized Skeletal Documentation Software

Query your database!

6 posts / 0 new
Last post
C Dudar's picture
Offline
Last seen: 1 week 4 days ago
Joined: 12/09/2011 - 13:44

Getting your data entered into the Osteoware database is just the beginning, now you want to query (a form of  'questioning' ) and extract information of research interest from your database.

Basically the sky is the limit on how you can query your database, but you need to know how to use Structured Query Language (SQL) which is easy to learn, and besides, SQL is a very valuable skill to have on your CV.

Since we all use the same Osteoware database, one query to accomplish XYZ will work for everyone.  You may simply need to change contextual variables (geographical and/or temporal information, catkey, etc. --usually unique to each user) if they are part of the query selection criteria. 

First, download Volume 1 of the user guide from the download page.  The User Guide is a work in progress (as of Jan 2012) but there is a good chapter on querying your database, so please read that first, as well as explore some of the online resources listed at the end. 

This forum will establish a library of common queries and resources, as well as provide support for more individualized or more difficult queries.  

Let us know what you want to study and we'll help you to get your data.

Edited by: C Dudar on 01/05/2012 - 15:20
joe.hefner4's picture
Offline
Last seen: 3 years 1 month ago
Joined: 01/03/2012 - 14:51

I'm looking forward to the SQL library, great idea Chris.

Offline
Last seen: 5 years 5 months ago
Joined: 04/05/2012 - 11:30

I encountered some trouble figuring out how to use data architect to create separate datasets for each of the three collections I am analyzing from the same site as I'd like to report on them individually but also compare across if possible.  Thank you so much for the help.

C Dudar's picture
Offline
Last seen: 1 week 4 days ago
Joined: 12/09/2011 - 13:44

Hi Catherine,

Open the CaseListProtInvt.ADT data table in Advantage.  For each catalog/catkey record from one of the three collections simply enter an appropriate 'Data Subset' name.  Three collections = use three different data subset names.

Each of the collections (and their catkeys) will then be grouped under that data subset name in the Data Subset drop down list in the upper left corner of the Osteoware Home Screen

Choose the data subset of interest from the drop down list, and the catkeys will be displayed in the Catkey Window to the right.

Let me know if you have any problems.

Offline
Last seen: 5 years 2 months ago
Joined: 04/12/2012 - 03:36

Hi, I have some doubts using Data Architect. I am wondering if it is possible to make statistcal analysis inside the program or should I export it to an excel file?

C Dudar's picture
Offline
Last seen: 1 week 4 days ago
Joined: 12/09/2011 - 13:44

Advantage Data Architect is a database manager, not really meant for statistics though if you get to know SQL you could write some simple manipulations/calculations in the SQL query as you generate your data reports.

I don't know SQL to that level to conduct statistics, and do prefer to query and export the data of interest to Excel and then into my stats program of choice.

What I would not do, though, is export ALL data from a site/collection and then try to manipulate it in Excel.  Conduct a query in Advantage to extract only the data you desire to compare; it does a great job of managing data if you get to know it well.

Any other questions do not hesitate to ask.