{"id":"https://openalex.org/W2200355770","doi":"https://doi.org/10.1109/bigdata.2015.7364068","title":"SQL-like big data environments: Case study in clinical trial analytics","display_name":"SQL-like big data environments: Case study in clinical trial analytics","publication_year":2015,"publication_date":"2015-10-01","ids":{"openalex":"https://openalex.org/W2200355770","doi":"https://doi.org/10.1109/bigdata.2015.7364068","mag":"2200355770"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata.2015.7364068","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2015.7364068","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.13016/m2bz61c6x","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083560131","display_name":"Akshay Grover","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Akshay Grover","raw_affiliation_strings":["Computer Science and Electrical Engineering"],"affiliations":[{"raw_affiliation_string":"Computer Science and Electrical Engineering","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043540088","display_name":"Jay Gholap","orcid":null},"institutions":[{"id":"https://openalex.org/I79272384","display_name":"University of Maryland, Baltimore County","ror":"https://ror.org/02qskvh78","country_code":"US","type":"education","lineage":["https://openalex.org/I79272384"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jay Gholap","raw_affiliation_strings":["Information Systems University of Maryland, Baltimore County"],"affiliations":[{"raw_affiliation_string":"Information Systems University of Maryland, Baltimore County","institution_ids":["https://openalex.org/I79272384"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063541070","display_name":"Vandana P. Janeja","orcid":"https://orcid.org/0000-0003-0130-6135"},"institutions":[{"id":"https://openalex.org/I79272384","display_name":"University of Maryland, Baltimore County","ror":"https://ror.org/02qskvh78","country_code":"US","type":"education","lineage":["https://openalex.org/I79272384"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vandana P. Janeja","raw_affiliation_strings":["Information Systems University of Maryland, Baltimore County"],"affiliations":[{"raw_affiliation_string":"Information Systems University of Maryland, Baltimore County","institution_ids":["https://openalex.org/I79272384"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072869372","display_name":"Yelena Yesha","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yelena Yesha","raw_affiliation_strings":["Computer Science and Electrical Engineering"],"affiliations":[{"raw_affiliation_string":"Computer Science and Electrical Engineering","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064605614","display_name":"Raghu Chintalapati","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Raghu Chintalapati","raw_affiliation_strings":["Ekagra Software Technologies"],"affiliations":[{"raw_affiliation_string":"Ekagra Software Technologies","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004233092","display_name":"Harsh Marwaha","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Harsh Marwaha","raw_affiliation_strings":["Ekagra Software Technologies"],"affiliations":[{"raw_affiliation_string":"Ekagra Software Technologies","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5078206380","display_name":"Kunal Modi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kunal Modi","raw_affiliation_strings":["Ekagra Software Technologies"],"affiliations":[{"raw_affiliation_string":"Ekagra Software Technologies","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5083560131"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.1514,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.96901418,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"2680","last_page":"2689"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9987000226974487,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9987000226974487,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9979000091552734,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9901999831199646,"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/computer-science","display_name":"Computer science","score":0.8270267248153687},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.7623242139816284},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.7048766016960144},{"id":"https://openalex.org/keywords/software-portability","display_name":"Software portability","score":0.6698317527770996},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6455143690109253},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5116901397705078},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.43493399024009705},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4254201352596283},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.421084463596344},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4101772904396057},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2511778473854065},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09237822890281677}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8270267248153687},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.7623242139816284},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.7048766016960144},{"id":"https://openalex.org/C63000827","wikidata":"https://www.wikidata.org/wiki/Q3080428","display_name":"Software portability","level":2,"score":0.6698317527770996},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6455143690109253},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5116901397705078},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.43493399024009705},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4254201352596283},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.421084463596344},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4101772904396057},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2511778473854065},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09237822890281677}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/bigdata.2015.7364068","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata.2015.7364068","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"},{"id":"pmh:oai:mdsoar.org:11603/11811","is_oa":false,"landing_page_url":"http://hdl.handle.net/11603/11811","pdf_url":null,"source":{"id":"https://openalex.org/S4306402556","display_name":"Maryland Shared Open Access Repository (USMAI Consortium)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Text"},{"id":"doi:10.13016/m2bz61c6x","is_oa":true,"landing_page_url":"https://doi.org/10.13016/m2bz61c6x","pdf_url":null,"source":{"id":"https://openalex.org/S4306402644","display_name":"Digital Repository at the University of Maryland (University of Maryland College Park)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I66946132","host_organization_name":"University of Maryland, College Park","host_organization_lineage":["https://openalex.org/I66946132"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.13016/m2bz61c6x","is_oa":true,"landing_page_url":"https://doi.org/10.13016/m2bz61c6x","pdf_url":null,"source":{"id":"https://openalex.org/S4306402644","display_name":"Digital Repository at the University of Maryland (University of Maryland College Park)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I66946132","host_organization_name":"University of Maryland, College Park","host_organization_lineage":["https://openalex.org/I66946132"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320337347","display_name":"National Institute on Drug Abuse","ror":"https://ror.org/00fq5cm18"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W46913361","https://openalex.org/W564945117","https://openalex.org/W1494137514","https://openalex.org/W1749271337","https://openalex.org/W2029084939","https://openalex.org/W2106625078","https://openalex.org/W2110086534","https://openalex.org/W2215130741","https://openalex.org/W2394680079","https://openalex.org/W2497756700"],"related_works":["https://openalex.org/W2621972978","https://openalex.org/W2373918503","https://openalex.org/W3129344858","https://openalex.org/W3001928035","https://openalex.org/W2791661407","https://openalex.org/W4320802139","https://openalex.org/W4301431331","https://openalex.org/W2588045195","https://openalex.org/W4385834214","https://openalex.org/W2957025774"],"abstract_inverted_index":{"Big":[0],"Data":[1,142],"deals":[2],"with":[3,213],"enormous":[4],"volumes":[5],"of":[6,29,47,85,111,119,155,192,221],"complex":[7],"and":[8,39,45,66,190],"exponentially":[9],"growing":[10],"data":[11,30,48,64,80,90,114,131,166,211],"sets":[12],"from":[13],"multiple":[14,128],"sources.":[15],"With":[16,42,195],"rapid":[17],"growth":[18],"in":[19,31,49,62,77,104,147,157],"technology,":[20],"we":[21,107,217],"are":[22],"now":[23],"able":[24],"to":[25,58,70,88,96,181,198],"generate":[26],"immense":[27],"amount":[28,46],"almost":[32],"any":[33],"field":[34],"imaginable":[35],"including":[36],"physical,":[37],"biological":[38],"biomedical":[40],"sciences.":[41],"the":[43,60,83,98,109,117,153,196],"diversity":[44],"health":[50],"care":[51],"industry":[52],"there":[53],"is":[54,82,94],"an":[55],"increasing":[56],"need":[57],"evaluate":[59,108,218],"components":[61],"big":[63,79,89,113,130,210],"frameworks":[65],"gauge":[67],"their":[68],"adaptability":[69],"analytics":[71],"techniques.":[72],"However,":[73],"a":[74,178,209],"key":[75,183],"step":[76],"adapting":[78],"tools":[81],"portability":[84,118],"relational":[86,121],"databases":[87,150],"environment.":[91],"Since":[92],"SQL":[93,223],"considered":[95],"be":[97,206],"de-facto":[99],"language":[100],"for":[101,116,140,151],"interactive":[102],"queries,":[103],"this":[105],"paper,":[106],"performance":[110],"SQL-like":[112,129,215],"solutions":[115],"existing":[120],"databases.":[122],"Our":[123],"work":[124],"focuses":[125],"on":[126,170,208],"benchmarking":[127],"technologies":[132],"over":[133],"Hadoop":[134],"based":[135],"distributed":[136],"file":[137],"system":[138],"(HDFS)":[139],"Study":[141],"Tabulation":[143],"Model":[144],"(SDTM)":[145],"used":[146],"clinical":[148,158,164,202],"trial":[149,165,203],"improving":[152],"efficiency":[154,191],"research":[156],"trials.":[159],"We":[160],"use":[161],"publically":[162],"available":[163],"(from":[167],"National":[168],"Institute":[169],"Drug":[171],"Abuse":[172],"(NIDA)),":[173],"which":[174],"follows":[175],"SDTM,":[176],"as":[177],"test":[179],"bed":[180],"measure":[182],"parameters":[184],"like":[185],"usability,":[186],"adaptability,":[187],"modularity,":[188],"robustness":[189],"these":[193],"solutions.":[194],"intention":[197],"demonstrate":[199],"how":[200],"current":[201],"functionality":[204],"can":[205],"replicated":[207],"backend":[212],"high":[214],"functionality,":[216],"several":[219],"types":[220],"ad-hoc":[222],"queries.":[224]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}