Query Formulation (epo) Patents (Class 707/E17.128)
-
Patent number: 8812643Abstract: 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: GrantFiled: July 5, 2011Date of Patent: August 19, 2014Assignee: Microsoft CorporationInventors: Stephen Jared Maine, Michael J. Coulson, Tirunelveli R. Vishwanath, Erik B. Christensen
-
Patent number: 8433863Abstract: 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: GrantFiled: March 27, 2008Date of Patent: April 30, 2013Assignee: Symantec Operating CorporationInventor: Stanford Niel Orcutt
-
Patent number: 8433867Abstract: 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: GrantFiled: January 9, 2010Date of Patent: April 30, 2013Assignee: International Business Machines CorporationInventors: Justin Paul Eastman, Jeffrey Richard Suarez, Henry Verdugo Valenzuela, Andrew Nelson Wilt
-
Publication number: 20130080472Abstract: 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: ApplicationFiled: September 28, 2011Publication date: March 28, 2013Inventors: Ira Cohen, Refael Dakar, Eli Mordechai, Ohad Assulin
-
Patent number: 8099428Abstract: 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: GrantFiled: March 29, 2011Date of Patent: January 17, 2012Assignee: CommVault Systems, Inc.Inventors: Rajiv Kottomtharayil, Parag Gokhale, Jun Lu
-
Patent number: 7984063Abstract: 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: GrantFiled: February 1, 2011Date of Patent: July 19, 2011Assignee: CommVault Systems, Inc.Inventors: Rajiv Kottomtharayil, Parag Gokhale, Jun Lu
-
Patent number: 7877348Abstract: 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: GrantFiled: September 11, 2009Date of Patent: January 25, 2011Assignee: Oracle International CorporationInventors: Henry Verschell, Raghuram Venkatasubramanian, Steve Cave, Martin Roth
-
Patent number: 7814118Abstract: 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: GrantFiled: March 31, 2008Date of Patent: October 12, 2010Assignee: CommVault Systems, Inc.Inventors: Rajiv Kottomtharayil, Parag Gokhale, Jun Lu
-
Patent number: 7801928Abstract: 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: GrantFiled: March 29, 2007Date of Patent: September 21, 2010Assignee: Nokia CorporationInventors: John Rieman, Minna Hekanaho, Minna Koutonen, Tero Rantonen, John Hard
-
Publication number: 20100030726Abstract: 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: ApplicationFiled: July 29, 2008Publication date: February 4, 2010Inventors: Sivasankaran Chandrasekar, Balasubramanyam Sthanikam, Sam Idicula, Nipun Agarwal
-
Publication number: 20090063434Abstract: 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: ApplicationFiled: August 31, 2007Publication date: March 5, 2009Inventors: Indran Naick, Jeffrey K. Wilson
-
Publication number: 20080270371Abstract: 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: ApplicationFiled: October 25, 2007Publication date: October 30, 2008Inventor: Thorsten Fiebig
-
Publication number: 20080147629Abstract: 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: ApplicationFiled: February 22, 2008Publication date: June 19, 2008Inventors: Richard D. Dettinger, Thomas J. Eggebraaten, Jeffrey W. Tenner
-
Publication number: 20080147624Abstract: 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: ApplicationFiled: February 22, 2008Publication date: June 19, 2008Inventors: Richard D. Dettinger, Thomas J. Eggebraaten, Jeffrey W. Tenner