Database management system and method which automatically schedules and performs actions and monitors results

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 6996576
APP PUB NO 20020091672A1
SERIAL NO

09991561

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A system and method for automated database management are provided. Statistics relating to operation of a database may be collected, wherein the database comprises one or more database objects. Characteristics of the database objects may be determined, either automatically or by user intervention, using the collected statistics, one or more policies, and/or one or more definitions. The policies and definitions may be defaults or may be customized by a user. Actions to be performed on the database objects may be determined, either automatically or by user intervention, based on the characteristics of the database objects. A schedule for performing the actions on the database objects may be automatically determined. The actions may be performed on the database objects based on the schedule. The actions on the database objects may be confirmed. The results of the actions on the database objects may be analyzed or monitored. Policies and/or definitions may be reconfigured based on the results. The system and method may automatically decide to perform one or more REORG actions on the database objects based on the statistics. A recommendation of a modification to one or more of the database objects may be generated based on the statistics. The scheduled actions may be modified as a result of detecting a change in the characteristics or usage of at least one of the database objects.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
BMC SOFTWARE, INC.HOUSTON, TX316

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Slavin, Jeff Austin, TX 5 79
Vos, Melody Dripping Springs, TX 5 84

Cited Art Landscape

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (3)
5327559 Remote and batch processing in an object oriented programming system 111 1990
5590056 Method and apparatus for computer program usage monitoring 78 1995
* 6282570 Monitoring a large parallel database through dynamic grouping and sequential sampling 46 1998
 
ORACLE INTERNATIONAL CORPORATION (1)
* 6370522 Method and mechanism for extending native optimization in a database system 54 1999
 
HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP (1)
2004/0111,441 Symbiotic wide-area file system and method 23 2002
* Cited By Examiner

Patent Citation Ranking

Forward Cite Landscape

Patent Info (Count) # Cites Year
 
Other [Check patent profile for assignment information] (3)
* 2005/0038,830 Distribution of mainframe data in the PC environment 4 2004
8868515 Distribution of mainframe data in the PC environment 1 2008
* 2009/0157,758 Distribution of mainframe data in the PC environment 2 2008
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (7)
* 7472108 Statistics collection using path-value pairs for relational databases 4 2006
* 2007/0271,218 Statistics collection using path-value pairs for relational databases 5 2006
* 2008/0155,641 METHOD AND SYSTEM MANAGING A DATABASE SYSTEM USING A POLICY FRAMEWORK 15 2006
8639657 Reorganizing table-based data objects 0 2008
9117005 Statistics collection using path-value pairs for relational databases 1 2008
* 8229924 Statistics collection using path-identifiers for relational databases 0 2009
* 2010/0011,030 STATISTICS COLLECTION USING PATH-IDENTIFIERS FOR RELATIONAL DATABASES 2 2009
 
ORACLE INTERNATIONAL CORPORATION (6)
* 7873606 Advisor framework, systems, methods and software for implementing the same 1 2004
* 2006/0059,170 Advisor framework, systems, methods and software for implementing the same 2 2004
8868482 Inferring schemas from XML document collections 1 2008
* 2010/0030,727 Technique For Using Occurrence Constraints To Optimize XML Index Access 7 2008
8650182 Mechanism for efficiently searching XML document collections 11 2009
* 2010/0228,734 MECHANISM FOR EFFICIENTLY SEARCHING XML DOCUMENT COLLECTIONS 7 2009
 
ENTIT SOFTWARE LLC (5)
* 7571225 Standard operating procedure automation in database administration 2 2007
* 2008/0016,123 STANDARD OPERATING PROCEDURE AUTOMATION IN DATABASE ADMINISTRATION 6 2007
* 7529827 Standard operating procedure automation in database administration 2 2007
8738753 Standard operating procedure automation in database administration 1 2009
* 2009/0177,707 STANDARD OPERATING PROCEDURE AUTOMATION IN DATABASE ADMINISTRATION 0 2009
 
CA, INC. (1)
* 2010/0211,815 SYSTEM AND METHOD FOR MODIFYING EXECUTION OF SCRIPTS FOR A JOB SCHEDULER USING DEONTIC LOGIC 6 2010
 
CLEAR BLUE SECURITY, LLC (2)
* 2008/0155,386 NETWORK DISCOVERY SYSTEM 7 2007
* 2008/0155,086 AGENT MANAGEMENT SYSTEM 9 2007
 
Steele, Jody (1)
8266477 System and method for modifying execution of scripts for a job scheduler using deontic logic 7 2010
 
TOYOTA MOTOR EAST JAPAN, INC. (2)
* 8267424 Airbag 10 2008
* 2010/0264,631 AIRBAG 7 2008
 
MICROSOFT TECHNOLOGY LICENSING, LLC (5)
8396845 Data-tier application component 1 2008
8380684 Data-tier application component fabric management 0 2008
* 2010/0082,549 DATA-TIER APPLICATION COMPONENT FABRIC MANAGEMENT 0 2008
* 9336380 Applying activity actions to frequent activities 0 2010
* 2012/0159,564 APPLYING ACTIVITY ACTIONS TO FREQUENT ACTIVITIES 5 2010
 
CYBERMATION INTERNATIONAL DISTRIBUTION SRL (2)
8171474 System and method for managing, scheduling, controlling and monitoring execution of jobs by a job scheduler utilizing a publish/subscription interface 9 2005
* 2006/0095,914 System and method for job scheduling 5 2005
* Cited By Examiner

Maintenance Fees

Fee Large entity fee small entity fee micro entity fee due date
11.5 Year Payment $7400.00 $3700.00 $1850.00 Aug 7, 2017
Fee Large entity fee small entity fee micro entity fee
Surcharge - 11.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge after expiration - Late payment is unavoidable $700.00 $350.00 $175.00
Surcharge after expiration - Late payment is unintentional $1,640.00 $820.00 $410.00