Get quick answers to your questions about the article from our AI researcher chatbot
{'id': 'https://openalex.org/W1990799340', 'doi': 'https://doi.org/10.5539/cis.v2n1p121', 'title': 'Study on the Optimization Method of Select Query Sentence in Standard SQL Language', 'display_name': 'Study on the Optimization Method of Select Query Sentence in Standard SQL Language', 'publication_year': 2009, 'publication_date': '2009-01-19', 'ids': {'openalex': 'https://openalex.org/W1990799340', 'doi': 'https://doi.org/10.5539/cis.v2n1p121', 'mag': '1990799340'}, 'language': 'en', 'primary_location': {'is_oa': True, 'landing_page_url': 'https://doi.org/10.5539/cis.v2n1p121', 'pdf_url': 'https://ccsenet.org/journal/index.php/cis/article/download/1871/1778', 'source': {'id': 'https://openalex.org/S2764452479', 'display_name': 'Computer and Information Science', 'issn_l': '1913-8989', 'issn': ['1913-8989', '1913-8997'], 'is_oa': True, 'is_in_doaj': False, 'is_core': True, 'host_organization': 'https://openalex.org/P4310322531', 'host_organization_name': 'Canadian Center of Science and Education', 'host_organization_lineage': ['https://openalex.org/P4310322531'], 'host_organization_lineage_names': ['Canadian Center of Science and Education'], 'type': 'journal'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'type': 'article', 'type_crossref': 'journal-article', 'indexed_in': ['crossref'], 'open_access': {'is_oa': True, 'oa_status': 'hybrid', 'oa_url': 'https://ccsenet.org/journal/index.php/cis/article/download/1871/1778', 'any_repository_has_fulltext': False}, 'authorships': [{'author_position': 'first', 'author': {'id': 'https://openalex.org/A5104105297', 'display_name': 'Yuqing Geng', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Yuqing Geng', 'raw_affiliation_strings': ['Department of Computer, Kerqin Art Professional College'], 'affiliations': [{'raw_affiliation_string': 'Department of Computer, Kerqin Art Professional College', 'institution_ids': []}]}, {'author_position': 'last', 'author': {'id': 'https://openalex.org/A5101796819', 'display_name': 'Chunsheng Zhang', 'orcid': 'https://orcid.org/0000-0003-4131-333X'}, 'institutions': [{'id': 'https://openalex.org/I108743333', 'display_name': 'Inner Mongolia University for Nationalities', 'ror': 'https://ror.org/04cwap208', 'country_code': 'CN', 'type': 'education', 'lineage': ['https://openalex.org/I108743333']}], 'countries': ['CN'], 'is_corresponding': False, 'raw_author_name': 'Chunsheng Zhang', 'raw_affiliation_strings': ['College of Math and Computer Science, Inner Mongolia University for Nationalities'], 'affiliations': [{'raw_affiliation_string': 'College of Math and Computer Science, Inner Mongolia University for Nationalities', 'institution_ids': ['https://openalex.org/I108743333']}]}], 'countries_distinct_count': 1, 'institutions_distinct_count': 1, 'corresponding_author_ids': [], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 0.0, 'has_fulltext': True, 'fulltext_origin': 'pdf', 'cited_by_count': 2, 'citation_normalized_percentile': {'value': 0.725777, 'is_in_top_1_percent': False, 'is_in_top_10_percent': False}, 'cited_by_percentile_year': {'min': 71, 'max': 75}, 'biblio': {'volume': '2', 'issue': '1', 'first_page': None, 'last_page': None}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T13734', 'display_name': 'Artificial Intelligence and Expert Systems', 'score': 0.5248, 'subfield': {'id': 'https://openalex.org/subfields/1702', 'display_name': 'Artificial Intelligence'}, '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/T13734', 'display_name': 'Artificial Intelligence and Expert Systems', 'score': 0.5248, 'subfield': {'id': 'https://openalex.org/subfields/1702', 'display_name': 'Artificial Intelligence'}, '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/standard-language', 'display_name': 'Standard language', 'score': 0.47297943}, {'id': 'https://openalex.org/keywords/semantic-knowledge-base', 'display_name': 'Semantic Knowledge Base', 'score': 0.453768}], 'concepts': [{'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.92239285}, {'id': 'https://openalex.org/C2777530160', 'wikidata': 'https://www.wikidata.org/wiki/Q41796', 'display_name': 'Sentence', 'level': 2, 'score': 0.612916}, {'id': 'https://openalex.org/C510870499', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'SQL', 'level': 2, 'score': 0.6042334}, {'id': 'https://openalex.org/C157692150', 'wikidata': 'https://www.wikidata.org/wiki/Q2919848', 'display_name': 'Query optimization', 'level': 2, 'score': 0.60150963}, {'id': 'https://openalex.org/C2775957009', 'wikidata': 'https://www.wikidata.org/wiki/Q399495', 'display_name': 'Standard language', 'level': 2, 'score': 0.47297943}, {'id': 'https://openalex.org/C194222762', 'wikidata': 'https://www.wikidata.org/wiki/Q114486', 'display_name': 'Query by Example', 'level': 4, 'score': 0.4258447}, {'id': 'https://openalex.org/C199360897', 'wikidata': 'https://www.wikidata.org/wiki/Q9143', 'display_name': 'Programming language', 'level': 1, 'score': 0.38612038}, {'id': 'https://openalex.org/C204321447', 'wikidata': 'https://www.wikidata.org/wiki/Q30642', 'display_name': 'Natural language processing', 'level': 1, 'score': 0.38572666}, {'id': 'https://openalex.org/C23123220', 'wikidata': 'https://www.wikidata.org/wiki/Q816826', 'display_name': 'Information retrieval', 'level': 1, 'score': 0.327819}, {'id': 'https://openalex.org/C164120249', 'wikidata': 'https://www.wikidata.org/wiki/Q995982', 'display_name': 'Web search query', 'level': 3, 'score': 0.16009992}, {'id': 'https://openalex.org/C41895202', 'wikidata': 'https://www.wikidata.org/wiki/Q8162', 'display_name': 'Linguistics', 'level': 1, 'score': 0.09400621}, {'id': 'https://openalex.org/C97854310', 'wikidata': 'https://www.wikidata.org/wiki/Q19541', 'display_name': 'Search engine', 'level': 2, 'score': 0.069164395}, {'id': 'https://openalex.org/C138885662', 'wikidata': 'https://www.wikidata.org/wiki/Q5891', 'display_name': 'Philosophy', 'level': 0, 'score': 0.0}], 'mesh': [], 'locations_count': 1, 'locations': [{'is_oa': True, 'landing_page_url': 'https://doi.org/10.5539/cis.v2n1p121', 'pdf_url': 'https://ccsenet.org/journal/index.php/cis/article/download/1871/1778', 'source': {'id': 'https://openalex.org/S2764452479', 'display_name': 'Computer and Information Science', 'issn_l': '1913-8989', 'issn': ['1913-8989', '1913-8997'], 'is_oa': True, 'is_in_doaj': False, 'is_core': True, 'host_organization': 'https://openalex.org/P4310322531', 'host_organization_name': 'Canadian Center of Science and Education', 'host_organization_lineage': ['https://openalex.org/P4310322531'], 'host_organization_lineage_names': ['Canadian Center of Science and Education'], 'type': 'journal'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}], 'best_oa_location': {'is_oa': True, 'landing_page_url': 'https://doi.org/10.5539/cis.v2n1p121', 'pdf_url': 'https://ccsenet.org/journal/index.php/cis/article/download/1871/1778', 'source': {'id': 'https://openalex.org/S2764452479', 'display_name': 'Computer and Information Science', 'issn_l': '1913-8989', 'issn': ['1913-8989', '1913-8997'], 'is_oa': True, 'is_in_doaj': False, 'is_core': True, 'host_organization': 'https://openalex.org/P4310322531', 'host_organization_name': 'Canadian Center of Science and Education', 'host_organization_lineage': ['https://openalex.org/P4310322531'], 'host_organization_lineage_names': ['Canadian Center of Science and Education'], 'type': 'journal'}, 'license': 'cc-by', 'license_id': 'https://openalex.org/licenses/cc-by', 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'sustainable_development_goals': [{'score': 0.57, 'display_name': 'Quality education', 'id': 'https://metadata.un.org/sdg/4'}], 'grants': [], 'datasets': [], 'versions': [], 'referenced_works_count': 6, 'referenced_works': ['https://openalex.org/W2354916853', 'https://openalex.org/W2356968235', 'https://openalex.org/W2381952024', 'https://openalex.org/W2389935101', 'https://openalex.org/W2612189897', 'https://openalex.org/W3127061739'], 'related_works': ['https://openalex.org/W319014924', 'https://openalex.org/W2955368753', 'https://openalex.org/W2612905717', 'https://openalex.org/W2588167896', 'https://openalex.org/W2391725132', 'https://openalex.org/W2384284661', 'https://openalex.org/W2362136306', 'https://openalex.org/W2356335648', 'https://openalex.org/W172736152', 'https://openalex.org/W151494989'], 'abstract_inverted_index': {'<!--': [0], '/*': [1], 'Font': [2], 'Definitions': [3], '*/': [4], '@font-face': [5, 27], '{font-family:??;': [6], 'panose-1:2': [7], '1': [8, 12, 13, 14, 15], '6': [9], '0': [10, 24], '3': [11], '1;': [16], 'mso-font-alt:SimSun;': [17], 'mso-font-charset:134;': [18], 'mso-generic-font-family:auto;': [19], 'mso-font-pitch:variable;': [20], 'mso-font-signature:3': [21], '135135232': [22], '16': [23], '262145': [25], '0;}': [26], '{font-family:': [28]}, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W1990799340', 'counts_by_year': [{'year': 2018, 'cited_by_count': 1}, {'year': 2017, 'cited_by_count': 1}], 'updated_date': '2024-08-15T07:11:31.125575', 'created_date': '2016-06-24'}