Advertisements
Netezza / PureData Table Documentation Practices
Applying a few table effective practices can:
- Significantly aide others in understanding the purpose and use of tables and column fields
- Provide more migratable meta data to inform and enable the capabilities of other tools
- And, from a self-preservation point of view, reduce the number of meetings, emails, and phone required to explain and clarify what the table and fields business meaning and roles
Among the Effective practices when modeling and design tables are:
- Add Primary Key
- Add table comments
- Add column field comments
- Add ‘Organize by’ fields to provide essential optimization on frequently used and/or key performance fields
One thought on “Netezza / PureData – Table Documentation Practices”