公开(公告)号：US20160085982A1

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

申请号：US14925870

申请日：2015-10-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Shenoda Guirguis ,  Alok Pareek ,  Stephen Wilkes

IPC: G06F21/62 ,  G06F9/46 ,  G06F17/30

CPC classification number: G06F21/6209 ,  G06F9/466 ,  G06F17/30377 ,  G06F17/30592 ,  G06F17/30616 ,  G06F19/322 ,  G06F21/6254 ,  G16H10/60

Abstract: A system and method for providing transactional data privacy while maintaining data usability, including the use of different obfuscation functions for different data types to securely obfuscate the data, in real-time, while maintaining its statistical characteristics. In accordance with an embodiment, the system comprises an obfuscation process that captures data while it is being received in the form of data changes at a first or source system, selects one or more obfuscation techniques to be used with the data according to the type of data captured, and obfuscates the data, using the selected one or more obfuscation techniques, to create an obfuscated data, for use in generating a trail file containing the obfuscated data, or applying the data changes to a target or second system.

Abstract translation: 一种用于在保持数据可用性的同时提供事务数据隐私的系统和方法，包括为不同的数据类型使用不同的模糊处理功能，以便在保持其统计特性的同时实时地安全地模糊数据。 根据实施例，该系统包括在第一或源系统以数据变化的形式接收数据时捕获数据的模糊处理，根据数据类型选择一种或多种与数据一起使用的混淆技术 使用所选择的一个或多个模糊技术对数据进行捕获和模糊处理，以创建混淆数据，以用于生成包含混淆数据的跟踪文件，或将数据改变应用于目标或第二系统。

公开(公告)号：US11475006B2

公开(公告)日：2022-10-18

申请号：US15368345

申请日：2016-12-02

Applicant: Oracle International Corporation

Inventor： Shenoda Guirguis ,  Sabina Petride

IPC: G06F16/2453 ,  G06F16/27

Abstract: Techniques are presented herein for efficient query processing and data change propagation at a secondary database system. The techniques involve determining execution costs for executing a query at a primary DBMS and for executing the query at an offload DBMS. The cost for executing the query at the offload DBMS includes the cost of propagating changes to database objects required by the query to the offload DBMS. Based on the execution cost, the query is sent to either the primary DBMS or the offload DBMS.

公开(公告)号：US20180349458A1

公开(公告)日：2018-12-06

申请号：US15610171

申请日：2017-05-31

Applicant: Oracle International Corporation

Inventor： Shenoda Guirguis ,  Kantikiran Pasupuleti ,  Sabina Petride ,  Sam Idicula

IPC: G06F17/30

CPC classification number: G06F16/273 ,  G06F16/2365 ,  G06F16/2379 ,  G06F16/2455

Abstract: Techniques are described for efficient query processing and data change propagation to a secondary database system. The secondary database system may execute queries received at a primary database system. Database changes made at the primary system are copied to the secondary system. The primary system receives a query to be executed on either the primary system or the secondary system. The primary system determines whether to send the query to the secondary system based upon whether data objects stored within the secondary system have pending changes that need to be applied to the data objects. The pending changes are stored within in-memory journals within the primary system. The primary system scans for the pending changes to the data objects and sends the pending changes to the secondary system. The secondary system then receives and applies the pending changes to the data objects within the secondary system. Upon applying the pending changes, the secondary system executes the query.

公开(公告)号：US11544395B2

公开(公告)日：2023-01-03

申请号：US17109807

申请日：2020-12-02

Applicant: Oracle International Corporation

Inventor： Shenoda Guirguis ,  Alok Pareek ,  Stephen Wilkes

IPC: G06F16/28 ,  G06F21/62 ,  G06F16/23 ,  G16H10/60 ,  G06F9/46 ,  G06F16/31 ,  G06F16/29

