{"id":"https://openalex.org/W2941395963","doi":"https://doi.org/10.3233/978-1-61499-959-1-21","title":"An Extension of the i2b2 Data Warehouse to Support REDCap Dynamic Data Pull","display_name":"An Extension of the i2b2 Data Warehouse to Support REDCap Dynamic Data Pull","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2941395963","doi":"https://doi.org/10.3233/978-1-61499-959-1-21","mag":"2941395963","pmid":"https://pubmed.ncbi.nlm.nih.gov/30942706"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-959-1-21","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-959-1-21","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/A5060879777","display_name":"Matteo Gabetta","orcid":"https://orcid.org/0000-0001-9140-768X"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Gabetta Matteo","raw_affiliation_strings":["BIOMERIS, Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"BIOMERIS, Pavia, Italy","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052240006","display_name":"Marco Mirabelli","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mirabelli Marco","raw_affiliation_strings":["Dep. of Electrical, Computer and Biomedical Engineering, University of Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"Dep. of Electrical, Computer and Biomedical Engineering, University of Pavia, Italy","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071676789","display_name":"Catherine Klersy","orcid":"https://orcid.org/0000-0003-0314-8548"},"institutions":[{"id":"https://openalex.org/I4210153126","display_name":"Istituti di Ricovero e Cura a Carattere Scientifico","ror":"https://ror.org/04tfzc498","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210153126"]},{"id":"https://openalex.org/I4210151645","display_name":"Policlinico San Matteo Fondazione","ror":"https://ror.org/05w1q1c88","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Klersy Catherine","raw_affiliation_strings":["Fondazione IRCCS Policlinico San Matteo, Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"Fondazione IRCCS Policlinico San Matteo, Pavia, Italy","institution_ids":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026632453","display_name":"Valeria Musella","orcid":"https://orcid.org/0000-0001-9517-2670"},"institutions":[{"id":"https://openalex.org/I4210153126","display_name":"Istituti di Ricovero e Cura a Carattere Scientifico","ror":"https://ror.org/04tfzc498","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210153126"]},{"id":"https://openalex.org/I4210151645","display_name":"Policlinico San Matteo Fondazione","ror":"https://ror.org/05w1q1c88","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Musella Valeria","raw_affiliation_strings":["Fondazione IRCCS Policlinico San Matteo, Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"Fondazione IRCCS Policlinico San Matteo, Pavia, Italy","institution_ids":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001248487","display_name":"Gianpiero Rizzo","orcid":"https://orcid.org/0000-0003-1946-4967"},"institutions":[{"id":"https://openalex.org/I4210151645","display_name":"Policlinico San Matteo Fondazione","ror":"https://ror.org/05w1q1c88","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]},{"id":"https://openalex.org/I4210153126","display_name":"Istituti di Ricovero e Cura a Carattere Scientifico","ror":"https://ror.org/04tfzc498","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210153126"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Rizzo Gianpiero","raw_affiliation_strings":["Fondazione IRCCS Policlinico San Matteo, Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"Fondazione IRCCS Policlinico San Matteo, Pavia, Italy","institution_ids":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065961744","display_name":"Paolo Pedrazzoli","orcid":"https://orcid.org/0000-0002-9419-7160"},"institutions":[{"id":"https://openalex.org/I4210151645","display_name":"Policlinico San Matteo Fondazione","ror":"https://ror.org/05w1q1c88","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]},{"id":"https://openalex.org/I4210153126","display_name":"Istituti di Ricovero e Cura a Carattere Scientifico","ror":"https://ror.org/04tfzc498","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210153126"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Pedrazzoli Paolo","raw_affiliation_strings":["Fondazione IRCCS Policlinico San Matteo, Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"Fondazione IRCCS Policlinico San Matteo, Pavia, Italy","institution_ids":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056107988","display_name":"Nicola Barbarini","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Barbarini Nicola","raw_affiliation_strings":["BIOMERIS, Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"BIOMERIS, Pavia, Italy","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050932220","display_name":"Riccardo Bellazzi","orcid":"https://orcid.org/0000-0002-6974-9808"},"institutions":[{"id":"https://openalex.org/I4210151645","display_name":"Policlinico San Matteo Fondazione","ror":"https://ror.org/05w1q1c88","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]},{"id":"https://openalex.org/I4210153126","display_name":"Istituti di Ricovero e Cura a Carattere Scientifico","ror":"https://ror.org/04tfzc498","country_code":"IT","type":"healthcare","lineage":["https://openalex.org/I4210153126"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Bellazzi Riccardo","raw_affiliation_strings":["IRCCS Fondazione Policlinico San Matteo"],"affiliations":[{"raw_affiliation_string":"IRCCS Fondazione Policlinico San Matteo","institution_ids":["https://openalex.org/I4210151645","https://openalex.org/I4210153126"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048692097","display_name":"Cristiana Larizza","orcid":"https://orcid.org/0000-0002-5055-8665"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Larizza Cristiana","raw_affiliation_strings":["Dep. of Electrical, Computer and Biomedical Engineering, University of Pavia, Italy"],"affiliations":[{"raw_affiliation_string":"Dep. of Electrical, Computer and Biomedical Engineering, University of Pavia, Italy","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5060879777"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.8547,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.69376081,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"258","issue":null,"first_page":"21","last_page":"25"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9908999800682068,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9908999800682068,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9517999887466431,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9222000241279602,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5824177265167236},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5552991032600403},{"id":"https://openalex.org/keywords/electronic-data-capture","display_name":"Electronic data capture","score":0.5362972617149353},{"id":"https://openalex.org/keywords/web-service","display_name":"Web service","score":0.45163094997406006},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4392145276069641},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2368735671043396},{"id":"https://openalex.org/keywords/bioinformatics","display_name":"Bioinformatics","score":0.15698546171188354},{"id":"https://openalex.org/keywords/clinical-trial","display_name":"Clinical trial","score":0.10774099826812744},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.07896167039871216}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5824177265167236},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5552991032600403},{"id":"https://openalex.org/C91790935","wikidata":"https://www.wikidata.org/wiki/Q5358348","display_name":"Electronic data capture","level":3,"score":0.5362972617149353},{"id":"https://openalex.org/C35578498","wikidata":"https://www.wikidata.org/wiki/Q193424","display_name":"Web service","level":2,"score":0.45163094997406006},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4392145276069641},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2368735671043396},{"id":"https://openalex.org/C60644358","wikidata":"https://www.wikidata.org/wiki/Q128570","display_name":"Bioinformatics","level":1,"score":0.15698546171188354},{"id":"https://openalex.org/C535046627","wikidata":"https://www.wikidata.org/wiki/Q30612","display_name":"Clinical trial","level":2,"score":0.10774099826812744},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.07896167039871216}],"mesh":[{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000078332","descriptor_name":"Data Analysis","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000078332","descriptor_name":"Data Analysis","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000078332","descriptor_name":"Data Analysis","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.3233/978-1-61499-959-1-21","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-959-1-21","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:30942706","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/30942706","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":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5799999833106995}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2099525665","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890"],"abstract_inverted_index":{"i2b2":[0],"and":[1,16],"REDCap":[2,22,73],"are":[3],"two":[4],"widely":[5],"adopted":[6],"solutions":[7],"respectively":[8],"to":[9,17,27,33,60],"facilitate":[10],"data":[11,35,62],"re-use":[12],"for":[13],"research":[14,20],"purpose":[15],"manage":[18],"non-for-profit":[19],"studies.":[21],"provides":[23],"the":[24],"design":[25],"specifications":[26,57],"build":[28],"a":[29,41,51,71],"web":[30,52],"service":[31,53],"used":[32],"import":[34,61],"from":[36,63],"an":[37],"external":[38],"source":[39],"with":[40,70],"procedure":[42],"called":[43],"DDP.":[44],"In":[45],"this":[46],"work":[47],"we":[48],"have":[49],"developed":[50],"that":[54],"implements":[55],"these":[56],"in":[58],"order":[59],"i2b2.":[64],"Our":[65],"approach":[66],"has":[67],"been":[68],"tested":[69],"real":[72],"study.":[74]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}