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.
319
questions
5
votes
3answers
236 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
4k 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
,...
8
votes
1answer
248 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 "...
17
votes
7answers
7k 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 ...
11
votes
5answers
7k views
Are there opensource hierarchical database management systems [closed]
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?.
11
votes
2answers
3k 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 ...
8
votes
2answers
255 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 files....
4
votes
4answers
2k 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
462 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 ...
56
votes
6answers
37k 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
428 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 ...
5
votes
3answers
673 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 object-...
5
votes
1answer
119 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 ...
11
votes
3answers
231 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
515 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 ...
8
votes
3answers
643 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.
10
votes
1answer
4k 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 ...
38
votes
5answers
6k 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?
71
votes
6answers
43k 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 ...
