Entries |
Document | Title | Date |
20100049756 | Medical Intelligence Framework - A framework executing on a computational structure and supporting a plurality of simultaneously executing software applications with a shared layer, wherein the framework is disposed between the plurality of applications and a set of data sources, the framework decomposing, processing, and analyzing data passed between the plurality of applications and the data sources into information elements. | 02-25-2010 |
20100063958 | Database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) for servicing query statements in a manner transparent to client machine - A database management system (DBMS) for servicing query statements through one or more client machines. The DBMS comprises a query interface adapted to receive query statements from the client machines. The query handling mechanism (i) receives each request from the query interface, (ii) extracts a set of dimensions associated with the request, (iii) uses the dimensions to retrieve aggregated fact data from a multi-dimensional database (MDDB), and (iv) forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism determines that servicing of one or more query requests require data stored in the relational tables, then the query processing mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. | 03-11-2010 |
20100076924 | SYSTEM AND METHOD OF MANAGING SOFTWARE PRODUCT-LINE CUSTOMIZATIONS - A method of managing application service provider product line variations is disclosed. The method includes receiving a client customization request, creating a configuration managed file tailored to the client customization request, binding the configuration managed file to at least one customizable resource, and deploying the customizable resource to a data store. The customizable resource is instantiated after disposition at the data store. | 03-25-2010 |
20100082524 | SYSTEM AND METHOD FOR PROCESSING AND/OR ANALYZING OLAP BASED DATA ACCORDING TO ONE OR MORE PARAMETERS - A system and method for processing a base vector derived from data stored in an OLAP cube. The system comprises a component configured for defining a base vector and a comparison vector, wherein the comparison vector comprises one or more dimensions corresponding to dimensions of the base vector. The system includes a component configured for defining a time scope associated with the base vector. The system further comprises a component configured for performing one or more analysis operations on the comparison vector to generate comparison values and a component configured for rendering the base and comparison vectors. According to another aspect, the system includes a component for altering or modifying individual data cells in the base vector and/or parameters associated with the base vector and/or analysis operation. | 04-01-2010 |
20100100522 | Interactive real estate contract and negotiation tool - Term negotiation can utilize centralized systems accessed via web interfaces for purposes such as mediation of communications between buyers and sellers, maintenance of a history of negotiations, and notification of parties regarding changes suggested during negotiation. Changes to terms proposed by parties using centralized systems can be stored in a data warehouse, potentially along with timestamp and identification information. | 04-22-2010 |
20100106680 | VENDOR PORTFOLIO MANAGEMENT IN SUPPORT OF VENDOR RELATIONSHIP MANAGEMENT ANALYSIS, PLANNING AND EVALUATION - Various examples include a system and methods in support of vendor relationship management, analysis, planning and evaluation including dealing with collections of vendors called vendor portfolios. In various examples the system includes a database, vendor portfolio definer, a vendor portfolio populator, and a vendor portfolio analyzer. The database houses vendor data. In various examples the vendor portfolio definer allows vendor portfolios to be created, meta data, including complex documents, to be associated with vendor portfolios, and user access permissions to be assigned to vendor portfolios. In various examples the vendor portfolio populator facilitates user selection of the vendors that will make up the collection of vendors in the vendor portfolio. The vendor portfolio analyzer analyzes a business metric using vendor portfolios. In various examples the vendor portfolio analyzer allows user to perform what-if analysis on vendor portfolios. In various examples the vendor portfolio definer includes a risk management definer, the vendor portfolio populator includes a risk management screener, and the vendor portfolio analyzer includes a risk manager to facilitate managing vendors base on the organizational risk they pose. In various examples the database contains information about obligations owed to and from a vendor and the vendor portfolio analyzer includes an obligation analyzer to analyze the organizational impact of vendor obligations. | 04-29-2010 |
20100138381 | Method and system for providing improved answers - Disclosed is a method and system for ranking answers supplied by user authors in an online database. A first author enters a first answer under a question. The answer is ranked #1 for output under that question. Then a second author enters a second answer under the same question. The second author also enters a bet claiming that her answer is better than the first answer. If the first author declines the bet, the second answer becomes ranked #1 for output under the question. If the first author accepts the bet, the bet is decided by a judge. The judge enters her decision into the answer database system. | 06-03-2010 |
20100287135 | CAPTURING OLAP ANALYSIS THREAD AS REFRESHABLE BUSINESS INTELLIGENCE DATA - Described herein are methods and systems for capturing OLAP analysis thread and transferring the data into a data visualization tool. According to one aspect, OLAP analysis step queries and the corresponding results are recorded and transferred to a data visualization tool. In another aspect, the data in the data visualization tool may be refreshed without affecting the data format. | 11-11-2010 |
20110016080 | DATA ACCESS SERVICE QUERIES - A technique is described for selectively obtaining information stored in a business warehouse. Such a technique may include selecting a data access service from a library during run-time and presenting data within the business warehouse using the selected data access service. The library may contain at least one data access service for each of a plurality of on-line analytical processing data access queries. Related apparatus, systems, computer program products, and computer systems are also described. | 01-20-2011 |
20110029478 | Stream Star Schema and Nested Binary Tree for Data Stream Analysis - An approach to processing data streams includes a new type dynamic database of stream star schema to accommodate high data stream rates for giga bits per second by reducing the insert time to a constant and a new type of data cube as nested binary tree to supports both data aggregates and data values. | 02-03-2011 |
20110055146 | FLEXIBLE CUBE DATA WAREHOUSING - An online analytical processing (OLAP) specification system for specifying a new OLAP cube from an OLAP cube template including an OLAP cube template determination module determining the OLAP cube template and retrieve a corresponding template metadata file, the template metadata file including metadata defining the structure of the OLAP cube template. The OLAP specification system also includes a metadata copy module copying the template metadata file to create a base metadata file. The OLAP specification system also includes a viable options generation module generating and presenting viable options for modifying metadata in the base metadata file to define the new OLAP cube, where the viable options for modifying metadata in the base metadata file conforms with one or more predetermined rules. The OLAP specification system further includes a metadata receipt module receiving input via a user interface indicating a modification to the metadata in the base metadata file based on the presented viable options and storing the modified base metadata file as a new metadata file defining the new OLAP cube. | 03-03-2011 |
20110060718 | Method and Apparatus for Organizing Hierarchical Data in a Relational Database - A relational database is provided with a plurality of data entries stored in the database. The data entries have a hierarchical relationship. The data entries are assigned a real number, unique identifier, which can be calculated using a convergent series, capable of locating each data entry in the hierarchical structure. Each data entry is assigned a float type, level value, identifying the data entries hierarchical level in the structure. The data entries are also assigned an family value defining a hierarchical relationship with another data entry. The invented method allows for retrieving a sub-tree of any data entry by comparing two real numbers, and adding new data entries or a sub-tree without making changes to other data entries. | 03-10-2011 |
20110066589 | ANALYTICS INFORMATION DIRECTORIES WITHIN A COMPREHENSIVE FRAMEWORK FOR COMPOSING AND EXECUTING ANALYTICS APPLICATIONS IN BUSINESS LEVEL LANGUAGES - Systems, methods and articles of manufacture are disclosed for building and executing analytics solutions. Such a solution may provide a comprehensive analytics solution (e.g., a risk assessment, fraud detection solution, dynamic operational risk evaluations, regulatory compliance assessments, etc.). The analytics solution may perform an analytics task using operational data distributed across a variety of independently created and governed data repositories in different departments of an organization. A framework is disclosed which allows a user (e.g., a risk analyst) to compose analytical tools that can access data from a variety of sources (both internal and external to an enterprise) and perform a variety of analytic functions. | 03-17-2011 |
20110071979 | Data Governance Manager for Master Data Management Hubs - Improved data governance solutions to enterprise-level master data storage hubs are provided by implementing data governance functionality across the operational systems, analytical systems, and master data hubs of an enterprise. Data governance functionality is provided across the systems and hubs of an enterprise by providing visibility into the operational data, analytical data, and master data of an enterprise, by providing visibility into the data quality measuring processes that have been executed on the operational and analytical data, and by providing functionality for correcting fragmented, inconsistent, and erroneous information within operational and analytical data. | 03-24-2011 |
20110099142 | MOBILE TERMINAL AND METHOD FOR PROVIDING LIFE OBSERVATIONS AND A RELATED SERVER ARRANGEMENT AND METHOD WITH DATA ANALYSIS, DISTRIBUTION AND TERMINAL GUIDING - A mobile terminal for providing life observations including: a processing entity, memory, a wireless transceiver for wirelessly transmitting and receiving data relative to external entities, an observation logic conducting active and passive observations detectable relative the mobile terminal in response to active and passive triggers, respectively, each active trigger being associated with a triggering rule for conducting a related observation, each passive trigger being associated with a change in the observation environment, the occurrence of which in the mobile terminal triggers conducting the observation linked to the passive trigger, and a data handling logic for storing, analyzing, and aggregating observation data points of the gathered observation data to timed observation data transmissions via the wireless transceiver towards an external entity. A server arrangement for analyzing context and behavior modelling using observations from plural mobile terminals and guiding the mobile terminals for future observations is also presented, with corresponding methods. | 04-28-2011 |
20110125704 | REPLICA PLACEMENT STRATEGY FOR DISTRIBUTED DATA PERSISTENCE - Methods and systems are described that involve replica placement strategy for distributed systems. At the time of index creation, initial index replica placement is decided. The first index replica is placed locally on the current processing server node. This server node operates as a master host for the first replica. The other index replicas are placed on different hosts depending on the index type, split index or non-split index, and a set of criteria. For non-split indexes, the set of criteria includes: a number of recently created replicas per host, resource usage per host, and a total number of replicas per host. For split indexes, the set of criteria includes: a number of replicas of any split index part per host and a number of local first replicas of split index parts. If all criteria are equal, the first host in alphanumeric ordering receives a next replica. | 05-26-2011 |
20110196821 | METHOD AND SYSTEM FOR GENERATION, ADJUSTMENT AND UTILIZATION OF WEB PAGES SELECTION RULES - According to some embodiments of the present invention there is provided a system of rule generation for web pages selection mechanism comprising a pattern recognition unit which analyzes a plurality of network requests and identifies a plurality of repeated patterns of characterizing features therein, a calculation unit which computes, for each said repeated pattern, a plurality of statistic features, and a rule construction unit which generates a plurality of web pages selection rules for at least some of said repeated patterns, wherein each of the web pages selection rules comprises a rule condition defining at least one criterion for matching it with characterizing features associated with at least one additional network request and a target web pages selection distribution set according to respective statistic features. | 08-11-2011 |
20110231358 | Method and apparatus for loading data files into a data-warehouse system - Date-warehouse systems are populated using an enhanced Extraction-Load-Transform (ETL) process and system by employing three ideas: Out-of-order-fill ETL, relative-ordering index (ROI), and dependent queries. Out-of-order-fill ETL allows a data warehouse to accept the loading of data files in any order, and does not require the loading of any previous backup data files in order to provide some functionality to end users under the view that some functionality or data access is better than none at all. Dependent queries are processes that use defined data structures for use in constructing, extracting, and validating each record to be written in said data-warehouse system in order to ensure that referential integrity is maintained and that no orphaned data is pushed into the data warehouse. Finally, ROI is a process wherein a value is determined, based on the constraints of the source data, which indicates the relative newness of the data. | 09-22-2011 |
20110231359 | SYNCHRONIZATION OF RELATIONAL DATABASES WITH OLAP CUBES - A method of synchronizing a source system that stores its records in a relational database and defines its own application level security with an OLAP cube, in which the structure of the relational database and cube is modelled to an intermediate representation for the purpose of comparing both structures; the differences between the two models are identified and used to modify the structure of the cube; the modified structure of the cube is used to generate a script for retrieving data from the relational database for insertion into the cube, after which the script is run and the data is inserted into the modified cube. A unique identifier is used for each item in the base system and each system is tagged with the same identifier in the cube. | 09-22-2011 |
20110276533 | ENERGY AND INTERNAL ENVIRONMENT MANAGEMENT INFORMATION SYSTEMS AND METHODS FOR BUILDINGS AND CAMPUSES - A building energy and environment information system for buildings and campuses. The invention provides an entirely elective and private incrementally deployed, incrementally modifiable, relatively inexpensive building information system that provides for a range of energy and environmental capabilities including room and building environment sensing (one or more of temperature, humidity, air quality, etc.), statistical processing software, modeling software, analysis software, information visualization software, decision support software, data logging, storage and recall, control arrangements, and interfacing with existing building systems (HVAC, solar, valves, power systems, etc.), external information systems and networks. The invention can be used for various purposes including trial deployment of equipment and software; exploratory or special-purpose information gathering; analysis, modeling, or simulation of current, past, or ongoing energy usage, loss, or waste as well as air temperature and quality distributions, impacts of changes to a building, facilities, policies, or operations; design of optimal control for building operation. | 11-10-2011 |
20110276534 | WEB-BASED INTERACTIVE GEOGRAPHIC INFORMATION SYSTEMS MAPPING ANALYSIS AND METHODS OF USING THEREOF - A method, system, and computer-readable medium for providing geographic information systems (GIS) data is provided. The steps, functions, and instructions provided include receiving GIS data from a plurality of websites, populating a searchable database with the GIS data, and generating a search-specific electronic summary of GIS data. A method and system for networking users of a GIS data management system is also provided. The steps and functions provided by this method and system include populating a searchable database with GIS data received from a plurality of websites and providing a networking interface interoperable with the database such that users of the GIS data management system are networked according to GIS data queries. | 11-10-2011 |
20110295791 | SYSTEM AND METHOD FOR SPECIFYING METADATA EXTENSION INPUT FOR EXTENDING DATA WAREHOUSE - An input extension specification can be generated, via an administration tool on a business intelligence (BI) server, for an extender associated with a data warehouse in order to extend the data warehouse. The administration tool can request for data flow information of the data warehouse from the extender. The data flow information indicates the mapping relationship between one or more source data objects and one or more target tables in the data warehouse. The administration tool further allows a user to select said one or more target tables in the data warehouse to be extended based on the data flow information, and builds the input extension specification for the extender. | 12-01-2011 |
20110307440 | METHOD FOR THE FULLY MODIFIABLE FRAMEWORK DISTRIBUTION OF DATA IN A DATA WAREHOUSE TAKING ACCOUNT OF THE PRELIMINARY ETYMOLOGICAL SEPARATION OF SAID DATA - Method for the fully modifiable framework distribution of data in a data warehouse taking account of the preliminary etymological separation of said data is based on the framework model of data. It is about the totality of the entity-objects, that relate to a particular abstract domains, is distributed into five groups in an automated way: atomic, composite and weak entity-objects, as well as artifacts i.e. entity-copies the data of which are conventionally placed in warehouse, and a group of indefinite entity-objects, the semantics of which is the subject to further specification. The method provides for the option of replenishment of the algorithms groups and criteria for the separation, each of which allows for a more accurate classification of a particular entity-object to the above-mentioned groups. And their using consistently makes it possible to speed up the process and reduce the fifth group—the group of indefinite entity-objects, which have contradictory characteristics—they can be equally assigned to different groups. A few algorithms were shown. This is an algorithm based on using the dictionary of entity-objects, which is available in public networks and is constantly replenished, and on functional dependencies between the data from the entity-objects, which allows us to compare the entity-objects with each other; an algorithm for tracking some repeating entity-objects in binary pairs, the algorithm of the statistic analysis of the determinized or multi-valued dependencies, as well as the algorithms of successive approximations modifications on the connections' framework-template. This pre-separation of the entity objects set in the abstract domains makes it possible to simultaneously use both the relational properties and, for example, object-oriented model of data distribution. This provides the option to account for some artifacts, for which multiple domains masks are formed in the warehouse, each of which is assigned an identification key corresponding to its structure. Effectuating the Cartesian products of masks among themselves on an “each on each” principle, a complete set of composite entity objects is obtained. After that, they set aside some semantically incompatible ones from the obtained tables—for example, the result of multiplying two weak entity-objects that have a common ancestor. Thus, a logical and physical data schemas, which are equivalent to each other. This enables using of relational capabilities in a physically distributed data warehouse separated onto different servers. The method also solves the issue of standardization of data warehouse schemes creation. | 12-15-2011 |
20110320398 | Apparatus and Method for Dynamically Materializing A Multi-Dimensional Data Stream Cube - A computer readable storage medium comprises executable instructions to generate a stream cube to store data received from multiple data sources. A plurality of multi-dimensional data streams are generated to represent the received data. A materialization strategy is repeatedly determined for the stream cube. The stream cube is materialized according to the materialization strategy to record the multi-dimensional data streams. | 12-29-2011 |
20120005151 | METHODS AND SYSTEMS OF CONTENT DEVELOPMENT FOR A DATA WAREHOUSE - In one embodiment, a processor-readable medium stores code representing instructions to cause a processor to perform a process including accessing a metadata specification and generating a data warehouse based on the metadata specification. The metadata specification includes metadata associated with generation of the data warehouse. | 01-05-2012 |
20120084250 | DATA WRITE-BACK TO DATA PROVIDER FROM INDIVIDUAL GRID CELLS - Architecture that provides an asymmetrical data approach to data write-back to a backend data store. Write-back is accomplished from a grid cell to a data provider (e.g., OLAP (online analytical processing)) that handles UPDATE CUBE statements. The coordinates of the data to access from the cube are provided in a first cell. In a second cell, the user provides the value desired to send back to the cube and a reference to the first cell that contains data value coordinates property. A calculation is triggered to determine if there is a difference in the value at the coordinates provided in the first cell and the user-supplied value in the second cell. If there is a difference, then the properties of the cube value function associated with the first cell are used to construct the UPDATE CUBE statement to send back the user-provided value to the data location defined by the coordinates. | 04-05-2012 |
20120084251 | PROBABILISTIC DATA MINING MODEL COMPARISON - A first data mining model and a second data mining model are compared. A first data mining model M | 04-05-2012 |
20120084252 | Datacenter Workflow Automation Scenarios Using Virtual Databases - Information from multiple databases is retrieved and stored on a database storage system. Multiple point-in-time copies are obtained for each database. A point-in-time copy retrieves data changed in the database since the retrieval of a previous point-in-time copy. A virtual database (VDB) is created by creating a set of files in the data storage system. Each file in the set of files created for a VDB is linked to the database blocks on the database storage system associated with a point-in-time copy of the source database. The set of files associated with the VDB are mounted on a database server allowing the database server to read from and write to the set of files. Workflows based on VDBs allow various usage scenarios based on databases to be implemented efficiently, for example, testing and development, backup and recovery, and data warehouse building. | 04-05-2012 |
20120095956 | PROCESS DRIVEN BUSINESS INTELLIGENCE - Described herein is a technology for facilitating process driven business intelligence. In one implementation, context data generated by a business process tool is received. One or more relevant application programming interfaces (APIs) are identified by matching the APIs with the current attribute associated with the context data. The APIs are executable by a processor to retrieve source data from an information source and provide business intelligence based on the source data. | 04-19-2012 |
20120109875 | ORGANIZATION OF DATA MART USING CLUSTERED KEY - A data mart may be organized using a clustered key, thereby allowing certain efficiencies in data search and retrieval to be realized. In one example, the clustered key is made of a plurality of attributes. The attributes may be chosen based on their likelihood of being using as search criteria. The likelihood of a given attribute being used as a search criterion may be determined through historical analysis of search requests. Records in the data mart may be sorted based on the attributes in the clustered key, thereby producing records that are organized by attribute in sequential runs. When a search uses an attribute in the clustered key as a search criterion, the records that are being sought may appear in one or more sequential runs, thereby leveraging the efficiency of sequential reads as opposed to random reads. | 05-03-2012 |
20120109876 | Long-term global anonymous medical health records repository - This invention provides a very large, long term, universal, and global repository of health records for knowledge preservation, statistical sample analysis, and querying, without personally identifiable patient information. Embodiments of this invention provide a computerized system consisting of a very large number—thousands to billions—of health records, with long-term medical history—spanning several years to several decades—, obtained from diverse health care providers, stored in read-only mode in a global repository, without accessible personally identifiable patient information, and with the corresponding means to query, correlate, trend, and analyze the data. | 05-03-2012 |
20120130940 | REAL-TIME ANALYTICS OF STREAMING DATA - Storage media, systems and methods are disclosed herein for analyzing data streams in real time. More particularly, storage media, systems and methods are presented for processing data streams to calculate results for prospective queries. The results may be advantageously computed prior to the formulation of the specific query, for example, based on a pre-established framework of potential query parameters. More particularly, a universe of potential queries may be extrapolated from the pre-established framework of potential query parameters. Results for each of the potential queries may them be tracked in real time. For example, results for each of the potential queries may be continuously updated based on real-time processing of events in a data stream. | 05-24-2012 |
20120130941 | Data Collection Framework - A common data collection framework accesses data collected by an electronic commerce system in a format specific to the electronic commerce system. The common data collection framework determines a type of the data and identifies, from among multiple types of common data objects, a common data object that is independent of the electronic commerce system and that is defined to store data corresponding to the determined type. The common data collection framework stores the data collected by the electronic commerce system in an instance of the common data object and provides, to an analytics system, the instance of the common data object to enable the analytics system to perform analytics on the data collected by the electronic commerce system using the common format that is different than the format specific to the electronic commerce system and that accommodates multiple, different types of electronic commerce systems. | 05-24-2012 |
20120150791 | METHODS AND SYSTEMS FOR LOADING DATA INTO A TEMPORAL DATA WAREHOUSE - A system disclosed includes a temporal data warehouse and a platform independent temporal data warehouse load application operable to run on the system. The load application uses timestamp data from incoming data in conjunction with a relational algebra of set operators to identify and sequence net changes between the incoming data and data previously stored within the data warehouse. The load application loads the identified and sequenced net changes into the data warehouse with relatively little intrusion into normal operation of the data warehouse. Optimizations, including but not limited to, distinct partitioning of the workload into parallel streams are selectable via metadata. | 06-14-2012 |
20120158642 | ENTERPRISE RESOURCE PLANNING (ERP) SYSTEM CHANGE DATA CAPTURE - A device receives, from a data warehouse, a request for incremental data, creates one or more temporary tables based on the request, and extracts incremental data from tracking tables of an enterprise resource planning (ERP) system. The device also stores the extracted incremental data in the one or more temporary tables, and joins the one or more temporary tables with one or more regular tables, where the one or more regular tables include data associated with the incremental data stored in the one or more temporary tables. The device further retrieves data from the joined one or more temporary tables and the one or more regular tables, and stores the retrieved data in the data warehouse. | 06-21-2012 |
20120158643 | Data Mining in a Business Intelligence Document - A business intelligence document provides functionality for testing a hypothesis on aggregated data in a business intelligence document (e.g., a spreadsheet-like document), wherein one or more of the input data values and transformation properties are designated as constrained (e.g., invariant or constrained within a range, set, enumeration, or domain). The hypothesis, which is articulated as a data mining assertion, is input through the user interface of the business intelligence document (e.g., via an expression interface or properties of a row, column, or cell) and solved over the aggregated data. The solution is then presented through the user interface of the spreadsheet-like document, such as in a table, graph, histogram, etc. | 06-21-2012 |
20120166383 | Annotation Of Data In An Operating Plan Data Aggregation System - In an embodiment a method is provided. The method includes receiving forecast information in a computer from a first group of users. The method also includes integrating the forecast information into a database and corresponding OLAP cube accessible by the computer. The method further includes receiving comments on specific entries of the forecast information in the computer from a second group of users. The method also includes receiving changes of the forecast information in the computer from a second group of users The method further includes integrating comments and changes into the database and OLAP cube. Moreover, the method includes providing a display of the comments and the changes to the first group of users in an interface to the computer. | 06-28-2012 |
20120173475 | Health Information Transformation System - Methods, computer systems, and computer readable media for transforming raw healthcare data into relevant healthcare data are provided. Transformation of raw healthcare data into relevant data is accomplished by receiving raw data from a plurality of data collectors, where the plurality of data collectors extract the raw data from a plurality of raw data sources, and sorting the raw data into unstructured raw data, structured data of non-standard nomenclature, and structured data of standard nomenclature. The data is transformed into relevant data through the use of natural language processing, nomenclature and ontology mapping, and adaptive knowledge processing. The relevant data is stored in a plurality of data repositories, and computer applications and services are allowed access to the plurality of data repositories. | 07-05-2012 |
20120185425 | CONTENT BASED APPROACH TO EXTENDING THE FORM AND FUNCTION OF A BUSINESS INTELLIGENCE SYSTEM - A business intelligence (BI) system which includes the ability to extend its functionality outside of the project life cycle by means of specific content. Complex multidimensional queries are interpreted as trees of atomic sub-expressions that are combined in a parse-tree-like structure to form the overall query. Each sub tree is valid in isolation when provided with the proper context. Any sub tree can be an expression template, stored as application content, which at generation time uses simple text substitution with instance specific parameters to produce multidimensional expression syntax. The system includes a sophisticated type system and semantic layer that hides the user from the complexities inherent in working with OLAP databases. A business intelligence expert can provide type and semantic cues for each expression template, held as content. The content expression templates are then exposed in the application primarily through a context menu that is filtered for appropriateness, but also in an explorer tree, toolbars, menus and submenus. The functionality from a users perspective is integral to the application. An iterative processing capability to complement these expressions is provided by means of OLAP database stored procedures held as application content. Building on the above, workflow content allows business users to extend the application by creating expert-system-like guided analyses and processes. Of key significance to this innovation is the concept that the expression templates, stored procedures and workflows are application content, and therefore redistributable and unshackled from the classic software development lifecycle and the cost and expertise associated. | 07-19-2012 |
20120203733 | Method and system for personal cloud engine - Personal Cloud Engine (iCloud) described in the present invention collects information relevant to a user from various data sources including personal email accounts, social network accounts, online vendors, on-line services for store and share photos and videos and on-line bank accounts. Collected data are classified, indexed, tagged and stored in a persistent data storage device. Web interface such as HTTP is provides for access data by a client, which can be web browser running on a computing device or a client application running on a smart phone. By gathering all the data, iCloud maintains a secondary copy of all valuable personal data and effectively prevents data loss. iCloud can also utilize the data and extract intrinsic value from the data stored by data mining and analytic tools. | 08-09-2012 |
20120209802 | POWER MANAGEMENT IN LINK AGGREGATION FOR DATA TRANSMISSION - A method includes receiving a data query instruction for execution, wherein execution of the data query instruction is to cause a data transfer into or from a data warehouse. The data warehouse includes data servers that are communicatively coupled for data transfer through a link aggregation group having at least two data links. Responsive to receiving the data query instruction and prior to or at least partially overlapping with execution of the data query instruction to cause the data transfer, the method includes identifying which of the number of data servers are to receive or transmit data as part of the data transfer; identifying, for each of the identified data servers, a minimum number of the at least two data links that are needed for the data transfer; and activating, if inactive, the minimum number of the at least two data links for each of the identified data servers. | 08-16-2012 |
20120221507 | DECLARATIVE UPDATE TO A LIVE SYSTEM - A live system manager may retrieve a current state of the live system, allow a user to edit the state, and generate a set of incremental commands that modify the current state into a desired state. The set of incremental commands may be then executed to create the desired state. In some embodiments, the set of incremental commands may be executed as a transaction. The live system manager may compare the current state to a desired state to generate the incremental commands, and may perform various validation operations during operation. A user may be presented options at various points to disambiguate the user's intentions. | 08-30-2012 |
20120226656 | SCALABLE MECHANISM FOR RESOLVING CELL-LEVEL ACCESS FROM SETS OF DIMENSIONAL ACCESS RULES - Methods and apparatus, including computer program products, implementing and using techniques for resolving cell-level access in a multi-dimensional data structure based on one or more sets of dimensional access rules. A business hierarchy is provided with nodes arranged in a tree structure. An online analytical processing database has several data cubes, where at least some have the business hierarchy as one of their dimensions. One or more rule-based access tables are provided for controlling access to cells of each data cube. Groups of nodes with identical access settings are identified in the business hierarchy. A single access block is generated per node group. Each access block is a serializable access specification object that contains information for generating a complete cell-level mask of access settings for a single node of the business hierarchy. The mask is generated based on the information in the access blocks for each node in the hierarchy. | 09-06-2012 |
20120239609 | System and Method of Relating Data and Generating Reports - In one embodiment the present invention includes a computer implemented method of relating data and generating reports. The method includes storing, by an OLAP system, a network data structure that relates a plurality of data objects. The method further includes storing transactional data in an in-memory database in the OLAP system. The method further includes generating, by the OLAP system, a report using the stored transactional data according to the network data structure. In this manner, deficiencies of the traditional star schema paradigm of data warehousing may be avoided. | 09-20-2012 |
20120259809 | In-Memory Processing for a Data Warehouse - Embodiments of the present invention include in-memory processing for data warehouse applications. In one embodiment, data records from a data warehouse application are stored in a data storage structure of an in-memory database. Data received from the data warehouse may be stored in a queue and loaded into the data storage structure according to predefined rules. Stored data records are associated with in-memory database transactions that caused the stored data record to be stored, and may further be associated with transactions that caused the stored data records to be changed. A mapping is generated to associate requests from the data warehouse application with in-memory database transactions. The data warehouse application may retrieve data in a change data format calculated on-the-fly. | 10-11-2012 |
20120265725 | Method and Apparatus for Monitoring an In-memory Computer System - An in-memory computing system for conducting on-line transaction processing and on-line analytical processing includes system tables in main memory to store runtime information. A statistics server can access the runtime information to collect monitoring data and generate historical data and other system performance metrics. | 10-18-2012 |
20120310874 | Determination of Rules by Providing Data Records in Columnar Data Structures - A method includes providing a columnar database comprising a plurality of columnar data structures associated with one column attribute; providing first data records having a plurality of first attribute-value pairs comprising counting information indicative of a number of first data records having the respective first attribute-value pair; providing mask data structures comprising one or more second attribute-value pairs; selecting second data records by intersecting the columnar data structures and the mask data structures; selecting one of the column attributes and one value contained in the column data structure associated with said selected column attribute as the destination attribute-value pair; creating one second rule for each first attribute-value pair; calculating, for each second rule, a co-occurrence-count between its respective source attribute-value pair and its destination attribute-value pair; and specifically selecting one or more of said second rules as the first rules in dependence on the calculated co-occurrence-count. | 12-06-2012 |
20120317070 | System, Process and Software Arrangement for Providing Multidimensional Recommendations/Suggestions - A process, system and computer software are provided to facilitate at least one recommendation to one or more users and/or one or more applications using multidimensional data. In particular, a multidimensional space is defined, wherein each dimension is capable of providing variable information. At least one dimension corresponds to user profiles. The multidimensional space is filled with multidimensional data corresponding to dimensions of the multidimensional space. Then, information from the multidimensional space is retrieved. Further, the recommendation is generated based on the retrieved information. In addition, it is possible to generate a recommendation-specific query. This can be performed by generating the recommendation-specific query to access a multidimensional cube and retrieve data stored therein. Then, the recommendation can be issued based on the data retrieved from the multidimensional cube. | 12-13-2012 |
20130013552 | Interest-Driven Business Intelligence Systems and Methods of Data Analysis Using Interest-Driven Data Pipelines - Interest-driven Business Intelligence (BI) systems in accordance with embodiments of the invention are illustrated. In one embodiment of the invention, a data processing system includes raw data storage containing raw data, metadata storage containing metadata that describes the raw data, and an interest-driven data pipeline that is automatically compiled to generate reporting data using the raw data, wherein the interest-driven data pipeline is compiled based upon reporting data requirements automatically derived from at least one report specification defined using the metadata. | 01-10-2013 |
20130018839 | ENABLING COMPUTATIONAL PROCESS AS A DYNAMIC DATA SOURCE FOR BI REPORTING SYSTEMS - There is provided a system, method and computer program product for integrating at least one analytical or modeling driver into an existing business analytic environment. The system comprises a BAMS (Business Analytics and Mathematical Sciences) driver, implemented on the memory device and run by the processor, loads a real database driver and redirects a request from a client application to the real database driver. An extension driver, invoked by the BAMS driver, provides an interface to a data modeling or processing software and converts the interface from a software environment compiled by a programming language to another software environment targeted to another programming language. The extension driver extends or overrides functionalities of the BAMS driver. Implementing the BAMS driver and the extension driver in the existing business analytic environment do not require any change made on the existing business analytic environment. | 01-17-2013 |
20130060729 | DISASTER AND EMERGENCY MANAGEMENT SYSTEM - A user interface for providing emergency and other information to an end user, where the information is stored locally on a portable device. The present invention provides real-time access to disaster and/or critical event pre-planning as well as real-time information correlation related to the management and control of disasters and other emergencies in addition to disaster pre-planning utilizing portable tablet devices. The present invention is an application that resides on a user's portable electronic device such as a tablet, and may be served by push and/or demand from a server or cloud data service. The application includes information related to pre-disaster planning as well as disaster response during an actual emergency or disaster event. The application structure is designed to provide emergency, disaster, and building planning information for both commercial and/or building interests, government and municipalities, and for individuals and families. | 03-07-2013 |
20130073513 | Hybrid OLTP and OLAP High Performance Database System - There is provided a method of maintaining a hybrid OLTP and OLAP database, the method comprising: executing one or more OLTP transactions; creating a virtual memory snapshot; and executing one or more OLAP queries using the virtual memory snapshot. Preferably, the method further comprises replicating a virtual memory page on which a data object is stored in response to an update to the data object, whereby the updated data object is accessible for OLTP transactions, while the non-updated data object remains accessible for OLAP queries. Accordingly, the present invention provides a hybrid system that can handle both OLTP and OLAP simultaneously by using hardware-assisted replication mechanisms to maintain consistent snapshots of the transactional data. | 03-21-2013 |
20130080383 | Archiving-Safe Replication of Relational Data - A computer-implemented method for archiving information includes: executing a first application in a first process; determining that the first application is an archiving application configured to archive information stored in a transactional system; assigning, based on the determination, an archiving mode to the first process; receiving, from the first process and after assigning the archiving mode, a request to delete information; and processing the request to delete information according to the archiving mode. | 03-28-2013 |
20130110764 | SYSTEM AND METHOD OF COMBINED DATABASE SYSTEM | 05-02-2013 |
20130132333 | MULTIDIMENSIONAL GROUPING OPERATORS - A multidimensional object, such as a language-integrated query (LINQ) object, can be generated based upon a grouping set operator and zero or more key selectors. The object can be utilized to query over a non-relational data source. The object can include a sequence of functions corresponding to each grouping related to the grouping set operator in order to provide multidimensional grouping representation. Furthermore, the object includes nested structures for optimized execution of the grouping set operator. | 05-23-2013 |
20130144833 | PROCESSING DATA IN A DATA WAREHOUSE - Data of a database environment, which includes hierarchy information and a matrix of values, is processed. The hierarchy information includes at least two sets of identification codes and defines at least two groups of identification codes. The matrix of values includes at least two columns of identification values. At least one simple filter object is generated based on a user input. Each simple filter object defines an ad hoc group of identification codes selected from a respective one of the sets of identification codes. A filtered operation object that specifies an operation and at least one of the simple filter objects is generated based on a user input. Each of the ad hoc groups differs from each of the groups defined by the hierarchy information. | 06-06-2013 |
20130151464 | PARALLEL PROCESSING OF SEMANTICALLY GROUPED DATA IN DATA WAREHOUSE ENVIRONMENTS - A system and method for parallel processing of semantically grouped data in data warehouse environments is disclosed. A datastore object having a number of records is generated in a data warehouse application. A hash value is added to each record. The hash value has an integer domain, and is uniformly distributed over the integer domain across the datastore object. A selection table is generated to create a number of tasks based on discrete ranges of the hash value. Then, a transformation routine is executed on each of the number of tasks in parallel to generate an infocube of data that corresponds to each range of the discrete ranges of the hash value. | 06-13-2013 |
20130151465 | RANGE AND PATTERN SELECTION IN REPORTING SOLUTIONS RELATED TO ANALYTICAL MODELS - Various embodiments of systems and methods for range and pattern selection in reporting solutions related to analytical models are described herein. Selection of range of values or pattern selection is performed and then the values are transformed to a list of single variables known to the underlying online analytical processing system. | 06-13-2013 |
20130179393 | METHOD FOR ANALYZING DATA UTILIZING WEIGHTED SUFFIX TREE - A method for analyzing data utilizing a weighted suffix tree includes receiving at least one original data sequence. An original data sequence ID is assigned to the original data sequence, and the original data sequence includes an original datums. A weighted suffix tree is constructed according to the original datums of the original data sequence. The weighted suffix tree includes several nodes, and each node includes a weight set which is formed by the original data sequence ID. Group information for classifying the original datums into several groups is received. The nodes of the weighted suffix tree belonging to a same group are merged according to the group information. Data is analyzed according to the weighted suffix tree after being merged. | 07-11-2013 |
20130185248 | SYSTEM AND METHOD FOR ANALYZING AND REPORTING EXTENSIBLE DATA FROM MULTIPLE SOURCES IN MULTIPLE FORMATS - A system and method for analyzing and reporting data from multiple sources is provided. The system is a foundation for an analytical platform that covers not only traditional relational data, but also a new generation of extensible data formats designed for the web, such as those based on XML (FIXML, FpML, ebXML, XBRL, ACORD, etc.), as well as HTML, E-mail, Excel, PDF, and others. In a preferred embodiment, the eXtensible on-line analytical processing (XOLAP), is a scalable client/server platform that allows the multi-dimensional analysis of modern data types, as well as traditional relational data, by bringing them all into an internal common XML-based model, without the time and expense of creating a data warehouse. | 07-18-2013 |
20130238547 | Methods, Systems, and Products for Stream Warehousing - Methods, systems, and products schedule updates to stream warehouses. A plurality of execution tracks are allocated in memory, with each execution track assigned a portion of utilization of a processor and a proportionate portion of the memory. A home track is also defined in the plurality of execution tracks. When the home track is unavailable, then a different track in the plurality of execution tracks is selected, and a database update job is dispatched to the different track. | 09-12-2013 |
20130238548 | ANALYTICAL DATA PROCESSING - Systems and apparatuses are provided for integrating user defined functions into an analytical data processing framework. A query compiler ( | 09-12-2013 |
20130246334 | SYSTEM AND METHOD FOR PROVIDING DATA PROTECTION WORKFLOWS IN A NETWORK ENVIRONMENT - A method is provided in one example and includes receiving first sets of metadata elements representing objects of an inventory and generating a first summary of a first subset of the objects. The method further includes receiving second sets of metadata elements and corresponding category information representing objects of the first subset that are classified based on a first category and generating a second summary of a second subset of the classified objects. In yet further embodiments, the method includes initiating a protection task for objects of the second subset of the classified objects. In more specific embodiments, the protection task includes applying a remediation policy to the objects of the second subset or registering the objects of the second subset. In yet other embodiments, the second summary includes at least one of a total count and a total size of the objects in the second subset. | 09-19-2013 |
20130246335 | SYSTEM AND METHOD FOR PROVIDING DATA PROTECTION WORKFLOWS IN A NETWORK ENVIRONMENT - A method is provided in one example and includes receiving first sets of metadata elements representing an inventory of objects in a data storage location of a network environment and presenting an inventory view of the objects to a user. The inventory view includes a first summary of the inventory objects. The method further includes receiving a request from the user to manipulate the inventory view based on a first selected dimension group and presenting to the user a manipulated inventory view that includes a second summary of a first subset of the inventory objects. In more specific embodiments, the method includes receiving a request from the user to perform a protection task on objects of the first subset and initiating the protection task. The protection task includes one of applying a remediation policy to the objects of the first subset and registering the objects of the first subset. | 09-19-2013 |
20130246336 | SYSTEM AND METHOD FOR PROVIDING DATA PROTECTION WORKFLOWS IN A NETWORK ENVIRONMENT - A method is provided in one example and includes crawling a storage location of a network environment to identify objects, fetching the identified objects, creating indexes corresponding to the identified objects, and classifying one or more objects of the identified objects based on a first category. The method further includes providing first sets of metadata elements and corresponding first category information representing the classified one or more objects of the identified objects, searching the indexes for a selected group of the classified one or more objects of the identified objects, and classifying one or more objects of the selected group based on a second category. In more specific embodiments, the method includes applying a remediation policy to the classified one or more objects of the selected group. In other more specific embodiments, the method includes registering the classified one or more objects of the selected group. | 09-19-2013 |
20130290242 | TIME SERIES DATA PROCESSING DEVICE AND METHOD THEREFOR - A data accumulation unit selects, upon data accumulation, time series data relating to a predicted number of vibrations and an actual number of vibrations as combinations of time series data, which become the analysis targets and are generated in the same cycle, among time series data from a time series data source, aggregates the selected combinations of time series data on an hourly basis, and accumulates the aggregated plural sets of time series data in an aggregated data table by associating them with an attribute (the number of vibrations); and upon data analysis, a data analysis unit accesses the aggregated data table based on the attribute, extracts the combinations of the time series data relating to the predicted number of vibrations and the actual number of vibrations as time series data to be used for the analysis and calculates the number of divergence vibrations. | 10-31-2013 |
20130346359 | Methods And Apparatus For Data Collection - Systems and techniques for directing data collection. Upon an initial data collection, the uncertainty of all or of a portion or portions of the collected data is evaluated. The collected data may be associated with a region, with portions of the collected data associated with subregions. Further data collection, including changes to or refinement of collection techniques, is undertaken based on evaluations of the uncertainty. Further data collection may be undertaken only for portions of the data for which uncertainty exceeds a threshold. Uncertainty evaluation may be performed at least in part using a model. The model may be an initial hypothesis model, and the model may be optimized as further data is collected, and the optimized model may be used to guide further data collection techniques, with iterations of data collection and model optimization being carried out concurrently. | 12-26-2013 |
20140032477 | SYSTEM AND METHOD FOR PROVISIONING AND LOAD BALANCING USER ACCOUNTS ON SERVER CLUSTERS - Providers of Internet based services must handle requests from many different customers. However, to make the experience simple and effective, a system for allowing a user to enter a simple Uniform Resource Locator based upon the user's identifier is provided that re-directs the user to a server cluster allocated to that user. The system is capable of periodic load re-balancing and can handle many different types of services for each user. | 01-30-2014 |
20140074769 | TUPLE REDUCTION FOR HIERARCHIES OF A DIMENSION - According to one embodiment of the present invention, a level of a first hierarchy and a second hierarchy of data attributes is determined where the first hierarchy and the second hierarchy share the determined level and each subordinate hierarchical level. The embodiment further removes from a set of tuples of a database operation at least one tuple that lacks corresponding data in a data source based on the tuple containing elements corresponding to non-intersecting sets of attributes at the determined level. Embodiments of the present invention include a method, system and computer program product for reducing tuple sets in substantially the same manner described above. | 03-13-2014 |
20140074770 | MANAGING ACTIVITIES OVER TIME IN AN ACTIVITY GRAPH - Systems and processes for managing a data warehouse using an activity graph are disclosed. One example process may include selectively tracking new versions of an entity based on a tracking type, removing entities based on data retention rules, removing entities based on data decay rules, and summarizing decayed data. | 03-13-2014 |
20140108330 | ENCAPSULATION OF MULTIPLICITY AND SPARSITY IN MULTIDIMENSIONAL QUERY EXECUTION SYSTEMS - Provided are techniques for processing a multidimensional query. For each multidimensional expression in the multidimensional query, the multidimensional expression is evaluated to generate a representation that includes an evaluation context, a degeneration status, and condensed value storage that does not store data that would be replicated due to degeneration, and the representation is stored. | 04-17-2014 |
20140114905 | ASSOCIATED INFORMATION PROPAGATION SYSTEM - An associated information system is provided that propagates visibility of associated information. The associated information system traces a data lineage of a data warehouse. The associated information system further identifies an association between a primary data element and an associated object, where the association between the primary data element and the associated object is identified as a primary link. The associated information system further stores a first associated object mapping system record within an associated object mapping system table that represents the primary link. The associated information system further identifies an association between a secondary data element and the associated object using the data lineage, where the association between the secondary data element and the associated object is identified as a secondary link, and where the secondary data element is related to the primary data element within the data lineage. The associated information system further stores a second associated object mapping record within the associated object mapping system table that represents the secondary link. | 04-24-2014 |
20140122411 | SINGLE PERSISTENCE IMPLEMENTATION OF BUSINESS OBJECTS - Business objects can be implemented in a single persistence scenario that supports both online transaction processing (OLTP) and online analytical processing (OLAP). A consumption-centric approach can use a same business object attribute data format model for consumption and persistence. Also, a singular model can be implemented in different layers of a system processing business objects. Extra software layers can be avoided. A business-objects-based system can take advantage of the technologies to provide greater flexibility, ease of extensibility, and performance improvements. | 05-01-2014 |
20140129511 | ON-DEMAND VIEWING OF A REPORT WITH SECURITY PERMISSIONS - A report link with security permissions is provided that generates a report personalized to a user's security permissions on-demand. A report service providing the functionality of a business intelligence system can create a uniform resource locator (URL) for a report. The URL may be generated to reference an application server, a report name, and a report identifier. An output file type can be passed through the URL to indicate how the report is to be viewed. A same report link may be distributed to users having different security permissions, while being used to render different viewable reports according to each user's permissions. When a client requests a report located at the URL, the report service performs a check of the roles/permissions of the user and arranges the report view for the user by combining sections of the report snapshot according to the roles/permissions of the client. | 05-08-2014 |
20140136470 | DATA AND META DATA VARIANTS EXTENDING ACTUAL DATA FOR PLANNING - Embodiments implement data and meta data versioning in order to adapt reported data (“actuals”) for planning purposes. A versioning engine receives from an operative system (e.g. ERP system), root variants. These root variants may comprise existing actual data and corresponding underlying corporate meta data. Based upon user input, the versioning engine creates from these root variants, additional variants of the data and/or meta data. A new data variant may be based upon the original corporate meta data unchanged (e.g. for projecting existing product lines). A data variant may alternatively be based upon a new meta data variant reflecting changes to the original corporate meta data (e.g. for adopting an entirely new product line). By effectively depicting relationships between actual data and plan data, and between that data and its underlying meta data, versioning allows a user to visualize evolution of actual data into plan data for forecasting purposes. | 05-15-2014 |
20140156586 | BIG-FAST DATA CONNECTOR BETWEEN IN-MEMORY DATABASE SYSTEM AND DATA WAREHOUSE SYSTEM - Embodiments of the present invention include systems and methods for insuring better query consistency between at least two different databases, where one faster database has more up-to-date information than another slower database, and wherein updates are typically applied to the faster database first and then to the slower database. In embodiments, the systems and methods also insure that a query to the slower database is not performed until a set of one or more updates from the faster database have been applied to that slower database. | 06-05-2014 |
20140156587 | RDF DATA WAREHOUSE VIA PARTITIONING AND REPLICATION - Hardware and/or software suitable for RDF data warehousing, a type of data integration wherein integrated information is represented as RDF and loaded into a centralized RDF database, is presented. Pieces of hardware/software suitably support desired performance and flexibility by transforming one or more RDF documents to a binary format where RDF resources are replaced by identifiers, indexing each integrated data source into a separate RDF database and finally merging data to a warehouse through merging steps. The RDF data warehousing is a special type of data integration approach that allows query optimization. | 06-05-2014 |
20140156588 | SYSTEMS AND METHODS FOR PERFORMING CUSTOMIZED LARGE-SCALE DATA ANALYTICS - A computer-implemented method for performing customized large-scale data analytics may include (1) providing a logical-data-model user interface to enable modifying a logical data model of a relational multi-dimensional analytic database, (2) receiving, via the logical-data-model user interface, user input to modify the logical data model of the relational multi-dimensional analytic database, (3) modifying the logical data model of the relational multi-dimensional analytic database based on the user input, (4) providing a visualization user interface, based on the logical data model, to enable performing online analytical processing operations, and (5) receiving, via the visualization user interface, a request to perform an online analytical processing operation that provides a view of data stored within the relational multi-dimensional analytic database in accordance with the logical data model. Various other methods, systems, and computer-readable media are also disclosed. | 06-05-2014 |
20140164314 | SYSTEM AND METHOD FOR PROVIDING DATA PROTECTION WORKFLOWS IN A NETWORK ENVIRONMENT - A method is provided in one example and includes receiving first sets of metadata elements representing an inventory of objects in a data storage location of a network environment and presenting an inventory view of the objects to a user. The inventory view includes a first summary of the inventory objects. The method further includes receiving a request from the user to manipulate the inventory view based on a first selected dimension group and presenting to the user a manipulated inventory view that includes a second summary of a first subset of the inventory objects. In more specific embodiments, the method includes receiving a request from the user to perform a protection task on objects of the first subset and initiating the protection task. The protection task includes one of applying a remediation policy to the objects of the first subset and registering the objects of the first subset. | 06-12-2014 |
20140172775 | FIELD EXTENSIBILITY IN A MULTI-TENANT ENVIRONMENT WITH COLUMNAR DATABASE SUPPORT - A multi-tenant environment can support field extensibility via extension tables. An in-memory, columnar database can store a core table being extended as well as the corresponding extension table. Transactional and analytical processing can be performed on the extension fields. A business-objects-based system can take advantage of the technologies to provide greater flexibility, security, and performance improvements. | 06-19-2014 |
20140172776 | COLUMN SMART MECHANISM FOR COLUMN BASED DATABASE - Embodiments of the present disclosure may provide a system and method for processing an online transactional processing (OLTP) transaction on a column-based storage of a database. The method may include receiving a request of the OLTP transaction to access data on the column-based storage. A determination may be made whether a cache associated with the database includes column information for the OLTP transaction. If the cache includes the column information for the OLTP transaction, the method may include processing the OLTP transaction with the column information in the cache. If the cache does not include the column information for the OLTP transaction, the method may include selecting columns from the column-based storage of the database. | 06-19-2014 |
20140181002 | Systems and Methods for Implementing Virtual Cubes for Data Processing - System and methods are provided for processing a multi-dimensional data structure represented as multi-dimensional cubes. A first multi-dimensional cube and a second multi-dimensional cube are received, the first multi-dimensional cube including first cube property data and first user data, the second multi-dimensional cube including second cube property data and second user data. A virtual multi-dimensional cube including virtual cube property data for accessing and performing computer-based operations upon the first user data and the second user data are generated, the virtual cube property data including a first mapping from the first cube property data to the virtual cube property data and a second mapping from the second cube property data to the virtual cube property data. | 06-26-2014 |
20140181003 | COMMON DATA MODEL FOR IDENTITY ACCESS MANAGEMENT DATA - A data model for managing identity and access management (IAM) data implemented at an electronic database may include a set of logical resource elements, a set of physical resource elements, and a set of access requests elements that respectively model logical resources, physical resources, and access requests received at an access request manager of an enterprise. The physical resource elements may be respectively associated with the logical resource elements such that access rights for the physical resources may be obtained based on a logical resource specified in the access request. A system for managing IAM may include a mapping module configured to transform heterogeneous IAM data provided by a plurality of IAM data sources into homogeneous IAM data formatted according to the common IAM data format. A data store may implement the IAM data model such that the data store is configured to store the homogeneous IAM data. | 06-26-2014 |
20140188782 | IN-MEMORY RUNTIME FOR MULTIDIMENSIONAL ANALYTICAL VIEWS - A multi-dimensional analytical view (MDAV) calculation can be enhanced by use of an in-memory MDAV runtime at a search engine server. The in-memory MDAV runtime can perform all or some of the processing required to respond to a data request that requires some analytical processing. | 07-03-2014 |
20140201128 | SYSTEM AND METHOD FOR PROCESSING AND/OR ANALYZING OLAP BASED DATA ACCORDING TO ONE OR MORE PARAMETERS - A system and method for processing a base vector derived from data stored in an OLAP cube. The system comprises a component configured for defining a base vector and a comparison vector, wherein the comparison vector comprises one or more dimensions corresponding to dimensions of the base vector. The system includes a component configured for defining a time scope associated with the base vector. The system further comprises a component configured for performing one or more analysis operations on the comparison vector to generate comparison values and a component configured for rendering the base and comparison vectors. According to another aspect, the system includes a component for altering or modifying individual data cells in the base vector and/or parameters associated with the base vector and/or analysis operation. | 07-17-2014 |
20140214752 | DATA STREAM SPLITTING FOR LOW-LATENCY DATA ACCESS - Techniques for facilitating and accelerating log data processing by splitting data streams are disclosed herein. The front-end clusters generate large amount of log data in real time and transfer the log data to an aggregating cluster. The aggregating cluster is designed to aggregate incoming log data streams from different front-end servers and clusters. The aggregating cluster further splits the log data into a plurality of data streams so that the data streams are sent to a receiving application in parallel. In one embodiment, the log data are randomly split to ensure the log data are evenly distributed in the split data streams. In another embodiment, the application that receives the split data streams determines how to split the log data. | 07-31-2014 |
20140244569 | ADAPTIVE WAREHOUSE DATA VALIDATION TOOL - Techniques for data validation may include dynamically generating one or more database queries to be performed on a target data warehouse and a baseline data warehouse based on warehouse model metadata for the target data warehouse and the baseline data warehouse. The techniques may further include executing the one or more database queries against the target data warehouse and the baseline data warehouse to receive one or more data sets from the baseline data warehouse and one or more data sets from the target data warehouse. The techniques may further include comparing the one or more data sets from the baseline data warehouse and the one or more data sets from the target data warehouse to validate target data in the target data warehouse against baseline data in the baseline data warehouse. | 08-28-2014 |
20140250053 | MULTIDIMENSIONAL DATASET QUERY PROCESSING - A method of processing a query. The method comprises providing at least one multidimensional dataset having at least three dimensions formed according to a plurality of data tables associating between a plurality of persons and a plurality of roles and comprising a plurality of cells, receiving a query defining at least one factual value coordinated by at least one of the plurality of cells, the at least one factual value representing a measure defined in at least one of the plurality of data tables, deriving at least one person from the plurality of persons, the at least one person being associated with the with multidimensional dataset with the at least one cell, and outputting an indication of the at least one person in response to the query. | 09-04-2014 |
20140279823 | LIFECYCLE PRODUCT ANALYSIS - Metadata is obtained regarding a data system instance. The metadata is sent to a server in a multi-tenant data center. Analysis results are received that indicate the results of an analysis performed on the metadata by a tool at the multi-tenant data center. | 09-18-2014 |
20140279824 | TIME-SENSITIVE CUBE - A time-sensitive cube data system is disclosed in which time-sensitive and/or time-series data objects are output in response to a user's operations on a time-sensitive OLAP cube. The time-sensitive and/or time-series data objects output by the time-sensitive cube data system may be displayed to the user in any way that may be advantageous to the user's understanding. The time-series objects output by the time-sensitive cube data system are more helpful than a single snapshot, as a user is able to see data trends over time. | 09-18-2014 |
20140289182 | SYSTEM AND METHOD FOR A NEURAL METADATA FRAMEWORK - The embodiments herein provide a method and process for storing and provisioning system catalogue(s) of metadata object relationships, from diverse and disparate physical data elements. The method comprises the steps of creating a logical enterprise data warehouse by assembling a plurality of nanomart storage structures; visually mashingup a plurality of interconnected data elements from the plurality of nanomart storage structures to produce a business analytics; and generating a neural metadata framework for providing a mathematical model to abstract and catalogue the plurality of data elements from the plurality of nanomart storage structures. | 09-25-2014 |
20150019475 | OPERATIONAL BUSINESS INTELLIGENCE SYSTEM AND METHOD - An automated method of detecting and reporting exceptions to a plurality of real-world processes, designed to combine the real-time speeds of automated transaction processing systems with the in depth analysis of automated business intelligence systems. The system operates by storing input data in the form of process agnostic database system (PADS) objects, configured to accept data without limitation as to specific process, and design to allow flexible automated linking between various things, activities, and processes to any desired depth. The system operates by analyzing real-time input data against various exception criteria, thereby determining exception marked objects, and then using linkages between different PADS objects to immediately determine the impact of these exceptions on other activities and processes. The system can then estimate the severity of the impact, automatically notify users when an impact to even distantly connected processes are detected, and also estimate the severity of the impact. | 01-15-2015 |
20150032684 | GENERATING A MULTI-COLUMN INDEX FOR RELATIONAL DATABASES BY INTERLEAVING DATA BITS FOR SELECTIVITY - A multi-column index is generated based on an interleaving of data bits for selectivity for efficient processing of data in a relational database system. Two or more columns may be identified for inclusion in the multi-column index for a relational database table. Based, at least in part, on the interleaving of data bits for selectivity from the identified columns, a multi-column index is generated for the relational database table that provides a respective index value for each entry in the relational database table. The entries of the relational database table may then be stored according to the index values of the multi-column index. | 01-29-2015 |
20150039554 | TIME-SENSITIVE CUBE - A time-sensitive cube data system is disclosed in which time-sensitive and/or time-series data objects are output in response to a user's operations on a time-sensitive OLAP cube. The time-sensitive and/or time-series data objects output by the time-sensitive cube data system may be displayed to the user in any way that may be advantageous to the user's understanding. The time-series objects output by the time-sensitive cube data system are more helpful than a single snapshot, as a user is able to see data trends over time. | 02-05-2015 |
20150088805 | AUTOMATIC CACHING OF SCAN AND RANDOM ACCESS DATA IN COMPUTING SYSTEMS - Approaches, techniques, and mechanisms are disclosed for improved caching in database systems that deal with multiple data access patterns, such as in database systems that interface with both OLTP and Data Warehouse clients. A cache is deployed between a database server and a storage system that stores data units. Some of the data units accessed by the database server are buffered within the cache. The data units may be associated with data access patterns, such as a random data access pattern or a scan data access pattern, in accordance with which the database server is or appears to be accessing the data units. A processor selects when to cache data units accessed by the database server, based at least on the associated data access patterns. Recent access counts may also be stored for the data units, and may further be utilized to select when to cache data units. | 03-26-2015 |
20150106325 | DISTRIBUTED STORAGE OF AGGREGATED DATA - Techniques are described for managing aggregation of data in a distributed manner, such as for a particular client based on specified configuration information. The described techniques may include storing aggregated data values for an OLAP cube or other data structure in a distributed manner, such as in some situations in a distributed hash table. The aggregated data values to be stored may be generated in various manners, such as by performing multi-stage data manipulation operations—for example, a map-reduce architecture may be used, with a first stage involving the use of one or more specified map functions to be performed, and with at least a second stage involving the use of one or more specified reduce functions to be performed. | 04-16-2015 |
20150149400 | Method and Apparatus for Monitoring an In-memory Computer System - An in-memory computing system for conducting on-line transaction processing and on-line analytical processing includes system tables in main memory to store runtime information. A statistics services can access the runtime information using script procedures stored in the main memory to collect monitoring data and generate historical data and other system performance metrics while maintaining the runtime data and generated data in the main memory. | 05-28-2015 |
20150370881 | DYNAMIC N-DIMENSIONAL CUBES FOR HOSTED ANALYTICS - An online analytical processing system may comprise an n-dimensional cube structured using slice-based partitioning in which each slice comprises one or more hierarchies of data points. A region of a hierarchy may be classified according to computational demands associated with the region. A scaling or replication mechanism may be applied to the region based on the computational demands associated with that region. | 12-24-2015 |
20150370882 | USE OF DEPENDENCY GRAPHS TO DYNAMICALLY UPDATE N-DIMENSIONAL CUBES - An online analytical processing system may comprise an n-dimensional cube structured using slice-based partitioning in which each slice comprises data points corresponding to a set of dimension values fixed across the slice and a set of dimension values allowed to vary. Slices may be partitioned and replicated across computing nodes. Views of the n-dimensional cube may be partially materialized by determining dependencies between slices. A central data dictionary may maintain information about slices and slice dependencies. Dimensions may be added by adding a new slice without requiring immediate recomputation of existing data points. | 12-24-2015 |
20150370883 | DATA INTEREST ESTIMATION FOR N-DIMENSIONAL CUBE COMPUTATIONS - An online analytical processing system may comprise an n-dimensional cube partitioned into slices, in which each slice may represent data points at the intersections of fixed and variable dimensions. Computation of data points within a slice may be deferred. A dependency graph may be initially constructed, in which the dependency graph is utilized in a subsequent computation. Calculation of data points may be prioritized based on information indicative of a chance that the data points will be accessed. | 12-24-2015 |
20150379080 | DYNAMIC SELECTION OF SOURCE TABLE FOR DB ROLLUP AGGREGATION AND QUERY REWRITE BASED ON MODEL DRIVEN DEFINITIONS AND CARDINALITY ESTIMATES - A method for optimizing data access in a data warehouse having a model driven architecture is provided. A data model for storing time series measurement data representing a plurality of dimensions and measurements is received. The data model includes one or more aggregation tables. A query having one or more predicates is received from a user. The one or more predicates are analyzed to determine whether the received query can be optimized using the existing aggregation tables. The received query is optimized using the aggregation tables, in response to determining that such query optimization is possible. | 12-31-2015 |
20150379108 | Data Mining in a Business Intelligence Document - A business intelligence document provides functionality for testing a hypothesis on aggregated data in a business intelligence document (e.g., a spreadsheet-like document), wherein one or more of the input data values and transformation properties are designated as constrained (e.g., invariant or constrained within a range, set, enumeration, or domain). The hypothesis, which is articulated as a data mining assertion, is input through the user interface of the business intelligence document (e.g., via an expression interface or properties of a row, column, or cell) and solved over the aggregated data. The solution is then presented through the user interface of the spreadsheet-like document, such as in a table, graph, histogram, etc. | 12-31-2015 |
20160055229 | METHOD AND APPARATUS FOR STRESS MANAGEMENT IN A SEARCHABLE DATA SERVICE - Method and apparatus for stress management in a searchable data service. The searchable data service may provide a searchable index to a backend data store, and an interface to build and query the searchable index, that enables client applications to search for and retrieve locators for stored entities in the backend data store. Embodiments of the searchable data service may implement a distributed stress management mechanism that may provide functionality including, but not limited to, the automated monitoring of critical resources, analysis of resource usage, and decisions on and performance of actions to keep resource usage within comfort zones. In one embodiment, in response to usage of a particular resource being detected as out of the comfort zone on a node, an action may be performed to transfer at least part of the resource usage for the local resource to another node that provides a similar resource. | 02-25-2016 |
20160078070 | DATABASE TABLE COLUMN ANNOTATION - According to an example, database constraint generation may include receiving data related to a table in a database, analyzing the data to determine a row count for a column of the table, and analyzing the data to determine a number of distinct values for the column of the table. A comparison value may be determined by comparing the row count to the number of distinct values. The database constraint generation may further include determining if the comparison value is within a threshold. If the comparison value is within the threshold, an annotation may be added to the column of the table such that the column is considered unique during a cardinality estimation process involving the table. | 03-17-2016 |
20160092542 | SYSTEM AND METHOD FOR DYNAMIC DATABASE SPLIT GENERATION IN A MASSIVELY PARALLEL OR DISTRIBUTED DATABASE ENVIRONMENT - A system and method is described for database split generation in a massively parallel or other distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table. | 03-31-2016 |
20160092543 | SYSTEM AND METHOD FOR GENERATING SIZE-BASED SPLITS IN A MASSIVELY PARALLEL OR DISTRIBUTED DATABASE ENVIRONMENT - A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table. | 03-31-2016 |
20160092544 | SYSTEM AND METHOD FOR GENERATING ROWID RANGE-BASED SPLITS IN A MASSIVELY PARALLEL OR DISTRIBUTED DATABASE ENVIRONMENT - A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table. | 03-31-2016 |
20160092545 | SYSTEM AND METHOD FOR GENERATING PARTITION-BASED SPLITS IN A MASSIVELY PARALLEL OR DISTRIBUTED DATABASE ENVIRONMENT - A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table. | 03-31-2016 |
20160092546 | SYSTEM AND METHOD FOR QUERY PROCESSING WITH TABLE-LEVEL PREDICATE PUSHDOWN IN A MASSIVELY PARALLEL OR DISTRIBUTED DATABASE ENVIRONMENT - A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table. | 03-31-2016 |
20160092547 | SYSTEM AND METHOD FOR EFFICIENT CONNECTION MANAGEMENT IN A MASSIVELY PARALLEL OR DISTRIBUTED DATABASE ENVIRONMENT - A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table. | 03-31-2016 |
20160092548 | SYSTEM AND METHOD FOR CONSISTENT READS BETWEEN TASKS IN A MASSIVELY PARALLEL OR DISTRIBUTED DATABASE ENVIRONMENT - A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table. | 03-31-2016 |
20160098460 | SCALABLE COMPUTATION OF DATA - Techniques for producing a cross tabulation are described. The techniques involve issuing a plurality of queries to a database. The queries are for each of at least one sublevel of data for each of at least one dimension of data associated with records in the database. The queries provide sublists of sorted identifiers for each one of the queries. The technique determines occurrences of intersections of levels of one dimension with levels of another dimension of the data associated with records in the database by traversing the sublists to detect intersections of the dimensions. | 04-07-2016 |
20160110439 | DATABASE MANAGEMENT SYSTEM AND METHOD OF OPERATION - A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database. | 04-21-2016 |
20160132576 | HIGH AVAILABILITY AND DISASTER RECOVERY IN LARGE-SCALE DATA WAREHOUSE - Techniques and mechanisms described herein facilitate the management of data centers. According to various embodiments, a first query dispatcher at a first data center may be disabled. The first data center may include a first data cluster and a first database. The first query dispatcher may be configured to dispatch queries to access data in the first data cluster and in a second data cluster at a second data center. The second data cluster may replicate data stored in the first data cluster. Metadata stored in the first database may be replicated to a second database in the second data center. The metadata may describe a state of the first data cluster. A second query dispatcher may be enabled at the second data center. The second query dispatcher may be configured to dispatch queries to access data in the second data cluster. | 05-12-2016 |
20160147804 | FORCED ORDERING OF A DICTIONARY STORING ROW IDENTIFIER VALUES - The subject matter disclosed herein provides methods for the forced ordering of a dictionary based on row identifier values. A plurality of concurrent transactions can be handled in an in-memory database. At least one of the transactions can include at least one write operation to a dictionary. Each write operation can be assigned a row identifier (ID). At least one of the write operations can be written to the dictionary out of sequence. The sequence can be based on the row ID. Each row ID in the dictionary can be mapped to a corresponding value identifier in the dictionary. The dictionary can position the value identifiers so that the corresponding row IDs are in a sorted sequential order based on the row ID. Related apparatus, systems, techniques, and articles are also described. | 05-26-2016 |
20160147814 | In-Memory Database System Providing Lockless Read and Write Operations for OLAP and OLTP Transactions - As part of a database system comprising a combination of on-disk storage and in-memory storage, a plurality of records that comprise a table are stored in a plurality of fragments that include at least a delta fragment and a main fragment retained in the on-disk storage. Each fragment has visibility data structures to enable multi-version concurrency control. Each fragment can be compressed using dictionary compression and n-bits compression. The fragments are loaded into main system memory in the in-memory storage from the on-disk storage if they are accessed for read operations or write operations and are not already in memory. A plurality of lockless read and write operations are concurrently performed, while providing snapshot isolation, on the at least one of the plurality of fragments while the at least one of the plurality of fragments is in the main system memory. | 05-26-2016 |
20160154779 | AUTOMATIC MODELING OF COLUMN AND PIVOT TABLE LAYOUT TABULAR DATA | 06-02-2016 |
20160154873 | MODELING RECURRING EVENTS IN A DATA STORE | 06-02-2016 |
20160203204 | GENERATING A VIRTUAL DYNAMIC REPRESENTATIVE OF A TAXONOMIC GROUP WITH UNIQUE INHERITANCE OF ATTRIBUTES | 07-14-2016 |
20180025035 | TOPOLOGICAL DATA ANALYSIS OF DATA FROM A FACT TABLE AND RELATED DIMENSION TABLES | 01-25-2018 |
20220138214 | SYSTEMS AND METHODS FOR PROVIDING ANALYTICS REGARDING A PLURALITY OF OBJECT PROCESSING SYSTEMS - An analytics system is disclosed for providing real time analytical data regarding operational characteristics of a plurality of object processing systems that process objects. The analytics system includes a communication system for accessing the warehouse management system and for obtaining object specific data, a data collection system for receiving real time data regarding processing at each of the plurality of object processing systems, each of the plurality of object processing systems including a programmable motion device that is programmed to process objects independent of other of the plurality of processing systems, an integration system for integrating the real time data with the object assignment data, and a graphic display system for displaying the real time data as associated with the assignment data. | 05-05-2022 |