公开(公告)号：US20190266139A1

公开(公告)日：2019-08-29

申请号：US16408305

申请日：2019-05-09

Applicant: Commvault Systems, Inc.

Inventor： Paramasivam Kumarasamy ,  Muthusamy Senthilnathan ,  Ravi Thati ,  Hemant Mishra

IPC: G06F16/22 ,  G06F16/2457 ,  G06F16/2455 ,  G06F16/2452 ,  G06F16/242 ,  G06F16/28 ,  G06F3/0482 ,  G06F16/248 ,  G06F16/21 ,  G06F16/182 ,  G06F16/13 ,  G06F16/25

Abstract: This application discloses a system for processing requests for data in production and archive/backup databases. The system stores a mapping of data in production and archive databases to multiple different data storage locations, including a production system storing at least one production database and an archive system storing at least one archive database. The system receives a data request from an application component, which manages or receives data from a user interface and has received the data request directly from the user interface. The system translates the data request to one or more database queries based on the mapping. The system causes to execute the database queries against data on the production or archive system. The system returns a result of executing the one or more database queries to the application component, where the application component returns the result to the user via the user interface.

公开(公告)号：US20190042609A1

公开(公告)日：2019-02-07

申请号：US16057763

申请日：2018-08-07

Applicant: Commvault Systems, Inc.

Inventor： Muthusamy Senthilnathan ,  Ravi Thati ,  Paramasivam Kumarasamy ,  Hemant Mishra

IPC: G06F17/30 ,  G06F3/0482

Abstract: 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.

公开(公告)号：US11755424B2

公开(公告)日：2023-09-12

申请号：US17239406

申请日：2021-04-23

Applicant: Commvault Systems, Inc.

Inventor： Paramasivam Kumarasamy ,  Brahmaiah Vallabhaneni ,  Rahul S. Pawar ,  Henry Wallace Dornemann ,  Jun H. Ahn ,  Amey Vijaykumar Karandikar ,  Amit Mitkar ,  Muthusamy Senthilnathan ,  Satish Chandra Kilaru

IPC: G06F16/00 ,  G06F11/14 ,  G06F16/27 ,  G06F16/11 ,  G06F16/182 ,  G06F16/21 ,  G06F16/17 ,  G06F16/22 ,  G06F16/23 ,  G06F3/06 ,  G06F11/30 ,  G06F11/34

CPC classification number: G06F11/1464 ,  G06F3/061 ,  G06F3/064 ,  G06F3/065 ,  G06F3/067 ,  G06F3/0619 ,  G06F3/0643 ,  G06F11/14 ,  G06F11/1448 ,  G06F11/1451 ,  G06F11/1458 ,  G06F11/1469 ,  G06F11/3034 ,  G06F11/3476 ,  G06F16/113 ,  G06F16/1727 ,  G06F16/184 ,  G06F16/1827 ,  G06F16/214 ,  G06F16/2282 ,  G06F16/2358 ,  G06F16/27 ,  G06F16/275 ,  G06F2201/80 ,  G06F2201/84

Abstract: According to certain aspects, a system may include a data agent configured to: process a database file residing on a primary storage device(s) to identify a subset of data in the database file for archiving, the database file generated by a database application; and extract the subset of the data from the database file and store the subset of the data in an archive file on the primary storage device(s) as a plurality of blocks having a common size; and at least one secondary storage controller computer configured to, as part of a secondary copy operation in which the archive file is copied to a secondary storage device(s): copy the plurality of blocks to the secondary storage devices to create a secondary copy of the archive file; and create a table that provides a mapping between the copied plurality of blocks and corresponding locations in the secondary storage device(s).

公开(公告)号：US10977231B2

公开(公告)日：2021-04-13

申请号：US16057763

申请日：2018-08-07

Applicant: Commvault Systems, Inc.

Inventor： Muthusamy Senthilnathan ,  Ravi Thati ,  Paramasivam Kumarasamy ,  Hemant Mishra

IPC: G06F17/00 ,  G06F16/22 ,  G06F16/13 ,  G06F16/182 ,  G06F16/21 ,  G06F16/248 ,  G06F16/25 ,  G06F16/28 ,  G06F16/242 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/2457 ,  G06F3/0482

Abstract: 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.

公开(公告)号：US20200320050A1

公开(公告)日：2020-10-08

申请号：US16857020

申请日：2020-04-23

Applicant: Commvault Systems, Inc.

Inventor： Hemant Mishra ,  Muthusamy Senthilnathan ,  Ravi Thati ,  Paramasivam Kumarasamy

IPC: G06F16/22 ,  G06F16/13 ,  G06F16/182 ,  G06F16/21 ,  G06F16/248 ,  G06F16/25 ,  G06F16/28 ,  G06F16/242 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/2457 ,  G06F3/0482

