Back to results
US 7,925,674 B2Granted
Management of a distributed database
AssigneeOracle International Corporation
InventorsByron Wang, Nimar Arora, Lik Wong, Jingwei Wu, Jun Yuan
Life of this patent
Estimating the term…
Abstract
Systems, methodologies, media, and other embodiments associated with managing of a distributed database are described. One exemplary system embodiment includes an input logic configured to obtain information associated with a distributed database where the distributed database comprises a plurality of databases. An analysis logic analyzes the information obtained from the distributed database to determine performance information associated with the distributed database and, an output logic can provide information regarding the performance information associated with the distributed database.
Claims21
A distributed database management system comprising:
- means for identifying a database component in a distributed database at which a flow of data terminates, the distributed database comprising a plurality of database components being stored on different hardware memory devices and together creating the distributed database, that appears to applications as a single database;
- means for determining one or more topology paths between database components in a distributed database and links between the database components paths by identifying a destination component at which a flow of data terminates, traversing database component links from the destination component toward a source component from which the flow of data originates, and including one or more database components that are traversed as part of the one or more identified topology paths;
- means for traversing database component links between database components from the identified database component toward an originating database component from which the flow of data was started;
- means for including one or more database components and links that are traversed as part of one or more identified topology paths where at least one topology path traverses components and component links associated with databases stored on at least two different storage mechanisms;
- means for obtaining performance data collected by for individual database components in the one or more identified topology paths;
- means for aggregating the database components, performance-related information associated with the database components, and database component links to form a topology of the distributed database that includes performance information for individual database components in the distributed database
- means for identifying one or more database components as bottleneck components based, at least in part, on the performance data;
- and
- means for providing a visual representation of the one or more identified topology paths based, at least in part, on the performance data for one or more database components.
6 more elements
A distributed database management system, comprising:
- a hardware processor;
- an input logic to separately access plurality of database components in a distributed database to obtain performance-related information collected by the database components, the plurality of database components being stored on different hardware memory devices and together creating the distributed database that appears to applications as a single database;
- a performance logic to identify one or more database topology paths by identifying a destination component at which a flow of data terminates, traversing database component links from the destination component toward a source component from which the flow of data was started, and including one or more database components that are traversed as part of the one or more identified topology paths, and where the performance logic is configured to analyze the flow of data along the one or more identified topology paths and provide information related to the flow of data along the one or more identified topology paths;
- a topology logic that traverses data paths between database components and identifies database components on the traversed data paths by identifying a flow of data, identifying the source component, and identifying the destination component to determine a topology of the distributed database that includes the identified database components and database component links between the database components on the one or more identified topology paths, the topology logic aggregating the database components, performance-related information associated with the database components, and database component links to form a topology of the distributed database that includes performance information for individual database components in the distributed database;
- and
- an output logic to provide a visual representation of the determined topology.
3 more elements
A non-transitory computer-readable storage medium having stored thereon computer-executable instructions that when executed by a machine cause the machine to perform a method, the method comprising:
- determining one or more topology paths between database components in a distributed database and links between the database components paths by identifying a destination component at which a flow of data terminates, traversing database component links from the destination component toward a source component from which the flow of data originates, and including one or more database components that are traversed as part of the one or more identified topology paths, the distributed database comprising a plurality of database components being stored on different memory devices and together creating the distributed database, to applications as a single database;
- obtaining performance data for individual database components in the one or more topology paths by separately accessing the database components to obtain performance-related information collected by the database components;
- analyzing the flow of data along the identified topology paths to provide information related to the flow of data along the one or more identified topology paths;
- aggregating the database components, performance-related information associated with the database components, and database component between the database components on the one or more identified topology paths to form a topology of the distributed database that includes performance information for individual database components in the distributed database;
- and
- identifying one or more database components as bottleneck components based, at least in part, on the performance data.
3 more elements
A method comprising:
- determining one or more topology paths between database components in a distributed database and links between the database components by identifying a destination component at which a flow of data terminates, traversing database component links from the destination component toward a source component from which the flow of data originates, and including one or more database components that are traversed as part of the one or more identified topology paths, the distributed database comprising a plurality of database components being stored on different memory devices and together creating the distributed database, that appears to applications as a single database;
- obtaining performance data for individual database components in the one or more topology paths by separately accessing the database components to obtain performance-related information collected by the database components;
- analyzing the flow of data along the identified topology paths to provide information related to the flow of data along the one or more identified topology paths;
- aggregating the database components, performance-related information associated with the database components, and database component links to form a topology of the distributed database that includes performance information for individual database components in the distributed database;
- and
- identifying one or more database components as bottleneck components based, at least in part, on the performance data.
3 more elements
Dependencies are inferred from the claim text.