Get quick answers to your questions about the article from our AI researcher chatbot
{'id': 'https://openalex.org/W3174970460', 'doi': None, 'title': 'Solving NULL issue in queries to a relational database using the operators of relational algebra A', 'display_name': 'Solving NULL issue in queries to a relational database using the operators of relational algebra A', 'publication_year': 2018, 'publication_date': '2018-01-01', 'ids': {'openalex': 'https://openalex.org/W3174970460', 'mag': '3174970460'}, 'language': 'en', 'primary_location': {'is_oa': False, 'landing_page_url': 'https://scholar.archive.org/work/wua44dcvbngu3kgpm4dpmje3pe', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S4210189999', 'display_name': 'Proceedings of the Institute for System Programming of RAS', 'issn_l': '2079-8156', 'issn': ['2079-8156', '2220-6426'], 'is_oa': True, 'is_in_doaj': True, 'is_core': False, 'host_organization': 'https://openalex.org/P4310312722', 'host_organization_name': 'Institute for System Programming of the Russian Academy of Sciences (ISPRAS)', 'host_organization_lineage': ['https://openalex.org/P4310312722'], 'host_organization_lineage_names': ['Institute for System Programming of the Russian Academy of Sciences (ISPRAS)'], 'type': 'journal'}, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}, 'type': 'article', 'type_crossref': 'journal-article', 'indexed_in': [], '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/A5084299790', 'display_name': 'И. В. Блудов', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': True, 'raw_author_name': 'Ivan V. Bludov', 'raw_affiliation_strings': [], 'affiliations': []}], 'institution_assertions': [], 'countries_distinct_count': 0, 'institutions_distinct_count': 0, 'corresponding_author_ids': ['https://openalex.org/A5084299790'], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 0.0, 'has_fulltext': False, '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': {'min': 0, 'max': 62}, 'biblio': {'volume': '21', 'issue': None, 'first_page': None, 'last_page': None}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10317', 'display_name': 'Data Stream Management Systems and Techniques', 'score': 0.9964, '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.9964, '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/T11106', 'display_name': 'Trajectory Data Mining and Analysis', 'score': 0.991, '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/T10215', 'display_name': 'Semantic Web and Ontology Development', 'score': 0.9669, '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/relational-algebra', 'display_name': 'Relational algebra', 'score': 0.80855083}, {'id': 'https://openalex.org/keywords/conjunctive-query', 'display_name': 'Conjunctive query', 'score': 0.75772136}, {'id': 'https://openalex.org/keywords/codds-theorem', 'display_name': "Codd's theorem", 'score': 0.70232713}, {'id': 'https://openalex.org/keywords/relational-database-systems', 'display_name': 'Relational Database Systems', 'score': 0.547706}, {'id': 'https://openalex.org/keywords/approximate-query-processing', 'display_name': 'Approximate Query Processing', 'score': 0.544155}, {'id': 'https://openalex.org/keywords/continuous-queries', 'display_name': 'Continuous Queries', 'score': 0.517438}, {'id': 'https://openalex.org/keywords/column-oriented-database-systems', 'display_name': 'Column-oriented Database Systems', 'score': 0.506698}, {'id': 'https://openalex.org/keywords/null', 'display_name': 'Null (SQL)', 'score': 0.50547314}, {'id': 'https://openalex.org/keywords/query-optimization', 'display_name': 'Query Optimization', 'score': 0.50313}], 'concepts': [{'id': 'https://openalex.org/C5655090', 'wikidata': 'https://www.wikidata.org/wiki/Q192588', 'display_name': 'Relational database', 'level': 2, 'score': 0.8354436}, {'id': 'https://openalex.org/C95916125', 'wikidata': 'https://www.wikidata.org/wiki/Q840540', 'display_name': 'Relational algebra', 'level': 3, 'score': 0.80855083}, {'id': 'https://openalex.org/C65647387', 'wikidata': 'https://www.wikidata.org/wiki/Q1781706', 'display_name': 'Conjunctive query', 'level': 3, 'score': 0.75772136}, {'id': 'https://openalex.org/C16739119', 'wikidata': 'https://www.wikidata.org/wiki/Q5139948', 'display_name': "Codd's theorem", 'level': 5, 'score': 0.70232713}, {'id': 'https://openalex.org/C99436015', 'wikidata': 'https://www.wikidata.org/wiki/Q1722436', 'display_name': 'Relational calculus', 'level': 4, 'score': 0.66488826}, {'id': 'https://openalex.org/C40207289', 'wikidata': 'https://www.wikidata.org/wiki/Q755662', 'display_name': 'Relational model', 'level': 3, 'score': 0.6417351}, {'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.5983855}, {'id': 'https://openalex.org/C203763787', 'wikidata': 'https://www.wikidata.org/wiki/Q371029', 'display_name': 'Null (SQL)', 'level': 2, 'score': 0.50547314}, {'id': 'https://openalex.org/C24394798', 'wikidata': 'https://www.wikidata.org/wiki/Q192588', 'display_name': 'Relational database management system', 'level': 3, 'score': 0.49127668}, {'id': 'https://openalex.org/C23123220', 'wikidata': 'https://www.wikidata.org/wiki/Q816826', 'display_name': 'Information retrieval', 'level': 1, 'score': 0.41915217}, {'id': 'https://openalex.org/C136119220', 'wikidata': 'https://www.wikidata.org/wiki/Q1000660', 'display_name': 'Algebra over a field', 'level': 2, 'score': 0.41856578}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.38566113}, {'id': 'https://openalex.org/C80444323', 'wikidata': 'https://www.wikidata.org/wiki/Q2878974', 'display_name': 'Theoretical computer science', 'level': 1, 'score': 0.3609863}, {'id': 'https://openalex.org/C33923547', 'wikidata': 'https://www.wikidata.org/wiki/Q395', 'display_name': 'Mathematics', 'level': 0, 'score': 0.33331057}, {'id': 'https://openalex.org/C202444582', 'wikidata': 'https://www.wikidata.org/wiki/Q837863', 'display_name': 'Pure mathematics', 'level': 1, 'score': 0.10028982}], 'mesh': [], 'locations_count': 1, 'locations': [{'is_oa': False, 'landing_page_url': 'https://scholar.archive.org/work/wua44dcvbngu3kgpm4dpmje3pe', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S4210189999', 'display_name': 'Proceedings of the Institute for System Programming of RAS', 'issn_l': '2079-8156', 'issn': ['2079-8156', '2220-6426'], 'is_oa': True, 'is_in_doaj': True, 'is_core': False, 'host_organization': 'https://openalex.org/P4310312722', 'host_organization_name': 'Institute for System Programming of the Russian Academy of Sciences (ISPRAS)', 'host_organization_lineage': ['https://openalex.org/P4310312722'], 'host_organization_lineage_names': ['Institute for System Programming of the Russian Academy of Sciences (ISPRAS)'], 'type': 'journal'}, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}], 'best_oa_location': None, 'sustainable_development_goals': [{'display_name': 'Reduced inequalities', 'id': 'https://metadata.un.org/sdg/10', 'score': 0.44}], 'grants': [], 'datasets': [], 'versions': [], 'referenced_works_count': 0, 'referenced_works': [], 'related_works': ['https://openalex.org/W58793094', 'https://openalex.org/W53196035', 'https://openalex.org/W3013047533', 'https://openalex.org/W3007337898', 'https://openalex.org/W2613697899', 'https://openalex.org/W2378275298', 'https://openalex.org/W2373284484', 'https://openalex.org/W2369460003', 'https://openalex.org/W2214258409', 'https://openalex.org/W2169117318', 'https://openalex.org/W2162502406', 'https://openalex.org/W2135103397', 'https://openalex.org/W2133629915', 'https://openalex.org/W2128189122', 'https://openalex.org/W2117881132', 'https://openalex.org/W2115101478', 'https://openalex.org/W2009920069', 'https://openalex.org/W2001946655', 'https://openalex.org/W172694688', 'https://openalex.org/W119186687'], 'abstract_inverted_index': None, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W3174970460', 'counts_by_year': [], 'updated_date': '2024-09-17T22:07:34.610928', 'created_date': '2021-07-05'}