Skip to content

Scientia Compendium

A collection of information technology, consulting, and business knowledge

  • Home
    • About
  • Linux
  • Cloud Computing
  • PeopleSoft
  • Salesforce (SFDC)
  • Data Warehouse
  • Infosphere
  • Systems Development Life Cycle (SDLC)
    • Data Modeling
    • Design
    • Develop
    • Test
    • Sustainment
  • Career Management
  • Databases
    • Structured Query Language (SQL)
    • DB2
    • Netezza
    • Oracle
    • MySQL
    • Salesforce (SFDC)
  • Published Works
    • Leading Virtual Meetings: Methods and Effective Practices
    • Life is Not Fair, and Life is Not Kind, Life is an Opportunity
    • Empowered
  • Blogging
  • Quotes
  • Useful Technical Links and References

Tag: Table Effective Practices

Netezza / PureData – Table Documentation Practices

  • Netezza / PureData Table Documentation Practices
    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

Related References

  • Netezza / PureData – How to add comments on a table
  • Netezza/ PureData – how to add a primary key
  • PureData – Table Effective Practices

Share this:

  • Tweet
  • Print
  • Share on Tumblr
  • More
  • Telegram
  • Email
  • WhatsApp
  • Pocket

Like this:

Like Loading...
Posted on February 17, 2017August 26, 2019 by Bert SwopePosted in Alter, Best Practice, Comment, Computer Science, Data Architect, Data Definition Language (DDL), Data Integration, Data Modeling, Data Warehouse, DataBase Management Systems (DBMS), Databases, Design, Designer, Develop, IBM, Information Integration, Information Science, Information Systems, Information Technology, Infosphere, Metadata Asset Manager, Netezza, Practice, PureData, Relational Database Management Systems (RDBMS), Science and Information Area, Science Of Science, Software Engineering, Structured Query Language (SQL), Systems Development Life Cycle (SDLC)Tagged #BestPractice, #dataanalytics, #dataarchitect, #databaseadministration, #DatabaseAdministrator, #DatabaseDesign, #DataClick, #DataGovernance, #DataIntegration, #datamodel, #datamodeling, #datawarehouse, #InformationManagement, #informationserver, #Informationtechnology, #IT, #UML, 7.0.x, 7.1.0.x, 7.2.0.x, 7.2.1, 7.2.x, aginity netezza workbench, ample, basic sql table design, Best Practice, best practices, best practices for sql table design, big Data, BigData, BigSQL, DashDB, Data, Data Analytics, Data Architect, Data Click, Data Governance, Data Integration, Data Model, Data Modeling, Data Warehouse, data warehouse table design, Database Administration, Database Administrator, Database Design, database table design best practices, Databases, DataQuality, Datastage, DB2, DBA, design best practices, edit sql table design, Effective Practice, Effective Practices, efficient sql table design, ELT, ETL, FK, Foreign Key, how to change sql table design, IBM, IIS, Information Managment, Information Server, Information Technology, Infosphere, Methodology, Netezza, netezza aginity, netezza best practices, netezza effective practices, netezza ibm, netezza SQL, PK, Practice, Primary Key, PureData, PureData Table Documentation Practices, PureSystems, Relational Database Management Systems (RDBMS), sql alter table design, sql command for table design, sql database table design, sql database table design best practices, sql design a table, sql modify table design, sql performance table design, sql select table design, sql self documenting table design, sql table design, sql table design best practices, sql table design e, sql table design guidelines, sql table design patterns, sql update table design, Standard Practice, Structured Query Language (SQL), table design for sql, table design in sql, table design primary key, Table Documentation Practices, Table Effective Practices, Tech, Technology. 1 Comment

Categories

Translate

Follow Scientia Compendium on WordPress.com

Enter your email address to follow this blog and receive notifications of new posts by email.

Links

  • My books on Amazon
  • The Homestead Gardener
  • Writing and The Written Word

Resources

  • Aginity Workbench for PureData /Netezza System for Analytics – Useful links
  • Infosphere Datastage – Useful Links
  • Oracle Database – Useful links
  • PureData / Netezza – Useful links
  • Useful Links – AIX
  • Useful Links– Linux
  • Useful Tools for Technical Consultants and Developers

Recent Posts: Writing and The Written Word

Poetry – December

Quote – A Book Is Best Understood

Quote – The help of good counsel

Poetry – A Recollection

Quote – Doing The Work Yourself

Recent Posts: The Homestead Gardener

The Benefits of Eating Frozen Fruit and Vegetables

Recipe – Homemade Parsnip Soup

Shortcut Key Lime Pie

Quote – The gardener’s business

Why House Cats Love Cardboard Boxes So Much

Social

  • View @ScientiaCmpndm’s profile on Twitter
  • View albertswope’s profile on LinkedIn
Blog at WordPress.com.
Cancel
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: