Some basic concepts in the database __ database

Source: Internet
Author: User

Some important concepts:

① Data: Data is the symbol that describes things. Data is everywhere

② database: The database is where the data is stored. A database is a collection of data and database objects. The so-called database objects are tables, views, stored procedures, triggers, etc.

③ database management System DBMS: A database management system is a computer software used to manage data. The database management system enables users to easily define and manipulate data, maintain data security and integrity, and perform concurrent control and recovery databases under multiple users.


④ Database System DBS: composed of databases, database management systems and users. Broadly speaking, it is composed of computer hardware, operating system, database management system and database application users and maintenance personnel built up under his support.

⑤ Relational Model RM
The relational model is the view that the world is composed of entities and connections
An entity is an object in the real world that has the characteristics or attributes that distinguish it from other things and is associated with other entities. In a relational model, entities are usually represented as tables, each row of a table describes an instance of an entity, and each column of the table describes a feature or attribute of an entity
Contact means the relationship between entities: a pair of one or one pairs, multiple pairs of one

You can use the information of one entity to find information about another entity by contacting
The relational model organizes all the data into a table, which is made up of rows and columns. Rows represent records of data, columns represent fields in records, and tables reflect facts and values in the real world

⑥ relational Database Rdb
Relational database is a database based on relational model
1. Relational database management System RDBMS
Relational database management system is the computer software of managing relational database
2. Keyword key
Keywords are an important concept in the relational model. It's a logical structure, not a physical part of a database.
Candidate Keyword candidate key if an attribute set can uniquely identify a row of a table without extra attributes, the attribute set is called the Candidate keyword

Primary keyword PRIMARY key
The primary key is a candidate keyword that is singled out as the unique identifier for the row of the table. A table has only one primary key, and the primary key can be called a primary key

Common keywords: Common key
In a relational database, relationships are represented by compatible or identical attributes or groups of attributes. If two relationships have compatible or identical attributes or attribute groups, then this property or group of properties is called the Public keyword of the two relationships

External keyword FOREIGN key
If the public key is the primary key in a relationship, then the public keyword becomes an external keyword for another relationship. This shows that the external keyword represents the relationship between two relationships, with another relationship of the external key to the main table of the table, with the addition of keywords table called the Main table from the table, foreign key to become foreign key

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.