Database Administration (MOSC)

MOSC Banner

DB design for billon rows tables

edited Nov 12, 2013 5:24AM in Database Administration (MOSC) 1 commentAnswered
Hi all, We have a requirment to create a database where the two tables would be 60 GB ( 1 billon rows) and 480 GB (13 billion rows) in size at the end of 2016. Presently those 2 tables has just 10 records.

the table structure of 1 billion rows is

TRIP_SUMMARY_ID                                                                                       NOT NULL NUMBER(12)
TRIP_SUMMARY_NBR                                                                                      NOT NULL VARCHAR2(12)
KM_DRIVEN_QTY                                                                                                  NUMBER(6)
DATA_RANGE_START_TS                                                                                   NOT NULL DATE
DATA_RANGE_END_TS                                                                                     NOT NULL DATE
VEHICLE_DEVICE_ID                                                                                     NOT NULL NUMBER(12)
SYSTEM_CREATE_TS                                                                                      NOT NULL TIMESTAMP(6)
SYSTEM_LAST_UPDATE_TS                                                                                 NOT NULL TIMESTAMP(6)

the table structure of 13 billion rows is

BEHAVIOR_SUMMARY_ID                                                                                   NOT NULL NUMBER(12)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center