Patents by Inventor Paolo Fragapane
Paolo Fragapane has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 9934330Abstract: A query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.Type: GrantFiled: April 30, 2013Date of Patent: April 3, 2018Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Natascha Kearsey, Christian Evans, Martin Hogg, Paolo Fragapane, Steve Corbett
-
Patent number: 9158818Abstract: Facilitating identification of star schemas in database environments. In an embodiment, queries directed to relational database tables (organized according to normalized schema) are examined to determine the relationships specified in the queries. A star schema is then generated by including the specified relationships. A data warehouse may be organized according to the generated star schema and the data previously stored in the database tables may be copied to the data warehouse.Type: GrantFiled: April 5, 2007Date of Patent: October 13, 2015Assignee: Oracle International CorporationInventors: Geemon Kadambalil Baby, Mahesh Jayashankar, Paolo Fragapane, Suresh Mali, Mike Durran, Ashish Mittal, James Steadman
-
Patent number: 8695006Abstract: There is provided a method of managing a resource within a computer system using a configuration wrapper, the method comprising: providing a configuration file comprising configuration data for the resource; generating metadata related to the configuration data; and automatically processing the metadata to produce a configuration wrapper for the resource. The configuration wrapper may be a java object with management attributes and methods.Type: GrantFiled: May 2, 2008Date of Patent: April 8, 2014Assignee: Oracle International CorporationInventors: Richard Grieve, Paolo Fragapane
-
Publication number: 20130246464Abstract: A query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.Type: ApplicationFiled: April 30, 2013Publication date: September 19, 2013Applicant: Oracle International CorporationInventors: Natascha Kearsey, Christian Evans, Martin Hogg, Paolo Fragapane, Steve Corbett
-
Patent number: 8447771Abstract: A query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.Type: GrantFiled: November 20, 2006Date of Patent: May 21, 2013Assignee: Oracle International CorporationInventors: Natascha Kearsey, Christian Evans, Martin Hogg, Paolo Fragapane, Steve Corbett
-
Patent number: 7814090Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.Type: GrantFiled: May 31, 2005Date of Patent: October 12, 2010Assignee: Oracle International CorporationInventors: Jitendra Dhamija, Suresh Mali, Christopher Evans, Paolo Fragapane, James Steadman, Andrew Osborn
-
Patent number: 7725457Abstract: A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.Type: GrantFiled: December 19, 2003Date of Patent: May 25, 2010Assignee: Oracle International CorporationInventors: Christopher Evans, Paolo Fragapane, Stephen Cave, Andrew Osborn
-
Publication number: 20090276784Abstract: There is provided a method of managing a resource within a computer system using a configuration wrapper, the method comprising: providing a configuration file comprising configuration data for the resource; generating metadata related to the configuration data; and automatically processing the metadata to produce a configuration wrapper for the resource. The configuration wrapper may be a java object with management attributes and methods.Type: ApplicationFiled: May 2, 2008Publication date: November 5, 2009Applicant: Oracle International CorporationInventors: Richard Grieve, Paolo Fragapane
-
Patent number: 7467152Abstract: The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.Type: GrantFiled: December 7, 2000Date of Patent: December 16, 2008Assignee: Oracle International CorporationInventors: Natascha Kearsey, Stephen David Cave, Andrew Osborn, Robert Lloyd Lavender, Kathryn Nash, Paolo Fragapane
-
Publication number: 20080249985Abstract: Facilitating identification of star schemas in database environments. In an embodiment, queries are examined to determine the joins required. The two tables of each join are added as a relationship in the star schema.Type: ApplicationFiled: April 5, 2007Publication date: October 9, 2008Applicant: Oracle International CorporationInventors: Geemon Kadambalil Baby, Mahesh Jayashankar, Paolo Fragapane, Suresh Mali, Mike Durran, Ashish Mittal, James Steadman
-
Publication number: 20080120326Abstract: A query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.Type: ApplicationFiled: November 20, 2006Publication date: May 22, 2008Applicant: Oracle International CorporationInventors: Natascha Kearsey, Christian Evans, Martin Hogg, Paolo Fragapane, Steve Corbett
-
Patent number: 7370062Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is disclosed. The method includes determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement may then be produced that only refers to the detail table using the identifier to the rows of the detail table. Subsequently, the revised SQL statement is processed.Type: GrantFiled: September 30, 2003Date of Patent: May 6, 2008Assignee: Oracle International CorporationInventors: Christopher Evans, Paolo Fragapane, Stephen Cave, James Steadman, Andrew Osborn, Kathryn Nash
-
Publication number: 20070239659Abstract: A query generator for generating a query for retrieving a desired set of data from a relational database is disclosed. The query generator is adapted to: a) receive an input query adapted to retrieve a superset of the desired set of data from the database; b) analyse a default filters table comprising one or more filter application criteria, each associated with a default filter condition that refers to data contained in the superset of data; and c) for each filter application criterion that is satisfied, modify the input query in accordance with the associated default filter condition to produce an output query adapted to retrieve the desired set of data only.Type: ApplicationFiled: March 30, 2006Publication date: October 11, 2007Inventors: Paolo Fragapane, Natascha Kearsey, Christopher Evans, Martin Hogg
-
Publication number: 20060271529Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: a) receive user input indicating selected items to be retrieved from the database; b) ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, c) if so: i) create a second view that is a copy of the first view and add a copy of each reach through item to it; and ii) create a query that refers only to the second view and the items exposed by it.Type: ApplicationFiled: May 31, 2005Publication date: November 30, 2006Inventors: Jitendra Dhamija, Suresh Mali, Christopher Evans, Paolo Fragapane, James Steadman, Andrew Osborn
-
Publication number: 20050076007Abstract: A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is described. The method comprises: a) presenting the SQL statement to the database; b) identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria; and c) for each identified join, modifying the SQL statement so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.Type: ApplicationFiled: December 19, 2003Publication date: April 7, 2005Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, Andrew Osborn
-
Publication number: 20040220928Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is described.Type: ApplicationFiled: September 30, 2003Publication date: November 4, 2004Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, James Steadman, Andrew Osborn, Kathryn Nash
-
Publication number: 20040220917Abstract: A method of preventing execution of unnecessary joins between tables in a database is described.Type: ApplicationFiled: September 30, 2003Publication date: November 4, 2004Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, James Steadman, Andrew Osborn, Kathryn Nash
-
Patent number: 6810399Abstract: The present invention relates to a repository which stores properties of database objects. The repository includes a first store for storing a number of predetermined properties, and a second store for storing additional properties. A processor is provided for determining or modifying the properties stored in the first and second stores.Type: GrantFiled: December 7, 2000Date of Patent: October 26, 2004Assignee: Oracle International CorporationInventors: Paolo Fragapane, Stephen David Cave, Robert Lloyd Lavender, James Adam Steadman, Andrew Osborn
-
Publication number: 20020046211Abstract: The present invention relates to a repository which stores properties of database objects. The repository includes a first store for storing a number of predetermined properties, and a second store for storing additional properties. A processor is provided for determining or modifying the properties stored in the first and second stores.Type: ApplicationFiled: December 7, 2000Publication date: April 18, 2002Inventors: Paolo Fragapane, Stephen David Cave, Robert Lloyd Lavender, James Adam Steadman, Andrew Osborn
-
Publication number: 20020010695Abstract: The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.Type: ApplicationFiled: December 7, 2000Publication date: January 24, 2002Inventors: Natascha Kearsey, Stephen David Cave, Andrew Osborn, Robert Lloyd Lavender, Kathryn Nash, Paolo Fragapane