News Column

"Systems and Methods for Interest-Driven Data Visualization Systems Utilized in Interest-Driven Business Intelligence Systems" in Patent Application...

May 13, 2014



"Systems and Methods for Interest-Driven Data Visualization Systems Utilized in Interest-Driven Business Intelligence Systems" in Patent Application Approval Process

By a News Reporter-Staff News Editor at Information Technology Newsweekly -- A patent application by the inventors Prabu, Prithvi (Sunnyvale, CA); Werther, Benjamin Mark (Burlingame, CA); Beyer, Kevin Scott (San Francisco, CA); Eshleman, John Glenn (Mountain View, CA); Mulholland, James (San Francisco, CA), filed on March 8, 2013, was made available online on May 1, 2014, according to news reporting originating from Washington, D.C., by VerticalNews correspondents.

This patent application is assigned to Platfora, Inc.

The following quote was obtained by the news editors from the background information supplied by the inventors: "The term 'business intelligence' is commonly used to refer to techniques for identifying, processing, and analyzing business data. Business intelligence systems can provide historical, current, and predictive views of business operations. Business data, generated during the course of business operations, including data generated from business processes and the additional data created by employees and customers, may be structured, semi-structured, or unstructured depending on the context and knowledge surrounding the data. In many cases, data generated from business processes is structured, whereas data generated from customer interactions with the business is semi-structured or unstructured. Due to the amount of data generally generated during the course of business operations, business intelligence systems are commonly built on top of and utilize a data warehouse.

"Data warehouses are utilized to store, analyze, and report data; for example, business data. Data warehouses utilize databases to store, analyze, and harness the data in a productive and cost-effective manner. A variety of databases are commonly utilized including a relational database management system (RDBMS), such as the Oracle Database from the Oracle Corporation of Santa Clara, Calif., or a massively parallel processing analytical database, such as Teradata from the Teradata Corporation of Miamisburg, Ohio. Business intelligence (BI) and analytical tools, such as SAS from SAS Institute, Inc. of Cary, N.C., are used to access the data stored in the database and provide an interface for developers to generate reports, manage and mine the stored data, perform statistical analysis, business planning, forecasting, and other business functions. Most reports created using BI tools are created by database administrators, and the underlying database may be tuned for the expected access patterns. A database administrator may index, pre-aggregate or restrict access to specific relations, allow ad-hoc reporting and exploration.

"A snowflake schema is an arrangement of tables in a RDBMS, with a central fact table connected to one or more dimension tables. The dimension tables in a snowflake schema are normalized into multiple related tables--for a complex schema there will be many relationships between the dimension tables, resulting in a schema which looks like a snowflake. A star schema is a specific form of a snowflake schema having a fact table referencing one or more dimension tables. However, in a star schema, the dimensions are normalized into a single table--the fact table is the center and the dimension tables are the 'points' of the star.

"Online transaction processing (OLTP) systems are designed to facilitate and manage transaction-based applications. OTLP may refer to a variety of transactions such a database management system transactions, business, or commercial transactions. OLTP systems typically have low latency response to user requests.

"Online analytical processing (OLAP), a modification of OLTP, is an approach to answering multidimensional analytical queries. OLAP tools enable users to analyze multidimensional data utilizing three basic analytical operations: consolidation (aggregating data), drill-down (navigating details of data), and slice and dice (take specific sets of data and view from multiple viewpoints). The basis for any OLAP system is an OLAP cube. An OLAP cube is a data structure allowing for fast analysis of data with the capability of manipulating and analyzing data from multiple perspectives. OLAP cubes typically are composed of numeric facts, called measures, categorized by dimensions. These facts and measures are commonly created from a star schema or a snowflake schema of tables in a RDBMS."

In addition to the background information obtained for this patent application, VerticalNews journalists also obtained the inventors' summary information for this patent application: "Systems and methods for interest-driven data visualization systems in accordance with embodiments of the invention are illustrated. In one embodiment, an interest-driven data visualization system includes a processor, a memory connected to the processor and configured to store an interest-driven data visualization application, and metadata storage configured to store data description metadata describing raw data, wherein the interest-driven data visualization application configures the processor to define reporting data requirements, where the reporting data requirements include at least one piece of reporting data metadata, generate data retrieval job data based on the at least one piece of reporting data metadata in the reporting data requirements and the data description metadata, transmit the data retrieval job data to an interest-driven business intelligence system, receive aggregate data from the interest-driven business intelligence system, where the interest-driven business intelligence system is configured to process data retrieval job data to generate aggregate data using the raw data, where a portion of the raw data is unstructured data and store aggregate data and the raw data described by the data description metadata stored within the metadata storage device of the interest-driven data visualization system, create at least one piece of reporting data using the received aggregate data, the data description metadata, and the reporting data metadata, associate visualization metadata with the reporting data, where the visualization metadata describes the visual appearance of the at least one piece of reporting data, and generate a report using the at least one piece of reporting data, the reporting data requirements, and the visualization metadata, where the generated report is configured to be displayed using a display device.

