-
公开(公告)号:US20050256908A1
公开(公告)日:2005-11-17
申请号:US10966961
申请日:2004-10-15
申请人: Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander Hwang , Steven Wertheimer , Francisco Sanchez , Dmitry Potapov , Shen-Ban Meng , Juan Loaiza , William Bridge , J. Lee
发明人: Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander Hwang , Steven Wertheimer , Francisco Sanchez , Dmitry Potapov , Shen-Ban Meng , Juan Loaiza , William Bridge , J. Lee
CPC分类号: G06F17/30569 , Y10S707/99942
摘要: A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.
摘要翻译: 提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。 基于源数据库中包含的数据,元数据(例如,系统表空间和控制文件中的数据)以及外部对象(例如,密码文件和外部存储的表),在目标平台上创建目标数据库。 存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。 可以在源数据库或目标数据库执行数据和元数据的转换。 源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。 可以在目标数据库上重新创建某些文件,例如密码文件和到外部存储对象的链接。
-
公开(公告)号:US20050253739A1
公开(公告)日:2005-11-17
申请号:US10966679
申请日:2004-10-14
申请人: Wei Hu , Alexander Hwang , Shen-Ban Meng , Alok Pareek , Dmitry Potapov , Francisco Sanchez
发明人: Wei Hu , Alexander Hwang , Shen-Ban Meng , Alok Pareek , Dmitry Potapov , Francisco Sanchez
CPC分类号: G06F17/30569
摘要: Stored data, such as tablespaces, are transported between different systems having different platforms by converting the format of the stored data into a common format either before or after transmitting the stored data from the source database system to the target database system. The common format may be a format that is universal in that the common format is not machine dependent. The stored data may be kept in the common format at the target database system and never converted to another format. Optionally, the stored data may be converted from the common format to a format associated with the target database system, thereby facilitating backward compatibility. A tool may be provided for performing the conversion. In an embodiment each of the target and source database systems have a copy of the tool.
摘要翻译: 通过将存储的数据从源数据库系统发送到目标数据库系统之前或之后将所存储的数据的格式转换成通用格式,将诸如表空间的存储的数据传送到具有不同平台的不同系统之间。 通用格式可以是通用的格式,因为通用格式不依赖于机器。 存储的数据可以在目标数据库系统中保持为通用格式,并且不会转换为另一种格式。 可选地,存储的数据可以从公共格式转换成与目标数据库系统相关联的格式,从而有助于向后兼容。 可以提供用于执行转换的工具。 在一个实施例中,目标和源数据库系统中的每一个具有工具的副本。
-
公开(公告)号:US08554806B2
公开(公告)日:2013-10-08
申请号:US10966679
申请日:2004-10-14
申请人: Wei Hu , Alexander Hwang , Shen-Ban Meng , Alok Pareek , Dmitry Potapov , Francisco Sanchez
发明人: Wei Hu , Alexander Hwang , Shen-Ban Meng , Alok Pareek , Dmitry Potapov , Francisco Sanchez
CPC分类号: G06F17/30569
摘要: Stored data are transported between different systems having different platforms by converting the format of the stored data into a common format either before or after transmitting the stored data from the source database system to the target database system. The common format may be a format that is universal in that the common format is not machine dependent. The stored data may be kept in the common format at the target database system and never converted to another format. Optionally, the stored data may be converted from the common format to a format associated with the target database system, thereby facilitating backward compatibility. A tool may be provided for performing the conversion.
摘要翻译: 通过将存储的数据从源数据库系统发送到目标数据库系统之前或之后将所存储的数据的格式转换成通用格式,将存储的数据在具有不同平台的不同系统之间传送。 通用格式可以是通用的格式,因为通用格式不依赖于机器。 存储的数据可以在目标数据库系统中保持为通用格式,并且不会转换为另一种格式。 可选地,存储的数据可以从公共格式转换成与目标数据库系统相关联的格式,从而有助于向后兼容。 可以提供用于执行转换的工具。
-
公开(公告)号:US07571173B2
公开(公告)日:2009-08-04
申请号:US10966961
申请日:2004-10-15
申请人: Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
发明人: Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
IPC分类号: G06F7/00
CPC分类号: G06F17/30569 , Y10S707/99942
摘要: A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.
摘要翻译: 提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。 基于源数据库中包含的数据,元数据(例如,系统表空间和控制文件中的数据)以及外部对象(例如,密码文件和外部存储的表),在目标平台上创建目标数据库。 存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。 可以在源数据库或目标数据库执行数据和元数据的转换。 源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。 可以在目标数据库上重新创建某些文件,例如密码文件和到外部存储对象的链接。
-
-
-