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
|
|
|
Tools For Customizing Great Plains
Microsoft Business Solutions ? Great Plains has captured the US market with its integrated business applications for small and mid-size organizations. Its comprehensive accounting and business management capabilities provide businesses with tools to customize various modules of the Great Plains software. These tools have been proven to have contributed to business growth and tighter control over its processes.There are several ways in which customization and integration can be applied to Great Plains applications because of its open architecture characteristic. Integrity of data and performance of processes can also be validated using one of the many tools as listed ...(related: Software)
Microworld Releases New Version Of Mailscan Ver. 4.5 - Antivirus And Content Security Software
MicroWorld Technologies, Inc. the leading solutions provider in the area of Anti-virus and Content security, has announced the launch of its new version of MailScan Ver. 4.5,the antivirus and content security software for mail servers.The new version of MailScan provides additional security features to allow users to monitor the TCP connections on their systems, and use enhanced Anti-SPAM con...(related: Software)
Microsoft Crm Modification ? Overview For It Specialist
Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision.If you are programmer or database administrator who is asked: how do we modify Microsoft CRM ? read this article and you will have the clues for further research.1. Microsoft CRM SDK ? this is software development kit with C# and partly VB.net code samples ? i...(related: Software)
An Introduction To .net Framework
.Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe. These web-applications adopt open s...(related: Software)
Database Guru James F. Koopmann Reviews Dbxtra Reporting And Query Tool
DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base.With the ability to connect to multiple databases or data sources at the same time, DBxtra allows for cross platform data aggregation and the ability to answer questions that would typically take IT time to migrate data into a single reporting database. Through powerful query and filtering mechanisms users have the ability to browse and achieve fine grained retr...(related: Software)
Microsoft Great Plains Payroll Module Customization Scenarios
It is now common thing when large corporation selects mid-market ERP or so-called standard functionality MRP solution as its corporate accounting system. Microsoft Business Solutions Great Plains is very good candidate. As all MBS ERPs it has MS SQL Server 2000/2005 database platform and allows you to deploy customizable and altered solution, serving large corporation HR department. If you use US / Canadian Payroll module as paycheck solution for internal employees ? you probably don't need custom logic. In this small article we'll show you the way of tailored integrated solution for nation-wide placement agency.? The Market. There is huge placement market in healthcare...(related: Software)
Software Process Improvement -a Successful Journey
Background:For many organizations like ours, the interim target of achieving ISO 9001 or CMM levels ...(related: Software)
Passwords Used In Microsoft Word Documents
You would like to protect your documents, wouldn't you? Reasons may vary but the problem is the same ? you need to protect your Microsoft Word documents from unauthorized editing or viewing. What document protection features does Microsoft® Office Word 2003, a part of Microsoft Office Professional Edition 2003 provide?Microsoft Word features for document protection. Microsoft Word offers t...(related: Software)
Getting Technical Support Help Online
Sometimes your PC will start acting strange for no apparent reason or a programwhich you use regularly will all of a sudden stop working as it should. Thiscan be a frustrating experience especially if you have no idea where to go forhelp. If this happens to you, don't panic! Here are some simple tips which mayturn your frown upside down.1. Don't assume that ...(related: Software)
Daffodil Db: Web Database
What is a Web Database?A web database is a database for the internet. You can get access to your data via the internet from anywhere in the world. Or, you can create a database driven website by using such databases. A web database stores large amount of information in an organized format that is easily accessible from scripting languages (like PHP).In web databases, modifications, like the ones constantly used by e-commerce sites, for example, can be performed without any hassles .That makes the dense editing of the html code obsolete. Repeated types of data, like contact information, can be generated automaticall...(related: Software)
Keeping Track
One of the things we can be as certain of as death and taxesis that in every meeting at least one person will hand out adocument for comments and discussion.But think of the huge workload this gives rise to for theauthor. She can only hope that not too many people respond, orthat they don't all do so at once!But there's another way...Microsoft Word has a nice feature called tracking. When you go through adocument by hand, you cross words out here, insert a linethere -- but of course the original document is still visible,no none of the changes is irrevocable.Word has exactly thesame facility:Go to tools - and now when you delete a word it doesn'tdisappear, a red line is p...(related: Software)
Anti-spyware Protection ? Holes In The Shining Armor
Looking at all the ads which promise to get rid of all spy programs, one may wonder why there is still plenty of them everywhere and the situation is by no means getting better. So let me spoil the advertisers' mood and show some of the "holes" in the majority of software products we expect to protect our data.Speaking about drawbacks of anti-spyware, let's take the word "spyware" in the narrow sense for a change and call "spyware" only software products that really spy, i.e. steal valuable information you want to keep private. Let's leave aside adware -- this motley crew of advertising stuff; information that some of them "steal" isn't valuable enough. It is ...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software