The database-theory tag has no wiki summary.
1
vote
1answer
76 views
Approach for a 2,000 table migration
What might be the best approach when converting or migrating a database containing over 2,000 tables? Where would you begin to tackle such an issue? Steps to take in the first weeks of designing? ...
-1
votes
0answers
22 views
XML and Object Oriented databases [closed]
I just want to know are object-oriented databases and XML databases two separate databases or is the XML database incorporated into the object-orientated database?
0
votes
2answers
41 views
Column partially determining accepted values of another column, should be somehow normalized?
I have a table that describes a set of properties (yes it's metadata, in this case there's a valid reason to have it in the database); among other things I tell the type of the data that can be ...
1
vote
1answer
29 views
Adding users to a list and sort by category?
I'm using SQL-Server 2012 and I would like to know how to solve this program.
So:
I want to create a page that allows admins to manage a project, and part of it, would be to add members/employees to ...
0
votes
2answers
41 views
Multiple instances in Oracle
I'm really confuse with the term instance and database. So, my first question is how database and Instance are related in Oracle, I mean, whether an instance is associated with one/multiple ...
1
vote
0answers
17 views
Closure of attributes definition clarification
A databases book I am using states [1]:
The closure of {A1, A2, ..., An} under the FD's in S is the set of attributes B such that every relation that satisfies all the FD's in set S also satisfies ...
-1
votes
1answer
74 views
How can I move 5 GB data from one database to another faster?
I'm using MySQL as database with Windows server. I'm having 5 GB of data in database. Now I need to change my server and the question is that how can I transfer complete 5 GB data to one mysql ...
0
votes
0answers
28 views
Examples of a database with no consistency measures that ensures consistency through schema alone
To clarify, the database can be any type RDBMS, NoSQL/BigTable. However, it must not employ any usual consistency measures such as locks, or synchronization, but the inconsistency-invincibility must ...
0
votes
2answers
59 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
0answers
59 views
In DBMS binary relationship is better than ternary
For which reasons (Features/points) binary relationship is better than ternary one in Database ER modeling? I got something by searching in website but those are not precise and meaningful!
1
vote
2answers
128 views
Reflexivity axiom for inferring functional dependencies
As you know there are three Armstrong's Axioms for inferring all the functional dependencies on a relational database. (X, Y and Z are set of attributes)
Reflexivity: If X ⊆ Y, then Y → X
...
1
vote
1answer
99 views
Deriving formulas for input/output
I'm currently enrolled in a DBS class and am having problem with an assignment. I've searched around and have been unable to understand what it is I'm meant to be doing with this derivation formula.
...
0
votes
0answers
31 views
what are some reasons that we move data between different environment? [closed]
We can move data using backup-copy-restore and detach/attach, right. But what are the reasons for moving these data. I'd think we move data to another environment for recovery purpose or to build data ...
0
votes
1answer
174 views
Keep total transaction in invoice application
I want to make an application called as Invoice Application with MySQL database. Now I have designed this database. Now I want to know is this database good for Invoice Application. I will use MySQL ...
1
vote
1answer
438 views
Planning simple CMS: How much relation?
I'm currently in the process of designing the database for a rather minimalistic Content Management System I'm working on alone. It should allow scalability while remaining speed, especially on boxes ...
