Polaris: a system for query, analysis, and visualization of multidimensional relational databases
In the last several years, large multidimensional databases have become common in a variety of applications, such as data warehousing and scientific computing. Analysis and exploration tasks place significant demands on the interfaces to these databases. Because of the size of the data sets, dense g...
Gespeichert in:
| Veröffentlicht in: | IEEE transactions on visualization and computer graphics 2002-01, Vol.8 (1), p.52-65 |
|---|---|
| Hauptverfasser: | , , |
| Format: | Artikel |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 65 |
|---|---|
| container_issue | 1 |
| container_start_page | 52 |
| container_title | IEEE transactions on visualization and computer graphics |
| container_volume | 8 |
| creator | Stolte, C. Tang, D. Hanrahan, P. |
| description | In the last several years, large multidimensional databases have become common in a variety of applications, such as data warehousing and scientific computing. Analysis and exploration tasks place significant demands on the interfaces to these databases. Because of the size of the data sets, dense graphical representations are more effective for exploration than spreadsheets and charts. Furthermore, because of the exploratory nature of the analysis, it must be possible for the analysts to change visualizations rapidly as they pursue a cycle involving first hypothesis and then experimentation. In this paper, we present Polaris, an interface for exploring large multidimensional databases that extends the well-known pivot table interface. The novel features of Polaris include an interface for constructing visual specifications of table-based graphical displays and the ability to generate a precise set of relational queries from the visual specifications. The visual specifications can be rapidly and incrementally developed, giving the analyst visual feedback as he constructs complex queries and visualizations. |
| doi_str_mv | 10.1109/2945.981851 |
| format | Article |
| fullrecord | <record><control><sourceid>proquest_RIE</sourceid><recordid>TN_cdi_proquest_miscellaneous_28494254</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>981851</ieee_id><sourcerecordid>28494254</sourcerecordid><originalsourceid>FETCH-LOGICAL-c474t-133b7ec0889ff31c341458dffb63b7242baf58dc296732d62c6c241078baf5a53</originalsourceid><addsrcrecordid>eNqFkTtPwzAUhSMEEqUwsTFZDDBAih83ic2GKl5SJRhgjtzEllw5TfFNkMKvx6GIgQEmH_t8OrrXJ0mOGZ0xRtUVV5DNlGQyYzvJhClgKc1ovhs1LYqU5zzfTw4QV5QyAKkmiX5uvQ4Or4kmOGBnGmLbQN56E4ZLotfaD-hwVDV5d9hr7z5059o1aS1pet-52jVmjfFFexKM_zKjrHWnlxoNHiZ7Vns0R9_nNHm9u32ZP6SLp_vH-c0iraCALmVCLAtTUSmVtYJVAhhksrZ2mUeDA19qG-8VV3kheJ3zKq84xLXkaOhMTJPzbe4mtHF87MrGYWW812vT9lgqWiiQIhORPPuT5BIU8Az-B4tcgFBj4ukvcNX2IX4DllJCRoEJHqGLLVSFFjEYW26Ca3QYSkbLsb5yrK_c1hfpky3tjDE_5Lf5CVlolOU</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>884504132</pqid></control><display><type>article</type><title>Polaris: a system for query, analysis, and visualization of multidimensional relational databases</title><source>IEEE Electronic Library (IEL)</source><creator>Stolte, C. ; Tang, D. ; Hanrahan, P.</creator><creatorcontrib>Stolte, C. ; Tang, D. ; Hanrahan, P.</creatorcontrib><description>In the last several years, large multidimensional databases have become common in a variety of applications, such as data warehousing and scientific computing. Analysis and exploration tasks place significant demands on the interfaces to these databases. Because of the size of the data sets, dense graphical representations are more effective for exploration than spreadsheets and charts. Furthermore, because of the exploratory nature of the analysis, it must be possible for the analysts to change visualizations rapidly as they pursue a cycle involving first hypothesis and then experimentation. In this paper, we present Polaris, an interface for exploring large multidimensional databases that extends the well-known pivot table interface. The novel features of Polaris include an interface for constructing visual specifications of table-based graphical displays and the ability to generate a precise set of relational queries from the visual specifications. The visual specifications can be rapidly and incrementally developed, giving the analyst visual feedback as he constructs complex queries and visualizations.</description><identifier>ISSN: 1077-2626</identifier><identifier>EISSN: 1941-0506</identifier><identifier>DOI: 10.1109/2945.981851</identifier><identifier>CODEN: ITVGEA</identifier><language>eng</language><publisher>New York: IEEE</publisher><subject>Construction specifications ; Data visualization ; Displays ; Exploration ; Feedback ; Graphical representations ; Multidimensional systems ; Online analytical processing ; Polarization ; Query processing ; Relational databases ; Scientific computing ; Spatial databases ; Specifications ; Visual ; Visual databases ; Visualization ; Warehousing</subject><ispartof>IEEE transactions on visualization and computer graphics, 2002-01, Vol.8 (1), p.52-65</ispartof><rights>Copyright The Institute of Electrical and Electronics Engineers, Inc. (IEEE) 2002</rights><lds50>peer_reviewed</lds50><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c474t-133b7ec0889ff31c341458dffb63b7242baf58dc296732d62c6c241078baf5a53</citedby><cites>FETCH-LOGICAL-c474t-133b7ec0889ff31c341458dffb63b7242baf58dc296732d62c6c241078baf5a53</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/981851$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>314,776,780,792,27903,27904,54736</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/981851$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc></links><search><creatorcontrib>Stolte, C.</creatorcontrib><creatorcontrib>Tang, D.</creatorcontrib><creatorcontrib>Hanrahan, P.</creatorcontrib><title>Polaris: a system for query, analysis, and visualization of multidimensional relational databases</title><title>IEEE transactions on visualization and computer graphics</title><addtitle>TVCG</addtitle><description>In the last several years, large multidimensional databases have become common in a variety of applications, such as data warehousing and scientific computing. Analysis and exploration tasks place significant demands on the interfaces to these databases. Because of the size of the data sets, dense graphical representations are more effective for exploration than spreadsheets and charts. Furthermore, because of the exploratory nature of the analysis, it must be possible for the analysts to change visualizations rapidly as they pursue a cycle involving first hypothesis and then experimentation. In this paper, we present Polaris, an interface for exploring large multidimensional databases that extends the well-known pivot table interface. The novel features of Polaris include an interface for constructing visual specifications of table-based graphical displays and the ability to generate a precise set of relational queries from the visual specifications. The visual specifications can be rapidly and incrementally developed, giving the analyst visual feedback as he constructs complex queries and visualizations.</description><subject>Construction specifications</subject><subject>Data visualization</subject><subject>Displays</subject><subject>Exploration</subject><subject>Feedback</subject><subject>Graphical representations</subject><subject>Multidimensional systems</subject><subject>Online analytical processing</subject><subject>Polarization</subject><subject>Query processing</subject><subject>Relational databases</subject><subject>Scientific computing</subject><subject>Spatial databases</subject><subject>Specifications</subject><subject>Visual</subject><subject>Visual databases</subject><subject>Visualization</subject><subject>Warehousing</subject><issn>1077-2626</issn><issn>1941-0506</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2002</creationdate><recordtype>article</recordtype><sourceid>RIE</sourceid><recordid>eNqFkTtPwzAUhSMEEqUwsTFZDDBAih83ic2GKl5SJRhgjtzEllw5TfFNkMKvx6GIgQEmH_t8OrrXJ0mOGZ0xRtUVV5DNlGQyYzvJhClgKc1ovhs1LYqU5zzfTw4QV5QyAKkmiX5uvQ4Or4kmOGBnGmLbQN56E4ZLotfaD-hwVDV5d9hr7z5059o1aS1pet-52jVmjfFFexKM_zKjrHWnlxoNHiZ7Vns0R9_nNHm9u32ZP6SLp_vH-c0iraCALmVCLAtTUSmVtYJVAhhksrZ2mUeDA19qG-8VV3kheJ3zKq84xLXkaOhMTJPzbe4mtHF87MrGYWW812vT9lgqWiiQIhORPPuT5BIU8Az-B4tcgFBj4ukvcNX2IX4DllJCRoEJHqGLLVSFFjEYW26Ca3QYSkbLsb5yrK_c1hfpky3tjDE_5Lf5CVlolOU</recordid><startdate>200201</startdate><enddate>200201</enddate><creator>Stolte, C.</creator><creator>Tang, D.</creator><creator>Hanrahan, P.</creator><general>IEEE</general><general>The Institute of Electrical and Electronics Engineers, Inc. (IEEE)</general><scope>RIA</scope><scope>RIE</scope><scope>AAYXX</scope><scope>CITATION</scope><scope>7SC</scope><scope>7SP</scope><scope>8FD</scope><scope>JQ2</scope><scope>L7M</scope><scope>L~C</scope><scope>L~D</scope><scope>F28</scope><scope>FR3</scope></search><sort><creationdate>200201</creationdate><title>Polaris: a system for query, analysis, and visualization of multidimensional relational databases</title><author>Stolte, C. ; Tang, D. ; Hanrahan, P.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c474t-133b7ec0889ff31c341458dffb63b7242baf58dc296732d62c6c241078baf5a53</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2002</creationdate><topic>Construction specifications</topic><topic>Data visualization</topic><topic>Displays</topic><topic>Exploration</topic><topic>Feedback</topic><topic>Graphical representations</topic><topic>Multidimensional systems</topic><topic>Online analytical processing</topic><topic>Polarization</topic><topic>Query processing</topic><topic>Relational databases</topic><topic>Scientific computing</topic><topic>Spatial databases</topic><topic>Specifications</topic><topic>Visual</topic><topic>Visual databases</topic><topic>Visualization</topic><topic>Warehousing</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Stolte, C.</creatorcontrib><creatorcontrib>Tang, D.</creatorcontrib><creatorcontrib>Hanrahan, P.</creatorcontrib><collection>IEEE All-Society Periodicals Package (ASPP) 1998-Present</collection><collection>IEEE Electronic Library (IEL)</collection><collection>CrossRef</collection><collection>Computer and Information Systems Abstracts</collection><collection>Electronics & Communications Abstracts</collection><collection>Technology Research Database</collection><collection>ProQuest Computer Science Collection</collection><collection>Advanced Technologies Database with Aerospace</collection><collection>Computer and Information Systems Abstracts Academic</collection><collection>Computer and Information Systems Abstracts Professional</collection><collection>ANTE: Abstracts in New Technology & Engineering</collection><collection>Engineering Research Database</collection><jtitle>IEEE transactions on visualization and computer graphics</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Stolte, C.</au><au>Tang, D.</au><au>Hanrahan, P.</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Polaris: a system for query, analysis, and visualization of multidimensional relational databases</atitle><jtitle>IEEE transactions on visualization and computer graphics</jtitle><stitle>TVCG</stitle><date>2002-01</date><risdate>2002</risdate><volume>8</volume><issue>1</issue><spage>52</spage><epage>65</epage><pages>52-65</pages><issn>1077-2626</issn><eissn>1941-0506</eissn><coden>ITVGEA</coden><abstract>In the last several years, large multidimensional databases have become common in a variety of applications, such as data warehousing and scientific computing. Analysis and exploration tasks place significant demands on the interfaces to these databases. Because of the size of the data sets, dense graphical representations are more effective for exploration than spreadsheets and charts. Furthermore, because of the exploratory nature of the analysis, it must be possible for the analysts to change visualizations rapidly as they pursue a cycle involving first hypothesis and then experimentation. In this paper, we present Polaris, an interface for exploring large multidimensional databases that extends the well-known pivot table interface. The novel features of Polaris include an interface for constructing visual specifications of table-based graphical displays and the ability to generate a precise set of relational queries from the visual specifications. The visual specifications can be rapidly and incrementally developed, giving the analyst visual feedback as he constructs complex queries and visualizations.</abstract><cop>New York</cop><pub>IEEE</pub><doi>10.1109/2945.981851</doi><tpages>14</tpages><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | ISSN: 1077-2626 |
| ispartof | IEEE transactions on visualization and computer graphics, 2002-01, Vol.8 (1), p.52-65 |
| issn | 1077-2626 1941-0506 |
| language | eng |
| recordid | cdi_proquest_miscellaneous_28494254 |
| source | IEEE Electronic Library (IEL) |
| subjects | Construction specifications Data visualization Displays Exploration Feedback Graphical representations Multidimensional systems Online analytical processing Polarization Query processing Relational databases Scientific computing Spatial databases Specifications Visual Visual databases Visualization Warehousing |
| title | Polaris: a system for query, analysis, and visualization of multidimensional relational databases |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-26T14%3A09%3A59IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_RIE&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Polaris:%20a%20system%20for%20query,%20analysis,%20and%20visualization%20of%20multidimensional%20relational%20databases&rft.jtitle=IEEE%20transactions%20on%20visualization%20and%20computer%20graphics&rft.au=Stolte,%20C.&rft.date=2002-01&rft.volume=8&rft.issue=1&rft.spage=52&rft.epage=65&rft.pages=52-65&rft.issn=1077-2626&rft.eissn=1941-0506&rft.coden=ITVGEA&rft_id=info:doi/10.1109/2945.981851&rft_dat=%3Cproquest_RIE%3E28494254%3C/proquest_RIE%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=884504132&rft_id=info:pmid/&rft_ieee_id=981851&rfr_iscdi=true |