Creating Reference Architectures

PowerDesigner provides a wizard to let you generate one or more reference architectures appropriate for your IQ environment, each based on a different hardware profile. The resulting diagram and objects detail the costs and specifications for all the elements required for each reference architecture.

1. Select Tools > Sybase IQ Reference Architecture > Launch Advisor Wizard to open the wizard.
2. Click Next to go to the Data Models page, and use the Select Data Models tool to add a PDM from the workspace or the Select Data Models from Files tool to open a PDM:
   
   
   
3. Click Next to go to the Database Size page, and specify the number of years growth for which you want to estimate. To review and edit table row counts and growth rates, click the Table Size Details link. When you are satisfied with your figures, click the Estimate button to produce an estimate of the overall size of your database at the end of the specified number of years:
   
   
   
4. Click Next to go to the Query Requirements page, and specify the number of queries of each type that you anticipate running simultaneously:
   
   
   
5. [optional, v15.3 and higher] Click Add Logical Server to define another set of query requirements. You can add as many logical servers as necessary to accurately represent your environment.
6. Click Next to go to the Load Requirements page. Click the Select Tables tool to specify the most critical tables to load (those which have the largest volumes of changes). Then specify the number or rows that will be loaded in batches, and indicate whether this loading will take place while queries are being run:
   
   
   
7. Click Next to go to the Hardware Profiles page. Click the ellipsis tool to select a candidate machine from the Hardware Profile Library for the coordinator, writer, and reader. You can reallocate part of the DBA, load, and query work between these machines as necessary. Use the System Balance slider to specify the relative importance to you of cost and performance:
   
   
   
8. Click Next to go to the Summary page, which lists the information entered on the preceding pages.
9. Click Finish to generate your environments.
   The Summary page lists the characteristics of the reference architecture, giving the number of nodes and the total cost of the solution. Click Back if you want to change any of your parameters in the wizard.
10. Click Close to exit the wizard and go to the generated diagram:

    Double-click the reference architecture symbol to go to a sub-diagram showing the architecture in detail, with separate symbols for the SAN, coordinator, readers and writers:

    
    
    

    Note: To model additional environments for comparison, relaunch the wizard and specify different hardware profiles.

• Reference Architecture Properties
  To view or edit a reference architecture's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• Database Server Properties
  To view or edit a database server's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• IQ Server Properties
  To view or edit an IQ server's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• SAN Properties
  To view or edit a SAN's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• IQ Store Properties
  To view or edit an IQ store's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• Query Type Properties
  To view or edit a query type's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
• Reference Architecture Model Properties
  A reference architecture model has more properties than a standard EAM.
• Logical Server Properties
  To view or edit a logical server's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.