Abstract: This application discloses a server for handling data reporting requests in a system that also comprises storage managers, primary storage devices, and secondary storage devices connected over one or more networks. The server receives, from each storage manager, a copy of data associated with the storage manager, and stores the received copies in one or more local databases. The server builds offline one or more indices for part or all of the received copies to improve query processing against the one or more local databases. Next, the server receives a request over a network from one of the storage managers or a standalone console, which received the request from a user for a report of data associated with the storage managers. The server produces a data report in response to the request, using the one or more indices and without impacting performance of the storage managers.

公开(公告)号：US10324914B2

公开(公告)日：2019-06-18

申请号：US14755561

申请日：2015-06-30

Applicant: Commvault Systems, Inc.

Inventor： Paramasivam Kumarasamy ,  Muthusamy Senthilnathan ,  Ravi Thati ,  Hemant Mishra

IPC: G06F17/30 ,  G06F16/22 ,  G06F16/13 ,  G06F16/182 ,  G06F16/21 ,  G06F16/248 ,  G06F16/25 ,  G06F16/28 ,  G06F16/242 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/2457 ,  G06F3/0482

Abstract: This application discloses a system for processing requests for data in production and archive/backup databases. The system stores a mapping of data in production and archive databases to multiple different data storage locations, including a production system storing at least one production database and an archive system storing at least one archive database. The system receives a data request from an application component, which manages or receives data from a user interface and has received the data request directly from the user interface. The system translates the data request to one or more database queries based on the mapping. The system causes to execute the database queries against data on the production or archive system. The system returns a result of executing the one or more database queries to the application component, where the application component returns the result to the user via the user interface.

公开(公告)号：US10210051B2

公开(公告)日：2019-02-19

申请号：US14717930

申请日：2015-05-20

Applicant: Commvault Systems, Inc.

Inventor： Brahmaiah Vallabhaneni ,  Paramasivam Kumarasamy ,  Rahul S. Pawar ,  Henry Wallace Dornemann ,  Jun H. Ahn ,  Muthusamy Senthilnathan

IPC: G06F17/30 ,  G06F11/14 ,  G06F3/06

Abstract: According to certain aspects, a system may include a first computing device configured to: in response to a request to access at least one first database object of a plurality of database objects represented by a database file generated by a first database application, the database file including a plurality of data blocks, identify a subset of the plurality of data blocks corresponding to the first database object; a secondary storage controller computer(s) configured to: access a stored table providing a mapping between the secondary copies of the plurality of data blocks and corresponding locations of the secondary copies in a secondary storage device(s); retrieve and forward the subset of data blocks from the secondary storage device(s); and a second computing device configured to: receive the requested data blocks retrieved from the secondary storage device(s); and convert the received data blocks to a format usable by a second database application.

公开(公告)号：US10089337B2

公开(公告)日：2018-10-02

申请号：US14810546

申请日：2015-07-28

Applicant: Commvault Systems, Inc.

Inventor： Muthusamy Senthilnathan ,  Ravi Thati ,  Paramasivam Kumarasamy ,  Hemant Mishra

IPC: G06F17/00 ,  G06F17/30 ,  G06F3/0482

Abstract: 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.

公开(公告)号：US20160342661A1

公开(公告)日：2016-11-24

申请号：US14755561

申请日：2015-06-30

Applicant: Commvault Systems, Inc.

Inventor： Paramasivam Kumarasamy ,  Muthusamy Senthilnathan ,  Ravi Thati ,  Hemant Mishra

IPC: G06F17/30

CPC classification number: G06F17/30312 ,  G06F3/0482 ,  G06F17/30094 ,  G06F17/30194 ,  G06F17/303 ,  G06F17/30309 ,  G06F17/30333 ,  G06F17/30392 ,  G06F17/30427 ,  G06F17/30477 ,  G06F17/30528 ,  G06F17/30554 ,  G06F17/3056 ,  G06F17/30592

Abstract: This application discloses a system for processing requests for data in production and archive/backup databases. The system stores a mapping of data in production and archive databases to multiple different data storage locations, including a production system storing at least one production database and an archive system storing at least one archive database. The system receives a data request from an application component, which manages or receives data from a user interface and has received the data request directly from the user interface. The system translates the data request to one or more database queries based on the mapping. The system causes to execute the database queries against data on the production or archive system. The system returns a result of executing the one or more database queries to the application component, where the application component returns the result to the user via the user interface.

Abstract translation: 该应用公开了一种用于处理生产和归档/备份数据库中的数据请求的系统。 系统将生产和归档数据库中的数据映射存储到多个不同的数据存储位置，包括存储至少一个生产数据库的生产系统和存储至少一个归档数据库的存档系统。 系统从应用组件接收数据请求，应用组件管理或接收来自用户界面的数据，并直接从用户界面接收到数据请求。 系统会根据映射将数据请求转换为一个或多个数据库查询。 系统导致对生产或存档系统上的数据执行数据库查询。 系统将执行一个或多个数据库查询的结果返回给应用程序组件，应用程序组件通过用户界面将结果返回给用户。