Stack Overflow
Stack Overflow

Questions tagged [rdbms]

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.

A relational database management system (RDBMS) is a database management system () that is based on the relational model as introduced by E. F. Codd, of IBM's San Jose Research Laboratory. Many popular databases that are currently in use are based on the relational database model.

RDBMSs have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and much more. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use. However, relational databases have been challenged by object databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational database, and XML databases.

History:
The development for the RDBMS model began at in 1974
The first commercially available RDBMS system was in 1979
The first RDBMS system for Mac OS was in 1984

References:

2783 questions
14
votes
4 answers

Creating indexes with descending key columns with Liquibase

I am wondering if there is a generic way to create an "ordered index" with liquibase. Something that will produce these kind of SQL statement: CREATE INDEX idx_name ON my_table (m_column DESC) I need that for oracle, postgresql, mysql, and sql…
poussma
  • 7,033
  • 3
  • 43
  • 68
13
votes
3 answers

What can an RDBMS do that Neo4j (and graph databases) cant?

“A Graph Database –transforms a–> RDBMS” The Neo4j site seems to imply that whatever you can do in RDBMS, you can do in Neo4j. Before choosing Neo4j as a replacement for an RDBMS, I need some doubts answered. I am interested in Neo4j…
Jesvin Jose
  • 22,498
  • 32
  • 109
  • 202
13
votes
2 answers

Difference between RDBMS and ORDBMS

It happened to me when I was reading about PostgreSQL on its wiki page where it refers to itself as an ORDBMS. I always knew about Microsoft SQL Server which is an RDBM system. Can someone help me understand the main differences between Relational…
RBT
  • 24,161
  • 21
  • 159
  • 240
13
votes
3 answers

What is Locking in MySQL and when would you use it?

What is Locking in MySQL (or any RDBMS) and when would you use it? A Layman explanation with a Example would be great!
Imran
  • 11,350
  • 20
  • 68
  • 78
13
votes
1 answer

what is sequential flooding?

This might be simple, but I can't get my head around it. Can anyone give me an example of sequential flooding? In the textbook I am reading and in Internet sources it is stated When the number of buffer frames is less than the pages in file, this…
WannaBeCoder
  • 1,280
  • 2
  • 17
  • 40
13
votes
2 answers

SQL query for point-in-polygon using PostgreSQL

I have the following simple table: CREATE TABLE tbl_test ( id serial NOT NULL, poly polygon NOT NULL ) WITH (OIDS=FALSE); I then try to insert a row with a polygon: insert into tbl_test values(1, PolyFromText('POLYGON((0 0, 10 10, 10 0, 0…
Assaf Lavie
  • 73,079
  • 34
  • 148
  • 203
12
votes
3 answers

NoSQL Database for Banking System

Is this a good decision to use NoSQL database for a banking system rather than RDBMS? If yes, What are the recommended NoSQL databases for a banking system?
Mahmoud Khaled
  • 6,226
  • 6
  • 37
  • 42
12
votes
1 answer

Data integrity across the databases of different Microservices

I am using relational databases for my microservices. I have CustomersMService which has its own database with table Customer, then I have OrdersMService which also has its own database but with table Order, and that table has column CustomerId. How…
uvytautas
  • 518
  • 8
  • 18
12
votes
3 answers

Efficient persistent data structures for relational database

I'm looking for material on persistent data structures that can be used to implement a relational model. Persistence in the meaning of immutable data structures. Anyone know of some good resources, books, papers and such? (I already have the book…
John Nilsson
  • 17,001
  • 8
  • 32
  • 42
12
votes
3 answers

SQL - Unique Key, Primary Key & Foreign Key

What are the differences between Unique Key, Primary Key and Foreign Key with respect to concept of SQL? How they are different from each other?
Jaipal Reddy K
  • 497
  • 1
  • 4
  • 7
12
votes
3 answers

Why use NoSQL over Materialized Views?

There has been a lot of talk recently about NoSQL. The #1 reason why I hear people use NoSQL is because they start to de-normalize their DBMS data so much so, to increase performance, that they end up with just one table with all of their data…
JustinT
  • 2,481
  • 3
  • 18
  • 11
12
votes
6 answers

Best Way to Store/Access a Directed Graph

I have around 3500 flood control facilities that I would like to represent as a network to determine flow paths (essentially a directed graph). I'm currently using SqlServer and a CTE to recursively examine all the nodes and their upstream…
Michael Todd
  • 16,679
  • 4
  • 49
  • 69
12
votes
1 answer

How would a "NOSQL" database be designed for consumer apps (e.g. social bookmarking)

I've been reading up on a lot of posts about non-relational databases, the whole NOSQL movement, and there's a lot of fresh new activity around it. It seems like a very interesting approach to building highly scalable web applications but…
828
  • 1,140
  • 1
  • 12
  • 21
12
votes
11 answers

Why would I ever choose to store and manipulate XML in a relational database?

Modern RDBMS's have support for XML column types and functionality for dealing with XML in stored procedures. Historically I would always have mapped hierarchical data (whether of OO objects or XML) to relational tables. Given the widespread…
Matthew Murdoch
  • 30,874
  • 30
  • 96
  • 127
12
votes
8 answers

Why is Select 1 faster than Select count(*)?

In Oracle, when querying for row existence, why is Select 1 fast than Select count(*)?
user290
1 2 3
…
99 100