What I Have Learn About Oracle Database Training
We studies this topic for almost 7 days by our VTC trainer named Mr Goh and Mr Leong.
Outline:
Brief intro to the technology used in Enterprise
Brief intro to the Oracle technology available to the Enterprise
VM
Hands On- Setup VM
Briefing & Introduction-UTM-I2M-VTC
About i2M
i2M, a fullyowned subsidiary of Khazanah Nasional Berhad, is currently working handinhand together with UTM and VTC to conduct the GBS Iskandar Campus Connect Oracle Training & Certification Program.
About GBS ISKANDAR
GBS ISKANDAR is a specialised programme to facilitate businesses to locate GBS Operations in Iskandar Puteri, Iskandar Malaysia. The programme is managed by i2M Ventures Sdn Bhd (i2M ), a whollyowned subsidiary of Khazanah Nasional Bhd, the Malaysian government’s investment arm.
About GBS ISKANDAR Campus Connect: Oracle Training
This training program introduces participants to ServiceOriented Architecture (SOA) concepts, the OSA approach to integration, and the Oracle Fusion Middleware 11g products that support and SOA implementation.
Brief intro to the technology used in Enterprise
Figure 1
Figure 1 it show the outline of the evolution technology used in Enterprise from year 1900 till 2013. based one the figure it show on the enhancement in the field of manufacturing, logistic, globalization and cloud computing. I learn that even the phone have rapid transformation for instance in year 1984 IBM first mobile/smart phone the later on 2007 the first iPhone has been created.
The evolution of storage has it history of creation, which in the year 1800 the first taper was invented later in year 1953 the first laser printing was produce as to overcome problem in human writing. The crucial evolution is in year 1971 where the first disk ed invented to store data. This is the start of storage evolution begin. Later in 1979 the compact CD/CD ROM ,1983 the connect storage, in 1995 the DVD and in 2000 the tumbdrive.
Around 1999 the first cloud is being introduce and subscribe. The the world is blown with the Google apps platform in year 2006. Then in 2008 the elastic cloud is introduce, follow the next year the creation of host window platform. With the creation of cloud maybe the need of PC can be less use but the circumstance is that more data storage must be created.
Brief intro to the Oracle technology available to the Enterprise
Now we move on to the main topic the world of Oracle. Referring from the oracle documentation document on then Brief History of Oracle Database, The current version of Oracle Database is the result of over 35 years of innovative development.
Highlights in the evolution of Oracle Database include the following:
Founding of Oracle
In 1977, Larry Ellison, Bob Miner, and Ed Oates started the consultancy Software Development Laboratories, which became Relational Software, Inc. (RSI). In 1983, RSI became Oracle Systems Corporation and then later Oracle Corporation.
First commercially available RDBMS
In 1979, RSI introduced Oracle V2 (Version 2) as the first commercially available SQL-based RDBMS, a landmark event in the history of relational databases.
Portable version of Oracle Database
Oracle Version 3, released in 1983, was the first relational database to run on mainframes, minicomputers, and PCs. The database was written in C, enabling the database to be ported to multiple platforms.
Enhancements to concurrency control, data distribution, and scalability
Version 4 introduced multiversion read consistency. Version 5, released in 1985, supported client/server computing and distributed database systems. Version 6 brought enhancements to disk I/O, row locking, scalability, and backup and recovery. Also, Version 6 introduced the first version of the PL/SQL language, a proprietary procedural extension to SQL.
PL/SQL stored program units
Oracle7, released in 1992, introduced PL/SQL stored procedures and triggers.
Objects and partitioning
Oracle8 was released in 1997 as the object-relational database, supporting many new data types. Additionally, Oracle8 supported partitioning of large tables.
Internet computing
Oracle8i Database, released in 1999, provided native support for internet protocols and server-side support for Java. Oracle8i was designed for internet computing, enabling the database to be deployed in a multitier environment.
Oracle Real Application Clusters (Oracle RAC)
Oracle9i Database introduced Oracle RAC in 2001, enabling multiple instances to access a single database simultaneously. Additionally, Oracle XML Database (Oracle XML DB) introduced the ability to store and query XML.
Grid computing
Oracle Database 10g introduced grid computing in 2003. This release enabled organizations to virtualize computing resources by building agrid infrastructure based on low-cost commodity servers. A key goal was to make the database self-managing and self-tuning. Oracle Automatic Storage Management (Oracle ASM) helped achieve this goal by virtualizing and simplifying database storage management.
Manageability, diagnosability, and availability
Oracle Database 11g, released in 2007, introduced a host of new features that enabled administrators and developers to adapt quickly to changing business requirements. The key to adaptability is simplifying the information infrastructure by consolidating information and using automation wherever possible.
Plugging In to the Cloud
Oracle Database 12c, released in 2013, was designed for the Cloud, featuring a new Multitenant architecture, In-Memory column store, and support for JSON documents. Oracle Database 12c helps customers make more efficient use of their IT resources, while continuing to reduce costs and improve service levels for users.
The outline of the of the history of oracle can be summarize in figure 2 and figure 3.
Figure 2
Based on figure 2, from 1977 till 1988 all about database while from 1989 till 1999 all about oracle building/creating software/apps. The main highlight is in year 1979 where the development of RSI replacing STC and in year 1987 where they decided to start to build software related to database that more related to accounting/business software.
Figure 3
For figure 3, below are my short description and highlighted event:
2002-hacker cant break through
‘G’ stand for grid computing
2005-relize to build a software is a lot cost so solution to subscribe them usually on HR dept. to apply leave etc...
2000 On wards people more involve in internet, realize people start to compare the appearance of the system
2006 – event its is an open source but the framework cant be change to make its secure and standardize
2007- from 10g to 11g
2008-their marketing campaign; Exadata- engineer system like iron movie find in YouTube oracle sponsor to appear in the iron man movie
2009-as a translator for to language vs IBM for middleware
2010-first available for cloud offering; they build chips from IBM or Intel
Exadata usually use solaris then later they just buy hardware for marble software for oracle
Data where-house (exadata) big company willing to pay cause many data to proses transaction data
2013-similer concept like java like drag and drop apps
2014-similer to engineer system (exalytics) part of OBIEE; SOA Suite the evolution like Microsoft office that evolve to new step. Like new product inside
2015- in cloud era.
VM
Figure 4
Based on figure 4 its categorize 2 type of VM (Virtual Machine) with representative example.
Type 1 hypervisor run directly on the hardware with VM resources provided by the hypervisor.
Type 2 hypervisor runs on a host operating system to provide virtualization services.
Hands On- Setup VM
After a long theory and boost up history in oracle, the trainer give us a Hands On to Setup our VM to install our own Oracle Database in a vitalization state. We use the Virtual Box software to create our VM. In the Virtual Box , we can set up the preference require such as the virtual disk, network and OS needed to install the Oracle database application.
Short note:
-VDI is the native format of VirtualBox.
-VMDK is developed by and for VMWare, but Sun xVM, QEMU, VirtualBox, SUSE Studio, and .NET DiscUtils also support it.
-VHD is the native format of Microsoft Virtual PC.
Oracle database Management Tools
- SQL*Plus
- SQL Developer
- Enterprisse Manager
For any inquiries please visit
www.vtcholding.com
Vision Technology Consulting Sdn Bhd
(Malaysia - Klang Valley)
Suite 3-1, 3rd Floor,
Block 4800, CBD Perdana,
Off Persiaran Multimedia,
63000 Cyberjaya,
Selangor, Malaysia
Office: +603 8322 0127 Fax:+603 8319 4510
No comments:
Post a Comment