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

    Serial advanced technology attachment dual in-line memory module assembly
    6.
    发明授权
    Serial advanced technology attachment dual in-line memory module assembly 失效
    串行高级技术附件双列直插式内存模组装配

    公开(公告)号:US08611097B2

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

    申请号:US13339407

    申请日:2011-12-29

    Abstract: A serial advanced technology attachment dual-in-line memory module (SATA DIMM) assembly includes a SATA DIMM module with a first circuit board, an expansion slot, and an expansion card with a second circuit board. A first edge connector is arranged on a bottom edge of the first circuit board and includes first power pins connected to a control chip and first storage chips, and first ground pins. A second edge connector connected to the expansion slot is arranged on a top edge of the first circuit board and includes second power pins connected to the first power pins, second ground pins, and four first signal pins connected to the control chip. A third edge connector engaged in the expansion slot is arranged on a bottom edge of the second circuit board and includes third power pins and four second signal pins connected to the second storage chips, and third ground pins.

    Abstract translation: 串行高级技术附件双列直插式内存模块(SATA DIMM)组件包括一个带有第一个电路板的SATA DIMM模块,一个扩展插槽和一个带有第二个电路板的扩充卡。 第一边缘连接器布置在第一电路板的底部边缘上,并且包括连接到控制芯片和第一存储芯片的第一电源引脚和第一接地引脚。 连接到扩展槽的第二边缘连接器布置在第一电路板的顶部边缘上,并且包括连接到第一电源引脚,第二接地引脚和连接到控制芯片的四个第一信号引脚的第二电源引脚。 接合在扩展槽中的第三边缘连接器布置在第二电路板的底部边缘上,并且包括连接到第二存储芯片的第三电源引脚和四个第二信号引脚以及第三接地引脚。

    Serial advanced technology attachment dual in-line memory module (SATA DIMM) capable of preventing data loss
    7.
    发明授权
    Serial advanced technology attachment dual in-line memory module (SATA DIMM) capable of preventing data loss 失效
    串行高级技术附件双列直插式内存模块(SATA DIMM),能够防止数据丢失

    公开(公告)号:US08582388B1

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

    申请号:US13564762

    申请日:2012-08-02

    CPC classification number: G11C5/04 G11C5/143

    Abstract: A serial advanced technology attachment dual in-line memory module device includes a power circuit, a storage chip, a control chip connected to the storage chip, and a detecting chip storing a preset voltage. The detecting chip includes a detecting pin connected to a power circuit through a first resistor and grounded through a second resistor, a ground pin grounded, a voltage pin connected to the power circuit, the control chip, and the storage chip, and an output pin connected to the storage chip. The detecting chip compares an output voltage of the power circuit detected by the detecting pin with the preset voltage, to output a control signal through the output pin to the control chip in response to the detected voltage being less than the preset voltage, to signal the control chip to control the storage chip to store data.

    Abstract translation: 串行高级技术附件双列直插存储器模块装置包括电源电路,存储芯片,连接到存储芯片的控制芯片以及存储预设电压的检测芯片。 检测芯片包括:检测引脚,其通过第一电阻连接到电源电路,并通过第二电阻器接地,接地引脚接地;连接到电源电路的电压引脚,控制芯片和存储芯片;以及输出引脚 连接到存储芯片。 检测芯片将检测引脚检测到的电源电路的输出电压与预设电压进行比较,以响应于检测到的电压小于预设电压,将控制信号通过输出引脚输出到控制芯片,以将信号通知 控制芯片控制存储芯片存储数据。

    ELECTRONIC DEVICE WITH FIRMWARE RECOVERY FUNCTION AND METHOD FOR RECOVERING FIRMWARE
    8.
    发明申请
    ELECTRONIC DEVICE WITH FIRMWARE RECOVERY FUNCTION AND METHOD FOR RECOVERING FIRMWARE 审中-公开
    具有固件恢复功能的电子设备和用于恢复固件的方法

    公开(公告)号:US20130212430A1

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

    申请号:US13612896

    申请日:2012-09-13

    Inventor: Lei DENG Wei-Min HE

    CPC classification number: G06F11/1417 G06F11/0736 G06F11/0793

    Abstract: An electronic device with firmware recovery function includes a connecting port to connect the electronic device to an external device and a BMC. The BMC includes a firmware memory storing firmware data of the BMC and a microprocessor. The microprocessor determines whether the BMC is able to execute the firmware data in the firmware memory, and determines whether a download command for downloading firmware data is received from the external device when the BMC is not able to execute the firmware data in the firmware memory. The microprocessor further reads the firmware data from the external device into a memory space of the microprocessor upon receiving the download command, and recovers the firmware data in the firmware memory by writing the firmware data from the memory space of the microprocessor into the firmware memory. A related method is also provided.

    Abstract translation: 具有固件恢复功能的电子设备包括将电子设备连接到外部设备和BMC的连接端口。 BMC包括存储BMC的固件数据和微处理器的固件存储器。 微处理器确定BMC是否能够执行固件存储器中的固件数据,并且当BMC不能够执行固件存储器中的固件数据时,确定是否从外部设备接收用于下载固件数据的下载命令。 微处理器在接收到下载命令时还将固件数据从外部设备读取到微处理器的存储器空间中,并通过将固件数据从微处理器的存储器空间写入固件存储器来恢复固件存储器中的固件数据。 还提供了相关的方法。

    Anti-frost coating and the application method thereof
    9.
    发明授权
    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
    10.
    发明申请
    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处理的数据变换的显示器上的用户界面。 第一显示区域呈现数据变换的数据表示。 第二显示区域呈现输入数据的视图,第三显示器呈现输出数据的视图。 接收用户输入修改数据变换。 响应于接收到用户输入,通过将修改的数据变换应用于输入数据而生成的输出数据来更新第三显示区域。

Patent Agency Ranking