HOME

TheInfoList



OR:

In
computer science Computer science is the study of computation, information, and automation. Computer science spans Theoretical computer science, theoretical disciplines (such as algorithms, theory of computation, and information theory) to Applied science, ...
, a set is an
abstract data type In computer science, an abstract data type (ADT) is a mathematical model for data types, defined by its behavior (semantics) from the point of view of a '' user'' of the data, specifically in terms of possible values, possible operations on data ...
that can store unique values, without any particular
order Order, ORDER or Orders may refer to: * A socio-political or established or existing order, e.g. World order, Ancien Regime, Pax Britannica * Categorization, the process in which ideas and objects are recognized, differentiated, and understood ...
. It is a computer implementation of the
mathematical Mathematics is a field of study that discovers and organizes methods, Mathematical theory, theories and theorems that are developed and Mathematical proof, proved for the needs of empirical sciences and mathematics itself. There are many ar ...
concept of a
finite set In mathematics, particularly set theory, a finite set is a set that has a finite number of elements. Informally, a finite set is a set which one could in principle count and finish counting. For example, is a finite set with five elements. Th ...
. Unlike most other collection types, rather than retrieving a specific element from a set, one typically tests a value for membership in a set. Some set data structures are designed for static or frozen sets that do not change after they are constructed. Static sets allow only query operations on their elements — such as checking whether a given value is in the set, or enumerating the values in some arbitrary order. Other variants, called dynamic or mutable sets, allow also the insertion and deletion of elements from the set. A
multiset In mathematics, a multiset (or bag, or mset) is a modification of the concept of a set that, unlike a set, allows for multiple instances for each of its elements. The number of instances given for each element is called the ''multiplicity'' of ...
is a special kind of set in which an element can appear multiple times in the set.


Type theory

In
type theory In mathematics and theoretical computer science, a type theory is the formal presentation of a specific type system. Type theory is the academic study of type systems. Some type theories serve as alternatives to set theory as a foundation of ...
, sets are generally identified with their
indicator function In mathematics, an indicator function or a characteristic function of a subset of a set is a function that maps elements of the subset to one, and all other elements to zero. That is, if is a subset of some set , then the indicator functio ...
(characteristic function): accordingly, a set of values of type A may be denoted by 2^ or \mathcal(A). (Subtypes and subsets may be modeled by refinement types, and
quotient set In mathematics, when the elements of some set S have a notion of equivalence (formalized as an equivalence relation), then one may naturally split the set S into equivalence classes. These equivalence classes are constructed so that elements ...
s may be replaced by
setoid In mathematics, a setoid (''X'', ~) is a set (or type) ''X'' equipped with an equivalence relation ~. A setoid may also be called E-set, Bishop set, or extensional set. Setoids are studied especially in proof theory and in type-theoretic foun ...
s.) The characteristic function F of a set S is defined as: :F(x) = \begin 1, & \mbox x \in S \\ 0, & \mbox x \not \in S \end In theory, many other abstract data structures can be viewed as set structures with additional operations and/or additional
axiom An axiom, postulate, or assumption is a statement that is taken to be true, to serve as a premise or starting point for further reasoning and arguments. The word comes from the Ancient Greek word (), meaning 'that which is thought worthy or ...
s imposed on the standard operations. For example, an abstract heap can be viewed as a set structure with a min(''S'') operation that returns the element of smallest value.


Operations


Core set-theoretical operations

One may define the operations of the
algebra of sets In mathematics, the algebra of sets, not to be confused with the mathematical structure of ''an'' algebra of sets, defines the properties and laws of sets, the set-theoretic operations of union, intersection, and complementation and the re ...
: * union(''S'',''T''): returns the union of sets ''S'' and ''T''. * intersection(''S'',''T''): returns the
intersection In mathematics, the intersection of two or more objects is another object consisting of everything that is contained in all of the objects simultaneously. For example, in Euclidean geometry, when two lines in a plane are not parallel, their ...
of sets ''S'' and ''T''. * difference(''S'',''T''): returns the difference of sets ''S'' and ''T''. * subset(''S'',''T''): a predicate that tests whether the set ''S'' is a
subset In mathematics, a Set (mathematics), set ''A'' is a subset of a set ''B'' if all Element (mathematics), elements of ''A'' are also elements of ''B''; ''B'' is then a superset of ''A''. It is possible for ''A'' and ''B'' to be equal; if they a ...
of set ''T''.


Static sets

