Data storage system for analysis of data across heterogeneous information management systems
원문보기
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06F-017/30
G06F-003/0482
출원번호
US-0918037
(2015-10-20)
등록번호
US-9633025
(2017-04-25)
발명자
/ 주소
Gokhale, Parag
Singh, Parminder
출원인 / 주소
Commvault Systems, Inc.
대리인 / 주소
Perkins Coie LLP
인용정보
피인용 횟수 :
1인용 특허 :
134
초록▼
Systems and methods for generating customized reports from data storage databases and other information management system databases. The methods include normalizing queried information from different types of information management system databases to enable system-wide report generation. Other impl
Systems and methods for generating customized reports from data storage databases and other information management system databases. The methods include normalizing queried information from different types of information management system databases to enable system-wide report generation. Other implementations are disclosed.
대표청구항▼
1. An information management system configured to create graphical reports associated with a status of the information management system, the system comprising: a first information management cell having a first storage manager coupled, via a first network, to a first plurality of computing devices,
1. An information management system configured to create graphical reports associated with a status of the information management system, the system comprising: a first information management cell having a first storage manager coupled, via a first network, to a first plurality of computing devices, wherein the first storage manager includes a first storage manager database to store a first data storage policy associated with the first plurality of computing devices, wherein the first data storage policy includes rules that determine a frequency by which the first storage manager causes data that is stored by the first plurality of computing devices to be backed up by a secondary storage device,wherein the first storage manager database is a first type of database; anda second information management cell connected to the first information management cell and having a second storage manager coupled, via a second, network to a second plurality of computing devices, wherein the second storage manager includes a second storage manager database to store a second data storage policy associated with the second plurality of computing devices, wherein the second storage manager database is a second type of database that is different from the first type of database,wherein the second storage manager includes a memory storing instructions,wherein the second storage manager includes a processor coupled to the memory, wherein the instructions are executable by the processor to cause the second storage manager to: receive an input from a user to query the first storage manager database and the second storage manager database,identify the first storage manager database as the first type of database and the second storage manager database as the second type of database,query the first storage manager database using a first set of query commands,identify a data format of the information received in response to the first set of query commands as a first data format,query the second storage manager database using a second set of query commands,identify a data format of the information received in response to the second set of query commands as a second data format, wherein the first set of query commands are different from the second set of query commands and the first set of query commands are based on identifying the first storage manager database as the first type of database,normalize information received in response to the query of the first storage manager database to be compatible with the second data format,merge and sort the normalized results and information received in response of the query of the second storage manager into an interim database associated with a report generation agent that generates the displayed reports, wherein the merged results represent database content for heterogeneous information management cells,display a graphical report of the information in the interim database, based on the input received from the user;populate a user interface with a list of content identifiers for views, tables, or columns of the first storage manager database and of the second storage manager database,wherein the instructions to cause the second storage manager to receive the input from the user includes instructions to cause the second storage manager to receive user selections of some of the list of content identifiers with the user interface,wherein the user interface includes with table names and column or row names from the common database format, andwherein the interface is configured to permit the user to select sets of information displayed via the user interface, and to query the first and second storage manager databases without requiring the user to be able to program in a database language. 2. The system of claim 1 wherein the first type of database is one of: a document-oriented database, a distributed database, and an object-relational database,wherein the instructions further cause the second storage manager to receive a non-table object in response to using first set of query commands on the first type of database,wherein the instructions to cause the second storage manager to normalize the received information includes converting the non-table object received from the first storage manager database into a database table. 3. The system of claim 1 wherein the instructions to cause the second storage manager to receive the input includes instructions to cause the second storage manager to receive a network address of the first storage manager database, wherein the instructions to cause the second storage manager to identify the first storage manager as the first type includes instructions to cause the second storage manager to query the first storage manager database to determine the type of the first storage manager database by using the network address of the first storage manager database received from the user. 4. The system of claim 1 wherein the instructions to cause the second storage manager to identify the first storage manager as the first type includes instructions to cause the second storage manager to query the first storage manager database to determine the type of the first storage manager database by using a look-up table. 5. The system of claim 1 wherein the graphical report includes at least one of a data table, a bar graph, and a pie chart, wherein the database management system models include at least three of flat models, hierarchical models, network models, relational models, dimensional models, object-relational models, document models, and object models. 6. The system of claim 1, further comprising: associating a graphing function with the user interface so that the at least one selection from the list of content identifiers is associated with the graphing function,wherein displaying the graphical report includes using the graphing function to display the at least one selection from the list of content identifiers. 7. The system of claim 1 wherein the user interface includes at least one of a drop-down menu, a combo box, a list of check boxes, and a list of radio buttons to enable interaction with the user interface without typing database commands. 8. A method for displaying graphical reports of a status of an information management system, wherein the information management system includes a first information management subnetwork having a first plurality of computing devices and a second information management subnetwork having a second plurality of computing devices, the method comprising: populating, with a computing device, a graphical user interface object with a list of content identifiers for heterogeneous information management system databases, wherein the heterogeneous information management system databases include: a first information management database of a first database management system model, wherein the first information management database includes data associated with the first plurality of computing devices,wherein the data in the first information management database is in a first data format, anda second information management database of a second database management system model, wherein the second information management database includes data associated with the second plurality of computing devices,wherein the data in the second information management database is in a second data format,wherein the first database management system model and the second database management system model are different from one another;receiving input from a user via the graphical user interface, wherein the input includes at least one selection of a content identifier from the list of content identifiers,wherein the graphical user interface provides multiple predetermined reports,wherein the predetermined reports include a top backup errors within a predetermined time period or data growth per data storage library, andwherein the graphical user interface is configured to permit the user to perform the selection without requiring the user to be able to program in a database language;determining database management system models for the heterogeneous information management system databases;querying the heterogeneous information management system databases based on the at least one selection from the list of content identifiers and based on the database management system models of the heterogeneous information management system databases;normalizing results from the query, wherein normalizing results from the query includes converting a portion of the results attributable to the first information management database in the first data format to the second data format, wherein the normalized results represent database content for heterogeneous information management system databases; anddisplaying graphical reports of the normalized results, based on the at least one selection from the list of content identifiers that was selected by the user, so that the method provides a bridge between different database types to generate and display reports containing data from both the first and second information management databases. 9. The method of claim 8 wherein the content identifiers include one or more of views, tables, and columns of the heterogeneous information management system databases. 10. The method of claim 8 wherein the graphical reports includes at least one of a data table, a bar graph, and a pie chart, wherein the database management system models include at least three of flat models, hierarchical models, network models, relational models, dimensional models, object-relational models, document models, and object models. 11. The method of claim 8, further comprising receiving a network address or network identifier from the user for at least one of the heterogeneous information management system databases, wherein determining the database management system models for the heterogeneous information management system databases includes using the network address or the network identifier to request the database management system models directly from the heterogeneous information management system databases over a network. 12. The method of claim 8, further comprising: associating a graphing function with the user interface so that the at least one selection from the list of content identifiers is associated with the graphing function, wherein displaying the graphical reports includes using the graphing function to display the at least one selection from the list of content identifiers. 13. The method of claim 8 wherein the graphical user interface includes at least one of a drop-down menu, a combo box, a list of check boxes, and a list of radio buttons to enable interaction with the graphical user interface without typing database commands. 14. The method of claim 8, further comprising: merging the normalized results from the query by entering the normalized results into an interim database associated with a report generation agent that generates the displayed reports, wherein the interim database is an in-memory database that operates in main memory of the computing device; andsorting the results with the interim database prior to displaying the graphical results. 15. At least one non-transitory tangible computer-readable medium storing instructions which, when executed by at least one data processing device, performs a method for displaying graphical reports of a status of an information management system, wherein the information management system includes a first information management subnetwork having a first plurality of computing devices and a second information management subnetwork having a second plurality of computing devices, the method comprising: populating, with a computing device, a graphical user interface object with a list of content identifiers for heterogeneous information management system databases, wherein the heterogeneous information management system databases include: a first information management database of a first database management system model, wherein the first information management database includes data associated with the first plurality of computing devices,wherein the data in the first information management database is in a first data format, anda second information management database of a second database management system model, wherein the second information management database includes data associated with the second plurality of computing devices,wherein the data in the second information management database is in a second data format,wherein the first database management system model and the second database management system model are different from one another;receiving input from a user via the graphical user interface , wherein the input includes at least one selection of a content identifier from the list of content identifiers,wherein the graphical user interface provides multiple predetermined reports,wherein the predetermined reports include a top backup errors within a predetermined time period or data growth per data storage library, andwherein the graphical user interface is configured to permit the user to perform the selection without requiring the user to be able to program in a database language;determining database management system models for the heterogeneous information management system databases;querying the heterogeneous information management system databases based on the at least one selection from the list of content identifiers and based on the database management system models of the heterogeneous information management system databases;normalizing results from the query, wherein normalizing results from the query includes converting a portion of the results attributable to the first information management database in the first data format to the second data format, wherein the normalized results represent database content for heterogeneous information management system databases; anddisplaying graphical reports of the normalized results, based on the at least one selection from the list of content identifiers that was selected by the user, so that the method provides a bridge between different database types to generate and display reports containing data from both the first and second information management databases. 16. The at least one non-transitory tangible computer-readable medium of claim 15 wherein the content identifiers include one or more of views, tables, and columns of the heterogeneous information management system databases. 17. The at least one non-transitory tangible computer-readable medium of claim 15 wherein the graphical reports includes at least one of a data table, a bar graph, and a pie chart, wherein the database management system models include at least three of flat models, hierarchical models, network models, relational models, dimensional models, object-relational models, document models, and object models. 18. The at least one non-transitory tangible computer-readable medium of claim 15, further comprising receiving a network address or network identifier from the user for at least one of the heterogeneous information management system databases, wherein determining the database management system models for the heterogeneous information management system databases includes using the network address or the network identifier to request the database management system models directly from the heterogeneous information management system databases over a network. 19. The at least one non-transitory tangible computer-readable medium of claim 15, further comprising: associating a graphing function with the user interface so that the at least one selection from the list of content identifiers is associated with the graphing function, wherein displaying the graphical reports includes using the graphing function to display the at least one selection from the list of content identifiers.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (134)
Gilbert, Matthew M.; Boom, Douglas D., Apparatus and method for dynamic resource allocation in a network environment.
Yuval Ofek ; Zoran Cakeljic ; Samuel Krikler IL; Sharon Galtzur IL; Michael Hirsch IL; Dan Arnon ; Peter Kamvysselis, Apparatus and methods for copying, backing up, and restoring data using a backup segment size larger than the storage block size.
Griffin David (Maynard MA) Campbell Jonathan (Acton MA) Reilly Michael (Sterling MA) Rosenbaum Richard (Pepperell MA), Arrangement with cooperating management server node and network service node.
Nakano Toshio (Odawara JPX) Nozawa Masafumi (Odawara JPX) Kurano Akira (Odawara JPX) Hisano Kiyoshi (Odawara JPX) Hoshino Masayuki (Odawara JPX), Backup control method and system in data processing system using identifiers for controlling block data transfer.
Kitajima Hiroyuki (Yokohama) Yamamoto Akira (Yokohama) Doi Takashi (Hadano) Nozawa Masafumi (Odawara JPX), Buffered peripheral system and method for backing up and retrieving data to and from backup memory device.
Cole Leo J. (Raleigh NC) Frantz Curtis J. (Durham NC) Lee Jeannette (Raleigh NC) Ordanic Zvonimir (Raleigh NC) Plank Larry K. (Rochester MN), Centralized management in a computer network.
Carpenter Kelly S. (Fremont CA) Dearing Gerard M. (San Jose CA) Nick Jeffrey M. (Fishkill NY) Strickland Jimmy P. (Saratoga CA) Swanson Michael D. (Poughkeepsie NY) Wilkinson Wendell W. (Hyde Park NY, Coherence controls for store-multiple shared data coordinated by cache directory entries in a shared electronic storage.
Senator Steven T. ; Fuller Billy J., Computer system method and apparatus providing for various versions of a file without requiring data copy or log operati.
Fecteau Jean G. (Toronto NY CAX) Gdaniec Joseph M. (Vestal NY) Hennessy James P. (Endicott NY) MacDonald John F. (Vestal NY) Osisek Damian L. (Vestal NY), Computer system which supports asynchronous commitment of data.
Dunphy William E. (Westminster CO) Halladay Steven M. (Louisville CO) Moy Michael E. (Lafayette CO) Munro Frederick G. (Broomfield CO), Data storage and protection system.
Yanai Moshe (Framingham MA) Vishlitzky Natan (Brookline MA) Alterescu Bruno (Newton MA) Castel Daniel (Framingham MA) Shklarsky Gadi (Brookline MA), Data storage system controlled remote data mirroring with respectively maintained data indices.
Fortier Richard W. (Acton MA) Mastors Robert M. (Ayer MA) Taylor Tracy M. (Upton MA) Wallace John J. (Franklin MA), Digital data processor with improved backup storage.
Kenley Gregory (Northboro MA) Ericson George (Schrewsbury MA) Fortier Richard (Acton MA) Holland Chuck (Northboro MA) Mastors Robert (Ayer MA) Pownell James (Natick MA) Taylor Tracy (Upton MA) Wallac, Digital data storage system with improved data migration.
Xu Yikang ; Vahalia Uresh K. ; Jiang Xiaoye ; Gupta Uday ; Tzelnic Percy, File server system using file system storage, data movers, and an exchange of meta data among data movers for file locking and direct access to shared file systems.
Lagueux, Jr., Richard A.; Stave, Joel H.; Yeaman, John B.; Stevens, Brian E.; Higgins, Robert M.; Collins, James M., Graphical user interface for configuration of a storage system.
Urevig Paul D. ; Malnati James R. ; Ethen Donald J. ; Weber Herbert L., Grouping shared resources into one or more pools and automatically re-assigning shared resources from where they are not currently needed to where they are needed.
Prahlad,Anand; Kavuri,Srinivas; Madeira,Andre Duque; Lunde,Norman R.; Bunte,Alan G.; May,Andreas; Schwartz,Jeremy, Hierarchical systems and methods for providing a unified view of storage information.
Barney Rock D. ; Schwols Keith ; Nelson Ellen M., Integration of a database into file management software for protecting, tracking and retrieving data.
Takagi Shiro,JPX, Large capacity storage apparatus having storage cells, an accessor, a cache memory and a disc update section to set a number of frequently accessed storage media.
Oshinsky, David Alan; Ignatius, Paul; Prahlad, Anand; May, Andreas, Logical view and access to data managed by a modular data and storage management system.
Ignatius, Paul; Theisen, Marjorie H.; Oshinsky, David Alan; Kavuri, Srinivas, Logical view and access to physical storage in modular data and storage management system.
Martin Charles W. (Richardson TX) Reid Fredrick S. (Plano TX) Forbus Gary L. (Dallas TX) Adams Steve M. (Plano TX) Shannon C. Patrick (Garland TX) Pirpich Eric A. (Garland TX), Mass data storage and retrieval system.
Kedem Nadav,ILX, Mass storage subsystem and backup arrangement for digital data processing system which permits information to be backed up while host computer(s) continue(s) operating in connection with information .
Long Robert M., Media element library with non-overlapping subset of media elements and non-overlapping subset of media element drives accessible to first host and unaccessible to second host.
Kullick Steven E. ; Spirakis Charles S. ; Titus Diane J., Method and apparatus for transferring archival data among an arbitrarily large number of computer devices in a networked.
Eastridge Lawrence E. (Tucson AZ) Kern Robert F. (Tucson AZ) Kern Ronald M. (Tucson AZ) Mikkelsen Claus W. (Morgan Hill CA) Ratliff James M. (Tucson AZ), Method and system for automated backup copy ordering in a time zero backup copy session.
Eastridge Lawrence E. (Tucson AZ) Kern Robert F. (Tucson AZ) Micka William F. (Tucson AZ) Mikkelsen Claus W. (Morgan Hill CA) Ratliff James M. (Tucson AZ), Method and system for automated termination and resumption in a time zero backup copy process.
Walter A. Hubis ; William G. Deitz, Method and system for controlling access share storage devices in a network environment by configuring host-to-volume mapping data structures in the controller memory for granting and denying access .
Aoyama Yuki,JPX ; Takahashi Toru,JPX ; Wakayama Satoshi,JPX, Method of and an apparatus for displaying version information and configuration information and a computer-readable recording medium on which a version and configuration information display program i.
Ahmad, Farhan; Axberg, Gary Thomas; He, Zhengwen; Li, Raymond M.; Merbach, David Lynn; Tevis, Gregory John; Yonker, William Roy, Methods and apparatus for launching device specific applications on storage area network components.
van Rietschote,Hans F.; Hobbs,Craig W.; Saptarshi,Mahesh P., Migrating virtual machines among computer systems to balance load caused by virtual machines.
Palmer,John Davis; Uttamchandani,Sandeep Madhav; Voruganti,Kaladhar, Model and system for reasoning with N-step lookahead in policy-based system management.
Crescenti,John; Kavuri,Srinivas; Oshinsky,David Alan; Prahlad,Anand, Modular backup and retrieval system used in conjunction with a storage area network.
Pisello Thomas (De Bary FL) Crossmier David (Casselberry FL) Ashton Paul (Oviedo FL), Network management system having historical virtual catalog snapshots for overview of historical changes to files distri.
Pisello Thomas (De Bary FL) Crossmier David (Casselberry FL) Ashton Paul (Oviedo FL), Network management system having virtual catalog overview of files distributively stored across network domain.
Fuhry, David Patrick; Harwood, Joseph Walter; McGee, Robert James; Schuring, Allison McDaniel, Networked computer system providing an integrated suite of web services and a geographic information system (GIS) for real property and land parcels.
Anderson, Owen Theodore; Gill, Binny Sher; Luan, Leo Shyh-Wei; Pereira, III, Manuel Vasconcellos; Riegel, Geoffrey Albert, Remote access agent for caching in a SAN file system.
Crockett Robert N. (Tucson AZ) Kern Ronald M. (Tucson AZ) Micka William F. (Tucson AZ), Software directed microcode state save for distributed storage controller.
Bowen,Jerre F.; Mathkar,Anup R.; Mathur,Rajat; Syed,Samina M. A.; Weimer,Thomas W.; Bennett,James E.; Braganza,Carl W.; Dwivedi,Tarun, System and method for an access layer application programming interface for managing heterogeneous components of a storage area network.
Lubbers,Clark; Elkington,Susan; Hess,Randy; Sicola,Stephen J.; McCarty,James; Korgaonkar,Anuja, System and method for automatic site failover in a storage area network.
DeShan,Jay Brent; Gray,Chad Ric; Felner,Jared; Giacoman,Raul; Syed,Ghousuddin; Rodiger,Anthony Joseph, System and method for monitoring delivery of digital content, including streaming media.
Mutalik Madhav ; Senie Faith M., System and method for performing file-handling operations in a digital data processing system using an operating system-independent file map.
Huai ReiJane (Old Brookville NY) Daly Robert (Ronkonkoma NY) Curti Walter (Dix Hills NY) Mohan Deepak (Huntington NY) Chueh James Kuang-Ru (Bayside NY) Louie Larry (Forest Hills NY), System and parallel streaming and data stripping to back-up a network.
Stoppani ; Jr. Peter (Woodinville WA), System for allocating storage spaces based upon required and optional service attributes having assigned piorities.
Flynn Rex A. (Belmont MA) Anick Peter G. (Marlboro MA), System for reconstructing prior versions of indexes using records indicating changes between successive versions of the.
Saether Christian D. (Seattle WA) Stoppani ; Jr. Peter (Woodinville WA), System of device independent file directories using a tag between the directories and file descriptors that migrate with.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy, Systems and methods for detecting and mitigating storage risks.
Prahlad,Anand; Kavuri,Srinivas; Madeira,Andre Duque; Lunde,Norman R.; Bunte,Alan G.; May,Andreas; Schwartz,Jeremy, Systems and methods for generating a storage-related metric.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy, Systems and methods for storage modeling and costing.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy, Systems and methods for storage modeling and costing.
Prahlad,Anand; Kavuri,Srinivas; Madeira,Andre Duque; Lunde,Norman R.; Bunte,Alan G; May,Andreas; Schwartz,Jeremy, Systems and methods for storage modeling and costing.
Ulrich, Thomas R.; Schweitzer, James R.; Bolstad, Gregory D.; Randall, Jay G.; Staub, John R.; Priester, Wilbur George, Systems and methods for storing parity groups.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.