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
0
votes
1 answer

sequelize to create better database structure

i am trying to think of a database for a project similar to netflix. where you can login on multiple devices and for each device you have a token. the problem is that i cannot think of a structure of a relational database for that. i created it on…
nishi
  • 512
  • 1
  • 4
  • 19
0
votes
0 answers

I need to join the two tables in the following way.. using mysql

Table 1 Country Export China 90 India 80 Korea 40 Table 2 Country Import China 40 India 30 Japan 50 Result Country Export Import China 90 40 India 80 30 Korea 40 0 Japan 0 50
Arjunkumar
  • 1
  • 1
0
votes
1 answer

MS Access Mapping Multiple Fields From One Table to Multiple Fields In Another Table

In my Access database I have a parent table called Unit that has two fields called unitNumber and floor. In a child table called Lease I used the Lookup Wizard to create a foreign key called unitIDFK linked back to the Unit table and included the…
myswede
  • 1
  • 1
0
votes
0 answers

Error Code: 2068. LOAD DATA LOCAL INFILE file request rejected due to restrictions on access. 0.000 sec

This is my table named 'pet'. SELECT * FROM pet; This is my table output When i try to load data into table 'pet' LOAD DATA LOCAL INFILE 'C:/Users/HP/Desktop/pet.txt' INTO TABLE pet FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; It throws the…
EC Chaitanya
  • 179
  • 1
  • 6
0
votes
2 answers

How to do something like "group by" to function on one field but include all fields in the query

Suppose I have the following SQL server table: I would like the following result, wherein there is only one record per ID and it is the one with the lowest value for field A, but Fields B and C are also included, like so: How would I accomplish…
Natan Andrews
  • 25
  • 5
0
votes
2 answers

How does Index Merge intersection provide optimization in mysql/rdbms?

I am trying to understand indexing in RDBMS, and I am having hard time understanding Index Merge Intersection optimization while executing SQL query. Let's take this query as example SELECT * FROM innodb_table WHERE primary_key < 10 AND key_col1 =…
Max
  • 9,100
  • 25
  • 72
  • 109
0
votes
1 answer

how to add select statement in IN clause in pivot

iam using pivot table in SQL query.. i need to make some columns as rowss, but i need to use select statement in IN clause where we givt option like this PIVOT( sum(target) FOR collectionName IN ( Select Ds.CollectionName as…
deepti
  • 729
  • 4
  • 17
  • 38
0
votes
1 answer

Query for relationships between rows

I need to find a relation between multiple person in single table, for example I have the below table: Guests Table so I need by sql script to say Guest 123 and 456 they checked in together to the same hotel in the same time 80% and so on... Kindly…
Omar M.alsulaiman
  • 5
  • 2
0
votes
2 answers

ORA-08103: object no longer exists in .net

I have a global temporary table (on commit delete rows) called "GLOBAL_T" and a stored procedure which takes a SYS_REFCURSOR as an OUTPUT parameter. So you can think a stored procedure like this: PROCEDURE test (POT_CURSOR OUT…
Tayfun
  • 63
  • 8
0
votes
2 answers

select combination of two columns sql, h2

Hello i have this table: In this table i want to check, if the combination of the columns: 'carrier' and 'flight' always give the same origin. How can i do that? I tried this one: select distinct(a.name) from carriers c, flights f, airports a where…
letstrythisone44
  • 77
  • 6
0
votes
0 answers

Is it in 2nd Normal Form?

I have R(A, B, C, D, E, F) with following functional dependencies: {AB}->{D} {D}->{C} {AC}->{E} {E}->{B} {BC}->{F} The relation has 4 candidate keys AB, AC, AD and AE. According to Wikipedia: A relation is in the second normal form if it fulfils…
SRIJAN KUMAR JAISWAL
  • 1
  • 1
0
votes
2 answers

Oracle: Update from within procedure not working

In my Oracle PL/SQL procedure I am trying to update a row like this: UPDATE personal p SET p.surname = surname, p.name = name, p."alter" = alter, p.sex = sex, p.jobcode = jobcode, p.year_wage = month_wage * 12 WHERE p.personalnr =…
octavio
  • 456
  • 4
  • 14
0
votes
0 answers

Teradata Table creation throwing an error: Syntax error: expected something between the 'TABLE' keyword and the 'PUBLIC' keyword

I am connected to Teradata via the dbeaver. I successfully got connected to it after downloading the libraries from the https://downloads.teradata.com/. I am completely new to teradata. I copied one command from the tutorials point and tried to ran…
Saugat Dahal
  • 39
  • 1
  • 10
0
votes
0 answers

What is the closest alternative to SQLite database in terms of supported functions and datatypes?

I have a system where we generate 'physical sql' targeting the different database for a 'logical sql'. We have a bunch of supported DBs where the physical sql is supported (Oracle, MySql, Postgres etc). I am adding SQLite as a new DB to be supported…
Shash
  • 19
  • 2
0
votes
1 answer

Issues with Data Integrity with RDBMS

Anyone know about Cascade events in a relational data base system? How it works, how it helps and if there are any disadvantages. Thanks.
Michael McLean
  • 1
1 2 3
…
99
100