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

What kind of additional constraints can I use with PRIMARY KEY?

I want my primary key to allow certain duplicate entries, how do I write this? I want a song to be allowed to have multiple genres. CREATE TABLE songs ( songid INTEGER PRIMARY KEY, title TEXT ) CREATE TABLE genres ( genreid INTEGER…
QCA
  • 11
  • 1
0
votes
0 answers

Summarized table in postgreSQL for better performance

I am using postgreSQL as my database. I have a table MASTER(A, B, C, D, N1, N2, N3, N4, N5, N6) where the primary key is (A, B, C, D) and N1, N2, N3, N4, N5, N6 are the numeric columns. I have a query as below to get the summarized data of each A…
Giri
  • 451
  • 1
  • 4
  • 13
0
votes
1 answer

Do Most/Typical Databases Use Stdio?

I couldn't find any documentation or anything answering my question anywhere. Do rdbms like postgres or mysql use the c libraries to write data just as ordinary files? Or do they just try to get a hold of the raw disk memory space address locations…
Christopher Clark
  • 23
  • 3
0
votes
0 answers

Is there a method in Microsoft Access to populate a field based on another table?

I currently have a table called ClinicT that contains: ClinicID (primary key), ClinicSite, ClinicDiscipline and ClinicArea. I have other tables in my database that have the ClinicSite, ClinicDiscipline and ClinicArea as well. However, I would like…
QuestionsEverywhere...
  • 1
  • 1
0
votes
2 answers

Does clustered index have a separate index file?

Do clustered indexes have a separate index file or is it the table itself? I read from my textbook that clustered indexes change the physical ordering of the actual file. So does it need a separate file? Kindly provide a generic answer if possible,…
sumanth
  • 135
  • 1
  • 10
0
votes
1 answer

Calculate SQL db2 date time difference between below

I have dates column in format like below 2020-06-08 03:54 , 2020-06-08 04:10 I want to calculate time difference between this in SQL dB please Sample excel data Definition Time_cmp= R_date - p_date R_date | p_ date | time_cmp 2020-06-08…
Akshay
  • 33
  • 3
0
votes
2 answers

Is there any other way of solving the SQL question involving employee data?

A company record its employees movement In and Out of office in a table with 3 columns (Employee id, Action (In/Out), Created). First entry for each employee is “In”. Every “In” is succeeded by an “Out". No data gaps and, employee can work across…
Nihilistic Raccoon
  • 17
  • 1
  • 4
0
votes
2 answers

Configure Apache Ignite Cluster with multiple database as backend partitions

I am new to Apache Ignite. Here's what I am curious about: Can I setup an ignite cluster as the frontend proxy to distribute requests based on some data column like tenantID, to mysql instances where each mysql instance holds data for single…
PleaseLetMeGo
  • 125
  • 2
  • 7
0
votes
1 answer

Database suddenly stopped in middle of transaction

I am building a web application that has an oracle cloud database as a primary database. And it is a payment application so every millisecond counts and transaction happens all the time. It is the most obvious question and I didn't find an answer. I…
Will Mcavoy
  • 485
  • 5
  • 24
0
votes
3 answers

Why store "collection" type in RDBMS considered violation of 1NF?

Following this question Wikipedia says: http://en.wikipedia.org/wiki/First_normal_form#Repeating_groups_within_columns A query such as "Which pairs of customers share a telephone number?" is more difficult to formulate How could this be difficult…
est
  • 11,429
  • 14
  • 70
  • 118
0
votes
1 answer

MYSQL - compare between 1 table have n partition and n table have same struct

I am a student and I have a question when I research about mysql partition. Example I have a table "Label" with 10 partitions by hash(TaskId) resourceId (PK) TaskId (PK) ... And I have 10 table with name table is "label": + taskId: tables:…
huyna3
  • 25
  • 2
0
votes
2 answers

Is MySQL a database? or a database server? Why do we install xampp or wamp in order to access MySQL?

I heard that MySQL is a database server. If it is a database server, then what is the need of installing other servers like xampp or lampp? Do xampp or wamp or lampp do other jobs than being a Database server?
FRANCIS CASIMIR S
  • 39
  • 5
0
votes
1 answer

How to ensure many to many relationship has the same foreign key

How can I ensure that the shop_has_product table is from the same company? Is there a way to achieve this is RDBMS or do I need write the insert logic in the application layer. Thanks you for your time.
passByReference
  • 23
  • 4
0
votes
0 answers

dump and load pickled object to sql database

I want to store an xgboost model to an sql database and read it back: I pickled my model and wrote it into a varchar field in my db: obj = pickle.dumps(mymodel) #write obj to db in a varchar field When I read the string back from the database…
TomD
  • 1
  • 2
0
votes
2 answers

Help regarding What DBMS to use for interaction between android phone, server and database?

I am looking for some guideance in terms of what database to use server(using servlets) side of my android application. Further down the line i will setup a website that will need to access the information from with the database. At the moment from…
molleman
  • 2,934
  • 16
  • 61
  • 92
1 2 3
…
99
100