| Publisher | SAS Institute | ||
|---|---|---|---|
| Format | 204.0KB PDF | Date added | 28 Feb 2006 |
| Topics | Knowledge and Data Management, Database Management | ||
| Downloads | 98 | ||
While formats are more efficient than standard lookup tables for retrieving target values, guidelines still need to be established for building the best possible format from a control data set. More specifically, the guidelines need to link the format as a function where label=f(range) to the format's underlying table as a two-dimensional relation where entities and attributes are identified by primary keys. Fortunately, database cardinality and normalization concepts can be expanded to embrace these seemingly disparate constructs. An identity is established between a mathematic "Function" and database theory's "First normal form" required for format construction. The paper then shows what happens when formats are built that either conform to or fail to meet requirements for second and third normal forms.
Did you find this white paper useful?
27 out of 50 users found this white paper useful
Related white papers
Best Practices for Translating Customer Satisfaction into Revenue
Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a...
Support Strategies: Customer Experience Management
Customer experience is the most powerful tool available today for distinguishing your company from competitors ? each contact with the customer offers an opportunity for strengthening your relationships by delivering...
3 Strategies for Reducing IT Support Costs
As companies brace for more bumps in the economic downturn, many organisations are indiscriminately cutting costs. To ensure a seamless transition into the post-recession market, however, slashing and burning is...
Forrester Strategies for Assessing IT Business Satisfaction
If you aren't assessing customer satisfaction you are overlooking a potential goldmine. This valuable data is crucial to creating a successful IT strategy. But where do you start? This new...
Realising the benefits of going green
Cross over to greener communications with improved data accuracy. Many organisations have processes in place to improve the quality of their contact data to address business drivers, such as cost reduction...
Centrinet case study
Centrinet launched an innovative business service - Smartbunker - based on renewable energy and energy-efficient technology(efficient IBM BladeCenter servers and Cisco networking hardware), It's the UK's first managed data centre...
IBM Virtualization Services
Virtualization is a powerful technology and can have profound effects on the datacenter; however, it should be viewed as a component of an overall IT strategy that will be able...
