Software Information |
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
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Do You Want Your Own Fully Programmable ERP? - Part 1 We are in a transition phase in the Managerial Administration models of any company or Government, because three factors are summing for that:The new powerful business Information Technologies and its more and more smaller costs, like ERP, CRM, BI, etc.,The creativity of the new MBA to generate value and its corresponding engineering - for example, Feedback Control System - in the administrative and managerial fields,Several different layers in the companies in what refers to its managerial and administrative automation levels. Microsoft CRM Programming Secrets - Tips For Developers This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job. Microsoft Great Plains: Offshore Customization & Development - Overview for Consultant When you visit department stores and see that majority of the apparels are produced in other countries, not US - you probably do not worry about this fact. About 10 years ago, when Clinton's high tech era was at the inception - we saw the signs of high tech professionals inflow in the USA from overseas. Microsoft Great Plains Partner Selection: Overview Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business Solutions ERP applications, serving to the whole spectrum of vertical and horizontal markets. Assuming that you already have one of these systems installed and implemented we would like to give you - IT director, Database Administrator, Programmer, Software Developer, Controller your options in supporting/upgrading Microsoft Great Plains for your companyIt is always good idea to install everything on your own - however Great Plains requires combination of computer networking, some programming, good accounting/distribution/logistics/reporting background - so it is not a surprise that Microsoft Business Solutions requires their customers to have specially assigner Microsoft Great Plains Partner/VAR/Reseller to serve the account. Microsoft Great Plains Integration with Microsoft Access - Overview for Developer Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market. At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM. Internet Faxing Service Review The Internet is reshaping every form of communications medium, and faxing is no exception. The latest twist: Internet faxing services that let you send messages to any fax machine from any Web browser or email, and others that give you a "personal fax phone number," then forward any documents sent there to your e-mail inbox. Removing Incoming Email in MS Exchange, C# Example The purpose of one of our projects was MS Exchange handler for processing incoming email.The basic source of knowledge was this article "Developing Managed Event Sinks/Hooks for Exchange Server Store using C#" by Logu Krishnan, published to the address http://www. Professional Software Icons For Your Standalone Application User interfaces and accessibility are some of the most important aspect of an application. It can have a million features, it can do a thousand things once, but if it doesn't look quite right then it will be a disaster. Benefits of Shareware Shareware has been fighting the stigma of being misunderstood for decades. While corporate software giants can no longer ignore the marketing potential of a trial version, small software startups are struggling with new listings and bandwidth costs. Microsoft Great Plains RW: Report Writer Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Report Writer (RW) module allows for modification and creation of Great Plains reports to suit your business needs. eConnect: eCommerce Development for Microsoft Great Plains Microsoft Business Solutions Great Plains has several options to enable web ordering. Traditionally Great Plains Dynamics/eEnterprise had eOrder - this is ASP pages based ordering application, enabling you to place or retrieve your Sales Order Processing (SOP) Sales Orders over the web. Microsoft and Webmasters Does Microsoft care for WebmastersIt's always been a problem with websites appearing exactly the same on different platforms. As a web developer / webmaster it is extremely difficult to make user experiences rich by having the site look the same in any OS / Browser. C++ Tutorials: 3, Program Flow (If, Else, While, For) Program Flow is what you think it is. How the program will flow. Make or Break Factors - When Considering Estimating Software Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can prove to be a major factor in the success or failure of their business.When a customer requests a bid on a job, they need a fast turnaround, and the best price. Razzle Dazzle Them Once upon a time not so long ago, there was a little boy who went to the market to try to sell his wares. He wasn't having any luck. Linux Secrets The first thing that you will notice about Linux Red Hat (using the Gnome Interface) is that it looks a lot like Windows 95/98/NT. But that's where the similarity ends. Falling in Love With More Than One Screensaver: The Fun Part Having from five to ten and more favorite screensavers is cool. But how do you enjoy them all in a straightforward and convenient way? Draw the power you need from the little yet useful tools discussed in this article!As you remember, earlier in my article What to Do if You Fall in Love With More Than One Screensaver we discussed the standard way of switching between multiple screensavers. Where to Find Free Fleet Maintenance Software Costs of fleet maintenance software can vary widely. It is generally expected that the fleet manager will look at the needs of the company to determine what software package is best suited for their particular needs. Demand More From Your Lead Tracking Software An integral part of any quality CRM system is lead tracking software. This is the part of the system that helps you gather customer data from your sales force. Free Preventive Maintenance Software While several preventive maintenance software manufacturers offer free trials for their products before charging a fee, some companies offer their products for free. Free preventive maintenance software is rare, and is sometimes less thorough than software that must be purchased, but it can be a good solution for a new or struggling business. |
home | site map | contact us |