Click here to Skip to main content
15,868,141 members
Home / Discussions / Database
   

Database

 
GeneralRe: Product dataabase Pin
DeerBear21-Jul-13 4:00
DeerBear21-Jul-13 4:00 
Mycroft Holmes wrote:
Most OLAP solutions use a different database than the production DB and the data is denormalised periodically (daily) into said OLAP Db.


I am not an OLAP expert, by far, but in the very few experiences I've had where we
needed cubes, I've found that you don't always need another db.

What I am trying to achieve is a middle ground between a complete data
warehouse and a "normal" database. I don't mind, in this resepct, to lose less
meaningful data, as far as the most important data is dealt with appropriately.

I would like to add some new tables, prefixed by OLAP_ so that I know those are
related to my cubes, and do something like this:

CREATE TABLE OLAP_PROD_HISTORY(
    ID            INTEGER NOT NULL,
    PRODUCT_ID    INTEGER NOT NULL,
    VERSION_HIGH  INTEGER DEFAULT 1 NOT NULL,
    VERSION_LOW   INTEGER DEFAULT 1 NOT NULL,
    EDITION       VARCHAR(255) DEFAULT '' NOT NULL,
    DISCONTINUED  INTEGER DEFAULT 0 NOT NULL,
    DOWNLOADABLE  INTEGER DEFAULT 1 NOT NULL,
    CHANGE_DATE   DATE NOT NULL,
    CHANGE_TYPE   INTEGER NOT NULL DEFAULT 0
)


The original idea though was trying to keep everything in the ordinary tables but I do not
think that's doable in any easy way - unless someone comes up with a brilliant idea, that is!

Do you see my point?

Regards,

A
AnswerRe: Product dataabase Pin
jschell21-Jul-13 10:00
jschell21-Jul-13 10:00 
GeneralRe: Product dataabase Pin
Mycroft Holmes21-Jul-13 12:57
professionalMycroft Holmes21-Jul-13 12:57 
QuestionHow to issue setup to the different users according to their membership with windows application? Pin
mehtabalikhan16-Jul-13 19:21
mehtabalikhan16-Jul-13 19:21 
AnswerRe: How to issue setup to the different users according to their membership with windows application? Pin
Mycroft Holmes16-Jul-13 20:20
professionalMycroft Holmes16-Jul-13 20:20 
QuestionSQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 0:05
Septimus Hedgehog16-Jul-13 0:05 
AnswerRe: SQL Server file locations. Pin
Corporal Agarn16-Jul-13 1:49
professionalCorporal Agarn16-Jul-13 1:49 
GeneralRe: SQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 3:18
Septimus Hedgehog16-Jul-13 3:18 
GeneralRe: SQL Server file locations. Pin
Corporal Agarn16-Jul-13 4:18
professionalCorporal Agarn16-Jul-13 4:18 
GeneralRe: SQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 4:44
Septimus Hedgehog16-Jul-13 4:44 
QuestionHow to replace string with stuff ? Pin
caulsonchua15-Jul-13 23:03
caulsonchua15-Jul-13 23:03 
AnswerRe: How to replace string with stuff ? Pin
Richard Deeming16-Jul-13 1:37
mveRichard Deeming16-Jul-13 1:37 
GeneralRe: How to replace string with stuff ? Pin
caulsonchua16-Jul-13 1:39
caulsonchua16-Jul-13 1:39 
GeneralRe: How to replace string with stuff ? Pin
Richard Deeming16-Jul-13 1:50
mveRichard Deeming16-Jul-13 1:50 
AnswerRe: How to replace string with stuff ? Pin
Mycroft Holmes16-Jul-13 12:44
professionalMycroft Holmes16-Jul-13 12:44 
QuestionMounting .DBF files (Oracle Database 11g) Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
AnswerRe: Mounting .DBF files (Oracle Database 11g) Pin
Maciej Los29-Jul-13 23:46
mveMaciej Los29-Jul-13 23:46 
GeneralRe: Mounting .DBF files (Oracle Database 11g) Pin
prathameshpitale30-Jul-13 5:40
prathameshpitale30-Jul-13 5:40 
QuestionORA-12560 TNS : protocol adapter error; ORA-1033 Oracle initialization or shutdown in progress Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
QuestionHow to find ladder in sql query Pin
Member 356741115-Jul-13 2:02
Member 356741115-Jul-13 2:02 
AnswerRe: How to find ladder in sql query Pin
Niral Soni15-Jul-13 5:00
Niral Soni15-Jul-13 5:00 
AnswerRe: How to find ladder in sql query Pin
karna from Hyderabad22-Jul-13 21:01
karna from Hyderabad22-Jul-13 21:01 
Questiondatabase course Pin
V.14-Jul-13 22:32
professionalV.14-Jul-13 22:32 
AnswerRe: database course Pin
Eddy Vluggen15-Jul-13 0:30
professionalEddy Vluggen15-Jul-13 0:30 
GeneralRe: database course Pin
V.15-Jul-13 1:30
professionalV.15-Jul-13 1:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.