Publication Information

{'id': 'https://openalex.org/W2798839954', 'doi': 'https://doi.org/10.1145/3183713.3183761', 'title': 'Lightweight Cardinality Estimation in LSM-based Systems', 'display_name': 'Lightweight Cardinality Estimation in LSM-based Systems', 'publication_year': 2018, 'publication_date': '2018-05-25', 'ids': {'openalex': 'https://openalex.org/W2798839954', 'doi': 'https://doi.org/10.1145/3183713.3183761', 'mag': '2798839954'}, 'language': 'en', 'primary_location': {'is_oa': True, 'landing_page_url': 'https://doi.org/10.1145/3183713.3183761', 'pdf_url': 'https://dl.acm.org/doi/pdf/10.1145/3183713.3183761', 'source': {'id': 'https://openalex.org/S4363608845', 'display_name': 'Proceedings of the 2022 International Conference on Management of Data', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': None, 'license_id': None, 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'type': 'article', 'type_crossref': 'proceedings-article', 'indexed_in': ['crossref'], 'open_access': {'is_oa': True, 'oa_status': 'bronze', 'oa_url': 'https://dl.acm.org/doi/pdf/10.1145/3183713.3183761', 'any_repository_has_fulltext': False}, 'authorships': [{'author_position': 'first', 'author': {'id': 'https://openalex.org/A5074957280', 'display_name': 'Ildar Absalyamov', 'orcid': None}, 'institutions': [{'id': 'https://openalex.org/I103635307', 'display_name': 'University of California, Riverside', 'ror': 'https://ror.org/03nawhv43', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I103635307']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Ildar Absalyamov', 'raw_affiliation_strings': ['University of California, Riverside, Riverside, CA, USA'], 'affiliations': [{'raw_affiliation_string': 'University of California, Riverside, Riverside, CA, USA', 'institution_ids': ['https://openalex.org/I103635307']}]}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5011512061', 'display_name': 'Michael J. Carey', 'orcid': 'https://orcid.org/0000-0003-1561-4059'}, 'institutions': [{'id': 'https://openalex.org/I204250578', 'display_name': 'University of California, Irvine', 'ror': 'https://ror.org/04gyf1771', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I204250578']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Michael J. Carey', 'raw_affiliation_strings': ['University of California, Irvine, Irvine, CA, USA'], 'affiliations': [{'raw_affiliation_string': 'University of California, Irvine, Irvine, CA, USA', 'institution_ids': ['https://openalex.org/I204250578']}]}, {'author_position': 'last', 'author': {'id': 'https://openalex.org/A5000947547', 'display_name': 'Vassilis J. Tsotras', 'orcid': 'https://orcid.org/0000-0001-5462-9451'}, 'institutions': [{'id': 'https://openalex.org/I103635307', 'display_name': 'University of California, Riverside', 'ror': 'https://ror.org/03nawhv43', 'country_code': 'US', 'type': 'education', 'lineage': ['https://openalex.org/I103635307']}], 'countries': ['US'], 'is_corresponding': False, 'raw_author_name': 'Vassilis J. Tsotras', 'raw_affiliation_strings': ['University of California, Riverside, Riverside, CA, USA'], 'affiliations': [{'raw_affiliation_string': 'University of California, Riverside, Riverside, CA, USA', 'institution_ids': ['https://openalex.org/I103635307']}]}], 'institution_assertions': [], 'countries_distinct_count': 1, 'institutions_distinct_count': 2, 'corresponding_author_ids': [], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 1.667, 'has_fulltext': True, 'fulltext_origin': 'pdf', 'cited_by_count': 22, 'citation_normalized_percentile': {'value': 0.901154, 'is_in_top_1_percent': False, 'is_in_top_10_percent': True}, 'cited_by_percentile_year': {'min': 91, 'max': 92}, 'biblio': {'volume': None, 'issue': None, 'first_page': None, 'last_page': None}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10317', 'display_name': 'Advanced Database Systems and Queries', 'score': 0.9994, '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.9994, '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': 'Data Management and Algorithms', 'score': 0.9992, '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/T12292', 'display_name': 'Graph Theory and Algorithms', 'score': 0.9971, 'subfield': {'id': 'https://openalex.org/subfields/1707', 'display_name': 'Computer Vision and Pattern Recognition'}, '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/merge', 'display_name': 'Merge (version control)', 'score': 0.6336671}, {'id': 'https://openalex.org/keywords/online-analytical-processing', 'display_name': 'Online analytical processing', 'score': 0.58034575}, {'id': 'https://openalex.org/keywords/cardinality', 'display_name': 'Cardinality (data modeling)', 'score': 0.4506703}], 'concepts': [{'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.867581}, {'id': 'https://openalex.org/C197129107', 'wikidata': 'https://www.wikidata.org/wiki/Q1921621', 'display_name': 'Merge (version control)', 'level': 2, 'score': 0.6336671}, {'id': 'https://openalex.org/C201932085', 'wikidata': 'https://www.wikidata.org/wiki/Q642514', 'display_name': 'Online analytical processing', 'level': 3, 'score': 0.58034575}, {'id': 'https://openalex.org/C79158427', 'wikidata': 'https://www.wikidata.org/wiki/Q485396', 'display_name': 'Analytics', 'level': 2, 'score': 0.57278043}, {'id': 'https://openalex.org/C157692150', 'wikidata': 'https://www.wikidata.org/wiki/Q2919848', 'display_name': 'Query optimization', 'level': 2, 'score': 0.54808253}, {'id': 'https://openalex.org/C87117476', 'wikidata': 'https://www.wikidata.org/wiki/Q362383', 'display_name': 'Cardinality (data modeling)', 'level': 2, 'score': 0.4506703}, {'id': 'https://openalex.org/C186967261', 'wikidata': 'https://www.wikidata.org/wiki/Q5082128', 'display_name': 'Mobile device', 'level': 2, 'score': 0.41304958}, {'id': 'https://openalex.org/C124101348', 'wikidata': 'https://www.wikidata.org/wiki/Q172491', 'display_name': 'Data mining', 'level': 1, 'score': 0.396826}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.39375332}, {'id': 'https://openalex.org/C120314980', 'wikidata': 'https://www.wikidata.org/wiki/Q180634', 'display_name': 'Distributed computing', 'level': 1, 'score': 0.3629798}, {'id': 'https://openalex.org/C135572916', 'wikidata': 'https://www.wikidata.org/wiki/Q193351', 'display_name': 'Data warehouse', 'level': 2, 'score': 0.336823}, {'id': 'https://openalex.org/C23123220', 'wikidata': 'https://www.wikidata.org/wiki/Q816826', 'display_name': 'Information retrieval', 'level': 1, 'score': 0.2745052}, {'id': 'https://openalex.org/C136764020', 'wikidata': 'https://www.wikidata.org/wiki/Q466', 'display_name': 'World Wide Web', 'level': 1, 'score': 0.110726595}], 'mesh': [], 'locations_count': 1, 'locations': [{'is_oa': True, 'landing_page_url': 'https://doi.org/10.1145/3183713.3183761', 'pdf_url': 'https://dl.acm.org/doi/pdf/10.1145/3183713.3183761', 'source': {'id': 'https://openalex.org/S4363608845', 'display_name': 'Proceedings of the 2022 International Conference on Management of Data', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': None, 'license_id': None, 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}], 'best_oa_location': {'is_oa': True, 'landing_page_url': 'https://doi.org/10.1145/3183713.3183761', 'pdf_url': 'https://dl.acm.org/doi/pdf/10.1145/3183713.3183761', 'source': {'id': 'https://openalex.org/S4363608845', 'display_name': 'Proceedings of the 2022 International Conference on Management of Data', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'conference'}, 'license': None, 'license_id': None, 'version': 'publishedVersion', 'is_accepted': True, 'is_published': True}, 'sustainable_development_goals': [], 'grants': [{'funder': 'https://openalex.org/F4320306076', 'funder_display_name': 'National Science Foundation', 'award_id': 'CNS-1305253, CNS-1305430, III-1447826, III-1447720'}], 'datasets': [], 'versions': [], 'referenced_works_count': 39, 'referenced_works': ['https://openalex.org/W1489255272', 'https://openalex.org/W1681014725', 'https://openalex.org/W1750237583', 'https://openalex.org/W1981420413', 'https://openalex.org/W1991271936', 'https://openalex.org/W1992023276', 'https://openalex.org/W2005188603', 'https://openalex.org/W2007069074', 'https://openalex.org/W2018666252', 'https://openalex.org/W2021850646', 'https://openalex.org/W2022858489', 'https://openalex.org/W2045604576', 'https://openalex.org/W2068739275', 'https://openalex.org/W2071989194', 'https://openalex.org/W2079499902', 'https://openalex.org/W2087177601', 'https://openalex.org/W2102166438', 'https://openalex.org/W2106163100', 'https://openalex.org/W2110086534', 'https://openalex.org/W2110557355', 'https://openalex.org/W2112452856', 'https://openalex.org/W2120074607', 'https://openalex.org/W2120108467', 'https://openalex.org/W2131126403', 'https://openalex.org/W2135527206', 'https://openalex.org/W2139276812', 'https://openalex.org/W2145910025', 'https://openalex.org/W2147232895', 'https://openalex.org/W2150779766', 'https://openalex.org/W2152029707', 'https://openalex.org/W2153160273', 'https://openalex.org/W2153329411', 'https://openalex.org/W2153511931', 'https://openalex.org/W2171903035', 'https://openalex.org/W2212047990', 'https://openalex.org/W2265297126', 'https://openalex.org/W2294361615', 'https://openalex.org/W4242587584', 'https://openalex.org/W4255671299'], 'related_works': ['https://openalex.org/W6138692', 'https://openalex.org/W2382180329', 'https://openalex.org/W2378213774', 'https://openalex.org/W2377387014', 'https://openalex.org/W2375394542', 'https://openalex.org/W2367419170', 'https://openalex.org/W2363019959', 'https://openalex.org/W2357522326', 'https://openalex.org/W23190051', 'https://openalex.org/W1535822977'], 'abstract_inverted_index': {'Data': [0], 'sources,': [1], 'such': [2, 44], 'as': [3], 'social': [4], 'media,': [5], 'mobile': [6], 'apps': [7], 'and': [8, 76], 'IoT': [9], 'sensors,': [10], 'generate': [11, 102], 'billions': [12], 'of': [13, 22, 70, 83, 121], 'records': [14], 'each': [15], 'day.': [16], 'Keeping': [17], 'up': [18], 'with': [19], 'this': [20], 'influx': [21], 'data': [23, 50, 71], 'while': [24], 'providing': [25], 'useful': [26], 'analytics': [27], 'to': [28, 46, 52, 101], 'the': [29, 92, 99, 122, 128], 'users': [30], 'is': [31, 51, 89], 'a': [32, 63, 73], 'major': [33], 'challenge': [34], 'for': [35], "today's": [36], 'data-intensive': [37], 'systems.': [38], 'A': [39], 'popular': [40], 'solution': [41], 'that': [42, 84, 91, 109], 'allows': [43], 'systems': [45, 61], 'handle': [47], 'rapidly': [48], 'incoming': [49], 'rely': [53, 113], 'on': [54, 81, 98, 114], 'log-structured': [55], 'merge': [56], '(LSM)': [57], 'storage': [58], 'models.': [59], 'LSM-based': [60], 'provide': [62], 'tunable': [64], 'trade-off': [65], 'between': [66], 'ingesting': [67], 'vast': [68], 'amounts': [69], 'at': [72], 'high': [74], 'rate': [75], 'running': [77], 'efficient': [78, 103], 'analytical': [79], 'queries': [80], 'top': [82], 'data.': [85], 'For': [86], 'queries,': [87], 'it': [88], 'well-known': [90], 'query': [93, 111, 130], 'processing': [94], 'performance': [95], 'largely': [96], 'depends': [97], 'ability': [100], 'execution': [104], 'plans.': [105], 'Previous': [106], 'research': [107], 'showed': [108], 'OLAP': [110], 'workloads': [112], 'having': [115], 'small,': [116], 'yet': [117], 'precise,': [118], 'statistical': [119], 'summaries': [120], 'underlying': [123], 'data,': [124], 'which': [125], 'can': [126], 'drive': [127], 'cost-based': [129], 'optimization.': [131]}, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2798839954', 'counts_by_year': [{'year': 2024, 'cited_by_count': 5}, {'year': 2023, 'cited_by_count': 5}, {'year': 2022, 'cited_by_count': 2}, {'year': 2021, 'cited_by_count': 2}, {'year': 2020, 'cited_by_count': 3}, {'year': 2019, 'cited_by_count': 5}], 'updated_date': '2025-01-08T15:05:21.454708', 'created_date': '2018-05-07'}