Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Five Steps to Rapid Development with TierDeveloper 4.0 > NetSparsh - Viral Content you Love & Share

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:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

TechCrunch

Investment advisory software developer SigFig raises $50 million ...
TechCrunch
SigFig, the developer of an automated wealth management toolkit, has raised $50 million in a new round of funding. The company said the new money would be ...

and more »

Engadget

GitHub Education is a free software development package for schools
Engadget
GitHub, the online, open-source code repository recently acquired by Microsoft, has already made big moves to support future software developers. In 2012 it launched the Student Developer Pack, in 2015 it built the GitHub Classroom for teachers, and ...

and more »

Clarkson prof in Potsdam leading team to evaluate DNA software
North Country Now
POTSDAM -- A Clarkson University professor is working with a $75,000 grant to lead a team in evaluating differences in the results given by a variety of software programs used to analyze mixed DNA samples. Clarkson University Associate Computer Science ...


Investor's Business Daily

Red Hat Downgraded, Cloud Computing Growth May Hit Legacy Software
Investor's Business Daily
The enterprise software maker reports fiscal first-quarter earnings late Thursday. Analysts estimate profit growth of 21% to 68 cents a share, with revenue rising 19% to $897 million. At its analyst day in May, the company said its emerging technology ...
Oracle, Micron, FedEx and More Earnings Coming This Week24/7 Wall St.
The Week Ahead: Pharma IPOs Galore, Blackberry Earnings And MoreBenzinga
Benzinga's Top Upgrades, Downgrades For June 19, 2018Benzinga
Zacks -GlobeNewswire
all 123 news articles »

ZDNet

Two weeks with the OnePlus 6: Useful buttons, gorgeous design, stellar software, and reasonable price
ZDNet
Speed and updates: OxygenOS provides nearly a stock Android experience with software customizations that make the device even better than stock. The software screams and in the short couple of weeks of using it I have seen updates so the default ...


hcanews.com

AI Diabetes Tech Continues FDA's Software Push
hcanews.com
Last year, the agency announced the launch of a precertification pilot program, with the goal of approving and bringing potentially life-saving software to market more quickly. Major names like Johnson & Johnson, Apple, and Fitbit signed on as ...

and more »

GeekWire

Owl Insights raises cash for mental health treatment software platform
GeekWire
The company, which is incorporated under the name Mental Health Data Services, makes software that supports mental health treatment in a variety of settings. GeekWire has reached out to Owl Insights for more information on the funding and will update ...


Award-Winning ONYX 18 Software Now Shipping
What They Think
Salt Lake City, Utah – Today, Onyx Graphics, Inc., announced global availability of ONYX 18, the newest version release of the company's award-winning wide- and grand-format software that includes new color technologies for color accuracy, consistency, ...


WPRI 12 Eyewitness News

Major UHIP software upgrade delayed again
WPRI 12 Eyewitness News
PROVIDENCE, R.I. (WPRI) - A major software upgrade for Rhode Island's troubled UHIP computer system that was scheduled for this weekend has been delayed again. Ashley O'Shea, a spokesperson for the Executive Office of Health and Human Services, ...
State delays software upgrade of UHIP systemTurn to 10

all 34 news articles »

512tech.com

Austin logistics software firm Convey lands $10 million to break into new markets
512tech.com
Convey, whose software platform helps online retailers manage shipping logistics, has raised $10 million to break into new markets. The Austin-based company received the funding from Silverton Partners, Techstars Venture Capital Fund, RPM Ventures, ...

and more »
Google News

Guide to Software Marketing

Intro This concise article will tell you in plain English... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

25 Things Mapping Software Can Do For You

1. With mapping software you can create a report that... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

The first topic we are going to discuss... Read More

Microsoft CRM for Large Corporation ? Security

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

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

Microsoft bought Navision, Denmark based software development company, along with... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Microsoft CRM: Implementation, Customization, Support ? Consultant Overview

Microsoft Business Solutions CRM is present several years on the... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

Importance of Coding Standards

Programming Help for BeginnersWe write programs to instruct computers. When... Read More