Oracle Paper Open title Report

I. Source of the subject

The project "The construction of Oracle database application experiment platform" comes from the actual teaching work needs, along with the progress of science and technology, the development of network, almost all enterprises use the database to help manage the business activity, bring the huge profit for the enterprise. Today's database market has formed the Oracle database of Oracle, IBM's DB 2 database, Microsoft's SQL Server database as the representative of the three pillars, Oracle of Oracle is a firm occupy the largest market share. At home, Oracle database has become the first choice of many enterprises, and the domestic market share of the trend of increasing every year. Therefore, the construction of Oracle database application platform can not only provide a platform for database teaching, but also enable students to achieve a combination of theory and practice in the process of learning, to provide students with more Oracle learning and practical resources, in order to improve students ' theoretical height and practical ability, and ultimately, To help students with their employment.

Ii. current situation at home and abroad

In foreign countries, there are already a large number of universities using Oracle, of which the top 10 of Harvard University, Yale University, Cambridge University, Oxford University, California Polytechnic University, Imperial College London, the University of Chicago, Massachusetts Institute of Technology, Columbia University, all using Oracle. The University of Cambridge, for example, has 30,000 students, 31 colleges, and 150 departments, facing every college with its own information systems, redundancy and conflict information, cumbersome and inefficient business processes, inability to quickly give business reports and other challenges, ultimately, by applying Oracle, Successful implementation of the guarantee of a single official record, all departments can obtain accurate data, students can be outside the campus to obtain records, share information, accurate reports.

At home, Tsinghua University, Beijing University of Technology and China University of Science and Technologies have signed agreements with Oracle to become the first member of the China OAI Program (Oracle Academic Education Program). According to the plan, they have access to Oracle's standard commercial software for instructional purposes, as well as Oracle's silver service. Students can learn the latest technology in the world and gain access to world-class courses, while participating in social practice through Oracle's alliances with industry users to gain the expertise they need on the market. Recently, on May 13, Chengdu Golden Morning Education Group and the world's largest enterprise software company Oracle, held in Chengdu, "2011 Oracle International IT Talent Training Innovation Forum" and "Sichuan Regional University Dean Summit Forum", Sichuan University, Chengdu University of Technology, Sichuan Normal University, Chengdu Institute of Information Engineering , Chengdu, the School of information, Chengdu Textile College, Chengdu Electronic Machinery College and other 25 university leaders attended the meeting. After the meeting, Oracle will work with universities on the replacement of Oracle's fine courses, professional co-construction, and build a large-scale training base and other cooperation models for in-depth negotiations, while Oracle will donate to some schools genuine software, training teachers. Through this meeting, ORACLE company will work with the universities in Sichuan province, in the "School-Enterprise Alliance" Education reform model, to build enterprises need information-based talent, to open up it manufacturers, universities, employing enterprises throughout the chain, improve the employment and professional ability of Sichuan University students.

At home and abroad, Oracle has gone deep into the universities at home and abroad, and it is urgent to integrate Oracle teaching into the database teaching.

Three, comprehensive analysis

After the project is implemented, it is expected to realize the sharing of Oracle database services, as well as the centralized management of users, so it is divided into two parts from the perspective of application analysis:
Deployment and use of Oracle database software

1.1 Selection of hardware carriers

In Oracle 11G, for example, the official documentation is described below:

Minimum project requirements

Physical Memory 1GB Minimum

Twice times the physical memory of virtual memory

Disk space Basic installation required: 4.55GB Advanced installation Required: 4.92GB

Display supports 256 colors

Processor minimum 550MHz, if the Vista system requires 800MHz

The above is the minimum hardware requirements for Oracle 11G installation, according to this requirement, can only achieve single-user learning, can not meet the large number of users of concurrent access application needs, therefore, in order to meet the Hubei Institute of Automotive Industry School 9600 students and 478 full-time teachers of the application needs, Should improve the hardware carrier performance of the procurement standards to meet the current application needs, at the same time, the hardware carrier should have a certain capacity to expand to meet the future upgrade requirements, saving investment costs.

1.2 Choice of operating system

Oracle database supports many types of operating systems, such as Windows series operating systems, Unix series operating systems, and Linux series operating systems.

Although the UNIX series, Linux series, and other types of operating system security can be higher than the Widows series of operating systems, but the Unix family, Linux series operating systems inherent in the difficult to learn, difficult to configure, etc., will bring a huge challenge to the deployment phase of the project, Because the expected requirements of the project are a platform for student learning and teacher teaching, the platform will not deploy commercially available database data in the future run phase, so the security of the Windows family can meet the requirements of the platform, while the Windows platform is easy to maintain, easy to manage and other features, It also facilitates the deployment of the platform.

Therefore, choosing the operating system of the Windows family, which meets the operational requirements of Oracle 11G, reduces the cost of post-maintenance.

1.3 Initial planning for Oracle 11G

Select the Windows version of Oracle 11G as a platform for database teaching, depending on the operating system platform selected.

It is reasonable to divide Oracle's users into 4 categories, providing database services for students at the Hubei Institute of Automotive Engineering and dedicated teachers.

First class, students. Students are free to use Oracle for related DDL, DML operations, but students should be strictly restricted from using DCL operations.

Class II, teachers. Teachers are free to use Oracle for first-off DDL, DML, DCL operations.

Third category, maintenance staff. The operator's operations should be strictly limited to prevent the database from being paralyzed, but oracle can be monitored and maintained on a basic basis.

Class fourth, administrator. Administrators have all the privileges to perform advanced operations on Oracle as required by the instructor, but should strictly monitor their operations to prevent server servers from becoming available.

Due to the large number of users on the platform, Resources for Oracle services need to be allocated rationally to improve the utilization of Oracle databases while meeting the special application needs of teachers.

Oracle Paper Open title Report