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
20
votes
10 answers

With the recent prevelance of NoSQL databases why would I use a SQL database?

After developing software for about 5 years now, I have spent probably atleast 20% and perhaps up to 40% of that time simply making a RDBMS able to save and retrieve complex object graphs. Many times this resulted in less than optimal coding…
Chris Marisic
  • 32,487
  • 24
  • 164
  • 258
20
votes
8 answers

Is Functional to Relational mapping easier than Object to Relational?

Object-relational mapping has been well discussed, including on here. I have experience with a few approaches and the pitfalls and compromises. True resolution seems like it requires changes to the OO or relational models themselves. If using a…
WW.
  • 23,793
  • 13
  • 94
  • 121
20
votes
14 answers

Why have object oriented databases not been successful (yet)?

That's the question. Give only one reason you think why have OODB failed or why many systems nowadays still use relational databases.
lurks
  • 2,576
  • 4
  • 30
  • 39
19
votes
2 answers

Can redis fully replace mysql?

Simple question, could I conceivably use redis instead of mysql for all sorts of web applications: social networks, geo-location services etc?
Travis Glines
  • 403
  • 5
  • 8
19
votes
3 answers

Why NoSQL say traditional RDBMS is not good at scalable

I've read some article say that RDBMS such as MySQL is not good at scalable,but NoSQL such as MongoDB can shard well. I want to know which feature that RDBMS provided make itself can not shard well.
shuitu
  • 253
  • 1
  • 2
  • 7
19
votes
5 answers

NoSQL / RDBMS hybrid with referential integrity (delete cascade)?

Is there a database out there that gives you the benefit of referential integrity and being able to use a SQL type language for querying, but also lets entities be loosely defined with respect to their data attributes and also the relationships…
SeriousCallersOnly
  • 429
  • 3
  • 6
19
votes
8 answers

Transaction support in MongoDB

I am new to MongoDB. I read that MongoDB does not support multi-document transactionshere http://docs.mongodb.org/manual/faq/fundamentals/. If I want to save data in two collections(A and B) atomically, then i can't do that using MongoDB i.e. if…
Anand
  • 20,708
  • 48
  • 131
  • 198
19
votes
2 answers

What is the disadvantage of just using Redis instead of an RDBMS?

So if for example I am trying to implement something that looks like Facebook's Graph API that needs to be very quick and support millions of users, what is the disadvantage of just using Redis instead of a RDBMS? Thanks! Jonathan
Jonathan Leung
  • 2,051
  • 2
  • 19
  • 24
18
votes
1 answer

Object Oriented Database Vs object Relational Database

I wonder how Object Oriented data modeling is different from Object Relational data modeling? Is it something like the pluses of both object oriented and relational data modeling were clubbed to achieve object relational data modeling? cheers
Arnkrishn
  • 29,828
  • 40
  • 114
  • 128
18
votes
6 answers

Update specific field on SOLR index

I want to using solr for search on articles I have 3 table: Group (id , group name) ArticleBase (id, groupId, some other field) Article(id, articleBaseId, title, date, ...) in solr schema.xml file i just define all article field that mixed with…
Hamid
  • 1,099
  • 3
  • 22
  • 37
17
votes
8 answers

Does MS-SQL support in-memory tables?

Recently, I started changing some of our applications to support MS SQL Server as an alternative back end. One of the compatibility issues I ran into is the use of MySQL's CREATE TEMPORARY TABLE to create in-memory tables that hold data for very…
Hanno Fietz
  • 30,799
  • 47
  • 148
  • 234
17
votes
1 answer

Why is it recommended to avoid unidirectional one-to-many association on a foreign key?

Possible Duplicate: Hibernate unidirectional one to many association - why is a join table better? In the Hibernate online documentation, under section 7.2.3 One-to-many, it's mentioned, that: unidirectional one-to-many association on a…
Shaw
  • 1,484
  • 4
  • 20
  • 31
17
votes
5 answers

Why aggregate functions in PostgreSQL do not work with boolean data type

Why we cannot use boolean values in aggregate functions without casting to some integer type first? In many cases it makes perfect sense to calculate sum, average or correlation from columns of boolean data type. Consider the following example where…
Tomas Greif
  • 21,685
  • 23
  • 106
  • 155
16
votes
2 answers

How can I calculate database design storage costs?

I often have a couple different schema's in mind when starting project. After making rough guesses I realize that some are less optimized for growth or storage space than others. Obviously, the size of the column value is the main thing. But table…
Xeoncross
  • 55,620
  • 80
  • 262
  • 364
16
votes
1 answer

How to create a database diagrams in visual studio code?

I am trying Visual studio code to code the database but I cannot create the database diagram. Is there a way I can create it just like in SSMS. Thank you.
NVS
  • 161
  • 2
  • 2
  • 4
1 2 3
…
99 100