{"id":"https://openalex.org/W4291801374","doi":"https://doi.org/10.1109/icccs55155.2022.9846105","title":"Relational Database Query Optimization Strategy Based on Industrial Internet Situation Awareness System","display_name":"Relational Database Query Optimization Strategy Based on Industrial Internet Situation Awareness System","publication_year":2022,"publication_date":"2022-04-22","ids":{"openalex":"https://openalex.org/W4291801374","doi":"https://doi.org/10.1109/icccs55155.2022.9846105"},"language":"en","primary_location":{"id":"doi:10.1109/icccs55155.2022.9846105","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icccs55155.2022.9846105","pdf_url":null,"source":{"id":"https://openalex.org/S4363608130","display_name":"2022 7th International Conference on Computer and Communication Systems (ICCCS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 7th International Conference on Computer and Communication Systems (ICCCS)","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/A5033991045","display_name":"Xiaofei Yao","orcid":"https://orcid.org/0000-0002-5392-6101"},"institutions":[{"id":"https://openalex.org/I4210120842","display_name":"Shenyang Institute of Computing Technology (China)","ror":"https://ror.org/02xqp7x96","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210120842"]},{"id":"https://openalex.org/I4210165038","display_name":"University of Chinese Academy of Sciences","ror":"https://ror.org/05qbk4x57","country_code":"CN","type":"education","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210165038"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xiaofei Yao","raw_affiliation_strings":["University of Chinese Academy of Sciences,University of Chinese Academy of Sciences, Shenyang Institute of Computing Technology,Shenyang,China","University of Chinese Academy of Sciences, Shenyang Institute of Computing Technology, University of Chinese Academy of Sciences, Shenyang, China"],"affiliations":[{"raw_affiliation_string":"University of Chinese Academy of Sciences,University of Chinese Academy of Sciences, Shenyang Institute of Computing Technology,Shenyang,China","institution_ids":["https://openalex.org/I4210120842","https://openalex.org/I4210165038"]},{"raw_affiliation_string":"University of Chinese Academy of Sciences, Shenyang Institute of Computing Technology, University of Chinese Academy of Sciences, Shenyang, China","institution_ids":["https://openalex.org/I4210120842","https://openalex.org/I4210165038"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100364789","display_name":"Jin Li","orcid":"https://orcid.org/0000-0002-3628-7037"},"institutions":[{"id":"https://openalex.org/I4210120842","display_name":"Shenyang Institute of Computing Technology (China)","ror":"https://ror.org/02xqp7x96","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210120842"]},{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jin Li","raw_affiliation_strings":["University of Chinese Academy of Sciences,Shenyang Institute of Computing Technology,Shenyang,China","Shenyang Institute of Computing Technology, University of Chinese Academy of Sciences, Shenyang, China"],"affiliations":[{"raw_affiliation_string":"University of Chinese Academy of Sciences,Shenyang Institute of Computing Technology,Shenyang,China","institution_ids":["https://openalex.org/I4210120842","https://openalex.org/I19820366"]},{"raw_affiliation_string":"Shenyang Institute of Computing Technology, University of Chinese Academy of Sciences, Shenyang, China","institution_ids":["https://openalex.org/I4210120842","https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102380926","display_name":"Yaodong Tao","orcid":null},"institutions":[{"id":"https://openalex.org/I21193070","display_name":"Beijing Jiaotong University","ror":"https://ror.org/01yj56c84","country_code":"CN","type":"education","lineage":["https://openalex.org/I21193070"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yaodong Tao","raw_affiliation_strings":["Beijing Jiaotong University,Beijing,China","Beijing Jiaotong University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Beijing Jiaotong University,Beijing,China","institution_ids":["https://openalex.org/I21193070"]},{"raw_affiliation_string":"Beijing Jiaotong University, Beijing, China","institution_ids":["https://openalex.org/I21193070"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070295014","display_name":"Shenglong Ji","orcid":null},"institutions":[{"id":"https://openalex.org/I4210141776","display_name":"China XD Group (China)","ror":"https://ror.org/04ceqst84","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210141776"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shenglong Ji","raw_affiliation_strings":["Qi An Xin Group,Beijing,China","Qi An Xin Group, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Qi An Xin Group,Beijing,China","institution_ids":["https://openalex.org/I4210141776"]},{"raw_affiliation_string":"Qi An Xin Group, Beijing, China","institution_ids":["https://openalex.org/I4210141776"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5033991045"],"corresponding_institution_ids":["https://openalex.org/I4210120842","https://openalex.org/I4210165038"],"apc_list":null,"apc_paid":null,"fwci":1.4728,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.84865719,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"152","last_page":"155"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9945999979972839,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9872000217437744,"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/computer-science","display_name":"Computer science","score":0.8277601599693298},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.751819908618927},{"id":"https://openalex.org/keywords/data-retrieval","display_name":"Data retrieval","score":0.6041220426559448},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5788910984992981},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5687019228935242},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5227225422859192},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5159119367599487},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.5134326219558716},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5089633464813232},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4808969497680664},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.418866366147995},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.4168112576007843},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.41000261902809143},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.38672229647636414},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.176317036151886}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8277601599693298},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.751819908618927},{"id":"https://openalex.org/C551230270","wikidata":"https://www.wikidata.org/wiki/Q4368942","display_name":"Data retrieval","level":2,"score":0.6041220426559448},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5788910984992981},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5687019228935242},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5227225422859192},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5159119367599487},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.5134326219558716},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5089633464813232},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4808969497680664},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.418866366147995},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.4168112576007843},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.41000261902809143},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38672229647636414},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.176317036151886},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icccs55155.2022.9846105","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icccs55155.2022.9846105","pdf_url":null,"source":{"id":"https://openalex.org/S4363608130","display_name":"2022 7th International Conference on Computer and Communication Systems (ICCCS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 7th International Conference on Computer and Communication Systems (ICCCS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W31005962","https://openalex.org/W1600445262","https://openalex.org/W1991271936","https://openalex.org/W2026893489","https://openalex.org/W2806354204"],"related_works":["https://openalex.org/W3085968255","https://openalex.org/W2188578519","https://openalex.org/W1502610062","https://openalex.org/W1588786827","https://openalex.org/W4240226448","https://openalex.org/W2159931520","https://openalex.org/W3011022408","https://openalex.org/W2018151471","https://openalex.org/W2007701712","https://openalex.org/W1568401719"],"abstract_inverted_index":{"In":[0,25],"relational":[1,36,57,71,126],"databases,":[2],"when":[3],"the":[4,15,19,40,51,64,70,74,91,100,114,118,138,154,159],"amount":[5],"of":[6,18,35,56,66,93,103],"data":[7,20,42,46,95,104,108,120,132,160],"in":[8,59,69,78,90,109,125,142],"a":[9,31,110],"single":[10,111],"table":[11,21],"is":[12,134],"too":[13],"large,":[14],"retrieval":[16,32,101,139,161],"performance":[17],"will":[22],"drop":[23],"sharply.":[24],"this":[26,28,143],"regard,":[27],"paper":[29],"proposes":[30],"optimization":[33],"strategy":[34,140,155],"databases":[37,58,127],"based":[38],"on":[39],"change":[41,119],"capture":[43,47,50,121],"mechanism.":[44],"Log-based":[45],"mechanism":[48],"to":[49,73,145],"addition,":[52],"deletion,":[53],"and":[54,62,130,163],"modification":[55],"real":[60,80],"time,":[61,116],"synchronize":[63],"changes":[65],"specified":[67],"fields":[68],"database":[72,76,131],"non-relational":[75],"Elasticsearch":[77,82],"near":[79],"time.":[81],"stores":[83],"all":[84],"search":[85],"conditions.":[86],"Using":[87],"Elasticsearch's":[88],"advantages":[89],"field":[92],"massive":[94],"retrieval,":[96],"it":[97],"effectively":[98,157],"solves":[99],"problem":[102],"tables":[105],"with":[106],"excessive":[107],"table.":[112],"At":[113],"same":[115],"through":[117],"mechanism,":[122],"unnecessary":[123],"indexes":[124],"are":[128],"reduced,":[129],"writing":[133],"improved.":[135],"Performance.":[136],"Applying":[137],"proposed":[141],"article":[144],"an":[146],"industrial":[147],"Internet":[148],"situational":[149],"awareness":[150],"system":[151],"proves":[152],"that":[153],"can":[156],"improve":[158],"ability":[162],"performs":[164],"well.":[165]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}