-
公开(公告)号:US20230334039A1
公开(公告)日:2023-10-19
申请号:US18339937
申请日:2023-06-22
发明人: Shubham Arora , Balaji Balaraman , Sandeep Bose , Arindam Chatterjee , Sastry Durvasula , Manoj Kumar Rana , Nitish Sharma
IPC分类号: G06F16/23 , G06F16/248 , G06F21/62 , G06F16/176 , G06F16/435 , G06F16/17 , G06F16/2457 , G06F16/2452 , G06F16/182 , G06F16/215 , G06F16/22
CPC分类号: G06F16/2365 , G06F16/248 , G06F21/6227 , G06F16/176 , G06F16/435 , G06F16/173 , G06F16/2457 , G06F16/24524 , G06F16/183 , G06F16/215 , G06F16/22
摘要: The present disclosure involves detecting a first language type of a query configured to access a column in a data table, wherein the query is requested by a user; converting, by the computing device, the query from the first language type to a second language type that conforms with the data storage format of the data table; after converting the query to the second language type, generating, by the computing device, a temporary table including the column and enforcing an access permission by formatting the temporary table to support the second language type and excluding a row from the temporary table for which the user does not have access rights; and executing, by the computing device, the query against the temporary table to generate a query result.
-
公开(公告)号:US20230273898A1
公开(公告)日:2023-08-31
申请号:US18313142
申请日:2023-05-05
发明人: Ambika Aggarwal , Ravi Arasan , Sandeep Bose , Debasish Das , Ravi K. Kaushik , Matthew Kent Meyer , Gurusamy Ramasamy , Jeremy D. Seideman
IPC分类号: G06F16/11 , G06F16/2458
CPC分类号: G06F16/116 , G06F16/2471
摘要: Systems and methods of the present disclosure may read source data corresponding to a source variable and apply a transformation to the source variable to generate an output variable. Accordingly, one such method comprises receiving a request to access an output variable by applying one or more data transformations to input data; before applying an actual data transformation to the input data, identifying that a match exists with a database of prior data transformations that have been applied to source variables to generate derived variables; identifying that a source variable in the matching one or more data transformations is flagged as sensitive data; and processing the request to access the output variable subject to an access restriction in response to the identification of the source variable that is flagged as sensitive data.
-
公开(公告)号:US10943024B2
公开(公告)日:2021-03-09
申请号:US16185706
申请日:2018-11-09
发明人: Ravi Arasan , Carmen Patricia Argüello , Sandeep Bose , Matthew Kent Meyer , Marimuthu Ponnambalam , Gurusamy Ramasamy , Jeremy D. Seideman , Mohammad Torkzahrani , Roopesh R. Varier
IPC分类号: G06F16/00 , G06F21/62 , G06F16/2453 , G06F16/25
摘要: A system may receive a request for access to a first variable. The request may include a requested action and a variable identifier for the first variable. The request may also have a syntax that is incompatible with first data storage format. The system may parse the request to capture the variable identifier from the request. The system may also look up a location of the first variable in a catalog using the variable identifier. The location of the first variable may include the first data storage format. The system may generate a query to access the first variable. The syntax of the query may be compatible with the first data storage format. The system may then submit the query to access the first data storage format. The query may be configured to complete the requested action.
-
公开(公告)号:US20210064637A1
公开(公告)日:2021-03-04
申请号:US16560124
申请日:2019-09-04
发明人: Karina Alvarez , Sachin Arya , Sandeep Bose , Subhash Godara , Anmol Handa , Ajay Paul Singh Manesh , Purvi Shah , Bhupesh Sharma
摘要: A system for data comparison is disclosed. The system may receive a source configuration metadata. The system may configure a data extraction module to extract data from a data set in response to the source configuration metadata. The system may generate a pre-work data from the data set. The system may compare the pre-work data to generate a post-process data set. The system may generate a report corresponding to the post-process data set.
-
公开(公告)号:US20190095638A1
公开(公告)日:2019-03-28
申请号:US16185706
申请日:2018-11-09
发明人: Ravi Arasan , Carmen Patricia Argüello , Sandeep Bose , Matthew Kent Meyer , Marimuthu Ponnambalam , Gurusamy Ramasamy , Jeremy D. Seideman , Mohammad Torkzahrani , Roopesh R. Varier
IPC分类号: G06F21/62
摘要: A system may receive a request for access to a first variable. The request may include a requested action and a variable identifier for the first variable. The request may also have a syntax that is incompatible with first data storage format. The system may parse the request to capture the variable identifier from the request. The system may also look up a location of the first variable in a catalog using the variable identifier. The location of the first variable may include the first data storage format. The system may generate a query to access the first variable. The syntax of the query may be compatible with the first data storage format. The system may then submit the query to access the first data storage format. The query may be configured to complete the requested action.
-
公开(公告)号:US20170139976A1
公开(公告)日:2017-05-18
申请号:US14944902
申请日:2015-11-18
发明人: Ambika Aggarwal , Ravi Arasan , Sandeep Bose , Debasish Das , Ravi K. Kaushik , Matthew Kent Meyer , Marimuthu Ponnambalam , Gurusamy Ramasamy , Jeremy D. Seideman
IPC分类号: G06F17/30
CPC分类号: G06F17/30566
摘要: A system may store a plurality of first records comprising a first variable in a first data storage format. The system may also store a plurality of second records comprising a second variable in a second data storage format. The first data storage format may have a different data structure than the second data storage format. The system may then generate a catalog including a first location of the first variable and a second location of the second variable. The first location identifies the first data storage format, which is where the first variable is stored. The second location identifies the second data storage format, which is where the second variable is stored. The system may then receive a request to access at least one of the first variable or the second variable and access the first variable and/or the second variable in response to the request.
-
公开(公告)号:US12061571B2
公开(公告)日:2024-08-13
申请号:US18313142
申请日:2023-05-05
发明人: Ambika Aggarwal , Ravi Arasan , Sandeep Bose , Debasish Das , Ravi K. Kaushik , Matthew Kent Meyer , Gurusamy Ramasamy , Jeremy D. Seideman
IPC分类号: G06F16/11 , G06F16/2458
CPC分类号: G06F16/116 , G06F16/2471
摘要: Systems and methods of the present disclosure may read source data corresponding to a source variable and apply a transformation to the source variable to generate an output variable. Accordingly, one such method comprises receiving a request to access an output variable by applying one or more data transformations to input data; before applying an actual data transformation to the input data, identifying that a match exists with a database of prior data transformations that have been applied to source variables to generate derived variables; identifying that a source variable in the matching one or more data transformations is flagged as sensitive data; and processing the request to access the output variable subject to an access restriction in response to the identification of the source variable that is flagged as sensitive data.
-
公开(公告)号:US11169959B2
公开(公告)日:2021-11-09
申请号:US16036326
申请日:2018-07-16
发明人: Ambika Aggarwal , Ravi Arasan , Sandeep Bose , Debasish Das , Ravi K. Kaushik , Matthew Kent Meyer , Gurusamy Ramasamy , Jeremy D. Seideman
IPC分类号: G06F16/2458 , G06F16/11
摘要: A system may read source data corresponding to a source variable and apply a transformation to the source variable to generate an output variable. The transformation may include logic, and the output variable may be configured for ingestion into a big data storage format. The system may record lineage data of the output variable that comprises the transformation and/or the source variable. The system may also receive a request to generate a requested output variable. The requested output variable may be generated from a second transformation that is the same as the first transformation. The system may thus match the first transformation to the second transformation using the lineage data. In response to matching the first transformation to the second transformation, the system may deny the request. The original output variable may be returned in response to the matching the first transformation to the second transformation.
-
公开(公告)号:US10445324B2
公开(公告)日:2019-10-15
申请号:US14944898
申请日:2015-11-18
发明人: Ravi Arasan , Sandeep Bose , Xiaoyang Chen , Debasish Das , Matthew Kent Meyer , Gurusamy Ramasamy , Jeremy D. Seideman
IPC分类号: G06F16/2457
摘要: A system may retrieve a pattern from a pattern database with the pattern identifying a type of sensitive data. The system may also retrieve data identified by a variable from a big data management system. The system may then match the data to the pattern to detect the type of sensitive data in the data. An output may be generated in response to the data matching the pattern. A variable access permission may be retrieved for the variable from a permissions repository, a sensitive data permission may be retrieved for the type of sensitive data from the permissions repository, and the variable access permission may be compared to the sensitive data permission to detect a discrepancy.
-
公开(公告)号:US20190034476A1
公开(公告)日:2019-01-31
申请号:US16105308
申请日:2018-08-20
发明人: Shubham Arora , Balaji Balaraman , Sandeep Bose , Arindam Chatterjee , Sastry Durvasula , Manoj Kumar Rana , Nitish Sharma
摘要: A system may receive a query configured to access a column in a data table. The data table may be in a flat file in a big data storage format. The system may detect the language type of the query and validate the query against the syntax of the language type. The system may also validate an access permission for data in the data table. The access permission may be stored in a permissions database. The system may generate a temporary table including the column with the temporary table configured to support the language type. The system may execute the query against the temporary table to generate a query result based on the temporary table as though it were the underlying data table. The system may enforce column-level or row-level access permissions by excluding columns or rows from the temporary table.
-
-
-
-
-
-
-
-
-