Oracle中英对照（oracle 中英对照）

Oracle: A Comparison of English and Chinese Terms

Oracle is a popular relational database management system (RDBMS) used by businesses worldwide. As with many software programs, Oracle uses specific terms and acronyms that may be unfamiliar to new users. In this article, we will compare the most common Oracle terms in English and Chinese.

Oracle: 甲骨文

Oracle is commonly translated as 甲骨文(jiǎ gǔ wén) in Chinese. This name pays homage to the ancient Chinese characters etched onto turtle shells and ox bones between the 14th and 11th centuries BCE. The famous Chinese calligrapher, Wang Xizhi, also used the term 甲骨文 to describe his own calligraphic style.

Database: 数据库

A database is a collection of data that is organized and stored for easy access and retrieval. In Oracle, databases are created using the CREATE DATABASE statement.

Table: 表格

A table is a collection of data organized into rows and columns. In Oracle, tables are created using the CREATE TABLE statement.

Column: 列

A column is a vertical group of cells in a table that contns data of the same type. In Oracle, columns are specified in the CREATE TABLE statement.

Row: 行

A row is a horizontal group of cells in a table that contns data for each column. In Oracle, rows are inserted using the INSERT INTO statement.

Primary Key: 主键

A primary key is a column or group of columns in a table that uniquely identifies each row. In Oracle, the PRIMARY KEY constrnt is used to designate a column as the primary key.

Foreign Key: 外键

A foreign key is a column or group of columns in one table that refers to the primary key of another table. In Oracle, the FOREIGN KEY constrnt is used to create a relationship between two tables.

Index: 索引

An index is a data structure used to quickly locate data in a table. In Oracle, indexes are created using the CREATE INDEX statement.

Query: 查询

A query is a statement that retrieves data from a table or tables. In Oracle, queries are created using the SELECT statement.

Transaction: 事务

A transaction is a group of SQL statements that are executed as a single unit. In Oracle, transactions are managed using the COMMIT and ROLLBACK statements.

Conclusion:

The above are some commonly used Oracle terms in both English and Chinese. Understanding these terms can help improve communication when working with Oracle, especially when working with international teams. While some of the terminology may be unfamiliar at first, learning the language of Oracle can greatly enhance one’s skillset in database management.