Methods and apparatus for generating a database layout

摘要

Methods and apparatus are provided for generating a database layout. A layout for a database is generated by receiving a user specification of a database vendor, purpose and environment for the database; receiving a user configuration of layout options for the database in a context of the given database vendor and purpose and for an indicated protection type; receiving a user selection of a storage profile for the database; and determining a correct size and product model for storing the database with the configured layout based on a quantitative profile factor assigned to the database vendor, purpose and environment and a quantitative layout factor assigned to the protection type. The quantitative profile factor can be based on a target layout complexity factor. The quantitative layout factor can be based on whether specified file types need to be stored on one or more tiers of a tiered storage system.

主权项

1. A method for designing a layout for a database, comprising:
receiving a user specification of a database vendor, a business data purpose and an environment for said database; receiving a configured layout from a user comprising a user configuration of layout options for said database to identify a predefined recommended layout for said given database vendor and said business data purpose; receiving a user selection of a storage profile for said database; comparing said configured layout and said predefined recommended layout to assign a target layout complexity factor indicating a degree of match between said configured layout and said predefined recommended layout; determining, using at least one hardware device, a size and a product model for storing said database with said configured layout based on a quantitative profile factor assigned to said database vendor, said business data purpose and said environment by at least one hardware device and a quantitative layout factor assigned to said protection type by at least one hardware device, wherein one or more components of said quantitative profile factor are weighted by said target layout complexity factor; and providing said determined size and said determined product model for storing said database with said configured layout.