Web-based database application development with Java technology and Oracle

by Ming X
In the article I read for this week, the author introduces a teaching case on the development of an E-business application using Java server technology with Java Database Connectivity to Oracle databases. The teaching case was tested in upper division CIS courses in three academic quarters during the past two years at California State University, Los Angeles; and it features on the fundamentals of e-business application development, the basic knowledge in database design, implementation, programming languages, networking, Web development and system analysis, script execution, and accessible web sites on the Internet. The author’s purpose is to provide students with a real-world, online and hands-on experience in database Web application development; and also to provide suggestions to those who are or will be teaching a Database Web application development course. On the database design and implementation part of application development process requires a lot of basic database management concepts. There are several steps; 1. Extract Entity Types 2. Identify Relationship Matrix 3.Generate Business rules 4. Identify Database Functions 5.Entity-Relationship Diagram (ERD) 6. Mapping from ER Diagram to Relational Database Schemas

Due to the growing number of E-business, E-business applications are popular and Web-based database application development has become an important topic in the information systems. Database applications are used to search, sort, filter and present information based upon web requests from users. Databases can also contain code to perform mathematical and statistical calculations on the data to support queries submitted from web browsers. Today’s web applications have substantial business impact on the way companies and consumers do business.

When running a business, investing in database software makes it possible to keep track of valuable information for the company and helps employees maintain access to this important data. Using an Web-based database involves accessing a website to store the information and provides several advantages over other methods of preserving data. Web-based database application is fast becoming the choice of enterprise teams. It gives team members access to the real-time information they need, in the format they need it; whenever and wherever they need it. That means faster response, increased accuracy, and better decision making. Web-based business application provides business professionals with the same benefits they seek with desktop applications and the benefits of a secure online, multi-user solution that is collaborative and productive.

Reference
Wang, Ming: E-business application development with Java technology and Oracle: The Fortune Invest Inc. case. Journal of Information Systems Education14. 3 (Fall 2003): 293-300.
http://0-search.proquest.com.opac.library.csupomona.edu/docview/200137036?accountid=10357

One thought on “Web-based database application development with Java technology and Oracle

  • November 19, 2012 at 12:20 am
    Permalink

    It seems like Java is outdated when it comes down to Web application. Since Oracle purchased Sun Microsystems, Java has been the official programming language for Oracle Application Development. With many of start-ups using PHP or Ruby On Rails in recent days, I believe that Java lost its attractions even though Java has been getting updates regularly. Even in here at Cal Poly Pomona, web applications are taught using ASP.NET, not JSP.

Comments are closed.