01 Pauá Model: Technical aspects - MTFA/CohortEx GitHub Wiki

The Pauá model is represented as an external schema, that means, a set of queries made over a logical schema and implies that the underlying database supports the relational model. It is possible, ut not practical, to make a representation of the model in pure relational algebra.
By this first version, it has been implemented over an Oracle database, but we have previsions to expand the model to other databases.
The external schema is represented by the references to ESxxxx materialized views. These views are the result of mapping the logical schema and not included here because are different for each Electronic Health Record system.
Which is described here are the ES views and it's fields using a JSON schema that can be browsed with the help of Docson.
The data types of each field are implicit form the subjacent database. The exception are the fields denoted by DATE, that are further used to filter or calculate records and need to be of a type suited for it. In Oracle database, this translates to DATE or TIMESTAMP data type.
Cleaning of data is already performed by queries of the Pauá model, so the only need to do before use of the CohortEx, is generate the ESxxx views from your particular EHR's system.