为复杂关系数据提供真实的长期归档访问
Providing Authentic Long-term Archival Access to Complex Relational Data
摘要：
我们讨论长期保存和访问关系数据库。重点是国家档案馆和科学数据档案馆，这些档案馆必须从广泛的特定于供应商的关系数据库管理系统（RDBMS）中摄取和整合数据。此外，我们提出了我们的解决方案SIARD分析和提取数据和数据逻辑，从几乎所有的RDBMS。在合理的真实性水平上，它使数据库完全脱离其特定于供应商的环境。用户可以根据可定制的模式添加归档描述性元数据。SIARD数据库档案将数据、数据逻辑、技术元数据和档案描述信息集成在一个档案信息包中，独立于任何特定的软件和硬件，基于纯文本文件和标准化语言SQL和XML。出于使用目的，SIARD存档可以重新加载到任何当前或未来支持标准SQL的RDBMS中。此外，SIARD还包括一个客户端，可“按需”将档案重新载入目标关系数据库管理系统，并可进行多用户远程访问，以便在一个图形用户界面中查询和浏览数据及其技术和描述性元数据。
英文摘要：
We discuss long-term preservation of and access to relational databases. The focus is on national archives and science data archives which have to ingest and integrate data from a broad spectrum of vendor-specific relational database management systems (RDBMS). Furthermore, we present our solution SIARD which analyzes and extracts data and data logic from almost any RDBMS. It enables, to a reasonable level of authenticity, complete detachment of databases from their vendor-specific environment. The user can add archival descriptive metadata according to a customizable schema. A SIARD database archive integrates data, data logic, technical metadata, and archival descriptive information in one archival information package, independent of any specific software and hardware, based upon plain text files and the standardized languages SQL and XML. For usage purposes, a SIARD archive can be reloaded into any current or future RDBMS which supports standard SQL. In addition, SIARD contains a client that enables 'on demand' reload of archives into a target RDBMS, and multi-user remote access for querying and browsing the data together with its technical and descriptive metadata in one graphical user interface.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
