Patent application number | Description | Published |
20090077013 | METHODS, SYSTEMS, AND COMPUTER PROGRAM PRODUCTS FOR USER-DRIVEN TARGETED QUERY RE-OPTIMIZATIONS USING DELTA VALUES - A method, system, and computer program product for user-driven targeted query re-optimizations using delta values are provided. The method includes displaying a query tree for a query via a graphical user interface (GUI), where the query tree includes a plurality of interconnected nodes in a tree structure, and outputting a delta value as a difference between an estimated and an actual performance metric of query execution. The method also includes receiving a request to provide alternative execution plans for a subtree of a selected node of the query tree, and displaying at least one alternative execution plan description for the subtree of the selected node. The method further includes receiving a re-optimization request for a user selected alternative execution plan description, and displaying a re-optimized query tree resulting from the re-optimization request. | 03-19-2009 |
20090276394 | OBTAINING A PLAN FOR EXECUTING A QUERY IN A RELATIONAL DATABASE - A plan for executing a query in a relational database is obtained. A query for accessing data in the relational database is received. The query specifies N tables in the relational database from which data is to be retrieved. A determination is made whether a syntax of the query matches a syntax of a plan in a plan cache for executing the query. Matches are identified between generic table formats of the N tables specified in the query to generic table formats of N tables specified in the plan responsive to the syntax of the query matching the syntax of a plan in the plan cache for executing the query. The plan for executing the query is obtained based on whether the syntax of the query matches the syntax of the plan and based on identified matches between the generic table formats of the N tables specified in the query to the generic table formats of the N tables specified in the plan. | 11-05-2009 |
20090281986 | Generating Database Query Plans - Embodiments of the invention provide techniques for optimizing database queries for energy efficiency. In general, a query optimizer is configured to compare energy requirements of query plans, and to select a query plan requiring minimal energy to execute. In one embodiment, the query optimizer may also compare time performance of the query plans, and may select a query plan by matching to a user preference for a relative priority between energy requirements and time performance. | 11-12-2009 |
20090281992 | Optimizing Database Queries - Embodiments of the invention provide techniques for optimizing database queries for energy efficiency. In general, a query optimizer is configured to compare energy requirements of query plans, and to select a query plan requiring minimal energy to execute. In one embodiment, the query optimizer may also compare time performance of the query plans, and may select a query plan by matching to a user preference for a relative priority between energy requirements and time performance. | 11-12-2009 |
20090282272 | Organizing Databases for Energy Efficiency - Embodiments of the invention provide techniques for optimizing database queries for energy efficiency. In general, a query optimizer is configured to compare energy requirements of query plans, and to select a query plan requiring minimal energy to execute. In one embodiment, the query optimizer may also compare time performance of the query plans, and may select a query plan by matching to a user preference for a relative priority between energy requirements and time performance. | 11-12-2009 |
20120198423 | Code Path Tracking - Methods, systems, and products are provided for code path tracking. Embodiments include identifying an instrumented trace point in software code to be path tracked; identifying a function executed at the instrumented trace point in the software code; identifying parameters for the function executed at the instrumented trace point; and recording a description of the function, the parameters, and the result of the execution of the function using the parameters. | 08-02-2012 |
20140101128 | ESTIMATING ROWS RETURNED BY RECURSIVE QUERIES USING FANOUT - In an embodiment, a recursive query is received that comprises a first select statement with a seed select statement and a second select statement with a recursive reference, wherein the recursive query further identifies at least two columns in at least one table, wherein the at least two columns have parent-child relationships represented by nodes in a graph, wherein the graph represents the organization of values in rows in the at least one table. A target recursion depth is calculated for the graph based on a fanout of the graph. In an embodiment, the target recursion depth is calculated by summing the fanout at each recursion depth of the graph multiplied by a number of nodes at each recursion depth of the graph. An estimated number of rows that the recursive query will return is estimated based on the target recursion depth. | 04-10-2014 |
20140101133 | ESTIMATING ROWS RETURNED BY RECURSIVE QUERIES USING FANOUT - In an embodiment, a recursive query is received that comprises a first select statement with a seed select statement and a second select statement with a recursive reference, wherein the recursive query further identifies at least two columns in at least one table, wherein the at least two columns have parent-child relationships represented by nodes in a graph, wherein the graph represents the organization of values in rows in the at least one table. A target recursion depth is calculated for the graph based on a fanout of the graph. In an embodiment, the target recursion depth is calculated by summing the fanout at each recursion depth of the graph multiplied by a number of nodes at each recursion depth of the graph. An estimated number of rows that the recursive query will return is estimated based on the target recursion depth. | 04-10-2014 |
Patent application number | Description | Published |
20080226810 | Pea Protein Composition - The invention relates to a pea protein whose protein content is equal to or greater than 60% by dry weight, preferably ranging from 60 to 95% by weight, a molecular weight distribution profile is of 1.0-1.8%, preferably of 1.5-3.0% of proteins of greater than 100 000 Da, preferably 20-55% of proteins greater than 15 000 and 100 000 Da, 15-30% of proteins of greater than 5 00 and 15 00 Da and 25-50%, preferably 25-45% of proteins greater than 5 000 Da and whose soluble protein content determined by a method for measuring the protein solubility in water ranging from 20 to 85%, preferably 25 to 65%. | 09-18-2008 |
20110111037 | ORODISPERSIBLE MANNITOL - Coagglomerates of mannitol, whose laser volume-average diameter D4,3 is between 1 and 200 μm, and of granular starch, are characterized in that they have a disintegration behaviour determined according to a test A such that the relaxation time measured is between 30 and 100 seconds and the swelling force is between 0.8 and 3.0 N. | 05-12-2011 |
20110305740 | GRANULATED POWDER CONTAINING VEGETABLE PROTEINS AND MALTODEXTRINS, PROCESS FOR PRODUCING SAME, AND USES THEREOF - The present invention concerns a granulated powder comprising at least one vegetable protein and at least one starch hydrolyzate, characterized in that it has a laser volume average diameter D4,3 of between 10 μm and 500 μm, preferably between 50 μm and 350 μm, and even more preferably between 70 μm and 250 μm, and a dry matter content, determined after stoving at 130° C. for 2 hours, of greater than 80%, preferably greater than 85%, and even more preferably greater than 90%. | 12-15-2011 |
20110311599 | GRANULATED POWDER CONTAINING VEGETABLE PROTEINS AND FIBERS, PROCESS FOR PRODUCING SAME, AND USE THEREOF - The present invention concerns a granulated powder containing at least one vegetable protein and at least one vegetable fiber, characterized in that it has a laser volume mean diameter D4,3 of between 10 μm and 500 μm, preferably between 50 μm and 350 μm, and even more preferably between 70 μm and 250 μm, and a dry matter content, determined after stoving at 130° C. for 2 hours, of greater than 80%, preferably greater than 85%, and even more preferably greater than 90%. The present invention also concerns a process for manufacturing this granulated powder as well as its use in various industrial field, and more particularly in the food-processing field, where it is used as a functional agent such as an emulsifying, overrun, stabilizing, thickening and/or gelling agent, in particular for totally or partially replacing certain animal proteins in the preparation of food products. | 12-22-2011 |
20120034342 | METHOD FOR OBTAINING A PREPARATION OF BETA-AMYLASES FROM THE SOLUBLE FRACTIONS OF STARCH PLANTS - The present invention relates to a method for obtaining a preparation of β-amylases from the soluble fraction of starch plants, characterized in that the soluble fraction of starch plants is selected from the group consisting of the soluble fractions of wheat, pea, broad bean, horse bean, rice, barley, rye, buckwheat, potato and sweet potato, and preferably of wheat and barley, a clarification of said soluble fractions is carried out in such a way as to remove therefrom the insoluble substances and the colloids and, optionally, an ultrafiltration of said clarified soluble fractions is carried out in such a way as to obtain an ultrafiltration retentate containing the concentrated β-amylase and an ultrafiltration permeate, said ultrafiltration retentate containing the concentrated β-amylase is diafiltered and the resulting β-amylase is recovered. | 02-09-2012 |
20130017310 | Process for Manufacturing Soluble and Functional Plant Proteins, Products Obtained and UsesAANM Dhalleine; ClaireAACI CompiegneAACO FRAAGP Dhalleine; Claire Compiegne FRAANM Passe; DamienAACI DouaiAACO FRAAGP Passe; Damien Douai FR - The invention relates to a process for manufacturing soluble and functional plant proteins, characterized in that it comprises at least one functionalizing step that consists of a treatment of 0.01 s to 1 s constituted of a step of heating plant proteins at a temperature of 100° C. to 160° C. and a step of cooling the heated plant proteins. The invention also relates to a process for converting non-functional plant proteins to functional proteins. Another subject of the invention is a plant protein, characterized in that it has a solubility in water of greater than 50% (with the exception of a potato protein for which the solubility in water is 25%), an emulsifying capacity between 700,000 mPa·s and 1,200,000 mPa·s for a sample directly placed at 4° C. for 24 h (with the exception of a potato protein for which the emulsifying capacity for a sample directly placed at 4° C. for 24 h is between 400,000 mPa·s and 600,000 mPa·s) and between 500,000 mPa·s and 1,100,000 mPa·s for a sample treated at 75° C. then placed at 4° C. for 24 h and an emulsifying capacity between 70% and 95%. A further subject of the invention is the use of said plant protein in the manufacture of food. | 01-17-2013 |
20130228168 | METHOD FOR DECONTAMINATING STARCH HYDROLYSATES FOR THE PREPARATION OF GLUCOSE POLYMERS FOR PERITONEAL DIALYSIS - The subject matter of the invention is a method for decontaminating starch hydrolysates from which glucose polymers for producing peritoneal dialysis solutions will be prepared. | 09-05-2013 |
20140106051 | MICROALGAL FLOUR GRANULES AND PROCESS FOR PREPARATION THEREOF - The present invention relates to microalgal flour granules, and optionally, lipid-rich microalgal flour. | 04-17-2014 |
20140212570 | MICROALGAL FLOUR - The present invention relates to microalgal food products with acceptable sensory characteristics and methods of producing the food products. The flour can be produced by cultivating microalgal cells of a strain of | 07-31-2014 |
20140234479 | MICROALGAL FLOUR - The present invention relates to microalgal food products with acceptable sensory characteristics and methods of producing the food products. The flour can be produced by cultivating microalgal cells of a strain of | 08-21-2014 |