"In another embodiment of the invention, the interest-driven data visualization application configures the processor to receive aggregate data metadata from the interest-driven business intelligence system, where the aggregate data metadata includes time estimation data describing the delay associated with generating supplemental aggregate data using the raw data that is generated based on time taken to generate at least a portion of the aggregated data.

"In another embodiment of the invention, the interest-driven data visualization application configures the processor to include display report metadata in the generated report, where the display report metadata configures the report to include an indication of the delay associated with generating the supplemental aggregate data.

"In yet another additional embodiment of the invention, the interest-driven data visualization application configures the processor to generate supplemental data retrieval job data based on the data retrieval job data and the received aggregate data, transmit the supplemental data retrieval job data to the interest-driven business intelligence system, receive supplemental aggregate data from the interest-driven business intelligence system, update at least one piece of the at least one piece of reporting data using the supplemental aggregate data, the data description metadata, and the reporting data metadata, and update the report using the updated reporting data.

"In still another additional embodiment of the invention, the interest-driven data visualization application configures the processor to associate an alert with the supplemental data retrieval job data, where the alert includes an action to be performed and perform the action associated with the alert when the supplemental aggregate data is received.

"In yet still another additional embodiment of the invention, the interest-driven data visualization application configures the processor to capture a visualization snapshot using the generated report, where the visualization snapshot includes a portion of the reporting data, the reporting data requirements, and the display data metadata and store the visualization snapshot within the memory.

"In yet another embodiment of the invention, the interest-driven data visualization application configures the processor to transmit the visualization snapshot to a remote system separate from the interest-driven data visualization system, where the remote system is configured to display the visualization snapshot without communicating with the interest-driven business intelligence system.

"In still another embodiment of the invention, the interest-driven data visualization application configures the processor to determine data description metadata using a second interest-driven business intelligence system, where the second interest-driven business intelligence system is separate from the interest-driven business intelligence system and the data description metadata describes new aggregate data available via the second interest-driven business intelligence system, create replacement reporting data using the data description metadata, determine a mapping between the a portion of the replacement reporting data and the visualization metadata based on the reporting data requirements and the data description metadata, and generate a replacement report using the replacement reporting data and the data description metadata.

"In yet still another embodiment of the invention, the visualization metadata includes a portable visualization.

"In yet another additional embodiment of the invention, the visualization metadata is automatically generated based upon the reporting data and the reporting data requirements.

"Yet another embodiment of the invention includes a method for creating interest-driven data visualizations including defining reporting data requirements using an interest-driven data visualization system, where the reporting data requirements include at least one piece of reporting data metadata, generating data retrieval job data based on the at least one piece of reporting data metadata in the reporting data requirements and the data description metadata using the interest-driven data visualization system, transmitting the data retrieval job data to an interest-driven business intelligence system using the interest-driven data visualization system, receiving aggregate data from the interest-driven business intelligence system using the interest-driven data visualization system, where the interest-driven business intelligence system is configured to process data retrieval job data to generate aggregate data using the raw data, where a portion of the raw data is unstructured data and store aggregate data and the raw data described by the data description metadata stored within the metadata storage device of the interest-driven data visualization system, creating at least one piece of reporting data based on the received aggregate data, the data description metadata, and the reporting data metadata using the interest-driven data visualization system, associating visualization metadata with the reporting data using the interest-driven data visualization system, where the visualization metadata describes the visual appearance of the at least one piece of reporting data, and generating a report based on the at least one piece of reporting data, the reporting data requirements, and the visualization metadata using the interest-driven data visualization system.

"In yet another additional embodiment of the invention, creating interest-driven data visualizations further includes receiving aggregate data metadata from the interest-driven business intelligence system using the interest-driven data visualization system, where the aggregate data metadata includes time estimation data describing the delay associated with generating supplemental aggregate data using the raw data that is generated based on time taken to generate at least a portion of the aggregated data.

"In still another additional embodiment of the invention, creating interest-driven data visualizations further includes displaying report metadata in the generated report using the interest-driven data visualization system, where the display report metadata configures the report to include an indication of the delay associated with generating the supplemental aggregate data.

