{"id":"https://openalex.org/W1970660119","doi":"https://doi.org/10.1145/2786006.2786007","title":"LSM-Based Storage and Indexing","display_name":"LSM-Based Storage and Indexing","publication_year":2015,"publication_date":"2015-05-31","ids":{"openalex":"https://openalex.org/W1970660119","doi":"https://doi.org/10.1145/2786006.2786007","mag":"1970660119"},"language":"en","primary_location":{"id":"doi:10.1145/2786006.2786007","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2786006.2786007","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Second International ACM Workshop on Managing and Mining Enriched Geo-Spatial Data","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036044228","display_name":"Sattam Alsubaiee","orcid":null},"institutions":[{"id":"https://openalex.org/I1284598098","display_name":"King Abdulaziz City for Science and Technology","ror":"https://ror.org/05tdz6m39","country_code":"SA","type":"facility","lineage":["https://openalex.org/I1284598098"]}],"countries":["SA"],"is_corresponding":false,"raw_author_name":"Sattam Alsubaiee","raw_affiliation_strings":["King Abdulaziz City for Science and Technology, Riyadh, Saudi Arabia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"King Abdulaziz City for Science and Technology, Riyadh, Saudi Arabia","institution_ids":["https://openalex.org/I1284598098"]}]},{"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, CA 92697, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Irvine, CA 92697, USA","institution_ids":["https://openalex.org/I204250578"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100369885","display_name":"Chen Li","orcid":"https://orcid.org/0000-0002-8784-8148"},"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":"Chen Li","raw_affiliation_strings":["University of California, Irvine, CA 92697, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Irvine, CA 92697, USA","institution_ids":["https://openalex.org/I204250578"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0589,"has_fulltext":false,"cited_by_count":22,"citation_normalized_percentile":{"value":0.74116428,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9987999796867371,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.8466906547546387},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8284629583358765},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.667373776435852},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.6341013312339783},{"id":"https://openalex.org/keywords/identifier","display_name":"Identifier","score":0.6075963377952576},{"id":"https://openalex.org/keywords/filter","display_name":"Filter (signal processing)","score":0.6055539846420288},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.6015658974647522},{"id":"https://openalex.org/keywords/integer","display_name":"Integer (computer science)","score":0.5470741987228394},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.49718883633613586},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4966500401496887},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.443094402551651},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.38985979557037354},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.1305384635925293}],"concepts":[{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.8466906547546387},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8284629583358765},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.667373776435852},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.6341013312339783},{"id":"https://openalex.org/C154504017","wikidata":"https://www.wikidata.org/wiki/Q853614","display_name":"Identifier","level":2,"score":0.6075963377952576},{"id":"https://openalex.org/C106131492","wikidata":"https://www.wikidata.org/wiki/Q3072260","display_name":"Filter (signal processing)","level":2,"score":0.6055539846420288},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.6015658974647522},{"id":"https://openalex.org/C97137487","wikidata":"https://www.wikidata.org/wiki/Q729138","display_name":"Integer (computer science)","level":2,"score":0.5470741987228394},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.49718883633613586},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4966500401496887},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.443094402551651},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.38985979557037354},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.1305384635925293},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2786006.2786007","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2786006.2786007","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Second International ACM Workshop on Managing and Mining Enriched Geo-Spatial Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320322997","display_name":"King Abdulaziz City for Science and Technology","ror":"https://ror.org/05tdz6m39"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1665789430","https://openalex.org/W2013493775","https://openalex.org/W2035735180","https://openalex.org/W2068739275","https://openalex.org/W2210479044","https://openalex.org/W2265297126","https://openalex.org/W2269109801","https://openalex.org/W2294361615","https://openalex.org/W6697187514"],"related_works":["https://openalex.org/W17155033","https://openalex.org/W3207760230","https://openalex.org/W1496222301","https://openalex.org/W1590307681","https://openalex.org/W2536018345","https://openalex.org/W4312814274","https://openalex.org/W4285370786","https://openalex.org/W2296488620","https://openalex.org/W4385508213","https://openalex.org/W4388431390"],"abstract_inverted_index":{"With":[0],"the":[1,105,108,111],"social-media":[2],"data":[3,30,34],"explosion,":[4],"near":[5],"real-time":[6],"queries,":[7],"particularly":[8],"those":[9],"of":[10,110],"a":[11,38,42],"spatio-temporal":[12],"nature,":[13],"can":[14,72],"be":[15,73],"challenging.":[16],"In":[17],"this":[18],"paper,":[19],"we":[20],"show":[21],"how":[22],"to":[23,54,66],"efficiently":[24],"answer":[25],"queries":[26],"that":[27,40,46],"target":[28],"recent":[29],"within":[31],"very":[32],"large":[33],"sets.":[35],"We":[36,99],"describe":[37],"solution":[39,63,106],"exploits":[41],"natural":[43],"partitioning":[44],"property":[45],"LSM-based":[47,68],"indexes":[48],"have":[49,100],"for":[50],"components,":[51],"allowing":[52],"us":[53],"filter":[55],"out":[56],"many":[57],"components":[58],"when":[59],"answering":[60],"queries.":[61],"Our":[62],"is":[64],"generalizable":[65],"any":[67,86],"index":[69],"structure,":[70],"and":[71,102],"applied":[74],"not":[75],"just":[76],"on":[77,82,85],"temporal":[78],"fields":[79],"(e.g.,":[80],"based":[81],"recency),":[83],"but":[84],"\"time-correlated":[87],"fields\"":[88],"such":[89],"as":[90],"Universally":[91],"Unique":[92],"Identifiers":[93],"(UUIDs),":[94],"user-provided":[95],"integer":[96],"ids,":[97],"etc.":[98],"implemented":[101],"experimentally":[103],"evaluated":[104],"in":[107],"context":[109],"AsterixDB":[112],"system.":[113]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}