发明名称 Row-based data filtering at a database level
摘要 A database management system provides row based filtering of data at a database level by evaluating content of at least one record of a write data request received from an application for a particular table from among at least one table of a database, against at least one filter rule specified for the particular table. The database management system selects, for the at least one record, whether to store the at least one record of the write data request as a separate row in the particular table based on a separate action triggered for the at least one record when evaluated against the at least one filter rule specified for the particular table, each record not selected for storage being silently discarded.
申请公布号 US9165078(B2) 申请公布日期 2015.10.20
申请号 US201313826906 申请日期 2013.03.14
申请人 INTERNATIONAL BUSINESS MACHINES CORPORATION 发明人 Bester Karla;Chandler Allan T.;Shewell Mark A.;Yates Stephen J.
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人 Labaw Jeffrey S.;Pattillo Amy J.
主权项 1. A method for filtering data in an incoming write data request, comprising: a computer, receiving a write data request by a filter write controller in a write layer of a database management system, the write data request passed to the filter write controller from a request interface of the database management system that receives a plurality of write data requests from one or more applications requesting to write data to one or more tables from among a plurality of tables of a database; the computer, responsive to the filter write controller receiving the write data request, determining whether a particular filter list in the write layer, associated with a particular table from among the plurality of tables specified in the write data request, comprises at least one filter rule, from among a plurality of filter lists each associated with a separate table from among the plurality of tables; the computer, responsive to detecting the particular filter list associated with the particular table comprises the at least one filter rule, evaluating content of the at least one record of the write data request for the particular table, against the at least one filter rule specified for the particular table in the particular filter list; and the computer selecting, by the filter write controller, whether to allow storage of the at least one record of the write data request as a separate row in the particular table based on a separate action triggered for the at least one record when evaluated against the at least one filter rule specified for the particular table, each record not selected for storage being silently discarded.
地址 Armonk NY US