KudoZ home » English to Spanish » Computers: Software

outrigger tablespace

Spanish translation: tabla de respaldo (o provisional)

Advertisement

Login or register (free and only takes a few minutes) to participate in this question.

You will also have access to many other tools and opportunities designed for those who have language-related jobs
(or are passionate about them). Participation is free and the site has a strict confidentiality policy.
17:32 May 22, 2005
English to Spanish translations [PRO]
Tech/Engineering - Computers: Software / diseño de bases de datos
English term or phrase: outrigger tablespace
es una tabla de conversión de objetos entre un program de base e datos y otro

Index Index
View table View
Fact, dimension, outrigger Table
Target database Current DBMS
Valid value Check parameter
Tablespace Tablespace

no encontré nada a pesar de mis esfuerzos. Agradecería de corazón una piolita.
saludos, P.
P Forgas
Brazil
Local time: 15:49
Spanish translation:tabla de respaldo (o provisional)
Explanation:
Una idea que espero te enfile en la dirección adecuada. Suerte


fox.wikis.com/wc.dll?Wiki~OutriggerTables~VFP
An OutriggerTable is what you get when you normalize a DimensionTable. You would then have a PrimaryKey in the OutriggerTable and a ForeignKey in the DimensionTable. The relation can be Identifying or non-identifying.

It is usually recomended to avoid using Outrigger tables if possible - since it affects query speed.

If the dimension tables are normalized into typical "snowflake" structures, as shown in Figure 2, two bad things happen. First, the data model becomes too complex to present to the user. Second, linking the elements among the various branches of the snowflake compromises browsing performance. Even when a long text string appears redundantly in the dimension table and can be moved to an "outrigger" table, you won't save enough disk space to justify moving it. The fact table is always overwhelmingly the largest table in a star join schema. In many cases, normalization can actually increase the storage requirements. If the cardinality of the repeated dimension data element is high (in other words, there are just a few duplications), the outrigger table may be nearly as big as the main dimension table. But we have introduced another key structure that is now repeated in both tables.
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/dbm...
PortalSQL.COM Tu sitio sobre Sql-Server
... la idea no es usarlo como tabla temporal sino de tabla de respaldo o histórico,
para que queden reflejados como copia todos los insert que hagan en las tablas ...
www.configuracionesintegrales.com/miguele/ responder.asp?idforo=1&idPregunta=2022&pagina=0 - 11k - Resultado Suplementario - En caché - Páginas similares
Selected response from:

Luis Rey Ballesteros (Luiroi)
Local time: 13:49
Grading comment
muchas gracias, fue una indicación buenísima
4 KudoZ points were awarded for this answer

Advertisement


Summary of answers provided
3 +2tabla de respaldo (o provisional)
Luis Rey Ballesteros (Luiroi)


  

Answers


1 hr   confidence: Answerer confidence 3/5Answerer confidence 3/5 peer agreement (net): +2
tabla de respaldo (o provisional)


Explanation:
Una idea que espero te enfile en la dirección adecuada. Suerte


fox.wikis.com/wc.dll?Wiki~OutriggerTables~VFP
An OutriggerTable is what you get when you normalize a DimensionTable. You would then have a PrimaryKey in the OutriggerTable and a ForeignKey in the DimensionTable. The relation can be Identifying or non-identifying.

It is usually recomended to avoid using Outrigger tables if possible - since it affects query speed.

If the dimension tables are normalized into typical "snowflake" structures, as shown in Figure 2, two bad things happen. First, the data model becomes too complex to present to the user. Second, linking the elements among the various branches of the snowflake compromises browsing performance. Even when a long text string appears redundantly in the dimension table and can be moved to an "outrigger" table, you won't save enough disk space to justify moving it. The fact table is always overwhelmingly the largest table in a star join schema. In many cases, normalization can actually increase the storage requirements. If the cardinality of the repeated dimension data element is high (in other words, there are just a few duplications), the outrigger table may be nearly as big as the main dimension table. But we have introduced another key structure that is now repeated in both tables.
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/dbm...
PortalSQL.COM Tu sitio sobre Sql-Server
... la idea no es usarlo como tabla temporal sino de tabla de respaldo o histórico,
para que queden reflejados como copia todos los insert que hagan en las tablas ...
www.configuracionesintegrales.com/miguele/ responder.asp?idforo=1&idPregunta=2022&pagina=0 - 11k - Resultado Suplementario - En caché - Páginas similares

Luis Rey Ballesteros (Luiroi)
Local time: 13:49
Native speaker of: Native in SpanishSpanish
PRO pts in category: 80
Grading comment
muchas gracias, fue una indicación buenísima

Peer comments on this answer (and responses from the answerer)
agree  carlie602
3 hrs
  -> Thanks, Carlie!

agree  Marina Soldati
1 day19 hrs
  -> Thanks Marina!!
Login to enter a peer comment (or grade)




Return to KudoZ list


KudoZ™ translation help
The KudoZ network provides a framework for translators and others to assist each other with translations or explanations of terms and short phrases.



See also:



Term search
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search