Feature Code 5: Omnipresent Sets - Provides the Perfect Set Operations

          Omnipresent sets

• Ubiquity of sets

The set is a widely-applied basic data type. For example, the order paid in this quarter, the list of premium clients (set A1), and the Top 500 enterprise (set B1).

• Provides the perfect set operations

esProc provides the set operation (intersection, union, compliment, and other operations) that can materialize the abstract basic data, convert them to the business understandable language, and carry out the stepwise computations according to the business requirements. In this way, the complexity is greatly reduced. For example, you can directly use A1^B1 to select out the Top 500 clients among those premium clients.
       By compassion, the stepwise computation is not favored and thus the set is also unsupported by SQL. The high level language cannot support the set operation directly, requiring programmers to implement a great many lines of codes.