{"id":"https://openalex.org/W1975843750","doi":"https://doi.org/10.1145/1353343.1353390","title":"Mining all frequent projection-selection queries from a relational table","display_name":"Mining all frequent projection-selection queries from a relational table","publication_year":2008,"publication_date":"2008-03-25","ids":{"openalex":"https://openalex.org/W1975843750","doi":"https://doi.org/10.1145/1353343.1353390","mag":"1975843750"},"language":"en","primary_location":{"id":"doi:10.1145/1353343.1353390","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353390","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353390","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353390","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5061380228","display_name":"Tao-Yuan Jen","orcid":null},"institutions":[{"id":"https://openalex.org/I4210142324","display_name":"CY Cergy Paris Universit\u00e9","ror":"https://ror.org/043htjv09","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210142324"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Tao-Yuan Jen","raw_affiliation_strings":["Universit\u00e9 de Cergy-Pontoise, Cergy-Pontoise, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 de Cergy-Pontoise, Cergy-Pontoise, France","institution_ids":["https://openalex.org/I4210142324"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050019723","display_name":"Dominique Laurent","orcid":"https://orcid.org/0000-0002-7264-9576"},"institutions":[{"id":"https://openalex.org/I4210142324","display_name":"CY Cergy Paris Universit\u00e9","ror":"https://ror.org/043htjv09","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210142324"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Dominique Laurent","raw_affiliation_strings":["Universit\u00e9 de Cergy-Pontoise, Cergy-Pontoise, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 de Cergy-Pontoise, Cergy-Pontoise, France","institution_ids":["https://openalex.org/I4210142324"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034372518","display_name":"Nicolas Spyratos","orcid":"https://orcid.org/0000-0002-3432-8608"},"institutions":[{"id":"https://openalex.org/I102197404","display_name":"Universit\u00e9 Paris-Sud","ror":"https://ror.org/028rypz17","country_code":"FR","type":"education","lineage":["https://openalex.org/I102197404"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Nicolas Spyratos","raw_affiliation_strings":["Universit\u00e9 Paris-Sud, Orsay, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 Paris-Sud, Orsay, France","institution_ids":["https://openalex.org/I102197404"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.5358,"has_fulltext":true,"cited_by_count":16,"citation_normalized_percentile":{"value":0.90187396,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"368","last_page":"379"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9987999796867371,"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/T11063","display_name":"Rough Sets and Fuzzy Logic","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/conjunctive-query","display_name":"Conjunctive query","score":0.8330960869789124},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.683026909828186},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.6654122471809387},{"id":"https://openalex.org/keywords/equivalence-class","display_name":"Equivalence class (music)","score":0.6151391267776489},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6114807724952698},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5949031710624695},{"id":"https://openalex.org/keywords/projection","display_name":"Projection (relational algebra)","score":0.5595751404762268},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5517832040786743},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5496297478675842},{"id":"https://openalex.org/keywords/monotonic-function","display_name":"Monotonic function","score":0.5417320132255554},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.5267578959465027},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4821857511997223},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4430275857448578},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.37317508459091187},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.23814937472343445},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.23048192262649536},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.17786985635757446},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.14115959405899048},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08256027102470398}],"concepts":[{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.8330960869789124},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.683026909828186},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.6654122471809387},{"id":"https://openalex.org/C2777044963","wikidata":"https://www.wikidata.org/wiki/Q5384707","display_name":"Equivalence class (music)","level":2,"score":0.6151391267776489},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6114807724952698},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5949031710624695},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.5595751404762268},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5517832040786743},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5496297478675842},{"id":"https://openalex.org/C72169020","wikidata":"https://www.wikidata.org/wiki/Q194404","display_name":"Monotonic function","level":2,"score":0.5417320132255554},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5267578959465027},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4821857511997223},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4430275857448578},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37317508459091187},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.23814937472343445},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.23048192262649536},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.17786985635757446},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.14115959405899048},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08256027102470398},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1353343.1353390","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353390","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353390","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.377.684","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.377.684","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2008-Nantes/papers/p368-Jen.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.541.9673","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.541.9673","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://depinfo.u-cergy.fr/~dlaurent/ressources/publi/EDBT_fixed.pdf","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/1353343.1353390","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353390","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353390","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Reduced inequalities","score":0.49000000953674316,"id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1975843750.pdf","grobid_xml":"https://content.openalex.org/works/W1975843750.grobid-xml"},"referenced_works_count":16,"referenced_works":["https://openalex.org/W43035074","https://openalex.org/W1495384623","https://openalex.org/W1528932865","https://openalex.org/W1553696291","https://openalex.org/W1573373104","https://openalex.org/W1579692176","https://openalex.org/W1673774254","https://openalex.org/W1992810975","https://openalex.org/W2001199771","https://openalex.org/W2106279168","https://openalex.org/W2115482638","https://openalex.org/W2145631985","https://openalex.org/W2162621793","https://openalex.org/W2914840321","https://openalex.org/W4212848460","https://openalex.org/W6633402183"],"related_works":["https://openalex.org/W1651216127","https://openalex.org/W2154694886","https://openalex.org/W2382232876","https://openalex.org/W3174970460","https://openalex.org/W1639806124","https://openalex.org/W2182642161","https://openalex.org/W4255196547","https://openalex.org/W2358659170","https://openalex.org/W146502352","https://openalex.org/W206482712"],"abstract_inverted_index":{"In":[0],"this":[1],"paper":[2],"we":[3,35,52,60,77],"study":[4],"the":[5,38,62,65,98],"problem":[6,18],"of":[7,46,93],"mining":[8],"all":[9,91],"frequent":[10],"queries":[11,58,92],"in":[12],"a":[13,17,44,54],"given":[14],"database":[15],"table,":[16],"known":[19],"to":[20,31,40,72],"be":[21,41],"intractable":[22],"even":[23],"for":[24],"conjunctive":[25],"queries.":[26],"We":[27],"restrict":[28],"our":[29],"attention":[30],"projection-selection":[32],"queries,":[33],"and":[34,59,74,86],"assume":[36],"that":[37],"table":[39],"mined":[42],"satisfies":[43],"set":[45],"functional":[47],"dependencies.":[48],"Under":[49],"these":[50],"assumptions":[51],"define":[53,78],"pre-ordering":[55],"\u227a":[56,80,84,88],"over":[57],"show":[61],"following:":[63],"(a)":[64],"support":[66],"measure":[67],"is":[68],"anti-monotonic":[69],"(with":[70],"respect":[71],"\u227a),":[73],"(b)":[75],"if":[76],"q":[79,83,89],"q'":[81,85,87],"iff":[82],"then":[90],"an":[94],"equivalence":[95],"class":[96],"have":[97],"same":[99],"support.":[100]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2012,"cited_by_count":5}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}