Click here to Skip to main content
14,669,422 members
Home » Discussions » Database
   

Database

 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 2:50
professionalEddy Vluggen6-Feb-20 2:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 22:28
professionalJörgen Andersson5-Feb-20 22:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 0:17
mveRichard Deeming6-Feb-20 0:17 
Questionintegrity constraint Pin
Tara112-Feb-20 6:23
MemberTara112-Feb-20 6:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 8:47
mveWendelius2-Feb-20 8:47 
GeneralRe: integrity constraint Pin
Tara112-Feb-20 9:07
MemberTara112-Feb-20 9:07 
GeneralRe: integrity constraint Pin
markkuk2-Feb-20 23:48
Membermarkkuk2-Feb-20 23:48 
Questiontransaction recovery Pin
Tara112-Feb-20 5:46
MemberTara112-Feb-20 5:46 
The quote below is from *An Introduction to Database Systems, 8th edition, C J Date*.
Is that possible systems crash while transferring the updates from physical device to database?
"It is quite possible, for instance, that the system might crash after the COMMIT has been honored but before the updates have been physically written to the database--they might still be waiting in a main-memory buffer and so lost at the time of the crash. Even if that happens, the system's restart procedure will still record those updates in the database: it is able to discover the values to be written by examining the relevant records in the log."


modified 2-Feb-20 13:48pm.

AnswerRe: transaction recovery Pin
Eddy Vluggen3-Feb-20 3:00
professionalEddy Vluggen3-Feb-20 3:00 
QuestionCopy structure of all the tables of one database to another server Pin
Member 1473192331-Jan-20 4:58
MemberMember 1473192331-Jan-20 4:58 
AnswerRe: Copy structure of all the tables of one database to another server Pin
phil.o31-Jan-20 5:12
mvephil.o31-Jan-20 5:12 
AnswerRe: Copy structure of all the tables of one database to another server Pin
Eddy Vluggen3-Feb-20 3:01
professionalEddy Vluggen3-Feb-20 3:01 
Questionintegrity constraint Pin
Tara1129-Jan-20 10:36
MemberTara1129-Jan-20 10:36 
AnswerRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 10:56
professionalMycroft Holmes29-Jan-20 10:56 
GeneralRe: integrity constraint Pin
Tara1129-Jan-20 11:05
MemberTara1129-Jan-20 11:05 
GeneralRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 11:21
professionalMycroft Holmes29-Jan-20 11:21 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 9:01
mveWendelius2-Feb-20 9:01 
QuestionOracle SQL query to MS-SQL Pin
Member 951930620-Jan-20 22:37
MemberMember 951930620-Jan-20 22:37 
AnswerRe: Oracle SQL query to MS-SQL Pin
Richard Deeming21-Jan-20 1:43
mveRichard Deeming21-Jan-20 1:43 
GeneralRe: Oracle SQL query to MS-SQL Pin
Member 951930628-Jan-20 22:44
MemberMember 951930628-Jan-20 22:44 
GeneralRe: Oracle SQL query to MS-SQL Pin
Mycroft Holmes29-Jan-20 10:59
professionalMycroft Holmes29-Jan-20 10:59 
Questionsplit time then group by 15 min mongodb Pin
Member 1300557210-Jan-20 21:56
MemberMember 1300557210-Jan-20 21:56 
QuestionSQL Query with a Loop Pin
Bobby Underwood6-Jan-20 4:58
MemberBobby Underwood6-Jan-20 4:58 
AnswerRe: SQL Query with a Loop Pin
#realJSOP6-Jan-20 5:04
mva#realJSOP6-Jan-20 5:04 
AnswerRe: SQL Query with a Loop Pin
Bobby Underwood6-Jan-20 5:11
MemberBobby Underwood6-Jan-20 5:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.