We're designing an OLTP financial system. it should be able to support 10.000 transactions per second and have reporting features. So we have come to the idea of using: a NoSQL DB as our m...

I am confused in some questions. I need their answers. If our relational model is also De-normalize then why we prefer dimensional model ? What is the reason we prefer dimensional model over relati...

An OLAP database consists of data in denormalized form. This means data redundancy and this data redundancy helps retrieve data through less number of joins, hence facilitating faster retrieval. ...

I'm trying to run benchmark on mySQL database using sysbench. However, it says it cannot find built-in test oltp. Detail: I've installed mySQL, and sysbench on my local machine. Also, I've created...

I have several OLTP databases with API's talking to them. I also have ETL jobs pushing data to an OLAP database every few hours. I've been tasked with building a custom dashboard showing hight lev...

Actually what do they mean? All articles I find about them don't give me an idea, or my knowledge is too insufficient to understand it. Will some one give me some resources with which I can learn ...

I'm trying to understand what OLAP, OLTP, data mining, analytics etc. are about, and I feel like my understanding about some of these concepts is still a bit vague. Information about these subjects...

Well, not much to ask apart from the question. What do you mean when you say a OLTP DB must have a high throughput. Going to the wiki. "In communication networks, such as Ethernet or packet ra...

What are the common design approaches taken in loading data from a typical Entity-Relationship OLTP database model into a Kimball star schema Data Warehouse/Marts model? Do you use a staging area...

We are working on designing an application that is typically OLTP (think: purchasing system). However, this one in particular has the need that some users will be offline, so they need to be able t...