The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
566 views

What are alternatives to Replication to distibute data (Microsoft SQL Server)

Is anyone knowledgeable of alternatives to SQL Server replication? I have a scenario where separate databases will share a lot of the same data which complex queries will match against. We want to ...
2
votes
0answers
311 views

Upgrading Remote Distributor in SQL Server Replication

I'm upgrading my remote distributor from 2005 to 2008r2, it is performing transactional replication only. this is a prerequisite to completing an upgrade of the Publisher to 2008r2. Script ...
1
vote
0answers
9 views

Does the consistency part of the CAP theorem apply to updates and not first-time writes?

Using this definition of the CAP theorem: Consistency All database clients see the same data, even with concurrent updates. Availability All database clients are able to access some version ...
1
vote
0answers
166 views

Distribute records on different MySQL databases - MySQL Proxy alternative

My scenario is the following: Right now I am using one big MySQL database with multiple tables to store user data. Many tables contain auto increment columns. I would like to split this into 2 or ...
0
votes
0answers
9 views

In face of a network partition (P), does Neo4J HA allow read stale data?

In Neo4j docs it says that it is partition tolerant, but in further descriptions their docs does not make clear what happens if a network partition occurs. It enables a fault-tolerant database ...
0
votes
0answers
31 views

Is database sharding done on a table level or database level?

I'm new to sharding databases, so I'm trying to wrap my head around it. Let's say we have a database that has 3 tables: Customer, Suppliers and Orders. Each table has 10 million records. I want to ...
0
votes
0answers
32 views

Ascending and descending semi-joins

I was reading about semi-joins for a research paper implementation. i have to select the best way to reduce tables in a distributed environment for a particular query. for that it has 2 different ...