"In yet still another additional embodiment of the invention, creating interest-driven data visualizations further includes generating supplemental data retrieval job data based on the data retrieval job data and the received aggregate data using the interest-driven data visualization system, transmitting the supplemental data retrieval job data to the interest-driven business intelligence system using the interest-driven data visualization system, receiving supplemental aggregate data from the interest-driven business intelligence system using the interest-driven data visualization system, updating at least one piece of the at least one piece of reporting data based on the supplemental aggregate data, the data description metadata, and the reporting data metadata using the interest-driven data visualization system, and updating the report based on the updated reporting data using the interest-driven data visualization system.

"In yet another embodiment of the invention, creating interest-driven data visualizations further includes associating an alert with the supplemental data retrieval job data using the interest-driven data visualization system, where the alert includes an action to be performed and performing the action associated with the alert using the interest-driven data visualization system when the supplemental aggregate data is received.

"In still another embodiment of the invention, creating interest-driven data visualizations further includes capturing a visualization snapshot based the generated report using the interest-driven data visualization system, where the visualization snapshot includes a portion of the reporting data, the reporting data requirements, and the display data metadata and storing the visualization snapshot using the interest-driven data visualization system.

"In yet still another embodiment of the invention, creating interest-driven data visualizations further includes transmitting the visualization snapshot to a remote system separate from the interest-driven data visualization system using the interest-driven data visualization system, where the remote system is configured to display the visualization snapshot without communicating with the interest-driven business intelligence system.

"In yet another additional embodiment of the invention, creating interest-driven data visualizations further includes determining data description metadata using a second interest-driven business intelligence system and the interest-driven data visualization system, where the second interest-driven business intelligence system is separate from the interest-driven business intelligence system and the data description metadata describes new aggregate data available via the second interest-driven business intelligence system, creating replacement reporting data based on the data description metadata using the interest-driven data visualization system, determining a mapping between the a portion of the replacement reporting data and the visualization metadata based on the reporting data requirements and the data description metadata using the interest-driven data visualization system, and generating a replacement report based on the replacement reporting data and the data description metadata using the interest-driven data visualization system.

"In still another additional embodiment of the invention, the visualization metadata includes a portable visualization.

"In yet still another additional embodiment of the invention, the visualization metadata is automatically generated based upon the reporting data and the reporting data requirements using the interest-driven data visualization system.

BRIEF DESCRIPTION OF THE DRAWINGS

"FIG. 1 is a network diagram of a business intelligence system including interest-driven data visualization systems in accordance with an embodiment of the invention.

"FIG. 2 is a conceptual illustration of an interest-driven data visualization system in accordance with an embodiment of the invention.

"FIG. 3 is an illustration of the visual appearance of an interest-driven data visualization system in accordance with an embodiment of the invention.

"FIG. 4 is a flow chart illustrating a process for the interest-driven visualization of data in accordance with an embodiment of the invention.

"FIG. 5 is a flow chart illustrating a process for creating a visualization using an interest-driven data visualization system in accordance with an embodiment of the invention.

"FIG. 6 is a flow chart illustrating a process for estimating time requirements for analyst-generated actions using an interest-driven data visualization system in accordance with an embodiment of the invention.

"FIG. 7 is a flow chart illustrating a process for data exploration using an interest-driven data visualization system in accordance with an embodiment of the invention.

"FIG. 8 is a flow chart illustrating a process for creating visualization snapshots using an interest-driven data visualization system in accordance with an embodiment of the invention."

URL and more information on this patent application, see: Prabu, Prithvi; Werther, Benjamin Mark; Beyer, Kevin Scott; Eshleman, John Glenn; Mulholland, James. Systems and Methods for Interest-Driven Data Visualization Systems Utilized in Interest-Driven Business Intelligence Systems. Filed March 8, 2013 and posted May 1, 2014. Patent URL: http://appft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.html&r=774&p=16&f=G&l=50&d=PG01&S1=20140424.PD.&OS=PD/20140424&RS=PD/20140424

Keywords for this news article include: Platfora Inc, Information Technology, Information and Data Modeling, Information and Data Retrieval, Information and Data Management, Information and Data Aggregation.

Our reports deliver fact-based news of research and discoveries from around the world. Copyright 2014, NewsRx LLC


For more stories covering the world of technology, please see HispanicBusiness' Tech Channel



Source: Information Technology Newsweekly


Story Tools






HispanicBusiness.com Facebook Linkedin Twitter RSS Feed Email Alerts & Newsletters