公开(公告)号：US20250156160A1

公开(公告)日：2025-05-15

申请号：US19025695

申请日：2025-01-16

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Hassan Heidari Namarvar ,  Alexander Sasha Stojanovic ,  David Allan ,  Ganesh Seetharaman

IPC: G06F8/41 ,  G06F3/042 ,  G06F3/0482 ,  G06F3/06 ,  G06F8/10 ,  G06F8/34 ,  G06F9/50 ,  G06F16/14 ,  G06F16/21 ,  G06F16/23 ,  G06F16/25 ,  G06F16/435 ,  G06F17/18 ,  G06F40/30 ,  G06N5/022 ,  G06N5/04 ,  G06N5/046 ,  G06N20/00 ,  G06Q10/0637

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system can provide support for auto-mapping of complex data structures, datasets or entities, between one or more sources or targets of data, referred to herein in some embodiments as HUBs. The auto-mapping can be driven by a metadata, schema, and statistical profiling of a dataset; and used to map a source dataset or entity associated with an input HUB, to a target dataset or entity or vice versa, to produce an output data prepared in a format or organization (projection) for use with one or more output HUBs.

公开(公告)号：US12282757B2

公开(公告)日：2025-04-22

申请号：US17490186

申请日：2021-09-30

Applicant: Oracle International Corporation

Inventor： Hassan Heidari Namarvar ,  Alexander Sasha Stojanovic ,  David Allan ,  Ganesh Seetharaman

IPC: G06F16/00 ,  G06F3/042 ,  G06F3/0482 ,  G06F3/06 ,  G06F8/10 ,  G06F8/34 ,  G06F8/41 ,  G06F16/14 ,  G06F16/21 ,  G06F16/23 ,  G06F16/25 ,  G06F16/435 ,  G06F17/18 ,  G06F40/30 ,  G06N5/022 ,  G06N5/04 ,  G06N5/046 ,  G06N20/00 ,  G06Q10/0637 ,  G06F9/50

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system can provide support for auto-mapping of complex data structures, datasets or entities, between one or more sources or targets of data, referred to herein in some embodiments as HUBs. The auto-mapping can be driven by a metadata, schema, and statistical profiling of a dataset; and used to map a source dataset or entity associated with an input HUB, to a target dataset or entity or vice versa, to produce an output data prepared in a format or organization (projection) for use with one or more output HUBs.

公开(公告)号：US11526338B2

公开(公告)日：2022-12-13

申请号：US16921533

申请日：2020-07-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ganesh Seetharaman ,  Alexander Sasha Stojanovic ,  Hassan Heidari Namarvar ,  David Allan

IPC: G06F9/44 ,  G06F3/0484 ,  G06F8/41 ,  G06N20/00 ,  G06F16/14 ,  G06F16/21 ,  G06F16/25 ,  G06F16/435 ,  G06F16/23 ,  G06N5/04 ,  G06Q10/06 ,  G06F40/30 ,  G06F3/0482 ,  G06F17/18 ,  G06N5/02 ,  G06F8/10 ,  G06F8/34 ,  G06F3/042 ,  G06F3/06 ,  G06F9/50

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system can provide a service to recommend actions and transformations, on an input data, based on patterns identified from the functional decomposition of a data flow for a software application, including determining possible transformations of the data flow in subsequent applications. Data flows can be decomposed into a model describing transformations of data, predicates, and business rules applied to the data, and attributes used in the data flows.

公开(公告)号：US10776086B2

公开(公告)日：2020-09-15

申请号：US15683563

申请日：2017-08-22

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ganesh Seetharaman ,  Alexander Sasha Stojanovic ,  Hassan Heidari Namarvar ,  David Allan

IPC: G06F7/00 ,  G06F8/41 ,  G06N20/00 ,  G06F16/14 ,  G06F16/21 ,  G06F16/25 ,  G06F16/435 ,  G06F16/23 ,  G06N5/04 ,  G06Q10/06 ,  G06F40/30 ,  G06F3/0482 ,  G06F17/18 ,  G06N5/02 ,  G06F8/10 ,  G06F8/34 ,  G06F3/042 ,  G06F3/06 ,  G06F9/50

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system provides a programmatic interface, referred to herein in some embodiments as a foreign function interface, by which a user or third-party can define a service, functional and business types, semantic actions, and patterns or predefined complex data flows based on functional and business types, in a declarative manner, to extend the functionality of the system.

公开(公告)号：US20200241854A1

公开(公告)日：2020-07-30

申请号：US16845738

申请日：2020-04-10

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Alexander Sasha Stojanovic ,  Hassan Heidari Namarvar ,  David Allan ,  Ganesh Seetharaman

IPC: G06F8/41 ,  G06N20/00 ,  G06F16/14 ,  G06F16/21 ,  G06F16/25 ,  G06F16/435 ,  G06F16/23 ,  G06N5/04 ,  G06Q10/06 ,  G06F40/30 ,  G06F3/0482 ,  G06F17/18 ,  G06N5/02 ,  G06F8/10 ,  G06F8/34 ,  G06F3/042 ,  G06F3/06

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system can perform an ontology analysis of a schema definition, to determine the types of data, and datasets or entities, associated with that schema; and generate, or update, a model from a reference schema that includes an ontology defined based on relationships between datasets or entities, and their attributes. A reference HUB including one or more schemas can be used to analyze data flows, and further classify or make recommendations such as, for example, transformations enrichments, filtering, or cross-entity data fusion of an input data.

