Predicting scale of data migration between production and archive storage systems, such as for enterprise customers having large and/or numerous files
원문보기
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06F-017/00
G06F-017/30
G06F-003/0482
출원번호
US-0810546
(2015-07-28)
등록번호
US-10089337
(2018-10-02)
발명자
/ 주소
Senthilnathan, Muthusamy
Thati, Ravi
Kumarasamy, Paramasivam
Mishra, Hemant
출원인 / 주소
Commvault Systems, Inc.
대리인 / 주소
Perkins Coie LLP
인용정보
피인용 횟수 :
0인용 특허 :
268
초록▼
This application discloses a system for presenting data to a user based on requests to move data from primary storage to secondary storage. The system receives a request to move data that satisfies at least one criterion, from primary to secondary data storage. The system then identifies an initial
This application discloses a system for presenting data to a user based on requests to move data from primary storage to secondary storage. The system receives a request to move data that satisfies at least one criterion, from primary to secondary data storage. The system then identifies an initial database query from the request, and further builds a nested database query from the initial database query according to a database schema. Next, the system estimates a size of a result of executing the nested database query. Finally, the system provides for display to the user the estimated size.
대표청구항▼
1. A computer-implemented method of predicting an amount of data storage needed when moving data from primary data storage to secondary or archive data storage, the method comprising: receiving, at a client computing device, a request to move data that satisfies at least one criterion, wherein the m
1. A computer-implemented method of predicting an amount of data storage needed when moving data from primary data storage to secondary or archive data storage, the method comprising: receiving, at a client computing device, a request to move data that satisfies at least one criterion, wherein the moving of data is from a primary data storage system to a secondary data storage system, andwherein the at least one criterion is related to age or size of data;providing an initial database query based on the request, wherein the initial database query is related to an initial table in an initial database;building a nested database query from the initial database query according to a database schema, wherein building the nested database query includes determining additional tables linked to the initial table;predicting a size of data that will be returned as a result of executing the nested database query; andproviding the predicted size before moving the data from the primary data storage system to the secondary data storage system. 2. The computer-implemented method of claim 1, further comprising presenting a user interface to a user showing a list of predetermined requests,wherein the request received is from the user and is chosen from the list of predetermined requests. 3. The computer-implemented method of claim 1, wherein the building includes traversing the database schemas according to foreign keys, and further comprising determining whether the secondary storage system has sufficient data storage space based on the predicted size. 4. The computer-implemented method of claim 1, wherein the budding includes computing a count of a number of records that match the nested database query, and wherein the budding includes computing an aggregate size from sizes of the records that match the nested database query. 5. The computer-implemented method of claim 1, wherein the building includes computing a count of records in a database table referenced in the nested database query and a size of a record in the database table. 6. The computer-implemented method of claim 1, further comprising determining whether to satisfy the request based on the predicted size, and wherein the determining is based on a computing bad of the primary data storage system, a computing bad of the secondary data storage system, an amount of free space on the primary data storage system, an amount of free space on the secondary data storage system, or a user need of data affected by the request. 7. The computer-implemented method of claim 1, further comprising: storing, by a database gate component, a mapping of data to a plurality of different data storage locations, including the primary data storage system storing at least one production database and the secondary data storage system storing at least one archive database;receiving a data request from an application logic component, wherein the application logic component manages or receives data from a user interface;at a database gate component, translating the data request to one or more database queries based on a mapping of data between production and archive databases associated with the primary and secondary data storage systems;causing to execute at least two database queries against data in the primary and secondary data storage systems;returning to the application logic component a combined result of executing the database queries;receiving at a reporting server a copy of metadata from the primary data storage system;receiving, at the reporting server, a request for a report of data on the primary data storage system; andproducing a data report at the reporting server in response to the request, wherein the reporting server generates the data report using the copy of metadata received from the primary data storage system. 8. At least one non-transitory, computer-readable medium carrying, instructions, which when executed by at least one data processor, performs a method of presenting data to a user based on requests to move data from primary storage to secondary storage, comprising: receiving, from a client computing device, a request from a user to move data that satisfies a criterion, from a primary storage system to a secondary storage system;identifying an initial database query from the request, wherein the initial database query is related to an initial table in the initial database;building a nested database query from the initial database query according to a database schema; wherein building the nested database query includes determining additional tables linked to the initial table;estimating a size of a result of executing the nested database query; andproviding the estimated size to be displayed to the user. 9. The computer-readable medium of claim 8, wherein the criterion is related to an age or size of the data. 10. The computer-readable medium of claim 8, further comprising providing data for a user interface to show to a user a list of predetermined requests, wherein the request received from the user is chosen from the list of predetermined requests. 11. The computer-readable medium of claim 8, wherein the building includes traversing the database schemas according to foreign keys. 12. The computer-readable medium of claim 8, wherein the building includes computing a count of a number of records that match the nested database query, and wherein the building includes computing an aggregate of sizes of the records that match the nested database query. 13. The computer-readable medium of claim 8, wherein the building includes computing a count of records in a database table referenced in the nested database query and a size of a record in the database table. 14. The computer-readable medium of claim 8, wherein the method further comprises determining whether to satisfy the request based on the estimated size, and wherein the determining is based on a computing bad of the primary storage system, a computing bad of the secondary storage system, an amount of free space on the primary storage system, an amount of free space on the secondary storage system, or a user need of data affected by the request. 15. The computer-readable medium of claim 8, further comprising: storing, by a database gate component, a mapping of data in production and archive databases respectively on the primary and secondary storage systems;receiving a data request from an application logic component, wherein the application logic component receives data from a user interface;at a database gate component, translating the data request to one or more database queries based on a mapping of data between production and archive databases;causing to execute at least two database queries against data in the primary and secondary storage systems;returning to the application logic component a combined result of executing the database queries;receiving at a reporting server a copy of metadata from the primary storage system;receiving, at the reporting server, a request for a report of data on the primary storage system; andproducing a data report at the reporting server in response to the request, wherein the reporting server generates the data report using the copy of metadata received from the primary storage system. 16. A system configured to present data to a user related to requests to move data from primary storage to secondary storage, the system comprising: at least one processor;at least one memory coupled to the processor and storing instructions for execution by the processor, wherein the instructions encode a method comprising: receiving a request from a user to move data that satisfies a criterion from a primary storage system to a secondary storage system;providing the request to a remote computing device to provide an estimated size of data to be moved, wherein the remote computing device identifies an initial database query from the request, wherein the initial database query is related to an initial table in an initial database;builds a database query from the initial database query according to a database schema, wherein building the database query includes determining additional tables linked to the initial table, andestimates a size of a result of executing the database query;receiving from the remote computing device, the estimated size; andproviding for display to the user the estimated size. 17. The system of claim 16, the method further comprising presenting a user interface to the user showing a list of predetermined requests,wherein the request received is chosen from the list of predetermined requests. 18. The system of claim 16, wherein the estimated size is based on a count of a number of records that match the database query and an aggregate size from sizes of the records that match the database query. 19. The system of claim 16, wherein the estimated size is based on a count of records in each database table referenced in the database query and a size of a record in each database table. 20. The system of claim 16, the method further comprising determining whether to satisfy the request based on the predicted size, and wherein the determining is based on a computing load of the primary storage system, a computing load of the secondary storage system, an amount of free space on the primary storage system, an amount of free space on the secondary storage system, or a user need of data affected by the request.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (268)
Tarui Toshiaki (Kokubunji JPX) Sukegawa Naonobu (Kokubunji JPX) Fujii Hiroaki (Hadano JPX) Kitai Katsuyoshi (Kokubunji JPX), Access control method for a shared main memory in a multiprocessor based upon a directory held at a storage location of.
Bates, Allen Keith; Haustein, Nils; Klein, Craig Anthony; Troppens, Ulf; Winarski, Daniel James, Apparatus and method to select a deduplication protocol for a data storage library.
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.
Dile, James Michael; Nguyen, Joanne T.; Piletski, Vadzim Ivanovich; Smith, James Patrick, Backing-up and restoring files including files referenced with multiple file names.
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.
Worley ; Jr. William S. (Saratoga CA) Bryg William R. (Saratoga CA) Baum Allen (Palo Alto CA), Cache memory consistency control with explicit software instructions.
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.
Chung, Keicy, Computer storage device having separate read-only space and read-write space, removable media component, system management interface, and network interface.
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.
Reed Drummond Shattuck ; Heymann Peter Earnshaw ; Mushero Steven Mark ; Jones Kevin Benard ; Oberlander Jeffrey Todd ; Banay Dan, Computer-based communication system and method using metadata defining a control structure.
Burchard, Artur; Van Gassel, Jozef Pieter; Yermalayeu, Siarhei; Van den Brink, Henrikus Bernardus; Mesut, Ozcan; Luitjens, Steven Broeils, Content status provision related to volatile memories.
Prahlad, Anand; Agrawal, Vijay H., Continuous data protection over intermittent connections, such as continuous data backup for laptops or wireless devices.
Prahlad, Anand; Agrawal, Vijay H., Continuous data protection over intermittent connections, such as continuous data backup for laptops or wireless devices.
Midgely Christopher W. (Framingham MA) Holland Charles J. (Northboro MA) Webb John W. (Sutton MA) Gonsalves Manuel (Brookline MA), Continuously-snapshotted protection of computer files.
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.
Hagerstrom, Carl F.; Hutchinson, Thomas Dixon; Bharthulwar, Shridhar; Tinius, Paul E., Detecting and managing orphan files between primary and secondary data stores.
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.
Christenson,Nikolai Paul; Fritchie,Scott Ernest Lystig; Larson,James Stephen, Electronic mail system with methodology providing distributed message store.
Alam Salim ; Bhalerao Vinayak A. ; Wu Charles ; Hu George ; Ferrell John I., File object synchronization between a desktop computer and a mobile device.
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.
Bates, Allen K.; Haustein, Nils; Klein, Craig A.; Krick, Frank; Troppens, Ulf; Winarski, Daniel, File system with internal deduplication and management of data blocks.
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.
Barney Rock D. ; Schwols Keith ; Nelson Ellen M., Integration of a database into file management software for protecting, tracking and retrieving data.
Douceur,John R.; Theimer,Marvin M.; Adya,Atul; Bolosky,William J., Locating potentially identical objects across multiple computers based on stochastic partitioning of workload.
Douceur,John R.; Theimer,Marvin M.; Adya,Atul; Bolosky,William J., Locating potentially identical objects across multiple computers based on stochastic partitioning of workload.
Cash, Charles D.; Jarecki, Stanislaw; Jutla, Charanjit S.; Krawczyk, Hugo M.; Rosu, Marcel C.; Steiner, Michael, Masking query data access pattern in encrypted data.
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.
Archibald, Jr., John Edward; McKean, Brian Dennis, Method and apparatus for using extended disk sector formatting to assist in backup and hierarchical storage management.
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 .
Chefalas, Thomas E.; Mastrianni, Steven J., Method and system for processing backup data associated with application, querying metadata files describing files accessed by the application.
Chron, Edward Gustav; Menon, Jaishankar Moothedath, Method and system for providing consistent data modification information to clients in a storage system.
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.
Wahlert, Brian M; Berkowitz, Brian T; van Ingen, Catharine; Rangegowda, Dharshan; Jazayeri, Mike, Method, system, and apparatus for creating saved searches and auto discovery groups for a data protection system.
Wolfgang, John Jay; Boyd, Kenneth Wayne; Day, III, Kenneth Fairclough; Doatmas, Philip Matthew; Dahman, Kirby Grant, Method, system, and program for data synchronization between a primary storage device and a secondary storage device by determining whether a first identifier and a second identifier match, where a unique identifier is associated with each portion of data.
Palliyil, Sudarshan; Venkateshamurthy, Shivakumara; Vijayaraghavan, Srinivas Belur; Aswathanarayana, Tejasvi, Methods, apparatus and computer programs for enhanced access to resources within a network.
MacHardy, Earle; Harvey, David; Duprey, Dennis, Methods, systems, and computer program products for mapped logical unit (MLU) replications, storage, and retrieval in a redundant array of inexpensive disks (RAID) environment.
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 virtual catalog overview of files distributively stored across network domain.
Faibish, Sorin; Whitney, William; Brashers, Per; Cotter, Gerald E., Object classification and indexing of very large name spaces using grid technology.
Sawdon, Wayne A.; Haskin, Roger L.; Schmuck, Frank B.; Wyllie, James C., Plurality of file systems using weighted allocation to allocate space on one or more storage devices.
Bruce, Buford L.; Kim, Peter C.; Levi, Michael; Silliman, Albert; Wissmann, Joseph T.; Zaremba, Christopher, Providing archiving of individual mail content while maintaining a single copy mail store.
William J. Bolosky ; John R. Douceur ; Scott M. Cutshall ; Richard F. Rashid ; Nathan P. Myhrvold ; David A. Goebel, Single instance store for file systems.
Prahlad, Anand; May, Andreas; Lunde, Norman R.; Zhou, Lixin; Kumar, Avinash; Ngo, David, Snapshot storage and management system with indexing and user interface.
Prahlad, Anand; May, Andreas; Lunde, Norman R.; Zhou, Lixin; Kumar, Avinash; Ngo, David, Snapshot storage and management system with indexing and user interface.
Crockett Robert N. (Tucson AZ) Kern Ronald M. (Tucson AZ) Micka William F. (Tucson AZ), Software directed microcode state save for distributed storage controller.
Ting, Daniel; Zheng, Ling; Manley, Stephen L.; DeStefano, John Frederick, System and method for managing data deduplication of storage systems utilizing persistent consistency point images.
Ting, Daniel; Zheng, Ling; Manley, Stephen L.; DeStefano, John Frederick, System and method for managing data deduplication of storage systems utilizing persistent consistency point images.
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.
Huang,Jau Hsiung; Tseng,Wei Hsin; Chou,Hung Te; Weng,Yung Chiuan, System and method for providing access to computer files across computer operating systems.
Prahlad, Anand; Gokhale, Parag; Kottomtharayil, Rajiv; Retnamma, Manoj K. Vijayan; Attarde, Deepak R., System and method for storing redundant information.
Prahlad, Anand; Gokhale, Parag; Kottomtharayil, Rajiv; Vijayan Retnamma, Manoj K.; Attarde, Deepak R., System and method for storing redundant information.
Moulton, Gregory Hagan, System and method for unorchestrated determination of data sequences using sticky byte factoring to determine breakpoints in digital sequences.
Patel, Sujal M.; Mikesell, Paul A., System and methods for providing a distributed file system utilizing metadata to track information about data stored throughout the system.
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.
Frasier, Lawrence Martin; Resino, Robert George, System for adjusting resource allocation to a logical partition based on rate of page swaps and utilization by changing a boot configuration file.
Stoppani ; Jr. Peter (Woodinville WA), System for allocating storage spaces based upon required and optional service attributes having assigned piorities.
Sim-Tang, Siew Yong; Fraisl, Daniel J., System for moving real-time data events across a plurality of devices in a network for simultaneous data protection, replication, and access services.
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.
Morris Robert J. T. (Los Gatos CA), System for reducing storage requirements and transmission loads in a backup subsystem in client-server environment by tr.
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; Schwartz, Jeremy A.; Ngo, David; Brockway, Brian; Muller, Marcus S., Systems and methods for classifying and transferring information in a storage network.
Prahlad, Anand; Schwartz, Jeremy A.; Ngo, David; Brockway, Brian; Muller, Marcus S., Systems and methods for classifying and transferring information in a storage network.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.