{"id":"https://openalex.org/W2106907670","doi":"https://doi.org/10.1007/3-540-45754-2_9","title":"Experiences with IR TOP N Optimization in a Main Memory DBMS: Applying \u2018the Database Approach\u2019 in New Domains","display_name":"Experiences with IR TOP N Optimization in a Main Memory DBMS: Applying \u2018the Database Approach\u2019 in New Domains","publication_year":2001,"publication_date":"2001-01-01","ids":{"openalex":"https://openalex.org/W2106907670","doi":"https://doi.org/10.1007/3-540-45754-2_9","mag":"2106907670"},"language":"en","primary_location":{"id":"doi:10.1007/3-540-45754-2_9","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-45754-2_9","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://ir.cwi.nl/pub/10449","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5040369634","display_name":"Henk Ernst Blok","orcid":null},"institutions":[{"id":"https://openalex.org/I94624287","display_name":"University of Twente","ror":"https://ror.org/006hf6230","country_code":"NL","type":"education","lineage":["https://openalex.org/I94624287"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Henk Ernst Blok","raw_affiliation_strings":["Computer Science Department, University of Twente, PO BOX 217, NL 7500 AE, Enschede, The Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Department, University of Twente, PO BOX 217, NL 7500 AE, Enschede, The Netherlands","institution_ids":["https://openalex.org/I94624287"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060259737","display_name":"Arjen P. de Vries","orcid":"https://orcid.org/0000-0002-2888-4202"},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832","https://openalex.org/I4405262988"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Arjen P. de Vries","raw_affiliation_strings":["CWI, Amsterdam, The Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, The Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071011503","display_name":"Henk Blanken","orcid":null},"institutions":[{"id":"https://openalex.org/I94624287","display_name":"University of Twente","ror":"https://ror.org/006hf6230","country_code":"NL","type":"education","lineage":["https://openalex.org/I94624287"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Henk M. Blanken","raw_affiliation_strings":["Computer Science Department, University of Twente, PO BOX 217, NL 7500 AE, Enschede, The Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Department, University of Twente, PO BOX 217, NL 7500 AE, Enschede, The Netherlands","institution_ids":["https://openalex.org/I94624287"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5091150744","display_name":"Peter M. G. Apers","orcid":null},"institutions":[{"id":"https://openalex.org/I94624287","display_name":"University of Twente","ror":"https://ror.org/006hf6230","country_code":"NL","type":"education","lineage":["https://openalex.org/I94624287"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Peter M. G. Apers","raw_affiliation_strings":["Computer Science Department, University of Twente, PO BOX 217, NL 7500 AE, Enschede, The Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Department, University of Twente, PO BOX 217, NL 7500 AE, Enschede, The Netherlands","institution_ids":["https://openalex.org/I94624287"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":2.15,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.87669053,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"126","last_page":"151"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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/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/T10627","display_name":"Advanced Image and Video Retrieval Techniques","score":0.995199978351593,"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/computer-science","display_name":"Computer science","score":0.8834688663482666},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.732319712638855},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.6849635243415833},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6575030088424683},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6266908049583435},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5433611869812012},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5300865769386292},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5219597220420837},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.5147736072540283},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.4925728440284729},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.48091575503349304},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.46075329184532166},{"id":"https://openalex.org/keywords/alias","display_name":"Alias","score":0.45467549562454224},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3790375888347626},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3618861138820648},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.24482518434524536},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.18349114060401917}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8834688663482666},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.732319712638855},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6849635243415833},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6575030088424683},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6266908049583435},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5433611869812012},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5300865769386292},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5219597220420837},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.5147736072540283},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.4925728440284729},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.48091575503349304},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.46075329184532166},{"id":"https://openalex.org/C46681722","wikidata":"https://www.wikidata.org/wiki/Q4725589","display_name":"Alias","level":2,"score":0.45467549562454224},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3790375888347626},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3618861138820648},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.24482518434524536},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.18349114060401917},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":6,"locations":[{"id":"doi:10.1007/3-540-45754-2_9","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-45754-2_9","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:ris.utwente.nl:openaire_cris_publications/f63eb03b-44aa-42e3-a0cd-2d9d6079e161","is_oa":false,"landing_page_url":"https://research.utwente.nl/en/publications/f63eb03b-44aa-42e3-a0cd-2d9d6079e161","pdf_url":null,"source":{"id":"https://openalex.org/S4406922991","display_name":"University of Twente Research Information","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Read, B (ed.), Blok, H E, de Vries, A P, Blanken, H & Apers, P M G 2001, 'Experiences with IR Top N Optimization in a Main Memory DBMS: Applying 'The Database Approach' in New Domains', Paper presented at 18th British National Conference on Databases, BNCOD 2001, Chilton, United Kingdom, 9/07/01 - 11/07/01 pp. 126-151. < http://eprints.eemcs.utwente.nl/secure2/7168/01/db-utwente-0000000002.pdf >","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:cwi:oai:cwi.nl:10449","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/10449","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferencepaper"},{"id":"pmh:cwi:oai:cwi.nl:16564","is_oa":false,"landing_page_url":"https://ir.cwi.nl/pub/16564","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferencepaper"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.140.1753","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.140.1753","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.utwente.nl/~amis/Publications/db-utwente-0000000002.pdf","raw_type":"text"},{"id":"pmh:oai:ris.utwente.nl:publications/f63eb03b-44aa-42e3-a0cd-2d9d6079e161","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""}],"best_oa_location":{"id":"pmh:cwi:oai:cwi.nl:10449","is_oa":true,"landing_page_url":"https://ir.cwi.nl/pub/10449","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferencepaper"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.5600000023841858,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W119481552","https://openalex.org/W154011233","https://openalex.org/W185368777","https://openalex.org/W1482518080","https://openalex.org/W1503217545","https://openalex.org/W1534714852","https://openalex.org/W1540124269","https://openalex.org/W1570477871","https://openalex.org/W1605873790","https://openalex.org/W1741576755","https://openalex.org/W2020919487","https://openalex.org/W2066636486","https://openalex.org/W2068644217","https://openalex.org/W2079656678","https://openalex.org/W2094320135","https://openalex.org/W2099799867","https://openalex.org/W2104128837","https://openalex.org/W2106795722","https://openalex.org/W2134829868","https://openalex.org/W4214568865","https://openalex.org/W4248625073","https://openalex.org/W6670271065","https://openalex.org/W7001192717","https://openalex.org/W7008621649"],"related_works":["https://openalex.org/W2365999782","https://openalex.org/W2889903446","https://openalex.org/W2942097156","https://openalex.org/W1564408968","https://openalex.org/W2079690139","https://openalex.org/W2003701127","https://openalex.org/W2375855311","https://openalex.org/W1986707023","https://openalex.org/W3103741606","https://openalex.org/W2134740279"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}