Re: New paper: Archetype-based data warehouse environment

2015-07-01 Thread Ian McNicoll 
Hi David,

Just caught up on this paper after my holiday. Fantastic piece of work and
great to see the full interaction of archetype tooling, querying, backend
operations and CDS being described in such detail.

Ian

Dr Ian McNicoll
mobile +44 (0)775 209 7859
office +44 (0)1536 414994
skype: ianmcnicoll
email: i...@freshehr.com
twitter: @ianmcnicoll

Co-Chair, openEHR Foundation Management Board
Director, freshEHR Clinical Informatics
Director, HANDIHealth CIC
Hon. Senior Research Associate, CHIME, UCL

On 19 June 2015 at 09:06, David Moner  wrote:

> Dear all,
>
> My colleagues Luis Marco-Ruiz, José A. Maldonado, Nils Kolstrup, Johan G.
> Bellika and myself have just published a paper titled "Archetype-based data
> warehouse environment to enable the reuse of electronic health record data"
> in the International Journal of Medical Informatics. I think this work can
> be of interest for many of you.
>
> Best regards,
> David
>
> Link: http://www.sciencedirect.com/science/article/pii/S1386505615300058
>
> Abstract:
>
> - Background. The reuse of data captured during health care delivery is
> essential to satisfy the demands of clinical research and clinical decision
> support systems. A main barrier for the reuse is the existence of legacy
> formats of data and the high granularity of it when stored in an electronic
> health record (EHR) system. Thus, we need mechanisms to standardize,
> aggregate, and query data concealed in the EHRs, to allow their reuse
> whenever they are needed.
> - Objective. To create a data warehouse infrastructure using
> archetype-based technologies, standards and query languages to enable the
> interoperability needed for data reuse.
> - Materials and methods. The work presented makes use of best of breed
> archetype-based data transformation and storage technologies to create a
> workflow for the modeling, extraction, transformation and load of EHR
> proprietary data into standardized data repositories. We converted legacy
> data and performed patient-centered aggregations via archetype-based
> transformations. Later, specific purpose aggregations were performed at a
> query level for particular use cases.
> - Results. Laboratory test results of a population of 230,000 patients
> belonging to Troms and Finnmark counties in Norway requested between
> January 2013 and November 2014 have been standardized. Test records
> normalization has been performed by defining transformation and aggregation
> functions between the laboratory records and an archetype. These mappings
> were used to automatically generate open EHR compliant data. These data
> were loaded into an archetype-based data warehouse. Once loaded, we defined
> indicators linked to the data in the warehouse to monitor test activity of
> Salmonella and Pertussis using the archetype query language.
> - Discussion. Archetype-based standards and technologies can be used to
> create a data warehouse environment that enables data from EHR systems to
> be reused in clinical research and decision support systems. With this
> approach, existing EHR data becomes available in a standardized and
> interoperable format, thus opening a world of possibilities toward semantic
> or concept-based reuse, query and communication of clinical data.
>
>
> --
> David Moner Cano
> Grupo de Informática Biomédica - IBIME
> Instituto ITACA
> http://www.ibime.upv.es
> http://www.linkedin.com/in/davidmoner
>
> Universidad Politécnica de Valencia (UPV)
> Camino de Vera, s/n, Edificio G-8, Acceso B, 3ª planta
> Valencia – 46022 (España)
>
> ___
> openEHR-technical mailing list
> openEHR-technical@lists.openehr.org
>
> http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org
>
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: New paper: Archetype-based data warehouse environment

2015-06-22 Thread Sam Heard 
Congratulations David and to you wonderful colleagues.
Cheers, Sam

Sent from Windows Mail

From: David Moner
Sent: ?Friday?, ?19? ?June? ?2015 ?5?:?37? ?PM
To: For openEHR clinical 
discussions, For openEHR technical 
discussions

Dear all,

My colleagues Luis Marco-Ruiz, Jos? A. Maldonado, Nils Kolstrup, Johan G. 
Bellika and myself have just published a paper titled "Archetype-based data 
warehouse environment to enable the reuse of electronic health record data" in 
the International Journal of Medical Informatics. I think this work can be of 
interest for many of you.

Best regards,
David

Link: http://www.sciencedirect.com/science/article/pii/S1386505615300058

Abstract:

- Background. The reuse of data captured during health care delivery is 
essential to satisfy the demands of clinical research and clinical decision 
support systems. A main barrier for the reuse is the existence of legacy 
formats of data and the high granularity of it when stored in an electronic 
health record (EHR) system. Thus, we need mechanisms to standardize, aggregate, 
and query data concealed in the EHRs, to allow their reuse whenever they are 
needed.
- Objective. To create a data warehouse infrastructure using archetype-based 
technologies, standards and query languages to enable the interoperability 
needed for data reuse.
- Materials and methods. The work presented makes use of best of breed 
archetype-based data transformation and storage technologies to create a 
workflow for the modeling, extraction, transformation and load of EHR 
proprietary data into standardized data repositories. We converted legacy data 
and performed patient-centered aggregations via archetype-based 
transformations. Later, specific purpose aggregations were performed at a query 
level for particular use cases.
- Results. Laboratory test results of a population of 230,000 patients 
belonging to Troms and Finnmark counties in Norway requested between January 
2013 and November 2014 have been standardized. Test records normalization has 
been performed by defining transformation and aggregation functions between the 
laboratory records and an archetype. These mappings were used to automatically 
generate open EHR compliant data. These data were loaded into an 
archetype-based data warehouse. Once loaded, we defined indicators linked to 
the data in the warehouse to monitor test activity of Salmonella and Pertussis 
using the archetype query language.
- Discussion. Archetype-based standards and technologies can be used to create 
a data warehouse environment that enables data from EHR systems to be reused in 
clinical research and decision support systems. With this approach, existing 
EHR data becomes available in a standardized and interoperable format, thus 
opening a world of possibilities toward semantic or concept-based reuse, query 
and communication of clinical data.


--
David Moner Cano
Grupo de Inform?tica Biom?dica - IBIME
Instituto ITACA
http://www.ibime.upv.es
http://www.linkedin.com/in/davidmoner

Universidad Polit?cnica de Valencia (UPV)
Camino de Vera, s/n, Edificio G-8, Acceso B, 3? planta
Valencia - 46022 (Espa?a)
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: New paper: Archetype-based data warehouse environment

2015-06-20 Thread Kalra, Dipak 
Dear David, other colleague authors,

This is an excellent paper and a very valuable contribution on the practical 
adoption of archetypes.

With best wishes,

Dipak Kalra

On 19 Jun 2015, at 10:07, David Moner 
mailto:dam...@gmail.com>> wrote:

Dear all,

My colleagues Luis Marco-Ruiz, Jos? A. Maldonado, Nils Kolstrup, Johan G. 
Bellika and myself have just published a paper titled "Archetype-based data 
warehouse environment to enable the reuse of electronic health record data" in 
the International Journal of Medical Informatics. I think this work can be of 
interest for many of you.

Best regards,
David

Link: http://www.sciencedirect.com/science/article/pii/S1386505615300058

Abstract:

- Background. The reuse of data captured during health care delivery is 
essential to satisfy the demands of clinical research and clinical decision 
support systems. A main barrier for the reuse is the existence of legacy 
formats of data and the high granularity of it when stored in an electronic 
health record (EHR) system. Thus, we need mechanisms to standardize, aggregate, 
and query data concealed in the EHRs, to allow their reuse whenever they are 
needed.
- Objective. To create a data warehouse infrastructure using archetype-based 
technologies, standards and query languages to enable the interoperability 
needed for data reuse.
- Materials and methods. The work presented makes use of best of breed 
archetype-based data transformation and storage technologies to create a 
workflow for the modeling, extraction, transformation and load of EHR 
proprietary data into standardized data repositories. We converted legacy data 
and performed patient-centered aggregations via archetype-based 
transformations. Later, specific purpose aggregations were performed at a query 
level for particular use cases.
- Results. Laboratory test results of a population of 230,000 patients 
belonging to Troms and Finnmark counties in Norway requested between January 
2013 and November 2014 have been standardized. Test records normalization has 
been performed by defining transformation and aggregation functions between the 
laboratory records and an archetype. These mappings were used to automatically 
generate open EHR compliant data. These data were loaded into an 
archetype-based data warehouse. Once loaded, we defined indicators linked to 
the data in the warehouse to monitor test activity of Salmonella and Pertussis 
using the archetype query language.
- Discussion. Archetype-based standards and technologies can be used to create 
a data warehouse environment that enables data from EHR systems to be reused in 
clinical research and decision support systems. With this approach, existing 
EHR data becomes available in a standardized and interoperable format, thus 
opening a world of possibilities toward semantic or concept-based reuse, query 
and communication of clinical data.


--
David Moner Cano
Grupo de Inform?tica Biom?dica - IBIME
Instituto ITACA
http://www.ibime.upv.es
http://www.linkedin.com/in/davidmoner

Universidad Polit?cnica de Valencia (UPV)
Camino de Vera, s/n, Edificio G-8, Acceso B, 3? planta
Valencia - 46022 (Espa?a)
___
openEHR-clinical mailing list
openehr-clini...@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-clinical_lists.openehr.org
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: New paper: Archetype-based data warehouse environment

2015-06-19 Thread Ricardo Correia 
Many congrats

A sex, 19/06/2015, 09:07, David Moner  escreveu:

