Patent Application
20140114971
The present invention relates to business intelligence systems, specifically the sharing of data generated using interest-driven business intelligence systems.
Business intelligence refers 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, such as 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.
Systems and methods for interest-driven data sharing in interest-driven business intelligence systems in accordance with embodiments of the invention are illustrated. In one embodiment, an interest-driven data sharing server system includes a processor, a memory connected to the processor and configured to store an interest-driven data sharing application, raw data storage configured to store raw data, where a portion of the raw data includes unstructured data, metadata storage configured to store data description metadata describing the raw data, and report storage configured to store previously generated reports including previous reporting data and previous reporting data requirements, wherein the interest-driven data sharing application configures the processor to receive a report specification, where the report specification includes at least one reporting data requirement, locate at least one previously generated report stored in the report storage using the previously reporting data requirements and the at least one reporting data requirement, identify raw data stored in the raw data storage using the data description metadata and at least one of the reporting data requirements, calculate redundant data metadata using the located previously generated reports and the identified raw data, where the redundant data metadata identifies data common to the identified raw data and the previous reporting data in the located previously generated reports, determine modified reporting data requirements, where the modified reporting data requirements exclude the common data identified by the redundant data metadata, retrieve updated source data from the raw data storage using the modified reporting data requirements, and generate reporting data based on the updated source data and the previous reporting data contained in at least one of the at least one previously generated reports.
In another embodiment of the invention, the interest-driven data sharing application configures the processor to generate the reporting data utilizing an interest-driven data pipeline, where the interest-driven data pipeline is configured to aggregate the updated data and the previous reporting data based on the report specification.
In an additional embodiment of the invention, the raw data storage is separate and remote from the interest-driven data sharing server system and the interest-driven data sharing application configures the processor to generate a data source job configured to retrieve updated source data from the raw data storage.
In yet another additional embodiment of the invention, the data source job configures the raw data storage to generate aggregate data based on raw data, where a portion of the raw data includes unstructured data.
In still another additional embodiment of the invention, the interest-driven data sharing server system further includes a data dimension directory, where the data dimension directory includes a plurality of data dimensions associated with the previously generated reports, wherein the at least one reporting data requirement includes at least one reporting data dimension, and wherein the interest-driven data sharing application configures the processor to calculate redundant metadata based on the data dimension directory and the at least one reporting data requirement.
In yet still another additional embodiment of the invention, the interest-driven data sharing application configures the processor to update the data dimension directory based on the generated reporting data.
In yet another embodiment of the invention, the interest-driven data sharing application configures the processor to retrieve updated source data from the raw data storage using the modified reporting data requirements, where the updated source data fulfills a portion of the modified reporting data requirement, generate partial reporting data based on the updated source data and the previous reporting data contained in at least one of the at least one previously generated reports, retrieve supplemental source data from the raw data storage, where the supplemental source data fulfills the remaining portion of the modified reporting data requirement, and generate reporting data using the partial reporting data and the supplemental source data.
In still another embodiment of the invention, the interest-driven data sharing server system includes aggregate data storage configured to store aggregate data, wherein the updated source data includes aggregate data, and wherein the interest-driven data sharing application configures the processor to store the updated source data using the aggregate data storage.
In yet still another embodiment of the invention, at least one of the at least one reporting data requirement includes data source metadata identifying at least one data source, where the at least one data source is configured to store raw data and the interest-driven data sharing application configures the processor to retrieve updated source data from the at least one data source.
In yet another additional embodiment of the invention, the report data storage is separate from the interest-driven data sharing server system and the interest-driven data sharing application configures the processor to generate data mapping metadata, where the data mapping metadata identifies correspondences between the previous reporting data requirements and the received report specification using the data description metadata, calculate redundant data metadata using the located previously generated reports and the identified raw data based on the data mapping metadata, and generate reporting data based on the updated source data and the previous reporting data contained in at least one of the at least one previously generated reports based on the data mapping metadata.
Still another embodiment of the invention includes a method for interest-driven data sharing, including receiving a report specification using an interest-driven data sharing server system, where the report specification includes at least one reporting data requirement, locating at least one previously generated report stored in the report storage based on the previously reporting data requirements and the at least one reporting data requirement using the interest-driven data sharing server system, identifying raw data stored in the raw data storage based on the data description metadata and at least one of the reporting data requirements using the interest-driven data sharing server system, calculating redundant data metadata based on the located previously generated reports and the identified raw data using the interest-driven data sharing server system, where the redundant data metadata identifies data common to the identified raw data and the previous reporting data in the located previously generated reports, determining modified reporting data requirements using the interest-driven data sharing server system, where the modified reporting data requirements exclude the common data identified by the redundant data metadata, retrieving updated source data based on the modified reporting data requirements using the interest-driven data sharing server system, and generating reporting data based on the updated source data and the previous reporting data contained in at least one of the at least one previously generated reports using the interest-driven data sharing server system.
In yet another additional embodiment of the invention, interest-driven data sharing further includes generating the reporting data utilizing an interest-driven data pipeline within the interest-driven data sharing server system, where the interest-driven data pipeline is configured to aggregate the updated data and the previous reporting data based on the report specification.
In still another additional embodiment of the invention, interest-driven data sharing further includes configuring the interest-driven data pipeline to generate a data source job configured to retrieve updated source data from a raw data storage system separate and remote from the interest-driven data sharing server system using the interest-driven data sharing server system.
In yet still another additional embodiment of the invention, the data source job configures the raw data storage to generate aggregate data based on raw data, where a portion of the raw data includes unstructured data.
In yet another embodiment of the invention, interest-driven data sharing further includes calculating redundant metadata based on the data dimension directory and the at least one reporting data requirement using the interest-driven data sharing server system, where the data dimension directory, where the data dimension directory includes a plurality of data dimensions associated with the previously generated reports and the at least one reporting data requirement includes at least one reporting data dimension.
In still another embodiment of the invention, interest-driven data sharing further includes updating the data dimension directory based on the generated reporting data using the interest-driven data sharing server system.
In yet still another embodiment of the invention, interest-driven data sharing further includes retrieving updated source data based on the modified reporting data requirements using the interest-driven data sharing server system, where the updated source data fulfills a portion of the modified reporting data requirement, generating partial reporting data based on the updated source data and the previous reporting data contained in at least one of the at least one previously generated reports using the interest-driven data sharing server system, retrieving supplemental source data using the interest-driven data sharing server system, where the supplemental source data fulfills the remaining portion of the modified reporting data requirement, and generating reporting data based on the partial reporting data and the supplemental source data using the interest-driven data sharing server system.
In yet another additional embodiment of the invention, interest-driven data sharing further includes storing the updated source data using the interest-driven data sharing server system.
In still another additional embodiment of the invention, interest-driven data sharing further includes retrieving updated source data from at least one data source using the interest-driven data sharing server system, where at least one of the at least one reporting data requirement includes data source metadata identifying the at least one data source configured to store raw data.
In yet still another additional embodiment of the invention, interest-driven data sharing further includes generating data mapping metadata using the interest-driven data sharing server system, where the data mapping metadata identifies correspondences between the previous reporting data requirements and the received report specification using the data description metadata, calculating redundant data metadata based on the located previously generated reports, the identified raw data, and the data mapping metadata using the interest-driven data sharing server system, and generating reporting data based on the updated source data, the previous reporting data contained in at least one of the at least one previously generated reports, and the data mapping metadata using the interest-driven data sharing server system.
Turning now to the drawings, interest-driven data sharing server systems in accordance with embodiments of the invention are illustrated. Interest-driven data sharing server systems enable analysts using a variety of systems, including, but not limited to, interest-driven business intelligence systems, to create reporting data using raw data retrieved from interest-driven business intelligence systems and, at the same time, to dynamically create new reporting data by efficiently re-using and updating data previously retrieved from the interest-driven business intelligence system. Interest-driven data sharing server systems are configured to dynamically build an interest-driven data pipeline to provide analysts with information of interest. Interest-driven data sharing server systems are capable of managing huge datasets in a way that provides an analyst with complete visibility into the available data utilizing metadata provided by an interest-driven business intelligence system and the ability to dynamically reconfigure the interest-driven data sharing server system to provide access to desired information stored in the interest-driven business intelligence system. In order to achieve highly interactive performance, an interest-driven data sharing server system dynamically compiles an interest-driven data pipeline to create reporting data based on the reporting data requirements and reporting data currently present in the interest-driven data sharing server system. Changes specified at the report level can be automatically compiled and traced backward by the interest-driven data sharing server system to create an appropriate interest-driven data pipeline to meet the new report requirements. Interest-driven data sharing server systems further build metadata concerning the data available in the interest-driven business intelligence system and provide the metadata to interest-driven data visualization systems to enable the construction of reports using the metadata. Available data in an interest-driven business intelligence system includes, but is not limited to, raw data, aggregate data, filtered data, and reporting data. Interest-driven business intelligence systems that can be utilized in accordance with embodiments of the invention are discussed further in U.S. patent application Ser. No. 13/408,872 to Eshleman et al., titled “Interest-Driven Business Intelligence Systems and Methods of Data Analysis Using Interest-Driven Data Pipelines” and filed Feb. 29, 2012, the entirety of which is incorporated herein by reference.
In many embodiments, reports can be created using interest-driven data visualization systems configured to request and receive data from an interest-driven data sharing server system. In order for an interest-driven data visualization system to build reports, a set of reporting data requirements are defined. These requirements specify the reporting data, derived from raw data that will be utilized to generate the reports. The raw data can be structured, semi-structured, or unstructured. In a variety of embodiments, structured and semi-structured data include metadata, such as an index or other relationships, describing the data; unstructured data lacks any definitional structure. An interest-driven data sharing server system can utilize reporting data already created by the interest-driven data sharing server system and/or cause new and/or updated reporting data to be generated by the interest-driven data sharing server system to satisfy the reporting data requirements. In a variety of embodiments, reporting data requirements are received from interest-driven data visualization systems based upon reporting requirements defined by analysts exploring metadata describing raw data stored in an interest-driven business intelligence system. Systems and methods for interest-driven data visualizations systems which may be utilized in accordance with a number of embodiments are described in U.S. Provisional Patent Application No. 61/717,092 to Prabhu et al., titled “Systems and Methods for Interest-Driven Data Visualization Systems Utilized in Interest-Driven Business Intelligence Systems” and filed Oct. 22, 2012, the entirety of which is incorporated by reference.
In many embodiments, interest-driven data sharing server systems are configured to determine redundant data between currently existing reporting data and/or source data and the requested reporting data and to generate interest-driven business intelligence data job requests that reduce the amount of redundant reporting data generated. In this way, the computing time involved in generating reporting data satisfying a set of reporting data requirements can be reduced by reusing reporting data and/or source data that has already been derived from the raw data and that is stored within the interest-driven data sharing server system. Similar reporting data is frequently utilized in a variety of reporting data generated using raw data, aggregate data, filtered data, and or metadata describing raw data available from an interest-driven business intelligence system. In several embodiments, interest-driven data sharing server systems are configured to provide the sharing of reporting data between reports created by different users of interest-driven business intelligence systems and/or interest-driven data visualization systems. In several embodiments, interest-driven data sharing server systems are configured to identify a request for reporting data utilized in a previous report and provide an isolated snapshot of that reporting data, where the isolated snapshot of the reporting data contains updated reporting data corresponding to the data present in the previous reporting data. In many embodiments, interest-driven data sharing server systems are configured to identify when the data necessary to fulfill reporting data requirements is already present on the interest-driven data sharing server system in the form of reporting data and/or source data. The interest-driven data sharing server system is configured to generate jobs to perform any necessary aggregation and/or filtering of the existing reporting data and/or existing source data to create new reporting data fulfilling the reporting data requirements.
In a variety of embodiments, reporting data can be shared between business intelligence systems. In many embodiments, the business intelligence systems sharing the reporting data contain sources of similar raw data, aggregate data, and/or filtered data. Determining if interest-driven business intelligence systems can be performed in a variety of ways in accordance with many embodiments of the invention, including, but not limited to, comparing metadata describing the raw data available in each of the interest-driven business intelligence systems using an interest-driven data sharing server system. The reporting data can be shared in many ways, including sharing one or more reporting data schemas describing the reporting data and sharing the reporting data itself. A number of sharing techniques not listed above may be utilized in accordance with the requirements of particular embodiments of the invention. In several embodiments, the shared reporting data and/or shared reporting data schema is created using an interest-driven data sharing server system using source data generated using one of the interest-driven business intelligence systems. In many embodiments, the shared reporting data is pre-built reporting data and/or a pre-built reporting data schema is shared.
Interest-driven data sharing server systems are configured to provide reporting data based upon one or more reporting data requirements. Reporting data provided by interest-driven data sharing server systems includes raw data, aggregate data, and/or filtered data loaded from raw data storage received from the business intelligence systems that has been processed and loaded into a data structure to provide rapid access to the data. In a number of embodiments, this raw data, aggregate data, and/or filtered data is provided to interest-driven data sharing server systems as source data. In many embodiments, the source data is described by metadata describing the raw data, aggregate data, and/or filtered data present in the interest-driven business intelligence system and/or source data metadata describing the source data. In several embodiments, the source data, aggregate data, and/or reporting data is stored in a data mart or other aggregate data storage associated with the interest-driven data sharing server system and/or the internet-driven business intelligence system. Interest-driven data sharing server systems can load source data into a variety of reporting data structures in accordance with a number of embodiments, including, but not limited to, online analytical processing (OLAP) cubes. In a variety of embodiments, the reporting data structures are defined using a reporting data schema. In a number of embodiments, interest-driven data sharing server systems are configured to combine requests for one or more OLAP cubes into a single request, thereby reducing the time, storage, and/or processing power utilized by the interest-driven business intelligence system in creating source data utilized to create reporting data schemas and/or the reporting data.
Systems and methods for interest-driven data sharing server systems in accordance with embodiments of the invention are discussed further below.
An interest-driven business intelligence system including an interest-driven data sharing server system in accordance with an embodiment of the invention is illustrated in
Interest-driven data visualization systems enable users to specify reports including data visualizations that enable the user to explore the raw data stored within the distributed computing platform 110 using reporting data generated by the interest-driven data sharing server system 112. Reporting data is provided in a variety of forms, including, but not limited to, snowflake schemas and star schemas. In many embodiments, reporting data is any data that includes fields of data populated using raw data stored within the distributed computing platform 110. The interest-driven data sharing server system 112 is configured to communicate via the network 114 with one or more interest-driven data visualization systems, including, but not limited to, cellular telephones 116, personal computers 118, and presentation devices 120. In many embodiments of the invention, interest-driven data visualization systems include any computing device capable of receiving and/or displaying data.
Based upon received reporting data requirements, the interest-driven data sharing server system 112 automatically compiles one or more interest-driven data pipelines to create or update reporting data to satisfy the received reporting data requirements. The interest-driven data sharing server system is configured to compile one or more interest-driven data pipelines configured to create and push down jobs to the distributed computing platform 110 to create source data and then applying various filter and/or aggregation processes to the source data to produce reporting data to be transmitted to interest-driven data visualization systems. In many embodiments, the interest-driven data sharing server system 112 includes reporting data that partially or fully satisfies the reporting data requirements. The interest-driven data sharing server system 112 is configured to identify the relevant existing reporting data and/or previously received source data and configure an interest-driven data pipeline to create jobs requesting reporting data minimizing the redundancy between the existing data and the new reporting data requirements. In a variety of embodiments, the interest-driven data sharing server system 112 is configured to determine redundancies between the requested data and existing data using metadata describing the data available from an interest-driven business intelligence system. The metadata describes what raw data is available from the interest-driven business intelligence system. In a number of embodiments, the metadata further describes what form the raw data is available in, such as, but not limited to, aggregate data, filtered data, source data, and reporting data. In several embodiments, the interest-driven data sharing server system 112 receives a plurality of reporting data requirements and the interest-driven data sharing server system 112 is configured to create jobs using the interest-driven data pipeline to create source data containing data fulfilling the union of the plurality of reporting data requirements. In a variety of embodiments, the interest-driven data sharing server system 112 is configured to identify redundant data requirements in one or more reporting data requirements and configure an interest-driven data pipeline to create jobs requesting source data fulfilling the redundant data requirements. In several embodiments, the interest-driven data sharing server system 112 is configured to store aggregate data and/or reporting data in a data mart and utilized the stored aggregate data and/or reporting data to identify the redundant data requirements. In a number of embodiments, the interest-driven data sharing server system 112 is configured to identify when reporting data requirements request updated data for existing reporting data and/or source data and configure an interest-driven data pipeline to create jobs to retrieve an updated snapshot of the existing reporting data from the distributed computing platform 110. In a variety of embodiments, redundant information is identified using reporting data schemas defining the structure of reporting data and/or source data schemas defining the structure of source data. In many embodiments, redundant information is determined using one or more files stored using the interest-driven data sharing server system; redundancies can be determined using the data contained in the files and/or metadata associated with the files, including the creation date of the files and/or the last modified date of the files.
In several embodiments, jobs pushed down to the distributed computing platform 110 by the interest-driven data sharing server system 112 cannot be executed in a low-latency fashion. In many embodiments, the distributed computing platform 110 is configured to provide a partial set of source data fulfilling the pushed down job and the interest-driven data sharing server system 112 is configured to create reporting data using the partial set of source data. As more source data is provided by the distributed computing platform 110, the interest-driven data sharing server system 112 is configured to update the created reporting data based upon the received source data. In a number of embodiments, the interest-driven data sharing server system will continue to update the reporting data until a termination condition is reached. These termination conditions can include, but are not limited to, a certain volume of source data is received, the source data provided is no longer within a particular time frame, and an amount of time to provide the source data has elapsed. In a number of embodiments, a time frame and/or the amount of time to provide the source data is determined based upon the time previously measured in the retrieval of source data for similar reporting data requirements.
The interest-driven data sharing server system 112 is configured to compile an interest-driven data pipeline to create jobs to be pushed down to the distributed computing platform 110 in order to retrieve data. In a variety of embodiments, the jobs created using the interest-driven data pipeline are tailored to the reporting data requirements. In many embodiments, the jobs created using the interest-driven data pipeline are customized to the hardware resources available on the distributed computing platform 110. In a number of embodiments, the jobs are configured to dynamically reallocate the resources available on the distributed computing platform 110 in order to best execute the jobs. In several embodiments, the jobs are created using performance metrics collected based upon the performance of previously executed jobs.
Raw data storage is utilized to store raw data, metadata storage is utilized to store data description metadata describing the raw data, and/or report storage is utilized to store previously generated reports including previous reporting data and previous reporting data requirements in a variety of embodiments of the invention. Raw data storage, metadata storage, and/or report storage can be a portion of the memory associated with the interest-driven data sharing server system 112, the distributed computing platform 110, and/or a separate device in accordance with the specific requirements of specific embodiments of the invention.
Although a specific architecture for an interest-driven business intelligence system with an interest-driven data sharing server system in accordance with an embodiment of the invention is conceptually illustrated in
Interest-driven data sharing server systems in accordance with embodiments of the invention are configured to create jobs to request source data from interest-driven business intelligence systems based upon received reporting data requirements and to create reporting data using the received source data. In many embodiments, the interest-driven data sharing server systems are further configured to determine redundancies between previously received source data and generated reporting data and create jobs that efficiently request additional source data from interest-driven business intelligence systems to reduce requests for redundant data. An interest-driven data sharing server system in accordance with an embodiment of the invention is conceptually illustrated in
In several embodiments, non-volatile memory is any form of non-volatile storage configured to store a variety of data, including, but not limited to, reporting data 234 and source data 236. In the illustrated embodiment, the non-volatile memory 230 is also configured to store an interest-driven data sharing application 232 that configures the processor 210 to perform an interest-driven data sharing processes. In many embodiments, interest-driven data sharing processes include efficiently creating jobs using an interest-driven data pipeline to retrieve source data from an interest-driven business intelligence system based upon redundancies between reporting data requirements and existing reporting data schemas 234 and/or source data schemas 236. In a variety of embodiments, interest-driven data sharing processes include iteratively updating reporting data based upon incrementally received source data. In several embodiments, interest-driven data sharing processes include creating jobs using an interest-driven data pipeline to retrieve updates to existing reporting data 234 and/or source data 236 from an interest-driven business intelligence system based upon the content of the existing reporting data schemas 234, source data schemas 236, and/or metadata describing data available from an interest-driven business intelligence system. A number of interest-driven data sharing processes not specifically described above may be utilized in accordance with the requirements of specific applications in accordance with embodiments of the invention. The non-volatile memory 230 further includes aggregate data storage 238 configured to store data received by the interest-driven data sharing server system 200, including, but not limited to, aggregate data, source data, and reporting data. In a variety of embodiments, the aggregate data storage 238 is configured as a data mart.
In many embodiments, reporting data schemas 234, source data schemas 236, and/or the interest-driven data sharing application 232 are stored using an external server system and received by the interest-driven data sharing server system 200 using a network interface 240. External server systems in accordance with a variety of embodiments include, but are not limited to, interest-driven business intelligence systems, distributed computing platforms, and interest-driven data sharing server systems. In several embodiments, the processor 210 is configured to transmit jobs using the network interface 240.
Although a specific architecture for an interest-driven data sharing server system in accordance with an embodiment of the invention is conceptually illustrated in
Interest-Driven Data Sharing with Redundancies
In a variety of embodiments, interest-driven data sharing server systems are configured to determine redundancies between requested reporting data and data currently existing in the interest-driven data sharing server system and create jobs to request only new data. A process for interest-driven data sharing with redundant data in accordance with an embodiment of the invention is illustrated in
In many embodiments, reporting data requirements are received (310) from an interest-driven data visualization system. In several embodiments, the received (310) reporting data requirements are based upon metadata describing raw data stored in an interest-driven business intelligence system. In a number of embodiments, the reporting data schema is determined (312) using the received (310) reporting data requirements. In a variety of embodiments, reporting data schemas may be defined (312) in a number of formats including, but not limited to, star schemas and snowflake schemas. In several embodiments, calculating (314) redundancies includes comparing the determined (312) reporting data schema against reporting data schemas and/or source data schemas present in an interest-driven data sharing server system. In a number of embodiments, calculating (314) redundancies includes building a dictionary of dimensions contained in schemas defining existing reporting data and/or source data and comparing the dictionary of dimensions against the determined (312) reporting data schema. In many embodiments, a dimension directory includes a listing of dimensions in reporting data and/or source data stored in a data mart associated with an interest-driven business intelligence system and/or interest-driven data sharing server system. In a variety of embodiments, the dimension directory includes dimension directory metadata describing the location of the dimensions within the file system of the interest-driven business intelligence system and/or the interest-driven data sharing server system. In several embodiments, the dimension directory metadata includes ETL process definitions describing ETL processes that were utilized to generate the dimensions described in the dimension directory. In a variety of embodiments, the ETL process definitions include analyzing ETL processes for one or more pieces of reporting data and/or source data described in the dimension directory and creating one or more updated ETL processes incorporating the analyzed ETL processes. In several embodiments, redundancies are identified and/or optimizations are performed with respect to the analyzed ETL processes in the creation of the updated ETL process. In a variety of embodiments, the analyzed ETL processes are refreshed and/or updated based on the analysis. In a number of embodiments, comparing the dimension directory against the reporting data schema includes identifying corresponding dimensions in the directory of dimensions with dimensions in the reporting data schema. In many embodiments, calculating (314) redundancies includes comparing join indices in schemas defining existing reporting data and/or source data and the join indices of the determined (312) schema. In several embodiments, a join index is data describing a joined relation between two or more sets of data; the join index can also include aggregate data associated with the joined sets of data. In a variety of embodiments, calculating (314) redundancies includes comparing files stored on the interest-driven data sharing server system associated with the existing reporting data and/or existing source data with the determined (312) schema. In several embodiments, the calculated (314) redundancies are stored using redundant data metadata describing data common to the identified raw data and the previous reporting data in the located previously generated reports
In a number of embodiments, the source data job is generated (316) using an interest-driven data pipeline. In many embodiments, the generated (316) source data job is based upon metadata describing raw data available from an interest-driven business intelligence system. In a variety of embodiments, the generated (316) source data job retrieves data requested in the reporting data requirements that reduces the calculated (314) redundancy. In a variety of embodiments, the generated (316) source data job is configured to retrieve data from a plurality of data sources associated with an interest-driven business intelligence system. Systems and methods for retrieving data from multiple data sources that can be utilized in accordance with embodiments of the invention are disclosed in U.S. patent application Ser. No. 13/790,624, titled “Systems and Methods for Interest-Driven Distributed Data Server Systems” and filed Mar. 8, 2013, the entirety of which is hereby incorporated by reference. In several embodiments, the new source data is retrieved (318) from an interest-driven business intelligence system. In a variety of embodiments, the new source data is retrieved (318) from a plurality of data sources associated with an interest-driven business intelligence system. In many embodiments, the retrieved (318) source data includes a source data schema defining the dimensions and facts of the retrieved (318) source data. In a number of embodiments, the retrieved (318) source data includes metadata describing the data sources from which the source data was retrieved (318).
In a number of embodiments, building (320) reporting data includes combining the source data schema of the retrieved (318) source data with the reporting data schemas defining the existing reporting data and/or source data to create reporting data having a reporting data schema fulfilling the reporting data schema determined (312) using the received (310) reporting data requirements. Building (320) reporting data then includes retrieving the data corresponding to the new reporting data schema. In several embodiments, the calculation (314) of redundancies between the determined (312) schema and the retrieved (318) new source data is performed as the reporting data is built (320). In a variety of embodiments, the reporting data built (320) is a materialized data mart. Materialized data marts in accordance with several embodiments of the invention are relational databases containing data fulfilling the reporting data requirements; the materialized data marts can be queried like any other relational database and used to create additional reporting data. In many embodiments, building (320) reporting data includes combining files associated with the existing reporting data and/or existing source data with the retrieved (318) source data. In a variety of embodiments, data stored in materialized data marts is aggregated and/or filtered to create additional data stored in the materialized data mart. In several embodiments, data stored in multiple data marts can be combined in order to create new reporting data.
Although a specific process for interest-driven data sharing with redundancies is described above with respect to
Typically, reporting data is generated by interest-driven data sharing server systems with respect to raw data available at a particular point in time. In many cases, analysts later create reports reflecting an updated view of the previously generated reporting data without disrupting the previously created reporting data. Interest-driven data sharing server systems are configured to create a snapshot isolating the previously created reporting data to preserve reports relying upon the previously created reporting data and generate jobs requesting updated reporting data to fulfill the new report requirements. A process for snapshot isolation in interest-driven data sharing server systems in accordance with an embodiment of the invention is illustrated in
In many embodiments, reporting data requirements are received (410) from an interest-driven data visualization system. In several embodiments, the received (410) reporting data requirements are based upon metadata describing raw data stored in an interest-driven business intelligence system. In several embodiments, isolating (414) a snapshot of the initial reporting data utilizes the received (412) new reporting data requirements. In a variety of embodiments, determining when a snapshot of the initial reporting data should be isolated (414) utilizes metadata describing updated raw data available from an interest-driven business intelligence system. In several embodiments, the snapshot is isolated (414) before the data update job is generated (416) and/or the updated source data is received (418). In many embodiments, the snapshot is isolated (414) after the data update job is generated (416) and/or the updated source data is received (418).
In a number of embodiments, the data update job is generated (416) using an interest-driven data pipeline. In many embodiments, the generated (416) data update job is based upon metadata describing raw data available from an interest-driven business intelligence system. In a variety of embodiments, the generated (416) data update job is configured to retrieve only the data that has been updated since the time that the initial reporting data was built (410); additional data can be retrieved along with the updated data as appropriate to specific requirements of specific embodiments of the invention. The time the initial reporting data was built (410) can be determined in a number of ways in accordance with embodiments of the invention, including, but not limited to, metadata associated with the initial reporting data, files storing the initial reporting data, the directory structure of the files storing the initial reporting data, and/or metadata associated with the files. Metadata associated with a file in accordance with many embodiments of the invention includes, but is not limited to, the creation date of the file, and the last modified date of the file. In a variety of embodiments, the generated (416) data update job is configured to retrieve data from a plurality of data sources associated with an interest-driven business intelligence system.
In several embodiments, the updated source data is received (418) from an interest-driven business intelligence system. In many embodiments, the received (418) updated source data includes a source data schema defining the dimensions and facts of the received (418) updated source data. In a number of embodiments, the received (418) updated source data includes metadata describing the data source providing the updated source data. In many embodiments, creating (420) the updated reporting data includes combining the source data schema for the updated source data with the reporting data schema for the initial reporting data. In a variety of embodiments, building (420) reporting data includes combining files associated with the existing reporting data and/or existing source data with the retrieved (418) source data. In several embodiments, creating (420) the updated reporting data includes logically eliminating redundant data between the initial reporting data and the updated source data.
Although a specific process for snapshot isolation in interest-driven data sharing server systems is illustrated in
Interest-driven data sharing server systems are configured to create reporting data using source data received from an interest-driven business intelligence system. Interest-driven data sharing server systems create jobs to be pushed down to interest-driven business intelligence systems in order to create and retrieve source data that can be used to generate desired reports. However, the interest-driven business intelligence system providing the source data may not be able to execute the job in a low-latency fashion in all cases. In order to provide reporting data in a timely fashion, interest-driven data sharing server systems are configured to incrementally retrieve source data and create reporting data in an iterative fashion utilizing the incrementally received source data. A process for iterative reporting data generation in accordance with an embodiment of the invention is illustrated in
In many embodiments, reporting data requirements are received (510) from an interest-driven data visualization system. In several embodiments, the received (510) reporting data requirements are based upon metadata describing raw data stored in an interest-driven business intelligence system. In a number of embodiments, the job is generated (512) using an interest-driven data pipeline. In many embodiments, the generated (512) job is based upon metadata describing raw data available from an interest-driven business intelligence system. In a variety of embodiments, the generated (512) job retrieves only the source data that has not been previously received (516). The source data that has been previously received (516) can be determined in a number of ways in accordance with embodiments of the invention, including, but not limited to, metadata associated with the source data, files storing the source data, the directory structure of the files storing the source data, and/or metadata associated with the files. Metadata associated with a file in accordance with many embodiments of the invention includes, but is not limited to, the creation date of the file and the last modified date of the file.
Typically, source data is requested (514) from an interest-driven business intelligence system. Source data may be requested (514) from a variety of other data sources in accordance with the requirements of a particular embodiment of the invention. A received (516) portion of source data can be any variety of portions of source data in accordance with many embodiments of the invention. Portions of source data may be determined according to a variety of criteria including, but not limited to, the time span of the portion of source data, the time required to receive (516) the portion of source data, the size of the portion of source data received (516), requests for additional portions of source data, and the availability of resources on the business intelligence system providing the source data. A number of processes may be utilized to update (518) the reporting data using the received (516) portion of source data. These processes include, but are not limited to, those described above with respect to
Although a specific process for iterative reporting data generation using interest-driven data sharing server systems is described above with respect to
In a variety of embodiments, interest-driven data sharing server systems are configured to share reporting data and/or reporting data schemas between interest-driven business intelligence systems capable of generating similar source data and/or source data metadata. A process for sharing reporting data in accordance with an embodiment of the invention is illustrated in
In many embodiments, the created (610) reporting data schema is based upon reporting data requirements determined using metadata describing raw data available from a first interest-driven business intelligence system. In a variety of embodiments, the created (610) reporting data schema is a pre-built reporting data schema. In several embodiments, determining (612) if the destination interest-driven business intelligence system can utilize the created (610) reporting data schema involves comparing metadata describing raw data available on the first interest-driven business intelligence system with metadata describing raw data available on the destination interest-driven business intelligence system. In a number of embodiments, the reporting data schema will be shared if there is a certain amount of overlap between the raw data available; this threshold amount may be pre-determined and/or determined dynamically. In many embodiments, the reporting data schema is only transferred (614) if the determination (612) indicates that the reporting data schema can be materialized into reporting data using the destination interest-driven business intelligence system. In many embodiments, the reporting data schema (616) is updated based upon the availability of data from the destination interest-driven business intelligence system. In a variety of embodiments, the availability of data on the destination interest-driven business intelligence system is determined using metadata describing the raw data available along with any aggregate data and/or filtered data. The update (616) can performed using a variety of systems in accordance with embodiments of the invention, including interest-driven data sharing server systems and interest-driven data visualization systems. The update may be performed automatically by a machine or by input received from an analyst in accordance with the requirements of particular embodiments of the invention. In several embodiments, reporting data is created (618) using source data generated by the destination interest-driven business intelligence system in response to a job generated using an interest-driven data sharing server system using the transferred (614) reporting data requirements. In many embodiments, the job is generated using the updated (616) reporting data. In a number of embodiments, the reporting data is created (618) using a variety of processes, including those described above with respect to
A specific process for sharing reporting data generated using interest-driven data sharing server systems between interest-driven business intelligence systems is described above with respect to
Although the present invention has been described in certain specific aspects, many additional modifications and variations would be apparent to those skilled in the art. It is therefore to be understood that the present invention can be practiced otherwise than specifically described without departing from the scope and spirit of the present invention. Thus, embodiments of the present invention should be considered in all respects as illustrative and not restrictive. Accordingly, the scope of the invention should be determined not by the embodiments illustrated, but by the appended claims and their equivalents.
This application claims the benefit of U.S. Provisional Patent Application No. 61/717,096, filed on Oct. 22, 2012, the disclosure of which is hereby incorporated by reference in its entirety.
| Number | Date | Country | |
|---|---|---|---|
| 61717096 | Oct 2012 | US |
