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

How to develop a web application compatible with multiple database management systems

How do you design and manage the development of a web application that should be compatible with multiple database management system such as Oracle and MS SQL Server? If you can't use ORM like NHibernate or EF, how do you maintain database schemas…
onof
  • 17,167
  • 7
  • 49
  • 85
10
votes
6 answers

How do you setup your connection pool?

What is the best way to setup your pool with respect to:- When do you create connections? When do you close connections, and would you close all of them? Do you test connections are still good. When and how? How do you figure out a good number for…
WW.
  • 23,793
  • 13
  • 94
  • 121
10
votes
3 answers

Can Sqoop export create a new table?

It is possible to export data from HDFS to RDBMS table using Sqoop. But it seems like we need to have existing table. Is there some parameter to tell Sqoop do the 'CREATE TABLE' thing and export data to this newly crated table? If yes, is it going…
Bohdan
  • 16,531
  • 16
  • 74
  • 68
10
votes
3 answers

Concurrent DB connection pool in Haskell

I am a Java programmer who learns Haskell. I work on a small web-app that uses Happstack and talks to a database via HDBC. I've written select and exec functions and I use them like this: module Main where import Control.Exception (throw) import…
oshyshko
  • 2,008
  • 2
  • 21
  • 31
9
votes
2 answers

Cloud Firestore and data modeling: From RDBMS to No-SQL

I am building an iOS app that is using Cloud Firestore (not Firebase realtime database) as a backend/database. Google is trying to push new projects towards Cloud Firestore, and to be honest, developers with new projects should opt-in for Firestore…
christostsang
  • 1,701
  • 3
  • 27
  • 46
9
votes
6 answers

Using 'where then Union' or Using 'Union then Where'

Please have these two types of query in your mind: --query1 Select someFields From someTables Where someWhereClues Union all Select someFields FROM some Tables Where someWhereClues --query2 Select * FROM ( Select someFields From…
shA.t
  • 16,580
  • 5
  • 54
  • 111
9
votes
3 answers

What makes Oracle more scalable?

Oracle seems to have a reputation for being more scalable than other RDBMSes. After working with it a bit, I can say that it's more complex than other RDBMSes, but I haven't really seen anything that makes it more scalable than other RDBMSes. But…
Jason Baker
  • 192,085
  • 135
  • 376
  • 510
9
votes
1 answer

Data structure used in a relational database system

What data structure is used in RDBMS for storing the actual data that we enter, firstname lastname and so on, I know that B and B+ trees are efficient for indexing and so on, but I haven't gotten a cpnvincing answer for this, please excuse my…
user2829027
  • 93
  • 1
  • 1
  • 3
9
votes
3 answers

Ready web query interface to SQL databases

Do you know any free tool which would constitute a web-based SQL database generic query interface, incl.: (mainly) allowing to type in an SQL query and display the result in some nice way the interface should allow for some basic security -…
Grzegorz Oledzki
  • 23,614
  • 16
  • 68
  • 106
9
votes
2 answers

Postgres update with an inner join across 2 tables?

I have 3 tables in my local Postgres database: [myschema].[animals] -------------------- animal_id animal_attrib_type_id (foreign key to [myschema].[animal_attrib_types]) animal_attrib_value_id (foreign key to…
IAmYourFaja
  • 55,468
  • 181
  • 466
  • 756
8
votes
4 answers

Dilemma: Cascade delete or Join delete

It's not a specific question, more a general wondering. When you have to make a delete on multiple tables in a 1:M relationship, is it better to make a FK constraint with a cascade delete or join the tables in the delete statement. I had an old…
Martin Taleski
  • 6,033
  • 10
  • 40
  • 78
8
votes
7 answers

How should I approach migrating data from a "bad" database design to a usable design?

The current project I inherited mainly revolves around one unnormalized table. There are some attempts at normalization but the necessary constraints weren't put in place. Example: In the Project table, there is a client name (among other values)…
llamaoo7
  • 4,051
  • 2
  • 22
  • 22
8
votes
2 answers

Datastructures used in DBMS

What are the datastructure used in DBMS like Oracle,MySQL & Sqlite for storing and retrieving records.
Prabu
  • 2,313
  • 2
  • 28
  • 31
8
votes
1 answer

How to Create a table in Sequelize to store in Postgressql with NodeJS

Am a newbie to Postgres and Sequelize i have successfully connected to DB trying to create a table in DB that is where am struck am getting an error the tablename doesn't exist sequelize.authenticate().then(() => { console.log("Success!"); var…
Kannan T
  • 1,639
  • 5
  • 18
  • 29
8
votes
3 answers

Populate tables with test data whilst maintaining relational integrity

I have a MySQL database with InnoDB tables, many of which have foreign keys. I was going to write a script to populate the tables with test data (10-20k rows or more) but I thought I ought to ask if there's something already out there that can…
bcmcfc
  • 25,966
  • 29
  • 109
  • 181
1 2 3
…
99 100