Quality of service feedback for technology-neutral data reporting
View Patent ↗A system for providing feedback associated with the planning of a query is provided. The system comprises a query planning mechanism capable of determining transformations required for the execution of the query, and a monitoring mechanism for monitoring and extracting feedback information from the planning mechanism, the feedback information including an indication of the transformations.
1. A method of reporting quality of service feedback information for a query to a data source of a database management system, the method comprising:
receiving an agnostic query, wherein the agnostic query is independent of the database management system;
executing the agnostic query;
determining, with a computing resource of the database management system, a transformation required for execution of the agnostic query during a planning stage of the execution of the agnostic query, wherein the transformation transforms a first construct within the agnostic query into a second construct to enable the agnostic query to be executed with respect to the data source of the database management system, wherein the first construct is not appropriate for the data source of the database management system, and wherein the second construct is appropriate for the data source of the database management system;
during the planning stage of the execution of the agnostic query, collecting, with the computing resource, the quality of service feedback information concerning a quality of service of the execution of the agnostic query by the computing resource, the quality of service feedback information defining a trace through the transformation required for execution of the agnostic query with respect to the data source of the database management system, wherein the quality of service feedback information includes the transformation, a severity and a context, the context including an object for rendering the feedback information appropriate to an intended locale;
comparing, with the computing resource, the severity to an established threshold, the established threshold indicating a minimum level of severity of feedback information being rendered;
rendering the quality of service feedback information having the severity exceeding the established threshold using the object; and
reporting the rendered quality of service feedback information.
2. The method according to claim 1 wherein the established threshold is selected from a group consisting of: an error, a warning, a key transformation, and an information.
3. The method according to claim 2 wherein the key transformation is an unknown transformation preventing tracing back to the data source.
4. The method according to claim 1 wherein the intended locale is a system log.
5. The method according to claim 1 wherein the established threshold is established by a user or a system administrator.
6. The method according to claim 1 wherein the rendered feedback information is reported in a system log controlled by an administrator, or to a user in a response to the agnostic query.
7. The method of claim 1 , further comprising:
receiving additional quality of service feedback information from the data source during an execution stage of the agnostic query, the additional quality of service feedback information including a time required for the data source to execute the agnostic query; and
updating the quality of service feedback information to include the additional quality of service feedback information received from the data source.
8. The method of claim 1 ,
wherein receiving an agnostic query comprises receiving an agnostic query with a computing resource,
wherein executing the agnostic query comprises executing the agnostic query with the computing resource, and
wherein reporting the rendered quality of service feedback information comprises reporting the rendered quality of service feedback information with the computing device resource.