{"id":"https://openalex.org/W2974377501","doi":"https://doi.org/10.1109/access.2019.2941925","title":"Performance Analysis of Not Only SQL Semi-Stream Join Using MongoDB for Real-Time Data Warehousing","display_name":"Performance Analysis of Not Only SQL Semi-Stream Join Using MongoDB for Real-Time Data Warehousing","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2974377501","doi":"https://doi.org/10.1109/access.2019.2941925","mag":"2974377501"},"language":"en","primary_location":{"id":"doi:10.1109/access.2019.2941925","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2019.2941925","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08840837.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08840837.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090225150","display_name":"Erum Mehmood","orcid":"https://orcid.org/0000-0001-9424-8274"},"institutions":[{"id":"https://openalex.org/I87482320","display_name":"University of Management and Technology","ror":"https://ror.org/0095xcq10","country_code":"PK","type":"education","lineage":["https://openalex.org/I87482320"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Erum Mehmood","raw_affiliation_strings":["School of Systems and Technology, University of Management and Technology, Lahore, Pakistan"],"raw_orcid":"https://orcid.org/0000-0001-9424-8274","affiliations":[{"raw_affiliation_string":"School of Systems and Technology, University of Management and Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I87482320"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5024941166","display_name":"Tayyaba Anees","orcid":"https://orcid.org/0000-0003-2266-9322"},"institutions":[{"id":"https://openalex.org/I87482320","display_name":"University of Management and Technology","ror":"https://ror.org/0095xcq10","country_code":"PK","type":"education","lineage":["https://openalex.org/I87482320"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Tayyaba Anees","raw_affiliation_strings":["School of Systems and Technology, University of Management and Technology, Lahore, Pakistan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Systems and Technology, University of Management and Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I87482320"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I87482320"],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":2.3102,"has_fulltext":true,"cited_by_count":26,"citation_normalized_percentile":{"value":0.89549142,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"7","issue":null,"first_page":"134215","last_page":"134225"},"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.9994999766349792,"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.9994999766349792,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9968000054359436,"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/T11106","display_name":"Data Management and Algorithms","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.8819506168365479},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.8306899070739746},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7760813236236572},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7581835985183716},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7104568481445312},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6336216926574707},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6009814739227295},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.54625004529953},{"id":"https://openalex.org/keywords/stream-processing","display_name":"Stream processing","score":0.495047003030777},{"id":"https://openalex.org/keywords/semi-structured-data","display_name":"Semi-structured data","score":0.4842810034751892},{"id":"https://openalex.org/keywords/data-stream-mining","display_name":"Data stream mining","score":0.4479658901691437},{"id":"https://openalex.org/keywords/data-stream","display_name":"Data stream","score":0.4476880729198456},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.4264914095401764},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.32535576820373535},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2889265716075897},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.2857626676559448},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.14438268542289734},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12668955326080322},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1190272867679596},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.11051687598228455}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8819506168365479},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.8306899070739746},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7760813236236572},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7581835985183716},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7104568481445312},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6336216926574707},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6009814739227295},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.54625004529953},{"id":"https://openalex.org/C107027933","wikidata":"https://www.wikidata.org/wiki/Q2006448","display_name":"Stream processing","level":2,"score":0.495047003030777},{"id":"https://openalex.org/C40077939","wikidata":"https://www.wikidata.org/wiki/Q2336004","display_name":"Semi-structured data","level":3,"score":0.4842810034751892},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.4479658901691437},{"id":"https://openalex.org/C2778484313","wikidata":"https://www.wikidata.org/wiki/Q1172540","display_name":"Data stream","level":2,"score":0.4476880729198456},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.4264914095401764},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.32535576820373535},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2889265716075897},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2857626676559448},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.14438268542289734},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12668955326080322},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1190272867679596},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.11051687598228455},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/access.2019.2941925","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2019.2941925","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08840837.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:36989ef22f6544889ddeb67756f3fcc1","is_oa":true,"landing_page_url":"https://doaj.org/article/36989ef22f6544889ddeb67756f3fcc1","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","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":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IEEE Access, Vol 7, Pp 134215-134225 (2019)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1109/access.2019.2941925","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2019.2941925","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08840837.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.5699999928474426,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2974377501.pdf","grobid_xml":"https://content.openalex.org/works/W2974377501.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W574355879","https://openalex.org/W1499784129","https://openalex.org/W1917129590","https://openalex.org/W1995751017","https://openalex.org/W2006595462","https://openalex.org/W2051695193","https://openalex.org/W2103106131","https://openalex.org/W2294631971","https://openalex.org/W2465893152","https://openalex.org/W2586697060","https://openalex.org/W2624552449","https://openalex.org/W2692297252","https://openalex.org/W2706966281","https://openalex.org/W2750514106","https://openalex.org/W2806273945","https://openalex.org/W2888868755","https://openalex.org/W2889062015","https://openalex.org/W2922169274","https://openalex.org/W2951057248","https://openalex.org/W6739619331"],"related_works":["https://openalex.org/W3169445913","https://openalex.org/W3098434254","https://openalex.org/W2897381437","https://openalex.org/W2516859113","https://openalex.org/W60511584","https://openalex.org/W3030659426","https://openalex.org/W2771285273","https://openalex.org/W3005809278","https://openalex.org/W2392980054","https://openalex.org/W2564234978"],"abstract_inverted_index":{"Data":[0],"warehousing":[1],"has":[2],"been":[3],"indispensable":[4],"to":[5,39],"enterprises":[6],"for":[7,47,57,102,117,133,164],"decades.":[8],"However,":[9],"infrequently":[10],"updated":[11],"data":[12,23,35,51,63,146,173],"warehouse":[13,36],"environment":[14],"does":[15],"not":[16],"support":[17],"quicker":[18],"business":[19],"decisions":[20],"and":[21,49,72,105,130,144,150,159],"faster":[22],"recovery":[24],"in":[25,100,122],"case":[26],"of":[27,33,42,61,141,169,172],"transformation":[28],"or":[29,176],"load":[30],"issue.":[31],"Implementation":[32],"real-time":[34,62,134],"provides":[37],"solution":[38],"update":[40],"problems":[41],"enterprises.":[43],"Efficient":[44],"stream":[45],"processing":[46,137],"un-structured(NoSQL)":[48],"structured(SQL)":[50],"from":[52,88],"various":[53],"sources":[54,90],"is":[55],"required":[56],"the":[58,112,128,170],"successful":[59],"implementation":[60],"warehousing.":[64],"We":[65],"have":[66,126],"done":[67],"an":[68],"analysis":[69],"between":[70],"un-structured":[71,104,143],"structured":[73,106,145],"semi-stream":[74,135],"join":[75,136],"processing,":[76],"using":[77,108,148],"efficient":[78],"database":[79],"engine":[80],"MongoDB":[81,109],"at":[82],"Extraction-Transformation-Loading":[83],"phase.":[84],"Semi-stream":[85],"tuples":[86],"coming":[87],"different":[89,116],"are":[91,115,182],"joined":[92],"with":[93],"disk-based":[94],"master":[95],"data,":[96],"based":[97],"on":[98],"keys":[99],"memory,":[101],"both":[103,118],"documents(tuples)":[107],"server,":[110],"where":[111],"I/O":[113],"rates":[114],"inputs.":[119],"Through":[120],"experiments,":[121],"this":[123],"paper":[124],"we":[125],"analyzed":[127],"CPU":[129],"memory":[131,157],"usage":[132,158],"through":[138],"two":[139],"types":[140],"tests,":[142],"streams":[147,174],"synthetic":[149],"real":[151],"datasets.":[152],"The":[153],"results":[154],"show":[155],"that,":[156],"execution":[160],"time":[161],"remains":[162],"consistent":[163],"a":[165],"given":[166],"specification":[167],"irrespective":[168],"nature":[171],"(un-structured":[175],"structured),":[177],"even":[178],"when":[179],"incoming":[180],"semi-streams":[181],"growing.":[183]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":7},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":5}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}