Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [distributed-databases]

The tag has no usage guidance.

0
votes
1answer
32 views

What Geopartioning or distributed SQL database can I use? [closed]

I want to split medical data on multiple nodes because I have Swiss, Europeans and Americans and I need to store data in citizen country. I don't want to manage this function in App but in the SQL ...
9
votes
1answer
296 views

What is the difference between Federated and Decentralized Data Warehouse?

I can not find any clear definitions or explanations of any of these. Both seem decentralized. It appears that in Federated DWH, the data is distributed and not integrated into a single repository and ...
2
votes
1answer
62 views

How can coupled databases be kept in sync with selective uni-directional syncing and with connections that can be off for days?

I am trying to create a database topology that looks like this: .------------. Bad Connection. Bad Connection. | Central DB | May go offline May go offline '-----...
1
vote
0answers
168 views

Error on cassandra-3.11.3-1.noarch centos7

I've a cluster consisting of 5 cassandra nodes. The cassandra version used is cassandra-3.11.3-1.noarch The keyspace strategy and is defined as follows: CREATE KEYSPACE my_keyspace WITH ...
1
vote
0answers
12 views

Is a distributed database needed for a low-data use, quick read, low write, AP system?

this may not be the proper place to ask this question, but I was not welcome posting it on StackOverflow so I thought this may be a good place. If this is the wrong place, please refer me to the right ...
1
vote
0answers
56 views

NuoDB - Where's the catch?

I've been reading on the promise of an ACID compliant database management system without sacrificing horizontal scaling capabilities. Where is the catch? Which part of the CAP theorem did they choose ...
0
votes
1answer
201 views

What's MongoDB's default behaviour when no sharded collection is specified

When we deploy a Sharded Cluster, without having a sharded collection in our database, what is the default behaviour of MongoDB? How does MongoDB, distributes the data across the shards?
5
votes
1answer
4k views

Insert into linked server fails with “The transaction manager has disabled its support for remote/network transactions”

Two servers: sq009 and sq202, both running SQL Server 2012 SP3. sq202 is the SQL Server hosting the DB for our ERP system, Sage 500. sq009 is the SQL Server hosting the DB for our IBM Maximo instance....
1
vote
0answers
115 views

Git as distributed and decentralized storrage with regard to ACID and CAP

When using Git to store documents distributed and decentralized it can be considered as a database. How would the ACID properties and the CAP theorem correspond to git in this case? I think one has ...
-1
votes
1answer
280 views

Database structure for a customer shopkeeper website

