Get quick answers to your questions about the article from our AI researcher chatbot
{'id': 'https://openalex.org/W2917556230', 'doi': 'https://doi.org/10.1016/0920-5489(92)90049-j', 'title': 'The SQL standard: A complete reference', 'display_name': 'The SQL standard: A complete reference', 'publication_year': 1992, 'publication_date': '1992-08-01', 'ids': {'openalex': 'https://openalex.org/W2917556230', 'doi': 'https://doi.org/10.1016/0920-5489(92)90049-j', 'mag': '2917556230'}, 'language': 'en', 'primary_location': {'is_oa': False, 'landing_page_url': 'https://doi.org/10.1016/0920-5489(92)90049-j', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S119630662', 'display_name': 'Computer Standards & Interfaces', 'issn_l': '0920-5489', 'issn': ['0920-5489', '1872-7018'], 'is_oa': False, 'is_in_doaj': False, 'is_core': True, 'host_organization': 'https://openalex.org/P4310320990', 'host_organization_name': 'Elsevier BV', 'host_organization_lineage': ['https://openalex.org/P4310320990'], 'host_organization_lineage_names': ['Elsevier BV'], 'type': 'journal'}, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}, 'type': 'article', 'type_crossref': 'journal-article', 'indexed_in': ['crossref'], 'open_access': {'is_oa': False, 'oa_status': 'closed', 'oa_url': None, 'any_repository_has_fulltext': False}, 'authorships': [{'author_position': 'first', 'author': {'id': 'https://openalex.org/A5020045418', 'display_name': 'John L Berg', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': True, 'raw_author_name': 'John L Berg', 'raw_affiliation_strings': [], 'affiliations': []}], 'institution_assertions': [], 'countries_distinct_count': 0, 'institutions_distinct_count': 0, 'corresponding_author_ids': ['https://openalex.org/A5020045418'], 'corresponding_institution_ids': [], 'apc_list': {'value': 3000, 'currency': 'USD', 'value_usd': 3000, 'provenance': 'doaj'}, 'apc_paid': None, 'fwci': 0.0, 'has_fulltext': True, 'fulltext_origin': 'ngrams', 'cited_by_count': 1, 'citation_normalized_percentile': {'value': 0.519533, 'is_in_top_1_percent': False, 'is_in_top_10_percent': False}, 'cited_by_percentile_year': {'min': 53, 'max': 61}, 'biblio': {'volume': '14', 'issue': '4', 'first_page': '357', 'last_page': '358'}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10317', 'display_name': 'Data Stream Management Systems and Techniques', 'score': 0.5528, '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'}}, 'topics': [{'id': 'https://openalex.org/T10317', 'display_name': 'Data Stream Management Systems and Techniques', 'score': 0.5528, '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/T13734', 'display_name': 'Artificial Intelligence and Expert Systems', 'score': 0.5497, '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'}}, {'id': 'https://openalex.org/T13650', 'display_name': 'Scientific Computing and Data Analysis with Python', 'score': 0.5132, '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/column-oriented-database-systems', 'display_name': 'Column-oriented Database Systems', 'score': 0.55347}, {'id': 'https://openalex.org/keywords/data-integration', 'display_name': 'Data Integration', 'score': 0.539467}, {'id': 'https://openalex.org/keywords/semantic-knowledge-base', 'display_name': 'Semantic Knowledge Base', 'score': 0.53857}, {'id': 'https://openalex.org/keywords/relational-database-systems', 'display_name': 'Relational Database Systems', 'score': 0.538067}, {'id': 'https://openalex.org/keywords/continuous-queries', 'display_name': 'Continuous Queries', 'score': 0.537033}, {'id': 'https://openalex.org/keywords/sql/psm', 'display_name': 'SQL/PSM', 'score': 0.44747445}], 'concepts': [{'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.77698934}, {'id': 'https://openalex.org/C199360897', 'wikidata': 'https://www.wikidata.org/wiki/Q9143', 'display_name': 'Programming language', 'level': 1, 'score': 0.4897056}, {'id': 'https://openalex.org/C167544706', 'wikidata': 'https://www.wikidata.org/wiki/Q360842', 'display_name': 'SQL/PSM', 'level': 5, 'score': 0.44747445}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.3905787}, {'id': 'https://openalex.org/C23123220', 'wikidata': 'https://www.wikidata.org/wiki/Q816826', 'display_name': 'Information retrieval', 'level': 1, 'score': 0.2853494}, {'id': 'https://openalex.org/C194222762', 'wikidata': 'https://www.wikidata.org/wiki/Q114486', 'display_name': 'Query by Example', 'level': 4, 'score': 0.1076282}, {'id': 'https://openalex.org/C164120249', 'wikidata': 'https://www.wikidata.org/wiki/Q995982', 'display_name': 'Web search query', 'level': 3, 'score': 0.0}, {'id': 'https://openalex.org/C97854310', 'wikidata': 'https://www.wikidata.org/wiki/Q19541', 'display_name': 'Search engine', 'level': 2, 'score': 0.0}], 'mesh': [], 'locations_count': 1, 'locations': [{'is_oa': False, 'landing_page_url': 'https://doi.org/10.1016/0920-5489(92)90049-j', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S119630662', 'display_name': 'Computer Standards & Interfaces', 'issn_l': '0920-5489', 'issn': ['0920-5489', '1872-7018'], 'is_oa': False, 'is_in_doaj': False, 'is_core': True, 'host_organization': 'https://openalex.org/P4310320990', 'host_organization_name': 'Elsevier BV', 'host_organization_lineage': ['https://openalex.org/P4310320990'], 'host_organization_lineage_names': ['Elsevier BV'], 'type': 'journal'}, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}], 'best_oa_location': None, 'sustainable_development_goals': [], 'grants': [], 'datasets': [], 'versions': [], 'referenced_works_count': 0, 'referenced_works': [], 'related_works': ['https://openalex.org/W2748952813', 'https://openalex.org/W2530322880', 'https://openalex.org/W2390279801', 'https://openalex.org/W2382290278', 'https://openalex.org/W2376932109', 'https://openalex.org/W2358668433', 'https://openalex.org/W2350741829', 'https://openalex.org/W2186055799', 'https://openalex.org/W2001405890', 'https://openalex.org/W1596801655'], 'abstract_inverted_index': None, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2917556230', 'counts_by_year': [], 'updated_date': '2024-09-18T18:46:10.717968', 'created_date': '2019-03-02'}