What is a Projection, in terms of database theory and NHibernate when using SetProjection()?
projection, the mental process by which people attribute to others what is in their own minds. For example, individuals who are in a self-critical state, consciously or unconsciously, may think that other people are critical of them.
Ed, LCSW, projection refers to unconsciously taking unwanted emotions or traits you don't like about yourself and attributing them to someone else. A common example is a cheating spouse who suspects their partner is being unfaithful.
What Is the Purpose of Projection? Sigmund Freud believed projection to be a defense mechanism often used as a way to avoid uncomfortable repressed feelings. Feelings that are projected may be controlling, jealous, angry, or sexual in nature.
Projection is one of the basic operations of Relational Algebra. It takes a relation and a (possibly empty) list of attributes of that relation as input. It outputs a relation containing only the specified list of attributes with duplicate tuples removed. In other words the output must also be a relation.
Example, if the relation R{A,B}, contains three tuples {1,10},{2,10},{3,20} then the projection of R over the attribute list {B} would contain 2 tuples: {10},{20}.
In short, projection is more or less equivalent to SELECT DISTINCT in SQL (excluding cases with nulls and duplicate columns).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With