Web-based database application development with Java technology and Oracle{1}

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.

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.