Data Warehouse, Data Mart, Online Analytical Processing (olap), Decision Support Systems Patents (Class 707/600)
  • Publication number: 20140040433
    Abstract: In accordance with embodiments, there are provided mechanisms for facilitating real-time streaming, filtering and routing of data according to one embodiment. In one embodiment and by way of example, a method includes receiving, at a computing device, one or more data streams from one or more data sources, transforming, in real-time, the one or more data streams into one or more normalized data streams. The transforming includes performing ingestion of the one or more data streams. The method may further include filtering, in real-time, the one or more normalized data streams, and routing the one or more filtered data streams as real-time output to one or more data systems.
    Type: Application
    Filed: July 30, 2013
    Publication date: February 6, 2014
    Applicant: Talksum, Inc.
    Inventors: DANIEL DALE RUSSELL, JR., Brian C. Knox
  • Patent number: 8645313
    Abstract: A system and method for indexing non-uniquely indexed entries in a report generated with a business intelligence system, such as, for example, an on-line analytical processing (OLAP) system. A dummy index is added to each index element returned in the report. Non-unique index elements receive different dummy indices to distinguish otherwise identical row elements. The dummy index is added to a base template and optionally also to a view template of a report generator of the OLAP system.
    Type: Grant
    Filed: May 27, 2005
    Date of Patent: February 4, 2014
    Assignee: Microstrategy, Inc.
    Inventors: Benjamin Li, Xinyi Wang, Xiaonan Han, Daniel Kerzner, Hanijanto Soewandi
  • Publication number: 20140032477
    Abstract: 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.
    Type: Application
    Filed: April 11, 2008
    Publication date: January 30, 2014
    Applicant: Adobe Systems incorporated
    Inventors: John Trammel, Mike De Laurentis
  • Patent number: 8631042
    Abstract: Methods and apparatus, including computer program products, implementing and using techniques for analyzing historical data in a data warehouse. A data warehouse is provided. The data warehouse includes several database tables. Every database table has a start time column and an end time column. A query is issued to the data warehouse. The query includes customized query predicates against the start time column values and end time column values of a database table. A response is received from the data warehouse. The response includes table records satisfying the query and having valid (START_TIME, END_TIME) ranges that cover a fixed time point specified by the customized query predicates of the query. Methods for updating a database table in a data warehouse, and a data warehouse system are also described.
    Type: Grant
    Filed: June 3, 2008
    Date of Patent: January 14, 2014
    Assignee: International Business Machines Corporation
    Inventor: Jian Le
  • Patent number: 8626702
    Abstract: Validation of an extraction process from an operation system to an on-line analytics and processing (“OLAP”) system may be achieved utilizing a function module that reads data from a queue and outputs the data in a structured form. A second function module may be used to perform an existence and uniqueness check on the data to determine the existence and/or uniqueness of various data elements.
    Type: Grant
    Filed: December 27, 2006
    Date of Patent: January 7, 2014
    Assignee: SAP AG
    Inventors: Markus Schlueter, Peter Karlheinz Zimmerer, Harald Fey
  • Patent number: 8626703
    Abstract: 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.
    Type: Grant
    Filed: December 17, 2010
    Date of Patent: January 7, 2014
    Assignee: Verizon Patent and Licensing Inc.
    Inventors: Fari Ebrahimi, Shankar Harihara, Walid Hassan, Tereasa Walker, Thillai Ponnambalam, Solleti Prakash Sreekanth, Indu Mohan Babu Nori
  • Publication number: 20130346359
    Abstract: 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.
    Type: Application
    Filed: July 25, 2012
    Publication date: December 26, 2013
    Inventors: Ligang Lu, Michael Peter Perrone
  • Patent number: 8615587
    Abstract: A data query instruction for execution is received, 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, which of the number of data servers are to receive or transmit data as part of the data transfer is identified; for each of the identified data servers, a minimum number of the at least two data links that are needed for the data transfer are identified; and if inactive, the minimum number of the at least two data links for each of the identified data servers are activated.
    Type: Grant
    Filed: January 11, 2011
    Date of Patent: December 24, 2013
    Assignee: International Business Machines Corporation
    Inventors: Gaurav Mehrotra, Laurent S. Mignet, Abhinay R. Nagpal, Sandeep R. Patil
  • Patent number: 8615590
    Abstract: 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.
    Type: Grant
    Filed: April 20, 2012
    Date of Patent: December 24, 2013
    Assignee: International Business Machines Corporation
    Inventors: Gaurav Mehrotra, Laurent S. Mignet, Abhinay R. Nagpal, Sandeep R. Patil
  • Patent number: 8600929
    Abstract: A method and computer system for aggregating data from a plurality of operational databases are provided. It is determined if a transformation script stored in storage of a computer system has been modified. Delta data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified. All data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified.
    Type: Grant
    Filed: March 30, 2010
    Date of Patent: December 3, 2013
    Assignee: Trapeze Software Inc.
    Inventor: Chacko Kattithara Paul
  • Patent number: 8601112
    Abstract: A system for collecting and processing time-series data from a plurality of data source computers comprises a plurality of computer-implemented partitions and a plurality of computer implemented nodes which own respective ones of the partitions. The plurality of computer-implemented partitions comprise a plurality of processes configured to produce the desired outputs. The plurality of partitions are configured (i) to permit each of the data messages to be received at an arbitrary one of the plurality of nodes, and (ii) to forward the received data message to one or more of the plurality of nodes which own respective ones of the plurality of partitions responsible for participating in producing one of the desired outputs.
    Type: Grant
    Filed: March 14, 2006
    Date of Patent: December 3, 2013
    Assignee: Amazon Technologies, Inc.
    Inventors: Paul G. Nordstrom, Aaron C. Thompson
  • Publication number: 20130318030
    Abstract: A central data warehouse includes embedded data marts. These embedded data marts, referred to as workspaces, are assigned centrally manage data by reference only but rely directly on the centrally managed data and the underlying infrastructure. Workspaces still allow departments in an enterprise to perform certain actions on their own (like adding new data and building new models) without having to instantiate copies of the centrally managed data in a locally managed data mart.
    Type: Application
    Filed: May 23, 2012
    Publication date: November 28, 2013
    Applicant: SAP AG
    Inventors: Klaus Nagel, Rainer Schaefer, Silvia Bratz, Marcus Hoepfner, Patrick Winkler, Matthias Jensen, Dirk Janning
  • Patent number: 8595181
    Abstract: The present invention is directed to methods and systems for rendering perceivable stimuli representative of information processing by a multi-tenant architecture that pre-fetches a portion of a subset of data on a multi-tenant architecture and emulates a result set of data in accordance with a report definition. To that end the method comprises identifying a subset of data on the multi-tenant architecture that is subject to a report definition. A portion of the subset is pre-fetched and analyzed to emulate a result. The emulated result is transmitted to a computer system of a user of the multi-tenant architecture. Perceivable stimuli is generated on the user computer system, in response to receiving the emulated result.
    Type: Grant
    Filed: April 25, 2011
    Date of Patent: November 26, 2013
    Assignee: salesforce.com, inc.
    Inventor: Guillaume Le Stum
  • Patent number: 8589335
    Abstract: A personalization of a batch of smart cards is provided. A user is provided with a plurality of queries regarding smart card features. Responses to the plurality of queries are received from the user. A personalization data file is generated using the responses to the plurality of queries, where the personalization data file comprises values, which may be used to provide features on a batch of smart cards.
    Type: Grant
    Filed: July 31, 2003
    Date of Patent: November 19, 2013
    Assignee: Visa International Service Association
    Inventors: Carl Smith, Trudy Hill
  • Patent number: 8583616
    Abstract: A method for managing storage and access to data files stored in a storage delivery network comprising a plurality of geographically distributed storage nodes, the method including: receiving a file request from a user, wherein the user is associated with a service level agreement (SLA) containing one or more policies governing handling of file requests from the user; determining if the SLA dictates redirecting the file request to a predetermined storage node; if the SLA dictates redirecting the file request to a predetermined storage node, redirecting the file request to the predetermined storage node; otherwise, identifying all storage nodes from the plurality of geographically distributed storage nodes that are not too busy by determining whether a number of current access requests being served by each storage node exceeds a predetermined threshold value; identifying a nearest storage node from among the not too busy storage nodes; and redirecting the user request to the nearest storage node.
    Type: Grant
    Filed: October 19, 2012
    Date of Patent: November 12, 2013
    Assignee: Nirvanix, Inc.
    Inventors: Scott P. Chatley, Gabriel Gallagher, Thanh T. Phan, Troy C. Gatchell
  • Patent number: 8583589
    Abstract: Systems, methods, and other embodiments associated with equivalence reasoning are described. One example method includes constructing a clique map that maps groups of equivalent resources to a representative canonical resource. The clique map is constructed by iteratively inputting batches of equivalence pairs from a semantic model to operating memory and building, in operating memory, one or more cliques for the input batch. Cliques for various input batches of equivalence pairs are merged in memory to produce the clique map for use by the semantic model. Triples associated with the semantic model may be consolidated by replacing resources that are in a clique with their corresponding representative canonical resource.
    Type: Grant
    Filed: October 6, 2009
    Date of Patent: November 12, 2013
    Assignee: Oracle International Corporation
    Inventors: Vladimir Kolovski, Zhe Wu, George Eadon
  • Patent number: 8584140
    Abstract: Systems and methods for receiving and sending messages about changes to data attributes are described. A message that includes all common data attributes associated with a first reference object is received. The data attributes in the message are mapped to common data attributes in a second reference object. The type of the message is determined, where the message is either a synchronization message or a key change message. The common data attributes in the second reference object are updated to match the common data attributes in the first reference object if the message is a synchronization message. A unique data attribute in the second reference object is updated if the message is a key change message.
    Type: Grant
    Filed: September 19, 2008
    Date of Patent: November 12, 2013
    Assignee: PresenceID, Inc.
    Inventors: Douglas Jock Walker, Reinier Van Ommeren
  • Patent number: 8577823
    Abstract: The present invention provides taxonomy system for enterprise data management and analysis. Building a taxonomy is based on defining taxonomy themes to solve different aspects of enterprise data management. For each theme, a taxonomy is created by classifying data related to the theme. Taxonomy nodes include enterprise data management policies and data analysis methods to be applied to data stored at the nodes. The amount of data that companies need to access and manage today is complex and voluminous. Because of computational requirements and time constraints, it is very difficult to classify and process all data. In many cases, current solutions ignore a sizable amount of data and process a small subset of it. This leads to incomplete and inaccurate results as ignored data may contain valuable information. The present invention provides taxonomies that encompass all data. Voluminous data is processed first to eliminate irrelevant data that is not related to the theme of a taxonomy.
    Type: Grant
    Filed: June 1, 2011
    Date of Patent: November 5, 2013
    Inventor: Omar M. A. Gadir
  • Patent number: 8577910
    Abstract: Methods, systems, and apparatus, including computer program products, for generating visual media search results are provided. A search query in a first language is received. A plurality of languages are identified. It is determined whether a language should be selected by translating the search query into translated terms in the language, determining a score for each translated term measuring how common the translated term is, and using the scores to determine if the language should be selected. A second language is selected from the plurality of different languages by selecting the considered language if it should be selected and otherwise selecting the second language according to a criterion. A set of one or more search results are generated based on the search query and a translation of the search query into the second language. The results are ordered based on a quality of results statistic for the translated query.
    Type: Grant
    Filed: June 9, 2009
    Date of Patent: November 5, 2013
    Assignee: Google Inc.
    Inventors: Vanessa Hodge, Kevin Law, Radhika Malpani, Gaurav Garg
  • Publication number: 20130290242
    Abstract: 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.
    Type: Application
    Filed: August 11, 2010
    Publication date: October 31, 2013
    Inventor: Naohiro Suzuki
  • Patent number: 8572020
    Abstract: 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.
    Type: Grant
    Filed: August 23, 2012
    Date of Patent: October 29, 2013
    Assignee: Facebook, Inc.
    Inventors: Alexander Tuzhilin, Gediminas Adomavicius
  • Patent number: 8566361
    Abstract: 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.
    Type: Grant
    Filed: December 9, 2011
    Date of Patent: October 22, 2013
    Assignee: Delphix Corp.
    Inventors: Charles Li Zha, Jedidiah Yueh, Alok Kumar Srivastava
  • Patent number: 8566903
    Abstract: A controller is configured to generate and propagate instructions to an execution agent which, in turn, is configured to collect and deposit collected artifacts into a repository. Write access to a location in the repository for collected artifacts that are to be deposited into a specified location is granted to the execution agent. Once the execution agent deposits the collected artifacts in the specified location in the repository, a summary of collected artifacts is propagated to the controller. The controller manages appropriate levels of access to the collected artifacts, while the repository enforces the level of access. The controller can grant read only access to the collected artifacts or it can allow for controlled changes to be made to the metadata associated with the collected artifact. An agent processes the data and generates additional metadata that can be associated with the collected artifacts and then saved in the repository.
    Type: Grant
    Filed: June 29, 2010
    Date of Patent: October 22, 2013
    Assignee: International Business Machines Corporation
    Inventors: Roman Kisin, Pierre Raynaud-Richard
  • Patent number: 8564818
    Abstract: An image forming apparatus transmits a log notification request to a server before log transmission. The server responds to the image forming apparatus by appropriately performing scheduling of a log transmission time to disperse a load. The image forming apparatus transmits a log at a time designated by the server.
    Type: Grant
    Filed: December 14, 2010
    Date of Patent: October 22, 2013
    Assignee: Canon Kabushiki Kaisha
    Inventor: Tadahiro Nakamura
  • Patent number: 8560530
    Abstract: Methods, apparatus, and articles of manufacture to rank a web site are disclosed herein. An example method to rank the influence of a web site involves receiving a topic term, filtering out a post that is not relevant to the topic term from a first plurality of posts to a web site, determining a number of inbound links to the web site based on the topic term, determining a time between the inbound links to the web site based on the topic term, and generating a rank of the web site based on the number of inbound links and the time between the inbound links.
    Type: Grant
    Filed: June 15, 2010
    Date of Patent: October 15, 2013
    Assignee: BuzzMetrics, Ltd.
    Inventors: Yakir Krichman, Eliyahu Greitzer
  • Patent number: 8560482
    Abstract: A virtual technical networking architecture is disclosed that allows a user to locate resources, seek expertise and collaborate with identified experts located within a virtual city in order to mentor, teach and resolve problems or fill a need. The virtual city offers a gaming technology environment to users, wherein the users and experts are depicted as avatars within the virtual city and different levels of expertise and different affiliations are identified by different avatar accessories. The virtual city connects users for learning and problem resolution and also recognizes the accomplishments of experts and memorializes these accomplishments in the virtual city. Accordingly, an entire city of experts in a wide variety of fields can be built, that brings large groups of people and resources together for intellectual capital and knowledge management. The virtual city can then be used to educate, train and disseminate information.
    Type: Grant
    Filed: December 7, 2010
    Date of Patent: October 15, 2013
    Assignee: Alphaport, Inc.
    Inventors: Anthony John Miranda, Jennifer Jones, Rosella Miranda, Giuseppe G. Miranda
  • Patent number: 8548827
    Abstract: The invention relates to a computer-implemented method for medical diagnosis support for patient data of a patient through a data processing system, wherein the data processing system comprises a graphical user interface and a database containing rules for calculating diagnosis risks.
    Type: Grant
    Filed: November 17, 2009
    Date of Patent: October 1, 2013
    Assignee: CompuGroup Medical AG
    Inventors: Frank Gotthardt, Dierk Helmann
  • Patent number: 8543534
    Abstract: An event server running an event driven application implementing an event processing network. The event processing network can include at least one processor to implement a rule on at least one input stream. The event processing network can define concurrent operation of at least two components of the event processing networks.
    Type: Grant
    Filed: June 4, 2008
    Date of Patent: September 24, 2013
    Assignee: Oracle International Corporation
    Inventors: Alexandre de Castro Alves, Dana Bergen, Andrew Piper
  • Publication number: 20130246336
    Abstract: 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.
    Type: Application
    Filed: December 27, 2011
    Publication date: September 19, 2013
    Inventors: Ratinder Paul Singh Ahuja, Bimalesh Jha, Nitin Maini, Sujata Patel, Ankit R. Jain, Damodar K. Hegde, Rajaram V. Nanganure, Avinash Vishnu Pawar
  • Publication number: 20130246335
    Abstract: 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.
    Type: Application
    Filed: December 27, 2011
    Publication date: September 19, 2013
    Inventors: Ratinder Paul Singh Ahuja, Bimalesh Jha, Nitin Maini, Sujata Patel, Ankit R. Jain, Damodar K. Hegde, Rajaram V. Nanganure, Avinash Vishnu Pawar
  • Publication number: 20130246334
    Abstract: 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.
    Type: Application
    Filed: December 27, 2011
    Publication date: September 19, 2013
    Inventors: Ratinder Paul Singh Ahuja, Bimalesh Jha, Nitin Maini, Sujata Patel, Ankit R. Jain, Damodar K. Hegde, Rajaram V. Nanganure, Avinash Vishnu Pawar
  • Patent number: 8538990
    Abstract: 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.
    Type: Grant
    Filed: March 4, 2011
    Date of Patent: September 17, 2013
    Assignee: International Business Machines Corporation
    Inventors: Kirk Arthur Bates, Rasmus Borgsmidt, David Stephen Lawrence Bowen
  • Patent number: 8538920
    Abstract: A storage service stores data from a network device. A data collector retrieves the data for the storage service based on reference data passed to the storage service from the network device.
    Type: Grant
    Filed: August 8, 2011
    Date of Patent: September 17, 2013
    Assignee: Hewlett-Packard Development Company, L.P.
    Inventor: Dana E. Laursen
  • Publication number: 20130238547
    Abstract: 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.
    Type: Application
    Filed: April 29, 2013
    Publication date: September 12, 2013
    Applicant: AT&T Intellectual Property I, L.P.
    Inventors: Theodore Johnson, Vladislav Shkapenyuk, Lukasz Golab
  • Publication number: 20130238548
    Abstract: Systems and apparatuses are provided for integrating user defined functions into an analytical data processing framework. A query compiler (22) identifies a call to a user defined function (28) and one of a GROUP BY expression and a defined online analytics processing (OLAP) window associated with the user defined function. A database engine (24) executes the user defined function (28) with a partition set defined by the one of the GROUP BY expression and the defined OLAP window, such that the user defined function operates on the partition set to produce a function output.
    Type: Application
    Filed: January 25, 2011
    Publication date: September 12, 2013
    Inventor: Muthian George
  • Patent number: 8533167
    Abstract: A cardinality of an incoming data stream is maintained in real time; the cardinality is maintained in a data structure that is represented by an unsorted list at low cardinalities, a linear counter at medium cardinalities, and a PCSA at high cardinalities. The conversion to the linear counter makes use of the data in the unsorted list, after which that data is discarded. The conversion to the PCSA uses only the data in the linear counter.
    Type: Grant
    Filed: January 17, 2013
    Date of Patent: September 10, 2013
    Assignee: Guavus, Inc.
    Inventors: Nikhil Shirish Ketkar, Gaurav Mishra, Jaskaran Singh Bawa, Mark Crovella
  • Patent number: 8527518
    Abstract: A search query for a collection of electronic documents is parsed to identify one or more terms and such identified terms are associated with one or more languages (i.e., spoken languages such as English, German, Spanish, etc.). A terms inverted index and a language inverted index are accessed to identify documents responsive to the query. Related apparatus, systems, techniques and articles are also described.
    Type: Grant
    Filed: December 16, 2010
    Date of Patent: September 3, 2013
    Assignee: SAP AG
    Inventors: Frederik Transier, Holger Schwedes, Wolfgang Stephan, Thomas Peh
  • Publication number: 20130226860
    Abstract: 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.
    Type: Application
    Filed: April 11, 2013
    Publication date: August 29, 2013
    Applicant: Platfora, Inc.
    Inventor: Platfora, Inc.
  • Patent number: 8520554
    Abstract: Implementing a standardized interpretive engine includes externalizing a business requirement into a component class of a data control structure, defining a solution to the business requirement, entering the solution into metadata within the component class, and pulling data from a data warehouse into the component class based upon the business requirement. Pulling the data includes aggregating sub-tending data from the data warehouse. The aggregation is specified to a level requested via the component class. Implementing the standardized interpretive engine also includes performing a calculation on the data in accordance with the business requirement. The data is pulled away from the data warehouse and forward to the component class, such that a single data source associated with the data is usable multiple times for a plurality of component classes.
    Type: Grant
    Filed: May 23, 2012
    Date of Patent: August 27, 2013
    Assignee: AT&T Intellectual Property I, L.P.
    Inventor: Ronald Boggs
  • Patent number: 8515889
    Abstract: Methods and systems for trend aware self-correcting entity relationship extraction are disclosed. For example, a method can include receiving a selected entity, determining a plurality of entities related to the selected entity, determining a plurality of most probable entities, calculating relevance scores, and displaying a subset of the plurality of most probable entities. The selected entity can be received on a network-based transaction system. The plurality of entities related to the selected entity can be determined based on a relationship score. The relationship score can represent navigation transitions, aggregated over time, between the selected entity and each of the plurality of entities. The plurality of most probable entities can be determined based on probabilities. Relevance scores can be calculated for each of the plurality of most probable entities. Finally, the subset of the plurality of most probable entities to be displayed can be determined according to the relevance scores.
    Type: Grant
    Filed: March 23, 2011
    Date of Patent: August 20, 2013
    Assignee: eBay Inc.
    Inventor: Ayon Sinha
  • Patent number: 8515897
    Abstract: A method and program product for automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model (UIAM). A Multidimensional Expressions (MDX) query is generated based on a user visit to a business intelligence application. Based on initial user visit(s), a cube-based UIAM is constructed by including a representation of a first set of user interest(s) in a first set of UIAM item(s). The cube-based UIAM is transformed into a data warehouse-based UIAM. Based on subsequent user visit(s), UIAM items are updated to represent a second set of user interest(s) and UIAM item scores are adjusted to specify how frequently and recently user interests are indicated by the user visits. An update of data in the data warehouse is detected. Reports representative of user interest(s) represented by the updated UIAM items having the top k scores are generated.
    Type: Grant
    Filed: January 4, 2011
    Date of Patent: August 20, 2013
    Assignee: International Business Machines Corporation
    Inventors: Xue F. Gao, Anh Q. Lu
  • Publication number: 20130191323
    Abstract: A method and system for determining a context of a web-page containing a plurality of multimedia content elements. The method comprises receiving a uniform resource locator (URL) of the web-page; downloading the web-page respective of the received URL; analyzing the web-page to identify the existence of each of the plurality of multimedia content elements; generating at least one signature for each of the plurality of multimedia content elements, wherein each of the generated signatures represents a concept; and correlating the concepts respective of the generated signatures to determine the context of each of the plurality of multimedia content elements, thereby determining the context of the web-page.
    Type: Application
    Filed: February 19, 2013
    Publication date: July 25, 2013
    Applicant: CORTICA, LTD.
    Inventor: Cortica, Ltd
  • Patent number: 8494996
    Abstract: An embodiment of the invention comprises, providing an initial object graph to a database, the initial object graph being generated by applying a set of rules to resources included in a resource set at a specified time, or by revising a previous object graph at the previous time, the resource set at the specified time comprising an initial resource set. The method includes providing the initial object graph to a working memory, maintained in separation from the database; discovering a changed fact associated with one of the resources of the initial resource set; and upon discovering the changed fact, determining modifications required by the changed fact to the initial object graph. If modifications are required, the initial object graph is revised in the working memory to include such modifications. The same revisions are then made to the initial object graph in the system database.
    Type: Grant
    Filed: June 23, 2010
    Date of Patent: July 23, 2013
    Assignee: International Business Machines Corporation
    Inventors: Robert J. McKeown, Michael D. Uftring
  • Patent number: 8495004
    Abstract: Determining and storing at least one validated results set in a global ontology database for future use by an entity that subscribes to the global ontology database. If global ontology data is stored in a global ontology database, attempt to determine a mapping between first and second ontologies. If a mapping between the first and second ontologies can be determined from the global ontology data, the mapping is validated and the validated mapping is defined as a validated results set. If global ontology data is not stored in a global ontology database or a mapping between the first and second ontologies can not be determined from global ontology data stored in the global ontology database, the first and second ontologies are unified by determining a mapping between the first and second ontologies, the mapping is validated and the validated mapping is defined as a validated results set.
    Type: Grant
    Filed: March 27, 2006
    Date of Patent: July 23, 2013
    Assignee: International Business Machines Corporation
    Inventors: Vijay Dheap, Baiju D. Mandalia
  • Patent number: 8495176
    Abstract: A content management system (CMS) includes a value-add application with a first set of XML content services, one or more dedicated XML processing servers with a second and other sets of XML content services, and a core CMS with a third set of XML content services. The content management system may be designed to provide XML content services at any of these three tiers of processing. A first threshold is defined that allows the value-add application to determine when to offload XML content services to a dedicated XML processing server. A second threshold is defined that allows the core CMS to determine when to offload XML content services to a dedicated XML processing server. Callback services are included that allow each tier of XML content services to send or receive additional information to complete the XML processing. The result is a content management system that is very powerful and flexible.
    Type: Grant
    Filed: August 18, 2010
    Date of Patent: July 23, 2013
    Assignee: International Business Machines Corporation
    Inventors: David G. Herbeck, John E. Petri
  • Publication number: 20130185248
    Abstract: 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.
    Type: Application
    Filed: December 20, 2012
    Publication date: July 18, 2013
    Applicant: SKYTIDE, INC.
    Inventors: NAT WYATT, JOSEPH E. ROZENFELD
  • Patent number: 8489544
    Abstract: A computer enabled system and method aggregates data describing a particular subject. The data is then divided into a predetermined group of categories which are graphically displayed according to a predetermined pattern. Distortions in the data or anomalies in the data are made visually apparent. Associated with the display is a prioritized array of interventions recommended in response to the distortions in the data or anomalies appearing in the data.
    Type: Grant
    Filed: June 4, 2008
    Date of Patent: July 16, 2013
    Inventor: John P. Ford
  • Patent number: 8489541
    Abstract: A system and method for enabling a Meta Object Facility (MOF) and a Java Metadata Interface (JMI) compliant service to access program resources. A system includes a metamodel repository and an application server. The metamodel repository is configured to store the program resources including metadata and one or more metamodels. The application server includes at least one application providing a first portion of the program resources. A first portion of the program resources are stored in a database associated with the application server. A second portion of the program resources are provided in at least one application of the application server, and programming language instances of the program resources are received by one or more applications independent of where the program resources are stored or provided.
    Type: Grant
    Filed: June 13, 2008
    Date of Patent: July 16, 2013
    Assignee: SAP AG
    Inventor: Christian Muenkel
  • Patent number: 8489542
    Abstract: Content objects may be incorporated as metadata in application systems in the same programming environment used to create the rest of the application. Although content objects may be included as part of the application systems, in some instances a central repository storing content object information from each application system may be used to facilitate communication and data sharing between applications. Alternatively, point-to-point communications between applications may also be supported so that applications may share content object data without relying on the central repository. Some embodiments may support both central repository communications and point-to-point communications between applications. Determinations may be made to identify the type of connectivity supported in different circumstances.
    Type: Grant
    Filed: September 23, 2010
    Date of Patent: July 16, 2013
    Assignee: SAP AG
    Inventors: Bernhard Fippel, Siar Sarferaz
  • Publication number: 20130179393
    Abstract: 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.
    Type: Application
    Filed: July 6, 2012
    Publication date: July 11, 2013
    Applicant: NATIONAL CENTRAL UNIVERSITY
    Inventors: Meng-Feng TSAI, Min-Feng WANG, Cheng-Hsien TANG, Bo-Ru SONG, Ching-Hsuan SHEN, Hsin-Fu SU, Chi-Sheng HUANG