IP Library Granted Patent US 12,189,663
Granted Patent B2
US 12,189,663 · App. 17/307,427 · Granted Jan 7, 2025

Systems and methods for visualizing object models of database tables

Inventors: Jeffrey Jon Weir (Seattle, WA); Britta Claire Nielsen (Seattle, WA)
Assignee: Tableau Software, LLC
G06F16/287G06F3/048G06F16/2246G06F16/2308G06F16/248G06F16/289
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,189,663
App. No.
17/307,427
Granted
Jan 7, 2025
Kind
B2
Abstract

A method visualizes object models for data sources. The device displays, in an object model visualization region, a first visualization of a tree of data object icons, each data object icon representing a logical combination of one or more tables. The device also displays recommendations for one or more data sources to add objects to the tree. While displaying the first visualization in the object model visualization region, the device detects a first input on a first data object icon of the tree of data object icons. In response to detecting the first input on the first data object icon, the device displays a second visualization of the tree of the data object icons in a first portion of the object model visualization region and displays a third visualization of information related to the first data object icon in a second portion of the object model visualization region.

Claims (58)

1. A method of visualizing object models for data sources, comprising:

at an electronic device with a display:

displaying, in an object model visualization region, a first visualization of a tree of one or more data object icons, each data object icon representing a logical combination of two or more tables;

displaying, in the object model visualization region, recommendations for one or more data sources to add objects to the tree of one or more data object icons; and

while concurrently displaying the first visualization in the object model visualization region:

detecting, in the object model visualization region, a first input on a first data object icon of the tree of one or more data object icons; and

in response to detecting the first input on the first data object icon:

displaying a second visualization of the tree of the one or more data object icons in a first portion of the object model visualization region; and

displaying a third visualization of information related to the first data object icon in a second portion of the object model visualization region.

2. The method of claim 1 , further comprising displaying, in the object model visualization region, one or more affordances to select filters to add to the first visualization.

3. The method of claim 1 , further comprising, prior to displaying the second visualization and the third visualization, segmenting the object model visualization region into the first portion and the second portion according to (i) a size of the tree of the one or more data object icons, and (ii) a size of the information related to the first data object icon.

4. The method of claim 1 , wherein information related to the first data object icon includes a second tree of one or more data object icons.

5. The method of claim 1 , further comprising, prior to displaying the second visualization and the third visualization:

generating a fourth visualization of information related to the first data object icon; and

displaying the fourth visualization by superimposing the fourth visualization over the first visualization while concurrently shrinking and moving the first visualization to the first portion in the object model visualization region.

6. The method of claim 5 , further comprising, growing and moving the fourth visualization to form the third visualization in the second portion in the object model visualization region.

7. The method of claim 1 , further comprising:

detecting a third input in the second portion of the object model visualization region, away from the second visualization; and

in response to detecting the third input, reverting to displaying the first visualization in the object model visualization region.

8. The method of claim 7 , wherein reverting to displaying the first visualization in the object model visualization region comprises:

ceasing to display the third visualization in the second portion of the object model visualization region; and

growing and moving the second visualization to form the first visualization in the object model visualization region.

9. The method of claim 1 , further comprising:

detecting a second input on a second data object icon; and

in response to detecting the second input on the second data object icon, ceasing to display the third visualization and displaying a fourth visualization of information related to the second data object icon in the second portion of the object model visualization region.

10. The method of claim 9 , further comprising resizing the first portion and the second portion according to (i) a size of the tree of the one or more data object icons, and (ii) a size of the information related to the second data object icon.

11. The method of claim 9 , further comprising moving the second visualization to focus on the second data object icon in the first portion of the object model visualization region.

12. A computer system for visualizing object models for data sources, comprising:

a display;

one or more processors; and

memory;

wherein the memory stores one or more programs configured for execution by the one or more processors, and the one or more programs comprise instructions for:

displaying, in an object model visualization region, a first visualization of a tree of one or more data object icons, each data object icon representing a logical combination of two or more tables;

displaying, in the object model visualization region, recommendations for one or more data sources to add objects to the tree of one or more data object icons; and

while concurrently displaying the first visualization in the object model visualization region:

detecting, in the object model visualization region, a first input on a first data object icon of the tree of one or more data object icons; and

