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.
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 ...
7
votes
3answers
499 views
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) ...
3
votes
1answer
1k views
Amazon SimpleDB or Amazon RDS?
I'm at a deciding point in my project of whether to implement the database using SimpleDB or Amazon RDS. The database needs to be accessed through an iPhone app and as well through a website. Here are ...
11
votes
5answers
1k views
What features of Oracle make it an attractive choice for small projects?
Given Oracle's licensing handling[a] (and, to a lesser extent, cost) I have always been wondering what the deciding factors would be for choosing Oracle over PostgreSQL or MySQL.
My company is nearly ...
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 ...
1
vote
2answers
271 views
Determining sizes for Separated Partitions of programs, data and logs in SQL Server
As per the recommendations of the CIS benchmarks for SQL Server, I want to create separate partitions for the data, the programs and the logs on my SQL Server dedicated server.
Question is, what is ...
5
votes
3answers
215 views
Import 2 column CSV files to some sort of DB… preliminary planning
Every day I have a CSV file generated by a script. It has two columns. Column 1 is a name, column 2 is the size of their mailbox.
I have a years worth of these files. I would like to be able to ...
3
votes
2answers
2k views
How to check that stored procedure is valid
As we know, it is possible to compile and to have so stored procedures:
CREATE PROC dbo.MyProc1
AS
SELECT * FROM Not_Exists_Or_Removed_Table
or
CREATE PROC dbo.MyProc2
AS
SELECT
Id
...
6
votes
1answer
173 views
Are relations slower than a big, inefficient table?
I've been asked in my job to violate the first normal form (repeating groups across columns, using empty / null values) several times, "for the sake of computer processing power". In a nutshell, a ...
11
votes
6answers
1k views
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 ...
6
votes
5answers
1k views
Are there opensource hierarchical database management systems
I was looking for a hierarchical database management system and the only one i came across was IBM's ims.Are there opensource systems that one can use?.
9
votes
2answers
508 views
How do I implement a database/table as a stack
I have a state-machine which needs to push/pop some file-names for different users. I would traditionally use stacks as the choice of data structure, but this needs to be done using a database since I ...
6
votes
2answers
161 views
A database for digital assets
I work at a print shop that has a decent sized archive of old print jobs. Currently, to find a job we have to search the SMB share (on win2000 server), which looks through a few hundred thousand ...
4
votes
4answers
783 views
Best method to give two Oracle databases on the same server access to common data
With a production and a test database on the same server, how should access be provided to some common quarterly update tables for both databases?
It is possible to put these tables into a third ...
3
votes
1answer
399 views
Any reasons at all *not* to use MySQL in this scenario
I want to know if there is any reasons at all not to use MySQL in this scenario.
2 servers behind a virtual IP with MySQL master-master replication
Goal: redundancy, want this to run 24/7 ...
13
votes
6answers
2k views
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 ...
2
votes
2answers
266 views
Will this Database design logic work and what should be used?
A few weeks ago I had a client of mine ask me about how complex it would be to develop a custom CRM application similar to the one being provided by highrisehq.com
What he essentially wants to do is ...
4
votes
3answers
271 views
Multi-database object-oriented proxy
Do you know if there is a system/product/technique which would allow to "wrap" one or more relational databases into one object-oriented virtual database (or could we call it a "multi-database ...
3
votes
1answer
102 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 ...
0
votes
0answers
374 views
Best online database [closed]
My wife is running a childcare company. We employ people who offer childcare in their home.
We have today a Microsoft Access database where we add information about our employees, our customers ...
9
votes
3answers
178 views
Are there any database engines which will intuit the join condition based on the existing foreign keys?
It seems strange to me that, when I've defined a foreign key, the engine cannot use this information to automatically figure out the correct JOIN expressions, but instead requires me to re-type the ...
6
votes
6answers
436 views
Which database engines will allow me to GRANT/REVOKE on a specific column?
If I have a table with a single column of sensitive data, and I want to grant broad use of the table without exposing that one column, I know that I can create a VIEW that gives them access to all the ...
7
votes
3answers
247 views
Which databases are recommended to be used as embedded databases?
Which databases are recommended to be used as embedded databases to store data within an application? The embedded database may or may not synchronize back to a larger system database.
9
votes
1answer
732 views
Fast database for a small microcontroller
I am using a PIC32, which is a 32-bit processor clocked at 80 MIPS with about 64-128KB of RAM available. It will be accessing a microSD card - up to 4 GB, on a FAT32 filesystem. Running all of this is ...
23
votes
5answers
2k views
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?
41
votes
5answers
7k views
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 ...
