Table scaling with partitions or with separate databases?

Hypothesis: I have a table (named BigTable) which could experience 5,000,000 INSERTS per day (with possibly just as many SELECTs). Each row inserted is about 50kb.

A multi tenant data architecture

We are at a planning & redesign stage of our loyalty card application. As it is understood it will be a multi-tenant application. And I need to take your thoughts. Here are the some key points we should take in to account to redesign logical and physical data structure:

Ledger or log design for a point-based system?

Right now creating a new service that will integrate into our company’s existing platform. The service will be responsible for tracking “points” that a user can generate over time through certain activities.

Azure Storage Table design with multiple query points

I have the following Azure Storage Table.

Why is the usage of string keys generally considered to be a bad idea?

This has been bugging me for a while. Most of the time, when it comes to storing data in structures such as hashtables, programmers, books and articles insist that indexing elements in said structures by String values is considered to be bad practice.
Yet, so far, I have not found a single such source to also explain WHY it is considered to be bad practice.
Does it depend on the programming language? On the underlying framework? On the implementation?

NoSQL (Azure Table Storage) RowKey design for ordered data

I store large quantities of GPS data in storage tables. Each partition can reach up to 1 million entities. Each GPS entity that is inserted into the table is actually sequential to the previous data inserted, so order matters.

Why OTServs have an item cloning problem if the server crashes? [closed]

Closed 11 years ago.

Using a database for each module in a system [duplicate]

I was trying to standardize and modularize some functions (Email
Management Module, CMS Module & etc) by implementing a 3-tier
architecture concept where each module would have its own independent
module database. So that in the future all we’d need to do is just
code a presentation layer, reuse the BLL layer, DAL Layer and
database.

What is a good design for a container, assignment and items

————- 1 * ————– * 1 ——– | Container |——–| Assignment |———–| User | ————- ————– ——– ^ ^ | | ———- ————- | | | | ———- ———- ———- ————— | Flight | | Dinner | | Booking| | Reservation | ———- ———- ———- ————— This problem is one that I’ve stumbled upon in […]

Should lookup tables enumerating strings have an integer primary key?

When I learned relational databases, the prof said that one would “almost always” want an artificial int as the primary key in a table, but did not specify what the exceptions are. At some time I stopped using them for junction tables, and never had a problem.