论文部分内容阅读
运用面向对象技术设计了黑河生态水文观测数据库。首先识别实体类和类间关系,然后将类和类间关系映射为表和表间关系。该设计用7个数据表存储观测站、观测点、数采仪、传感器、观测变量间的层次结构,在不修改数据库设计的情况下,能适应该层次结构的动态调整。用单一数据表存储所有观测数据,大大降低了数据操作的复杂性。用PostgreSQL的表继承机制对数据存储方式进行了优化,解决了存储容量和查询速度之间的矛盾。
Using the object-oriented technology, the Heihe Eco-hydrological Observation Database is designed. First identify the relationship between the entity class and the class, and then the relationship between the class and the class is mapped to the relationship between the table and the table. The design uses seven data tables to store the hierarchy between observatories, observation points, data acquisition instruments, sensors and observation variables, and can adapt to the dynamic adjustment of the hierarchy without modifying the database design. Storing all observations with a single data table greatly reduces the complexity of data manipulation. PostgreSQL table inheritance mechanism to optimize the data storage, storage capacity and query speed to resolve the conflict between.