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
0 answers

Error Code: 38 DB::Exception: Cannot parse date: value is too short: Cannot parse Date from String:while executing Insert into clickhouse db

I am creating a table in ClickHouse DB using this command CREATE TABLE SAMPLE (id Int,sample_date Date ) Engine = MergeTree Primary Key id Then I am storing the data into the table created above using this command INSERT INTO SAMPLE…
Vaibhav Yadav
  • 3
  • 2
0
votes
0 answers

Grant select, update, delete and insert permission to particular tables only in single query

I have 50/60 tables in database and i want to grant select, update, delete, insert permission to particular tables only like granting access to 20 tables at a time. How to do it? I want to grant those 4 permission to my 20 tables at a time in a…
Aman Mahaseth
  • 1
  • 1
0
votes
0 answers

Finding the canonical cover?

While finding minimal cover what to do if closure of left two attributes become same as the combined attribute? I came to know that there should not be any extraneous left-hand side attribute. How to remove redundant FD if FD’s are given…
drika
  • 17
  • 4
0
votes
1 answer

MySQL two (almost) identical table merge the values and default unique values

I have two almost identical MySQL tables besides a date column, and I would like to merge them with a select query to create a final table displaying both dates. If there is a unique acc_id in one table -> i want to default the amount in the other…
henry434
  • 97
  • 1
  • 9
0
votes
1 answer

ERROR: 'Incorrect syntax near the keyword 'ORDER'.'

I'm getting an error from my SQL query: SELECT TOP 20 * FROM ( SELECT DISTINCT p.ItemGroupName, p.Varenummer, s.EAN, s.inventoryQuantity FROM ShopInventory s, ProductData p WHERE s.EAN = p.EAN ) ORDER BY…
Andreas Ravnholt
  • 49
  • 7
0
votes
0 answers

Should I use a NoSQL database for a transactional app?

So I am building a points system app for my high school (50% because I thought it was a great idea 50% because I want to educate myself about databases). Essentially, my cafeteria uses a coupon system (physical paper) to provide a currency to buy…
DarthKitten
  • 3
  • 3
0
votes
2 answers

Linking database id's and files

Say I'm using MySQL and I have a column id which is my primary key in some table. In PHP I generate a random string/integer and store that as the id in my database. I then reference that id as the name for my file everywhere in my code (as I know it…
Obto
  • 1,377
  • 1
  • 20
  • 33
0
votes
0 answers

How can I get a list of other entities from spring data jpa?

I am looking for a way to solve the pagination and N+1 problems. (I'm using RDBMS.) The requirements are as follows: pagination process is required. display the title of the group and the names of all members in the group by group in the group…
0xe82de
  • 3
  • 2
0
votes
1 answer

Delete data from postgres/mysql on regular interval

I have a spring boot app where I am using mysql or postgres database (based on client requirement). In database I have a table in which I have to store data for 3 months. The data gets populated in this table continuously through a kafka stream. So…
devesh joshi
  • 105
  • 1
  • 8
0
votes
1 answer

How to obtain source tables from a merged table (Cypher/SQL/Pandas)?

Suppose I have the following table-- PersonID | cityID_which_personID_likes | city_longitutde | city_latitude | city_country And I would like to obtain the following two tables-- A) PersonID | cityID_which_personID_likes B) cityID | city_longitutde…
learner
  • 11
  • 2
0
votes
1 answer

Acheiving horizontal scaling through federation?

Does federation lead to horizontal scaling? We know that relational databases usually are scaled vertically as horizontal scaling is not feasible and can disrupt the entire databases. One of the main reasons why it is not possible as we tend to have…
Rosy Roy
  • 3
  • 2
0
votes
1 answer

Does Linq and projects like i4o make object oriented DBs a viable alternateive to relational DBs?

Given Linq and technologies like i4o is there any real reason why an object oriented database management system won't be a viable alternative to a relational database management system for new projects starting in the next 3 to 5 years?
Jonathan Parker
  • 6,705
  • 3
  • 43
  • 54
0
votes
1 answer

How to connect my website with DB2 on Cloud?

I have a site and there is register system that introduce data into RDBMS via php. I had PostgreSql on localhost and now I wanna connect my website with "DB2 on Cloud" from cloud.ibm.com How can I do it and what I must use? I used to connect with…
Fors1t
  • 73
  • 1
  • 7
0
votes
0 answers

Use greater than operator in like operator Hive

I want to use numerical greater than operator in like clause in hive sql. select col1,col2 from table_1 where NOT (col_3 RLIKE 'p=2') instead of 'p=2' i want to eliminate all the values where p>2 How can i achieve that? Any leads would be…
RohitM
  • 127
  • 1
  • 8
0
votes
1 answer

Postgres | function to sort a custom type array

I have (after group by clause) the next table: country | tuple -------------------------------- England | {"(5,666)","(3,333)"} USA | {"(3,222)","(2,777)"} India | {"(2,444)","(4,555)"} tuple is defined with: CREATE TYPE tuple AS (id…
Shay Zambrovski
  • 401
  • 5
  • 21
1 2 3
…
99 100