{"id":"https://openalex.org/W7154393003","doi":"https://doi.org/10.35266/1999-7604-2026-1-2","title":"Structured query language for data management of vehicles and road traffic accidents","display_name":"Structured query language for data management of vehicles and road traffic accidents","publication_year":2026,"publication_date":"2026-01-01","ids":{"openalex":"https://openalex.org/W7154393003","doi":"https://doi.org/10.35266/1999-7604-2026-1-2"},"language":"en","primary_location":{"id":"doi:10.35266/1999-7604-2026-1-2","doi":"https://doi.org/10.35266/1999-7604-2026-1-2","is_oa":false,"landing_page_url":"https://doi.org/10.35266/1999-7604-2026-1-2","pdf_url":null,"source":{"id":"https://openalex.org/S4393917755","display_name":"Vestnik kibernetiki","issn_l":"1811-7430","issn":["1811-7430","1999-7604"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["russia-white-list-3"],"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":"Proceedings in Cybernetics","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://cyberleninka.ru/article/n/yazyk-strukturirovannyh-zaprosov-dlya-upravleniya-dannymi-o-transportnyh-sredstvah-i-dorozhno-transportnyh-proisshestviyah/pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5116007351","display_name":"D. Yu. Zorkin","orcid":"https://orcid.org/0009-0002-3875-9285","observed_orcids":["https://orcid.org/0009-0002-3875-9285"]},"institutions":[{"id":"https://openalex.org/I4210140902","display_name":"Volgograd State Technical University","ror":"https://ror.org/041szz343","country_code":"RU","type":"education","lineage":["https://openalex.org/I4210140902"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"D. Yu. Zorkin","raw_affiliation_strings":["Volgograd State Technical University, Volgograd, Russia"],"raw_orcid":"https://orcid.org/0009-0002-3875-9285","affiliations":[{"raw_affiliation_string":"Volgograd State Technical University, Volgograd, Russia","institution_ids":["https://openalex.org/I4210140902"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5125751498","display_name":"N. V. Asanova","orcid":"https://orcid.org/0000-0003-3781-7017","observed_orcids":["https://orcid.org/0000-0003-3781-7017"]},"institutions":[{"id":"https://openalex.org/I4210140902","display_name":"Volgograd State Technical University","ror":"https://ror.org/041szz343","country_code":"RU","type":"education","lineage":["https://openalex.org/I4210140902"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"N. V. Asanova","raw_affiliation_strings":["Volgograd State Technical University, Volgograd, Russia"],"raw_orcid":"https://orcid.org/0000-0003-3781-7017","affiliations":[{"raw_affiliation_string":"Volgograd State Technical University, Volgograd, Russia","institution_ids":["https://openalex.org/I4210140902"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210140902"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"25","issue":"1","first_page":"18","last_page":"26"},"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.923799991607666,"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.923799991607666,"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/T13681","display_name":"Engineering and Information Technology","score":0.07069999724626541,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11734","display_name":"Decision Support System Applications","score":0.00139999995008111,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/structured-query-language","display_name":"structured query language","score":0.9490000009536743},{"id":"https://openalex.org/keywords/relational-database-design","display_name":"relational database design","score":0.9570000171661377},{"id":"https://openalex.org/keywords/traffic-accidents","display_name":"traffic accidents","score":0.906000018119812},{"id":"https://openalex.org/keywords/vehicle-registration-data","display_name":"vehicle registration data","score":0.7730000019073486},{"id":"https://openalex.org/keywords/compulsory-motor-third-party-liability-insurance","display_name":"compulsory motor third-party liability insurance","score":0.8820000290870667},{"id":"https://openalex.org/keywords/data-integrity","display_name":"data integrity","score":0.703000009059906},{"id":"https://openalex.org/keywords/acidic-properties","display_name":"acid properties","score":0.7570000290870667},{"id":"https://openalex.org/keywords/newsql","display_name":"NewSQL","score":0.8370000123977661},{"id":"https://openalex.org/keywords/data-aggregation","display_name":"data aggregation","score":0.4880000054836273}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7261000275611877},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6783000230789185},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.5914999842643738},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5787000060081482},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5501999855041504},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5295000076293945},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47769999504089355},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.41110000014305115},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4075999855995178},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.37599998712539673},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.35019999742507935},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.34790000319480896},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.3402999937534332},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.3343999981880188},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.3100999891757965},{"id":"https://openalex.org/C2777834853","wikidata":"https://www.wikidata.org/wiki/Q96776939","display_name":"Liability","level":2,"score":0.30959999561309814},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.30790001153945923},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.30649998784065247},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.2996000051498413},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.28209999203681946},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.2777000069618225},{"id":"https://openalex.org/C92446256","wikidata":"https://www.wikidata.org/wiki/Q3306762","display_name":"Data validation","level":2,"score":0.27570000290870667},{"id":"https://openalex.org/C177688676","wikidata":"https://www.wikidata.org/wiki/Q7449106","display_name":"Semantics of Business Vocabulary and Business Rules","level":5,"score":0.2727999985218048},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.27149999141693115},{"id":"https://openalex.org/C146222976","wikidata":"https://www.wikidata.org/wiki/Q1204997","display_name":"Business logic","level":2,"score":0.2651999890804291},{"id":"https://openalex.org/C93361087","wikidata":"https://www.wikidata.org/wiki/Q4426698","display_name":"Data consistency","level":2,"score":0.2614000141620636},{"id":"https://openalex.org/C163867264","wikidata":"https://www.wikidata.org/wiki/Q4672792","display_name":"Accounting information system","level":2,"score":0.26089999079704285},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.2563999891281128},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.25099998712539673}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.35266/1999-7604-2026-1-2","doi":"https://doi.org/10.35266/1999-7604-2026-1-2","is_oa":false,"landing_page_url":"https://doi.org/10.35266/1999-7604-2026-1-2","pdf_url":null,"source":{"id":"https://openalex.org/S4393917755","display_name":"Vestnik kibernetiki","issn_l":"1811-7430","issn":["1811-7430","1999-7604"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["russia-white-list-3"],"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":"Proceedings in Cybernetics","raw_type":"journal-article"},{"id":"pmh:https://cyberleninka.ru/article/n/yazyk-strukturirovannyh-zaprosov-dlya-upravleniya-dannymi-o-transportnyh-sredstvah-i-dorozhno-transportnyh-proisshestviyah","doi":null,"is_oa":true,"landing_page_url":"https://cyberleninka.ru/article/n/yazyk-strukturirovannyh-zaprosov-dlya-upravleniya-dannymi-o-transportnyh-sredstvah-i-dorozhno-transportnyh-proisshestviyah","pdf_url":"https://cyberleninka.ru/article/n/yazyk-strukturirovannyh-zaprosov-dlya-upravleniya-dannymi-o-transportnyh-sredstvah-i-dorozhno-transportnyh-proisshestviyah/pdf","source":{"id":"https://openalex.org/S4306401404","display_name":"CyberLeninK (CyberLeninka)","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":null,"raw_type":"text"}],"best_oa_location":{"id":"pmh:https://cyberleninka.ru/article/n/yazyk-strukturirovannyh-zaprosov-dlya-upravleniya-dannymi-o-transportnyh-sredstvah-i-dorozhno-transportnyh-proisshestviyah","doi":null,"is_oa":true,"landing_page_url":"https://cyberleninka.ru/article/n/yazyk-strukturirovannyh-zaprosov-dlya-upravleniya-dannymi-o-transportnyh-sredstvah-i-dorozhno-transportnyh-proisshestviyah","pdf_url":"https://cyberleninka.ru/article/n/yazyk-strukturirovannyh-zaprosov-dlya-upravleniya-dannymi-o-transportnyh-sredstvah-i-dorozhno-transportnyh-proisshestviyah/pdf","source":{"id":"https://openalex.org/S4306401404","display_name":"CyberLeninK (CyberLeninka)","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":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7154393003.pdf","grobid_xml":"https://content.openalex.org/works/W7154393003.grobid-xml"},"referenced_works_count":4,"referenced_works":["https://openalex.org/W4313245853","https://openalex.org/W4319779344","https://openalex.org/W4365453860","https://openalex.org/W4390747458"],"related_works":["https://openalex.org/W6911967362","https://openalex.org/W7128743195","https://openalex.org/W2383710748","https://openalex.org/W7162212619","https://openalex.org/W2369561358","https://openalex.org/W3021384748","https://openalex.org/W7165319837","https://openalex.org/W1542525166","https://openalex.org/W3163521041","https://openalex.org/W624193932"],"abstract_inverted_index":{"The":[0,27,53,74,106],"article":[1],"studies":[2],"implementation":[3],"of":[4,50,95,111],"the":[5,77,92,99,112],"structured":[6],"query":[7,84],"language":[8],"(SQL)":[9],"in":[10],"systematizing":[11],"data":[12,61,69],"on":[13],"vehicles,":[14],"their":[15],"owners,":[16],"and":[17,32,45,89,118,142],"road":[18],"traffic":[19],"accidents":[20],"(RTAs)":[21],"within":[22],"an":[23,82],"integrated":[24],"information":[25],"environment.":[26],"paper":[28],"aims":[29],"to":[30],"develop":[31],"validate":[33],"a":[34,38,109],"method":[35],"for":[36,68,91,133],"designing":[37],"relational":[39,113,120],"database":[40],"that":[41,85,126],"ensures":[42],"accounting":[43,94,134],"integrity":[44],"financially":[46],"precise":[47],"automated":[48],"calculation":[49,143],"insurance":[51],"payments.":[52],"work":[54],"structures":[55],"table":[56],"with":[57,71,81,115,139],"vehicle":[58],"registration":[59],"plates":[60],"using":[62],"DDL":[63],"scripts,":[64],"which":[65],"include":[66],"constraints":[67],"compliance":[70],"state":[72],"standards.":[73],"authors":[75],"perform":[76],"key":[78],"business":[79],"logic":[80,88],"SQL":[83,128],"applies":[86],"conditional":[87],"aggregation":[90],"accurate":[93],"liability":[96,104],"limits":[97],"under":[98],"compulsory":[100],"motor":[101],"third":[102],"party":[103],"insurance.":[105],"study":[107],"contains":[108],"comparison":[110],"approach":[114],"non-relational":[116],"(NoSQL)":[117],"scalable":[119],"(NewSQL)":[121],"methods.":[122],"It":[123],"is":[124],"concluded":[125],"standard":[127],"systems":[129],"are":[130],"most":[131],"efficient":[132],"tasks":[135],"requiring":[136],"strong":[137],"consistency":[138],"ACID":[140],"properties":[141],"transparency.":[144]},"counts_by_year":[],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2026-04-15T00:00:00"}