公开(公告)号：US10216814B2

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

申请号：US14044429

申请日：2013-10-02

Applicant: Oracle International Corporation

Inventor： David Allan ,  Kwok-hung (Thomas) Lau ,  Yu (Jeff) Gong

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30 ,  G06F8/41

Abstract: A data integration system is disclosed that incorporates one or more techniques for eases the design and maintenance of a mapping. As components are added to an existing design, the data integration system removes the need to specify all input and output attributes. In one aspect, components types are implement that allow entity relationships to be added and/or edited in a flow view of a logical design. Therefore, attributes of components representing datasets can be added and propagated to downstream components with minimal effort on the part of a map designer.

公开(公告)号：US10073867B2

公开(公告)日：2018-09-11

申请号：US14077135

申请日：2013-11-11

Applicant: Oracle International Corporation

Inventor： Thomas Lau ,  David Allan

IPC: G06F8/35 ,  G06F17/30 ,  G06F8/20 ,  G06F8/34

CPC classification number: G06F16/211 ,  G06F8/20 ,  G06F8/34 ,  G06F8/35 ,  G06F16/25 ,  G06F16/254

Abstract: In various embodiments, a data integration system is disclosed which enables users to create a logical design which is platform and technology independent. The user can create a logical design that defines, at a high level, how a user wants data to flow between sources and targets. The tool can analyze the logical design, in view of the user's infrastructure, and create a physical design. The logical design can include a plurality of components corresponding to each source and target in the design, as well as operations such as joins or filters, and access points. Each component when transferred to the physical design generates code to perform operations on the data. Depending on the underlying technology (e.g., SQL Server, Oracle, Hadoop, etc.) and the language used (SQL, pig, etc.) the code generated by each component may be different.

公开(公告)号：US20180052870A1

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

申请号：US15683559

申请日：2017-08-22

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Alexander Sasha Stojanovic ,  Hassan Heidari Namarvar ,  David Allan ,  Ganesh Seetharaman

IPC: G06F17/30 ,  G06N99/00 ,  G06N5/04

CPC classification number: G06F8/433 ,  G06F3/0428 ,  G06F3/0482 ,  G06F3/0649 ,  G06F8/10 ,  G06F8/34 ,  G06F8/4452 ,  G06F9/5061 ,  G06F16/144 ,  G06F16/211 ,  G06F16/2322 ,  G06F16/2358 ,  G06F16/254 ,  G06F16/435 ,  G06F17/18 ,  G06F17/2785 ,  G06N5/022 ,  G06N5/04 ,  G06N5/046 ,  G06N20/00 ,  G06Q10/0637

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system can perform an ontology analysis of a schema definition, to determine the types of data, and datasets or entities, associated with that schema; and generate, or update, a model from a reference schema that includes an ontology defined based on relationships between datasets or entities, and their attributes. A reference HUB including one or more schemas can be used to analyze data flows, and further classify or make recommendations such as, for example, transformations enrichments, filtering, or cross-entity data fusion of an input data.

公开(公告)号：US20180052861A1

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

申请号：US15683563

申请日：2017-08-22

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ganesh Seetharaman ,  Alexander Sasha Stojanovic ,  Hassan Heidari Namarvar ,  David Allan

IPC: G06F17/30 ,  G06F17/27 ,  G06N99/00 ,  G06F3/042

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system provides a programmatic interface, referred to herein in some embodiments as a foreign function interface, by which a user or third-party can define a service, functional and business types, semantic actions, and patterns or predefined complex data flows based on functional and business types, in a declarative manner, to extend the functionality of the system.

公开(公告)号：US20180052898A1

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

申请号：US15683554

申请日：2017-08-22

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： David Allan ,  Alexander Sasha Stojanovic ,  Hassan Heidari Namarvar ,  Ganesh Seetharaman

IPC: G06F17/30 ,  G06F17/27 ,  G06N5/02 ,  G06N99/00 ,  G06F3/0482 ,  G06F17/18

CPC classification number: G06F8/433 ,  G06F3/0428 ,  G06F3/0482 ,  G06F3/0649 ,  G06F8/10 ,  G06F8/34 ,  G06F8/4452 ,  G06F9/5061 ,  G06F16/144 ,  G06F16/211 ,  G06F16/2322 ,  G06F16/2358 ,  G06F16/254 ,  G06F16/435 ,  G06F17/18 ,  G06F17/2785 ,  G06N5/022 ,  G06N5/04 ,  G06N5/046 ,  G06N20/00 ,  G06Q10/0637

Abstract: In accordance with various embodiments, described herein is a system (Data Artificial Intelligence system, Data AI system), for use with a data integration or other computing environment, that leverages machine learning (ML, DataFlow Machine Learning, DFML), for use in managing a flow of data (dataflow, DF), and building complex dataflow software applications (dataflow applications, pipelines). In accordance with an embodiment, the system can include a software development component and graphical user interface, referred to herein in some embodiments as a pipeline editor, or Lambda Studio IDE, that provides a visual environment for use with the system, including providing real-time recommendations for performing semantic actions on data accessed from an input HUB, based on an understanding of the meaning or semantics associated with the data.