(Cat? OR feline) AND NOT dog?
Cat? W/5 behavior
(Cat? OR feline) AND traits
Cat AND charact*

This guide provides a more detailed description of the syntax that is supported along with examples.

This search box also supports the look-up of an IP.com Digital Signature (also referred to as Fingerprint); enter the 72-, 48-, or 32-character code to retrieve details of the associated file or submission.

Concept Search - What can I type?

For a concept search, you can enter phrases, sentences, or full paragraphs in English. For example, copy and paste the abstract of a patent application or paragraphs from an article.

Concept search eliminates the need for complex Boolean syntax to inform retrieval. Our Semantic Gist engine uses advanced cognitive semantic analysis to extract the meaning of data. This reduces the chances of missing valuable information, that may result from traditional keyword searching.

Publishing Venue

Related People

Abstract

Disclosed is the method to directly specify the SQL Having clause by selecting a column in a SQL Group By statement with direct manipulation techniques identical to those used to specify the SQL Where clause. The user interface design itself will enforce the restrictions as to what column may or may not be included. In addition, any changes to the validity of the Having clause are automatically corrected by the system.

Country

United States

Language

English (United States)

This text was extracted from an ASCII text file.

This is the abbreviated version, containing approximately
52% of the total text.

Improved Query Understanding Through the Use of a Having
Window

Disclosed is
the method to directly specify the SQL
Having clause by selecting a column in a SQL Group By statement with
direct manipulation techniques identical to those used to specify the
SQL Where clause. The user interface
design itself will enforce the
restrictions as to what column may or may not be included. In
addition, any changes to the validity of the Having clause are
automatically corrected by the system.

A user involved
in defining a database query may be required to
use a Having clause. This allows the
output collected into groups by
the Group By clause to be filtered as a group.
Existing user
interfaces treat the Having clause as a special function that is
directly entered by text or in a special dialog. This reduces the
useability of the product by requiring that the user conceptualize
the clause as somehow not part of the main query. In fact, the Group
By clause directly determines what can be included in the Having
clause and what it means. This results
in unique dialogs when using
Having at a cost to the developer and user.

A Having
clause specifies that only the results table rows that
meet the Having clause restrictions be included. The Having clause
only applies to the Group By clause. The
proposal is to present a
Having clause option in the Group By object.
The user signifies the
need for a Having clause by operating on the Group By column. This
initiates a dialog to specify the Having clause for that column.
Following the completion of the definition dialog, the Having clause
is displayed as connected to the Group By column in a visual obje...