Query Formulation (epo) Patents (Class 707/E17.128)
  • Patent number: 8812643
    Abstract: Encoding and/or decoding of messages. On the encoding end, a composite encoder encodes message from an internal format that is used by internal system components into an external format. However, the composite encoder may encode the outgoing messages into different external formats on a per-message basis. For incoming message, a composite decoder decodes incoming messages from any one of a plurality of external formats into the internal format also on a per-message basis. A per-message report mechanism permits internal system components and the encoding/decoding components to communicate information regarding the encoding or decoding on a per message basis. XML messages can be converted automatically into Binary messages.
    Type: Grant
    Filed: July 5, 2011
    Date of Patent: August 19, 2014
    Assignee: Microsoft Corporation
    Inventors: Stephen Jared Maine, Michael J. Coulson, Tirunelveli R. Vishwanath, Erik B. Christensen
  • Patent number: 8433863
    Abstract: An incremental backup service may be configured to backup structured files and unstructured files on a client system. A filter driver 130 may be configured to monitor write operations on the client system and log changed cluster address information for structured files. The backup service may backup changed clusters of structured files to a backup storage device. For each of the unstructured files, the backup service may compare the file size to a threshold size. If the unstructured file is smaller than the threshold size, the backup service may backup the entire unstructured file. If the file size is larger than the threshold size, the backup service may determine the ratio of changed clusters to unchanged clusters. If the ratio is below a ratio threshold, the backup service may backup the changed clusters. If the ratio is above the ratio threshold, the backup service may backup the entire file.
    Type: Grant
    Filed: March 27, 2008
    Date of Patent: April 30, 2013
    Assignee: Symantec Operating Corporation
    Inventor: Stanford Niel Orcutt
  • Patent number: 8433867
    Abstract: A method for using a change-recording feature to perform more effective backups includes generating an initial point-in-time copy of source data residing in a storage device. The method may then perform an initial backup of the initial point-in-time copy. As changes are made to the source data, the method may record changes made to the source data after the initial point-in-time copy is generated. These changes may be stored as incremental change data. At some point, the initial point-in-time copy may be updated using the incremental change data. In order to perform an incremental backup of the updated point-in-time copy, the method may query the incremental change data to determine which changes were used to update the point-in-time copy. The method may then perform an incremental backup of the updated point-in-time copy by backing up the changes designated in the incremental change data.
    Type: Grant
    Filed: January 9, 2010
    Date of Patent: April 30, 2013
    Assignee: International Business Machines Corporation
    Inventors: Justin Paul Eastman, Jeffrey Richard Suarez, Henry Verdugo Valenzuela, Andrew Nelson Wilt
  • Publication number: 20130080472
    Abstract: A system and related method to process natural queries is provided. In one aspect, it is determined whether any portion of the natural language query matches one of a plurality of semantic keywords. In another aspect, the natural language query is translated into at least one database query. In a further aspect, the database query may be executed in a database arranged in accordance with the database model.
    Type: Application
    Filed: September 28, 2011
    Publication date: March 28, 2013
    Inventors: Ira Cohen, Refael Dakar, Eli Mordechai, Ohad Assulin
  • Patent number: 8099428
    Abstract: A method in a computer system for retrieving data from one of multiple copies of the data is provided, referred to as the data management system. The data management system receives a request identifying at least one data object to be accessed. Then, the data management system queries a metabase to locate data copies that contain the identified at least one data object, wherein the data copies are created from similar source data, and wherein for each data copy the metabase contains an indication of the availability of the copy relative to other copies. Next, the data management system determines one of the located data copies to use to access the identified at least one data object, wherein the determination is made based on the indicated availability contained in the metabase for each of the located data copies. Then, the data management system accesses the identified at least one data object using the determined one of the located data copies.
    Type: Grant
    Filed: March 29, 2011
    Date of Patent: January 17, 2012
    Assignee: CommVault Systems, Inc.
    Inventors: Rajiv Kottomtharayil, Parag Gokhale, Jun Lu
  • Patent number: 7984063
    Abstract: A method in a computer system for retrieving data from one of multiple copies of the data is provided, referred to as the data management system. The data management system receives a request identifying at least one data object to be accessed. Then, the data management system queries a metabase to locate data copies that contain the identified at least one data object, wherein the data copies are created from similar source data, and wherein for each data copy the metabase contains an indication of the availability of the copy relative to other copies. Next, the data management system determines one of the located data copies to use to access the identified at least one data object, wherein the determination is made based on the indicated availability contained in the metabase for each of the located data copies. Then, the data management system accesses the identified at least one data object using the determined one of the located data copies.
    Type: Grant
    Filed: February 1, 2011
    Date of Patent: July 19, 2011
    Assignee: CommVault Systems, Inc.
    Inventors: Rajiv Kottomtharayil, Parag Gokhale, Jun Lu
  • Patent number: 7877348
    Abstract: A method for analyzing data from a database using an analytic database function includes receiving a selection of measured items from a user, receiving a placement item from the user, and determining a partitioning of the selection of measured items from the placement item. A placement item can be a column, a row, or an axis. A template associated with the analytic database function is adapted to define at least one partitioning relative to the placement item. The template is further adapted to define an ordering parameter for the analytic database function and optionally an aggregation level for the analytic database function. A database query is created with the partitioning. The database query can be an SQL statement.
    Type: Grant
    Filed: September 11, 2009
    Date of Patent: January 25, 2011
    Assignee: Oracle International Corporation
    Inventors: Henry Verschell, Raghuram Venkatasubramanian, Steve Cave, Martin Roth
  • Patent number: 7814118
    Abstract: A method in a computer system for retrieving data from one of multiple copies of the data is provided, referred to as the data management system. The data management system receives a request identifying at least one data object to be accessed. Then, the data management system queries a metabase to locate data copies that contain the identified at least one data object, wherein the data copies are created from similar source data, and wherein for each data copy the metabase contains an indication of the availability of the copy relative to other copies. Next, the data management system determines one of the located data copies to use to access the identified at least one data object, wherein the determination is made based on the indicated availability contained in the metabase for each of the located data copies. Then, the data management system accesses the identified at least one data object using the determined one of the located data copies.
    Type: Grant
    Filed: March 31, 2008
    Date of Patent: October 12, 2010
    Assignee: CommVault Systems, Inc.
    Inventors: Rajiv Kottomtharayil, Parag Gokhale, Jun Lu
  • Patent number: 7801928
    Abstract: A method is disclosed, including determining an application to be executed; determining a dictionary associated to the determined application; and enabling the associated dictionary. Corresponding computer program, apparatus, user interface, and system are also disclosed.
    Type: Grant
    Filed: March 29, 2007
    Date of Patent: September 21, 2010
    Assignee: Nokia Corporation
    Inventors: John Rieman, Minna Hekanaho, Minna Koutonen, Tero Rantonen, John Hard
  • Publication number: 20100030726
    Abstract: A mechanism is provided for improving the performance of particular database queries operating on a view comprising binary-encoded XML. The key to improving performance is to determine whether a XML index is available to improve the computation of XPath data before deriving an optimized execution plan for a particular query. When a XML index is not available to help expedite the computation of binary-encoded XML, then deferring the computation of the XPath data until after the view merge stage avoids unnecessary computation of XPaths that are part of the view but not needed for the particular query.
    Type: Application
    Filed: July 29, 2008
    Publication date: February 4, 2010
    Inventors: Sivasankaran Chandrasekar, Balasubramanyam Sthanikam, Sam Idicula, Nipun Agarwal
  • Publication number: 20090063434
    Abstract: Embodiments of the invention provide site browsing history information that pertains to a specified network site user. One embodiment, directed to a method, comprises the step of acquiring data for a database, wherein the acquired data identifies multiple sites that are accessed by the user in an order, during a specified period of time. The method further comprises accessing at least a portion of the data from the database. From the accessed data, a pictorial representation of a plurality of the websites accessed during the specified time period is generated. The pictorial representation further illustrates the order in which at least some of the websites of the plurality were accessed.
    Type: Application
    Filed: August 31, 2007
    Publication date: March 5, 2009
    Inventors: Indran Naick, Jeffrey K. Wilson
  • Publication number: 20080270371
    Abstract: Executing a XML database query. The method may include compiling the XML database query to provide at least two alternative execution plans, wherein the at least two alternative execution plans provide the same response to the XML database query. The method may further include deciding during runtime, which of the at least two alternative execution plans is executed. The method may include executing the selected execution plan.
    Type: Application
    Filed: October 25, 2007
    Publication date: October 30, 2008
    Inventor: Thorsten Fiebig
  • Publication number: 20080147629
    Abstract: A method, system and article of manufacture for constructing queries that are executed against a database and, more particularly, for constructing queries capable of returning classified information related to data in a database. One embodiment includes receiving user input specifying a plurality of result fields for an abstract query. Each result field corresponds to a logical field specification of a data abstraction model abstractly describing the data in the database. The method further includes receiving user input selecting one of the plurality of result fields, and receiving user input specifying a classification definition for the selected result field. The classification definition is suitable for dividing data to be returned for the selected result field into a plurality of categories. Then, a classification field for the abstract query is generated on the basis of the selected result field and the classification definition. The classification field is included with the abstract query.
    Type: Application
    Filed: February 22, 2008
    Publication date: June 19, 2008
    Inventors: Richard D. Dettinger, Thomas J. Eggebraaten, Jeffrey W. Tenner
  • Publication number: 20080147624
    Abstract: A method, system and article of manufacture for constructing queries that are executed against a database and, more particularly, for constructing queries capable of returning classified information related to data in a database. One embodiment includes receiving user input specifying a plurality of result fields for an abstract query. Each result field corresponds to a logical field specification of a data abstraction model abstractly describing the data in the database. The method further includes receiving user input selecting one of the plurality of result fields, and receiving user input specifying a classification definition for the selected result field. The classification definition is suitable for dividing data to be returned for the selected result field into a plurality of categories. Then, a classification field for the abstract query is generated on the basis of the selected result field and the classification definition. The classification field is included with the abstract query.
    Type: Application
    Filed: February 22, 2008
    Publication date: June 19, 2008
    Inventors: Richard D. Dettinger, Thomas J. Eggebraaten, Jeffrey W. Tenner