集输大队报表数据迁移论文03083107刘骞.docVIP

中国石油大学（华东）毕业设计（论文） 中国石油大学（华东）毕业设计（论文） 集输大队报表数据迁移 学生姓名：刘骞 学 号专业班级：软件工程03-1班 指导教师：郑秋梅 2007年6月20曰 随着信息技术的发展，对数据处理提出了越来越多的要求，在异构数据 库之间进行数据迁移以及web数据库的建立成为两种常用的的信息处理方 式。木文就Oracle向SQL Server的数据迁移作为一个实例，讨论一种数据 迁移模式，即通过源、的数据库之间的“对话”确定要抽取和插入的数据， 这是实现数据的定时、自动迁移的基础。然后建立上报表系统将迁移到 SQL Server中的数据发布到网上供相关用户访问。木文实例涉及Oracle和 SQL Server两大关系型数据库，运用Java实现定时自动迁移模块，JSP + Resin实现报表系统，两个系统都是基于JDBC机制实现的。在指导老师的 帮助下，已经基木上实现了任务书所要求的功能。 关键词：数据迁移；数据管理；JDBC； Oracle数据库；SQL Server数 据库 ABSTRACT With the development of the information technology, there is more and more demand on data processing. So many kinds of data processing such as data migration between data bases with different architecture or foundation of on-line data bases become very popular. This article takes data migration from Oracle to SQL Server as an example to discuss a migration mode which decides what data to select-and-insert through “talk” between them，and this is also the basic foundation on which the automatic and on-time migration is based. And then a table management system is developed to make the data migrated to SQL Server is available for certain users. The instance in this article involves Oracle and SQL Server, which are the two large-scale relational databases. And the automatic and on-time migration module is programmed in Java while the data form system is base on JSP and Resin. And they are both based on JDBC (Java Data Base Connectivity). With the help of the teacher, the system designed could easily meet the demands listed on the task book. Keywords: data migration; data management; JDBC; Oracle; SQL Server 目 录 TOC \o 1-5 \h \z HYPERLINK \l bookmark4 \o Current Document \h 第一章前言 1 HYPERLINK \l bookmark5 \o Current Document \h 研究的目的及意义 1 1.1研究目的 1 1.2研究的意义 1 HYPERLINK \l bookmark6 \o Current Document \h 研究现状 1 HYPERLINK \l bookmark7 \o Current Document \h 第二章系统实现技术 3 HYPERLINK \l bookmark8 \o Current Document \h 2. 1 Oracle 数据库 3 2.1.1 Oracle数据库的安装、配置 3 2. 1. 2 Oracle数据库的连接 3 2. 1. 3 Oracle数据库的查询