Unlock instant, AI-driven research and patent intelligence for your innovation.

Antinull usage and simulation in data filtering

A data value and data item technology, which is applied in special data processing applications, electrical digital data processing, digital data information retrieval, etc., can solve the problem of not allowing multiple specific items, etc.

Inactive Publication Date: 2012-07-11
MICROSOFT CORP
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Unfortunately, this only works with text data, and generally doesn't allow selection of multiple specific items (e.g. Maria, Abdul, and John from the example above)

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Antinull usage and simulation in data filtering
  • Antinull usage and simulation in data filtering
  • Antinull usage and simulation in data filtering

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] Embodiments may extend the data system to include a dedicated token, shown and described herein as "AntiNull." AntiNull tokens have custom semantics that define how the AntiNull token interacts with other values ​​in the system, especially in comparisons and calculations. These semantics ensure that using AntiNull as a parameter value for data filtering produces unfiltered data. Additionally, embodiments may include declarative configuration for interoperability with systems that do not natively support AntiNull tokens.

[0050] AntiNull is a dedicated token representing all possible values ​​in the domain in which this AntiNull is used. Although not exactly the opposite of null (which represents unknown values ​​or values ​​outside the domain), AntiNull has a number of properties that complement the null behavior.

[0051] The following shows the behavior of AntiNull in filter conditions. For an AntiNull that behaves as a "don't apply this filter" indicator in a fil...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

AntiNull usage and simulation in data filtering are described here. Data items are compared. The method includes accessing a query or command to retrieve data. The query or command includes an identification of a data item, a logical operator and a specialized token. A comparison as defined by the logical operator between the data item and the specialized token is performed. The following illustrates the results of the logical operation on any data item and the specialized token: an equal logical operation results in true, a greater than logical operation results in false; a less than logical operation results in false; a greater than or equal to logical operation results in true; a less than or equal to logical operation results in true; a not equal logical operation results in false; an IN logical operation results in true; and a NOT IN logical operation results in false. As a result of the comparison, the data item may be retrieved.

Description

technical field [0001] The present invention relates to data filtering, in particular to the use and simulation of AntiNull in data filtering. technical background [0002] Background and Related Fields [0003] Computers and computing systems have impacted nearly every aspect of modern life. Computers are commonly used for work, leisure, healthcare, transportation, entertainment, home management, and the like. [0004] In data applications, there is no simple general way for efficient parametric selection of data, where sometimes a subset of the data is selected, and other times all the data is selected. [0005] For example, consider the following SQL query: [0006] SELECT Customer.Id, Customer.Name, Customer.Age [0007] FROM Customer [0008] WHERE Customer.Name IN(CustomerNames) [0009] Once parameter values ​​have been passed into the query, the query can become equivalent to the following query: [0010] SELECT Customer.Id, Customer.Name, Customer.Age [001...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30421G06F16/2448
Inventor C·A·海斯A·S·梅耶斯A·I·米内耶夫
Owner MICROSOFT CORP