📚 Databases | 数据库
In science, the ability to collect, store, and retrieve data accurately is just as important as the experiment itself. Whether you are tracking plant growth, monitoring reaction rates, or cataloguing thousands of astronomical observations, a well-structured database makes information manageable, searchable, and meaningful. This article explores the core concepts of databases and how they are applied in scientific contexts, aligned with the way data handling appears across the IGCSE sciences.
在科学中，准确收集、存储和检索数据的能力与实验本身同样重要。无论你是在追踪植物生长、监测反应速率，还是编录成千上万的天文观测记录，一个结构良好的数据库都能使信息变得便于管理、搜索且有意义。本文将探讨数据库的核心概念，以及它们如何在科学场景中得到应用，这与 IGCSE 科学各科目中数据处理的方式是一致的。
1. What is a Database? | 什么是数据库？
A database is an organised collection of data, generally stored and accessed electronically from a computer system. It allows data to be easily entered, updated, queried, and analysed. In a science laboratory, a database could hold results from dozens of trials so that trends can be spotted without leafing through pages of a notebook.
数据库是一种有组织的数据集合，通常以电子方式存储在计算机系统中并供访问。它使得数据能够方便地输入、更新、查询和分析。在一间科学实验室里，一个数据库可以保存数十次试验的结果，这样无需翻阅笔记本就可以发现趋势。
Databases can be as simple as a single table in a spreadsheet, or as complex as a multi-user relational system managing millions of records. The key is that the data is structured, rather than existing as random notes.
数据库可以像电子表格中的单张工作表一样简单，也可以是管理着数百万条记录的多用户关系型系统。关键在于数据是结构化的，而不是以零散的笔记形式存在。
2. Key Database Terminology | 关键数据库术语
Before diving deeper, it is helpful to understand the basic building blocks: a table (also called a relation) holds data about one type of entity. A field is a single piece of information, such as temperature or mass. A record is a complete set of fields about one item – for example, all the data from one experimental run. A value is the actual datum entered into a field.
在深入之前，先了解一些基本构件很有帮助：表（也称为关系）用于存放关于某一类实体的数据。字段是单条信息，如温度或质量。记录是关于某一项事物的完整字段集合——例如，一次实验运行的所有数据。值则是录入字段的实际数据。
In a science class database, you might have a table called Experiments. Fields could include ExperimentID, Date, Substance, InitialMass_g, FinalMass_g, and ReactionTime_s. Each row would be a record of one particular trial.
在科学课数据库中，你可能有一个名为 Experiments 的表。字段可以包括 ExperimentID、Date、Substance、InitialMass_g、FinalMass_g 和 ReactionTime_s。每一行就是一次特定试验的记录。
3. Tables, Records and Fields in a Scientific Database | 科学数据库中的表、记录与字段
Imagine you are investigating how the concentration of an acid affects the volume of gas produced. Each time you alter the concentration, you perform a new trial. All of these trials belong in one table, because they share the same attributes. A well-designed table keeps observations uniform, so you can compare results fairly.
假设你正在研究酸的浓度如何影响产生气体的体积。每当你改变浓度，你就进行一次新的试验。所有这些试验都属于同一张表，因为它们共享相同的属性。设计良好的表能使观察记录保持统一，以便你公平地比较结果。
Fields must be given clear, self-explanatory names. Instead of using a vague heading like ‘Result1’, a scientist would label a field VolumeOfGas_cm3. Including units in the field name helps avoid confusion later, especially when data is shared among researchers.
字段必须被赋予清晰的、自明的名称。科学家不会使用像“Result1”这样模糊的标题，而是会将字段标注为 VolumeOfGas_cm3。在字段名称中包含单位有助于之后避免混淆，特别是当数据在研究人员之间共享时。
4. Data Types and Their Importance | 数据类型及其重要性
Each field in a database has a defined data type, such as text, number, date/time, or boolean (yes/no). Applying the correct data type ensures that only sensible data can be entered. For example, a field that stores temperature should be set to number, not text, preventing someone from typing ‘warm’ instead of 35.5.
数据库中的每个字段都有一个定义好的数据类型，如文本、数字、日期/时间或布尔型（是/否）。使用正确的数据类型能确保只能输入合理的数据。例如，存储温度的字段应设为数字型而非文本型，这样可以防止有人输入“warm”而不是 35.5。
Common data types in science databases include Integer for counts (e.g. number of bubbles), Real/Float for measurements with decimal places (e.g. mass, time), Date/Time for recording when an observation was made, and Text/String for labels like the name of a chemical.
科学数据库中常见的数据类型包括用于计数的整型（如气泡数量），用于带小数位的测量值的实型/浮点型（如质量、时间），用于记录观察时间的日期/时间型，以及用于如化学品名称等标签的文本/字符串型。
5. Primary Keys and Relationships | 主键与关系
A primary key is a field (or combination of fields) that uniquely identifies each record in a table. No two records share the same primary key value. In the Experiments table, the ExperimentID field might be an auto-incrementing integer that serves this role. Primary keys are essential for linking tables together in a relational database.
主键是一个（或一组）能够唯一标识表中每条记录的字段。没有两条记录会共享同一个主键值。在 Experiments 表中，ExperimentID 字段可以是一个自动递增的整数，并充当这一角色。主键对于在关系型数据库中将多张表关联起来至关重要。
Consider a database that also tracks the scientists performing the experiments. Instead of repeating each scientist’s name and details in every experiment record, you can have a separate Scientists table with its own primary key. The Experiments table then stores only a ScientistID as a foreign key, creating a relationship. This reduces duplication and errors.
设想有一个数据库同时也要追踪执行实验的科学家。与其在每条实验记录中重复每位科学家的姓名和详细信息，你可以设立一个独立的 Scientists 表，并带有其自己的主键。然后，Experiments 表只需存储一个 ScientistID 作为外键，这样就建立起了关系。这减少了数据重复和错误。
6. Data Validation and Verification | 数据验证与核实
Validation checks that the data entered matches the rules set for the field. Examples include range checks (e.g. pH must be between 0 and 14), presence checks (a field cannot be left blank), and type checks. Validation happens automatically by the database software and helps trap mistakes at the point of entry.
验证检查所输入的数据是否符合为字段设定的规则。示例包括范围检查（如 pH 值必须在 0 到 14 之间）、存在性检查（字段不能留空）以及类型检查。验证由数据库软件自动执行，有助于在数据录入时捕获错误。
Verification, on the other hand, is about ensuring that the data entered matches the original source. A common method is double entry, where two people independently type the same set of readings, and the system flags mismatches. In science, verification is crucial when transcribing handwritten observations into a digital database.
另一方面，核实是要确保输入的数据与原始来源相符。一种常见的方法是双重录入，即两个人各自独立地键入同一组读数，系统会对不一致之处加以标记。在科学中，当把手工记录的观察转录到数字数据库中时，核实是至关重要的。
7. Querying a Scientific Database | 查询科学数据库
A query is a request for specific information from a database. For instance, you may wish to retrieve all experiments where the final temperature exceeded 80°C and the catalyst was ‘manganese dioxide’. A query extracts these records instantly, allowing you to focus on analysis rather than searching.
查询是对数据库中特定信息的一种请求。例如，你可能希望检索所有最终温度超过 80 °C 且催化剂为“二氧化锰”的实验记录。查询能即时提取出这些记录，使你能够专注于分析，而非查找。
Queries can be built using a graphical interface (such as query-by-example) or by using a language like SQL. A simple SQL statement might be: SELECT * FROM Experiments WHERE Catalyst = 'MnO2' AND FinalTemp > 80;. This filtering capability is invaluable when dealing with large datasets from numerous trials.
查询可以通过图形界面（例如示例查询）或使用 SQL 这样的语言来构建。一条简单的 SQL 语句可能是：SELECT * FROM Experiments WHERE Catalyst = 'MnO2' AND FinalTemp > 80;。在处理来自大量试验的海量数据集时，这种筛选能力是极其宝贵的。
8. Databases in Research and Collaboration | 研究与合作中的数据库
Modern science relies heavily on databases that are shared among institutions. GenBank stores DNA sequences, the Protein Data Bank holds 3D structures of molecules, and climate databases archive decades of temperature readings. Students should recognise that the principle of one central repository accessed by many scientists avoids duplication of effort and improves the reliability of findings.
现代科学高度依赖在各个机构间共享的数据库。GenBank 存储了 DNA 序列，蛋白质数据库保存着分子的三维结构，而气候数据库则归档了数十年的温度读数。学生们应当认识到，由一个中央存储库供众多科学家访问的原则，避免了重复劳动并提高了研究结果的可靠性。
When contributing data to such a repository, standardisation of field names, units, and formats becomes critical. This is why international scientific bodies agree on conventions – so that a biologist in Japan can readily use data collected in Brazil without confusion.
当向此类存储库存入数据时，字段名称、单位和格式的标准化就变得至关重要。这就是为什么国际科学机构会就各种公约达成一致——如此，一位日本的生物学家便可毫无混淆地直接使用在巴西收集的数据。
9. Advantages of a Database over Paper Records | 数据库相较于纸质记录的优点
Paper notebooks are prone to physical damage, illegible handwriting, and are difficult to search. A database, however, offers speed, security, and scalability. Backups preserve data against loss, and passwords restrict access to authorised users. Furthermore, calculations and summaries (such as mean and standard deviation) can be generated automatically from the stored data.
纸质笔记容易遭受物理损坏、字迹潦草，且难以搜索。而数据库则提供了速度、安全性和可扩展性。备份可防止数据丢失，密码则会将访问限制在授权用户范围内。此外，可以根据存储的数据自动生成计算和摘要（如平均值和标准差）。
The ability to run complex queries across thousands of records within seconds means that scientists can test hypotheses more quickly. This is particularly beneficial in longitudinal studies, where data accumulates over many years.
能在数秒内对数千条记录执行复杂查询的能力，意味着科学家可以更快地检验假设。这在需要经年累月积累数据的纵向研究中尤其有益。
10. Common Database Management Systems | 常见的数据库管理系统
Familiarity with database software can begin with simple tools like Microsoft Access, which is often used in schools to introduce tables, queries, and forms. More powerful systems include open-source solutions such as MySQL, PostgreSQL, and web-based databases that support scientific research platforms.
对数据库软件的熟悉可以从简单的工具开始，例如 Microsoft Access，学校里常用它来介绍表、查询和窗体。更强大的系统包括开源解决方案，如 MySQL、PostgreSQL，以及支持科学研究平台的基于网络的数据库。
Even spreadsheet applications like Excel can manage flat-file databases for small projects, although they lack the robust relational features and multi-user capabilities of a true database management system. IGCSE-level science investigations are often adequately served by such simpler structures, provided they are designed thoughtfully.
即使是像 Excel 这样的电子表格应用程序，也可以为小型项目管理平面文件数据库，尽管它们缺少真正数据库管理系统的稳健关系特性和多用户能力。只要经过深思熟虑的设计，IGCSE 级别的科学探究通常用这样简单的结构就足够了。
11. Designing a Simple Database for a Lab Investigation | 为一个实验室探究设计简单的数据库
Suppose you are conducting an experiment on the effect of light intensity on the rate of photosynthesis, measured by the number of oxygen bubbles released per minute. A possible table structure could follow this plan:
假设你正在进行一项关于光照强度对光合作用速率影响的实验，速率通过每分钟释放的氧气泡数量来测量。一个可能的表结构可以遵循如下规划：
| Field Name | Data Type | Description |
|---|---|---|
| TrialID | Integer (PK) | Unique identifier for each trial |
| LightIntensity_lux | Real | Light intensity measured in lux |
| BubbleCount | Integer | Number of oxygen bubbles per minute |
| ElodeaMass_g | Real | Mass of the pondweed used |
| WaterTemp_C | Real | Water temperature in degrees Celsius |
With such a structure, you can later query, for example, the average bubble count for each light intensity level, or verify whether the temperature remained constant across trials. This table can be created in any spreadsheet or database programme.
有了这样的结构，你之后就可以查询每个光照强度级别的平均气泡数，或者核实各个试验期间温度是否保持恒定。这张表可以在任何电子表格或数据库程序中创建。
12. Best Practices for Recording and Handling Data | 记录与处理数据的最佳实践
Always include a unique identifier for each record. Keep a backup copy of your database, especially during a long-term investigation. Choose meaningful field names and apply validation rules wherever feasible. Regularly review your data for outliers, but do not delete them unless you are certain they arise from error; they can be flagged in a separate column instead.
始终为每条记录包含一个唯一标识符。保存数据库的备份副本，尤其是在长期探究期间。选择有意义的字段名称，并在可行处应用验证规则。定期检查数据是否有异常值，但除非你确定它们是由错误引起的，否则不要删除；可以将它们标记在一个单独的列中。
When collaborating, agree on standard units and naming conventions beforehand. These habits, instilled during IGCSE work, build the foundation for ethical, reproducible research in the future.
在合作时，应事先约定标准单位和命名规约。这些在 IGCSE 学习期间养成的习惯，将为未来合乎伦理、可复现的研究奠定基础。
Published by TutorHao | Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图