Abstract: A system and method for providing transactional data privacy while maintaining data usability, including the use of different obfuscation functions for different data types to securely obfuscate the data, in real-time, while maintaining its statistical characteristics. In accordance with an embodiment, the system comprises an obfuscation process that captures data while it is being received in the form of data changes at a first or source system, selects one or more obfuscation techniques to be used with the data according to the type of data captured, and obfuscates the data, using the selected one or more obfuscation techniques, to create an obfuscated data, for use in generating a trail file containing the obfuscated data, or applying the data changes to a target or second system.

公开(公告)号：US20180157710A1

公开(公告)日：2018-06-07

申请号：US15368345

申请日：2016-12-02

Applicant: Oracle International Corporation

Inventor： Shenoda Guirguis ,  Sabina Petride

IPC: G06F17/30

CPC classification number: G06F16/24545 ,  G06F16/27

Abstract: Techniques are presented herein for efficient query processing and data change propagation at a secondary database system. The techniques involve determining execution costs for executing a query at a primary DBMS and for executing the query at an offload DBMS. The cost for executing the query at the offload DBMS includes the cost of propagating changes to database objects required by the query to the offload DBMS. Based on the execution cost, the query is sent to either the primary DBMS or the offload DBMS.

公开(公告)号：US20210089669A1

公开(公告)日：2021-03-25

申请号：US17109807

申请日：2020-12-02

Applicant: Oracle International Corporation

Inventor： Shenoda Guirguis ,  Alok Pareek ,  Stephen Wilkes

IPC: G06F21/62 ,  G06F16/28 ,  G06F16/23 ,  G16H10/60 ,  G06F9/46

Abstract: A system and method for providing transactional data privacy while maintaining data usability, including the use of different obfuscation functions for different data types to securely obfuscate the data, in real-time, while maintaining its statistical characteristics. In accordance with an embodiment, the system comprises an obfuscation process that captures data while it is being received in the form of data changes at a first or source system, selects one or more obfuscation techniques to be used with the data according to the type of data captured, and obfuscates the data, using the selected one or more obfuscation techniques, to create an obfuscated data, for use in generating a trail file containing the obfuscated data, or applying the data changes to a target or second system.

公开(公告)号：US10860732B2

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

申请号：US14925870

申请日：2015-10-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Shenoda Guirguis ,  Alok Pareek ,  Stephen Wilkes

IPC: G06F7/00 ,  G06F21/62 ,  G06F16/28 ,  G06F16/23 ,  G16H10/60 ,  G06F9/46 ,  G06F17/30 ,  G06F16/31 ,  G06F16/29

Abstract: A system and method for providing transactional data privacy while maintaining data usability, including the use of different obfuscation functions for different data types to securely obfuscate the data, in real-time, while maintaining its statistical characteristics. In accordance with an embodiment, the system comprises an obfuscation process that captures data while it is being received in the form of data changes at a first or source system, selects one or more obfuscation techniques to be used with the data according to the type of data captured, and obfuscates the data, using the selected one or more obfuscation techniques, to create an obfuscated data, for use in generating a trail file containing the obfuscated data, or applying the data changes to a target or second system.

公开(公告)号：US10691722B2

公开(公告)日：2020-06-23

申请号：US15610171

申请日：2017-05-31

Applicant: Oracle International Corporation

Inventor： Shenoda Guirguis ,  Kantikiran Pasupuleti ,  Sabina Petride ,  Sam Idicula

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/2455

Abstract: Techniques are described for efficient query processing and data change propagation to a secondary database system. The secondary database system may execute queries received at a primary database system. Database changes made at the primary system are copied to the secondary system. The primary system receives a query to be executed on either the primary system or the secondary system. The primary system determines whether to send the query to the secondary system based upon whether data objects stored within the secondary system have pending changes that need to be applied to the data objects. The pending changes are stored within in-memory journals within the primary system. The primary system scans for the pending changes to the data objects and sends the pending changes to the secondary system. The secondary system then receives and applies the pending changes to the data objects within the secondary system. Upon applying the pending changes, the secondary system executes the query.