Click here to Skip to main content
15,672,024 members
Home / Discussions / Database
   

Database

 
AnswerRe: Rank over () / row_number over in sqlite Pin
Mycroft Holmes22-Jul-13 22:55
professionalMycroft Holmes22-Jul-13 22:55 
QuestionRe: Rank over () / row_number over in sqlite Pin
jojoba2022-Jul-13 23:57
jojoba2022-Jul-13 23:57 
QuestionProduct dataabase Pin
DeerBear20-Jul-13 5:59
DeerBear20-Jul-13 5:59 
AnswerRe: Product dataabase Pin
Mycroft Holmes20-Jul-13 13:37
professionalMycroft Holmes20-Jul-13 13:37 
AnswerRe: Product dataabase Pin
Eddy Vluggen20-Jul-13 23:24
professionalEddy Vluggen20-Jul-13 23:24 
GeneralRe: Product dataabase Pin
DeerBear21-Jul-13 2:27
DeerBear21-Jul-13 2:27 
GeneralRe: Product dataabase Pin
Mycroft Holmes21-Jul-13 3:36
professionalMycroft Holmes21-Jul-13 3:36 
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 

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.