Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-240

Run queries using derived fact tables (Multi-fact table & OMOP)

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Completed
    • None
    • 1.7.09
    • None
    • None
    • Query Tool, Timeline View
    • Queries, Temporal Queries
    • Hide
      Currently testing the install scripts.

      Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables.

      Tested and queries appear to be working correctly.
      Show
      Currently testing the install scripts. Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables. Tested and queries appear to be working correctly.

    Description

      An enhancement to CRC to run queries against derived fact tables (Multi-fact tables) as found in OMOP or PCORI.

      Enabled by a crc.properties parameter
      # Derived fact table parameter
      queryprocessor.derivedfacttable=true

      If parameter does not exist, then queries run against obs_fact table.

      On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain.

      In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          lcp5 Lori Phillips created issue -
          lcp5 Lori Phillips made changes -
          Field Original Value New Value
          Assignee Lori Phillips [ lcp5 ]
          jmd86 Janice Donahoe made changes -
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.09 [ 10306 ]
          lcp5 Lori Phillips made changes -
          Description An enhancement to CRC to run queries against derived fact tables as found in OMOP or PCORI.

          Enabled by a crc.properties parameter
          # Derived fact table parameter
          queryprocessor.derivedfacttable=true

          If parameter does not exist, then queries run against obs_fact table.           		An enhancement to CRC to run queries against derived fact tables as found in OMOP or PCORI.

          Enabled by a crc.properties parameter
          # Derived fact table parameter
          queryprocessor.derivedfacttable=true

          If parameter does not exist, then queries run against obs_fact table.

          On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain.

          In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes Currently testing the install scripts.

          Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables.
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes Currently testing the install scripts.

          Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables.           		Currently testing the install scripts.

          Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables.

          Tested and queries appear to be working correctly.
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Completed [ 10000 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Summary Run queries using derived fact tables (OMOP) Run queries using derived fact tables (Multi-fact table & OMOP)
          jmd86 Janice Donahoe made changes -
          Description An enhancement to CRC to run queries against derived fact tables as found in OMOP or PCORI.

          Enabled by a crc.properties parameter
          # Derived fact table parameter
          queryprocessor.derivedfacttable=true

          If parameter does not exist, then queries run against obs_fact table.

          On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain.

          In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query           		An enhancement to CRC to run queries against derived fact tables (Multi-fact tables) as found in OMOP or PCORI.

          Enabled by a crc.properties parameter
          # Derived fact table parameter
          queryprocessor.derivedfacttable=true

          If parameter does not exist, then queries run against obs_fact table.

          On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain.

          In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            lcp5 Lori Phillips
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: