EVALUATION OF EXISTING TECHNOLOGY



Database & Application Migration

Questionnaire

ISV NAME

ISV Application Name

Date

PARTNER TECHNICAL SERVICES

Version: 1.0

Copyright 2002, Oracle Corporation, All rights reserved

Usage Guidelines:

This worksheet is to be used for documenting an Oracle ISV’s application architecture, infrastructure and technical requirements so that an educated estimate can be made for how long it will take to migration/port the database and application to an Oracle architecture.

Audience:

Technical Architects, Lead Designers, Business Analysts, Lead Developers, Lead DBAs.

Contact Information:

Name ___________________________

Title ___________________________

eMail ___________________________

Phone ___________________________

General Application Information Worksheet

|Application : |

|Name of the Application ( Abbreviation): |

| |

|General Application Description ( Brief Value Proposition): |

| |

|Is your application aligned with any specific industries ( Telecommunications, Government, Utilites etc ) |

| |

|Application Category ( Online Transaction Processing, Data Warehousing, Hybrid ): |

| |

|What types of users access your application? ( Back office, front office, self service, general public ): |

| |

|How much customization does your application require for each new implementation? |

| |

|Is your application multilingual? |

| |

|How do you handle application and infrastructure version changes for your customers? |

| |

|Application deployment architecture ( Client/Server, Web based ): |

| |

|n-Tier configuration ( 2 Tier, 3 Tier, Specify partition criteria ): |

| |

|TP monitor being used (If any) |

| |

|What is the primary development, deployment platform for the database? |

| |

|Does the Application support databases from multiple vendors? Please specify. |

| |

|What is the primary development, deployment platform for the application server: |

| |

|Does the Application support application servers from multiple vendors? Please specify. |

| |

|What development tools and methodologies do you use to develop your application? |

| |

|What are the operating systems that your application supports? Please specify. |

| |

|What other vendors’ products does your application integrate / interface with? |

| |

|Are there specific considerations within your Application to support Performance, Availability, Scalability and Serviceability?? |

| |

Future Intentions Information Worksheet

|Application: |

|What major changes are you planning for your application in future releases? |

| |

|What new technologies are you planning to adopt? ( Web Services, wireless device support, portal, etc ) |

| |

|What additional Oracle technologies do you plan to adopt? |

| |

|Are you planning to deploy your application in an online hosting mode? |

| |

|What new applications are you planning to develop? |

| |

|Do you have plans for any future Proof of Concept projects? |

| |

|What is the Integration Strategy for the Application ( Enterprise Application Integration, B2B ) |

| |

| |

Detailed Application Architecture/Infrastructure Worksheet

|Existing Resources/Infrastructure/Technology |Name/Value |Additional Info. |

|Client Tier |

|Application Programming Technology(s) used? (Applet, Plug-in, Script, Thick Java Client, C++, C, VB,| | |

|Delphi, PowerBuilder etc) | | |

|Deployment requirements? (Browser dependency, plug-in etc) | | |

|Protocol(s) used to communicate with Application Server Tier? (HTTP(s), IIOP, RMI, SOAP, SQL*Net, | | |

|RPC, etc) | | |

|Client Code deployment mechanisms (if required)? (Physical distribution, Java Web Start, etc) | | |

|What types of devices does your application support? ( Web browsers, desktops, wireless devices, | | |

|PDA’s, etc ) | | |

| | | |

|Application Server Tier(s) |

|General Application Server usage. Mention products used in each of the following categories: | | |

|HTTP Server | | |

|Caching Technologies | | |

|J2EE Server | | |

|Portal | | |

|Reports Server | | |

|Integration / Middleware | | |

|Unified Messaging Server | | |

|Business Intelligence Server | | |

|Wireless Server | | |

|Single Sign On Server | | |

|Application Programming Language(s) used? (Java, C, Perl, etc) | | |

|Presentation Technologies used? | | |

|Servlet | | |

|Java Server Pages | | |

|Active Server Pages | | |

|PL/SQL Server Pages | | |

