{"id":"https://openalex.org/W7225737947","doi":"https://doi.org/10.20944/preprints202611.0955.v1","title":"Relational or Distributed? A Scaling Study of Frequent Itemset Mining over Urban License Plate Detections for Smart City Platforms","display_name":"Relational or Distributed? A Scaling Study of Frequent Itemset Mining over Urban License Plate Detections for Smart City Platforms","publication_year":2026,"publication_date":"2026-11-10","ids":{"openalex":"https://openalex.org/W7225737947","doi":"https://doi.org/10.20944/preprints202611.0955.v1"},"language":"en","primary_location":{"id":"doi:10.20944/preprints202611.0955.v1","doi":"https://doi.org/10.20944/preprints202611.0955.v1","is_oa":true,"landing_page_url":"https://doi.org/10.20944/preprints202611.0955.v1","pdf_url":null,"source":{"id":"https://openalex.org/S6309402219","display_name":"Preprints.org","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"posted-content"},"volume":null,"type":"preprint","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.20944/preprints202611.0955.v1","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5161418097","display_name":"Diego A. Moreno-Gallon","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Diego A. Moreno-Gallon","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076777956","display_name":"Kevin David Ortega Qui\u00f1ones","orcid":"https://orcid.org/0009-0004-6187-0517","observed_orcids":["https://orcid.org/0009-0004-6187-0517"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kevin David Ortega-Qui\u00f1ones","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5161391548","display_name":"Daniela Buitrago-Largo","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Daniela Buitrago-Largo","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5160227668","display_name":"Mauricio Holgu\u00edn-Londo\u00f1o","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mauricio Holgu\u00edn-Londo\u00f1o","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5158010529","display_name":"Germ\u00e1n Andr\u00e9s Holgu\u00edn-Londo\u00f1o","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Germ\u00e1n A. Holgu\u00edn-Londo\u00f1o","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.6553000211715698,"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.6553000211715698,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.29760000109672546,"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.03099999949336052,"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"}}],"keywords":[],"concepts":[{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.7239999771118164},{"id":"https://openalex.org/C2780560020","wikidata":"https://www.wikidata.org/wiki/Q79719","display_name":"License","level":2,"score":0.6521999835968018},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6503999829292297},{"id":"https://openalex.org/C64543145","wikidata":"https://www.wikidata.org/wiki/Q162942","display_name":"Intersection (aeronautics)","level":2,"score":0.6347000002861023},{"id":"https://openalex.org/C2777103469","wikidata":"https://www.wikidata.org/wiki/Q1231558","display_name":"Smart city","level":3,"score":0.5774999856948853},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5435000061988831},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4726000130176544},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.46970000863075256},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.4361000061035156},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40149998664855957},{"id":"https://openalex.org/C164866538","wikidata":"https://www.wikidata.org/wiki/Q367351","display_name":"Cluster (spacecraft)","level":2,"score":0.3917999863624573},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.36059999465942383},{"id":"https://openalex.org/C99844830","wikidata":"https://www.wikidata.org/wiki/Q102441924","display_name":"Scaling","level":2,"score":0.34940001368522644},{"id":"https://openalex.org/C2988224531","wikidata":"https://www.wikidata.org/wiki/Q20830730","display_name":"Network structure","level":2,"score":0.3192000091075897},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.31150001287460327},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.28839999437332153},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27730000019073486},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.27070000767707825},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.2696000039577484}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.20944/preprints202611.0955.v1","doi":"https://doi.org/10.20944/preprints202611.0955.v1","is_oa":true,"landing_page_url":"https://doi.org/10.20944/preprints202611.0955.v1","pdf_url":null,"source":{"id":"https://openalex.org/S6309402219","display_name":"Preprints.org","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"posted-content"}],"best_oa_location":{"id":"doi:10.20944/preprints202611.0955.v1","doi":"https://doi.org/10.20944/preprints202611.0955.v1","is_oa":true,"landing_page_url":"https://doi.org/10.20944/preprints202611.0955.v1","pdf_url":null,"source":{"id":"https://openalex.org/S6309402219","display_name":"Preprints.org","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"posted-content"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Counting":[0],"how":[1],"many":[2],"vehicles":[3,12,41,52],"crossed":[4],"an":[5],"intersection":[6],"produces":[7],"a":[8,94,104,157,209],"report;":[9],"finding":[10],"which":[11,17,207],"move":[13,215],"together,":[14],"and":[15,49,73,139,153,197],"through":[16],"cameras,":[18],"reveals":[19],"the":[20,39,43,57,90,118,169,179,193,217],"structure":[21,31],"of":[22,34,51,121,151,160,205],"urban":[23],"traffic.":[24],"License":[25],"plate":[26],"recognition":[27],"cameras":[28,35,59,116],"make":[29],"that":[30,45,87],"observable.":[32],"Sets":[33],"frequently":[36],"shared":[37],"by":[38,146],"same":[40,58],"expose":[42],"corridors":[44],"traffic":[46,65],"actually":[47],"uses,":[48],"groups":[50],"repeatedly":[53],"seen":[54],"together":[55],"at":[56,124,143],"support":[60],"automated":[61],"convoy":[62],"detection":[63],"for":[64,89],"enforcement.":[66],"Both":[67],"are":[68,75],"frequent":[69],"itemset":[70],"mining":[71,166],"problems,":[72],"they":[74],"precisely":[76],"where":[77],"relational":[78,170,218],"databases":[79],"lose":[80],"ground":[81],"as":[82],"data":[83],"grow.":[84],"We":[85],"quantify":[86],"loss":[88],"corridor":[91],"formulation,":[92],"comparing":[93],"self":[95,180],"join":[96,181],"in":[97],"indexed":[98],"PostgreSQL":[99,141],"with":[100],"distributed":[101],"FP-Growth":[102,185],"on":[103,117],"four-worker":[105],"Apache":[106],"Spark":[107,154],"cluster":[108],"over":[109],"100":[110],"million":[111,133,199],"simulated":[112],"detections":[113],"from":[114,128,173],"500":[115],"road":[119],"network":[120],"Pereira,":[122],"Colombia,":[123],"eight":[125],"nested":[126],"scales":[127],"50":[129],"thousand":[130],"to":[131,148,162,175,202],"15":[132],"rows.":[134],"For":[135],"reports,":[136],"histograms,":[137],"lookups":[138],"alerts,":[140],"wins":[142],"every":[144],"scale":[145],"up":[147],"five":[149],"orders":[150],"magnitude,":[152],"never":[155],"leaves":[156],"fixed":[158],"overhead":[159],"two":[161],"four":[163,201],"minutes.":[164],"Structure":[165],"behaves":[167],"differently:":[168],"advantage":[171],"collapses":[172],"328":[174],"1.6":[176],"times,":[177],"because":[178],"grows":[182,186],"super-linearly":[183],"while":[184],"almost":[187],"linearly.":[188],"Extrapolated":[189],"growth":[190],"exponents":[191],"place":[192],"crossover":[194],"between":[195],"30":[196],"73":[198],"detections,":[200],"nine":[203],"days":[204],"operation,":[206],"tells":[208],"city":[210],"when":[211],"structural":[212],"analysis":[213],"must":[214],"off":[216],"engine.":[219]},"counts_by_year":[],"updated_date":"2026-11-11T12:16:26.678958","created_date":"2026-11-11T00:00:00"}