<?xml version="1.0"?>
<edsp version="3.1" about_me="http://ycmi.med.yale.edu/EAVCR/EDSP" source="Olfactory Receptors Database">
  <source>
    <type>eav/cr</type>
    <name>Data Store:SenseLab</name>
    <location>ordb.biotech.ttu.edu</location>
    <date>4/12/2026 7:06:55 AM</date>
    <query_method>GET</query_method>
    <query_parameter>o=21685</query_parameter>
  </source>
  <metadata type="partial" time="0">
    <datatypes>
      <datatype id="B" name="Boolean" xml_datatype="xs:boolean" />
      <datatype id="C" name="Object/Ref" xml_datatype="xs:long" />
      <datatype id="D" name="Datetime" xml_datatype="xs:dateTime" />
      <datatype id="F" name="Formula(only)" xml_datatype="xs:anyType" />
      <datatype id="H" name="Hierarchy(p)" xml_datatype="xs:long" />
      <datatype id="I" name="Integer" xml_datatype="xs:long" />
      <datatype id="M" name="Memo" xml_datatype="xs:string" />
      <datatype id="R" name="Real" xml_datatype="xs:double" />
      <datatype id="S" name="String" xml_datatype="xs:string" />
      <datatype id="V" name="Object/Value" xml_datatype="xs:long" />
      <datatype id="W" name="Object/Ref(MC)" xml_datatype="xs:long" />
      <datatype id="Y" name="Binary" xml_datatype="xs:base64Binary" />
    </datatypes>
    <metadata_ontology>
      <sem_type_atts />
      <sem_rel_types />
      <sem_rel_att />
    </metadata_ontology>
    <database id="d2" name="modeldb" caption="ModelDB" caption_long="Model Database" description="ModelDB provides an accessible location for storing and efficiently retrieving compartmental neuron models. ModelDB is tightly coupled with NeuronDB. Models can be coded in any language for any environment, though ModelDB has been initially constructed for use with NEURON and GENESIS. Model code can be viewed before downloading and browsers can be set to auto-launch the models" main_class="19" version="3" version_date="4/12/2002 11:28:19 AM">
      <class id="c73" name="sql_programs" caption="SQL programs" description="These SQL programs are intended to display tables that are useful for administration and development of scripts." object_description_hide="false" type="E" is_concept="false" host_concepts="false" uid="" version="3" version_date="4/27/2003 9:43:11 AM">
        <att id="a229" dt_id="M" sn="1" name="sql_program" caption="SQL Program" description="This stores an SQL program" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="1" version_date="4/27/2003 9:45:32 AM" />
        <att id="a230" dt_id="I" sn="2" name="max_rows" caption="Maximum Rows" description="This variable determines the maximum number of rows that are desired to be displayed. If set to &quot;-1&quot; then all rows are displayed." width="20" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="2" version_date="4/27/2003 9:52:03 AM" />
        <att id="a231" dt_id="I" sn="3" name="max_cols" caption="Maximum Columns" description="This variable determines the maximum number of columns that are desired to be displayed. If set to &quot;-1&quot; then all columns are displayed." width="20" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="2" version_date="4/27/2003 10:36:43 AM" />
      </class>
    </database>
  </metadata>
  <data time="0.0156180000012682">
    <data_database db_id="d2">
      <data_class class_id="c73" version="3">
        <object id="o21685" name="debug: select 200 most prolific authors" description="change sql so that authors that differ by middle initial are equivalent" uid="" version="3" version_date="5/6/2003 10:42:01 PM">
          <att_value att_id="a229" value="select author.object_id,author.object_name, count(paper_author.object_id) from objects author, objects author1,eav_objects paper_author where author.object_class=44 and paper_author.attribute_id=148 and (author.object_id = paper_author.value or author1.object_id=paper_author.value and lower(author1.name) like lower(left(author.name,length(author1_name)))) group by author.object_id,author.object_name order by COUNT(paper_author.OBJECT_ID) DESC, author.object_name" />
          <att_value att_id="a230" value="200" />
        </object>
      </data_class>
    </data_database>
  </data>
</edsp>