in response to detecting the first input on the first data object icon:

displaying a second visualization of the tree of the one or more data object icons in a first portion of the object model visualization region; and

displaying a third visualization of information related to the first data object icon in a second portion of the object model visualization region.

13. The computer system of claim 12 , wherein the one or more programs further comprise instructions for displaying, in the object model visualization region, one or more affordances to select filters to add to the first visualization.

14. The computer system of claim 12 , wherein the one or more programs further comprise instructions for, prior to displaying the second visualization and the third visualization, segmenting the object model visualization region into the first portion and the second portion according to (i) a size of the tree of the one or more data object icons, and (ii) a size of the information related to the first data object icon.

15. The computer system of claim 12 , wherein the one or more programs further comprise instructions for, prior to displaying the second visualization and the third visualization:

generating a fourth visualization of information related to the first data object icon; and

displaying the fourth visualization by superimposing the fourth visualization over the first visualization while concurrently shrinking and moving the first visualization to the first portion in the object model visualization region.

16. The computer system of claim 15 , wherein the one or more programs further comprise instructions for growing and moving the fourth visualization to form the third visualization in the second portion in the object model visualization region.

17. The computer system of claim 12 , wherein the one or more programs further comprise instructions for:

detecting a second input on a second data object icon; and

in response to detecting the second input on the second data object icon, ceasing to display the third visualization and displaying a fourth visualization of information related to the second data object icon in the second portion of the object model visualization region.

18. The computer system of claim 17 , wherein the one or more programs further comprise instructions for resizing the first portion and the second portion according to (i) a size of the tree of the one or more data object icons, and (ii) a size of the information related to the second data object icon.

19. The computer system of claim 17 , wherein the one or more programs further comprise instructions for moving the second visualization to focus on the second data object icon in the first portion of the object model visualization region.

20. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer system having a display, one or more processors, and memory, the one or more programs comprising instructions for:

displaying, in an object model visualization region, a first visualization of a tree of one or more data object icons, each data object icon representing a logical combination of two or more tables;

displaying, in the object model visualization region, recommendations for one or more data sources to add objects to the tree of one or more data object icons; and

while concurrently displaying the first visualization in the object model visualization region:

detecting, in the object model visualization region, a first input on a first data object icon of the tree of one or more data object icons; and

in response to detecting the first input on the first data object icon:

displaying a second visualization of the tree of the one or more data object icons in a first portion of the object model visualization region; and

displaying a third visualization of information related to the first data object icon in a second portion of the object model visualization region.

