{"id":"https://openalex.org/W2512734842","doi":"https://doi.org/10.3233/978-1-61499-678-1-567","title":"Unlocking Data for Statistical Analyses and Data Mining: Generic Case Extraction of Clinical Items from i2b2 and tranSMART","display_name":"Unlocking Data for Statistical Analyses and Data Mining: Generic Case Extraction of Clinical Items from i2b2 and tranSMART","publication_year":2016,"publication_date":"2016-01-01","ids":{"openalex":"https://openalex.org/W2512734842","doi":"https://doi.org/10.3233/978-1-61499-678-1-567","mag":"2512734842","pmid":"https://pubmed.ncbi.nlm.nih.gov/27577447"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-678-1-567","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-678-1-567","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"article","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5031442638","display_name":"Daniel Firnkorn","orcid":null},"institutions":[{"id":"https://openalex.org/I223822909","display_name":"Heidelberg University","ror":"https://ror.org/038t36y30","country_code":"DE","type":"education","lineage":["https://openalex.org/I223822909"]},{"id":"https://openalex.org/I4210099379","display_name":"Zimmer Biomet (Germany)","ror":"https://ror.org/016731f38","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210099379","https://openalex.org/I4210115238"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Firnkorn Daniel","raw_affiliation_strings":["Institute of Medical Biometry and Informatics, Heidelberg University, Germany"],"affiliations":[{"raw_affiliation_string":"Institute of Medical Biometry and Informatics, Heidelberg University, Germany","institution_ids":["https://openalex.org/I4210099379","https://openalex.org/I223822909"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070108740","display_name":"Sebastian R. Merker","orcid":"https://orcid.org/0000-0002-7550-2967"},"institutions":[{"id":"https://openalex.org/I223822909","display_name":"Heidelberg University","ror":"https://ror.org/038t36y30","country_code":"DE","type":"education","lineage":["https://openalex.org/I223822909"]},{"id":"https://openalex.org/I4210099379","display_name":"Zimmer Biomet (Germany)","ror":"https://ror.org/016731f38","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210099379","https://openalex.org/I4210115238"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Merker Sebastian","raw_affiliation_strings":["Institute of Medical Biometry and Informatics, Heidelberg University, Germany"],"affiliations":[{"raw_affiliation_string":"Institute of Medical Biometry and Informatics, Heidelberg University, Germany","institution_ids":["https://openalex.org/I4210099379","https://openalex.org/I223822909"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058906885","display_name":"Matthias Ganzinger","orcid":"https://orcid.org/0000-0002-2716-5425"},"institutions":[{"id":"https://openalex.org/I223822909","display_name":"Heidelberg University","ror":"https://ror.org/038t36y30","country_code":"DE","type":"education","lineage":["https://openalex.org/I223822909"]},{"id":"https://openalex.org/I4210099379","display_name":"Zimmer Biomet (Germany)","ror":"https://ror.org/016731f38","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210099379","https://openalex.org/I4210115238"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Ganzinger Matthias","raw_affiliation_strings":["Institute of Medical Biometry and Informatics, Heidelberg University, Germany"],"affiliations":[{"raw_affiliation_string":"Institute of Medical Biometry and Informatics, Heidelberg University, Germany","institution_ids":["https://openalex.org/I4210099379","https://openalex.org/I223822909"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085505239","display_name":"Thomas Muley","orcid":"https://orcid.org/0000-0002-8141-0604"},"institutions":[{"id":"https://openalex.org/I223822909","display_name":"Heidelberg University","ror":"https://ror.org/038t36y30","country_code":"DE","type":"education","lineage":["https://openalex.org/I223822909"]},{"id":"https://openalex.org/I2802164966","display_name":"University Hospital Heidelberg","ror":"https://ror.org/013czdx64","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2802164966"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Muley Thomas","raw_affiliation_strings":["Translational Research Unit, Thoraxklinik at University Hospital Heidelberg, Heidelberg"],"affiliations":[{"raw_affiliation_string":"Translational Research Unit, Thoraxklinik at University Hospital Heidelberg, Heidelberg","institution_ids":["https://openalex.org/I223822909","https://openalex.org/I2802164966"]}]},{"author_position":"last","author":{"id":null,"display_name":"Knaup Petra","orcid":null},"institutions":[{"id":"https://openalex.org/I223822909","display_name":"Heidelberg University","ror":"https://ror.org/038t36y30","country_code":"DE","type":"education","lineage":["https://openalex.org/I223822909"]},{"id":"https://openalex.org/I4210099379","display_name":"Zimmer Biomet (Germany)","ror":"https://ror.org/016731f38","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210099379","https://openalex.org/I4210115238"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Knaup Petra","raw_affiliation_strings":["Institute of Medical Biometry and Informatics, Heidelberg University, Germany"],"affiliations":[{"raw_affiliation_string":"Institute of Medical Biometry and Informatics, Heidelberg University, Germany","institution_ids":["https://openalex.org/I4210099379","https://openalex.org/I223822909"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5031442638"],"corresponding_institution_ids":["https://openalex.org/I223822909","https://openalex.org/I4210099379"],"apc_list":null,"apc_paid":null,"fwci":3.152,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.92361478,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"228","issue":null,"first_page":"567","last_page":"71"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9642000198364258,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.929099977016449,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6882519721984863},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5861809849739075},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.565850555896759},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5511958003044128},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.5441625118255615},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.5425764322280884},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5230358839035034},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.5198915004730225},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.44582852721214294},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.4290480613708496},{"id":"https://openalex.org/keywords/health-informatics","display_name":"Health informatics","score":0.42257025837898254},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4203988313674927},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.35558652877807617},{"id":"https://openalex.org/keywords/medline","display_name":"MEDLINE","score":0.1640383005142212},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.15077155828475952},{"id":"https://openalex.org/keywords/medicine","display_name":"Medicine","score":0.12654030323028564},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.08536559343338013}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6882519721984863},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5861809849739075},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.565850555896759},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5511958003044128},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.5441625118255615},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5425764322280884},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5230358839035034},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.5198915004730225},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.44582852721214294},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.4290480613708496},{"id":"https://openalex.org/C145642194","wikidata":"https://www.wikidata.org/wiki/Q870895","display_name":"Health informatics","level":3,"score":0.42257025837898254},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4203988313674927},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.35558652877807617},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.1640383005142212},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.15077155828475952},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.12654030323028564},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.08536559343338013},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C159110408","wikidata":"https://www.wikidata.org/wiki/Q121176","display_name":"Nursing","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C138816342","wikidata":"https://www.wikidata.org/wiki/Q189603","display_name":"Public health","level":2,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.0}],"mesh":[{"descriptor_ui":"D000068598","descriptor_name":"Data Accuracy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000068598","descriptor_name":"Data Accuracy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000068598","descriptor_name":"Data Accuracy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D066275","descriptor_name":"Health Information Exchange","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D066275","descriptor_name":"Health Information Exchange","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D066275","descriptor_name":"Health Information Exchange","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true}],"locations_count":2,"locations":[{"id":"doi:10.3233/978-1-61499-678-1-567","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-678-1-567","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:27577447","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/27577447","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in health technology and informatics","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.41999998688697815,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2364409751","https://openalex.org/W2901826185","https://openalex.org/W3119296476","https://openalex.org/W2742521120","https://openalex.org/W2359411520","https://openalex.org/W2159392828","https://openalex.org/W2353586736","https://openalex.org/W1503556420","https://openalex.org/W2189235061","https://openalex.org/W2353590449"],"abstract_inverted_index":{"In":[0,89],"medical":[1,35,75],"science,":[2],"modern":[3],"IT":[4],"concepts":[5],"are":[6,66,81,112,126,172],"increasingly":[7],"important":[8],"to":[9,54,130,139,233,246],"gather":[10],"new":[11],"findings":[12],"out":[13],"of":[14,58,101,104,168,180,200,221,253,260],"complex":[15,241],"diseases.":[16],"Data":[17],"Warehouses":[18],"(DWH)":[19],"as":[20],"central":[21],"data":[22,36,49,91,109,135,142,157,255],"repository":[23],"systems":[24,277],"play":[25],"a":[26,86,97,141,177,197,209,226,237,272],"key":[27],"role":[28],"by":[29,188],"providing":[30],"standardized,":[31],"high-quality":[32],"and":[33,51,64,93,108,124,154,162,170,257],"secure":[34],"for":[37,74,229,276],"effective":[38],"analyses.":[39],"However,":[40],"DWHs":[41],"in":[42,85,115,236,251],"medicine":[43],"must":[44],"fulfil":[45],"various":[46],"requirements":[47],"concerning":[48],"privacy":[50],"the":[52,56,102,131,189,218,258],"ability":[53],"describe":[55],"complexity":[57],"(rare)":[59],"disease":[60],"phenomena.":[61],"Here,":[62],"i2b2":[63,123,169],"tranSMART":[65,125,171],"free":[67],"alternatives":[68],"representing":[69],"DWH":[70],"solutions":[71],"especially":[72,250],"developed":[73,208],"informatics":[76],"purposes.":[77],"But":[78],"different":[79,254],"functionalities":[80],"not":[82],"yet":[83],"provided":[84],"sufficient":[87,232],"way.":[88],"fact,":[90],"import":[92],"export":[94,136,166],"is":[95,137,269],"still":[96],"major":[98],"problem":[99],"because":[100],"diversity":[103],"schemas,":[105],"parameter":[106],"definitions":[107],"quality":[110],"which":[111,144,183,216],"described":[113],"variously":[114],"each":[116,201,222,230],"single":[117],"clinic.":[118],"Further,":[119],"statistical":[120],"analyses":[121,235],"inside":[122,271],"possible,":[127],"but":[128,262],"restricted":[129],"implemented":[132],"functions.":[133],"Thus,":[134],"needed":[138],"provide":[140],"basis":[143],"can":[145],"be":[146,185],"directly":[147],"included":[148],"within":[149],"statistics":[150],"software":[151,274],"like":[152,160,265],"SPSS":[153],"SAS":[155],"or":[156,174,196],"mining":[158],"tools":[159,167],"Weka":[161],"RapidMiner.":[163],"The":[164],"standard":[165],"more":[173],"less":[175],"creating":[176],"database":[178],"dump":[179],"key-value":[181,219],"pairs":[182,220],"cannot":[184],"used":[186],"immediately":[187],"mentioned":[190],"tools.":[191],"They":[192],"need":[193],"an":[194],"instance-based":[195],"case-based":[198],"representation":[199],"patient.":[202],"To":[203],"overcome":[204],"this":[205],"lack,":[206],"we":[207],"concept":[210],"called":[211],"Generic":[212],"Case":[213],"Extractor":[214],"(GCE)":[215],"pivots":[217],"clinical":[223],"fact":[224],"into":[225],"row-oriented":[227],"format":[228],"patient":[231],"enable":[234],"broader":[238],"context.":[239],"Therefore,":[240],"pivotisation":[242],"routines":[243],"where":[244],"necessary":[245],"ensure":[247],"temporal":[248],"consistency":[249],"terms":[252],"sets":[256],"occurrence":[259],"identical":[261],"repeated":[263],"parameters":[264],"follow-up":[266],"data.":[267],"GCE":[268],"embedded":[270],"comprehensive":[273],"platform":[275],"medicine.":[278]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":5}],"updated_date":"2026-04-16T08:26:57.006410","created_date":"2025-10-10T00:00:00"}