Get quick answers to your questions about the article from our AI researcher chatbot
{'id': 'https://openalex.org/W2043209364', 'doi': 'https://doi.org/10.1016/0167-9236(93)e0047-h', 'title': 'A knowledge-based system for performing reverse engineering of relational databases', 'display_name': 'A knowledge-based system for performing reverse engineering of relational databases', 'publication_year': 1995, 'publication_date': '1995-03-01', 'ids': {'openalex': 'https://openalex.org/W2043209364', 'doi': 'https://doi.org/10.1016/0167-9236(93)e0047-h', 'mag': '2043209364'}, 'language': 'en', 'primary_location': {'is_oa': False, 'landing_page_url': 'https://doi.org/10.1016/0167-9236(93)e0047-h', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S11479521', 'display_name': 'Decision Support Systems', 'issn_l': '0167-9236', 'issn': ['0167-9236', '1873-5797'], '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/A5048128109', 'display_name': 'Roger H.L. Chiang', 'orcid': None}, 'institutions': [{'id': 'https://openalex.org/I172675005', 'display_name': 'Nanyang Technological University', 'ror': 'https://ror.org/02e7b5302', 'country_code': 'SG', 'type': 'education', 'lineage': ['https://openalex.org/I172675005']}], 'countries': ['SG'], 'is_corresponding': True, 'raw_author_name': 'Roger H.L. Chiang', 'raw_affiliation_strings': ['Nanyang Technological University, Singapore 2263'], 'affiliations': [{'raw_affiliation_string': 'Nanyang Technological University, Singapore 2263', 'institution_ids': ['https://openalex.org/I172675005']}]}], 'institution_assertions': [], 'countries_distinct_count': 1, 'institutions_distinct_count': 1, 'corresponding_author_ids': ['https://openalex.org/A5048128109'], 'corresponding_institution_ids': ['https://openalex.org/I172675005'], 'apc_list': {'value': 3280, 'currency': 'USD', 'value_usd': 3280, 'provenance': 'doaj'}, 'apc_paid': None, 'fwci': 0.965, 'has_fulltext': True, 'fulltext_origin': 'ngrams', 'cited_by_count': 24, 'citation_normalized_percentile': {'value': 0.851159, 'is_in_top_1_percent': False, 'is_in_top_10_percent': False}, 'cited_by_percentile_year': {'min': 86, 'max': 87}, 'biblio': {'volume': '13', 'issue': '3-4', 'first_page': '295', 'last_page': '312'}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10317', 'display_name': 'Advanced Database Systems and Queries', 'score': 0.9997, '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': 'Advanced Database Systems and Queries', 'score': 0.9997, '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/T10215', 'display_name': 'Semantic Web and Ontologies', 'score': 0.9975, '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/T11106', 'display_name': 'Data Management and Algorithms', 'score': 0.9959, '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'}}], 'keywords': [{'id': 'https://openalex.org/keywords/entity–relationship-model', 'display_name': 'Entity–relationship model', 'score': 0.51303446}, {'id': 'https://openalex.org/keywords/heuristics', 'display_name': 'Heuristics', 'score': 0.47602728}, {'id': 'https://openalex.org/keywords/schema', 'display_name': 'Schema (genetic algorithms)', 'score': 0.45704988}], 'concepts': [{'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.7763159}, {'id': 'https://openalex.org/C510870499', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'SQL', 'level': 2, 'score': 0.64789784}, {'id': 'https://openalex.org/C5655090', 'wikidata': 'https://www.wikidata.org/wiki/Q192588', 'display_name': 'Relational database', 'level': 2, 'score': 0.63497007}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.5750821}, {'id': 'https://openalex.org/C30775581', 'wikidata': 'https://www.wikidata.org/wiki/Q632285', 'display_name': 'Database schema', 'level': 3, 'score': 0.5698236}, {'id': 'https://openalex.org/C24394798', 'wikidata': 'https://www.wikidata.org/wiki/Q192588', 'display_name': 'Relational database management system', 'level': 3, 'score': 0.53920144}, {'id': 'https://openalex.org/C148840519', 'wikidata': 'https://www.wikidata.org/wiki/Q1049878', 'display_name': 'Database design', 'level': 2, 'score': 0.5201888}, {'id': 'https://openalex.org/C5968703', 'wikidata': 'https://www.wikidata.org/wiki/Q267136', 'display_name': 'Database model', 'level': 3, 'score': 0.51473236}, {'id': 'https://openalex.org/C103593891', 'wikidata': 'https://www.wikidata.org/wiki/Q624546', 'display_name': 'Entity–relationship model', 'level': 3, 'score': 0.51303446}, {'id': 'https://openalex.org/C127705205', 'wikidata': 'https://www.wikidata.org/wiki/Q5748245', 'display_name': 'Heuristics', 'level': 2, 'score': 0.47602728}, {'id': 'https://openalex.org/C40207289', 'wikidata': 'https://www.wikidata.org/wiki/Q755662', 'display_name': 'Relational model', 'level': 3, 'score': 0.46186146}, {'id': 'https://openalex.org/C52146309', 'wikidata': 'https://www.wikidata.org/wiki/Q7431116', 'display_name': 'Schema (genetic algorithms)', 'level': 2, 'score': 0.45704988}, {'id': 'https://openalex.org/C124101348', 'wikidata': 'https://www.wikidata.org/wiki/Q172491', 'display_name': 'Data mining', 'level': 1, 'score': 0.41583538}, {'id': 'https://openalex.org/C23123220', 'wikidata': 'https://www.wikidata.org/wiki/Q816826', 'display_name': 'Information retrieval', 'level': 1, 'score': 0.325248}, {'id': 'https://openalex.org/C111919701', 'wikidata': 'https://www.wikidata.org/wiki/Q9135', 'display_name': 'Operating system', 'level': 1, 'score': 0.0}], 'mesh': [], 'locations_count': 1, 'locations': [{'is_oa': False, 'landing_page_url': 'https://doi.org/10.1016/0167-9236(93)e0047-h', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S11479521', 'display_name': 'Decision Support Systems', 'issn_l': '0167-9236', 'issn': ['0167-9236', '1873-5797'], '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': 22, 'referenced_works': ['https://openalex.org/W1490459971', 'https://openalex.org/W1510026310', 'https://openalex.org/W1512840853', 'https://openalex.org/W1521935994', 'https://openalex.org/W1552346309', 'https://openalex.org/W1581093035', 'https://openalex.org/W1587731453', 'https://openalex.org/W166362352', 'https://openalex.org/W1977378431', 'https://openalex.org/W198128062', 'https://openalex.org/W1998046157', 'https://openalex.org/W2006267758', 'https://openalex.org/W2050480346', 'https://openalex.org/W2104771072', 'https://openalex.org/W2113827629', 'https://openalex.org/W2127972622', 'https://openalex.org/W2144192824', 'https://openalex.org/W2244808476', 'https://openalex.org/W2489353692', 'https://openalex.org/W2945526390', 'https://openalex.org/W50942968', 'https://openalex.org/W96648690'], 'related_works': ['https://openalex.org/W52829598', 'https://openalex.org/W4297044271', 'https://openalex.org/W279222092', 'https://openalex.org/W2512945146', 'https://openalex.org/W2460926837', 'https://openalex.org/W2007556552', 'https://openalex.org/W1998046157', 'https://openalex.org/W1982714394', 'https://openalex.org/W1978969411', 'https://openalex.org/W108313336'], 'abstract_inverted_index': None, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2043209364', 'counts_by_year': [{'year': 2022, 'cited_by_count': 1}, {'year': 2014, 'cited_by_count': 2}, {'year': 2012, 'cited_by_count': 1}], 'updated_date': '2024-12-14T06:44:38.562492', 'created_date': '2016-06-24'}