Quote – Doing The Work Yourself

Writing and The Written Word

The wise man will commit no business of importance to a proxy when he may do it himself.

— Roger L’Estrange

View original post

Denodo Model Best Practices For Creation of Associations

What Are Denodo Associations?

In denodo associations follow the same concept as modeling tools, which can be described as an ‘on-demand join.’

Where Should Associations Be Created In the Denodo Model?

You don’t necessarily need to define an Association at every level; usually, the best practice is to apply associations at the following points:

  • On final views published for data consumers, indicating relationships between related views; Especially, on published web services.
  • On the component views below, any derived view that brings together disparate (dissimilar) data sources.  The associations should be defined as Referential Constraints whenever appropriate to aid the optimization engine.
  • On the component views below, any derived view that joins a “Base View from Query” with standard views, since Base Views from Query cannot be rewritten by the denodo optimization engine.  Often Base Views from Query create performance bottlenecks.

These best practices should cover the majority scenarios; beyond these guidelines, it is best to take an ad-hoc approach to create Associations when you see a specific performance/optimization.

Why Are Associations important in Denodo?

In a nutshell, associations performance and the efficiency of the denodo execution optimizer along with other model metadata, such as:  

  • The SQL of the view(s)
  • Table metadata (Table Keys {PK, FK), Virtual Partitions…etc.)
  • Data statistics, which are used by the Cost Based Optimizer (CBO)

Related References

Associations in Denodo

Importing Associations And Joins From A Database Schema in Denodo

A coworker recently asked a question as to whether denodo generated joins automatically from source RDBMS database schema.  After searching, a few snippets of information became obvious.  First, that the subject of inheriting join properties was broader than joins and needed to in modeling associations (joins on demand). Second, that there were some denodo design best practices to be considered to optimize associations.

Does Denodo Automatically Generate Joins From the Source System?

After some research, the short answer is no.

Can Denodo Inherit Accusations From A Logical Model?

The short answer is yes. 

Denodo bridges allow models to be passed to and from other modeling tools, it is possible to have the association build automatically, using the top-down approach design approach and importing a model, at the Interface View level, which is the topmost level of the top-down design process. 

However, below the Interface view level, associations and or joins are created manually by the developer.

Where Should Associations Be Created?

You don’t necessarily need to define an Association at every level, usually, the best practice is to apply associations at following points:

These best practices should cover the majority scenarios, beyond these guidelines it is best to take an ad-hoc approach to create Associations when you see a specific performance/optimization.

Related References

Associations in Denodo

What is Power?

Writing and The Written Word

First and foremost, power is personal. Our perception of a situation has much to do with our ability to affect a situation. Therefore, power is each person’s ability to influence a situation. When a person has no ability to influence their situation (even, if as a result of an inaccurate personal belief), they have no power.

Definition of Power

Power is each person’s ability and willingness to influence a situation.

View original post

The Law of Power

Writing and The Written Word

The Law

The fundamental law of power is that it is situational, multifaceted, dynamic, and perishable.

Power is Situational

Power is without a doubt situational, a person who is very politically powerful, but having no wilderness knowledge or skills, find themselves alone in the middle will have less ability to save themselves, than an experienced woodsman.

Power is Multifaceted

Power has many attributes (social influence, mental reference, innate ability, and situation), which aggregate to provide the total of your power at in given time and in any given situation

Power isDynamic

As a person’s situation changes, their ability to influence the situation can be increased, decreased, and/or lost. Also, facets of power are not static but are morphed by change.

Power isPerishable

A person can, through inaction, lose the ability to influence a situation forever.

View original post

Success – You must love your work?

Writing and The Written Word

Why you should love your work

Sooner or later you will wonder why you are not passionate and energized about your work. At the same time, an inner voice will tell you to suck it up because work is only a four-letter word and you are not supposed to enjoy it.

It is a misconception because loving your work can bring manage benefits. Work should enable and empower, not entrap. Here we have some of the reasons why you should love your work.

Helps with your success

When you love your career, no one can stop you from getting successful. You will do everything that it takes to assure that your customers love what you are offering, and your boss appreciates your every move. You would prefer to collect the appreciation because your every move will be well planned, and you will not be afraid…

View original post 1,764 more words

Quote – There are no secrets to success

Writing and The Written Word

There are no secrets to success. It is the result of preparation, hard work, and learning from failure.

— Colin Powell

View original post