|Application Logic Technologies used? | | |

|Enterprise Java Beans | | |

|CORBA | | |

|DCOM | | |

|Which of the following Enterprise Java Bean technologies are used: | | |

|Session | | |

|Container Managed Persistence | | |

|Bean Managed Persistence | | |

|Message Driven | | |

|Does your application adhere to the J2EE specification ( no use of proprietary extensions ) | | |

| | | |

|Middleware Technologies used? | | |

|O-R mapping or persistance tools used. ( Toplink, BC4J ) | | |

|Caching | | |

|Single Sign On | | |

|Legacy system adapter connectivity tools | | |

|Management / Infrastructure Technologies used? | | |

|Database Management Tools | | |

|Scheduling software | | |

|Scripting languages ( Tcl /Tk ) | | |

|Monitoring utilities | | |

|Application Server Clustering? ( EJB, Load Balancing, Failover, etc ) | | |

|Application Tier Partitioning? (Compute vs. Data Intensive Logic) | | |

|Other Information regarding Tiers (Specify) | | |

| | | |

|Online Service Specific Architectural Considerations |

|Infrastructure supports Multiple Companies per Instance? | | |

|How is Data Segmentation accomplished? (Application Code, Virtual Private Database) | | |

|What Security is in place to ensure secure data segmentation? | | |

| | | |

|Software Engineering Considerations |

|Software Development methodology used? ( Agile, Extreme, WISC, RUP, SASD, etc ) | | |

| | | |

|CASE Tools used? If so, what specific artifacts are produced? List by application tier ( database,| | |

|app server, client etc) | | |

| | | |

|Modelling languages used? (UML etc) If so, what specific artifacts are modelled? | | |

|IDE used? (JDeveloper, Forms, PowerBuilder, etc) | | |

| | | |

|Leveraged Frameworks? (BC4J, Struts, MVC, etc ) | | |

| | | |

|Leveraged Component Technologies? (COM, DCOM, .Net, CORBA, J2EE, Web Services etc) | | |

| | | |

|External Integration Capabilities |

|Event System in Place? | | |

|Messaging System? | | |

|Standard Naming Service? | | |

|Data Transformation Technology? | | |

|Directory Services (Oracle Internet Directory, Active Directory, iPlanet ) | | |

|Workflow System? | | |

|Security Considerations |

|Standard Outside Authentication (LDAP, JNDI) | | |

|Authorization Model (programmatic/declarative, data level) | | |

|Encrypted Data Transfer between Tiers? | | |

General Data Interface Layer Worksheet

|Data Access features being used in your current data interface layer. |

|Data Access method being used. (ODBC, JDBC, SQLJ, ADO, DAO, OCI, PRO*, PL/SQL, etc) |

| |

|Database Connection and session management |

| |

|Stored Procedures? (Java, PL/SQL) |

| |

|What type of SQL Statements are used? Static/Dynamic SQL |

| |

|Do you use large objects (e.g. BLOB/CLOB/BFILE) or Object data types or other user-defined data types? |

| |

Oracle Database –Configuration Information

|Database: |Name/Value |Comments |

|Database used (Oracle / DB2 / SqlServer etc.) | | |

|Database Release ( 8.1.7, 9.0.1 etc ) | | |

|Database version (Standard/Enterprise) | | |

|Approximate database size (in MB/GB/TB - please indicate) | | |

|# of Users (Concurrent and/or Batch) | | |

|# of Tables / Views | | |

|# of Procedures and Packages | | |

|# of Triggers | | |

|Optimizer mode in use? (COST / RULE / CHOOSE) | | |

|Is the database auditing enabled? | | |

|How is uniqueness generated for database rows? (natural keys, timestamps, database sequences, etc) | | |

| | | |

|How is referential integrity enforced? (triggers in the database, database integrity constraints, | | |

|application coding, etc) | | |

| | | |

|Database features in use (replication, security, clustering, object database features, etc.): | | |

| | | |

| | | |

|Additional Information |

|Specify any application or development issues or additional information here. |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download