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
16
votes
3 answers

Database for Python Twisted

There's an API for Twisted apps to talk to a database in a scalable way: twisted.enterprise.dbapi The confusing thing is, which database to pick? The database will have a Twisted app that is mostly making inserts and updates and relatively few…
Will
  • 73,905
  • 40
  • 169
  • 246
15
votes
5 answers

Storing conditional logic expressions/rules in a database

How can I store logical expressions using a RDBMS? I tag objects and would like to be able to build truth statements based on those tags. (These might be considered as virtual tags.) Tags new for_sale used offer Rule second_hand_goods = (!new or…
chillitom
  • 24,888
  • 17
  • 83
  • 118
15
votes
3 answers

How to implement ONE-TO-MANY in a database

I want to implement one-to-many concept in my application. This is the scenario: I have two tables (i). Person(ID, NAME, AGE, DEPT) (ii). Person Responsibilities(ID, RESP'S) One person may have more than one responsibility. How shall I implement a…
user405398
15
votes
1 answer

Differences between ROWTYPE, TYPE, and RECORD in postgresql?

What is the use of the following declarations, and where will we use these types of declarations? myrow tablename%ROWTYPE; myfield tablename.columnname%TYPE; arow RECORD;
mohangraj
  • 9,842
  • 19
  • 59
  • 94
15
votes
2 answers

SQLite long to wide formats?

I wonder if there is a canonical way to convert data from long to wide format in SQLite (is that operation usually in the domain of relational databases?). I tried to follow this example for MySQL but I guess SQLite does not have the same IF…
hatmatrix
  • 42,883
  • 45
  • 137
  • 231
15
votes
3 answers

MySQL: Has anyone used the TokuDB storage engine?

Has anyone used the TokuDB storage engine for MySQL? The product web site claims to have a 50x performance increase over other MySQL storage engines (e.g. Innodb, MyISAM, etc). Here are the performance claims…
Timmyboy
  • 191
  • 1
  • 6
15
votes
1 answer

When should you use JCR and when should you use JPA/RDBMS?

The Java JCR API defines a persistence mechanism which can be used to replace many of the traditional roles of a RDBMS. For example, JackRabbit - the JCR reference implementation - supports transactions, SQL queries, object-content mapping, etc. You…
Robert Campbell
  • 6,848
  • 12
  • 63
  • 93
14
votes
2 answers

hierarchical data in a database: recursive query vs. closure tables vs. graph database

I'm starting on a new project that has some hierarchical data and I'm looking at all the options for storing that in a database at the moment. I am using PostgreSQL, which does allow recursive querying. I also looked into design patterns for…
tospo
  • 646
  • 9
  • 17
14
votes
6 answers

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 a few things about the differences between SQL and NoSQL databases. I'm convinced about the potential advantages, but I'm a little worried about…
ascobol
  • 7,554
  • 7
  • 49
  • 70
14
votes
4 answers

RDBMS without SQL

Is there an RDBMS in existence that does not have SQL. I am not talking of NoSQL and all that XML and Javascript object type of data. I mean like the database that is not instructed via SQL, but plainly via some API. There should not be an SQL at…
Jazz
  • 639
  • 1
  • 11
  • 28
14
votes
6 answers

Which database systems support an ENUM data type, which don't?

Following up this question: "Database enums - pros and cons", I'd like to know which database systems support enumeration data types, and a bit of detail on how they do it (e.g. what is stored internally, what are the limits, query syntax…
Tomalak
  • 332,285
  • 67
  • 532
  • 628
14
votes
2 answers

I don't understand Collation? (Mysql, RDBMS, Character sets)

I Understand Character sets but I don't understand Collation. I know you get a default collation with every Character set in Mysql or any RDBMS but I still don't get it! Can someone please explain in layman terms? Thank you in advance ;-)
Imran
  • 11,350
  • 20
  • 68
  • 78
14
votes
3 answers

Difference between Relational Algebra and Relational calculus

What is the exact difference between relational algebra and relational calculus? At most references, it will be Relational algebra is procedural and calculus is non-procedural. What do these terms mean? We can solve all problems using relational…
mohangraj
  • 9,842
  • 19
  • 59
  • 94
14
votes
3 answers

Strategic issue: Mixing relational and non-relational db?

There has been a lot of talk about contra-revolutionary NoSQL databases like Cassandra, CouchDB, Hypertable, MongoDB, Project Voldemort, BigTable, and so many more. As far as I am concerned, the strongest pros are scalability, performance and…
Ta Sas
  • 9,573
  • 15
  • 51
  • 73
14
votes
6 answers

TRIGGERs that cause INSERTs to fail? Possible?

In cleaning up this answer I learnt a bit about TRIGGERs and stored procedures in MySQL, but was stunned that, while BEFORE INSERT and BEFORE UPDATE triggers could modify data, they seemingly couldn't cause the insert/update to fail (ie.…
Matthew Scharley
  • 127,823
  • 52
  • 194
  • 222
1 2 3
…
99 100