5 Steps to Rapid Development
-
Five Steps to Rapid Development with TierDeveloper 3.0 Unlock the power of rapid development when you use TierDeveloper from AlachiSoft in your N-Tier application development. Follow the steps below to quickly design, generate, and deploy a great portion of your real-life N-Tier application. For free evaluation download please visit http://www.alachisoft.com/download.htm STEP 1: HAVE YOUR DATABASE READY 1. Create your database in Microsoft SQL Server, Oracle, or DB2. You can design and create your own database. Or, you can use the sample database provided with TierDeveloper. Or, you can use one of the databases/schemas already provided with your database. They are: a.Microsoft SQL Server: Northwind database. Just create a new TierDeveloper project against this database. b.Oracle: DEMO schema with EMP, DEPT, BONUS, SALGRADE, and other tables. Just create a new TierDeveloper project against this schema. c.DB2: SAMPLE schema provided with DB2. Just create a new TierDeveloper project against this schema. 2. Populate database with data. This would ensure that you have a fully working database ready to be used by a web application. STEP 2: KNOW YOUR APPLICATION'S DATABASE INTERACTION 1. Identify table-columns your app will access: Before you do anything, you must know which tables and which columns in these tables is your application going to access. 2. Identify transactional operations: Identify where in your application you need to do insert, update, delete, or single-row select operations. 3. Identify queries: Most applications need to retrieve collection of rows from one or more tables in the database. Identify all places where you need to issue queries. These could be single-table queries or could involve complex joins or nested queries. 4. Identify stored procedures to call: If there are any stored procedures that already exist in the database which you need to call, identify them here. These stored procedures should be those that contains complex business rules or other data manipulation logic. Do not manually create stored procedures in the database for transactional operations or for queries that are otherwise handled by TierDeveloper. TierDeveloper can generate stored procedure DDL for you in that situation. 5. Identify bulk updates or deletes: Most applications do not require bulk updates or deletes but some do. If you have any, identify them. The best way to understand your applications database interaction needs is to understand its behavior from