2008dataandequations

Data & Equations

Universal Biology Database

Control Data

Experimental Data - Diabetes Example

SQL - Control and Experimental Data

Stereology Literature Database - CO

Stereology Literature Database - EX

Read

Data and equations become the raw materials of an information science. Click on an item in the list to run a program module.

The database table includes almost 50,000 data pairs (Y/X) assigned to decimal repertoire equations (DREs).

Scroll to the right to view the power equations, expected and observed values, DREs, and original Y/X ratios.

Control data can be retrieved from the database either by selecting items from lists or by using relational operators. To run a query, click on the Retrieve button. To view the results as a scrolling table of data, click on the view data button.

Let's find all the data coming from a specific strain of mouse. In the Organism field, type in <like %mouse%> and in the Type field <c57BL/6j>. Click on the Retrieve button.

The database engine quickly retrieves 441 rows of data, using the SQL statement appearing in the window at the botton of the screen.

Let's retrieve data for diabetes in adult male rats. The screen shows the SQL script used to assemble such a query.

Here we see the results of the query with the scrolling screen (view data) - in decending order of the decimal repertoire equations.

In humans, find all those data pairs with a DRE of 10.0. In the Equation field, type in <like %10.0%> and <like %hu%> in the Organism field. Click on the Retrieve button.

The query retrieves 181 rows of data.

Click on the view data button and scroll to the bottom of the screen. By plotting these 181 data pairs (X vs. Y), it becomes quickly apparent that biology can use the same numerical relationship to order parts of all sizes.

The database interface provides ready access to control data and offers a variety of helpful search tools.

The database interface also provides ready access to experimental data, identifying those found to be significantly different from the controls.

The read button supplies background information and instructions.