Tagged Questions
17
votes
6answers
5k views
Should I use one database per application or share a single database amongst multiple applications [closed]
I have multiple applications some that use data from the same sources.
Is it best practice (or what are the pros/cons) to:
leave the data in databases shared by multiple applications
saves space ...
8
votes
11answers
14k views
Using XML as data storage
I was thinking about the XML format and the following quote:
“XML is not a database. It was never meant to be a database. It is never going to be a database. Relational databases are proven ...
3
votes
5answers
694 views
Good techniques to speed up database execution
I have an ASP.Net application that is using a MySQL database. My queries are not executing as fast as I would like them too. Are there some standard ways to increase the speed of a MySQL database ...
42
votes
12answers
3k views
Is it necessary to create a database with as few tables as possible
Should we create a database structure with a minimum number of tables?
Should it be designed in a way that everything stays in one place or is it okay to have more tables?
Will it in anyway affect ...
10
votes
4answers
2k views
Weaknesses with different types of NoSQL databases
Here's my question: What are the weaknesses with different types of NoSQL databases? Specifically, what're the weaknesses of key-value stores, graph data stores and document stores?
I've had an easy ...
9
votes
6answers
21k views
what do database programmers do?
Every time I read about Oracle programmers etc, I get confused. I don't know what exactly they do.
From my understanding, application programmers need to develop the core functionality. The libraries ...
53
votes
12answers
32k views
Is it a bad practice to store large files (10 MB) in a database? [closed]
I am currently creating a web application that allows users to store and share files, 1 MB - 10 MB in size.
It seems to me that storing the files in a database will significantly slow down ...
15
votes
9answers
1k views
Constraints in a relational databases - Why not remove them completely?
Is there any reason to build constraints between tables (inside SQLserver) nowadays? If so, when? Most applications in my area are built on object principles and tables are joined on demand. Demand ...
15
votes
6answers
727 views
What do DBAs do?
Yes, I know they administrate databases.
I asked this question because I'd like to get a further insight into the kind of day-to-day duties a DBA might perform, and the real-world business problems ...
11
votes
10answers
897 views
How could RDBMSes be considered a fad?
Completing my Computing A-level in 2003 and getting a degree in Computing in 2007, and learning my trade in a company with a lot of SQL usage, I was brought up on the idea of Relational Databases ...
8
votes
7answers
2k views
Copying a competitor's database schema? [closed]
I am going to be releasing some software soon which will require users to run a local database. There is a competitor in the space that is doing the same thing and they have a pretty sophisticated ...
6
votes
6answers
846 views
Is the “One Description Table to rule them all” approch good?
Long ago, I worked (as a client) with a software which use a centralized table for it's codified element.
Here, as far as I remember, how the table look like :
Table_Name (PK)
Field_Name (PK)
Code ...
13
votes
5answers
1k views
Is it the job of programmers to design the database?
I've been a programmer for the past six years. Throughout my career, I have worked on many web applications.
Most of the time, when a database was needed, it was given to us (the programmers) or we ...
3
votes
3answers
394 views
Is it better to use a switch statement or database to look through 5,000 to 10,000 instances?
I have some JSON data in this format (5,000 instances for now):
{"id":"123456","icon":"icon.png","caseName":"name of case"}
I am allowing the user to search for the name of the case and then return ...
