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

does sqllite work well in pos desktop application

I'm currently working on a desktop POS application using flutter and the application does not necessarily need an internet connection or networking at all it works locally I have choosen sqlite (sqflite for flutter) as a local databse for the…
Karrar
  • 1,273
  • 3
  • 14
  • 30
0
votes
1 answer

How to deal with a directory that has a space in it being passed to ProcessBuilder and then to Exp.exe?

I am working on an issue where spaces in a directory cause a program that runs exp.exe to crash. The user first selects a .dmp file from any directory they want, which is then used to build an argument list. This argument list contains the command…
binarycoffee356
  • 49
  • 1
  • 8
0
votes
0 answers

RDS MySQL DNS hostname incorrect

I am trying to connect to my RDS MySQL instance using MySql client on a ubuntu terminal. When I type the following command and provide it the database password, I notice that it fails and it seems like it is trying to connect to a different hostname…
Darth.Vader
  • 5,079
  • 7
  • 50
  • 90
0
votes
1 answer

Reading data from different upstream systems in Spark

How to handle data ingestion in spark if data is received from multiple sources systems like RDBMS or sometimes from CSV files or any other file format or upstream systems. If file format is known then it can be specified while reading as…
SparkScala1
  • 1
  • 1
0
votes
2 answers

MySQL query to find hour of the day when the number of housing society visits is highest

Housing Society Visit Data Id Contact Entry_time Exit_time Duration of Stay 1 8080808080 26/07/2021 08:00:05 26/07/2021 08:23:06 181 2 9692596925 26/07/2021 08:12:49 26/07/2021 08:14:44 115 3 7099270992 26/07/2021 11:02:49 26/07/2021…
GeekyCoder
  • 1
  • 3
0
votes
0 answers

dropping table on mariadb crashes

I am using MariaDB (v10.4.11) and executing sql's via HeidiSQL (v11.3.0.6295). I have a few tables set up, and I can edit some of them just fine, using either sqls or UI provided by HeidiSQL. But, two of tables are not editable nor deletable. I…
beginnercoder
  • 81
  • 9
0
votes
3 answers

Enhance Python performance pandas dataframe

I have two pandas dataframes looking like this ID email name 1 "firstname.lastname@provider.com" "firstname lastname" ... ... ... 5150 "firstname.lastname@provider.com" "firstname lastname" with roughly 5150 rows. The data is not…
Marcus Willems
  • 69
  • 5
0
votes
0 answers

Postgres not responding after reboot - needs /usr/lib/postgresql/12/bin/pg_ctl restart -D /var/lib/postgresql/12/main

I'm having problems with PostgreSQL on Ubuntu 20.04. After server is rebooted, the database doesn't work and I need to switch the user to postgres and call /usr/lib/postgresql/12/bin/pg_ctl restart -D /var/lib/postgresql/12/main to restart…
Milano
  • 18,048
  • 37
  • 153
  • 353
0
votes
1 answer

How to run multiple simple select statements independently of each other simultaneously in SQL Server?

I have a SQL Server installed on ubuntu with only one table (accessed via sqlcmd) has nearly 2 trillion rows. It currently has a clustered index on column index A (which is not useful for me). I would like to do a select statement on the data select…
Hold My Stack
  • 45
  • 1
  • 6
0
votes
1 answer

'Column not allowed' error when adding data from cursor to table in pl/sql

I'm working on some practice problems to help me learn pl/sql. I'm required to use a cursor to add data from one table to another. My code is below. I've used dbms_output.put_line to make sure there is data in the cursor and the data in the cursor…
Crystal
  • 5
  • 2
0
votes
1 answer

Does it makes sense to create IDENTITY PK (INT) if the records uploaded have already a specific ID assigned?

Rationale I created an ETL in Python that downloads some data from Salesforce and loads them in SQL Server. Those records are related to Salesforce Objects like Case, EmailMessage, RecordType, User, etc... Those records also have a specific ID…
tidus4400
  • 56
  • 1
  • 6
0
votes
1 answer

Executing date field with null in plsql

Hello I have a procedure and questions about it. This procedure is used for extracting data then inserting them into one table. What I want to do is that when executing the procedure if pid_billdate is null, it should use previous months' last dasy…
vitaminJava
  • 139
  • 2
  • 11
0
votes
1 answer

Taking Previous Months' Date Automatically in PLSQL

Hello I have a procedure and questions about it. This procedure is used for extracting data then inserting them into one table. When I test my code, I have to enter some parameters for executing procedure. `--this is how I execute the…
vitaminJava
  • 139
  • 2
  • 11
0
votes
1 answer

Pivot in Oracle based on multiple columns

I have sample data like this in main table, value column has varchar as datatype. |primary_id |identifier_one |identifier_two |value | |-------------|-----------------|-----------------|-----------| |10001 |3000 |23 …
Chetan Kondawle
  • 179
  • 12
0
votes
0 answers

How to change time zone setting inside create view code

Do you know if there is a way to write "set time zone interval '00:00' hour to minute" inside create view code? I`ve been finding ways on how to do it because I cannot change the default time zone setting of a user or ask him to change the current…
Jojo10478
  • 29
  • 6
1 2 3
…
99 100