Dedicated vocabulary for database systems (1)

Some specialized vocabulary of the database system:

1. Data ):

Symbols that reflect the facts of the objective world and distinguish their characteristics: characters, numbers, texts, sounds, figures, images, charts, pictures, etc., which exist objectively in the real world, which can be input to the computer for storage and management.

2. Information ):

Data that is processed and extracted from raw data and used to determine behaviors, plans, or have certain semantics is called information.

3. database (Data Base ):

It is a collection of highly correlated data and relationships in the real world.

4. Database Management System (DBMS ):

Is a software system that stores and manages data in databases. It includes various languages and tools for storing, managing, retrieving, and controlling data in databases. It is a set of system software.

5. Database System DBS (Data Base System ):

Is a general term for database and database management systems. It refers to a collection of associated data and a collection of software tools that manipulate data. DBS = DB + DBMS

6. Application Programming Interface ):

It is an interface function, process, or language provided by DBMS for developing applications to manipulate and access data in the database.

7. Database Application AP (Application Program ):

A program that allows users to manipulate and access databases.

8. Data Warehouse)

A data warehouse is a commercial application system with built-in databases. Use existing data resources to convert data into information, extract knowledge from it, extract it into wisdom, and create benefits.

9. Data Mining)

Data mining can help commercial users process a large amount of existing data in order to discover "unexpected relationships" to increase market share and profit.

10. Information Mining ):

Information Mining refers to discovering relevant information in the vast ocean of documents, maps, photos, sounds and images, that is, content-oriented retrieval.

11. Data Model ):

In a database, the description of data (entity) is called the database mode. It is described in the corresponding Schema Definition Language.

12. Data Model ):

It is a digital simulation and abstraction of real-world features.

13. Field ):

The smallest unit of data in a hierarchical data model, which describes the attributes of an object.

14. Segment (Segment ):

It is the unit of Entity description in the IMS layered data model and a record composed of a field set. It is also the unit in which applications access database data.

15. Data Item ):

It is the smallest data unit in the mesh data model named by DBTG, indicating the attributes of an object.

16. Record ):

It is the unit of Entity description in the mesh data model named by DBTG and an ordered set of data items.

17. Domain ):

The field is a set of values, that is, the value range.

18. Relationship ):

A link is a two-dimensional table with a table name.

19. Tuple ):

A row in a relational table is called a tuples. Tuples can indicate the relationship between an object or an object.

20. attributes ):

A column in a relational table is called an attribute of a link, that is, a data item of a tuples. Attributes include attribute name, attribute type, attribute value range, and attribute value. The attribute name is unique in the table.

21. keywords (Primary Key ):

A single attribute or a combination of several attributes in a table, and its values can uniquely identify a tuples in a link. The keyword attribute cannot be null.

22. External keywords (Forgien Key ):

An Attribute Group that corresponds to a keyword of another link is called an external keyword of the link. The external keyword is null or the key value corresponding to the External table.

23. Network Library ):

A communication software package that packs database requests and results, which are transmitted over the network protocol. Net-Library must be installed on both the client and server.