Patent application EP17168477A (EP), filed 2017-04-27
Publication number: EP3239862A1
Title: SELECTION QUERY LANGUAGE METHODS AND SYSTEMS
Abstract: [0001]    Provided are methods and systems comprising receiving a plurality of data tables, wherein each data table comprises at least one row, generating a first handle for a first value in a table of the plurality of tables, wherein the first handle comprises an indication of whether a row in each of the plurality of tables is associated or not associated with the first value, and performing one or more operations on the first handle.
IPC codes: G06F  17/    30            A I
G06F  16/    22            A I
Claims: number: 1
text: A method comprising:
number: 2
text: The method of claim 1, wherein the first handle comprises a column for each row of each table of the plurality of tables and a row for each table of the plurality of tables.
number: 3
text: The method of claim 2, wherein an intersection of a column and a row in the first handle comprises an indication of association or no association with the first value.
number: 4
text: The method of claim 1, wherein performing one or more operations on the first handle comprises performing one or more of SET HANDLE H, SELECT, WHERE, COMPLEMENT, UNION, INTERSECT, STATE(n), UPDATE, AGGR, SORT, SESSION, PAGE, IN, ON, WITH, FROM, and combinations thereof.
number: 5
text: The method of claim 1, wherein performing one or more operations on the first handle comprises performing a PAGE operation to retrieve one or more data values from the plurality of tables based on the first handle.
number: 6
text: The method of claim 1, further comprising generating a second handle for a second value in a table of the plurality of tables, wherein the second handle comprises an indication of whether a row in each of the plurality of tables is associated or not associated with the second value.
number: 7
text: The method of claim 6, wherein performing one or more operations on the first handle comprises performing one or more operations on the first handle and the second handle.
number: 8
text: The method of claim 1, further comprising:
number: 9
text: A method comprising:
number: 10
text: The method of claim 9, wherein the first handle comprises a column for each row of each table of the plurality of tables and a row for each table of the plurality of tables.
number: 11
text: The method of claim 10, wherein an intersection of a column and a row in the first handle comprises an indication of association or no association with the first value.
number: 12
text: The method of claim 9, wherein performing one or more operations on the first handle comprises performing one or more of SET HANDLE H, SELECT, WHERE, COMPLEMENT, UNION, INTERSECT, STATE(n), UPDATE, AGGR, SORT, SESSION, PAGE, IN, ON, WITH, FROM, and combinations thereof.
number: 13
text: The method of claim 9, wherein performing one or more operations on the first handle comprises performing a PAGE operation to retrieve one or more data values from the plurality of tables based on the first handle.
number: 14
text: The method of claim 9, further comprising generating a second handle for a second hypercube, wherein the second handle represents results of a mathematical function applied to at least a portion of the plurality of data tables.
number: 15
text: The method of claim 14, wherein performing one or more operations on the first handle comprises performing one or more operations on the first handle and the second handle.
number: 16
text: The method of claim 9, further comprising:
Office action: search_report, dated 2017-11-01
Rejection reasons: novelty_epc_54
inventive_step_epc_56
Prior art cited: ref_id: US7058621B1
ref_type: patent
severity: background
ref_id: US8745099B2
ref_type: patent
severity: background
ref_id: US8244741B2
ref_type: patent
severity: background
ref_id: US201314054321A
ref_type: patent
severity: background
ref_id: [XYI]     - JIANG ZHAN ET AL: "ITREKS: Keyword Search over Relational Database by Indexing Tuple Relationship", 9 April 2007, ADVANCES IN DATABASES: CONCEPTS, SYSTEMS AND APPLICATIONS; [LECTURE NOTES IN COMPUTER SCIENCE], SPRINGER BERLIN HEIDELBERG, BERLIN, HEIDELBERG, PAGE(S) 67 - 78, ISBN: 978-3-540-71702-7, XP019078903
ref_type: npl
severity: background
ref_id: - DURVAL RAMOS: "Paging a Query with SQL Server", 31 March 2014 (2014-03-31), XP055400191, Retrieved from the Internet <URL:https://social.technet.microsoft.com/wiki/contents/articles/23811.paging-a-query-with-sql-server.aspx> [retrieved on 20170822]
ref_type: npl
severity: background
ref_id: - CHRISTINA ADAMS: "Qlikview Set Analysis Guide | Result Data", 8 November 2012 (2012-11-08), pages 1 - 6, XP055400170, Retrieved from the Internet <URL:https://www.resultdata.com/qlikview-set-analysis-guide/> [retrieved on 20170822]
ref_type: npl
severity: background
ref_id: - HENRIC CRONSTRÖM: "Qlik Design Blog : A Primer on Set Analysis | Qlik Community", 17 February 2015 (2015-02-17), XP055400381, Retrieved from the Internet <URL:https://community.qlik.com/blogs/qlikviewdesignblog/2015/02/16/set-analysis> [retrieved on 20170822]
ref_type: npl
severity: background
ref_id: - JIANG ZHAN ET AL, ITREKS: Keyword Search over Relational Database by Indexing Tuple Relationship, ADVANCES IN DATABASES: CONCEPTS, SYSTEMS AND APPLICATIONS; [LECTURE NOTES IN COMPUTER SCIENCE], SPRINGER BERLIN HEIDELBERG, BERLIN, HEIDELBERG, PAGE(S) 67 - 78, (20070409), ISBN 978-3-540-71702-7, XP019078903 [X] 1,4,6,7 * Sections 1, 3, 4 * [Y] 5,8,13,16 [I] 2,3,9-12,14,15
ref_type: npl
severity: novelty_destroying
ref_id: - Durval Ramos, "Paging a Query with SQL Server", (20140331), URL: https://social.technet.microsoft.com/wiki/contents/articles/23811.paging-a-query-with-sql-server.aspx, (20170822), XP055400191 [Y] 5,13 * the whole document *
ref_type: npl
severity: obviousness
ref_id: - Christina Adams, "Qlikview Set Analysis Guide | Result Data", (20121108), pages 1 - 6, URL: https://www.resultdata.com/qlikview-set-analysis-guide/, (20170822), XP055400170 [Y] 8,16 * the whole document *
ref_type: npl
severity: obviousness
ref_id: - Henric Cronström, "Qlik Design Blog : A Primer on Set Analysis | Qlik Community", (20150217), URL: https://community.qlik.com/blogs/qlikviewdesignblog/2015/02/16/set-analysis, (20170822), XP055400381 [A] 8,16 * the whole document *
ref_type: npl
severity: background
Final disposition: pending (2017-11-01)