Method to measure stored procedure execution statistics

Error detection/correction and fault detection/recovery – Data processing system error or fault handling – Reliability and availability

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C714S037000, C717S127000, C717S131000, C717S135000

Reexamination Certificate

active

10341841

ABSTRACT:
The invention is a method to obtain actual stored procedure execution statistics while an overlying application is running. The method is accomplished by a software module running in background and acquires the execution statistics, including database writes and reads, for every stored procedure run. Statistics, such as the number of database writes and reads, are reported by the application's underlying database supervisory program. The resulting execution statistics are analyzed and selected information is saved to a stored procedure statistics database. Because the module can be run continuously in background, it can develop statistics for all procedure calls made under varying computing conditions with varying calling parameter sets. A statistical analysis of such acquired stored procedure execution statistics is useful for evaluating new versions of the complex software application, new stored procedures, modified stored procedures, and for locating a specific cause of application failure or reduced performance as caused by a malformed or malfunctioning stored procedure. Additionally, the method can flag anomalous performance, warning of previously undetected failure.

REFERENCES:
patent: 3872448 (1975-03-01), Mitchell, Jr.
patent: 4751702 (1988-06-01), Beier et al.
patent: 5748978 (1990-05-01), Rees et al.
patent: 5027269 (1991-06-01), Grant et al.
patent: 5075881 (1991-12-01), Blomberg et al.
patent: 5159687 (1992-10-01), Richburg
patent: 5168444 (1992-12-01), Cukor et al.
patent: 5202986 (1993-04-01), Nickel
patent: 5278982 (1994-01-01), Daniels et al.
patent: 5313616 (1994-05-01), Cline et al.
patent: 5347518 (1994-09-01), Lee et al.
patent: 5386551 (1995-01-01), Chikira et al.
patent: 5446895 (1995-08-01), White et al.
patent: 5455946 (1995-10-01), Mohan et al.
patent: 5471613 (1995-11-01), Banning et al.
patent: 5471629 (1995-11-01), Risch
patent: 5482139 (1996-01-01), Rivalto
patent: 5511117 (1996-04-01), Zazzera
patent: 5539885 (1996-07-01), Ono et al.
patent: 5549117 (1996-08-01), Tacklind et al.
patent: 5563998 (1996-10-01), Yakish et al.
patent: 5566297 (1996-10-01), Devarakonda
patent: 5594863 (1997-01-01), Stiles
patent: 5630047 (1997-05-01), Wang
patent: 5630069 (1997-05-01), Flores et al.
patent: 5630173 (1997-05-01), Oprescu
patent: 5655074 (1997-08-01), Rauscher
patent: 5701470 (1997-12-01), Joy et al.
patent: 5712971 (1998-01-01), Stanfill et al.
patent: 5721913 (1998-02-01), Ackroff et al.
patent: 5721914 (1998-02-01), De Vries
patent: 5752034 (1998-05-01), Srivastava et al.
patent: 5758061 (1998-05-01), Plum
patent: 5758062 (1998-05-01), McMahon et al.
patent: 5764972 (1998-06-01), Crouse et al.
patent: 5768506 (1998-06-01), Randell
patent: 5774553 (1998-06-01), Rosen
patent: 5781448 (1998-07-01), Nakamura et al.
patent: 5784557 (1998-07-01), Oprescu
patent: 5784562 (1998-07-01), Diener
patent: 5787402 (1998-07-01), Potter et al.
patent: 5799297 (1998-08-01), Goodridge et al.
patent: 5806075 (1998-09-01), Jain et al.
patent: 5828883 (1998-10-01), Hall
patent: 5832523 (1998-11-01), Kanai et al.
patent: 5835770 (1998-11-01), Shum et al.
patent: 5842196 (1998-11-01), Agarwal et al.
patent: 5845292 (1998-12-01), Bohannon et al.
patent: 5845293 (1998-12-01), Veghte et al.
patent: 5872976 (1999-02-01), Yee et al.
patent: 5884037 (1999-03-01), Aras et al.
patent: 5903721 (1999-05-01), Sixtus
patent: 5903897 (1999-05-01), Carrier, III et al.
patent: 5907846 (1999-05-01), Berner et al.
patent: 5920719 (1999-07-01), Sutton et al.
patent: 5937198 (1999-08-01), Nelson et al.
patent: 5960196 (1999-09-01), Carrier, III et al.
patent: 5960445 (1999-09-01), Tamori et al.
patent: 5978477 (1999-11-01), Hull et al.
patent: 5995965 (1999-11-01), Experton
patent: 6003075 (1999-12-01), Arendt et al.
patent: 6009274 (1999-12-01), Fletcher et al.
patent: 6009405 (1999-12-01), Leymann et al.
patent: 6012087 (2000-01-01), Freivald et al.
patent: 6014671 (2000-01-01), Castelli et al.
patent: 6026237 (2000-02-01), Berry et al.
patent: 6028938 (2000-02-01), Malkin et al.
patent: 6029002 (2000-02-01), Afifi et al.
patent: 6058393 (2000-05-01), Meier et al.
patent: 6061503 (2000-05-01), Chamberlain
patent: 6061643 (2000-05-01), Walker et al.
patent: 6061686 (2000-05-01), Gauvin et al.
patent: 6065009 (2000-05-01), Leymann et al.
patent: 6067412 (2000-05-01), Blake et al.
patent: 6073107 (2000-06-01), Minkiewicz et al.
patent: 6081808 (2000-06-01), Blackman et al.
patent: 6088700 (2000-07-01), Larsen et al.
patent: 6101601 (2000-08-01), Matthews et al.
patent: 6108673 (2000-08-01), Brandt et al.
patent: 6108698 (2000-08-01), Tenev et al.
patent: 6125390 (2000-09-01), Touboul
patent: 6128708 (2000-10-01), Fitzpatrick et al.
patent: 6138112 (2000-10-01), Slutz
patent: 6138158 (2000-10-01), Boyle et al.
patent: 6145121 (2000-11-01), Levy et al.
patent: 6163776 (2000-12-01), Periwal
patent: 6167534 (2000-12-01), Straathof et al.
patent: 6175833 (2001-01-01), West et al.
patent: 6188400 (2001-02-01), House et al.
patent: 6195676 (2001-02-01), Spix et al.
patent: 6226652 (2001-05-01), Percival et al.
patent: 6230319 (2001-05-01), Britt, Jr. et al.
patent: 6237035 (2001-05-01), Himmel et al.
patent: 6237143 (2001-05-01), Fontana et al.
patent: 6243862 (2001-06-01), Lebow
patent: 6247029 (2001-06-01), Kelley et al.
patent: 6249877 (2001-06-01), Kawakami et al.
patent: 6256635 (2001-07-01), Arrouye et al.
patent: 6263121 (2001-07-01), Melen et al.
patent: 6266683 (2001-07-01), Yehuda et al.
patent: 6269479 (2001-07-01), Puram
patent: 6279008 (2001-08-01), Tung Ng et al.
patent: 6279039 (2001-08-01), Bhat et al.
patent: 6301701 (2001-10-01), Walker et al.
patent: 6311320 (2001-10-01), Jibbe
patent: 6311327 (2001-10-01), O'brien et al.
patent: 6336122 (2002-01-01), Lee et al.
patent: 6353897 (2002-03-01), Nock et al.
patent: 6356920 (2002-03-01), Vanderslius
patent: 6363499 (2002-03-01), Delo et al.
patent: 6363524 (2002-03-01), Loy
patent: 6381609 (2002-04-01), Breitbart et al.
patent: 6385618 (2002-05-01), Ng et al.
patent: 6397221 (2002-05-01), Greef et al.
patent: 6405209 (2002-06-01), Obendorf
patent: 6405250 (2002-06-01), Lin et al.
patent: 6405364 (2002-06-01), Bowman-Amuah
patent: 6411910 (2002-06-01), Eulau et al.
patent: 6411957 (2002-06-01), Dijkstra
patent: 6418446 (2002-07-01), Lection et al.
patent: 6418448 (2002-07-01), Sarkar
patent: 6418451 (2002-07-01), Maimone
patent: 6424981 (2002-07-01), Isaac et al.
patent: 6438749 (2002-08-01), Chamberlain
patent: 6446126 (2002-09-01), Huang et al.
patent: 6449623 (2002-09-01), Bohannon et al.
patent: 6453310 (2002-09-01), Zander
patent: 6456995 (2002-09-01), Salo et al.
patent: 6463454 (2002-10-01), Lumelsky et al.
patent: 6466980 (2002-10-01), Lumelsky et al.
patent: 6467052 (2002-10-01), Kaler et al.
patent: 6470464 (2002-10-01), Bertram et al.
patent: 6477471 (2002-11-01), Hedstrom et al.
patent: 6477540 (2002-11-01), Singh et al.
patent: 6490581 (2002-12-01), Neshatfar et al.
patent: 6502095 (2002-12-01), Breitbart et al.
patent: 6502104 (2002-12-01), Fung et al.
patent: 6502207 (2002-12-01), Itoh et al.
patent: 6505176 (2003-01-01), DeFrancesco, Jr. et al.
patent: 6513154 (2003-01-01), Porterfield
patent: 6519763 (2003-02-01), Kaufer et al.
patent: 6526443 (2003-02-01), Goldsmith et al.
patent: 6532467 (2003-03-01), Brocklebank et al.
patent: 6535894 (2003-03-01), Schmidt et al.
patent: 6539337 (2003-03-01), Provan et al.
patent: 6539383 (2003-03-01), Charlet et al.
patent: 6539397 (2003-03-01), Doan et al.
patent: 6539398 (2003-03-01), Hannan et al.
patent: 6546506 (2003-04-01), Lewis
patent: 6557039 (2003-04-01), Leong et al.
patent: 6560580 (2003-05-01), Fraser et al.
patent: 6571249 (2003-05-01), Garrecht et al.
patent: 6574640 (2003-06-01), Stahl
patent: 6578004 (2003-06-01), Cimral et al.
patent: 6578006 (2003-06-01), Saito et al.
patent: 6578129 (2003-06-01), da Silva Junior et al.
patent: 6584447 (2003-06-01), Fox et al.
patent: 6587841 (2003-07-01), DeFrancesco et al.
patent: 6591260 (2003-07-01), Schwarzhoff et al.
patent: 6601017 (2003-07-01), Kennedy et al.
patent: 6601018 (2003-07-01), Logan
patent: 6601075 (2003-07-01)

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Method to measure stored procedure execution statistics does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method to measure stored procedure execution statistics, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method to measure stored procedure execution statistics will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3916311

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.