Patents by Inventor Dek J. Shee

Dek J. Shee 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).

  • Monitoring database performance by obtaining SQL addresses for SQL statements
    Patent number: 7325016
    Abstract: The present invention provides a method and system for monitoring the process performance of a database that accepts and records SQL statements and that records the status of a session of use of the database. The invention obtains the SQL address and hash value for each SQL statement, the current session status corresponding to each SQL statement and the previous session status corresponding to each SQL statement. The invention also records a time stamp at the time the session status information is obtained. The information gathering steps are repeated at a predetermined interval of time. Using the information gathered, the run time for each SQL statement is calculated. The run time for each SQL statement may then be reviewed to determine which SQL statements experience the greatest run time, which allows DBAs to locate the source of any performance problems.
    Type: Grant
    Filed: May 13, 2005
    Date of Patent: January 29, 2008
    Assignee: Sprint Communications Company L.P.
    Inventor: Dek J. Shee
  • Database performance monitoring method and tool
    Patent number: 6910036
    Abstract: The present invention provides a method and system for monitoring the process performance of a database that accepts and records SQL statements and that records the status of a session of use of the database. The invention obtains the SQL address and hash value for each SQL statement, the current session status corresponding to each SQL statement and the previous session status corresponding to each SQL statement. The invention also records a time stamp at the time the session status information is obtained. The information gathering steps are repeated at a predetermined interval of time. Using the information gathered, the run time for each SQL statement is calculated. The run time for each SQL statement may then be reviewed to determine which SQL statements experience the greatest run time, which allows DBAs to locate the source of any performance problems.
    Type: Grant
    Filed: January 17, 2002
    Date of Patent: June 21, 2005
    Assignee: Sprint Communications Company L.P.
    Inventor: Dek J. Shee
  • Database performance monitoring method and tool
    Publication number: 20030110153
    Abstract: The present invention provides a method and system for monitoring the process performance of a database that accepts and records SQL statements and that records the status of a session of use of the database. The invention obtains the SQL address and hash value for each SQL statement, the current session status corresponding to each SQL statement and the previous session status corresponding to each SQL statement. The invention also records a time stamp at the time the session status information is obtained. The information gathering steps are repeated at a predetermined interval of time. Using the information gathered, the run time for each SQL statement is calculated. The run time for each SQL statement may then be reviewed to determine which SQL statements experience the greatest run time, which allows DBAs to locate the source of any performance problems.
    Type: Application
    Filed: December 11, 2001
    Publication date: June 12, 2003
    Applicant: Sprint Communications Company L.P.
    Inventor: Dek J. Shee