CONVEYING HIERARCHICAL ELEMENTS OF A USER INTERFACE
    11.
    发明申请
    CONVEYING HIERARCHICAL ELEMENTS OF A USER INTERFACE 有权
    输入用户界面的分层元素

    公开(公告)号:US20130205252A1

    公开(公告)日:2013-08-08

    申请号:US13366629

    申请日:2012-02-06

    IPC分类号: G06F3/048

    CPC分类号: G06Q10/06

    摘要: Techniques are disclosed for generating a view of a data flow model. One or more groupings of data flow objects in the data flow model is determined, based on an ontology. At least a first one of the groupings is collapsed in the view. The view is output for display in a user interface configured to selectively expand and collapse the first group based on user input.

    摘要翻译: 公开了用于生成数据流模型的视图的技术。 基于本体来确定数据流模型中数据流对象的一个​​或多个分组。 至少在分组中的第一个在视图中折叠。 视图被输出以在用户界面中显示,用户界面被配置为基于用户输入选择性地展开和折叠第一组。

    Information governance crowd sourcing
    12.
    发明授权
    Information governance crowd sourcing 有权
    信息治理人群采购

    公开(公告)号:US09092749B2

    公开(公告)日:2015-07-28

    申请号:US13446681

    申请日:2012-04-13

    摘要: A method, computer program product, and system for information governance crowd sourcing by, responsive to receiving a data quality exception identifying one or more data quality errors in a data store, identifying a performance level required to correct the data quality errors, selecting, from a crowd hierarchy, a first one or more crowds meeting the defined performance level, wherein the crowd hierarchy ranks the performance of one or more crowds, and routing, by operation of one or more computer processors, the one or more data quality errors to the selected crowds for correction.

    摘要翻译: 一种用于信息治理的方法,计算机程序产品和系统,通过响应于接收到数据质量异常来识别数据存储中的一个或多个数据质量错误,识别纠正数据质量错误所需的性能水平,从 人群层次结构,满足定义的性能级别的第一个或多个人群,其中,群体层次结构对一个或多个人群的表现进行排序,并且通过一个或多个计算机处理器的操作将一个或多个数据质量错误路由到 选择人群进行修正。

    Ontology guided reference data discovery
    13.
    发明授权
    Ontology guided reference data discovery 失效
    本体指导参考数据发现

    公开(公告)号:US08250101B2

    公开(公告)日:2012-08-21

    申请号:US12789225

    申请日:2010-05-27

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30306

    摘要: Mapping and translating reference data from multiple databases using an enterprise ontology. This is achieved by various means, including mapping values of a first database to corresponding fields within the ontology, mapping values of a second database to corresponding fields within the ontology, and determining relationships between the values of the first database and the values of the second database based on their respective mappings to common fields within the ontology.

    摘要翻译: 使用企业本体从多个数据库映射和翻译参考数据。 这通过各种手段实现,包括将第一数据库的值映射到本体内的相应字段,将第二数据库的值映射到本体内的相应字段,以及确定第一数据库的值与第二数据库的值之间的关系 数据库基于它们各自映射到本体内的常见字段。

    Method to detect reference data tables in ETL processes
    14.
    发明授权
    Method to detect reference data tables in ETL processes 失效
    在ETL流程中检测参考数据表的方法

    公开(公告)号:US08583626B2

    公开(公告)日:2013-11-12

    申请号:US13415047

    申请日:2012-03-08

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30563

    摘要: A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data.

    摘要翻译: 一种用于通过在一个或多个计算机处理器的操作中识别在该过程中的至少第一参考数据运算符来识别提取 - 转换 - 加载(ETL)过程中的参考数据表的方法,系统和计算机程序产品,其中, 第一参考数据运算符引用一个或多个表并且评估由参考数据运算符引用的至少第一表,以通过将得分分配给第一表来确定第一表是参考数据表,其中分数表示可能性 第一表是参考数据表,并且其中参考数据表包含描述其他数据的一组值。

    Detecting transcoding tables in extract-transform-load processes
    15.
    发明授权
    Detecting transcoding tables in extract-transform-load processes 有权
    在提取 - 转换 - 加载过程中检测转码表

    公开(公告)号:US08954376B2

    公开(公告)日:2015-02-10

    申请号:US13415018

    申请日:2012-03-08

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30563

    摘要: Techniques are disclosed for identifying transcoding tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, records passing through an operator configured to replace values in the records with values from at least one table linked to the operator before being sent to an output table, wherein the operator specifies an operation for extracting, transforming, or loading data stored in one or more source systems into storage by a target system, and evaluating at least a first table linked to the operator to determine whether the first table is a transcoding table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a transcoding table, wherein a transcoding table is used to harmonize values from a plurality of tables in the one or more source systems to a table in the target.

    摘要翻译: 公开了用于在提取 - 转换 - 加载(ETL)过程中识别代码转换表的技术,通过一个或多个计算机处理器的操作,通过被配置为用至少一个表中的值替换记录中的值的操作员的记录 在被发送到输出表之前链接到操作者,其中操作者指定用于将存储在一个或多个源系统中的数据提取,变换或加载到由目标系统存储的操作的操作,以及至少评估与第 操作者通过将分数分配给第一表来确定第一表是否是代码转换表,其中分数指示第一表是代码转换表的可能性,其中代码转换表用于协调来自多个 将一个或多个源系统中的表映射到目标中的表。

    Enforcing domain strong typing
    16.
    发明授权
    Enforcing domain strong typing 失效
    强制域强打字

    公开(公告)号:US07953747B2

    公开(公告)日:2011-05-31

    申请号:US12192631

    申请日:2008-08-15

    IPC分类号: G06F17/30

    摘要: A centralized method for defining and enforcing strong-typing among domains in RDBMS or ORDBMS is provided to allow flexible, easy, and quick domain creation, as well as facilitating easy implementation and change control on domains. When an application requests data from the database, one or more domains are first identified in the SQL query. A determination is then made as to whether operators for each domain pair in the SQL query are authorized. A determination is also made as to whether functions in the SQL authorized. If the operators and functions in the SQL are authorized, the initial SQL request is rewritten to include a casting formula for each domain pair operation. The rewritten SQL request is then executed.

    摘要翻译: 提供了一种用于在RDBMS或ORDBMS中的域之间定义和强制强类型化的集中方法,以便灵活,简单,快速地创建域,以及便于实现和更改域控制。 当应用程序从数据库请求数据时,首先在SQL查询中标识一个或多个域。 然后确定SQL查询中每个域对的运算符是否被授权。 还要确定SQL中的功能是否被授权。 如果SQL中的运算符和函数被授权,则初始SQL请求将被重写,以包括每个域对操作的转换公式。 然后执行重写的SQL请求。