Database application development

Developing A Database-Backed Web Application {1}

by Kathy S
Database-backed applications generally use structured data where output via different parameters such as subject or material type is desired; enable searching of the data by various parameters; manage constantly changing data; and allow the reuse of information in different contexts and pages. The author of this article journal focused mainly on the important things to consider when building a database-backed web application. The long list is as follows: Planning (deciding what you want, get everybody on board, think big, start small), Define the System, Develop a Data Model, Define Interactions, Define the User Interface, Implement (select a hardware platform), Select a Data Management System, Select Development Tools, Coding, Production, Issues (Data backups, data integrity), Security and Communication. When it comes to planning it is important to identify the persons who will fill various roles in the project: Project coordinator, data users, designer, database administrator, developer/programmer, and testers. Also, Data modeling is considered the most critical part of the entire process and one that is too often overlooked according to the author. The designer will save a lot of time and avoid many problems and frustrations by focusing on proper data modeling before attempting implementation. The article goes into much more detail for each of the points listed. I’d recommend reading the entire journal article to understand the whole process. read more...

Developing Mobile Database Apps {1}

by Kevin S
Learning about application development and databases go hand-in-hand with each other. Speaking of hands, we frequently would like to access databases through a mobile device. In the journal “Building Database-Powered Mobile Applications” we can learn of the different API’s available to create applications on mobile platforms. API’s covered include those for Android, Symbian, Windows CE/Mobile and Windows Phone (sorry Apple isn’t covered!). For most of the OS’s, SQLite may be used. SQLite has some restrictions on it’s data types and does not support certain other features normally used in SQL server. read more...

A New Teaching Approach for Database Application Development {1}

by Garcello D
The article I decided to week’s blog about is titled “Centralized Project-Based teaching Approach in Database Application Development Training”, which was written by Gaoyan Zang on June 29 2010-July 1 2010. So based on the title the article is about a new teaching approach which has been proven by fact to stimulate the enthusiasm of students, improve learning efficiency, and to make performance evaluation more efficient and fair. The intro of the article basically explains how the information technology field is growing and how due to the fact that it’s growing we need fresh new talent to innovate in it. The problem is that this fresh new talent can come from fresh graduated students but the problem with that is that the companies do not hire fresh new students because they require real project experience. This teaching method is different from your average lecture or laboratory courses, it requires the students to complete a task in a certain amount of time without the distractions from any other courses, they have a specific goal they should meet and thus they are achieving targets by meeting those goals. The students will experience something very similar to future real work situations where they will be assigned a project task and will have to analyze the need, outline design and detailed design, to code, to test, to implement, and to do maintenance and so on. Although in the real world the distribution of these jobs would be more specific, the author beliefs it is best for the students to experience the entire package. read more...

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

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 read more...