I am working on a project in which there will be two spaces for the customer and the shopkeeper. Multiple shopkeepers can insert data and can modify the products in their shop(they will have a unique ...
1
vote
1answer
31 views

Is there a way to configure a distributed environment with mongodb? [closed]

Can I configure a distributed environment system with mongodb? (For example, master and slave structures) My job is to insert the data into the master and read the data, Slave nodes read data by ...
0
votes
1answer
65 views

MySQL Replication after a set period of time

I have a question about MySQL replication: can I set the slave DBs to only poll the master DB for information once every 10 seconds? Our MySQL master DB is under fairly heavy load. By default, MySQL ...
3
votes
1answer
171 views

Best practice bring MS SQL database to remote sites

Currently we use terminalservers to enable remote users to work with a central LOB-application. The terminalserver is on the same LAN as the MS SQL-server. Now my question is: what is the preferred ...
1
vote
0answers
88 views

What's an example of a Distributed Database Query?

Since I may not come across or get a chance to use a distributed database system. I would like to understand an example of a Distributed Database Query. I know that in a distributed system, you have ...
3
votes
1answer
66 views

Can Cassandra be used to increase database write rate?

I am developing a database for an analysis job that requires parsing terabytes of information into a database. My job is to create and populate a database and using it to answer analyst's questions. ...
1
vote
0answers
54 views

Is it possible to have a partition to distribute transaction load horizontally in SQL Server 2016?

In Cassandra, you can have a partition key to align partitions to particular server nodes. My understanding is that you can distribute transactional responsibility horizontally in SQL Server 2016 (...
0
votes
1answer
502 views

Distributed database for worldwide LIDAR point cloud [closed]

I have an idea for a project that would build a free worldwide 3D scan of the real world. You may think of it as a high-definition version of OpenStreetMap (OSM) project. The point cloud data would ...
0
votes
1answer
60 views

generate unique primary key for all clients from the local database and NOT the server

I'm using MySQL Innodb database to work as a distributed database among many places and also each place will work offline but at the end all the data will be centralized in one server, I want to ...
1
vote
1answer
631 views

Replication Subscribers and AlwaysOn Availability Groups (SQL Server)

I have AlwaysOn Availability Groups configured with Replication Subscribers, and is currently running successfully with one publisher using the command below. -- commands to execute at the publisher,...
5
votes
1answer
6k views

Horizontally scaling SQL Server, distributing the database with sharding

I wanted to know if there is any way to distribute a SQL Server (I'm using 2012 version) database accross multiple nodes. I'm trying to compare READ queries performance between SQL Server and MongoDB. ...
2
votes
1answer
1k views

Distributed database implementation in sql server

Currently, We have central Database at Head Office and users from sub offices ,scattered around the country, connect to central database. Now we want to distribute the database in disconnected mode at ...
2
votes
0answers
118 views

Distributing MS Access Database

I develop an application that saves records in MS Access DB. Each user has it own DB copy on his local machine, and there is a central DB that reflects all the copies from everyone. The central DB is ...
1
vote
0answers
224 views

Implementing a unique primary key for distributed databases

I've got an issue to find a way to create a global primary key to a given relation (namely "Patient") In a distributed database there are three local sub-systems: surgery department, emergency ...
0
votes
1answer
72 views

Machine learning database Big data

Which databases can I use for storing object features for machine learning use case, in case of Big data? To explain a bit more - object features basically represent an object in a form of an array ...
2
votes
1answer
129 views

Postgres data integration

Consider a scenario where I have 3 standalone running Postgres engines that are installed on three separate machines. The data on this machine is inserted, updated or removed each month by employees. ...
1
vote
2answers
3k views

MYSQL find if a default value has been set for a table (DateTime Specifically)

I am trying to internationalize a database, but there are places where the timestamp that gets set is using NOW() instead of UTC_TIMESTAMP(), and it's using Amazon's RDS with multiple MySQL servers. ...
2
votes
0answers
389 views

OrientDB distributed architecture

Technically this question could relate to any database that performs in a similar distribute manner but given that I am specifically working with OrientDB I thought the question should be target as ...
0
votes
2answers
930 views

xml parameter to distributed query - difference between SQL2005 & SQL2012

I have inherited an old SQL2005 Enterprise database (on Windows 2003) that allows an xml parameter to a distributed query such as this: exec sp_executesql 'exec [server].[database].dbo.sproc @Id=@Id,@...
1
vote
0answers
37 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 of ...
2
votes
1answer
319 views

Need scalable database solution for very big automated data entry database

I've been working on MySQL database in simple web applications for a long time and i now have a project which should maintain about 1,000 up to 10,000 query per minute (it is some logging database ...
4
votes
2answers
80 views

Simultaneous money withdrawls from a distributed/replicated database

Lets say I have $10 in my bank account. The database is replicated in North America and Asia. At the exact same time I do a withdrawl of $10 in N. America and in Asia, meaning that my withdraw would ...
5
votes
3answers
4k 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 ...
0
votes
1answer
836 views

Oracle DB - Is it possible to distribute data of a table onto multiple servers?

BigTable[1]-like systems (HBase[2] for instance) allows a table to be distributed transparently accross multiple servers. This works as follows: Each server perform the read/writes operations on ...
0
votes
2answers
4k views

Alternatives for Dblink in oracle?

we have an SSIS job that inserts data into a table in server A from data in table which is located in some other server B. For this,we are making use of dblinks to connect to other database . But, ...
2
votes
1answer
451 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 ...
1
vote
1answer
110 views

Designing a fragmentation database? [closed]

I did some research about distributed databases, but I still have some questions. I understand there is something called "fragmentation database" but I can't find any help full document for ...
0
votes
1answer
77 views

Linked SQL Servers

I'm trying to link 2 SQL Servers (2008 and 2005). I have tried it via the GUI and scripts, and having no luck. I have problems trying to to query through it with access. As I'm not the Admin of the ...
1
vote
2answers
8k views

Distributed Database Architecture Using MySQL Replication

I've been task to move our web servers to the cloud for all countries that use our services for localization. The issue is, they must share the same data and therefore I need to set up some database ...
2
votes
2answers
4k views

Difference between partitioning and fragmentation [closed]

I'm trying to learn something about distributed databases and I stumbled upon the concepts of fragmentation and partitioning. It seems to me as if both do the same thing and produce similar results (...
0
votes
1answer
817 views

How to install and configure Postgres-XC in windows?

Can anybody suggest me any resources of the complete installation procedure of postgres-XC in windows. I've installed postgresql-9.2 in my windows and can use it. Now I need to know the installation ...
0
votes
3answers
2k views

how to find vertica community edition and how to export / copy data

I have the hardest time downloading anything other than enterprise edition from vertica.com. It is supposed to have a community edition on https://my.vertica.com/community/ but all the links just show ...
16
votes
3answers
10k views

Consistency in ACID and CAP theorem, are they the same?

From my understanding, the consistency in ACID is ensuring the data integrity. However, the consistency in CAP means the data can appear quickly in distributed system. Does that mean: they are not ...
3
votes
1answer
630 views

DB2 Express-C 10.1 database move to DB2 Work group Server/Enterprise Edition

I have not done such migration before and I want to know if I am going to face such issues when moving my database (tables,views,table-spaces,functions,procedures,etc.) to other DB2 distribution. If ...
3
votes
0answers
631 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
1answer
910 views

Model for Distributed Database [closed]

I want to design a model for a distributed database solution. Are there appropriate tools and approaches? How to include stereotypes for (horizontal) fragments?
3
votes
2answers
396 views

Database choices for big data

I have many text files, their total size is about 300GB ~ 400GB. They are all in this format key1 value_a key1 value_b key1 value_c key2 value_d key3 value_e .... each line is composed by a key and ...
3
votes
1answer
186 views

Distribute MySQL in different cities?

We have our main MySQL server in city A. We have the bulk of our customer service staff in city B. The staff are complaining that the connection is too slow to the server. The options are: Have them ...
3
votes
1answer
331 views

PostgreSQL synchronized commit performance

I'm setting up a pair of PostgreSQL servers. Because cash is short I can only afford one high class server and some crapy backup box. If the expensive high end box should catch fire, operations can ...
3
votes
1answer
1k views

Does the pgpool-II extension allow for parallel execution of any query?

I read about pgpool-II here and it states that: Using the parallel query function, data can be divided among the multiple servers, so that a query can be executed on all the servers concurrently to ...
10
votes
1answer
2k views

Why can't we perform joins in a distributed database like Bigtable?

From this answer to "What database does Google use?": Bigtable is not a relational database. It does not support joins nor does it support rich SQL-like queries. Is this obvious? I do not ...