The discipline of Operational and Architectural Management of Database Systems.
2
votes
3answers
145 views
Merging tables with a 1 to 1 relationship in a database
Is it a good idea to merge two tables that have a 1..1 relationship together?
I have inherited a database with too many tables linked together in a 1..1 relationship. I'd like to evaluate the ...
0
votes
0answers
68 views
Connecting PCs with APEX
I am working on a Project using APEX.
I want to connect my friend to APEX so we can do work and assign tasks to each other.
Our PCs are connected to the same LAN and I can PING both PCs, however I ...
2
votes
1answer
271 views
When dedicated server process model should be used instead of shared process model?
It looks like Oracle shared server process model is better than dedicated server process model. In a shared server configuration, client user processes connect to a dispatcher and it can support ...
7
votes
5answers
1k views
Are there any good and free tools for managing a PostgreSQL database?
Before, I have used phpmyadmin to manage an MySQL database, but now I would like to manage a PostgreSQL database. The PostgreSQL database is on a server, but not a webserver, so I don't use PHP.
Are ...
5
votes
2answers
6k views
What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?
I am very new to Database Administration.
I face a lot of problems while setting up mysql master-slave replication.
I also face regular mysql replication troubleshooting issues.
Can anybody helps ...
2
votes
2answers
981 views
Disabling Checking of Schema On Function/Stored Procedure Creation
I'm trying to automate the process that executes changes to the SQL Server 2008 R2 database. The process I put in place drops and recreates my stored procedures and functions, as well as run scripts ...
3
votes
3answers
114 views
Is this database fine for calculation?
I am doing an application called as Invoice Application.For that I have my database is like this.
Now my problem comes when I am taking the tax part in my database.As I have made tax as an option ...
5
votes
1answer
327 views
Does dropping a Primary Key constraint from a Partitioned Table break the partition?
We have a table partitioned on a date column. The Primary Key for the table is a composite key of this date column and 4 other columns.
We are thinking about dropping the Primary Key constraint from ...
0
votes
0answers
124 views
Oracle Data Guard Fast-Start Failover Questions
Here is the setup in question:
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dbabc
Observer: (none)
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
...
4
votes
4answers
186 views
Recommendation for free event monitoring software
I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough.
There are some interesting suggestions in this ...
-3
votes
1answer
213 views
Single query to copy data from 3 tables into a single empty table
In an interview today, I was asked if I could write a single query to copy data from 3 source tables to an empty destination table.
I started saying "I will use a temp table or table variables", ...
1
vote
1answer
411 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 ...
1
vote
1answer
581 views
Solution to error NID-00135 in Oracle 10g, Solaris 10
We are trying to build a test version of a production database by restoring the production backup using RMAN and renaming the database to test.
We've successfully restored and opened the database ...
0
votes
1answer
193 views
Unable to restore database in Oracle 10g
I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message.
...
2
votes
1answer
78 views
How to get dependencies order
I have a Database Called Total and I have about 40 tables in it.I am trying to move the tables in the database into a different server So I have prepared all the create table scripts but the problem ...
2
votes
4answers
1k views
Small sample database for practicing database administration?
I'm looking for a portable sample database that
can be created from a script
has a simple ER model
has little data for database administration practicing purposes.
I know that there is e.g. ...
4
votes
3answers
117 views
Can anyone describe the step by step process of recovery , backup and restore in sql server
Can anyone describe the step by step process of recovery via backup and restore in SQL Server 2008.
If possible please include some examples.
0
votes
1answer
56 views
Is Index Used for This Query
If so, which one?
How do we know?
I have 3 indexes in a query. Actually only the first 2 should be useful
{
"v": NumberInt(1),
"key": {
"LongitudeLatitude": "2d",
"Prominent"▼: ...
5
votes
1answer
1k views
Is it possible to synchronize two ms access db?
We have a flower store where we use MS Access and a client program to work with the database. But this program can work only with one database.
We are going to open a new store, so now we have to ...
0
votes
1answer
544 views
How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
I´m new to SQL Server administration.
I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary).
Is there some way ...
2
votes
1answer
189 views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
0
votes
1answer
370 views
WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
The scenario
Two systems(not server) running PHP and PostgreSQL with the following versions
Fedora 15:
PHP
PHP 5.3.13 (cli) (built: May 9 2012 14:38:35)
Copyright (c) 1997-2012 The ...
2
votes
2answers
487 views
Why database diagrams are not working when domain account is attached to database owner?
I was trying to use Database diagrams is SQL Server and got following error:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first ...
0
votes
1answer
117 views
Database designed in facebook [closed]
I want to know which database is used in Facebook?How the database is designed to make virtual friend list in the database of a user?
3
votes
2answers
102 views
What are sensible/rational character limits in a database e.g. for a persons name
This is a general question about database admin.
Is there some kind of standardization for character limits on fields in a DB? It makes sense to specify character limits on the database end for ...
0
votes
1answer
142 views
Data storage in innodb
I am new to mysql administration and I came to know about the data storage in myisam is through .frm, .myd and .myi. I could not find the data storage mechanism in InnoDB rather than its storage in ...
3
votes
2answers
632 views
Rebuilding index has impact on mdf/ldf files SQL Server 2008
While rebuilding index have used option 'SORT_IN_TEMPDB = ON' in order to avoid unnecessary growing your user database files.
What does it exactly means?
Is complete process done on TempDB and does ...
0
votes
2answers
234 views
Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well?
Operating system used is linux. I have tried Navicat and SQL Power Architect. They did display relations between tables in the same schema. I have some foreign key constraints which reference tables ...
1
vote
1answer
991 views
Cannot browse for Backup files using SSMS
I'm facing a strange problem.
When I try to backup or restore any database using a SQL Server user (not sa) that belongs only to "public" server role, i have the following error when i click the ...
0
votes
1answer
662 views
What is going wrong with postgresql initdb? Why is the `UTF-8` encoding not getting enforced?
I am using PostgreSQL 9.1. Trying to enforce UTF8 encoding as default.
This is what I am doing.
service postgresql initdb -E 'UTF-8' \
--lc-collate='en_US.UTF-8' \
...
8
votes
2answers
493 views
Recovering logical space from a tablespace
I have a tablespace called DATA, and it is setup with auto-extend as false. This tablespace has two datafiles and is set up so it takes up 350 GB of physical space.
A week ago I queried ...
1
vote
2answers
169 views
PostgreSQL : Is this because of locks(row level)?
I have a table with approximately 2.1 million tuples. Which has latitude and longitude columns. I am trying to convert this into a geographic type (point with SRID).
The function(procedure) I have ...
2
votes
1answer
485 views
Pgpool-II: sequences advanced by 1 after PITR recovery
I have tested pgpool-II 3.0.1 and pgpool 3.0.4, PostgreSQL 8.4
In both cases I'm getting the same result: after online recovery on primary and target nodes all 'serial' values got "+1". Other nodes ...
2
votes
2answers
1k views
Difference between Row based and statement based replication in Mysql?
What is the Actual difference between Row based and Statement based replication I actually looking in terms of replication effect's on slave.
If I am using Row based replication then whats is the ...
2
votes
1answer
2k views
Is it possible to do a datapump import with a different user than did the export?
I have one db dump below is the log file for that dump
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** ...
2
votes
0answers
141 views
SQL Server SSIS issue retrieve data when i enter into login of server side?
can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side
here is the error message
TITLE: Microsoft SQL Server Management Studio
...
2
votes
2answers
233 views
Help with Vehicle Service database
I am using the Desktop Vehicle Maintenance template in access, but i am trying to cater it towards our farms needs.
We will be keeping track of the service's done on Trucks, Tractors, Equipment, etc.
...
1
vote
2answers
696 views
Unable to mount oracle instance
I am trying to shutdown the system, then I want to mount it. I have tried this:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
...
2
votes
1answer
81 views
database connection time expired issue
I have a server machine and four client machine for database connectivity.
I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through ...
6
votes
3answers
162 views
Can I check the services currently running through SSMS?
I want to check which services has started and which has not by running a script/query on SSMS.
9
votes
1answer
332 views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
3
votes
2answers
1k views
pt-table-checksum help required
I am trying to figure out pt-table-checksum, as I am using it for the first time.
It look likes the documentation is complex and not easy to understand stuff.
I have a complex replication topology ...
2
votes
1answer
173 views
Active Directory domain being shutdown— Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
2
votes
1answer
701 views
MySQL : “FLUSH TABLES WITH READ LOCK” started automatically
I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being ...
11
votes
3answers
2k views
SQL Server 2008 R2 “Ghost Memory”?
We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
4
votes
1answer
1k views
Capabilities of InnoDB INSERT Performance
Hi I am running the most recent version of Percona Server.
Server version: 5.5.24-55 Percona Server (GPL), Release 26.0
I have a 10 cpu box of these characteristics.
processor : 0
vendor_id ...
3
votes
1answer
59 views
Administration of MySQL Users
What is the best practice for keeping and maintaining MySQL users? Say for example I have 5 programmers and a PHP application connecting to a database. Should I create 6 different users 1 for each ...
2
votes
2answers
95 views
which option is better for not slow down the performance of queries?
I am developing a system that records customer payments, when a customer makes a payment, the system must update the account and show the payment made and all previous payments, is here when the ...
-1
votes
1answer
164 views
What exactly is SOLR? [closed]
It seems like a magical technology that can
Do spatial search
do full text search
The problem is,
It doesn't say where does it store all the data. Does it have it's own proprietary database
If it ...
0
votes
2answers
221 views
DBA to work from home [closed]
I was wondering is it feasible or doable to work from home as a DBA or Database designer/developer or Business intelligence developer.
I have seen developers doing great working from home, but can ...
