Patents by Inventor GianFranco Putzolu
GianFranco Putzolu 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: 7526508Abstract: An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.Type: GrantFiled: September 3, 2004Date of Patent: April 28, 2009Assignee: Oracle International CorporationInventors: Leng Leng Tan, Gianfranco Putzolu, Richard Sarwal, Alex Tsukerman, Gary C. Ngai, Graham Stephen Wood, Karl Dias, Mark Ramacher, Benoit Dageville, Mohamed Ziauddin, Tirthankar Lahiri, Sujatha Muthulingam, Vishwanath Karra, Francisco Sanchez, Hsiao-Te Su, Wanli Yang, Vasudha Krishnaswamy, Sushil Kumar
-
Patent number: 7107270Abstract: A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, at least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set. Only processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within the ownership group.Type: GrantFiled: February 25, 2004Date of Patent: September 12, 2006Assignee: Oracle International CorporationInventor: Gianfranco Putzolu
-
Publication number: 20060149701Abstract: A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, at least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set. Only processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within the ownership group.Type: ApplicationFiled: February 28, 2006Publication date: July 6, 2006Applicant: ORACLE INTERNATIONAL CORPORATIONInventor: Gianfranco Putzolu
-
Patent number: 7020599Abstract: A method for simulating different MTTR settings includes determining a simulated MTTR setting and providing a simulated checkpoint queue. The simulated checkpoint queue is associated with the simulated MTTR setting and is an ordered list of one or more elements. Each element represents a buffer, and the ordered list has a head and a tail. The method also includes providing a simulated write counter associated with the simulated MTTR setting. The method further includes, in response to detecting a change to a first buffer, checking if the first buffer is represented in the simulated checkpoint queue. If the first buffer is not represented in the simulated checkpoint queue, an element that represents the first buffer is linked to the tail of the simulated checkpoint queue. An MTTR advisory system includes a memory, one or more processors coupled to the memory, a simulated MTTR setting, a simulated checkpoint queue, and a simulated write counter. The simulated MTTR setting is maintained in the memory.Type: GrantFiled: December 13, 2001Date of Patent: March 28, 2006Assignee: Oracle International Corporation (OIC)Inventors: Qiang Cao, Sushil Kumar, Tirthankar Lahiri, Yunrui Li, Gianfranco Putzolu
-
Publication number: 20050086195Abstract: An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.Type: ApplicationFiled: September 3, 2004Publication date: April 21, 2005Inventors: Leng Leng Tan, Gianfranco Putzolu, Richard Sarwal, Alex Tsukerman, Gary Ngai, Graham Wood, Karl Dias, Mark Ramacher, Benoit Dageville, Mohamed Ziauddin, Tirthankar Lahiri, Sujatha Muthulingam, Vishwanath Karra, Francisco Sanchez, Hsiao-Te Su, Wanli Yang, Vasudha Krishnaswamy, Sushil Kumar
-
Patent number: 6804671Abstract: A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by generating the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and incorporating the associated metadata, without patching any of the disk pointers.Type: GrantFiled: January 28, 2003Date of Patent: October 12, 2004Assignee: Oracle International CorporationInventors: Juan R. Loaiza, Hasan Rizvi, J. William Lee, William H. Bridge, Jr., Jonathan D. Klein, Alex Tsukerman, Gianfranco Putzolu
-
Publication number: 20040172422Abstract: A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, at least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set. Only processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within the ownership group.Type: ApplicationFiled: February 25, 2004Publication date: September 2, 2004Applicant: ORACLE INTERNATIONAL CORPORATIONInventor: Gianfranco Putzolu
-
Patent number: 6711571Abstract: A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, a database system is provided which includes one or more persistent storage devices having a database stored thereon, and a plurality of database servers executing on a plurality of nodes. Each node has direct access to the persistent storage devices. At least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set.Type: GrantFiled: June 28, 2001Date of Patent: March 23, 2004Assignee: Oracle International CorporationInventor: Gianfranco Putzolu
-
Patent number: 6665684Abstract: Techniques are disclosed for expanding the concept of partitioning in variety of ways. In particular techniques are provided for performing multiple-dimension partitioning. In multiple-dimension partitioning, a database object is divided into partitions based on one criteria, and each of those resulting partitions is divided into sub-partitions based on a second criteria. The process of partitioning partitions based on different criteria may be repeated across any number of dimensions. Entirely different partitioning techniques may be used for each level of partitioning. The database server takes advantage of partitions when processing queries by selectively accessing a subset of partitions on disk or reducing the number of internal join operations.Type: GrantFiled: September 27, 1999Date of Patent: December 16, 2003Assignee: Oracle International CorporationInventors: Mohamed Zait, Benoit Dageville, Andre Kruglikov, Gianfranco Putzolu
-
Patent number: 6549901Abstract: Provided are mechanisms that may be used to support efficient exportation of user data stored in a database system. According to an aspect of the present invention, a database system is configured to store data for users in separate repositories referred to as tablespaces. To store data in this manner, a database system may be configured in variety of ways.Type: GrantFiled: September 29, 2000Date of Patent: April 15, 2003Assignee: Oracle CorporationInventors: Juan R. Loaiza, Hasan Rizvi, J. William Lee, William H. Bridge, Jr., Jonathan D. Klein, Alex Tsukerman, Gianfranco Putzolu
-
Publication number: 20020194157Abstract: Techniques are disclosed for expanding the concept of partitioning in variety of ways. In particular techniques are provided for performing multiple-dimension partitioning. In multiple-dimension partitioning, a database object is divided into partitions based on one criteria, and each of those resulting partitions is divided into sub-partitions based on a second criteria. The process of partitioning partitions based on different criteria may be repeated across any number of dimensions. Entirely different partitioning techniques may be used for each level of partitioning. The database server takes advantage of partitions when processing queries by selectively accessing a subset of partitions on disk or reducing the number of internal join operations.Type: ApplicationFiled: September 27, 1999Publication date: December 19, 2002Inventors: MOHAMED ZAIT, BENOIT DAGEVILLE, ANDRE KRUGLIKOV, GIANFRANCO PUTZOLU
-
Patent number: 6470423Abstract: Described herein are approaches for partitioning a buffer cache for dynamically selecting buffers in the buffer cache to store data items, such as data blocks in a DBMS. The selection is based on data access and/or usage patterns. A buffer cache includes multiple buffer pools. A buffer pool is selected from among the multiple buffer pools to store a data item. The selection of a buffer pool is based on various factors, including the likelihood that storing the data item will produce future cache hits, and properties of buffer pools that vary between the buffer pools. Properties of a buffer pool include not only how the buffer pools are organized, both logically and physically, but also how the buffer pool is managed. Examples of a buffer pool property include buffer pool size, size of a buffer in the buffer pool, and the replacement strategy used for a buffer pool (e.g. LRU).Type: GrantFiled: December 21, 2001Date of Patent: October 22, 2002Assignee: Oracle CorporationInventors: Alexander C. Ho, Ashok Joshi, Gianfranco Putzolu, Juan R. Loaiza, Graham Wood, William H. Bridge, Jr.
-
Patent number: 6370619Abstract: The present invention provides a method and apparatus for partitioning a buffer cache for dynamically mapping data blocks with a particular replacement strategy based on the associated table's access and/or usage patterns. According to the method, a buffer cache in a computer system is managed by dividing the buffer cache into multiple buffer pools. In managing the buffer cache, when a data item is requested, it is first determined whether the requested data item is stored in a buffer within the buffer cache. If the requested data item is not stored in a buffer in the buffer cache, then a particular buffer pool in the buffer cache is dynamically selected for storing the requested data item. Once the particular buffer pool is selected, the requested data item is stored into a buffer in the particular buffer pool.Type: GrantFiled: June 22, 1998Date of Patent: April 9, 2002Assignee: Oracle CorporationInventors: Alexander C. Ho, Ashok Joshi, Gianfranco Putzolu, Juan R. Loaiza, Graham Wood, William H. Bridge, Jr.
-
Patent number: 6370529Abstract: A method and apparatus for multi-phase locking for partition maintenance operations is provided. In the first phase, a shared data dictionary lock is acquired on a body of metadata in a data dictionary. Next, the data dictionary is read and a list of affected partitions is generated. In the second phase, an intent exclusive data lock is acquired on the affected table. Next, an exclusive data lock is acquired on the affected partitions of the affected table. The shared data dictionary lock on the data dictionary is released and a physical attribute of the data of the affected partitions is changed. In the third phase, an exclusive data dictionary lock is acquired on the data dictionary. The metadata associated with the affected partitions in the data dictionary is updated and the exclusive data locks on the affected partitions and the intent exclusive data lock on the affected table are released. Finally, the exclusive data dictionary lock on the data dictionary is released.Type: GrantFiled: January 11, 2000Date of Patent: April 9, 2002Assignee: Oracle CorporationInventors: Andre Kruglikov, Elizabeth Davis, Gianfranco Putzolu
-
Patent number: 6341340Abstract: A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. A mechanism is provided for transitioning ownership of a data item. Ownership is transferred by disabling access to the data item, waiting for all transactions that have made changes to the data item to either commit or abort, changing data that indicates ownership of the data item from a first owner to a second owner, and enabling access to the data item.Type: GrantFiled: December 28, 1998Date of Patent: January 22, 2002Assignee: Oracle CorporationInventors: Alex Tsukerman, Gary C. Ngai, Gianfranco Putzolu, J. William Lee
-
Patent number: 6321238Abstract: A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, a database system is provided which includes one or more persistent storage devices having a database stored thereon, and a plurality of database servers executing on a plurality of nodes. Each node has direct access to the persistent storage devices. At least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set.Type: GrantFiled: December 28, 1998Date of Patent: November 20, 2001Assignee: Oracle CorporationInventor: Gianfranco Putzolu
-
Publication number: 20010039550Abstract: A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, a database system is provided which includes one or more persistent storage devices having a database stored thereon, and a plurality of database servers executing on a plurality of nodes. Each node has direct access to the persistent storage devices. At least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set.Type: ApplicationFiled: June 28, 2001Publication date: November 8, 2001Inventor: Gianfranco Putzolu
-
Patent number: 6314114Abstract: An approach for managing resources in a distributed computing system includes establishing dedicated process pools on nodes where work is to be performed. Each dedicated process pool is associated with a particular remote node and includes one or more processes. The one or more processes in each dedicated process pool perform work on behalf of processes on the associated remote node. Each dedicated process pool is managed by processes on the associated remote node using local synchronization data maintained on the associated remote node. The assignment of particular processes to perform work on behalf of processes on the associated remote node is performed by the processes on the associated remote node. In addition, the spawning of additional processes or the termination of existing processes from a dedicated process pool is managed by the processes on the associated remote node.Type: GrantFiled: June 23, 1998Date of Patent: November 6, 2001Assignee: Oracle CorporationInventors: Mark Coyle, Gianfranco Putzolu
-
Patent number: 6272503Abstract: A database containing datafiles is partitioned into a set of tablespaces. Every disk pointer pointing to a data item in a datafile refers to a tablespace-relative file number for the datafile. Data pointed to by a tablespace-relative disk pointer is retrieved by first checking the cache, and upon a cache miss, the tablespace-relative file number is translated into an absolute file number according to a latch-free look up technique.Type: GrantFiled: May 30, 1997Date of Patent: August 7, 2001Assignee: Oracle CorporationInventors: William H. Bridge, Jr., Jonathan D. Klein, J. William Lee, Juan R. Loaiza, Alex Tsukerman, GianFranco Putzolu
-
Patent number: 6105026Abstract: A method and apparatus for multi-phase locking for partition maintenance operations. In the first phase, a shared data dictionary lock is acquired on a body of metadata in a data dictionary. Next, the data dictionary is read and a list of affected partitions is generated. In the second phase, an intent exclusive data lock is acquired on the affected table. Next, an exclusive data lock is acquired on the affected partitions of the affected table. The shared data dictionary lock on the data dictionary is released and a physical attribute of the data of the affected partitions is changed. In the third phase, an exclusive data dictionary lock is acquired on the data dictionary. The metadata associated with the affected partitions in the data dictionary is updated and the exclusive data locks on the affected partitions and the intent exclusive data lock on the affected table are released. Finally, the exclusive data dictionary lock on the data dictionary is released.Type: GrantFiled: July 3, 1997Date of Patent: August 15, 2000Assignee: Oracle CorporationInventors: Andre Kruglikov, Elizabeth Davis, Gianfranco Putzolu