| Description |
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. You can download TierDeveloper 3.0 at 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 |
