Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy a great portion of your real-life N-Tier application.

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 the user's perspective and focus on all the data that needs to be displayed to the user or changed by the user.

STEP 3: CREATE TIERDEVELOPER PROJECT

1. Connect TierDeveloper to your database: TierDeveloper uses OLEDB to connect to your database and reads its schema so it can let you define the mappings of middle-tier objects with tables in the database (based on what you have determined about your application's interaction with your database). Please note that even if you're going to generate Java/J2EE application that will use JDBC to connect to the database, TierDeveloper (the product) will use OLEDB to connect to your database.

2. Define data object mappings to your tables: Wherever you had identified table-columns that your application needs, define data objects mapped to these tables with the appropriate columns selected as data object attributes. You can map a data object to single table or multiple tables. You'll need multi-table data objects for situations where you're trying to issue a multi-table join query that returns data from multiple tables.

3. Specify transactional methods in data objects: Based on what you identified as your application's transactional needs earlier, you should now define those insert, update, delete, and single-row select as methods of your data objects. TierDeveloper lets you do that with point-and-click.

4. Define queries as data object methods: For each query that you identified earlier, define a query method in the appropriate data objects. Remember, a query returns a resultset which get translated into a collection of data objects by TierDeveloper generated code.

5. Define stored procedure calls as data object methods: Wherever you needed to call stored procedures, you need to define data object methods for them. Remember, these stored procedures contain sophisticated business rules. Any stored procedures for transactional operations or queries can be generated by TierDeveloper so you do not have to manually write them in the database.

6. Define bulk update/delete operations as data object methods: Wherever you need to do a bulk update or bulk delete, you'll need to define data object methods for them.

STEP 4: GENERATE AND RUN 50% OF YOUR APPLICATION INSTANTLY

1. Generate data objects: After you have defined all your data objects, you are ready to generate code for them. You can generate data object code in the following format:

a. .NET components

2. Build and deploy data objects generated code: If you machine has the appropriate build environment for your platform, TierDeveloper asks you whether you want to build the generated data objects code. If you say "yes", it creates the following. It also then deploys them to your appropriate environment.

a. .NET assemblies for .NET components. They are deployed through component services.

3. Generate web application: After you have generated and build the data objects, you can generate a fully working web application. The purpose of this web application is to let you test all the functions of data objects. This also serves as a good sample/example code for you to copy into your own web application development. TierDeveloper generates the following types of web applications:

a. ASP.NET pages in C# or VB.NET and with or without XML/XSLT.

4. Build and deploy web application: TierDeveloper can also build the web pages for you. It does the following for each platform:

a. Build a .NET assembly for ASP.NET pages. They are deployed to IIS

5. Run deployed web app with data objects: Now that you have successfully deployed the data objects and the web app, you can run the web app. The really nice thing is that all this generated code is now working against your own database and in your own environment. You can see all the behavior of the data objects through this web app and also use it as a guide in your own web development. Try this and you'll be convinced about TierDeveloper being a true Rapid Development tool.

STEP 5: DEVELOP REMAINING 50% OF YOUR APPLICATION

After running and verifying that all the generated code contains your desired functionality and runs correctly against your database, you are now ready to develop the rest of the application. The areas you are likely to need to develop in your application are:

1. Presentation Layer (Web Pages): Use TierDeveloper generated web app as a sample/example for quickly developing your own. You can even copy/paste a lot of the code from the generated web app into yours, thereby speeding up your development work even further.

2. Business Objects: Although TierDeveloper generated code contains all your data manipulation logic and some of your business rules as well (in the form of data validation or stored procedure calls), you will most likely have to develop additional business objects. If you're not an expert in your target platform (.NET, J2EE, or J2SE), you can learn from the generated data objects as your business objects are likely going to be in the same environment and would follow similar design approach.

For free evaluation download please visit
http://www.alachisoft.com/download.htm

In The News:


The Register

Green software blacked out Australian State
The Register
Something good is going to come out of last year's “Black System” in the Australian State of South Australia: the global wind power industry has learned how to do better modelling for systems under attack from repeated failures. South Australia last ...

and more »

TNW

3 software development trends you don't want to miss
TNW
This has led to more and more companies adopting team chat applications to assist in conducting key business operations, including the building and shipping software applications. Interacting with your team members using a chat application is only ...


New York Times

Software Engineer Starts Unlikely Business: A Weekly Newspaper
New York Times
The investment — by a software engineer who studied artificial intelligence, no less — seems like a quixotic one when so many newspapers are struggling and many readers prefer to catch up on town news on Facebook. But the engineer, Heeten Choxi, ...

and more »

Siemens' software donation to benefit Connecticut community college students
New Haven Register
The intial befeficiaries of Siemens' product lifecycle management software will be students in the Advanced Manufacturing Technology Centers at Three Rivers, Manchester, Asnuntuck and Gateway community colleges. Use of the software Siemens is making ...
Siemens Gives Community Colleges $315 Million Worth of Advanced Manufacturing SoftwareHartford Courant

all 4 news articles »

Brownwood Bulletin

Commissioners OK use of forfeiture funds for prosecutors' software
Brownwood Bulletin
Brown County Commissioners Court members on Monday authorized District Attorney Micheal Murray's office to spend just over $94,000 in forfeiture funds to buy software and equipment that will streamline the process of providing discovery to defense ...
Brown County DA getting new software to increase transparencyKTXS

all 2 news articles »

PCWorld

Switching from Mac to PC, Part 3: The software challenge | PCWorld
PCWorld
When you switch from Mac to PC, you'll be leaving some software behind. We've found some solid replacements.

and more »

GeekWire

How this legal software startup used its funding round to support legal aid under Trump budget cuts
GeekWire
But MetaJure, a Seattle startup that provides software to help lawyers manage their documents and email, is starting early. As early as the company's Series A funding round, in fact. MetaJure used its $2.6 million round as an opportunity for what its ...

and more »

Market Realist

How BBM Enterprise Could Impact BlackBerry's Software Business
Market Realist
By opening BBM Enterprise SDK (software development kit) to third-party developers, BlackBerry has also unlocked a new revenue stream in its Software and Services segment. The company could take a cut from the sales of third-party apps integrated with ...

and more »

Daily Mail

The 'magic carpet' software that helps fighter jet pilots make a perfect landing on a warship in ANY conditions
Daily Mail
The US Navy has revealed a radical new system allowing fighter pilots to land on deck safely. Called 'Magic Carpet' the software is being tested by F/A-18E/F Super Hornet and EA-18G Growler pilots across the Navy's fleet. It effectively acts as an ...

and more »

9 to 5 Mac

Apple rolling out macOS 10.12.4 software update with Night Shift for Mac
9 to 5 Mac
funny, that you mention case sensitivity. That is actually the biggest reason why I want APFS as soon as possible, because I'd really like a case sensitive filesystem for web development. I tried using HFS+ in it's case sensitive mode but a lot of ...

and more »
Google News

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

S is for Spying, Surveillance -- and for Software as Well

Words we choose to describe things and phenomena often show... Read More

Marketing Your WinRunner Team

It won't matter how effective your WinRunner Team is if... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

Corel WordPerfect 7 Macro Programming Example

Case study: A secretary using Corel WordPerfect 7 is often... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Microsoft Office Selecting Secrets

Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More

Reporting Tools for Microsoft Great Plains ? Overview For Developers

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

As we could imagine, if you are reading this article... Read More