All Questions
-1
votes
0answers
5 views
Problems installing Oracle XE 11g on Fedora 20 - No apex, no network access
I need to setup a temporary Oracle XE database on a virtual machine to work as a server, so I choose Feroda as Oracle mainly support RedHat.
So, this is what I did:
a) Downloaded newest version of ...
0
votes
1answer
11 views
INSERT take too much time
I have in my MySQL DB a few tables
Most of the time, I'm only doing INSERT in my db. I have up to 4 connections to the DB, each one inserting into a different table. There cannot be two connections ...
0
votes
0answers
9 views
What inefficiency does sharding & partitioning attempt to address?
I have never implemented sharding or partitioning, but from what I understand, multiple servers are used to distribute large amounts of data.
Is this because of a limited hardware budget or to ...
0
votes
1answer
16 views
PostgreSQL problems on Ubuntu 12.04
I'm having terrible problems with PostgreSQL initialization on my VPS. I followed several tutorials on this topic and nothing made my database server work.
I followed these steps:
sudo apt-get ...
0
votes
1answer
26 views
Where can I get best resources to learn sql? [duplicate]
I am very new to the databases just have basic knowledge about it.
I want to learn sql language and dont know where to start. Please help me to start with it.
And what is the difference between ...
-3
votes
0answers
34 views
Correlation between BI developer and Web Analyst? [on hold]
These days, I'm studying to become a business intelligence developer and today I'm reflecting If I need necessary knowledge as a web analyst.
My question is.
Is there a correlation between BI ...
1
vote
1answer
19 views
Backup architecture for frequent backups of business critical DB
We've got a database (mysql) driven application which contains business critical information, were looking at building a system that will allow us to backup the db frequently (every 15 minutes, ...
1
vote
1answer
16 views
Mongo db and sharding / replica sets concept questions
I have few questions about sharding and replica sets:
I am planning to write important logs to a sharded environment. about 100 million rows in a day, If I will connect to a single MONGOS process , ...
1
vote
2answers
19 views
Multiple “model” DBs — or db creation 'profiles'
I know you can't actually have multiple 'model' DBs on the same server instance. BUT, I'd like to have something almost like it. Basically, we have a business model where each customer is its own DB, ...
2
votes
1answer
19 views
redundant foreign keys in PostgreSQL - are there any indexing benefits?
Note: this is not the same as this SO question which is about adding redundant information in the tables themselves.
Does the final statement in the below series of statements buy me anything in ...
2
votes
1answer
49 views
Enforcing constraints “two tables away”
I ran into some trouble modeling an electrical schematic in SQL.
The structure I'd like to capture is
part ←────────── pin
↑ ↑
part_inst ←───── pin_inst
where "inst" is short ...
1
vote
1answer
45 views
What problem prevents well defined behavior of a foreign key on a non-unique column?
In my noob opinion, it strikes me that in a serialized environment, this shouldn't be a problem.
Is that correct? If not, please explain to me why a foreign key's behavior on a non-unique column is ...
0
votes
2answers
26 views
Configure postgresql recovery again to be slave
I completed a replication setup using PostgreSQL. Everything was working fine, so I proceeded doing a test by bringing down the main database and promoting the slave to be new master (via touch ...
3
votes
0answers
21 views
User locking tables without privileges
This is a restatement of a question asked on the GIS Stack Exchange here. Although it has GIS-specific elements it may be be a more general PostgreSQL effect.
I have a PostgreSQL 8.4.4 database ...
0
votes
0answers
10 views
Undo tablespace size in many data import in short number of tables
Yesterday i've had many problems trying to import a big dump file with only 9 tables but many rows in each table.
In common use the undo tablespace has a size of 1.5 Gb. But when trying to import the ...
