This article has Open Peer Review reports available.
A metadata approach for clinical data management in translational genomics studies in breast cancer
© Papatheodorou et al; licensee BioMed Central Ltd. 2009
Received: 11 February 2009
Accepted: 30 November 2009
Published: 30 November 2009
In molecular profiling studies of cancer patients, experimental and clinical data are combined in order to understand the clinical heterogeneity of the disease: clinical information for each subject needs to be linked to tumour samples, macromolecules extracted, and experimental results. This may involve the integration of clinical data sets from several different sources: these data sets may employ different data definitions and some may be incomplete.
In this work we employ semantic web techniques developed within the CancerGrid project, in particular the use of metadata elements and logic-based inference to annotate heterogeneous clinical information, integrate and query it.
We show how this integration can be achieved automatically, following the declaration of appropriate metadata elements for each clinical data set; we demonstrate the practicality of this approach through application to experimental results and clinical data from five hospitals in the UK and Canada, undertaken as part of the METABRIC project (Molecular Taxonomy of Breast Cancer International Consortium).
We describe a metadata approach for managing similarities and differences in clinical datasets in a standardized way that uses Common Data Elements (CDEs). We apply and evaluate the approach by integrating the five different clinical datasets of METABRIC.
The METABRIC study (Molecular Taxonomy of Breast Cancer International Consortium) is an example of molecular profiling studies on cancer patients that aim to associate experimental results with clinical datasets in order to understand the clinical heterogeneity of the disease. The patient cohorts used are large and the clinical information is consolidated from a number of hospital databases that use different data definitions and often hold incomplete datasets. Patient information is often scattered in different databases within a hospital, or even between different hospitals, as patients are not necessarily treated by the same hospital throughout the course of their disease and/or relapse. Moreover, patient cohorts usually span a large period of time and depending on when the hospital started to record patient data electronically, this can result in incomplete clinical datasets. In addition to these, standard treatment and diagnosis procedures have changed throughout the last three decades, resulting in different types of information being accumulated over time. An example is the HER2 bio-marker assay, which has been a standard test, recorded at diagnosis, in our collaborating hospitals in Canada for the last few years, whereas only recently it has started being assessed regularly in the collaborating UK hospitals.
The different hospital databases have not been designed to conform to some agreed standards for data representation and meanings. They have been developed to fulfill the specific requirements of the hospital unit, and the data is described according to the definitions of assessments and concepts that are used locally. An example, is the use of Nottingham Prognostic Index (NPI)  versus the TNM classification scheme . The databases we encountered in this study record either of those but never both. In addition to this, the TNM classification scheme is updated every few years, so any samples obtained at different times will have been classified by different TNM versions. The lack of common standards for cancer data representation and also the lack of a standardised means for relating from one classification scheme to another makes data sharing and integration a challenging task.
The semantic web is a term used to describe a collection of initiatives and technologies aimed at associating data with some representation of its meaning, so that we might access or process the data on the basis of its semantics, rather than its form or location. Although the technologies of the semantic web, such as the Resource Description Framework (RDF) [3, 4] and the Web Ontology Language (OWL)  are still very much under development, they are already being applied widely in business, government, and scientific contexts .
Two Cancer Informatics projects, caBIG [7–10] and CancerGrid [11–13], are employing semantic web technology aiming to develop tools that assist the management of cancer data and the interoperability of different hospitals and research centres.
Both caBIG and CancerGrid have developed tools that assist in the development of standardised methodologies for data integration and sample tracking in the context of cancer clinical trials. In each case, there has been an emphasis upon standardising the way in which procedures and observations are described, rather than upon agreeing a single set of common procedures. The only difference is that the process for arriving at standardised descriptions is, at present, centralised in caBIG, and distributed in CancerGrid: in the former, descriptions are standardised by reference to a single, global classification scheme; in the latter, researchers are free to construct a scheme that reflects their local purpose and immediate needs, and then relate this scheme to others as and when necessary. This has meant in turn that there is a greater emphasis in CancerGrid upon support for the evolution of descriptions and protocols - with software artifacts (such as forms and queries) being generated to match successive versions of a model.
In this work, we use the model- or metadata- driven approach employed by the CancerGrid project, since it is best suited for the clinical data integration in the METABRIC project. We do not attempt to transform the data from the five different databases so that they conform to a common description. This would lead to abstracting information out of the data and losing detail that might be important in the interpretation of experiments. Instead, we develop a method that enables us to store the data using their original definitions using Common Data Elements (CDEs).
In order to query the data, we employ SQIV (Crichton, C., et al In preparation), a set of CancerGrid tools for Standardization, Querying, Inference and Validation that processes the data using pre-defined inference rules that model the relationships between CDEs.
The problem of integrating data from multiple sources is very similar to those addressed by federated database systems [14, 15]; a simplistic view of these is that they allow multiple databases, with different schemas, to be queried using one global schema. In the research context, where different organisations and even individuals may have different views on the relationships between the schemas, this type of system is too restrictive. Instead, we feel that our approach to the classification of data using CDEs, along with mappings between those CDEs, allows us to tackle the issue of semantic heterogeneity whilst giving the individual researcher the freedom to pick the semantics they think is appropriate.
The rest of the paper is structured as follows. First, we provide a description of the Metadata Repository (MDR) implementation and SQIV. Then we describe the model that integrates the five different source database models and we explain how the data is imported and queried. Finally, we discuss the usefulness of the approach and identify directions for future improvements.
Common Data Elements & Metadata Repository
A Common Data Element (CDE) is a metadata definition with an informal explanation of its meaning and usage, a list of alternative names and definitions, units of measurement, and the type of values to be recorded. CDEs can be created for any kind of concept, measurement, or application, and, although grouped into "Data Element Concepts" for convenience, need not derive their meaning from their position in a complex hierarchy or graph. This is in contrast to the ontological approach to data definition, often used in bioinformatics applications [16, 17], where each subclass is part of a specification for a representational vocabulary for a particular domain . Although classifications or ontologies can be added to a database of CDEs, they can be used to support navigation and inference on an application-specific basis: there is no requirement to locate a CDE within an existing domain ontology before recording the semantics of a data definition.
The Metadata Repository (MDR) is a database that stores CDEs. The information stored includes the identifier of the CDE and more details such as definition, value domain, unit of measure, property and object class where the CDE belongs to. Its purpose is to address the semantics, the representation and the registration of the descriptions of data. We are using the metadata repository implementation developed by the CancerGrid project http://cancergrid.org/downloads/, whose structure conforms to the ISO/IEC11179 international standard for metadata repositories . The CancerGrid MDR implementation provides tools for registering, updating and browsing CDEs, concepts, properties and their definitions, as well as searching and basic classification tools.
In order to compare and query the data in practice, we transform it to some agreed dataset definitions by use of the functions for Data Standardization, Inference and Querying available in SQIV http://cancergrid.org/downloads/sqiv/, a command line java tool.
Standardization is a process that takes data formatted in XML according to an XML schema that is annotated with CDE identifier and produces equivalent RDF for further processing, for example querying or inference. RDF, the Resource Description Framework, is one of the core technologies of the semantic web.
The Querying process takes RDF and allows this to be queried using SPARQL, or to be converted back into XML using an XML schema annotated with CDE identifiers to define the output format.
Finally, the Inference process allows reasoning about semantically annotated data, in order to produce richer data, or data in terms of other meta-data identifiers. In METABRIC, we use the inference function to map the original data definitions to the METABRIC specific ones, as demonstrated in later sections.
The METABRIC project (Molecular Taxonomy of Breast Cancer International Consortium) collects clinical and genomic data on breast cancer tumours from five different hospitals/research centres in the UK and Canada. METABRIC has been approved by the 'NHS National Research Ethics Service, Cambridgeshire 4 Research Ethics Committee' with reference number: 07/MRE05/35. The aim of the project is to generate a robust molecular taxonomy of clinically annotated breast cancers. METABRIC will analyse 2000 breast tumours using a combination of high resolution array-CGH, expression profiling, sequencing and tissue microarray analysis, and correlate the molecular profiles obtained with the clinical outcome of the tumours.
The clinical data used for this study are being obtained from five different sources: in the UK the Cambridge Breast Unit at Addenbrooke's Hospital (Cambridge), Guy's Hospital (London) and Nottingham University City Hospital and in Canada the Tumour Bank of British Columbia (Vancouver) and the Manitoba Tumour Bank. The clinical information required was determined by the aim of the molecular profiling study and it includes survival data, such as date and cause of death, treatment information, such as chemotherapy, surgery and radiotherapy type and bio-marker information such as ER, PR and HER2 status.
Data collection has been a complex process in some cases, since information about a patient was stored in different specialised databases (for example, pathology information, radiotherapy, chemotherapy, clinical trials databases) within the same hospital that were not managed by a central system. The data had to be extracted from all of these and related to each other, in order to achieve a single clinical dataset from each hospital.
Moreover, the vocabularies of the five different data sources differed significantly in parts. There were cases where similar fields were defined using different classification schemes, the most striking example being 'tumour histological type', which was defined differently in each one of the five sources. Other differences included compound measurements that use different types of assessment. For example the Estrogen Receptor levels are recorded using either an immunohistochemistry method or a biochemical assay. Some hospitals record it using one method, others using the other and there are cases where one method was used in earlier breast cancer cases and then it was replaced by a new assessment.
Instead of transforming the data into a common classification scheme for each one of these fields, we create CDEs that record each field definition from each data source. We represent each field of each one of the source databases by a Common Data Element (CDE). This process resulted in 50 CDEs and 33 data element concepts.
In addition to the CDEs that represent each field from each data source, we also record 29 CDEs that define the type of information required by the METABRIC minimum dataset definition (i.e. the clinical information required by the METABRIC study, in the format described by the METABRIC collaborators). CDEs have been curated by the investigators, clinicians and pathologists contributing to the METABRIC study.
Clinical Database Model
The XML schemas describe the structure of the XML documents that are used to record the information for the patients and tumour samples. Each element on each XML schema is mapped with the appropriate CDE identifier by means of SAWSDL references, making use of the recent extension of XML schema: Semantic Annotations for the Web Services Description Language WSDL (SAWSDL)  that supports semantic annotation.
For the reasons discussed earlier in the Background Section, some fields have been defined differently by some or all five sources. For example 'menopausal status at diagnosis' is described as 'clinically determined' in some databases. In others the 'menopausal status at diagnosis' is inferred by the 'age at diagnosis', with patients over 50 years old recorded as post-menopausal and patients less than 50 described as pre-menopausal.
Both 'inferred' and 'clinical' elements are modeled as parts of the complex element 'menopausal status at diagnosis' to record the data according to the format in which it was described by the original database.
However, at the level of XML schema, the 'clinical' menopausal status element is associated with the 'clinical menopausal status' CDE identifier, whereas the 'inferred' menopausal status element is associated with the 'inferred menopausal status' CDE identifier.
Similarly, in the cases of 'histological type of tumour' and 'relapse type', different databases have used different classification schemes. Some databases use the same classification for all three types of relapse (local, regional, distant). Others only record distant relapse type (using a different classification scheme) and others record local and distant relapse types only, again using different classification schemes. The different classification schemes are modeled as sub-classes to a more general class 'relapse', in a similar fashion to the 'menopausal status at diagnosis' element.
The clinical datasets that are used in METABRIC are received in batches, in tabular format from the different hospital databases. Direct access to the clinical databases is not granted due to the participating hospitals' security regulations involving the protection of patient information. The tabular data sets are then converted into XML documents according to the related CDE-annotated XML schemas in a semi-automated manner, using the built-in functionality of excel or relational database management systems for XML export and XSLT documents. The specifics of the transformation method depend on the schema and data vocabulary of the data source.
Using the inference functionality of SQIV we can pre-process the data in an automatic way, in order to perform any transformations that do not result in information loss but will decrease redundancy in the database (e.g. transform all tumour size values to centimeters). In more detail, we first standardize the data to an RDF format. The Standardization function of SQIV takes as input the XML document containing the original data, the XML schema document that is annotated with the CDE identifiers for each element and outputs an RDF file that contains the mappings between the XML data and the CDE identifiers. Once the data is standardized, we can use the inference tool of SQIV in order to make any transformations required. For this we develop rules that map the CDE annotated data to values of the agreed METABRIC CDEs using the Jena Semantic Web Framework . The Jena Semantic Web Framework is a Java API, employed by the inference tool of SQIV that performs reasoning and in this case transforms the data according to our rules. The result is an RDF file with the new CDE annotations and values, which can then be converted to XML using the Querying tool of SQIV and a METABRIC XML schema. The resulting XML documents are then stored into an eXist database .
The eXist database system, where the clinical data is stored, supports standard querying tools for XML data, such as XQuery and XPath. However, in order to query across differently defined data fields that are annotated with CDEs we employ the use of reasoning tools.
This work demonstrates how data from different sources can be integrated using semantic annotation, in order to support a large scale collaborative study. For the METABRIC study we developed 79 CDEs that correspond to 33 different data element concepts. Currently, we are testing the method on larger datasets, of about 2000 patients, as we are collecting clinical data from the five collaborating centres of the project and populating the database. At the same time we are enriching the set of inference rules to cater for more cases and we are testing more thoroughly the inference and standardisation functionalities of SQIV. Our experience with the import of 2000 patient records, in batches ranging from 300 to 900 records from five different hospitals has so far been successful.
For the quantities of information we are dealing with in METABRIC (and related research studies) the integration process and the technology used scale up satisfactorily. Integrating more heterogeneous data from a significantly larger number of sources would require the creation of a large number of inference rules that relate CDEs. The speed of SQIV inference would decrease with larger number of records and/or more complex Jena rules. Such cases, dealing with millions of records and a large number of CDE relations, may be tackled by standard optimisation methods and caching.
The ISO/IEC11179 standard for metadata registries employed here provides a simple metadata schema for elements, concepts, value domains and properties. Issues associated with the ISO/IEC11179 include the lack of any structuring of data elements, apart from their association with data element concepts. The question on how to extend (or simplify) ISO/IEC11179 to allow for information structuring in a usable and understandable way is a subject of ongoing research . Here, we were able to overcome this issue by formulating rules in Jena that relate multiple CDEs and deduce the values of inferred CDEs.
The value of this work, as we see it, is that it enables researchers to create and use CDEs and also provide semantics describing the relationship between CDEs that is appropriate to the scope of their current research project. We believe that this 'bottom-up' approach is particularly useful in a research environment, where definitions and semantics change frequently. Different CDEs, as well as their subsequent versions, are given unique identifiers and the relations between them can be formulated on demand and according to their usage, while older versions of CDEs and relations are stored.
Alternative 'top down' approaches, such as ontologies, could be used to model the relationships between CDEs in a more systematic way. Such methods would require that the relationships between CDEs are defined in advance and could be limiting in research situations, where competing views about what relationships between CDEs must exist.
In this context, and after our experience with the inference rules in METABRIC, the main direction for future work is on structuring the information between CDEs, by storing the relationships between them at a higher level that reflects the inference patterns that are actually being used. We plan to construct an ontology of CDE relations, reflecting the Jena rules used in METABRIC with the view of developing a generalised approach of extracting a structure of CDEs from the existing relations between them. Further planned improvements to the metadata registry and SQIV tool include improving support for XML schema custom simple types and their use for data validation and support for the direct standardization of a wider range of data sources.
Researchers and clinicians in different hospitals and research centres use different ways of describing and representing their data, for reasons ranging from adhering to a certain local (or national) terminology to the scope of the database they develop. Moreover, these data descriptions change regularly as new methods for medical tests become available. Semantic annotation of the data, ensures that meaning and usage of the data is recorded and enables re-use of the data, and integration with other resources.
We described a general approach for integrating and managing similarities and differences between different datasets using CDEs and inference rules. This approach ensures no information loss, since the datasets are stored according to their original definitions and classification schemes, but at the same time enables data comparison. We apply the approach on clinical data where concepts are described using different classification schemes. However, the approach can be applied for integrating any type of data where similar concepts have been described differently or the data is incomplete.
We thank Steve Harris (CancerGrid, Oxford) for developing the Metadata Repository used for creating and storing all CDEs. Moreover, we thank the clinical and scientific METABRIC collaborators. The METABRIC group consists of: C. Caldas, J. Brenton, S. Tavaré, G. Wishart, E. Provenzano, S.F. Chin, I. Papatheodorou, I. Spiteri in Cambridge; I. Ellis, A. Green in Nottingham; A. D. Purushotham, S. Pinder, A. Tutt, C. Gillet in Guy's Hospital; S. Aparicio, D. Huntsman, C. Speers in Vancouver; M. Parisien in Manitoba. We also thank David Greenberg and Karen Wright from the ECRIC (Eastern Cancer Registry and Information Centre), Linda Jones from the Cambridge ECMC (Experimental Cancer Medicine Centre), Amanda O'Neill and Vince Taylor from the NIHR Cambridge BMRC (Cambridge Biomedical Research Centre) for providing the database vocabularies and curating the CDEs. METABRIC is funded by Cancer Research UK and by the British Columbia Cancer Foundation. CancerGrid is funded by the MRC and by Microsoft External Research. Irene Papatheodorou is the Jean Lorraine Bulmer Research Fellow at the Cambridge Research Institute.
- Haybittle J, Blamey R, Elston C, Johnson J, Doyle P, Campbell F, Nicholson R, Griffiths K: A prognostic index in primary breast cancer. Br J Cancer. 1982, 45 (3): 361-366.View ArticlePubMedPubMed CentralGoogle Scholar
- Souhami R, Tobias J: Cancer and its management. 2005, BlackwellView ArticleGoogle Scholar
- W3C: RDF/XML Syntax Specification. 2004, [http://www.w3.org/TR/rdf-syntax-grammar/]Google Scholar
- Lassila O, Swick R: Resource Description Framework (RDF) model and syntax specification. Tech. rep. 1998Google Scholar
- Antoniou G: A Semantic Web Primer. 2004, MIT PressGoogle Scholar
- Stevens R, Goble CA, Bechhofer S: Ontology-based Knowledge Representation for Bioinformatics. Briefings in Bioinformatics. 2000, 1 (4): 398-414. 10.1093/bib/1.4.398.View ArticlePubMedGoogle Scholar
- Saltz J, Oster S, Hastings S, Langella S, Kurc T, Sanchez W, Kher M, Mnisundaram A, Shanbhag K, Covitz P: caGRID: Design and implementation of the core architecture of the cancer biomedical informatics grid. Bioinformatics. 2006, 22 (15): 1910-1916. 10.1093/bioinformatics/btl272.View ArticlePubMedGoogle Scholar
- Covitz PA, Hartel FW, Schaefer C, de Coronado S, Fragoso G, Sahni H, Gustafson S, Buetow KH: caCORE: A common infrastructure for cancer informatics. Bioinformatics. 2003, 19 (18): 2404-2412. 10.1093/bioinformatics/btg335.View ArticlePubMedGoogle Scholar
- Hartel FW, de Coronado S, Dionne R, Fragoso G, Golbeck J: Modeling a description logic vocabulary for cancer research. Journal of Biomedical Informatics. 2005, 38 (2): 114-129. 10.1016/j.jbi.2004.09.001.View ArticlePubMedGoogle Scholar
- Fragoso G, de Coronado S, Haber M, Hartel F, Wright L: Overview and utilization of the NCI Thesaurus: Conference Papers. Comp Funct Genomics. 2004, 5 (8): 648-654. 10.1002/cfg.445.View ArticlePubMedPubMed CentralGoogle Scholar
- Calinescu R, Harris S, Gibbons J, Davies J: Cross-Trial Query System for Cancer Clinical Trials. Innovations and Advanced Techniques in Computer and Information Sciences and Engineering. 2007, Springer, 385-390.View ArticleGoogle Scholar
- Calinescu R, Harris S, Gibbons J, Davies J, Toujilov I, Nagl SB: Model-driven architecture for cancer research. SEFM '07: Proceedings of the Fifth IEEE International Conference on Software Engineering and Formal Methods. 2007, Washington, DC, USA: IEEE Computer Society, 59-68.View ArticleGoogle Scholar
- Zang T, Calinescu R, Harris S, Tsui A, Kwiatkowska M, Gibbons J, Davies J, Maccallum P, Caldas C: WSRF-Based Modeling of Clinical Trial Information for Collaborative Cancer Research. CCGRID '08: Proceedings of the 2008 Eighth IEEE International Symposium on Cluster Computing and the Grid (CCGRID). 2008, Washington, DC, USA: IEEE Computer Society, 73-81.View ArticleGoogle Scholar
- Sheth A, Larson J: Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Computing Surveys (CSUR). 1990, 22 (3): 183-236. 10.1145/96602.96604.View ArticleGoogle Scholar
- Marenco L, Wang TY, Shepherd G, Miller PL, Nadkarni P: QIS: A Framework for Biomedical Database Federation. J Am Med Inform Assoc. 2004, 11 (6): 523-534. 10.1197/jamia.M1506.View ArticlePubMedPubMed CentralGoogle Scholar
- Smith B: The Logic of Biological Classification and the Foundations of Biomedical Ontology. 10th International Conference in Logic Methodology and the Philosophy of Science. 2004, Elsevier-NorthHollandGoogle Scholar
- Rector AL: What's in a code? Towards a Formal Account of the Relation of Ontologies and Coding Systems. Studies In Health Technology And Informatics. 2007, 129: 730-734.PubMedGoogle Scholar
- Gruber TR: A translation approach to portable ontology specifications. Knowledge Acquisition. 1993, 5 (2): 199-220. 10.1006/knac.1993.1008.View ArticleGoogle Scholar
- ISO/IEC11179: ISO/IEC11179 international standard for metadata repositories. 2007, [http://metadata-stds.org/11179/]Google Scholar
- Kopecký J, Vitvar T, Bournez C, Farrell J: SAWSDL: Semantic Annotations for WSDL and XML Schema. IEEE Internet Computing. 2007, 11 (6): 60-67. 10.1109/MIC.2007.134.View ArticleGoogle Scholar
- McBride B: Jena: Implementing the RDF Model and Syntax Specification. Proceedings of the Second International Workshop on the Semantic Web (SemWeb). 2001Google Scholar
- Meier W: eXist: An Open Source Native XML Database. Web, Web-Services, and Database Systems. NODe. 2002, 7-10.Google Scholar
- Davies J, Harris S, Crichton C, Shukla A, Gibbons J: Metadata Standards for Semantic Interoperability in Electronic Government. International Conference on Theory and Practice of Electronic Governance, Cairo. 2008Google Scholar
- The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1755-8794/2/66/prepub
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.