HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 32

Appendix

Get HP ProLiant 3000 PDF manuals and user guides View all HP ProLiant 3000 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 32 highlights

Appendix A DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers REGION Table Layout Column Name Datatype Requirements R_REGIONKEY identifier R_NAME fixed text, size 25 R_COMMENT variable text, size 152 Primary Key: R_REGIONKEY TIME Table Layout Column Name Datatype Requirements T_TIMEKEY date T_ALPHA MM-DD fixed text, size 10 T_YEAR integer T_MONTH integer T_WEEK integer T_DAY integer Primary Key: T_TIMEKEY Comment 5 regions are populated Comment Number of days since 1-1-1970 Date expressed as YYYYYear expressed as YYYY Number of months since 1-1-1970 Week of the year from 1 to 53 Day of the month © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
Appendix A
DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers
1998 Compaq Computer Corporation, All Rights Reserved
Doc No ECG156/0398
REGION Table Layout
Column Name
Datatype Requirements
Comment
R_REGIONKEY
identifier
5 regions are populated
R_NAME
fixed text, size 25
R_COMMENT
variable text, size 152
Primary Key:
R_REGIONKEY
TIME Table Layout
Column Name
Datatype Requirements
Comment
T_TIMEKEY
date
Number of days since 1-1-1970
T_ALPHA
fixed text, size 10
Date expressed as YYYY-
MM-DD
T_YEAR
integer
Year expressed as YYYY
T_MONTH
integer
Number of months since 1-1-1970
T_WEEK
integer
Week of the year from 1 to 53
T_DAY
integer
Day of the month
Primary Key:
T_TIMEKEY