{"id":"https://openalex.org/W7224258922","doi":"https://doi.org/10.21203/rs.3.rs-11451908/v1","title":"Experimental Characterization of Metadata Synchronization in a Homogeneous MySQL Multidatabase Testbed Direct JSON-over-TCP/IP Fan-out, Serial JSON-over-SMB Relay, and Native Replication","display_name":"Experimental Characterization of Metadata Synchronization in a Homogeneous MySQL Multidatabase Testbed Direct JSON-over-TCP/IP Fan-out, Serial JSON-over-SMB Relay, and Native Replication","alternate_titles":[],"publication_year":2026,"publication_date":"2026-10-30","ids":{"openalex":"https://openalex.org/W7224258922","doi":"https://doi.org/10.21203/rs.3.rs-11451908/v1"},"language":"en","primary_location":{"id":"doi:10.21203/rs.3.rs-11451908/v1","doi":"https://doi.org/10.21203/rs.3.rs-11451908/v1","is_oa":true,"landing_page_url":"https://doi.org/10.21203/rs.3.rs-11451908/v1","pdf_url":"https://www.researchsquare.com/article/rs-11451908/latest.pdf","source":{"id":"https://openalex.org/S4306525896","display_name":"Research Square","issn_l":null,"issn":null,"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":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Research Square","raw_type":"posted-content"},"parent_works":[],"lineage":["https://openalex.org/W7224258922"],"child_works_count":0,"type":"preprint","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.researchsquare.com/article/rs-11451908/latest.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5025704842","display_name":"Mohammad Ghulam Ali","orcid":"https://orcid.org/0000-0002-6012-6380","observed_orcids":["https://orcid.org/0000-0002-6012-6380"]},"institutions":[{"id":"https://openalex.org/I145894827","display_name":"Indian Institute of Technology Kharagpur","ror":"https://ror.org/03w5sq511","country_code":"IN","type":"education","lineage":["https://openalex.org/I145894827"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Mohammad Ghulam Ali Ali","raw_affiliation_strings":["Indian Institute of Technology Kharagpur"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Kharagpur","institution_ids":["https://openalex.org/I145894827"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5025704842"],"corresponding_institution_ids":["https://openalex.org/I145894827"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"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_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.8916000127792358,"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.8916000127792358,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.10300000011920929,"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.001500000013038516,"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":[{"id":"https://openalex.org/keywords/metadata-synchronization","display_name":"metadata synchronization","score":0.9739999771118164},{"id":"https://openalex.org/keywords/propagation-delay","display_name":"propagation delay","score":0.7260000109672546},{"id":"https://openalex.org/keywords/distributed-databases","display_name":"distributed databases","score":0.6470000147819519}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7813000082969666},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5703999996185303},{"id":"https://openalex.org/C21099817","wikidata":"https://www.wikidata.org/wiki/Q7631721","display_name":"Subnet","level":2,"score":0.5662999749183655},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.5430999994277954},{"id":"https://openalex.org/C31395832","wikidata":"https://www.wikidata.org/wiki/Q1318674","display_name":"Testbed","level":2,"score":0.47850000858306885},{"id":"https://openalex.org/C2778562939","wikidata":"https://www.wikidata.org/wiki/Q1298791","display_name":"Synchronization (alternating current)","level":3,"score":0.42570000886917114},{"id":"https://openalex.org/C66882249","wikidata":"https://www.wikidata.org/wiki/Q169336","display_name":"Homogeneous","level":2,"score":0.3865000009536743},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.3499999940395355},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.3434000015258789},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3384000062942505},{"id":"https://openalex.org/C90806461","wikidata":"https://www.wikidata.org/wiki/Q1144416","display_name":"Propagation delay","level":2,"score":0.3328000009059906},{"id":"https://openalex.org/C105344744","wikidata":"https://www.wikidata.org/wiki/Q958957","display_name":"Spread spectrum","level":3,"score":0.3287999927997589},{"id":"https://openalex.org/C11704745","wikidata":"https://www.wikidata.org/wiki/Q918337","display_name":"Unicast","level":3,"score":0.3001999855041504},{"id":"https://openalex.org/C175291020","wikidata":"https://www.wikidata.org/wiki/Q1156822","display_name":"Offset (computer science)","level":2,"score":0.290800005197525},{"id":"https://openalex.org/C30872290","wikidata":"https://www.wikidata.org/wiki/Q1172389","display_name":"Data element","level":3,"score":0.2856999933719635},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.2842000126838684},{"id":"https://openalex.org/C557945733","wikidata":"https://www.wikidata.org/wiki/Q389772","display_name":"Data transmission","level":2,"score":0.28139999508857727},{"id":"https://openalex.org/C12590798","wikidata":"https://www.wikidata.org/wiki/Q3933199","display_name":"Replication (statistics)","level":2,"score":0.27649998664855957},{"id":"https://openalex.org/C151319957","wikidata":"https://www.wikidata.org/wiki/Q752739","display_name":"Asynchronous communication","level":2,"score":0.2750999927520752},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2727999985218048},{"id":"https://openalex.org/C96324660","wikidata":"https://www.wikidata.org/wiki/Q205446","display_name":"Dataflow","level":2,"score":0.272599995136261},{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.26249998807907104},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.2612000107765198},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.2599000036716461},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.2551000118255615},{"id":"https://openalex.org/C101780184","wikidata":"https://www.wikidata.org/wiki/Q840576","display_name":"Dissemination","level":2,"score":0.25369998812675476}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.21203/rs.3.rs-11451908/v1","doi":"https://doi.org/10.21203/rs.3.rs-11451908/v1","is_oa":true,"landing_page_url":"https://doi.org/10.21203/rs.3.rs-11451908/v1","pdf_url":"https://www.researchsquare.com/article/rs-11451908/latest.pdf","source":{"id":"https://openalex.org/S4306525896","display_name":"Research Square","issn_l":null,"issn":null,"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":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Research Square","raw_type":"posted-content"}],"best_oa_location":{"id":"doi:10.21203/rs.3.rs-11451908/v1","doi":"https://doi.org/10.21203/rs.3.rs-11451908/v1","is_oa":true,"landing_page_url":"https://doi.org/10.21203/rs.3.rs-11451908/v1","pdf_url":"https://www.researchsquare.com/article/rs-11451908/latest.pdf","source":{"id":"https://openalex.org/S4306525896","display_name":"Research Square","issn_l":null,"issn":null,"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":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Research Square","raw_type":"posted-content"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7224258922.pdf","grobid_xml":"https://content.openalex.org/works/W7224258922.grobid-xml"},"referenced_works_count":13,"referenced_works":["https://openalex.org/W1502629466","https://openalex.org/W1532184659","https://openalex.org/W1537257884","https://openalex.org/W1623647868","https://openalex.org/W2140853443","https://openalex.org/W3124041911","https://openalex.org/W3203311072","https://openalex.org/W4225728335","https://openalex.org/W4388917351","https://openalex.org/W4407583791","https://openalex.org/W4416514089","https://openalex.org/W7138949449","https://openalex.org/W7162958089"],"related_works":["https://openalex.org/W7095805987","https://openalex.org/W6884913281","https://openalex.org/W2188680629","https://openalex.org/W7097886710","https://openalex.org/W7103425379","https://openalex.org/W1592444483","https://openalex.org/W2154909541","https://openalex.org/W2330988350","https://openalex.org/W2398651945","https://openalex.org/W7203633152"],"abstract_inverted_index":{"Abstract":[0],"Schema":[1],"changes":[2],"in":[3,32,261],"autonomous":[4],"database":[5,263],"nodes":[6],"can":[7],"invalidate":[8],"integrated":[9],"catalog":[10,173,273],"views":[11],"unless":[12],"metadata":[13,167,258],"propagation":[14,30,62,250],"is":[15,72,83,97,108,123,134,146],"timely":[16],"and":[17,45,54,67,74,77,92,99,102,115,118,125,128,151,160,172,183,186,222,245],"correct.":[18],"This":[19],"study":[20,165],"comparatively":[21,142],"evaluates":[22],"three":[23],"operationally":[24],"distinct":[25],"Data":[26],"Definition":[27],"Language":[28],"(DDL)":[29],"implementations":[31],"a":[33,188,253],"three-node":[34],"homogeneous":[35],"MySQL":[36,47,139,208],"environment:":[37],"application-level":[38],"direct":[39,87,199,226],"TCP/IP":[40,88,200],"fan-out,":[41,89],"serial":[42,112,204],"JSON-over-SMB":[43,113],"relay,":[44,114,205],"native":[46,138,207],"replication.":[48,140],"Five":[49],"latency":[50,145,181],"observations":[51,193],"per":[52],"destination":[53],"technique":[55],"yield":[56],"30":[57],"recorded":[58,192],"measurements.":[59],"The":[60,141,164,191,236],"mean":[61,196,213],"latencies":[63],"for":[64,86,111,137,198,203,255],"Nodes":[65,75,90,100,116,126],"1":[66,76,91,101,117,127],"2":[68,93,119],"within":[69,79,94,104,120,130],"same":[70,95,121],"subnet":[71,96,122],"1200.0":[73],"3":[78,103,129],"two":[80,105,131],"different":[81,106,132],"subnets":[82,107,133],"1383.0":[84],"ms":[85,110,136],"3241.0":[98],"4664.6":[109],"171.6":[124],"146.4":[135],"higher":[143],"serial-relay":[144],"consistent":[147],"with":[148,155],"cumulative":[149],"processing":[150],"coordination":[152],"overhead":[153],"associated":[154],"sequential":[156],"forwarding,":[157],"JSON":[158],"serialization,":[159],"SMB-based":[161],"file":[162],"handling.":[163],"distinguishes":[166],"delivery,":[168],"DDL":[169,249],"application,":[170],"acknowledgement,":[171],"convergence":[174],"as":[175],"separate":[176],"operational":[177],"endpoints,":[178],"examines":[179],"descriptive":[180],"variability":[182],"event-index":[184],"comparisons,":[185],"establishes":[187],"catalog-consistency":[189],"specification.":[190],"show":[194],"lower":[195],"delays":[197,214],"fan-out":[201],"than":[202],"while":[206],"replication":[209],"exhibits":[210],"the":[211,216,242],"lowest":[212],"under":[215],"evaluated":[217],"conditions.":[218],"Nevertheless,":[219],"architectural":[220,246],"differences":[221,231],"measurement":[223],"semantics":[224],"limit":[225],"causal":[227],"attribution":[228],"of":[229,248],"performance":[230,243],"to":[232],"individual":[233],"transport":[234],"mechanisms.":[235],"findings":[237],"provide":[238],"empirical":[239],"insights":[240],"into":[241],"characteristics":[244],"trade-offs":[247],"strategies,":[251],"establishing":[252],"foundation":[254],"designing":[256],"reliable":[257],"synchronization":[259],"mechanisms":[260],"distributed":[262],"environments":[264],"without":[265],"claiming":[266],"experimentally":[267],"verified":[268],"heterogeneous":[269],"interoperability":[270],"or":[271],"global":[272],"convergence.":[274]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7224258922","counts_by_year":[],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2026-10-30T00:00:00"}
