System and method for automatically suggesting rules for data stored in a table

    公开(公告)号:US10332010B2

    公开(公告)日:2019-06-25

    申请号:US13770666

    申请日:2013-02-19

    Abstract: A method and system are presented of automatically suggesting rules for data stored in a table, with the table comprising a plurality of columns. The table is profiled to identify a content type for each of one or more of the plurality of columns. A rule knowledge base is accessed to locate rules specified for identified content types. Then, one or more of the located rules specified for identified content types are presented as suggestions. Acceptance of one or more of the suggested rules is received from a user, and the received validations are stored in the rule knowledge base. The accepted rules are applied to data for quality detection and monitoring. Embodiments are also described where columns are suggested based on a given rule.

    Automatic rule generation
    2.
    发明授权
    Automatic rule generation 有权
    自动规则生成

    公开(公告)号:US09152627B2

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

    申请号:US13623719

    申请日:2012-09-20

    CPC classification number: G06F17/30 G06F17/30371 G06F17/3051 G06Q10/06

    Abstract: In an example embodiment, a method of automatically generating data validation rules from data stored in a column of a table is provided. Outliers for the data are determined by analyzing a profiling statistic for the data, the profiling statistic having a type. Then it is determined if a predefined limit is exceeded, based on a quantity of the outliers determined for the data through the analysis of the profiling statistic. A data validation rule is then automatically generated based on non-outliers detected in the data through the analysis of the profiling statistic, the generated data validation rule also being based on the type of the profiling statistic. The data validation rule can then be applied to data subsequently entered for the column, causing at least a portion of the data subsequently entered for the column to be rejected.

    Abstract translation: 在示例实施例中,提供了从存储在表的列中的数据自动生成数据验证规则的方法。 通过分析数据的分析统计量,具有类型的分析统计信息来确定数据的异常值。 然后,基于通过分析统计量的分析为数据确定的异常值的数量,确定是否超过预定义的限制。 然后,基于通过分析统计信息的分析在数据中检测到的非离群值来自动生成数据验证规则,生成的数据验证规则也基于分析统计量的类型。 然后可以将数据验证规则应用于随后为列输入的数据,导致随后输入的数据的至少一部分数据被拒绝。

    METADATA SEARCH BASED ON SEMANTICS
    3.
    发明申请
    METADATA SEARCH BASED ON SEMANTICS 有权
    基于语义的元数据搜索

    公开(公告)号:US20150213021A1

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

    申请号:US14167424

    申请日:2014-01-29

    Abstract: According to some embodiments, a method and an apparatus of enriching search results with metadata are provided to receive a plurality of metadata associated with an entity and storing the plurality of metadata in a repository. A search request associated with the entity is received and search results that comprise a portion of the plurality of metadata stored in the repository are determined.

    Abstract translation: 根据一些实施例,提供了利用元数据来丰富搜索结果的方法和装置,以接收与实体相关联的多个元数据并将多个元数据存储在存储库中。 接收与实体相关联的搜索请求,并且确定包含存储在存储库中的多个元数据的一部分的搜索结果。

    System and Method for Data Quality Business Impact Analysis
    4.
    发明申请
    System and Method for Data Quality Business Impact Analysis 审中-公开
    数据质量业务影响分析系统与方法

    公开(公告)号:US20140379417A1

    公开(公告)日:2014-12-25

    申请号:US13924152

    申请日:2013-06-21

    CPC classification number: G06Q10/0635

    Abstract: A computer implemented method of calculating a cost impact. The method includes associating cost amounts with various rules, using the rules to identify bad data, and calculating an aggregate cost of the bad data. In this manner, the Data Steward can prioritize various data quality improvement projects.

    Abstract translation: 计算机实现计算成本影响的方法。 该方法包括将成本金额与各种规则相关联,使用规则来识别不良数据,以及计算坏数据的总成本。 以这种方式,数据管家可以优先考虑各种数据质量改进项目。

    Anti-frost coating and the application method thereof
    6.
    发明授权
    Anti-frost coating and the application method thereof 有权
    防霜涂层及其应用方法

    公开(公告)号:US08372484B2

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

    申请号:US12864607

    申请日:2009-01-21

    Abstract: The present invention provides an anti-frost coating, which forms a coat having a hydrophilic and hydrophobic composite structure after being applied on a substrate, and contains a hydrophobic polymer and a hydrophilic polymer. The application method of the anti-frost coating comprises: dissolving the hydrophilic polymer and the hydrophobic polymer in a solvent to form a homogeneous solution, coating the solution on a substrate to form a film, drying and curing to form an anti-frost coat with a hydrophilic and super-hydrophobic composite structure including a super-hydrophobic surface layer and a hydrophilic inner layer. Water drips can roll off easily and the dust and impurities deposited on the surface can be easily removed. The anti-frost effect is desirable.

    Abstract translation: 本发明提供一种防霜涂层,其在涂布在基材上后形成具有亲水和疏水复合结构的涂层,并且含有疏水性聚合物和亲水性聚合物。 防霜涂层的应用方法包括:将亲水性聚合物和疏水性聚合物溶解在溶剂中以形成均匀溶液,将溶液涂布在基材上以形成膜,干燥和固化以形成具有 包含超疏水表面层和亲水性内层的亲水和超疏水复合结构。 水滴可能容易脱落,沉积在表面上的灰尘和杂质可以很容易地去除。 防霜效果是可取的。

    Dataset Previews for ETL Transforms
    7.
    发明申请
    Dataset Previews for ETL Transforms 有权
    ETL变换的数据集预览

    公开(公告)号:US20120284223A1

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

    申请号:US13101418

    申请日:2011-05-05

    CPC classification number: G06F17/30563

    Abstract: Disclosed is a user interface on a display for editing data transformations comprising an ETL process. A first display area presents a data representation of a data transformation. A second display area presents a view of input data, and a third display are presents a view of output data. User input to modify the data transformation is received. In response to receiving the user input, the third display area is updated with output data generated by applying the modified data transformation to the input data.

    Abstract translation: 公开了用于编辑包括ETL处理的数据变换的显示器上的用户界面。 第一显示区域呈现数据变换的数据表示。 第二显示区域呈现输入数据的视图,第三显示器呈现输出数据的视图。 接收用户输入修改数据变换。 响应于接收到用户输入,通过将修改的数据变换应用于输入数据而生成的输出数据来更新第三显示区域。

    USING POCKET DEVICE TO SURVEY, MONITOR, AND CONTROL PRODUCTION DATA IN REAL TIME
    8.
    发明申请
    USING POCKET DEVICE TO SURVEY, MONITOR, AND CONTROL PRODUCTION DATA IN REAL TIME 审中-公开
    使用POCKET设备实时调查,监控和控制生产数据

    公开(公告)号:US20100127888A1

    公开(公告)日:2010-05-27

    申请号:US12323960

    申请日:2008-11-26

    CPC classification number: G01V1/40

    Abstract: A system for real-time data surveillance in an oilfield operation includes a data collection system deployed at a well site for collecting oilfield data; an office-based computer system for storing and analyzing the oilfield data; a portable device, wherein the portable device includes at least one program for communicating with the office-based computer system, for surveying the oilfield data stored in the office-based computer system, and for causing the office-based computer system to perform a process implemented on the office-based computer system; and a communication system providing communication links among the data collection system, the office-based computer system, and the portable device.

    Abstract translation: 油田作业实时数据监控系统,包括部署在井场采集油田数据的数据采集系统; 用于存储和分析油田数据的办公室计算机系统; 便携式设备,其中便携式设备包括用于与基于办公室的计算机系统通信的至少一个程序,用于测量存储在基于办公室的计算机系统中的油田数据,并且使得基于办公室的计算机系统执行处理 在办公室的计算机系统上实施; 以及提供数据收集系统,基于办公室的计算机系统和便携式设备之间的通信链路的通信系统。

    Synthesis of stable solutions of rare earth tris (organophosphate) in hydrocarbon solvents

    公开(公告)号:US06767927B1

    公开(公告)日:2004-07-27

    申请号:US09557719

    申请日:2000-04-25

    Applicant: Kenan Yunlu Min He

    Inventor: Kenan Yunlu Min He

    CPC classification number: C07F9/025

    Abstract: Stable rare earth tris (organophosphate) solutions comprise a rare earth tris (organophosphate) and a hydrocarbon solvent. From about 2% to about 10% rare earth element, preferably from about 3% to about 8%, is present in the solutions. The rare earth tris (organophosphate) solutions are stable from precipitation of the rare earth tris (organophosphate) for at least about fifteen (15) days, preferably for at least about twenty (20) days and most preferably at least about thirty (30) days. A process for preparing these solutions is described herein. A stabilizing additive, acid, glycol or mixtures thereof, is utilized to inhibit precipitation. The molar ratios of free acid, glycol and/or water to the rare earth element are controlled to inhibit precipitation.

Patent Agency Ranking