First class (computing)

First class (computing)

In database modeling, a first class item is one that has an identity independent of any other item. The identity allows the item to persist when its attributes change, and other items to claim relationships with the item.

As a general rule, first class items represent things rather than relationships. For example, the database representations of a human and of a company are each first class items. However, the fact that the person is an employee of that company is not, nor is data "about" that relationship, e.g. information about the salary the company pays to its employee.

Typically, a relational database will include several tables, each of which contains rows representing first class items of a given type (e.g. a table of people, a table of companies). It will also contain other tables representing relationships between these first class items.

In a table representing first class items, one column of the table will typically contain a different integer assigned to each row (effectively, to each item) as a unique identifier: that is to say, unique for objects of this type; objects of different types, represented in different tables, can coincidentally have the same identifier, but the coincidence is meaningless.

In a relational database, a table representing a "relationship" between two or more first class items (or data about that relationship) will usually "not" have special identifiers for its rows. Instead these rows will be identified by an ordered tuple consisting of unique identifiers of the first class items involved in the relationship.


Wikimedia Foundation. 2010.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • First class — The term First class (or 1st class, Firstclass) generally implies a high level of service, importance or quality. Specific uses of the term include:* First class travel ** First class (aviation) * First Class mail * First class cricket * First… …   Wikipedia

  • First-class object — In computing, a first class object (also value, entity, and citizen), in the context of a particular programming language, is an entity which can be used in programs without restriction (when compared to other kinds of objects in the same… …   Wikipedia

  • First-move advantage in chess — The first move advantage in chess refers to the inherent advantage of the player (called White) who makes the first move in chess. Chess players and theorists generally agree that White begins the game with some advantage. Statistics compiled… …   Wikipedia

  • Concurrent computing — Programming paradigms Agent oriented Automata based Component based Flow based Pipelined Concatenative Concurrent c …   Wikipedia

  • Data Intensive Computing — is a class of parallel computing applications which use a data parallel approach to processing large volumes of data typically terabytes or petabytes in size and typically referred to as Big Data. Computing applications which devote most of their …   Wikipedia

  • Arleigh Burke class destroyer — USS Arleigh Burke (DDG 51), lead ship of the class Class overview Name: Arleigh Burke class destroyer …   Wikipedia

  • DNA computing — is a form of computing which uses DNA, biochemistry and molecular biology, instead of the traditional silicon based computer technologies. DNA computing, or, more generally, biomolecular computing, is a fast developing interdisciplinary area.… …   Wikipedia

  • Bachelor of Computing and Financial Management — is one of the newest programs at the University of Waterloo created in 2006. Jointly offered by the School of Accountancy in the Faculty of Arts and the David R. Cheriton School of Computer Science in the Faculty of Math, these students take… …   Wikipedia

  • History of computing hardware — Computing hardware is a platform for information processing (block diagram) The history of computing hardware is the record of the ongoing effort to make computer hardware faster, cheaper, and capable of storing more data. Computing hardware… …   Wikipedia

  • Parallel computing — Programming paradigms Agent oriented Automata based Component based Flow based Pipelined Concatenative Concurrent computing …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”