Data Warehouse, Data Mart, Online Analytical Processing (olap), Decision Support Systems Patents (Class 707/600)
  • Patent number: 7765485
    Abstract: Embodiments of the present invention address deficiencies of the art in respect to extending the user interface of an application, and provide a method, system and computer program product for extending the user interface of an application in a componentized application environment. In one embodiment of the invention, a user interface extension method for a componentized application environment can include specifying in markup a set of user interface controls and further specifying in markup an extension to a user interface control in the set. The markup for the user interface control can be substituted with the markup for the extension. Thereafter, the markup for the extension and the set of user interface controls can be provided to a set of corresponding control factories, absent the substituted user interface control, for generation into user interface control instances defining a user interface for the componentized application environment.
    Type: Grant
    Filed: January 30, 2006
    Date of Patent: July 27, 2010
    Assignee: International Business Machines Corporation
    Inventors: Bruce R. Baker, Bhadrinarayanan O. Madapusi
  • Patent number: 7761405
    Abstract: A method and apparatus for managing log per entry in a directory server is described. In one embodiment, the directory server receives a request to operate on an entry in the directory server. The directory server operates on the entry. The information of the operation on the entry is stored in a log attribute of the entry.
    Type: Grant
    Filed: November 29, 2006
    Date of Patent: July 20, 2010
    Assignee: Red Hat, Inc.
    Inventor: Peter Andrew Rowley
  • Patent number: 7756820
    Abstract: Methods and apparatus, including computer program products, for an activity browser. A computer system includes a user interface linked to a processor arranged to perform instructions in accordance with a business application stored in a memory, the business application including context code portions representing at least one context, the context representing a business situation, service interface code portions defining at least two interfaces between services and the context, each of the interfaces arranged for exchanging data from a parameter of the context and the service associated with the context, and user-interface code portions for outputting at the user interface data representing information about the context.
    Type: Grant
    Filed: July 19, 2005
    Date of Patent: July 13, 2010
    Assignee: SAP AG
    Inventors: Dennis B. Moore, Joerg Beringer
  • Patent number: 7756821
    Abstract: An element of a file system is virtually deleted by creating a deletion marker for the element. Two or more separate physical file system directories are presented as one merged (virtual) file system directory to a process running in a silo. The operating system provides the merged view of the file system directories by monitoring file system requests made by processes in silos on a computer or computer system and filtering out those elements associated with deletion markers. Special processing is invoked in response to detecting certain types of file system access requests, including: enumeration, open, create, rename or delete.
    Type: Grant
    Filed: November 2, 2006
    Date of Patent: July 13, 2010
  • Patent number: 7756822
    Abstract: An architecture and system for integrating online transactional processing (OLTP) systems with online analytical processing (OLAP) system. The architecture includes a data access layer having one or more data access programs for accessing OLTP data, a service layer having a business intelligence (BI) platform for generating OLAP data, and a data abstraction layer providing a common meta-model for OLTP data integrated with OLAP data. The architecture further includes a user interface presentation layer configured to provide a user interface for displaying a report run on the integrated OLTP and OLAP data.
    Type: Grant
    Filed: December 1, 2003
    Date of Patent: July 13, 2010
    Assignee: SAP AG
    Inventors: Gerd Danner, Andreas Wesselmann
  • Patent number: 7752162
    Abstract: The analysis of OLAP data to determine user-relevant information firstly generates a set of queries based on said preferences. Each query is evaluated sequentially against the OLAP data to give a query result. For each evaluated query in turn, it is determined whether said result is relevant to the user on the basis of conditions derived from the user preferences. An output results set is formed consisting of the relevant results. Further, if a previous query result containing a common measure was determined not to be relevant, then a subsequent query can be omitted from evaluation.
    Type: Grant
    Filed: June 2, 2006
    Date of Patent: July 6, 2010
    Assignee: International Business Machines Corporation
    Inventors: Prasad Manikarao Deshpande, Krishna Kummamuru, Guruduth Somasekhara Banavar, Vijii Enara Chenthamarakshan
  • Publication number: 20100163041
    Abstract: A method may include dispensing a dose of an inhalable compound according to a dosing instruction set; and maintaining a hands-free article for dispensing the inhalable compound in an operable dispensing position.
    Type: Application
    Filed: June 4, 2009
    Publication date: July 1, 2010
    Inventors: Roderick A. Hyde, Muriel Y. Ishikawa, Jordin T. Kare, Robert Langer, Eric C. Leuthardt, Elizabeth A. Sweeney, Clarence T. Tegreene, Lowell L. Wood, JR., Victoria Y.H. Wood
  • Patent number: 7747480
    Abstract: Systems and methods for managing data assets in an enterprise computing environment are provided. Data assets associated with a plurality of source systems operating within the enterprise computing environment may be registered with an asset repository hub. The asset repository hub receives a registration request from a source system for a particular data asset and determines whether the data asset is unique within the enterprise computing environment. If the data asset is unique, then the data asset is stored at the asset repository hub and a unique enterprise identifier is associated with the data asset. In determining whether the asset is unique, the asset repository hub may cleanse the data asset against a set of business rules; generate a plurality of match codes that describe the content of the data asset; and cluster the generated match codes against clusters of previously generated match codes.
    Type: Grant
    Filed: March 28, 2007
    Date of Patent: June 29, 2010
    Assignee: SAS Institute Inc.
    Inventors: Ronald Jeffrey Agresta, Scott Aron Gidley, Brian Carl Rineer, Alexander A. Novozhilov
  • Patent number: 7743015
    Abstract: Data processing systems and methods are provided having an on-line transaction processing (OLTP) database and an on-line analysis processing (OLAP) database. The OLAP and OLTP databases are synchronized periodically. In response to a user's query, OLAP cube data that is available in the OLAP database is complimented with data from the OLTP database for inclusion of up-to-date data into the on-line analysis processing.
    Type: Grant
    Filed: June 17, 2005
    Date of Patent: June 22, 2010
    Assignee: SAP AG
    Inventor: Winfried Schmitt
  • Patent number: 7739225
    Abstract: Methods and systems to analyze aspect rules based on domain coverage of aspect-value pairs are provided. The system receives a first plurality of data items from a database, applies a first plurality of rules to the first plurality of data items to generate a second plurality of data items associated with a first domain, counts the second plurality of data items to determine a total quantity of data items, applies a second plurality of rules to the second plurality of data items to identify a third plurality of data items it associates with a first aspect-value pair, counts the third plurality of data items to determine a first quantity of data items, determines a percentage of coverage for the first aspect-value pair based on the first quantity of data items and the total quantity of data items, and provides the percentage coverage for the first aspect-value pair as an interface element within an interface.
    Type: Grant
    Filed: February 7, 2007
    Date of Patent: June 15, 2010
    Assignee: eBay Inc.
    Inventors: Josh Loftus, Venkat Sundaranatha, Louis Marcel Gino Monier, Jean-Michel Leon, Aditya Arora, Benjamin David Foster, Seema Shah
  • Patent number: 7739226
    Abstract: Methods and systems to analyze aspect rules based on domain coverage of the aspect rules are provided. The system receives a first plurality of data items from a database, applies a first plurality of rules to the first plurality of data items to generate a second plurality of data items associated with a first domain, counts the second plurality of data items to determine a total quantity of data items, applies a second plurality of rules to the second plurality of data items to identify a third plurality of data items associated with a first aspect counts the third plurality of data items to determine a first quantity of data items, determines a percentage of coverage for the first aspect based on the first quantity of data items and the total quantity of data items, and provides the percentage of coverage as an interface element within an interface.
    Type: Grant
    Filed: February 7, 2007
    Date of Patent: June 15, 2010
    Assignee: eBay Inc.
    Inventors: Josh Loftus, Venkat Sundaranatha, Louis Marcel Gino Monier, Jean-Michel Leon, Aditya Arora, Benjamin David Foster, Seema Shah
  • Patent number: 7739227
    Abstract: Enterprise confidential electronic data inventory systems, methods and/or computer program products include a database management system, method and/or computer program product that is configured to store identifying information for the confidential electronic data of the enterprise without storing the confidential electronic data itself. Querying of the identifying information for the electronic data of the enterprise that is stored may also be provided.
    Type: Grant
    Filed: April 12, 2007
    Date of Patent: June 15, 2010
    Assignee: AT&T Intellectual Property I, L.P.
    Inventors: Glenda S. Jordan, Jeanne M. Robinson, Ryan D. Fisher
  • Patent number: 7734652
    Abstract: An implementation of NMF functionality integrated into a relational database management system provides the capability to apply NMF to relational datasets and to sparse datasets. A database management system comprises a multi-dimensional data table operable to store data and a processing unit operable to perform non-negative matrix factorization on data stored in the multi-dimensional data table and to generate a plurality of data tables, each data table being smaller than the multi-dimensional data table and having reduced dimensionality relative to the multi-dimensional data table. The multi-dimensional data table may be a relational data table.
    Type: Grant
    Filed: August 27, 2004
    Date of Patent: June 8, 2010
    Assignee: Oracle International Corporation
    Inventors: Pablo Tamayo, George G. Tang, Mark A. McCracken, Mahesh K. Jagannath, Marcos M. Campos, Boriana L. Milenova, Joseph S. Yarmus, Pavani Kuntala
  • Publication number: 20100138381
    Abstract: 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. If the judge finds that the first author's answer is better than the second author's, then the first author's answer remains ranked first under the question; if the judge finds that the second author's answer is better, then the second author's answer replaces the first author's answer as the #1 ranked answer under the question.
    Type: Application
    Filed: January 29, 2010
    Publication date: June 3, 2010
    Inventor: Michael T. Rossides
  • Patent number: 7730020
    Abstract: Equipment failures are diagnosed using an integrated approach of case-based reasoning (CBR) and statistical reliability analysis. The method outputs a single list of suggested failed components, ranked by an overall probability of failure, and their associated past solutions from the case base. The overall probability of failure is calculated using the combined logic of case based reasoning and statistical reliability analysis. The method is typically used in a real-time decision support system to aid equipment diagnosis by a maintenance technician working in the field.
    Type: Grant
    Filed: August 23, 2007
    Date of Patent: June 1, 2010
    Assignee: International Business Machines Corporation
    Inventors: Ying Tat Leung, Gyana Ranjan Parija, Samir Sharma
  • Patent number: 7730059
    Abstract: Methods, systems, and computer readable medium for displaying results of a search query. In one implementation, the method includes receiving a query, obtaining documents that satisfy the query, constructing a facet hierarchy based on documents that satisfy the query, creating a cube structure based on the facet hierarchy, and displaying a multi-dimensional search interface based on the cube structure.
    Type: Grant
    Filed: March 30, 2007
    Date of Patent: June 1, 2010
    Assignee: International Business Machines Corporation
    Inventors: Marion Behnen, Qi Jin, Timo Pfahl, Holger Pirk
  • Patent number: 7725429
    Abstract: In one embodiment, a system is provided for centrally managing core enterprise reference data associated with an enterprise. A centralized master repository contains the core enterprise reference data. An internal services framework coupled to the centralized master repository provides internal services for managing the core enterprise reference data within the centralized master repository, one or more of the internal services having direct access to the core enterprise reference data stored in the centralized master repository for management purposes.
    Type: Grant
    Filed: May 17, 2004
    Date of Patent: May 25, 2010
    Assignee: i2 Technologies US, Inc.
    Inventor: Vasudev Rangadass
  • Patent number: 7720808
    Abstract: A computer readable medium comprises executable instructions to form a list of parameters for a report. The list of parameters is compared to existing lists of parameters. A selected list of parameters is designated. A report is generated with the selected list of parameters.
    Type: Grant
    Filed: December 14, 2005
    Date of Patent: May 18, 2010
    Assignee: Business Objects Software Ltd.
    Inventors: Tao Lin, Timothy John Lawrence
  • Patent number: 7716172
    Abstract: A method of operating a multi-dimensional database is disclosed. In this method, a multi-dimensional portion of the data is transferred to a multi-dimensional database. A relational portion of the cube is kept in the relational database. When data from the relational portion needs to be accessed, the system produces the SQL queries to obtain data from the relational database.
    Type: Grant
    Filed: January 30, 2006
    Date of Patent: May 11, 2010
    Assignee: Hyperion Solutions Corporation
    Inventors: Vaishnavi Anjur, Vijay K. Anjur, Hemanta Banerjee, Maya Binkovich, Srinivas Duvvuri, Mark Goldenshteyn, Arun Kumar, Kevin Kaixuan Liao, Igor Nazarenko
  • Patent number: 7716173
    Abstract: A method and system for producing graphics. A hierarchical structure of a database is determined. A visual table, comprising a plurality of panes, is constructed by providing a specification that is in a language based on the hierarchical structure of the database. In some cases, this language can include fields that are in the database schema. The database is queried to retrieve a set of tuples in accordance with the specification. A subset of the set of tuples is associated with a pane in the plurality of panes.
    Type: Grant
    Filed: July 17, 2006
    Date of Patent: May 11, 2010
    Assignee: The Board of Trustees of the Leland Stanford Jr. University
    Inventors: Chris Stolte, Diane L. Tang, Patrick Hanrahan
  • Patent number: 7716212
    Abstract: A query framework system is provided. The query framework system comprises a query framework service for consuming a query and returning a result set, a provider application programming interface for defining a consistent application programming interface for providers, one or more providers incorporating query processing logic, and a configuration repository for storing the list of the providers in the query framework system and their properties.
    Type: Grant
    Filed: June 22, 2006
    Date of Patent: May 11, 2010
    Assignee: International Business Machines Corporation
    Inventors: Soufaine Azizi, Vladimir Mordvinov, Michael C. Potter
  • Patent number: 7716174
    Abstract: Data integration and data analysis using computing equipment, software as well as hardware, includes a system and method for integrating data from various data sources, structured and unstructured, without physically creating a data warehouse and automatically generating queries for analysis of the integrated data from a multitude of different views.
    Type: Grant
    Filed: October 31, 2007
    Date of Patent: May 11, 2010
    Assignee: International Business Machines Corporation
    Inventors: Juhnyoung Lee, Pietro Mazzoleni, Jakka Sairamesh, Maroun Touma
  • Publication number: 20100113892
    Abstract: This invention relates generally to providing nutrigenomic information tailored to that of the customer so that the customer can make informed decisions regarding diet, exercise, risks of disease and other health issues that result in a healthier lifestyle and prolonged lifespan. In particular the invention provides systems for research and commercial purposes, particularly for research for improving dietary constituents, personalized nutrition and diets, and of nutrient-gene interactions involved in diseases. The invention further relates to a method for doing business encompassing establishing and running a nutrigenomic research super-market and providing validated nutrient intake data to health care practitioners.
    Type: Application
    Filed: November 30, 2007
    Publication date: May 6, 2010
    Inventors: James Kaput, Nancy Fogg-Johnson
  • Patent number: 7711704
    Abstract: A tabular operation provider is provided for processing a data agnostic business intelligence query with relational operations, herein called a relational query against a multidimensional datasource. The tabular operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a relational query that is issued against one or more multidimensional data sources. The query decomposer decomposes expressions of the relational query into one multidimensional expression and one or more relational expressions. The query replacer replaces the relational query with a stack of operations expressed by the decomposed multidimensional expressions and/or the relational expressions.
    Type: Grant
    Filed: April 27, 2006
    Date of Patent: May 4, 2010
    Assignee: International Business Machines Corporation
    Inventor: Soufiane Azizi
  • Publication number: 20100106680
    Abstract: 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.
    Type: Application
    Filed: October 23, 2009
    Publication date: April 29, 2010
    Applicants: BladeLogic, Inc.
    Inventors: Jorge A. Navarrete, Stephen J. O'Connor, Peter P. Dai, Johri Dhanotra, Hubert Yau Kin Siu, Charudutt Nagori, Ashish Kalani
  • Patent number: 7707171
    Abstract: An interactive response, storage and tracking system delivered through an interactive medium (e.g. mobile, internet, kiosk in shops) whereby the provided visual stimuli enables consumers/respondents/users to select a stimulus that best answers their response to a given question. These visual ‘answers’ are then collated to form ‘clusters’ of respondents that share the same or similar preferences thereby enabling the viewer of such information to understand the propensity of a given ‘cluster’ to behave, react, respond, perform and/or purchase.
    Type: Grant
    Filed: September 16, 2005
    Date of Patent: April 27, 2010
    Assignee: Imagini Holdings Limited
    Inventor: Alex Willcock
  • Patent number: 7707167
    Abstract: A method, system, and apparatus are provided for creating a knowledge interchange (“KI”) profile for a user that identifies the interests of the user, the individuals with which the user has communicated, and the topics on which the communication with the user was made. In order to create the KI profile, items of interest are gathered at the client computer by monitoring the interaction between a user and programs executing on the client computer. Once the items of interest have been identified, the KI profile is created by performing a social network analysis, an interest analysis, and a noun phrase analysis. Once the KI profile has been created, it may be uploaded to a server computer where it is aggregated with KI profiles created for other users.
    Type: Grant
    Filed: September 20, 2004
    Date of Patent: April 27, 2010
    Assignee: Microsoft Corporation
    Inventors: Ajitesh Kishore, Sandeep Sahasrabudhe
  • Publication number: 20100100522
    Abstract: 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.
    Type: Application
    Filed: October 16, 2009
    Publication date: April 22, 2010
    Inventors: Gregory Austin Allison, Matthew Allan Vorst
  • Publication number: 20100082524
    Abstract: 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.
    Type: Application
    Filed: October 1, 2008
    Publication date: April 1, 2010
    Inventor: PAUL GRANT BARBER
  • Patent number: 7689605
    Abstract: The present invention leverages MOLAP performance for ROLAP objects (dimensions, partitions and aggregations) by building, in a background process, a MOLAP equivalent of that object. When the background processing completes, queries are switched from ROLAP queries to MOLAP queries. When changes occur to relevant relational objects (such as tables that define content of OLAP objects), an OLAP object is switched back to a ROLAP mode, and all relevant caches are dropped while, as a background process, a new MOLAP equivalent is created.
    Type: Grant
    Filed: January 11, 2006
    Date of Patent: March 30, 2010
    Assignee: Microsoft Corporation
    Inventors: Cristian Petculescu, Amir Netz, Thomas P. Conlon
  • Publication number: 20100076924
    Abstract: 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.
    Type: Application
    Filed: December 3, 2009
    Publication date: March 25, 2010
    Inventors: James Snyder, Harry Lai, Shirish Reddy, Jimmy Wan
  • Publication number: 20100063903
    Abstract: An electronic transaction decision module is provided that includes a dynamic rules engine, processing system and interfaces to enable various participants in an electronic payment environment to establish and modify the rules, condition values, fees and rewards associated with electronic transactions. Participants in electronic financial or other economic transactions are authorized and enabled to define multiple rules, condition values, fees and rewards within which they either authorize or deny the consummation of a financial transaction and define its impact upon various participants, and to dynamically and efficiently modify those rules, condition values, fees and rewards when desired. Rules, condition values, fees and rewards may be set and evaluated hierarchically based on the participant's relative authority with respect to each attribute.
    Type: Application
    Filed: March 9, 2009
    Publication date: March 11, 2010
    Inventors: Thayne Whipple, Pamela F. Galligan, David Taylor
  • Publication number: 20100063958
    Abstract: 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.
    Type: Application
    Filed: November 9, 2009
    Publication date: March 11, 2010
    Inventors: Reuven Bakalash, Guy Shaked, Joseph Caspi
  • Publication number: 20100049756
    Abstract: 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.
    Type: Application
    Filed: October 27, 2008
    Publication date: February 25, 2010
    Applicant: Siemens Medical Solutions USA. Inc.
    Inventors: Vamsi K. Chemitiganti, Lucian Vlad Lita, Maleeha Qazi
  • Patent number: 7664804
    Abstract: A method, system, and apparatus are provided for exposing and utilizing workbook ranges as server data sources. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook including a range that includes data objects. The workbook may be published to a server computer where the specified data objects are exposed as server data sources. The server computer allows client applications to discover and connect to the data objects contained within the workbook as server data sources.
    Type: Grant
    Filed: June 1, 2004
    Date of Patent: February 16, 2010
    Assignee: Microsoft Corporation
    Inventors: Daniel C. Battagin, Liviu Asnash, Amir Netz, Cristian Petculescu, Eran Megiddo