Skip to main content

New answers tagged

1 vote
Accepted

What is the difference between a key attribute store and a key value store?

The key-value store associates a key with a value. Each value can be elementary or it can be composite, e.g. a serialized object. Think of it as a dictionary. Or as a table with two columns. The ...
Christophe's user avatar
  • 78.6k
3 votes

What is the difference between a key attribute store and a key value store?

"Key value store" is definitely the more common term, which has also a Wikipedia entry. I can only guess why in context of Azure Table Storage, the Microsoft docs call this a key/attribute ...
Doc Brown's user avatar
  • 210k
1 vote

What is the difference between a key attribute store and a key value store?

I think the "key" difference here is that a key/value store implies a single key and a single value. Where as an attribute value store means that your value is split into multiple (sub) key/...
Ewan's user avatar
  • 77.4k
1 vote
Accepted

How to design sharing feature properly in DB?

As requested in the comments as an answer: CREATE TABLE Users ( id INTEGER PRIMARY KEY, name TEXT NOT NULL ); CREATE TABLE Categories ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, ...
Luc Franken's user avatar
  • 2,846
1 vote

Text files vs. MySQL Performance for Large Dataset

A database sounds suitable for your use case. If you use indices appropriately it should provide very fast lookups, on the order of tens to hundreds of milliseconds. But possibly the greatest ...
JonasH's user avatar
  • 5,814
2 votes

Text files vs. MySQL Performance for Large Dataset

Storing data in memory with a hash table lookup will be faster than any remote database (assuming the same specs) due to the network latency. Hash tables offer O(1) lookup complexity, while MySQL with ...
Lem's user avatar
  • 21
3 votes

How to handle data when source of truth is through API

This is an extremely common problem when building any sort of distributed system. This is such a foundational problem for service-oriented architecture and microservices that no single canonical term ...
Greg Burghardt's user avatar
0 votes

What can I do to get a message processor to slow down the rate of writes that it is making to a database?

Disclaimer: I've never horizontally scaled producers with an ACID consumer. The described approach is proven to work well with object databases. I suggest to use Nagle's algorithm. It combines ...
Basilevs's user avatar
  • 2,248
0 votes
Accepted

Single-source data warehouse permissions management

Just a Summary of discussion answer The problem is quite specific to redshift in that tables need to be copied/recreated inorder to manage indexing and volume. This recreation is often managed by ...
Ewan's user avatar
  • 77.4k

Top 50 recent answers are included