Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [architecture]

182 questions
43
votes
7 answers

Is it better to store images in a BLOB or just the URL?

Possible Duplicate: Files - in the database or not? I was wondering if there's any good reason to still use blob fields in a database. A couple of years ago I worked with a DB with a bunch of images in it, the DB was very slow and I couldn't see…
eiefai
  • 1,874
  • 2
  • 21
  • 18
30
votes
7 answers

Pros/Cons of using multiple databases vs using a single database

I was working on a new project which has the requirement to use 7 databases, arguing that performance, stability, optimization are more easily implemented. While I don't agree, I'm having trouble collecting good arguments to use a single database…
rdkleine
  • 421
  • 1
  • 4
  • 7
27
votes
2 answers

How to store time series data

I have what I believe is a time series data set (please correct me if I'm wrong) that has a bunch of associated values. An example would be modeling a car and tracking its various attributes during a trip. For example: timestamp | speed | distance…
guest82
  • 373
  • 1
  • 3
  • 4
24
votes
3 answers

What's the best way to archive all but current year and partition the table at the same time

Task Archive off all but a rolling 13 month period from a group of large tables. The archived data must be stored in another database. The database is in simple recovery mode The tables are 50 mil rows to several billion and in some cases take up…
Kenneth Fisher
  • 24,307
  • 13
  • 63
  • 116
20
votes
4 answers

How to handle table design with variable columns

I have a table design scenario and as a non-DBA type, would like opinions on which is more scaleable. Say you are asked to record information on houses for a metro area, starting with a small neighborhood (200 houses) but eventually growing to…
Schmitty23
  • 301
  • 1
  • 2
  • 4
13
votes
3 answers

Database Administrator vs Database Architect?

In terms of job responsibilities and activities, what is the difference between a Database Administrator (DBA) and a Database Architect?
Allen Jantzen
  • 161
  • 1
  • 1
  • 3
13
votes
4 answers

Drives vs. Mount Points?

The previous Senior DBA set up mount points for all of our drives across every SQL Server throughout the company. The new Senior DBA is horrified by mount points wants to change our standard (mainly, I think, because he has no experience with…
SQL_Deadwood
  • 841
  • 3
  • 7
  • 24
12
votes
1 answer

Highly Concurrent Storage System

Imagine your requirement is that you have 3 huge tables (structured data) with say 30 billion rows in each (total size of 4TB) and your many concurrent users (which are parallel os threads on remote LAN machines) will need to read a portion of the…
iCode
  • 223
  • 1
  • 5
11
votes
1 answer

Optimizing a 'latest' query in Postgres on 20M rows

My table looks as follows: Column | Type | -----------------------+-------------------+ id | integer | source_id | integer | timestamp | integer …
Pepijn Schoen
  • 111
  • 4
9
votes
2 answers

Postgres with pgpool architecture

Below is an example pgpool architecture: This implies that you only need to have pgpool on a single server; is this true? When I look at the configuration I also see that you configure backends within pgpool.conf; so it further implies this. But,…
user20459
8
votes
1 answer

MySQL high availability, failover and replication with Latency

We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of MySQL we will run ... either Community or…
KM.
  • 1,367
  • 4
  • 14
  • 20
8
votes
3 answers

Data warehouse staging architecture

This is a question about data warehouse design. We are setting up a healthcare datawarehouse and starting with 2 major source systems that combine for about 20,000 tables and 2 TB of data. 1) It is highly dimensional data 2) We don't wan't to…
eased
  • 81
  • 2
7
votes
1 answer

In MongoDB, is having lots of small collections better than having one huge collection?

Huge collections have huge indexes that may not fit into RAM. Is that problem entirely solved with sharding ? If I have lots of small collections with small indexes, what are the options for storing them ? Since only very few of them would be bigger…
João Pinto Jerónimo
  • 293
  • 2
  • 6
7
votes
2 answers

Is a geographically distributed application with SQL Server replication a good idea?

We are currently thinking about a target architecture for a geographically distributed application. This application tracks and schedules the movements of all material units across various production sites. There will be two logical entities: The…
Seb_Lz
  • 71
  • 2
7
votes
4 answers

Why would one need multiple instances of same Oracle database?

I came across the following statement in this article: An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance to be able to manipulate that data, the instance must open the…
Parag Meshram
  • 378
  • 2
  • 3
  • 11
1
2 3
…
12 13