将该用户拥有的所有对象转移到一个临时数据库。
Transfer all the objects that this user owns to a staging database.
转换过程复杂、繁琐,采用脚本解析技术和临时数据库技术完成了转换功能;
The transformation process is complicated and cockamamie, and it based script analysis and temp db technology.
因此当来自临时数据库的信息通过存储过程被转移到数据仓库中时,这个沿袭出现了一个断点。
So when information from the staging database is moved to the data warehouse through stored procedures, there is a gap in the lineage.
介绍用临时数据库的方法绘制报表的思路和程序。它简单实用、便于实现,以供需要的人们相互交流。
The method and procedure of using the temporary database to draw a report is introduced, which is simple, practical, easy to be realized, and may be useful for mutual exchange.
(译文:VACUUM命令通过如下方式进行工作:首先把数据库内容复制到一个临时数据库文件中,然后再把临时数据库文件中的内容写回到原始数据库文件中(以整理数据库文件)。
The VACUUM command works by copying the contents of the database into a temporary database file and then overwriting the original with the contents of the temporary file.
其他用于用户数据、临时数据和索引数据的表空间则需要在创建数据库之后另行创建,并且在使用这些表空间之前,还需要为之指定一个用户。
Other table spaces for user, temporary and index data need to be created after the database has been created, and a user needs to be assigned to these table spaces before they can be used.
其他用于用户数据、临时数据和索引数据的表空间则需要在创建数据库之后另行创建,并且在使用这些表空间之前,还需要为之指定一个用户。
Other table spaces for user, temporary and index data need to be created after the database has been created, and a user needs to be assigned to these table spaces before they can be used.
应用推荐