Questions tagged [database-recommendation]

Determining what database product best fits the requirements and limitations in a specific situation. This is advice that generally requires much more insight into requirements than can easily be gleaned on a Q&A forum such as StackExchange.

If you are seriously evaluating databases for a project then the evaluation is likely to be affected or even constrained by a range of factors. These could range from feature requirements to corporate policies mandating the use of certain platforms. Feasibility studies for this can be quite in-depth pieces of research in their own right.

Asking questions of the form 'what database should I use for xxx' is unlikely to produce a useful answer unless you can be quite specific about requirements. Specifying these in a useful level of detail can produce quite substantial documents.

You are much more likely to get a useful response if you can do some preliminary research based on the capabilities you are looking for, and then use Q&A forums to get specific clarifications on individual points.

323 questions
245
votes
5 answers

How large should be mysql innodb_buffer_pool_size?

I have a busy database with solely InnoDB tables which is about 5GB in size. The database runs on a Debian server using SSD disks and I've set max connections = 800 which sometimes saturate and grind the server to halt. The average query per second…
alfish
  • 2,844
  • 6
  • 19
  • 18
116
votes
5 answers

Best database and table design for billions of rows of data

I am writing an application that needs to store and analyze large amounts of electrical and temperature data. Basically I need to store large amounts of hourly electricity usage measurements for the past several years and for many years to come for…
Gecata
  • 1,263
  • 3
  • 8
  • 5
71
votes
6 answers

What are the differences between NoSQL and a traditional RDBMS?

What are the differences between NoSQL and a traditional RDBMS? Over the last few months, NoSQL has been frequently mentioned in the technical news. What are its most significant features relative to a traditional RDBMS? At what level (physical,…
Spredzy
  • 2,248
  • 2
  • 20
  • 25
63
votes
6 answers

About single threaded versus multithreaded databases performance

H2 is a single threaded database with a good reputation regarding performance. Other databases are multi-threaded. My question is: when does a multi-thread database become more interesting than an single thread database? How many users? How many…
Jérôme Verstrynge
  • 1,441
  • 4
  • 22
  • 27
57
votes
6 answers

What problems will I get creating a database per customer?

I remember from the stackoverflow podcasts that Fog Creek use a database per customer for Fogbugz. I assume that means the Fogbugz On Demand servers have 10s of thousands of databases. We are just starting to develop a web app and have a similar…
Rik Heywood
  • 673
  • 1
  • 6
  • 6
39
votes
5 answers

When is the right time to use MariaDB instead of MySQL, and Why?

What we earn and what we lost with this migration? What should I expect as drawbacks after the migration? Is it really unnecessary to change the applications in any situation?
Maniero
  • 2,648
  • 6
  • 27
  • 29
28
votes
2 answers

Ready-to-Use Database models example

Where can I find ready-to-use database models ? I don't need a database with data in it, but only schemas (UML diagrams). Perhaps something like the data models at this link, but much more complex and real world.
tasmaniski
  • 1,095
  • 4
  • 13
  • 16
26
votes
4 answers

Whether or not to create separate tables for different product types?

I'm in the process of designing a database and I'm having second thoughts about my initial design decisions... Product types are as follows... Models, parts, replacement part kits and options. Option A (first design): I planned on having separate…
payling
  • 385
  • 1
  • 3
  • 7
23
votes
3 answers

Is there a tool to check if my database is normalized to the third normal form?

I learned about normalization recently, and understand how important it is when implementing a new schema. How can I check if my database is 2NF or 3NF compliant ? Manual review is a sure option, but I'm looking for an automated tool here. I'm not…
19
votes
3 answers

PostGIS vs. SQL Server for GIS data

So I'm recently starting at a new company and have a lot of ArcGIS users who seem really keen on going forwards with a PostGIS instance to serve some data to our customers. While I don't have an issue with this, we are a 95% SQL Server and 5% Oracle…
LowlyDBA - John M
  • 10,941
  • 11
  • 40
  • 60
19
votes
7 answers

Is polling the only way for updating app's data from a database?

An application needs to have data as more freshly updated from a database as possible. In such a case, is there any other way for getting the data, besides of a timer based requesting (polling) the database? I work with a MS SQL Server 2008 (and…
rem
  • 1,525
  • 3
  • 20
  • 22
18
votes
2 answers

Which DBMS is good for super-fast reads and a simple data structure?

I am developing a product that, as a part of it's operation, must track a large number of files/directories. The idea is to store stat information in a database then, on boot, create watches for each file. Files that change will be queued (in the…
beatgammit
  • 283
  • 1
  • 2
  • 9
16
votes
3 answers

Is there any benefit to defragmenting SQL indexes in a SAN environment?

Our SQL server lives on a SAN. It contains dozens of OLTP databases, some with several tables containing over 1m records. We have been running Ola Hallengren's index maintenance scripts weekly, and it runs for several hours each time. Based on the…
14
votes
3 answers

What are negative keys used for?

Somewhat new to using standard SQL databases (currently working with MySQL mostly) I haven't run across many usages of this as of yet. When and why is it useful to have negative (or rather signed) keys indexing a table?
13
votes
2 answers

Proper technique for storing users event data

I am mostly a self-taught when it comes to database designs. I am posing this question because I have settled on this common structure, but am wondering if it is the most efficient or 'industry standard' method. Most databases I design have a user…
CenterOrbit
  • 440
  • 3
  • 10
1
2 3
21 22