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
295
votes
6 answers

Relational Database Design Patterns?

Design patterns are usually related to object oriented design. Are there design patterns for creating and programming relational databases? Many problems surely must have reusable solutions. Examples would include patterns for table design, stored…
Sklivvz
  • 30,601
  • 24
  • 116
  • 172
227
votes
18 answers

When NOT to use Cassandra?

There has been a lot of talk related to Cassandra lately. Twitter, Digg, Facebook, etc all use it. When does it make sense to: use Cassandra, not use Cassandra, and use a RDMS instead of Cassandra.
JimJim
  • 2,279
  • 2
  • 14
  • 3
173
votes
16 answers

When/Why to use Cascading in SQL Server?

When setting up foreign keys in SQL Server, under what circumstances should you have it cascade on delete or update, and what is the reasoning behind it? This probably applies to other databases as well. I'm looking most of all for concrete examples…
Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
162
votes
9 answers

NoSql vs Relational database

Recently NoSQL has gained immense popularity. What are the advantages of NoSQL over traditional RDBMS?
user496949
  • 83,087
  • 147
  • 309
  • 426
153
votes
9 answers

Check for changes to an SQL Server table?

How can I monitor an SQL Server database for changes to a table without using triggers or modifying the structure of the database in any way? My preferred programming environment is .NET and C#. I'd like to be able to support any SQL Server 2000 SP4…
TimM
  • 1,885
  • 2
  • 14
  • 12
136
votes
3 answers

Difference between DECIMAL and NUMERIC datatype in PSQL

what is the use of decimal and numeric datatype in postgreSQL. As per the reference the following is the explanation given to these datatypes. Decimal,numeric --> It is a user specified precision, exact and range up to 131072 digits before the…
mohangraj
  • 9,842
  • 19
  • 59
  • 94
129
votes
15 answers

Best practices for storing postal addresses in a database (RDBMS)?

Are there any good references for best practices for storing postal addresses in an RDBMS? It seems there are lots of tradeoffs that can be made and lots of pros and cons to each to be evaluated -- surely this has been done time and time again? …
John
  • 14,944
  • 12
  • 57
  • 57
102
votes
11 answers

Drop all tables command

What is the command to drop all tables in SQLite? Similarly I'd like to drop all indexes.
alamodey
  • 14,320
  • 24
  • 86
  • 112
99
votes
9 answers

What are database constraints?

What is a clear definition of database constraint? Why are constraints important for a database? What are the types of constraints?
bala3569
  • 10,832
  • 28
  • 102
  • 146
89
votes
7 answers

Best representation of an ordered list in a database?

I know that this sort of goes against the principles of a relational database but let me describe the situation. I have a page where the user will place a number of items. ________________ | -Item1 | | -Item2 | | -Item3 | |…
Greg Guida
  • 7,302
  • 4
  • 30
  • 40
87
votes
8 answers

How add unique key to existing table (with non uniques rows)

I want to add complex unique key to existing table. Key contains from 4 fields (user_id, game_id, date, time). But table have non unique rows. I understand that I can remove all duplicate dates and after that add complex key. Maybe exist another…
yAnTar
  • 4,269
  • 9
  • 47
  • 73
82
votes
7 answers

Why NoSQL is better at "scaling out" than RDBMS?

I have read the following text in a technical blog discussing the advantages and disadvantages of NoSQL: "For years, in order to improve performance on database servers, database administrators have had to buy bigger servers as the database load…
xiaohan2012
  • 9,870
  • 23
  • 67
  • 101
79
votes
17 answers

Hidden Features of PostgreSQL

I'm surprised this hasn't been posted yet. Any interesting tricks that you know about in Postgres? Obscure config options and scaling/perf tricks are particularly welcome. I'm sure we can beat the 9 comments on the corresponding MySQL thread :)
ramanujan
  • 5,581
  • 5
  • 30
  • 31
79
votes
2 answers

What exactly is a wide column store?

Googling for a definition either returns results for a column oriented DB or gives very vague definitions. My understanding is that wide column stores consist of column families which consist of rows and columns. Each row within said family is…
Moo
  • 3,369
  • 4
  • 22
  • 41
79
votes
7 answers

Is there any way to get the column name along with the output while execute any query in Hive?

In Hive, when we do a query (like: select * from employee), we do not get any column names in the output (like name, age, salary that we would get in RDBMS SQL), we only get the values. Is there any way to get the column names to be displayed along…
Nithin
  • 9,661
  • 14
  • 44
  • 67
1
2 3
…
99 100