> Dear all,
>
> My colleagues Luis Marco-Ruiz, José A. Maldonado, Nils Kolstrup, Johan G.
> Bellika and myself have just published a paper titled "Archetype-based data
> warehouse environment to enable the reuse of electronic health record data"
> in the International Journal of Medical Informatics. I think this work can
> be of interest for many of you.
>
> Best regards,
> David
>
> Link: http://www.sciencedirect.com/science/article/pii/S1386505615300058
>
> Abstract:
>
> - Background. The reuse of data captured during health care delivery is
> essential to satisfy the demands of clinical research and clinical decision
> support systems. A main barrier for the reuse is the existence of legacy
> formats of data and the high granularity of it when stored in an electronic
> health record (EHR) system. Thus, we need mechanisms to standardize,
> aggregate, and query data concealed in the EHRs, to allow their reuse
> whenever they are needed.
> - Objective. To create a data warehouse infrastructure using
> archetype-based technologies, standards and query languages to enable the
> interoperability needed for data reuse.
> - Materials and methods. The work presented makes use of best of breed
> archetype-based data transformation and storage technologies to create a
> workflow for the modeling, extraction, transformation and load of EHR
> proprietary data into standardized data repositories. We converted legacy
> data and performed patient-centered aggregations via archetype-based
> transformations. Later, specific purpose aggregations were performed at a
> query level for particular use cases.
> - Results. Laboratory test results of a population of 230,000 patients
> belonging to Troms and Finnmark counties in Norway requested between
> January 2013 and November 2014 have been standardized. Test records
> normalization has been performed by defining transformation and aggregation
> functions between the laboratory records and an archetype. These mappings
> were used to automatically generate open EHR compliant data. These data
> were loaded into an archetype-based data warehouse. Once loaded, we defined
> indicators linked to the data in the warehouse to monitor test activity of
> Salmonella and Pertussis using the archetype query language.
> - Discussion. Archetype-based standards and technologies can be used to
> create a data warehouse environment that enables data from EHR systems to
> be reused in clinical research and decision support systems. With this
> approach, existing EHR data becomes available in a standardized and
> interoperable format, thus opening a world of possibilities toward semantic
> or concept-based reuse, query and communication of clinical data.
>
>
> --
> David Moner Cano
> Grupo de Informática Biomédica - IBIME
> Instituto ITACA
> http://www.ibime.upv.es
> http://www.linkedin.com/in/davidmoner
>
> Universidad Politécnica de Valencia (UPV)
> Camino de Vera, s/n, Edificio G-8, Acceso B, 3ª planta
> Valencia – 46022 (España)
>  ___
> openEHR-technical mailing list
> openEHR-technical@lists.openehr.org
>
> http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

New paper: Archetype-based data warehouse environment

2015-06-19 Thread David Moner 
Dear all,

My colleagues Luis Marco-Ruiz, José A. Maldonado, Nils Kolstrup, Johan G.
Bellika and myself have just published a paper titled "Archetype-based data
warehouse environment to enable the reuse of electronic health record data"
in the International Journal of Medical Informatics. I think this work can
be of interest for many of you.

Best regards,
David

Link: http://www.sciencedirect.com/science/article/pii/S1386505615300058

Abstract:

- Background. The reuse of data captured during health care delivery is
essential to satisfy the demands of clinical research and clinical decision
support systems. A main barrier for the reuse is the existence of legacy
formats of data and the high granularity of it when stored in an electronic
health record (EHR) system. Thus, we need mechanisms to standardize,
aggregate, and query data concealed in the EHRs, to allow their reuse
whenever they are needed.
- Objective. To create a data warehouse infrastructure using
archetype-based technologies, standards and query languages to enable the
interoperability needed for data reuse.
- Materials and methods. The work presented makes use of best of breed
archetype-based data transformation and storage technologies to create a
workflow for the modeling, extraction, transformation and load of EHR
proprietary data into standardized data repositories. We converted legacy
data and performed patient-centered aggregations via archetype-based
transformations. Later, specific purpose aggregations were performed at a
query level for particular use cases.
- Results. Laboratory test results of a population of 230,000 patients
belonging to Troms and Finnmark counties in Norway requested between
January 2013 and November 2014 have been standardized. Test records
normalization has been performed by defining transformation and aggregation
functions between the laboratory records and an archetype. These mappings
were used to automatically generate open EHR compliant data. These data
were loaded into an archetype-based data warehouse. Once loaded, we defined
indicators linked to the data in the warehouse to monitor test activity of
Salmonella and Pertussis using the archetype query language.
- Discussion. Archetype-based standards and technologies can be used to
create a data warehouse environment that enables data from EHR systems to
be reused in clinical research and decision support systems. With this
approach, existing EHR data becomes available in a standardized and
interoperable format, thus opening a world of possibilities toward semantic
or concept-based reuse, query and communication of clinical data.


-- 
David Moner Cano
Grupo de Informática Biomédica - IBIME
Instituto ITACA
http://www.ibime.upv.es
http://www.linkedin.com/in/davidmoner

Universidad Politécnica de Valencia (UPV)
Camino de Vera, s/n, Edificio G-8, Acceso B, 3ª planta
Valencia – 46022 (España)
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org