Tagged Questions
1
vote
1answer
127 views
Switching to NoSQL for native JSON use?
I am rather comfortable writing concrete schemas with explicit primary keys, foreign keys, indexes, views and stored procedures. For queuing I use a NoSQL solution called: Redis.
Recently I heard a ...
2
votes
4answers
326 views
One table with many rows or many tables with a few rows
I'm having a question rounding my mind. It's better to create one table and store a lot of rows there or create various tables and have a few rows on them? What's the performance and the I/O saved at ...
2
votes
4answers
389 views
Advice on choosing a really fast DBMS
I am working on a project that does real-time monitoring of data being transmitted, and logs if there are any of the various type of errors, etc. The CRUD operations are real-time. We initially ...
6
votes
1answer
336 views
Using an RDBMS for querying tens of Terabytes of time-series data?
I stumbled over an algorithmic / data-structures question over on SO, which I'll short quote:
(...) opinions regarding best of
breed data structures to be used for indexing time-series (aka
...
5
votes
3answers
1k views
Database suggestion for a social network/ knowledge base community?
I am looking into various database types and DBMS's for a new project I am wanting to start in the summer.
I have built systems in MySQL and postgreSQL , now I am wanting to expand my knowledge and ...
1
vote
0answers
242 views
Best database for INSERT 2 millions of records around 3 hours and query data at the same time [closed]
I have a voting application. This voting process takes about 3 hours to complete. After 3 hours there will be 2 millions of records in the database. At the same time application needs to query the ...
2
votes
3answers
386 views
Best database choice for a highly scalable web ticketing system?
Essentially, we are developing using Ruby on Rails and want to make a highly scalable ticketing system. Essentially we will have a small database (containing event details and tickets sold) that will ...
16
votes
6answers
10k views
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 ...
1
vote
0answers
348 views
Which database technology for big structured data? [closed]
Scenario: Think you have got
100TB of text in 200 tables. This is structured related data. compareable to dbpedia only more data. Any really relational and distributed and performant database would do ...
3
votes
1answer
103 views
Data transformation implementation
My company's database, I am working with, makes available a data to a lot of external applications. So I need to transform the same data to a lot of dynamic views. I can see that a former database ...
