Patent application number | Description | Published |
20090157775 | ARCHIVING METHOD AND SYSTEM - A method of archiving a set of source tables in a database system. Each source table has a plurality of rows. Initially, a consistency point for the set of source tables is established. The database system creates a log record for each change (insert, modify, or delete) effected to a row of the source tables subsequent to the consistency point. Substantially all source table rows are copied to an archive (a data storage object that is external to the database system). Then the accumulated log records for the affected source tables are distilled and appended to the archive. | 06-18-2009 |
20090172051 | ONLINE INCREMENTAL DATABASE DUMP - Various embodiments may include taking an initial dump of a database table and tracking changes to the database table, with regard to but outside of transactions, since a most recent full or partial dump has been taken. A partial dump, in such embodiments, may be taken since the most recent full or partial dump and used to create a data structure which may be used to update only those database table rows modified since a last full or partial dump. As a result, the dumps of a database table will include a single full dump and may include one or more partial dumps. These full and partial dumps may then be instantiated to create or update an instance of the database table. In some embodiments, dumps may be taken directly to a mirrored instance of a database table. | 07-02-2009 |
20120078860 | ALGORITHMIC COMPRESSION VIA USER-DEFINED FUNCTIONS - A method, apparatus, and article of manufacture for accessing data in a computer system. One or more user-defined functions (UDFs) implementing a desired compression or decompression algorithm are created, wherein the UDFs are associated with one or more columns of a table when the table is created or altered, in order to perform compression or decompression of data stored in the associated columns, such that the data is compressed by the UDF implementing the desired compression algorithm when the data is inserted or updated in the table, and the data is decompressed by the UDF implementing the desired decompression algorithm when the data is retrieved from the table. | 03-29-2012 |
20130173586 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR REDUCING RESPONSE TIME VARIATION IN A WORKLOAD MANAGEMENT SYSTEM - A system, method, and computer readable medium are provided for reducing response time variation in a workload management system for a database system. When a query response is generated in response to a database query from a client, a determination may be made as to whether response time of the query response is less than a predetermined amount of time. Delivery of the query response to the client is delayed when an amount of time associated with the query response is less than the predetermined amount of time. | 07-04-2013 |
20150186045 | MANAGEMENT OF DATA IN MULTI-STORAGE SYSTEMS THAT CAN INCLUDE NON-VOLATILE AND VOLATILE STORAGES - Techniques for management of data in multi-storage systems allow managing storage of data in a first storage of multiple storages in a multi-storage system based on the temperature of the data (or data temperature) obtained for a second storage of the multiple storages in a multi-storage system. For example, in a multi-storage system that includes at least one non-volatile storage (e.g., one or more HDDs) and at least one volatile storage (e.g., a cache memory device), the storage of a particular data portion (e.g., a storage unit of data) for the at least one volatile storage can be managed based on a temperature of the data determined for the non-volatile storage. By way of example, persistent temperatures used for management of data in a non-volatile storage system (e.g., a multi-tier storage of a database system) can be used to effectively manage the storage of the data in a cache memory that is typically provided for improving performance by keeping data that is likely to be used in the cache memory. As a result, overall performance of a system can be further enhanced by allowing persistent temperature measurements to be used in managing cache memory, instead of solely relying on conventional techniques for caching data which typically do not take into account persistent temperatures associated with a non-volatile storage environment. | 07-02-2015 |
20150186046 | MANAGEMENT OF DATA IN MULTI-STORAGE SYSTEMS THAT CAN INCLUDE NON-VOLATILE AND VOLATILE STORAGES - Techniques for management of data in multi-storage systems allow managing storage of data in one of the multiple storages (e.g., a HDD) based on the information associated with the storage and/or access of data (e.g., logical hits of data in a cache memory) in another one of the storages (e.g., a cache memory) of the multi-storage system. In one aspect, information associated with storage and/or access of data in a volatile (or non-persistent) storage environment is provided for managing the storage of data in a non-volatile (or persistent) storage environment. By way of example, data access information associated with a volatile storage environment (e.g., logical hits of data in a cache) can be effectively communicated to a non-volatile storage environment, for example, as information that can be indicative of data temperatures. Moreover, the information obtained from a non-volatile storage environment can be persistently stored for and/or in the non-volatile environment (e.g., stored as persistent data temperatures), thereby preserving and allowing the information to be used to more effectively manage the storage of the data in the non-volatile storage itself and/or the multi-storage system including the (volatile storage) as a whole. | 07-02-2015 |
20150186047 | MANAGEMENT OF DATA IN MULTI-STORAGE SYSTEMS THAT CAN INCLUDE NON-VOLATILE AND VOLATILE STORAGES - A combination of non-persistent-based and persistent-based schemes are used to effectively manage volatile storages which are conventionally managed solely by using non-persistent schemes (e.g., LRU schemes in cache memory). Generally, the persistent-based schemes can be based on persistent information associated with a non-volatile storage environment (e.g., persistent data temperatures associated with data stored in non-volatile storages). In this context, a persistent-based scheme can, for example, be effectively used in addition or combination with a conventional scheme provided for volatile memory. By way of example, a LRU scheme can be combined with a scheme based on persistent data temperatures in order to more effectively manage cache memory provided to enhance the performance of a system. As another example, a LRU, a LFU aging schemes can be combined with a scheme based on persistent data temperatures. | 07-02-2015 |
Patent application number | Description | Published |
20120144234 | AUTOMATIC ERROR RECOVERY MECHANISM FOR A DATABASE SYSTEM - A computer-implemented method, apparatus and article of manufacture for performing an automatic error recovery in a database system. Automatic error recovery is performed for a query execution plan, following errors, problems or failures that occur during execution, by automatically or manually deactivating and/or activating components, features or code paths, and then re-submitting the query execution plan for execution in the computer system. | 06-07-2012 |
20120166400 | TECHNIQUES FOR PROCESSING OPERATIONS ON COLUMN PARTITIONS IN A DATABASE - Techniques for processing operations on column partitions of a table in a database are provided. A table includes a control column partition. Each delete container of the control column partition representing multiple rows in the table (or a row partition, if any), and each row represented by a bit flag within a bit string. Rows of the table set for deletion have their corresponding bits within a particular delete container set to indicate those rows are deleted. | 06-28-2012 |
20120166402 | TECHNIQUES FOR EXTENDING HORIZONTAL PARTITIONING TO COLUMN PARTITIONING - Techniques for extending horizontal partitioning to column partitioning are provided. A database table is partitioned into custom groups of rows and custom groups of columns. Each partitioned column is managed as a series of containers representing all values appearing under the partitioned column. A logical row represents a row of the table logically indicating each column value of a row. Compression, deletion, and insertion within the containers are managed via a control header maintained with each container. | 06-28-2012 |
20120173496 | NUMERIC, DECIMAL AND DATE FIELD COMPRESSION - A method, apparatus, and article of manufacture for accessing data in a computer system. Compression and decompression functions are associated with a column of the table, in order to perform compression of decimal, numeric or date data stored in the column when the data is inserted or updated in the table, and in order to perform decompression of the data stored in the column when the data is retrieved from the table. The compression function compresses and stores the data in a fixed-length compressed field in the column without a length value, and the fixed-length compressed field has a size that is determined by a range of values for the data stored in the fixed-length compressed field. The decompression function retrieves and decompresses the data from the fixed-length compressed field. | 07-05-2012 |
20140188820 | TECHNIQUES FOR FINDING A COLUMN WITH COLUMN PARTITIONING - Techniques for finding a column with column partitioning are provided. Metadata for a container row is expanded to include information for searching ranges of partitioned column values. The metadata identifies offsets to specific ranges and specific columns within a specific range. The offsets also identify where compressed data for a desired column resides. Thereby, permitting partitioned columns having compressed data to be located without being decompressed and decompressed on demand as needed. | 07-03-2014 |
Patent application number | Description | Published |
20090088581 | CHELATING CARBENE LIGAND PRECURSORS AND THEIR USE IN THE SYNTHESIS OF METATHESIS CATALYSTS - Chelating ligand precursors for the preparation of olefin methathesis catalysts are disclosed. The resulting catalysts are air stable monomeric species capable of promoting various methathesis reactions efficiently, which can be recovered from the reaction mixture and reused. Internal olefin compounds, specifically beta-substituted styrenes, are used as ligand precursors. Compared to terminal olefin compounds such as unsubstituted styrenes, the beta-substituted styrenes are easier and less costly to prepare, and more stable since they are less prone to spontaneous polymerization. Methods of preparing chelating-carbene methathesis catalysts without the use of CuCl are disclosed. This eliminates the need for CuCl by replacing it with organic acids, mineral acids, mild oxidants or even water, resulting in high yields of Hoveyda-type methathesis catalysts. The invention provides an efficient method for preparing chelating-carbene metathesis catalysts by reacting a suitable ruthenium complex in high concentrations of the ligand precursors followed by crystallization from an organic solvent. | 04-02-2009 |
20090259065 | METHODS OF MAKING ORGANIC COMPOUNDS BY METATHESIS AND HYDROCYANATION - The invention is directed to methods of making organic compounds by metathesis and hydrocyanation. The method of the invention may be used, for example, to make industrial important organic compounds such as diacids, diesters, acid-amines, acid-alcohols, acid-nitriles, ester-amines, ester-alcohols, and ester-nitriles. | 10-15-2009 |
20090264672 | METHODS OF MAKING ORGANIC COMPOUNDS BY METATHESIS - Described are methods of making organic compounds by metathesis chemistry. The methods of the invention are particularly useful for making industrially-important organic compounds beginning with starting compositions derived from renewable feedstocks, such as natural oils. The methods make use of a cross-metathesis step with an olefin compound to produce functionalized alkene intermediates having a pre-determined double bond position. Once isolated, the functionalized alkene intermediate can be self-metathesized or cross-metathesized (e.g., with a second functionalized alkene) to produce the desired organic compound or a precursor thereto. The method may be used to make bifunctional organic compounds, such as diacids, diesters, dicarboxylate salts, acid/esters, acid/amines, acid/alcohols, acid/aldehydes, acid/ketones, acid/halides, acid/nitriles, ester/amines, ester/alcohols, ester/aldehydes, ester/ketones, ester/halides, ester/nitriles, and the like. | 10-22-2009 |
20100094034 | Metathesis Methods Involving Hydrogenation and Compositions Relating to Same - Disclosed are improved methods for conducting metathesis utilizing polyunsaturated fatty acid compositions (e.g., polyunsaturated fatty acid polyol esters, polyunsaturated fatty acids, polyunsaturated fatty esters, and mixtures), such as those found in naturally occurring oils and fats, as the starting material. The inventive methods involve hydrogenation of polyunsaturated fatty acid compositions prior to metathesis, thereby providing partially-hydrogenation compositions having a relatively higher amount of monounsaturated fatty acid species. The partially hydrogenated composition can then be subjected to metathesis to provide a metathesis product composition containing industrially useful compounds. | 04-15-2010 |
20100145086 | Synthesis of Terminal Alkenes From Internal Alkenes Via Olefin Metathesis - This disclosure relates generally to olefin metathesis, and more particularly relates to the synthesis of terminal alkenes from internal alkenes using a cross-metathesis reaction catalyzed by an olefin metathesis catalyst. According to one aspect, for example, a method is provided for synthesizing a terminal olefin, the method comprising contacting, in the presence of a ruthenium alkylidene metathesis catalyst, an olefinic substrate comprised of at least one internal olefin with a cross metathesis partner comprised of an alpha olefinic reactant, under reaction conditions effective to allow cross-metathesis to occur, wherein the reaction conditions include a reaction temperature of at least 35° C. The methods, compositions, reactions and reaction systems herein disclosed have utility in the fields of catalysis, organic synthesis, and industrial chemistry. | 06-10-2010 |
20110112319 | CHELATING CARBENE LIGAND PRECURSORS AND THEIR USE IN THE SYNTHESIS OF METATHESIS CATALYSTS - Chelating ligand precursors for the preparation of olefin methathesis catalysts are disclosed. The resulting catalysts are air stable monomeric species capable of promoting various methathesis reactions efficiently, which can be recovered from the reaction mixture and reused. Internal olefin compounds, specifically beta-substituted styrenes, are used as ligand precursors. Compared to terminal olefin compounds such as unsubstituted styrenes, the beta-substituted styrenes are easier and less costly to prepare, and more stable since they are less prone to spontaneous polymerization. Methods of preparing chelating-carbene methathesis catalysts without the use of CuCl are disclosed. This eliminates the need for CuCl by replacing it with organic acids, mineral acids, mild oxidants or even water, resulting in high yields of Hoveyda-type methathesis catalysts. The invention provides an efficient method for preparing chelating-carbene metathesis catalysts by reacting a suitable ruthenium complex in high concentrations of the ligand precursors followed by crystallization from an organic solvent. | 05-12-2011 |
20130035532 | SYNTHESIS OF TERMINAL ALKENES FROM INTERNAL ALKENES VIA OLEFIN METATHESIS - This disclosure relates generally to olefin metathesis, and more particularly relates to the synthesis of terminal alkenes from internal alkenes using a cross-metathesis reaction catalyzed by an olefin metathesis catalyst. According to one aspect, for example, a method is provided for synthesizing a terminal olefin, the method comprising contacting, in the presence of a ruthenium alkylidene metathesis catalyst, an olefinic substrate comprised of at least one internal olefin with a cross metathesis partner comprised of an alpha olefinic reactant, under reaction conditions effective to allow cross-metathesis to occur, wherein the reaction conditions include a reaction temperature of at least 35° C. The methods, compositions, reactions and reaction systems herein disclosed have utility in the fields of catalysis, organic synthesis, and industrial chemistry. | 02-07-2013 |
20130172568 | Chelating Carbene Ligand Precursors and Their Use in the Synthesis of Metathesis Catalysts - Chelating ligand precursors for the preparation of olefin methathesis catalysts are disclosed. The resulting catalysts are air stable monomeric species capable of promoting various methathesis reactions efficiently, which can be recovered from the reaction mixture and reused. Internal olefin compounds, specifically beta-substituted styrenes, are used as ligand precursors. Compared to terminal olefin compounds such as unsubstituted styrenes, the beta-substituted styrenes are easier and less costly to prepare, and more stable since they are less prone to spontaneous polymerization. Methods of preparing chelating-carbene methathesis catalysts without the use of CuCl are disclosed. This eliminates the need for CuCl by replacing it with organic acids, mineral acids, mild oxidants or even water, resulting in high yields of Hoveyda-type methathesis catalysts. The invention provides an efficient method for preparing chelating-carbene metathesis catalysts by reacting a suitable ruthenium complex in high concentrations of the ligand precursors followed by crystallization from an organic solvent. | 07-04-2013 |
20150018559 | Chelating Carbene Ligand Precursors and Their Use in the Synthesis of Metathesis Catalysts - Chelating ligand precursors for the preparation of olefin methathesis catalysts are disclosed. The resulting catalysts are air stable monomeric species capable of promoting various methathesis reactions efficiently, which can be recovered from the reaction mixture and reused. Internal olefin compounds, specifically beta-substituted styrenes, are used as ligand precursors. Compared to terminal olefin compounds such as unsubstituted styrenes, the beta-substituted styrenes are easier and less costly to prepare, and more stable since they are less prone to spontaneous polymerization. Methods of preparing chelating-carbene methathesis catalysts without the use of CuCl are disclosed. This eliminates the need for CuCl by replacing it with organic acids, mineral acids, mild oxidants or even water, resulting in high yields of Hoveyda-type methathesis catalysts. The invention provides an efficient method for preparing chelating-carbene metathesis catalysts by reacting a suitable ruthenium complex in high concentrations of the ligand precursors followed by crystallization from an organic solvent. | 01-15-2015 |
20150094481 | METHODS OF MAKING ORGANIC COMPOUNDS BY METATHESIS AND HYDROCYANATION - The invention is directed to methods of making organic compounds by metathesis and hydrocyanation. Hydrocyanation functions to introduce a nitrile group into the organic compound. The nitrile group may be converted into an amine group, an aldehyde group, an alcohol group, or a carboxylic acid group. The method of the invention may be used, for example, to make industrial important organic compounds such as diacids, diesters, acid-amines, acid-alcohols, acid-nitriles, ester-amines, ester-alcohols, and ester-nitriles. | 04-02-2015 |
20150307438 | Methods of Making Organic Compounds by Metathesis - Described are methods of making organic compounds by metathesis chemistry. The methods of the invention are particularly useful for making industrially-important organic compounds beginning with starting compositions derived from renewable feedstocks, such as natural oils. The methods make use of a cross-metathesis step with an olefin compound to produce functionalized alkene intermediates having a pre-determined double bond position. Once isolated, the functionalized alkene intermediate can be self-metathesized or cross-metathesized (e.g., with a second functionalized alkene) to produce the desired organic compound or a precursor thereto. The method may be used to make bifunctional organic compounds, such as diacids, diesters, dicarboxylate salts, acid/esters, acid/amines, acid/alcohols, acid/aldehydes, acid/ketones, acid/halides, acid/nitriles, ester/amines, ester/alcohols, ester/aldehydes, ester/ketones, ester/halides, ester/nitriles, and the like. | 10-29-2015 |