The architecture tag has no wiki summary.
0
votes
3answers
140 views
AlwaysOn Architecture - SQL Server 2012 for creating a dev environment?
I was thinking if the AlwaysOn architecture in SQL Server 2012 can be leveraged somehow to create a replica for DEV and QA environment properly in addition to setting up HADR using the same ...
0
votes
1answer
86 views
Real-time merge of two SQL Server databases on different servers
One of the requirements our customer has given is to merge two databases running on two different machines in real time. This means that we have to build some sync policy (or use SQL Server Tools to ...
3
votes
1answer
65 views
Many:Many with Shared Relation
I'm modelling data with multiplicity like this:
Each Composition/Anthology related pair must share a Composer. Also, each Anthology must contain at least one Composition. How would you recommend I ...
-3
votes
1answer
56 views
Are database servers less scalable than web servers? [closed]
Isn't it possible to scale database servers through virtualization, like forever? I like to keep most of the workload on database server because it optimizes queries and the architecture decreases the ...
0
votes
1answer
34 views
New Database vs New Table for User Registrations
Here's an example, there is this application that completes a task (mostly data-enrty stuff). Users can sign-up on a website to begin using the application straight away.
At the moment, I was looking ...
0
votes
1answer
116 views
Is there an easy way to replicate MySQL data?
My software is deployed in various cities, each have a database, but they have different authorizations such as:
central DB
/\
/ \
DB1 ...
0
votes
2answers
60 views
Academic Journals and Reviews for Database Systems [closed]
I want to start reading up on the latest advances in database technology. Can anyone tell me what are the leading academic journals on the subject?
Also, I have a friend doing a PhD in another area ...
0
votes
2answers
145 views
Relationships in a school database
I am designing database for a school app. Student is the main entity in the database. Student has relation with Parent & Guardian.
I am confused as where to store references. As will student ...
0
votes
0answers
116 views
Hadoop, Hive, Sqoop and MySQL [closed]
I want to start a testing session for performance and maintenance on an architecture that includes these three components:
Hadoop
Hive
Sqoop
to share data from a MySQL database (at the moment ...
0
votes
1answer
182 views
How shared nothing and shared everything architectures look like in Oracle?
Oracle has partitioning and clustering features. Partitioning enables to split table or indexes into multiple tablespaces and store on various servers. So it's done manually. Clustering enables ...
2
votes
2answers
115 views
Database structure for a system with multisite
The system I'm working is structured as below. Given that I'm planning to use Joomla as the base.
a(www.a.com),b(www.b.com),c(www.c.com) are search portals which allows user to to search for ...
0
votes
2answers
126 views
Need advises for a new MySQL architecture
I need to deploy a MySQL-based application with the following requirements and would love to receive some guidance (any) as to how I could set things up:
Scale of deployment
5 servers with a ...
3
votes
1answer
95 views
Economic Database Architecture Possibilities w/ Data of Varying Length
I'm in the process of designing a MySQL database (InnoDB) that holds a large amount of economic data which our application scores. The size of the economic data varies a great deal: some measures, ...
1
vote
2answers
85 views
Distributing MySQL database on n systems
I have a webserver in my application which talks to a single MySQL node. Instead of having just one MySQL node, I want to have a cluster of n nodes which form my database.
Is it possible to do ...
2
votes
1answer
319 views
Foreign key with multiple table options
I'm not sure if the title is very good, feel free to suggest a better one.
People can "comment" on different objects of my site,similarly to StackExchange (for example they can comment on a Question, ...
0
votes
0answers
274 views
The Oracle's Log Buffer, Redo Log Buffer Cache and Redo Log files [closed]
I need to know the difference between :
(i) Log Buffer (ii) Redo Log Buffer Cache and (iii) Redo Log files.
1
vote
1answer
82 views
Storing all data in a single db versus multiple dbs in Mongodb
We have an app that is basically an ERP. Some of the resources in the ERP are satellite tracked. So the information related to the resource itself is minimal, but the satellite tracker produces data ...
1
vote
1answer
202 views
How do I handle importing high amounts of transaction data into application DB?
For the moment, this is a hypothetical question. I've got a database that has a high level of transactional data coming into it. I also have a database that supports my website (my application ...
1
vote
1answer
112 views
Where do caching servers conceptually fit in my architecture?
Given the simple well-known architecture below:
Where (conceptually) does the caching server(s) sit?
6
votes
3answers
1k views
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?
2
votes
1answer
209 views
Redesigning a multi-instance MySQL server for performance and resiliency
I've got a single MySQL server which currently runs N separate MySQL instances on, which are rapidly growing beyond the capabilities of that box.
Is it possible to have an active-active MySQL ...
1
vote
1answer
406 views
MySQL Cluster over WAN: Best Architecture Options?
My company is looking at a multi-data-centre solution for high-availability, fun, and profit.
We have businesses across the planet, with the need for MySQL database clustering solutions that can keep ...
5
votes
2answers
222 views
Recommended structure? %70 write %30 read. 10M row. 200 query/sec. Select, update, insert, search
Followings are what I need to do on my project:
1- If a search term is new and unique, then add the search term
2- Show lastest searched 1000 search terms (I don't need to store dates of all search ...
11
votes
1answer
216 views
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 ...
8
votes
1answer
128 views
Relational database: in-RAM partitioning? Theoretical structure discussion
I'm rewriting an MMORPG server engine using some rather esoteric elements (theoretically good but rarely used in practice), and having a bit of doubt. Some elements of this are “solid” — but the point ...
2
votes
1answer
81 views
What is the best architecture to run Oracle sucessfully run on VMWare?
Due to a data center move we are mandated to migrate all servers to virtual machines. We currently have a 3 Node Oracle RAC running on physical servers. There seems to be a great debate about the ...
0
votes
1answer
502 views
32-bit versus 64-bit ODP.NET to Oracle connection
I seem to be having an issue connecting a 32-bit .NET application to a 64-bit server, without a full Oracle client.
If I build a 64-bit application, using the 64-bit ODP.NET dll's or a 64-bit instant ...
5
votes
1answer
441 views
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 ...
4
votes
2answers
533 views
What exactly is a database engine?
I have gone through the definition on http://en.wikipedia.org/wiki/Database_engine several times:
A database engine (or "storage engine") is the underlying software component that a database ...
4
votes
5answers
2k views
Pros/Cons Using multiple databases vs using single database
Working on a new project which has the requirement to use 7 databases. Arguing performance, stability, optimization is easier implemented.
While I don't agree I'm having trouble collecting good ...
4
votes
1answer
3k views
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 ...
22
votes
7answers
4k views
Is it better to store images in a BLOB or just the URL? [duplicate]
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 ...
