RDBMS: All content tagged as RDBMS in NoSQL databases and polyglot persistence
Q: Copy MySQL to RAM as a poor man’s memcached replacement?
A: Use the the MEMORY storage engine on a read only slave to do your reads from, is exactly what you really want and a sane setup. Forget “dumping it to disk” (?!) or other strange things.
You can even put the slave as another instance on your existing server if you can’t afford to setup a dedicated slave, but properly tuning the MySQL parameters for mostly read workloads will bring a significant performance enhancement too!
Original title and link: MySQL MEMORY as Poor Man’s Memcached Replacement ( ©myNoSQL)
The other day I’ve posted about Sqoop’s first release under Apache umbrella, so I’ve thought of providing a bit more details about where Sqoop fits in picture. I’ve embedded below 3 presentations that will answer questions like what is Sqoop, when and where to use Sqoop, how to use Sqoop.
Sir Tim Berners-Lee:
Inventing the World Wide Web involved my growing realization that there was a power in arranging ideas in an unconstrained, web-like way. And that awareness came to me through precisely that kind of process.
Let’s think how the different data models require us to arrange data:
- hierarchical model: free form, single-type of relationship (parent-child)
- relational model: strict form, (limited) multiple-types of relationships
- document model: free form, dual relationship types: logical and hierarchical
- star schema: strict form, (limited) multiple-types of relationships
Now think about graph databases: free form (nodes can have any number of properties), unlimited number of uni/bi-directional relationships. So question is, why aren’t network/graph databases used more these days?
Original title and link: Graph Databases and the World Wide Web ( ©myNoSQL)