Typical operations that may be provided by a static set structure ''S'' are: * is_element_of(''x'',''S''): checks whether the value ''x'' is in the set ''S''. * is_empty(''S''): checks whether the set ''S'' is empty. * size(''S'') or
cardinality The thumb is the first digit of the hand, next to the index finger. When a person is standing in the medical anatomical position (where the palm is facing to the front), the thumb is the outermost digit. The Medical Latin English noun for thum ...
(''S'')
: returns the number of elements in ''S''. * iterate(''S''): returns a function that returns one more value of ''S'' at each call, in some arbitrary order. * enumerate(''S''): returns a list containing the elements of ''S'' in some arbitrary order. * build(''x''1,''x''2,…,''x''''n'',): creates a set structure with values ''x''1,''x''2,...,''x''''n''. * create_from(''collection''): creates a new set structure containing all the elements of the given collection or all the elements returned by the given
iterator In computer programming, an iterator is an object that progressively provides access to each item of a collection, in order. A collection may provide multiple iterators via its interface that provide items in different orders, such as forwards ...
.


Dynamic sets

Dynamic set structures typically add: * create(): creates a new, initially empty set structure. ** create_with_capacity(''n''): creates a new set structure, initially empty but capable of holding up to ''n'' elements. * add(''S'',''x''): adds the element ''x'' to ''S'', if it is not present already. * remove(''S'', ''x''): removes the element ''x'' from ''S'', if it is present. * capacity(''S''): returns the maximum number of values that ''S'' can hold. Some set structures may allow only some of these operations. The cost of each operation will depend on the implementation, and possibly also on the particular values stored in the set, and the order in which they are inserted.


Additional operations

There are many other operations that can (in principle) be defined in terms of the above, such as: * pop(''S''): returns an arbitrary element of ''S'', deleting it from ''S''. * pick(''S''): returns an arbitrary element of ''S''. Functionally, the mutator pop can be interpreted as the pair of selectors (pick, rest), where rest returns the set consisting of all elements except for the arbitrary element. Can be interpreted in terms of iterate. *
map A map is a symbolic depiction of interrelationships, commonly spatial, between things within a space. A map may be annotated with text and graphics. Like any graphic, a map may be fixed to paper or other durable media, or may be displayed on ...
(''F'',''S'')
: returns the set of distinct values resulting from applying function ''F'' to each element of ''S''. * filter(''P'',''S''): returns the subset containing all elements of ''S'' that satisfy a given predicate ''P''. * fold(''A''0,''F'',''S''): returns the value ''A'', ''S'', after applying ''A''i+1 := ''F''(''Ai'', ''e'') for each element ''e'' of ''S,'' for some binary operation ''F.'' ''F'' must be associative and commutative for this to be well-defined. * clear(''S''): delete all elements of ''S''. * equal(''S''1', ''S''2'): checks whether the two given sets are equal (i.e. contain all and only the same elements). * hash(''S''): returns a
hash value A hash function is any function that can be used to map data of arbitrary size to fixed-size values, though there are some hash functions that support variable-length output. The values returned by a hash function are called ''hash values'', ...
for the static set ''S'' such that if equal(''S''1, ''S''2) then hash(''S1'') = hash(''S2'') Other operations can be defined for sets with elements of a special type: * sum(''S''): returns the sum of all elements of ''S'' for some definition of "sum". For example, over integers or reals, it may be defined as fold(0, add, ''S''). * collapse(''S''): given a set of sets, return the union. For example, collapse()

. May be considered a kind of sum. * flatten(''S''): given a set consisting of sets and atomic elements (elements that are not sets), returns a set whose elements are the atomic elements of the original top-level set or elements of the sets it contains. In other words, remove a level of nesting – like collapse, but allow atoms. This can be done a single time, or recursively flattening to obtain a set of only atomic elements. For example, flatten()

. * nearest(''S'',''x''): returns the element of ''S'' that is closest in value to ''x'' (by some
metric Metric or metrical may refer to: Measuring * Metric system, an internationally adopted decimal system of measurement * An adjective indicating relation to measurement in general, or a noun describing a specific type of measurement Mathematics ...
). * min(''S''), max(''S''): returns the minimum/maximum element of ''S''.


Implementations

Sets can be implemented using various
data structure In computer science, a data structure is a data organization and storage format that is usually chosen for Efficiency, efficient Data access, access to data. More precisely, a data structure is a collection of data values, the relationships amo ...
s, which provide different time and space trade-offs for various operations. Some implementations are designed to improve the efficiency of very specialized operations, such as nearest or union. Implementations described as "general use" typically strive to optimize the element_of, add, and delete operations. A simple implementation is to use a
list A list is a Set (mathematics), set of discrete items of information collected and set forth in some format for utility, entertainment, or other purposes. A list may be memorialized in any number of ways, including existing only in the mind of t ...
, ignoring the order of the elements and taking care to avoid repeated values. This is simple but inefficient, as operations like set membership or element deletion are ''O''(''n''), as they require scanning the entire list. Sets are often instead implemented using more efficient data structures, particularly various flavors of
trees In botany, a tree is a perennial plant with an elongated stem, or trunk, usually supporting branches and leaves. In some usages, the definition of a tree may be narrower, e.g., including only woody plants with secondary growth, only p ...
,
trie In computer science, a trie (, ), also known as a digital tree or prefix tree, is a specialized search tree data structure used to store and retrieve strings from a dictionary or set. Unlike a binary search tree, nodes in a trie do not store t ...
s, or
hash tables In computer science, a hash table is a data structure that implements an associative array, also called a dictionary or simply map; an associative array is an abstract data type that maps Unique key, keys to Value (computer science), values. ...
. As sets can be interpreted as a kind of map (by the indicator function), sets are commonly implemented in the same way as (partial) maps (
associative array In computer science, an associative array, key-value store, map, symbol table, or dictionary is an abstract data type that stores a collection of (key, value) pairs, such that each possible key appears at most once in the collection. In math ...
s) – in this case in which the value of each key-value pair has the
unit type In the area of mathematical logic and computer science known as type theory, a unit type is a type that allows only one value (and thus can hold no information). The carrier (underlying set) associated with a unit type can be any singleton set. ...
or a sentinel value (like 1) – namely, a
self-balancing binary search tree In computer science, a self-balancing binary search tree (BST) is any node-based binary search tree that automatically keeps its height (maximal number of levels below the root) small in the face of arbitrary item insertions and deletions.Donald ...
for sorted sets (which has O(log n) for most operations), or a
hash table In computer science, a hash table is a data structure that implements an associative array, also called a dictionary or simply map; an associative array is an abstract data type that maps Unique key, keys to Value (computer science), values. ...
for unsorted sets (which has O(1) average-case, but O(n) worst-case, for most operations). A sorted linear hash table may be used to provide deterministically ordered sets. Further, in languages that support maps but not sets, sets can be implemented in terms of maps. For example, a common
programming idiom In computer programming, a programming idiom, code idiom or simply idiom is a code fragment having a semantic role which recurs frequently across software projects. It often expresses a special feature of a recurring construct in one or more pro ...
in
Perl Perl is a high-level, general-purpose, interpreted, dynamic programming language. Though Perl is not officially an acronym, there are various backronyms in use, including "Practical Extraction and Reporting Language". Perl was developed ...
that converts an array to a hash whose values are the sentinel value 1, for use as a set, is: my %elements = map @elements; Other popular methods include
arrays An array is a systematic arrangement of similar objects, usually in rows and columns. Things called an array include: {{TOC right Music * In twelve-tone and serial composition, the presentation of simultaneous twelve-tone sets such that the ...
. In particular a subset of the integers 1..''n'' can be implemented efficiently as an ''n''-bit
bit array A bit array (also known as bitmask, bit map, bit set, bit string, or bit vector) is an array data structure that compactly stores bits. It can be used to implement a simple set data structure. A bit array is effective at exploiting bit-level par ...
, which also support very efficient union and intersection operations. A Bloom map implements a set probabilistically, using a very compact representation but risking a small chance of false positives on queries. The Boolean set operations can be implemented in terms of more elementary operations (pop, clear, and add), but specialized algorithms may yield lower asymptotic time bounds. If sets are implemented as sorted lists, for example, the naive algorithm for union(''S'',''T'') will take time proportional to the length ''m'' of ''S'' times the length ''n'' of ''T''; whereas a variant of the list merging algorithm will do the job in time proportional to ''m''+''n''. Moreover, there are specialized set data structures (such as the union-find data structure) that are optimized for one or more of these operations, at the expense of others.


Language support

One of the earliest languages to support sets was Pascal; many languages now include it, whether in the core language or in a
standard library In computer programming, a standard library is the library (computing), library made available across Programming language implementation, implementations of a programming language. Often, a standard library is specified by its associated program ...
. * In C++, the
Standard Template Library The Standard Template Library (STL) is a software library originally designed by Alexander Stepanov for the C++ programming language that influenced many parts of the C++ Standard Library. It provides four components called ''algorithms'', '' ...
(STL) provides the
set Set, The Set, SET or SETS may refer to: Science, technology, and mathematics Mathematics *Set (mathematics), a collection of elements *Category of sets, the category whose objects and morphisms are sets and total functions, respectively Electro ...
template class, which is typically implemented using a binary search tree (e.g. red–black tree); SGI's STL also provides the hash_set template class, which implements a set using a hash table.
C++11 C++11 is a version of a joint technical standard, ISO/IEC 14882, by the International Organization for Standardization (ISO) and International Electrotechnical Commission (IEC), for the C++ programming language. C++11 replaced the prior vers ...
has support for the unordered_set template class, which is implemented using a hash table. In sets, the elements themselves are the keys, in contrast to sequenced containers, where elements are accessed using their (relative or absolute) position. Set elements must have a strict weak ordering. * The
Rust Rust is an iron oxide, a usually reddish-brown oxide formed by the reaction of iron and oxygen in the catalytic presence of water or air moisture. Rust consists of hydrous iron(III) oxides (Fe2O3·nH2O) and iron(III) oxide-hydroxide (FeO(OH) ...
standard library provides the generic HashSet
/code> and
/code> types. *
Java Java is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea (a part of Pacific Ocean) to the north. With a population of 156.9 million people (including Madura) in mid 2024, proje ...
offers the interface to support sets (with the class implementing it using a hash table), and the sub-interface to support sorted sets (with the class implementing it using a binary search tree). *
Apple An apple is a round, edible fruit produced by an apple tree (''Malus'' spp.). Fruit trees of the orchard or domestic apple (''Malus domestica''), the most widely grown in the genus, are agriculture, cultivated worldwide. The tree originated ...
's Foundation framework (part of Cocoa) provides the
Objective-C Objective-C is a high-level general-purpose, object-oriented programming language that adds Smalltalk-style message passing (messaging) to the C programming language. Originally developed by Brad Cox and Tom Love in the early 1980s, it was ...
classes NSSet
/code>, NSMutableSet
/code>, NSCountedSet
/code>,
/code>, and
/code>. The CoreFoundation APIs provide th
CFSet
an
CFMutableSet
types for use in C. * Python has built-i
set and frozenset types
since 2.4, and since Python 3.0 and 2.7, supports non-empty set literals using a curly-bracket syntax, e.g.: ; empty sets must be created using set(), because Python uses to represent the empty dictionary. * The .NET Framework provides the generic HashSet
/code> and SortedSet
/code> classes that implement the generic ISet
/code> interface. *
Smalltalk Smalltalk is a purely object oriented programming language (OOP) that was originally created in the 1970s for educational use, specifically for constructionist learning, but later found use in business. It was created at Xerox PARC by Learni ...
's class library includes Set and IdentitySet, using equality and identity for inclusion test respectively. Many dialects provide variations for compressed storage (NumberSet, CharacterSet), for ordering (OrderedSet, SortedSet, etc.) or for weak references (WeakIdentitySet). *
Ruby Ruby is a pinkish-red-to-blood-red-colored gemstone, a variety of the mineral corundum ( aluminium oxide). Ruby is one of the most popular traditional jewelry gems and is very durable. Other varieties of gem-quality corundum are called sapph ...
's standard library includes a set
/code> module which contains Set and SortedSet classes that implement sets using hash tables, the latter allowing iteration in sorted order. *
OCaml OCaml ( , formerly Objective Caml) is a General-purpose programming language, general-purpose, High-level programming language, high-level, Comparison of multi-paradigm programming languages, multi-paradigm programming language which extends the ...
's standard library contains a Set module, which implements a functional set data structure using binary search trees. * The GHC implementation of
Haskell Haskell () is a general-purpose, statically typed, purely functional programming language with type inference and lazy evaluation. Designed for teaching, research, and industrial applications, Haskell pioneered several programming language ...
provides a Data.Set
/code> module, which implements immutable sets using binary search trees. * The
Tcl TCL or Tcl or TCLs may refer to: Business * TCL Technology, a Chinese consumer electronics and appliance company ** TCL Electronics, a subsidiary of TCL Technology * Texas Collegiate League, a collegiate baseball league * Trade Centre Limited ...
Tcllib package provides a set module which implements a set data structure based upon TCL lists. * The
Swift Swift or SWIFT most commonly refers to: * SWIFT, an international organization facilitating transactions between banks ** SWIFT code * Swift (programming language) * Swift (bird), a family of birds It may also refer to: Organizations * SWIF ...
standard library contains a Set type, since Swift 1.2. *
JavaScript JavaScript (), often abbreviated as JS, is a programming language and core technology of the World Wide Web, alongside HTML and CSS. Ninety-nine percent of websites use JavaScript on the client side for webpage behavior. Web browsers have ...
introduced Set
/code> as a standard built-in object with the ECMAScript 2015 standard. * Erlang's standard library has a sets
/code> module. *
Clojure Clojure (, like ''closure'') is a dynamic programming language, dynamic and functional programming, functional dialect (computing), dialect of the programming language Lisp (programming language), Lisp on the Java (software platform), Java platfo ...
has literal syntax for hashed sets, and also implements sorted sets. * LabVIEW has native support for sets, from version 2019. * Ada provides the Ada.Containers.Hashed_Sets
/code> and
/code> packages. As noted in the previous section, in languages which do not directly support sets but do support
associative array In computer science, an associative array, key-value store, map, symbol table, or dictionary is an abstract data type that stores a collection of (key, value) pairs, such that each possible key appears at most once in the collection. In math ...
s, sets can be emulated using associative arrays, by using the elements as keys, and using a dummy value as the values, which are ignored.


Multiset

A generalization of the notion of a set is that of a
multiset In mathematics, a multiset (or bag, or mset) is a modification of the concept of a set that, unlike a set, allows for multiple instances for each of its elements. The number of instances given for each element is called the ''multiplicity'' of ...
or bag, which is similar to a set but allows repeated ("equal") values (duplicates). This is used in two distinct senses: either equal values are considered ''identical,'' and are simply counted, or equal values are considered ''equivalent,'' and are stored as distinct items. For example, given a list of people (by name) and ages (in years), one could construct a multiset of ages, which simply counts the number of people of a given age. Alternatively, one can construct a multiset of people, where two people are considered equivalent if their ages are the same (but may be different people and have different names), in which case each pair (name, age) must be stored, and selecting on a given age gives all the people of a given age. Formally, it is possible for objects in computer science to be considered "equal" under some
equivalence relation In mathematics, an equivalence relation is a binary relation that is reflexive, symmetric, and transitive. The equipollence relation between line segments in geometry is a common example of an equivalence relation. A simpler example is equ ...
but still distinct under another relation. Some types of multiset implementations will store distinct equal objects as separate items in the data structure; while others will collapse it down to one version (the first one encountered) and keep a positive integer count of the multiplicity of the element. As with sets, multisets can naturally be implemented using hash table or trees, which yield different performance characteristics. The set of all bags over type T is given by the expression bag T. If by multiset one considers equal items identical and simply counts them, then a multiset can be interpreted as a function from the input domain to the non-negative integers (
natural number In mathematics, the natural numbers are the numbers 0, 1, 2, 3, and so on, possibly excluding 0. Some start counting with 0, defining the natural numbers as the non-negative integers , while others start with 1, defining them as the positive in ...
s), generalizing the identification of a set with its indicator function. In some cases a multiset in this counting sense may be generalized to allow negative values, as in Python. * C++'s
Standard Template Library The Standard Template Library (STL) is a software library originally designed by Alexander Stepanov for the C++ programming language that influenced many parts of the C++ Standard Library. It provides four components called ''algorithms'', '' ...
implements both sorted and unsorted multisets. It provides the
multiset In mathematics, a multiset (or bag, or mset) is a modification of the concept of a set that, unlike a set, allows for multiple instances for each of its elements. The number of instances given for each element is called the ''multiplicity'' of ...
class for the sorted multiset, as a kind of associative container, which implements this multiset using a
self-balancing binary search tree In computer science, a self-balancing binary search tree (BST) is any node-based binary search tree that automatically keeps its height (maximal number of levels below the root) small in the face of arbitrary item insertions and deletions.Donald ...
. It provides the unordered_multiset class for the unsorted multiset, as a kind of unordered associative container, which implements this multiset using a
hash table In computer science, a hash table is a data structure that implements an associative array, also called a dictionary or simply map; an associative array is an abstract data type that maps Unique key, keys to Value (computer science), values. ...
. The unsorted multiset is standard as of
C++11 C++11 is a version of a joint technical standard, ISO/IEC 14882, by the International Organization for Standardization (ISO) and International Electrotechnical Commission (IEC), for the C++ programming language. C++11 replaced the prior vers ...
; previously SGI's STL provides the hash_multiset class, which was copied and eventually standardized. * For
Java Java is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea (a part of Pacific Ocean) to the north. With a population of 156.9 million people (including Madura) in mid 2024, proje ...
, third-party libraries provide multiset functionality: **
Apache Commons The Apache Commons is a project of the Apache Software Foundation, formerly under the Jakarta Project. The purpose of the Commons is to provide reusable, Open-source software, open source Java (software platform), Java software. The Commons is compo ...
Collections provides the Bag
/code> and SortedBag interfaces, with implementing classes like HashBag and TreeBag. **
Google Guava Google Guava is an open-source set of common libraries for Java, mainly developed by Google engineers. Overview Google Guava can be roughly divided into three components: basic utilities to reduce manual labor to implement common methods and b ...
provides the Multiset
/code> interface, with implementing classes like
/code> and
/code>. * Apple provides the NSCountedSet
/code> class as part of Cocoa, and the CFBag
/code> and CFMutableBag
/code> types as part of CoreFoundation. * Python's standard library includes collections.Counter
/code>, which is similar to a multiset. *
Smalltalk Smalltalk is a purely object oriented programming language (OOP) that was originally created in the 1970s for educational use, specifically for constructionist learning, but later found use in business. It was created at Xerox PARC by Learni ...
includes the Bag class, which can be instantiated to use either identity or equality as predicate for inclusion test. Where a multiset data structure is not available, a workaround is to use a regular set, but override the equality predicate of its items to always return "not equal" on distinct objects (however, such will still not be able to store multiple occurrences of the same object) or use an
associative array In computer science, an associative array, key-value store, map, symbol table, or dictionary is an abstract data type that stores a collection of (key, value) pairs, such that each possible key appears at most once in the collection. In math ...
mapping the values to their integer multiplicities (this will not be able to distinguish between equal elements at all). Typical operations on bags: * contains(''B'', ''x''): checks whether the element ''x'' is present (at least once) in the bag ''B'' * is_sub_bag(''B''1, ''B''2): checks whether each element in the bag ''B''1 occurs in ''B''1 no more often than it occurs in the bag ''B''2; sometimes denoted as ''B''1 ⊑ ''B''2. * count(''B'', ''x''): returns the number of times that the element ''x'' occurs in the bag ''B''; sometimes denoted as ''B'' # ''x''. * scaled_by(''B'', ''n''): given a
natural number In mathematics, the natural numbers are the numbers 0, 1, 2, 3, and so on, possibly excluding 0. Some start counting with 0, defining the natural numbers as the non-negative integers , while others start with 1, defining them as the positive in ...
''n'', returns a bag which contains the same elements as the bag ''B'', except that every element that occurs ''m'' times in ''B'' occurs ''n'' * ''m'' times in the resulting bag; sometimes denoted as ''n'' ⊗ ''B''. * union(''B''1, ''B''2): returns a bag containing just those values that occur in either the bag ''B''1 or the bag ''B''2, except that the number of times a value ''x'' occurs in the resulting bag is equal to (''B''1 # x) + (''B''2 # x); sometimes denoted as ''B''1 ⊎ ''B''2.


Multisets in SQL

In
relational databases A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured form ...
, a table can be a (mathematical) set or a multiset, depending on the presence of unicity constraints on some columns (which turns it into a
candidate key A candidate key, or simply a key, of a relational database is any set of columns that have a unique combination of values in each row, with the additional constraint that removing any column could produce duplicate combinations of values. A candi ...
).
SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...
allows the selection of rows from a relational table: this operation will in general yield a multiset, unless the keyword DISTINCT is used to force the rows to be all different, or the selection includes the primary (or a candidate) key. In ANSI SQL the MULTISET keyword can be used to transform a subquery into a collection expression: SELECT expression1, expression2... FROM table_name... is a general select that can be used as '' subquery expression'' of another more general query, while MULTISET(SELECT expression1, expression2... FROM table_name...) transforms the subquery into a '' collection expression'' that can be used in another query, or in assignment to a column of appropriate collection type.


See also

*
Bloom filter In computing, a Bloom filter is a space-efficient probabilistic data structure, conceived by Burton Howard Bloom in 1970, that is used to test whether an element is a member of a set. False positive matches are possible, but false negatives ar ...
* Disjoint set *
Set (mathematics) In mathematics, a set is a collection of different things; the things are '' elements'' or ''members'' of the set and are typically mathematical objects: numbers, symbols, points in space, lines, other geometric shapes, variables, or other se ...


Notes


References

{{Data structures Data types Composite data types Abstract data types Articles with example Python (programming language) code