บริการให้เช่า Oracle 10g for Linux Enterprise Server

system · March 3, 2007, 9:30am

BASE ON/CentOS Enterprise Server [ES]
http://www.therackspace.com

สำหรับองค์/หน่วยงาน ที่ต้องการ Oracle Database Server อันทรงคุณภาพ ทางเรา therackspace.com ผู้นำทางด้าน Data Center Co-Location Server ยินดีใคร่เสนอ ORACLE 10g

ทางเราเปิดให้เช่าใช้ DBMS Oracle 10g --> Data Space (หมายถึงกำหนดขนาด db แบบ dedicated disk space)

เปิดบริการให้ DBA/Oracle ขององค์มาเช่าใช้ เพื่อประหยัดต้นทุนในการหา Oracle/Server HW ให้กับองค์ของท่าน อีกทั้งมีเจ้าหน้าที่ DBA คอยแนะนำให้คำปรึกษาและดูแลตลอดการใช้งาน

การประยุกต์ใช้งาน
สามารถนำมาใช้ได้กับ web application ทุกภาษา

Oracle 10g ติดตั้งบน CentOS 4.4 (Enterprise Server)

ลักษณะการใช้งาน

Access DB Oracle external webserver
Access DB Oracle internal Dedicated/Co-Location ภายในตู้ของ The Rackspace
Database Backup Daily Free

หมายเหตุ
ทางเรารับให้คำปรึกษาและวางระบบขนาดใหญ่ ด้วยเทคโนโลยี่ Cluster Servers Farm รองรับ Traffic/Load ได้ไม่จำกัด เพื่อความเติมโตไปข้างหน้าของท่านได้อย่างมีประสิทธิภาพด้วยความมั่นใจในความมั่นคงความเชื่อถือสูง

สนใจสอบถามรายละเอียดได้ที่
Tel: 081-7316544, 02-3984489
Smartnet Consultant Part., Ltd.

system · March 3, 2007, 9:48am

Oracle Database 10g
Oracle Database 10g is the first database designed for grid computing, the most flexible and cost-effective way to manage enterprise information. It cuts costs of management while providing the highest possible quality of service.

In addition to providing numerous quality and performance enhancements, Oracle Database 10g significantly reduces the costs of managing the IT environment, with a simplified install, greatly reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning.

These and other automated management capabilities help improve DBA and developer productivity and efficiency. And with Release 2, Oracle’s focus on improving efficiencies and reducing the cost of information management continues.

Oracle Database High Availability
Databases and the Internet have enabled worldwide collaboration and information sharing by extending the reach of database applications throughout organizations and communities. Both small businesses and global enterprises have users all over the world who require access to data 24 hours a day. Without this data access, revenue and customers can be lost, penalties can be owed, and bad press can have a lasting effect on customers and a company’s reputation. Building a high availability IT infrastructure is critical to the success and well being of all enterprises in today’s fast moving economy.

One of the challenges in designing an HA solution is examining and addressing all the possible causes of downtime. It is important to consider causes of both unplanned and planned downtime when designing a fault tolerant and resilient IT infrastructure. Unplanned downtime is primarily the result of computer failures or data failures. Planned downtime is primarily due to data changes or system changes that must be applied to the production system.

Click on the following for a further explanation of what the critical high availability solution areas are, why they are important considerations for building a highly available solution, and what are Oracle’s offerings in each of these areas.

Oracle Backup and Recovery

Backup and recovery is one of the most important aspects of database administration. If a database crashed and there was no way to recover it, the devastating results to a business could include lost data, lost revenue and customer dissatisfaction. Whether companies operate a single database or multiple databases storing hundreds of gigabytes or even terabytes of data, they share one common factor - the need to back up important data and protect themselves from disaster by developing a backup and recovery plan.

Oracle Real Application Clusters
Oracle Real Application Clusters (RAC) is an option to the award-winning Oracle Database 10g Enterprise Edition. Oracle RAC is a cluster database with a shared cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches to provide highly scalable and available database solutions for all your business applications.

Oracle Database 10g Standard Edition includes Real Application Clusters support for higher levels of system uptime.

Oracle Focus.

system · March 3, 2007, 9:58am

Using PHP and Oracle

The example I’ll be working with will be a registration form (or a minimal part of it, anyway). The theory is that I must confirm unique email addresses in the users table so that people cannot register multiple times using the same address. This is normally part of the validation process that comes after the user submits the form to the handling PHP script. But why should the user have to wait until then for this piece of validation? Instead, as soon as the user enters their email address and goes to the next form field, the email address will be immediately validated. But to do so, I still need to query the database, which is where Ajax comes in.

The simplified table structure for this example could be created with the following SQL statement (without the presence of the other tables, I’ve done away with identifying keys and such).

CREATE TABLE users (
email VARCHAR2(60)
)

Obviously you could expand on this in many ways. For now, though, the important thing is that the sample code assumes you have established such a table and can connect to it from a PHP script. Some records must be in this table for the example to fully function, so you should populate it like so:

INSERT INTO users (email) VALUES (‘this@that.com’)
INSERT INTO users (email) VALUES (‘me@school.edu’)
INSERT INTO users (email) VALUES (‘fake@address.net’)

Programming the Database Query



SELECT COUNT(*) AS NUM_ROWS FROM users WHERE email='{$_GET['email']}'



f ($rows > 0) {
	echo 'Email address has already been registered!';
} else {
	echo 'Email address is available!';
}



<form action="somepage.php" method="post">
Email Address: <input name="email" type="text" size="30" maxlength="60" />

First Name: <input name="first_name" type="text" size="20" maxlength="20" />

(Rest of the form...)
</form>

หมายเหตุ เป็นการ cut ตัวอย่างเล็กๆบางส่วน…เพื่อเสนอให้เห็นว่าการใช้ PHP เรียกใช้งาน Oracle DB ไม่ยากครับ

Oracle Focus.