OLTP? Not a data warehouse?

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #350,934

by S1mon_Jester

11/19/11 7:18:23 PM

OLTP? Not a data warehouse?

Post #350,996

11/21/11 1:42:43 PM

Re: OLTP? Not a data warehouse?

The 400 column table I, personally, saw in production was from a data warehouse. The 1190 column table is from another team's effort at building a warehouse.

Interestingly, PostgreSQL was a good pick:

Max Columns per table of selected db servers
--------------------------------------------
DB2 UDB Max Columns per table: 1012
Oracle Max Columns per table: 1000
MS Sql Server Max Columns per table: 1024
PostgreSQL: 1600

Database Question. - (mmoffitt) - (11) - Nov. 18, 2011, 02:06:51 PM EST

Wow... that was deviant! - (folkert) - (8) - Nov. 18, 2011, 02:19:44 PM EST

Heh. - (mmoffitt) - (7) - Nov. 18, 2011, 03:03:15 PM EST

*Boggle* is entirely appropriate. - (static) - (6) - Nov. 18, 2011, 06:48:24 PM EST

Better than this - (drook) - (1) - Nov. 18, 2011, 10:39:31 PM EST

I guess I'm lucky. - (static) - Nov. 19, 2011, 06:26:45 AM EST

I agree on the 200. - (mmoffitt) - (3) - Nov. 19, 2011, 09:45:21 AM EST

What is your update schedule? And will you be coding in it? - (crazy) - (2) - Nov. 19, 2011, 11:19:23 AM EST

Nope. Happily I will not be directly involved in any of it. - (mmoffitt) - (1) - Nov. 21, 2011, 01:40:13 PM EST

Smart move -NT - (crazy) - Nov. 21, 2011, 05:21:52 PM EST

OLTP? Not a data warehouse? -NT - (S1mon_Jester) - (1) - Nov. 19, 2011, 07:18:23 PM EST

Re: OLTP? Not a data warehouse? - (mmoffitt) - Nov. 21, 2011, 01:42:43 PM EST

We are trying to save children from evil forces. This wisdom tooth is not a good sign.
69 ms