What are redundant structures in Databases?

Question

What are redundant structures in Databases?

Minnesota - Viking

Hall of Fame

Points: 3469
More actions
May 9, 2010 at 9:27 pm

#386888

I have an interview coming up
One of the areas i will be question upon is "Redundant Structures"?
Can some one tell me what are they ? Any resource where i can study them ?
Tried googling and searching through forums 🙁 didnt work
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

No idea, it's not a standard SQL term or definition. I'd ask for more details.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 2

Here are the only things I could find

A structure with extra internal load paths or external supports in excess of the minimum required for stability.

it seems like it could be a way of talking about denormalization. I agree though it sounds like a home grown term

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field

Minnesota - Viking Hall of Fame Points: 3469 More actions · Answer 3

@@Gail.. Thank You

@@Bradley: Yupe.. i too guess it should be near to Denormalization.

Anyways i will update you if i attend this interview.

[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 4

Z@f (5/9/2010)
... will be question upon "Redundant Structures"

This expression applies to optimization structures in large environments like multitera byte data warehouse, such structures come in two flavors which are non-redundant and redundant.

A good example of each one would be...

non-redundant... table partitioning.

redundant... materialized views.

As you can see redundant structures originate redundant data while non-redundant structures doesn't.

Hope this helps.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Jeff Moden SSC Guru Points: 1003965 More actions · Answer 5

~~Heh... I wonder if "redundant" refers to mirroring, clustering, replication, etc.~~

{edit} Heh... never mind. Simple GOOGLE search gave me more answers about "Redundant Structures" that I'm embarassed. I searched for...

"Redundant Structures" SQL SERVER

Another good interview question might be "As a DBA or SQL Developer, how would you find out what 'Redundant Structures' are as they pertain to SQL Server." 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)