Question : My table looks as follows: Column | Type | ———————–+——————-+ id | integer | source_id | integer | […]
Tag: architecture
Redundant data or UNION [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
How to query for address “predictions” while applying constraints
Question : Let’s say I have this simplified database scheme. The scheme consists of three tables, street, city and zipcode […]
Do multiple SQL Server instances increase security?
Question : Context Let’s assume you have a server which exposes a web server and one or more web services […]
MySQL MATCH vs JOIN
Question : I have a lot of data to filter and therefore I wonder is it better to create somekind […]
In MongoDB, is having lots of small collections better than having one huge collection?
Question : Huge collections have huge indexes that may not fit into RAM. Is that problem entirely solved with sharding […]
Numerical data with lots of NULLs: 6NF or document database?
Question : I have a source of numerical data mostly comprised of sensor readings, physical quantities and flags. Each associated […]
Real-time merge of two databases on different servers
Question : One of the requirements our customer has given is to merge two databases running on two different machines […]
MySQL high availability, failover and replication with Latency
Question : We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have […]
What is a construct in Oracle?
Question : I’m currently studying Oracle Architecture and Database Memory Structures. I’m a newbie in the subject and I just […]