{"id":"https://openalex.org/W4404032025","doi":"https://doi.org/10.1109/icccnt61001.2024.10724191","title":"Optimizing Crop Monitoring: A Data Warehouse Approach in Precision Agriculture","display_name":"Optimizing Crop Monitoring: A Data Warehouse Approach in Precision Agriculture","publication_year":2024,"publication_date":"2024-06-24","ids":{"openalex":"https://openalex.org/W4404032025","doi":"https://doi.org/10.1109/icccnt61001.2024.10724191"},"language":"en","primary_location":{"id":"doi:10.1109/icccnt61001.2024.10724191","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icccnt61001.2024.10724191","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 15th International Conference on Computing Communication and Networking Technologies (ICCCNT)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"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/A5045926305","display_name":"Isha Agarwal","orcid":"https://orcid.org/0000-0002-9094-9118"},"institutions":[{"id":"https://openalex.org/I42014448","display_name":"Sardar Vallabhbhai National Institute of Technology Surat","ror":"https://ror.org/02y394t43","country_code":"IN","type":"education","lineage":["https://openalex.org/I42014448"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Isha Agarwal","raw_affiliation_strings":["Sardar Vallabhbhai National Institute of Technology (SVNIT),Avionics Lab,Surat,India"],"affiliations":[{"raw_affiliation_string":"Sardar Vallabhbhai National Institute of Technology (SVNIT),Avionics Lab,Surat,India","institution_ids":["https://openalex.org/I42014448"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065416217","display_name":"Dipti P. Rana","orcid":"https://orcid.org/0000-0002-5058-1355"},"institutions":[{"id":"https://openalex.org/I42014448","display_name":"Sardar Vallabhbhai National Institute of Technology Surat","ror":"https://ror.org/02y394t43","country_code":"IN","type":"education","lineage":["https://openalex.org/I42014448"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Dipti Rana","raw_affiliation_strings":["Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India"],"affiliations":[{"raw_affiliation_string":"Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India","institution_ids":["https://openalex.org/I42014448"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114194363","display_name":"P.G. Shah","orcid":"https://orcid.org/0000-0002-4055-1611"},"institutions":[{"id":"https://openalex.org/I42014448","display_name":"Sardar Vallabhbhai National Institute of Technology Surat","ror":"https://ror.org/02y394t43","country_code":"IN","type":"education","lineage":["https://openalex.org/I42014448"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Priyanshi Shah","raw_affiliation_strings":["Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India"],"affiliations":[{"raw_affiliation_string":"Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India","institution_ids":["https://openalex.org/I42014448"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114511865","display_name":"Aayush Dude","orcid":null},"institutions":[{"id":"https://openalex.org/I42014448","display_name":"Sardar Vallabhbhai National Institute of Technology Surat","ror":"https://ror.org/02y394t43","country_code":"IN","type":"education","lineage":["https://openalex.org/I42014448"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Aayush Dude","raw_affiliation_strings":["Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India"],"affiliations":[{"raw_affiliation_string":"Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India","institution_ids":["https://openalex.org/I42014448"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5064438983","display_name":"Pooja Patel","orcid":"https://orcid.org/0000-0002-6148-3953"},"institutions":[{"id":"https://openalex.org/I42014448","display_name":"Sardar Vallabhbhai National Institute of Technology Surat","ror":"https://ror.org/02y394t43","country_code":"IN","type":"education","lineage":["https://openalex.org/I42014448"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Pooja Patel","raw_affiliation_strings":["Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India"],"affiliations":[{"raw_affiliation_string":"Sardar Vallabhbhai National Institute of Technology (SVNIT),Department of Computer Science and Engg.,Surat,India","institution_ids":["https://openalex.org/I42014448"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5045926305"],"corresponding_institution_ids":["https://openalex.org/I42014448"],"apc_list":null,"apc_paid":null,"fwci":1.3001,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.85044754,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10616","display_name":"Smart Agriculture and AI","score":0.9473999738693237,"subfield":{"id":"https://openalex.org/subfields/1110","display_name":"Plant Science"},"field":{"id":"https://openalex.org/fields/11","display_name":"Agricultural and Biological Sciences"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T10616","display_name":"Smart Agriculture and AI","score":0.9473999738693237,"subfield":{"id":"https://openalex.org/subfields/1110","display_name":"Plant Science"},"field":{"id":"https://openalex.org/fields/11","display_name":"Agricultural and Biological Sciences"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5878359079360962},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5610684752464294},{"id":"https://openalex.org/keywords/precision-agriculture","display_name":"Precision agriculture","score":0.5462800860404968},{"id":"https://openalex.org/keywords/crop","display_name":"Crop","score":0.47709375619888306},{"id":"https://openalex.org/keywords/agriculture","display_name":"Agriculture","score":0.4672541320323944},{"id":"https://openalex.org/keywords/warehouse","display_name":"Warehouse","score":0.46292591094970703},{"id":"https://openalex.org/keywords/agricultural-engineering","display_name":"Agricultural engineering","score":0.41736167669296265},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3370620310306549},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.16032135486602783},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.11665332317352295},{"id":"https://openalex.org/keywords/forestry","display_name":"Forestry","score":0.09696453809738159}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5878359079360962},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5610684752464294},{"id":"https://openalex.org/C120217122","wikidata":"https://www.wikidata.org/wiki/Q740083","display_name":"Precision agriculture","level":3,"score":0.5462800860404968},{"id":"https://openalex.org/C137580998","wikidata":"https://www.wikidata.org/wiki/Q235352","display_name":"Crop","level":2,"score":0.47709375619888306},{"id":"https://openalex.org/C118518473","wikidata":"https://www.wikidata.org/wiki/Q11451","display_name":"Agriculture","level":2,"score":0.4672541320323944},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.46292591094970703},{"id":"https://openalex.org/C88463610","wikidata":"https://www.wikidata.org/wiki/Q194118","display_name":"Agricultural engineering","level":1,"score":0.41736167669296265},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3370620310306549},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.16032135486602783},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.11665332317352295},{"id":"https://openalex.org/C97137747","wikidata":"https://www.wikidata.org/wiki/Q38112","display_name":"Forestry","level":1,"score":0.09696453809738159},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icccnt61001.2024.10724191","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icccnt61001.2024.10724191","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 15th International Conference on Computing Communication and Networking Technologies (ICCCNT)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.8299999833106995,"display_name":"Zero hunger","id":"https://metadata.un.org/sdg/2"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1600079720","https://openalex.org/W2062982970","https://openalex.org/W2082948153","https://openalex.org/W2166391252","https://openalex.org/W2200121095","https://openalex.org/W2567643124","https://openalex.org/W2603417106","https://openalex.org/W2945967375","https://openalex.org/W2951517349","https://openalex.org/W2971480543","https://openalex.org/W2983056308","https://openalex.org/W3004921674","https://openalex.org/W3142507861","https://openalex.org/W4306391965","https://openalex.org/W6686840473"],"related_works":["https://openalex.org/W2389559488","https://openalex.org/W2382920002","https://openalex.org/W1551473783","https://openalex.org/W4224990216","https://openalex.org/W2912977869","https://openalex.org/W2170509036","https://openalex.org/W3195856620","https://openalex.org/W2622264455","https://openalex.org/W3209610942","https://openalex.org/W2995581643"],"abstract_inverted_index":{"Precision":[0],"agriculture":[1],"harnesses":[2],"advanced":[3],"technology":[4],"and":[5,12,52,61,124,169,191],"data":[6,35,54,69,104],"analytics":[7],"to":[8,41,74,84,166,176,183,201],"enhance":[9],"the":[10,30,75,86,135,185,197],"efficiency":[11],"cost-effectiveness":[13],"of":[14,32,44,48,78,89,137],"agricultural":[15,110,193],"production.":[16],"This":[17,112],"paper":[18],"presents":[19],"a":[20,33,45,67,101,188],"comprehensive":[21],"case":[22],"study":[23],"focused":[24],"on":[25],"optimizing":[26],"crop":[27,154,171,203],"monitoring":[28],"through":[29],"implementation":[31],"robust":[34],"warehouse":[36,70],"framework.":[37],"Our":[38,180],"objective":[39],"is":[40,83],"propose":[42],"development":[43],"system":[46],"capable":[47],"seamlessly":[49,114],"collecting,":[50],"storing,":[51],"analyzing":[53],"from":[55],"diverse":[56],"sources,":[57],"including":[58],"drones,":[59],"sensors,":[60],"farmer-contributed":[62],"information,":[63],"all":[64],"integrated":[65],"within":[66],"cohesive":[68],"architecture.":[71],"In":[72,134],"response":[73],"dynamic":[76],"needs":[77],"farmers,":[79],"our":[80,142],"primary":[81],"aim":[82],"facilitate":[85],"swift":[87],"retrieval":[88],"crop-specific":[90],"information":[91,149],"at":[92,107],"any":[93],"developmental":[94],"stage.":[95],"To":[96],"achieve":[97],"this,":[98],"we":[99],"introduce":[100],"sophisticated":[102],"multidimensional":[103],"model":[105,113],"adept":[106],"managing":[108],"intricate":[109],"datasets.":[111],"integrates":[115],"with":[116,147],"modern":[117],"technologies":[118],"such":[119],"as":[120],"machine":[121],"learning":[122],"algorithms":[123],"decision-support":[125],"systems,":[126],"providing":[127],"an":[128],"enhanced":[129],"decision-making":[130,152],"ecosystem":[131],"for":[132,150,187],"farmers.":[133],"context":[136],"this":[138,159],"under":[139],"explored":[140],"subject,":[141],"proposed":[143],"approach":[144],"empowers":[145],"farmers":[146,165],"precise":[148],"informed":[151],"in":[153],"management.":[155],"We":[156],"anticipate":[157],"that":[158],"strategy":[160],"will":[161],"not":[162],"only":[163],"enable":[164],"increase":[167],"yields":[168],"improve":[170],"quality":[172],"but":[173],"also":[174],"contribute":[175],"significant":[177],"cost":[178],"savings.":[179],"research":[181],"aims":[182],"pave":[184],"road":[186],"more":[189],"ecological":[190],"efficient":[192],"industry":[194],"by":[195],"eliminating":[196],"current":[198],"access":[199],"gap":[200],"detailed":[202],"life-cycle":[204],"data.":[205]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2025-12-27T23:08:20.325037","created_date":"2025-10-10T00:00:00"}