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
12
votes
5 answers

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 haven't really worked with Oracle. I'm a little bit familiar with Oracle, but far from a genius on the subject. Unfortunately, that is…
Jason Baker
  • 192,085
  • 135
  • 376
  • 510
11
votes
5 answers

Has anyone published a detailed comparison between different in-memory RDBMSs?

There are quite a few independent and not-so-independent studies comparing traditional RDBMSs but I haven't managed to find any good material on in-memory databases. I am primarily interested in ones specialized for OLTP. So far, I managed to find…
Andrew not the Saint
  • 2,496
  • 2
  • 17
  • 22
11
votes
7 answers

Separating user table from people table in a relational database

I've done many web apps where the first thing you do is make a user table with usernames, passwords, names, e-mails and all of the other usual flotsam. My current project presents a situation where non-users records need to function similarly to…
Barrett Conrad
  • 1,878
  • 14
  • 14
11
votes
3 answers

Advice on mixing MongoDB w/ MySQL for a web application

I have a web application that uses a relational database (MySQL). We're adding a new feature that will allow certain users to dynamically construct 'forms' from a pool of optional form elements and distribute these forms for completion/submission to…
Casey Flynn
  • 13,654
  • 23
  • 103
  • 194
11
votes
8 answers

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, adLockReadOnly) There are other applications in the network which do make changes to the table. For some reason I'm getting…
Daniel Rikowski
  • 71,375
  • 57
  • 251
  • 329
11
votes
3 answers

is MongoDB and Ldap the same concept?

As Mysql, sql server, postgre sql etc are basically different implementation of the same concept (rdbms), I am wondering does the same relationship exists between LDAP and MongoDB/CouchDB etc, or is there something more into LDAP?
Itay Moav -Malimovka
  • 52,579
  • 61
  • 190
  • 278
11
votes
4 answers

Are RDBMS that bad as described in Hadoop: The definitive guide?

I'm reading Hadoop: The definitive guide by Tom White. In chapter 13.6 "HBase vs RDMS" he said that if you have a lot of data, even simple queries like getting 10 recent items are extreamly expensive and they had to rewrite them using python and…
Piotr Czapla
  • 25,734
  • 24
  • 99
  • 122
11
votes
2 answers

how to design Hbase schema?

suppose that I have this RDBM table (Entity-attribute-value_model): col1: entityID col2: attributeName col3: value and I want to use HBase due to scaling issues. I know that the only way to access Hbase table is using a primary key (cursor). you…
Yonatan Maman
  • 2,428
  • 1
  • 24
  • 34
11
votes
4 answers

What is a good alternative to SQL Server for ASP.NET applications?

I've been looking into a lot of database's recently, and am not sure if it's because I'm bored or what, but I want to create a few web applications using database's other than MS SQL Server. Any suggestions that tie into ASP.NET nicely?
Landmine
  • 1,759
  • 6
  • 39
  • 60
11
votes
3 answers

Detecting SQL Server Utilization with a query

My current project will send queries to an sql server constantly and It may use 100% of the memory or CPU. How can I check if the server is nearing full utilization in a stored procedure so that I can decide whether to execute the queries or not…
Uğur Gümüşhan
  • 2,455
  • 4
  • 34
  • 62
10
votes
7 answers

What are the pros and cons of object databases?

There is a lot of information out there on object-relational mappers and how to best avoid impedance mismatch, all of which seem to be moot points if one were to use an object database. My question is why isn't this used more frequently? Is it…
Kevin Pang
  • 41,172
  • 38
  • 121
  • 173
10
votes
2 answers

Should VARCHAR columns be put at the end of table definitions in MySQL?

I've heard (from a colleague, who heard it from another developer) that VARCHAR columns should always be put at the end of a table definition in MySQL, because they are variable in length and could therefore slow down queries. The research I've…
ProcessEight
  • 399
  • 1
  • 2
  • 9
10
votes
6 answers

SQL: Primary key column. Artificial "Id" column vs "Natural" columns

Possible Duplicate: Relational database design question - Surrogate-key or Natural-key? When I create relational table there is a temptation to choose primary key column the column which values are unique. But for optimization and uniformity…
Andrew Florko
  • 7,672
  • 10
  • 60
  • 107
10
votes
1 answer

How does PostgreSQL's scaling compare to MongoDB?

I know a fair about about how amazingly scalable MongoDB is, particularly with its auto-sharding, and the ability to hot-add servers to a cluster. However, I haven't found much data about PostgreSQL's scalability. I know it has tablespaces, much…
IamIC
  • 17,747
  • 20
  • 91
  • 154
10
votes
1 answer

Join deletion with same syntax in mysql and h2

I have a production database in mysql and do some Junit tests in H2. I am struggling to find a syntax that would both work in tests and production to delete records in 2 tables. SQL queries are sent to the database using…
Yves Nicolas
  • 6,901
  • 7
  • 25
  • 40
1 2 3
…
99 100