Assignments (1)
CHANGE OF NAME Recorded Nov 20, 2024
From: TABLEAU SOFTWARE, INC.
To: TABLEAU SOFTWARE, LLC
Reel/Frame 069405/0245 →
Continuity (2)
Continuation 16679233 · Nov 10, 2019
Related Publication 20210256039A1 · Aug 19, 2021
References Cited (185)
US 5297280A · Potts, Sr. et al. · 1994 [cited by applicant]
US 5511186A · Carhart et al. · 1996 [cited by applicant]
US 5917492A · Bereiter · 1999 [cited by examiner]
US 6189004B1 · Rassen et al. · 2001 [cited by applicant]
US 6199063B1 · Colby et al. · 2001 [cited by applicant]
US 6212524B1 · Weissman et al. · 2001 [cited by applicant]
US 6385604B1 · Bakalash et al. · 2002 [cited by applicant]
US 6397214B1 · Rogers · 2002 [cited by applicant]
US 6492989B1 · Wilkinson · 2002 [cited by applicant]
US 6532471B1 · Ku · 2003 [cited by examiner]
US 6807539B2 · Miller et al. · 2004 [cited by applicant]
US 7023453B2 · Wilkinson · 2006 [cited by applicant]
US 7039650B2 · Adams et al. · 2006 [cited by applicant]
US 7143339B2 · Weinberg et al. · 2006 [cited by applicant]
US 7176924B2 · Wilkinson · 2007 [cited by applicant]
US 7290007B2 · Farber et al. · 2007 [cited by applicant]
US 7302383B2 · Valles et al. · 2007 [cited by applicant]
US 7302447B2 · Dettinger et al. · 2007 [cited by applicant]
US 7337163B1 · Srinivasan et al. · 2008 [cited by applicant]
US 7426520B2 · Gorelik et al. · 2008 [cited by applicant]
US 7603267B2 · Wang et al. · 2009 [cited by applicant]
US 7800613B2 · Hanrahan et al. · 2010 [cited by applicant]
US 7941521B1 · Petrov et al. · 2011 [cited by applicant]
US 8082243B2 · Gorelik et al. · 2011 [cited by applicant]
US 8442999B2 · Gorelik et al. · 2013 [cited by applicant]
US 8874613B2 · Gorelik et al. · 2014 [cited by applicant]
US 9165029B2 · Bhoovaraghavan et al. · 2015 [cited by applicant]
US 9336253B2 · Gorelik et al. · 2016 [cited by applicant]
US 9411797B2 · Campbell et al. · 2016 [cited by applicant]
US 9430469B2 · Lam et al. · 2016 [cited by applicant]
US 9501585B1 · Gautam et al. · 2016 [cited by applicant]
US 9563674B2 · Hou et al. · 2017 [cited by applicant]
US 9613086B1 · Sherman · 2017 [cited by applicant]
US 9710527B1 · Sherman · 2017 [cited by applicant]
US 9779150B1 · Sherman et al. · 2017 [cited by applicant]
US 9818211B1 · Gibb et al. · 2017 [cited by applicant]
US 9858292B1 · Setlur et al. · 2018 [cited by applicant]
US 9886460B2 · Cushing et al. · 2018 [cited by applicant]
US 10418032B1 · Mohajer et al. · 2019 [cited by applicant]
US 10515121B1 · Setlur et al. · 2019 [cited by applicant]
US 10546001B1 · Nguyen et al. · 2020 [cited by applicant]
US 10546003B2 · Gupta et al. · 2020 [cited by applicant]
US 10997217B1 · Nielsen · 2021 [cited by examiner]
US 11360991B1 · Morton · 2022 [cited by examiner]
US 11429264B1 · Weir · 2022 [cited by examiner]
US 11475052B1 · Nielsen · 2022 [cited by examiner]
US 20010054034A1 · Arning et al. · 2001 [cited by applicant]
US 20020055939A1 · Nardone et al. · 2002 [cited by applicant]
US 20020059267A1 · Shah et al. · 2002 [cited by applicant]
US 20030004959A1 · Kotsis et al. · 2003 [cited by applicant]
US 20030023608A1 · Egilsson et al. · 2003 [cited by applicant]
US 20040103088A1 · Cragun et al. · 2004 [cited by applicant]
US 20040122844A1 · Malloy et al. · 2004 [cited by applicant]
US 20040139061A1 · Colossi et al. · 2004 [cited by applicant]
US 20040243593A1 · Stolte et al. · 2004 [cited by applicant]
US 20050038767A1 · Verschell et al. · 2005 [cited by applicant]
US 20050060300A1 · Stolte et al. · 2005 [cited by applicant]
US 20050076045A1 · Stenslet et al. · 2005 [cited by applicant]
US 20050114368A1 · Gould et al. · 2005 [cited by applicant]
US 20050182703A1 · D'hers et al. · 2005 [cited by applicant]
US 20060004746A1 · Angus et al. · 2006 [cited by applicant]
US 20060010143A1 · Netz et al. · 2006 [cited by applicant]
US 20060149768A1 · McCormack et al. · 2006 [cited by applicant]
US 20060167924A1 · Bradlee et al. · 2006 [cited by applicant]
US 20060173813A1 · Zorola · 2006 [cited by applicant]
US 20060206512A1 · Hanrahan et al. · 2006 [cited by applicant]
US 20060294081A1 · Dettinger et al. · 2006 [cited by applicant]
US 20060294129A1 · Stanfill et al. · 2006 [cited by applicant]
US 20070006139A1 · Rubin et al. · 2007 [cited by applicant]
US 20070129936A1 · Wang et al. · 2007 [cited by applicant]
US 20070156734A1 · Dipper et al. · 2007 [cited by applicant]
US 20070255685A1 · Boult · 2007 [cited by examiner]
US 20080016026A1 · Farber et al. · 2008 [cited by applicant]
US 20080027957A1 · Bruckner et al. · 2008 [cited by applicant]
US 20080027970A1 · Zhuge et al. · 2008 [cited by applicant]
US 20090006370A1 · Li et al. · 2009 [cited by applicant]
US 20090313576A1 · Neumann et al. · 2009 [cited by applicant]
US 20090319548A1 · Brown et al. · 2009 [cited by applicant]
US 20100005054A1 · Smith et al. · 2010 [cited by applicant]
US 20100005114A1 · Dipper · 2010 [cited by applicant]
US 20100036800A1 · Gui et al. · 2010 [cited by applicant]
US 20100077340A1 · French et al. · 2010 [cited by applicant]
US 20110119047A1 · Ylonen et al. · 2011 [cited by applicant]
US 20110131250A1 · Stolte et al. · 2011 [cited by applicant]
US 20120116850A1 · Abe et al. · 2012 [cited by applicant]
US 20120117453A1 · Mackinlay et al. · 2012 [cited by applicant]
US 20120191698A1 · Albrecht et al. · 2012 [cited by applicant]
US 20120284670A1 · Kashik et al. · 2012 [cited by applicant]
US 20120323948A1 · Li et al. · 2012 [cited by applicant]
US 20130080584A1 · Benson · 2013 [cited by applicant]
US 20130159307A1 · Wolge et al. · 2013 [cited by applicant]
US 20130166498A1 · Aski et al. · 2013 [cited by applicant]
US 20130191418A1 · Martin, Jr. et al. · 2013 [cited by applicant]
US 20130249917A1 · Fanning et al. · 2013 [cited by applicant]
US 20140181151A1 · Mazoue et al. · 2014 [cited by applicant]
US 20140189553A1 · Bleizeffer et al. · 2014 [cited by applicant]
US 20150261728A1 · Davis et al. · 2015 [cited by applicant]
US 20150278371A1 · Anand et al. · 2015 [cited by applicant]
US 20160092090A1 · Stojanovic et al. · 2016 [cited by applicant]
US 20160092530A1 · Jakubiak et al. · 2016 [cited by applicant]
US 20160092601A1 · Lamas et al. · 2016 [cited by applicant]
US 20170091277A1 · Zoch · 2017 [cited by applicant]
US 20170132277A1 · Hsiao et al. · 2017 [cited by applicant]
US 20170357693A1 · Kumar et al. · 2017 [cited by applicant]
US 20180024981A1 · Xia et al. · 2018 [cited by applicant]
US 20180032576A1 · Romero · 2018 [cited by applicant]
US 20180039614A1 · Govindarajulu et al. · 2018 [cited by applicant]
US 20180129513A1 · Gloystein et al. · 2018 [cited by applicant]
US 20180158245A1 · Govindan · 2018 [cited by applicant]
US 20180203924A1 · Agrawal et al. · 2018 [cited by applicant]
US 20180210883A1 · Ang et al. · 2018 [cited by applicant]
US 20180329987A1 · Tata et al. · 2018 [cited by applicant]
US 20180336223A1 · Kapoor et al. · 2018 [cited by applicant]
US 20190065565A1 · Stolte et al. · 2019 [cited by applicant]
US 20190108272A1 · Talbot et al. · 2019 [cited by applicant]
US 20190121801A1 · Jethwa et al. · 2019 [cited by applicant]
US 20190138648A1 · Gupta et al. · 2019 [cited by applicant]
US 20190197605A1 · Sadler et al. · 2019 [cited by applicant]
US 20190236144A1 · Hou et al. · 2019 [cited by applicant]
US 20190384815A1 · Patel et al. · 2019 [cited by applicant]
US 20200065385A1 · Dreher et al. · 2020 [cited by applicant]
US 20200073876A1 · Lopez et al. · 2020 [cited by applicant]
US 20200089700A1 · Ericson et al. · 2020 [cited by applicant]
US 20200089760A1 · Ericson et al. · 2020 [cited by applicant]
US 20200110803A1 · Djalali et al. · 2020 [cited by applicant]
US 20200125239A1 · Talbot · 2020 [cited by examiner]
US 20200125559A1 · Talbot et al. · 2020 [cited by applicant]
US 20200134103A1 · Mankovskii · 2020 [cited by applicant]
US 20200233905A1 · Williams et al. · 2020 [cited by applicant]
US 20200401581A1 · Eubank · 2020 [cited by examiner]
US 20210097065A1 · Beers · 2021 [cited by examiner]
US 20210256039A1 · Weir · 2021 [cited by examiner]
Ganapavurapu, “Designing and Implementing a Data Warehouse Using Dimensional Modling,” Thesis Dec. 7, 2014, XP055513055, retrieved from Internet: UEL:https://digitalepository.unm.edu/cgi/viewcontent.cgi?article= 1091&co… [cited by applicant]
Gyldenege, Preinterview First Office Action, U.S. Appl. No. 16/221,413, Jun. 11, 2020, 4 pgs. [cited by applicant]
Gyldenege, First Action Interview Office Action, U.S. Appl. No. 16/221,413, Jul 27, 2020, 4 pgs. [cited by applicant]
Gyldenege, Notice of Allowance, U.S. Appl. No. 16/221,413, Jan. 12, 2021, 12 pgs. [cited by applicant]
Mansmann, “Extending the OLAP Technology to Handle Non-Conventional and Complex Data,” Sep. 29, 2008, XP055513939, retrieve from URL/https://kops.uni-konstanz.de/hadle/123456789/5891, 1 pg. [cited by applicant]
Milligan et al., (Tableau 10 Complete Reference, Copyright © 2018 Packt Publishing Ltd., ISBN 978-1-78995-708-2., Electronic edition excerpts retrived on [Sep. 23, 2020] from https://learning.orelly.com/, 144 pgs., (Yea… [cited by applicant]
“Mondrian 3.0.4 Technical Guide”, 2009 (Year: 2009), 254 pgs. [cited by applicant]
Morton, Office Action, U.S. Appl. No. 14/054,803, Sep. 11, 2015, 22 pgs. [cited by applicant]
Morton, Final Office Action, U.S. Appl. No. 14/054,803, May 11, 2016, 22 pgs. [cited by applicant]
Morton, Notice of Allowance, U.S. Appl. No. 14/054,803, Mar. 1, 2017, 23 pgs. [cited by applicant]
Morton, Preinterview 1st Office Action, U.S. Appl. No. 15/497,130, Sep. 18, 2019, 6 pgs. [cited by applicant]
Morton, First Action Interview Office Action, U.S. Appl. No. 15/497,130, Feb. 19, 2020, 26 pgs. [cited by applicant]
Morton, Final Office Action, U.S. Appl. No. 15/497,130, Aug. 12, 2020, 19 pgs. [cited by applicant]
Morton, Office Action, U.S. Appl. No. 15/497,130, Jan. 8, 2021, 20 pgs. [cited by applicant]
Morton, Office Action, U.S. Appl. No. 15/497,130, Jun. 15, 2021, 35 pgs. [cited by applicant]
Morton, Notice of Allowance, U.S. Appl. No. 15/497,130, Feb. 11, 2022, 11 pgs. [cited by applicant]
Setlur, Preinterview First Office Action, U.S. Appl. No. 16/234,470, Sep. 24, 2020, 6 pgs. [cited by applicant]
Setlur, First Action Interview Office Action, U.S. Appl. No. 16/234,470, Oct. 28, 2020, 4 pgs. [cited by applicant]
Sleeper, Ryan (Practical Tableau, Copyright © 2018 Evolytics and Ryan Sleeper, Published by O'Reilly Media, Inc., ISBN 978-1-491-97731, Electronics edition excerpts retrieved on [Sep. 23, 2020] from https://learning.ore… [cited by applicant]
Song et al., “SAMSTAR,” Data Warehousing and OLAP, ACM, 2 Penn Plaza, Suite 701, New York, NY, Nov. 9, 2007, XP058133701, pp. 9 to 16, 8 p. [cited by applicant]
Tableau Software, Inc., International Search Report and Written Opinion, PCTUS2019056491, Jan. 2, 2020, 11 pgs. [cited by applicant]
Tableau Software, Inc., International Search Report and Written Opinion, PCTUS2018/044878, Oct. 22, 2018, 15 pgs. [cited by applicant]
Tableau Software, Inc., International Preliminary Report on Patentability, PCTUS2018/044878, Apr. 14, 2020, 12 pgs. [cited by applicant]
Tableau All Releases, retrieved on [Oct. 2, 2020] from https://www.tableau.com/products/all-features, 49 pgs. (Year:2020). [cited by applicant]
Talbot, Preinterview First Office Action, U.S. Appl. No. 16/236,611, Oct. 28, 2020, 6 pgs. [cited by applicant]
Talbot, Office Action, U.S. Appl. No. 14/801,750, May 7, 2018, 60 pgs. [cited by applicant]
Talbot, Final Office Action, U.S. Appl. No. 14/801,750, Nov. 28, 2018, 63 pgs. [cited by applicant]
Talbot, Office Action, U.S. Appl. No. 14/801,750, Jun. 24, 2019, 55 pgs. [cited by applicant]
Talbot, Notice of Allowance, U.S. Appl. No. 14/801,750. Dec. 22, 2021, 9 pgs. [cited by applicant]
Talbot, Preinterview First Office Action, U.S. Appl. No. 15/911,026, Jun. 9, 2020, 6 pgs. [cited by applicant]
Talbot, First Action Interview Office Action, U.S. Appl. No. 15/911,026, Jul. 22, 2020, 6 pgs. [cited by applicant]
Talbot, Preinterview First Office Action, U.S. Appl. No. 16/236,612, Oct. 29, 2020, 6 pgs. [cited by applicant]
Talbot, First Action Interview Office Action, U.S. Appl. No. 16/236,611, Dec. 22, 2020, 5 pgs. [cited by applicant]
Talbot, Final Office Action, U.S. Appl. No. 16/236,611, Apr. 27, 2021, 21 pgs. [cited by applicant]
Talbot, Office Action, U.S. Appl. No. 16/236,611, Oct. 4, 2021, 23 pgs. [cited by applicant]
Talbot, Office Action, U.S. Appl. No. 16/675,122, Oct. 8, 2020, 18 pgs. [cited by applicant]
Weir, Office Action, Oct. 1, 2020, 9 pgs. [cited by applicant]
Weir, Notice of Allowance, Jan. 11, 2021, 8 pgs. [cited by applicant]
Borden, Preinterview First Office Action, U.S. Appl. No. 16/905,819, Oct. 28, 2021, 4 pgs. [cited by applicant]
Borden, Notice of Allowance, U.S. Appl. No. 16/905,819, Nov. 24, 2021, 19 pgs. [cited by applicant]
Eubank, Office Action, U.S. Appl. No. 16/579,762, Feb. 19, 2021, 9 pgs. [cited by applicant]
Eubank, Notice of Allowance, U.S. Appl. No. 16/579,762, Aug. 18, 2021, 15 pgs. [cited by applicant]
Eubank, Office Action, U.S. Appl. No. 16/570,969, Jun. 15, 2021, 12 pgs. [cited by applicant]
Eubank, Final Office Action, U.S. Appl. No. 16/570,969, Dec. 1, 2021, 16 pgs. [cited by applicant]
Eubank, Notice of Allowance, U.S. Appl. No. 16/570,969, Dec. 18, 2023, 7 pgs. [cited by applicant]
Morton, Office Action, U.S. Appl. No. 17/840,546, Dec. 22, 2022, 37 pgs. [cited by applicant]
Morton, Final Office Action, U.S. Appl. No. 17/840,546, Aug. 5, 2023, 39 pgs. [cited by applicant]
Talbot, Final Office Action, U.S. Appl. No. 15/911,026, Dec. 16, 2020, 28 pgs. [cited by applicant]
Talbot, Notice of Allowance, U.S. Appl. No. 15/911,026, Nov. 23, 2022, 9 pgs. [cited by applicant]
Talbot, Preinterview First Office Action, U.S. Appl. No. 16/236,612, Apr. 28, 2021, 20 pgs. [cited by applicant]
Talbot, Notice of Allowance, U.S. Appl. No. 16/236,611, Dec. 13, 2023, 8 pgs. [cited by applicant]
Talbot, Office Action, U.S. Appl. No. 16/236,612, Oct. 5, 2021, 22 pgs. [cited by applicant]
Morton, Office Action, U.S. Appl. No. 17/840,546, Jul. 2, 2024, 31 pgs. [cited by applicant]