Making a database available on the Web

Making a database available on the Web

In our organization, we have an Oracle database server (production), and we would like to provide this database on the Web. What are the solutions available for the architecture in factor of better performace for the database on the Web, higher security and availability?

    Requires Free Membership to View

    By submitting your registration information to SearchOracle.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchOracle.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Today, you have many technologies for making your data available on the Web. You can use ASP, JSP, Java applets, Cold Fusion, Perl/CGI, and many, many more. Oracle does have their own Web server (Oracle Application Server) and they do have Oracle Portal, which can make development of your Web-based application a little easier. One of my favorite Web-based development tools is Dreamweaver UltraDev by Macromedia.

The factors influencing performance, security, and availability are not too different just because you are using a Web-based application. For performance, you will still need to tune your SQL statements, your database, and your server. For security, you will still need to make your data secure as possible with respect to using grants, roles, security through stored procedures and view, etc. Oracle does include a few features which can give you some benefit to your Web-based apps such as Secure Application Context and connection pooling.

This was first published in June 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.