{"id":"https://openalex.org/W7142014055","doi":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105","title":"Hybrid NoSQL-SQL Database Architectures for Real-Time Big Data Analytics and Scalable Cloud Applications","display_name":"Hybrid NoSQL-SQL Database Architectures for Real-Time Big Data Analytics and Scalable Cloud Applications","publication_year":2024,"publication_date":"2024-01-01","ids":{"openalex":"https://openalex.org/W7142014055","doi":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105"},"language":"en","primary_location":{"id":"doi:10.63282/3117-5481/aijcst-v6i1p105","doi":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105","is_oa":true,"landing_page_url":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105","pdf_url":"https://aijcst.org/index.php/aijcst/article/download/186/171","source":{"id":"https://openalex.org/S5407054643","display_name":"American International Journal of Computer Science and Technology","issn_l":"3117-5481","issn":["3117-5481"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"American International Journal of Computer Science and Technology","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://aijcst.org/index.php/aijcst/article/download/186/171","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5130770564","display_name":"Venkata Kishore Chilakapati","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Venkata Kishore Chilakapati","raw_affiliation_strings":["Support Escalation Engineer,  Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Support Escalation Engineer,  Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5123599385","display_name":"Srikanth Reddy Keshireddy","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Srikanth Reddy Keshireddy","raw_affiliation_strings":["Senior Software Engineer, Keen Info Tek Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Senior Software Engineer, Keen Info Tek Inc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130812102","display_name":"Venkata Teja Nagumotu","orcid":"https://orcid.org/0009-0007-7190-3249","observed_orcids":["https://orcid.org/0009-0007-7190-3249"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Venkata Teja Nagumotu","raw_affiliation_strings":["Sr Network Engineer, Techno-bytes Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Sr Network Engineer, Techno-bytes Inc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5118605932","display_name":"Harsha Vardhan Reddy Kavuluri","orcid":"https://orcid.org/0009-0005-6003-6464","observed_orcids":["https://orcid.org/0009-0005-6003-6464"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Harsha Vardhan Reddy Kavuluri","raw_affiliation_strings":["Lead database administrator, Wissen infotech Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lead database administrator, Wissen infotech Inc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130768387","display_name":"Akhil Kumar Pathani","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Akhil Kumar Pathani","raw_affiliation_strings":["Network Engineer, Ebay"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Network Engineer, Ebay","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5130796872","display_name":"Ajay Dasari","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ajay Dasari","raw_affiliation_strings":["Senior Support Engineer, Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Senior Support Engineer, Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.42817787,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"6","issue":null,"first_page":"50","last_page":"59"},"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.975600004196167,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.975600004196167,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.019099999219179153,"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/T14280","display_name":"Big Data Technologies and Applications","score":0.0038999998942017555,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/nosql-databases","display_name":"NoSQL databases","score":0.7459999918937683},{"id":"https://openalex.org/keywords/in-memory-databases","display_name":"in-memory databases","score":0.8080000281333923},{"id":"https://openalex.org/keywords/distributed-file-systems","display_name":"distributed file systems","score":0.8270000219345093},{"id":"https://openalex.org/keywords/real-time-data-ingestion","display_name":"real-time data ingestion","score":0.921999990940094},{"id":"https://openalex.org/keywords/distributed-query-optimization","display_name":"distributed query optimization","score":0.8550000190734863},{"id":"https://openalex.org/keywords/schema-transformation","display_name":"schema transformation","score":0.7960000038146973},{"id":"https://openalex.org/keywords/stream-processing-frameworks","display_name":"stream processing frameworks","score":0.7559999823570251},{"id":"https://openalex.org/keywords/cloud-scalability","display_name":"cloud scalability","score":0.7450000047683716},{"id":"https://openalex.org/keywords/predictive-scaling","display_name":"predictive scaling","score":0.6690000295639038}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8432999849319458},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.7351999878883362},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.7318000197410583},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6912999749183655},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6017000079154968},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.522599995136261},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.46470001339912415},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.42910000681877136},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.428600013256073},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4271000027656555},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.42399999499320984},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.3935999870300293},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.3917999863624573},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.3910999894142151},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3840000033378601},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.32589998841285706},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.320499986410141},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.3084000051021576},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.30169999599456787},{"id":"https://openalex.org/C93361087","wikidata":"https://www.wikidata.org/wiki/Q4426698","display_name":"Data consistency","level":2,"score":0.2948000133037567},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2912999987602234},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.2750000059604645},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.2700999975204468},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.2646999955177307},{"id":"https://openalex.org/C107027933","wikidata":"https://www.wikidata.org/wiki/Q2006448","display_name":"Stream processing","level":2,"score":0.2632000148296356},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.2587999999523163},{"id":"https://openalex.org/C50897621","wikidata":"https://www.wikidata.org/wiki/Q2665508","display_name":"Hybrid system","level":2,"score":0.2535000145435333},{"id":"https://openalex.org/C194739806","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Computer data storage","level":2,"score":0.2502000033855438}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.63282/3117-5481/aijcst-v6i1p105","doi":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105","is_oa":true,"landing_page_url":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105","pdf_url":"https://aijcst.org/index.php/aijcst/article/download/186/171","source":{"id":"https://openalex.org/S5407054643","display_name":"American International Journal of Computer Science and Technology","issn_l":"3117-5481","issn":["3117-5481"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"American International Journal of Computer Science and Technology","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.63282/3117-5481/aijcst-v6i1p105","doi":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105","is_oa":true,"landing_page_url":"https://doi.org/10.63282/3117-5481/aijcst-v6i1p105","pdf_url":"https://aijcst.org/index.php/aijcst/article/download/186/171","source":{"id":"https://openalex.org/S5407054643","display_name":"American International Journal of Computer Science and Technology","issn_l":"3117-5481","issn":["3117-5481"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"American International Journal of Computer Science and Technology","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7142014055.pdf","grobid_xml":"https://content.openalex.org/works/W7142014055.grobid-xml"},"referenced_works_count":16,"referenced_works":["https://openalex.org/W1968509117","https://openalex.org/W2549017613","https://openalex.org/W2567696826","https://openalex.org/W2574252967","https://openalex.org/W2625113730","https://openalex.org/W2750764235","https://openalex.org/W2790623212","https://openalex.org/W2809044511","https://openalex.org/W2913041555","https://openalex.org/W2957025774","https://openalex.org/W2981461708","https://openalex.org/W2987794387","https://openalex.org/W2991266382","https://openalex.org/W4412891125","https://openalex.org/W7085665413","https://openalex.org/W7124308988"],"related_works":["https://openalex.org/W2574252967","https://openalex.org/W2903114088","https://openalex.org/W4412824373","https://openalex.org/W7202280086","https://openalex.org/W2519074544","https://openalex.org/W2752495101","https://openalex.org/W2607794957","https://openalex.org/W3025254365","https://openalex.org/W4409185242","https://openalex.org/W7084172274"],"abstract_inverted_index":{"The":[0,52,77,138],"increasing":[1],"data":[2,15,50,69,81,156,184],"volume,":[3],"velocity":[4],"and":[5,22,41,66,92,94,108,134,157],"variety":[6],"has":[7],"been":[8],"a":[9,29,72,146,173],"serious":[10],"challenge":[11],"to":[12,46,121,177],"the":[13,100,126,168,170,178],"conventional":[14],"management":[16],"systems.":[17,166,186],"To":[18],"overcome":[19],"scalability,":[20],"heterogeneity":[21],"low-latency":[23],"processing":[24,63],"issues,":[25],"this":[26],"paper":[27,78],"discusses":[28],"hybrid":[30,75,135,142],"SQL-NoSQL":[31,143],"architecture,":[32],"which":[33],"combines":[34],"in-memory":[35],"databases":[36,39],"(MMDB),":[37],"relational":[38],"(RDB)":[40],"distributed":[42,131],"file":[43],"systems":[44,113,144],"(DFS)":[45],"manage":[47],"spatio-temporal":[48],"big":[49,183],"efficiently.":[51],"framework":[53,176],"that":[54,141],"is":[55,114,119],"proposed":[56],"allows":[57],"real-time":[58,150],"ingestion":[59],"of":[60,64,102,111,128,149,152,155,180],"data,":[61],"on-the-fly":[62],"analytics,":[65],"scalable":[67],"long-term":[68],"storage":[70],"using":[71],"single":[73],"integrated":[74],"framework.":[76],"also":[79],"analyzes":[80],"interoperability,":[82],"ACID-":[83],"BASIS":[84],"consistency":[85,136],"trade-offs,":[86],"streaming":[87],"systems/frameworks,":[88],"e.g.,":[89],"Spark,":[90],"Flink":[91],"Storm":[93],"event-driven":[95],"high-velocity":[96],"analytics":[97,185],"architectures.":[98],"Also,":[99],"use":[101],"AI/ML":[103],"methods":[104],"in":[105,125],"predictive":[106],"scaling":[107],"performance":[109],"optimization":[110],"cloud-based":[112],"pointed":[115],"out.":[116],"Literature":[117],"review":[118],"conducted":[120],"establish":[122],"major":[123],"gaps":[124],"areas":[127],"schema":[129],"transformation,":[130],"query":[132],"optimization,":[133],"management.":[137],"results":[139],"reveal":[140],"provide":[145],"robust":[147],"platform":[148],"analysis":[151],"large":[153],"amounts":[154],"scalability":[158],"cloud":[159],"applications":[160],"as":[161,163],"well":[162],"modern":[164],"decision-making":[165],"On":[167],"overall,":[169],"study":[171],"presents":[172],"thorough":[174],"architectural":[175],"creation":[179],"scalable,":[181],"real-time,":[182]},"counts_by_year":[],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2026-03-29T00:00:00"}