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

Clubhouse nets $10m Series A from Battery Ventures to make software development fun again
TechCrunch
People often describe work as a rat race, but for a lot of engineers, that isn't too far off. Take one Jira ticket off the queue, fix the bug or add the feature, mark the ticket as complete and move as quickly as possible to the next ticket ...

and more »

Forbes

Generous 401(k) Matches Helped Scott Scherr Build The Ultimate Software Stock
Forbes
Over the past decade, few companies have performed as well as Ultimate Software, a payroll and human resources software seller, and done so with less fanfare. Yielding a 20% annualized return since 2007, Ultimate Software has become the ultimate mid ...


AnandTech

AMD Releases Radeon Software Adrenalin Edition: Overlay, App & More for 2017
AnandTech
A few weeks ago, AMD took the courtesy of revealing the name (and nothing else) of their upcoming 2017 major feature update for Radeon Software. But today, the totality of AMD's Radeon Software Adrenalin Edition is finally upon us. Succeeding Crimson ...
Meet Radeon Software Adrenalin Edition: AMD Link mobile app ...PCWorld
AMD unveils Radeon Adrenalin graphics software update with mobile appVentureBeat
AMD Radeon Software Adrenalin adds in-game overlay, mobile app ...PC Perspective
Hot Hardware -Tom's Hardware
all 33 news articles »

Spaceman Shuttleworth Finds Earthly Riches With Ubuntu Software
Bloomberg
... so there is opportunity there for somebody to come in and fill those gaps,” said Tim Klasell, Senior Research Analyst at Northland Securities. “Those gaps have become big enough because Linux has become big enough.” Red Hat Inc. is the biggest ...

and more »

The Register

Fruit of an acquisition: Apple AI software goes open
The Register
Apple's joined other juggernauts of the tech sector by releasing an open source AI framework. Turi Create 4.0, which landed at GitHub recently, is a fruit of its 2016 US$200 million acquisition of Turi. As the GitHub description explains, it targets ...


Lansing State Journal

Michigan state employees question progress on new software system
Lansing State Journal
LANSING – Several Michigan state government employees and their unions are questioning reported progress in fixing glitchy new budgeting software that has delayed parts of paychecks to an unknown number of state workers. Gov. Rick Snyder's ...


Big Think (blog)

New DNA-Scanning Software Can ID You in Minutes
Big Think (blog)
Imagine a security system, say a key card scanner, an airport security checkpoint, or a pass code based on your DNA. That'd be really hard to hack. It sounds like science fiction. But researchers at Columbia University, along with colleagues at the New ...


WolfPAC Simplifies Risk Management with New Software Release
PR Newswire (press release)
BOSTON, Dec. 12, 2017 /PRNewswire/ -- WolfPAC Integrated Risk Management has launched their new platform "WolfPAC 4.0". The platform is designed for risk managers at organizations in heavily regulated industries, like financial institutions. With this ...

and more »

RingCentral -1.4% as part of JPMorgan's software downgrades
Seeking Alpha
Business communications firm RingCentral (NYSE:RNG) is 1.4% lower, caught up in a rack of software downgrades at JPMorgan. The analysts cut ratings on more than a dozen firms, saying they significantly outperformed the S&P 500 this year and are all ...

and more »

Packaging World

Beckhoff Automation: Vision software
Packaging World
Beckhoff Automation has announced the incorporation of comprehensive image processing capabilities into its PC-based control system with new TwinCAT Vision software, which unites a comprehensive range of machine functionality – PLC, motion control ...

and more »
Google News

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

Reloading Windows XP

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

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

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

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

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

Save Your Resources - Combine Your IM Clients

There are so many different programs that clutter up your... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

Microsoft CRM Implementation ? Fundamental CRM Principles Revision

Microsoft CRM is relatively new player on the now becoming... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph... Read More

Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More

Guide to Software Marketing

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

Microsoft Small Business Manager Customization Options - Overview

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

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail... Read More

Design a Web Album Using Adobe Photoshop- Part 2

So let's begin crunching down these 300 images using Adobe... Read More

C++ Tutorials: 3, Program Flow (If, Else, While, For)

Program Flow is what you think it is. How the... Read More

Backing Up And Restoring Your MySQL Database

If you've been using MySQL database to store your important... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

.NET :Solving the Multiple Inheritance Issue Under .NET Platform

.NET platform does not support multiple inheritance. Do not confuse... Read More