Details

    • Sub-Task
    • Status: In Review
    • Major
    • Resolution: Unresolved
    • None
    • 1.7.13
    • None
    • None

    Description

      Add support for multiple fact tables on the totalnum counter scripts for all database platforms.

      Attachments

        Activity

          Multifact by creating a large view of all fact tables now supported in all platforms. Needs to be tested in Oracle and Postgres.

          To use with multi-fact setups: Create a fact table view as the union of all your fact tables. (This is essentially going back to a single fact table, but it is only used for totalnum counting. This is needed to correctly count patients that mention multiple fact tables within a hierarchy.)
            e.g.,
              create view observation_fact_view as
                 select * from CONDITION_VIEW
                union all
                 select * from drug_view
              And then run the totalnum counter on that fact table view.
          jklann Jeffrey Klann added a comment - Multifact by creating a large view of all fact tables now supported in all platforms. Needs to be tested in Oracle and Postgres. To use with multi-fact setups: Create a fact table view as the union of all your fact tables. (This is essentially going back to a single fact table, but it is only used for totalnum counting. This is needed to correctly count patients that mention multiple fact tables within a hierarchy.)   e.g.,     create view observation_fact_view as        select * from CONDITION_VIEW       union all        select * from drug_view     And then run the totalnum counter on that fact table view.
          This needs to be tested in Oracle.
          jklann Jeffrey Klann added a comment - This needs to be tested in Oracle.
          rm302 Reeta Metta added a comment -
          needs to be tested in postgres as well
          rm302 Reeta Metta added a comment - needs to be tested in postgres as well
          rm302 Reeta Metta added a comment -
          verified only on sql server
          currently no db set up for oracle and postgres
          rm302 Reeta Metta added a comment - verified only on sql server currently no db set up for oracle and postgres
          This has been tested on Oracle by Ngan Chau at UCLA.
          jklann Jeffrey Klann added a comment - This has been tested on Oracle by Ngan Chau at UCLA.

          People

            jklann Jeffrey Klann
            jklann Jeffrey Klann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: