Top "Rdbms" questions

A relational database management system (RDBMS) is a database management system (DBMS) in which data is stored in tables and the relationships among the data are also stored in tables.

Why don't DBMS's support ASSERTION

So I recently learned about ASSERTION in my databases course, and my prof noted that major databases don't support it, …

sql rdbms database
Help me put Oracle terminology into SQL Server terminology

My company is now supporting Oracle for the first time, and most of my colleagues are SQL Server developers who …

sql sql-server oracle terminology rdbms
Is it possible to create a deadlock with read-only access?

I have a VB6 application accessing a single table on a MSSQL2000 server via ADO. I'm using read-only access (adOpenStatic, …

sql-server ado rdbms deadlock
Difference between Avrodata file and Sequence file with respect to Apache sqoop

In sqoop's perspective what is the difference between importing a relational table as a sequence file like- sqoop import --connect …

hadoop rdbms sqoop
When to replace RDBMS/ORM with NoSQL

What kind of projects benefit from using a NoSQL database instead of rdbms wrapped by an ORM? Examples: Stackoverflow similiar …

nosql rdbms
Example of a task that a NoSQL database can't handle (if any)

I would like to test the NoSQL world. This is just curiosity, not an absolute need (yet). I have read …

mongodb rdbms acid nosql
Is there an official name for the many-to-many relationship table in a database schema?

Most of the projects I've worked on have required many-to-many relationships in the database schema. For example, you might have …

database naming-conventions rdbms
What is the easiest way to copy a database from one Informix IDS 11 Server to another

The source database is quite large. The target database doesn't grow automatically. They are on different machines. I'm coming from …

migration rdbms informix administration
Oracle dump (.dmp) file format

I am wondering about how is the internal format of a .dmp file (dump file, or backup and restoration file) …

oracle format rdbms dmp
PostgreSQL Long VACUUM

I am currently cleaning up a table with 2 indexes and 250 million active rows and approximately as many dead rows (or …

postgresql rdbms vacuum