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

Difference between the multilevel indexing and secondary indexing in dbms

what is the exact difference between the multilevel indexing and secondary indexing in dbms as both appears same but classified different?
ralph0609
  • 21
  • 5
0
votes
0 answers

DB insert/select performance issue

[Problem Statement] I have trouble with inserting data to DB.(About 15,000,000 records) It takes 2-3 week(estimated).. it takes too long!!! After latency analysis, I found that select query was the root cause of problem but there's not idea to fix…
SangYoon Lee
  • 11
  • 1
  • 2
0
votes
1 answer

The maximum recursion 100 has been exhausted before statement completions

;WITH UserSequence AS ( SELECT LastEnrolledOn, Users, ROW_NUMBER() OVER(ORDER BY LastEnrolledOn) as 'Sequence' FROM (select sum(ct) users, LastEnrolledOn from (select count(*) as ct,LastEnrolledOn from (select …
rajesh
  • 1
  • 2
0
votes
0 answers

Should I use multiple databases in MySQL for my "hosting" platform?

My idea is to offer a platform where the clients can create a personal site with a custom CMS, and then they will be able to customize their site using plugins. My question is: should I create a DB for each client? I would choose this solution for…
Emilio
  • 1
0
votes
0 answers

Designing a Database for a PHP system which can handle time-table of a institute and can manage marking and checking previous attendance

I am trying to make a PHP-MySQL application for school system management. It should be able to handle the time table of entire week. Faculty, student can check their respective time tables. Faculty should be able to mark attendance of students of…
Mukul Mahajan
  • 1
0
votes
1 answer

anonymize rdbms datas, keeping key relations

Is there a "ready-to-use" method to anonymize datas, but keeping relations between keys ? For example, I have : Table #1 user code zip code ztxp15 45789 And : Table #2 user code order date ztxp15 2021-06-27 06:22pm I want…
Sebastien
  • 115
  • 1
  • 11
0
votes
1 answer

How should i organise table having ununique primary key

I have 2 datasets in csv file that has to be imported into database: Clients and Income. Table Clients has CUSTOMER_ID,....(other columns) Table Income has INCOME_ID,CUSTOMER_ID....(other columns) I dont know how should i organise tables and…
Jane
  • 1
  • 1
0
votes
2 answers

Trouble picking a DB for my use case. Any help/insight would be appreaciated?

I'm kind of new to designing my own full-stack projects, but I'm designing a little app for my own learning where I store a user's weightlifting data that they can enter and view in a web app. Eventually, I want to scale up to users being able to…
Ritvik Biswas
  • 100
  • 1
  • 9
0
votes
2 answers

SQL: Best way to reference entire table

I have a database with the data of many experiments. These experiments contain some generic attributes, but also some experiment-specific attributes. As a small example, the database can look like this: TABLE…
DwightFromTheOffice
  • 500
  • 4
  • 15
0
votes
1 answer

Looking for a non-cloud RDBMS to import partitioned tables (in CSV format) with their directory structure

Context: I have been working on Cloudera/Impala in order to use a big database and create more manageable "aggregate" tables which contain substantially less information. These more manageable tables are of the order of tens to hundreds of…
sg1234
  • 600
  • 4
  • 19
0
votes
0 answers

In Laravel database can I use a previously made array of conditions in where function?

In laravel tutorial it's said that we can pass an array of conditions in where function. My question is when I pass an array of conditions previously made by me it doesn't work. Here is the code in documentation: $users =…
Arifur Rahman Arif
  • 1
  • 1
0
votes
0 answers

Database maintenance without write access to the data

I am working on a rather unique requirement. I am not into databases so please pardon my ignorance. I have a MySql database hosted on AWS. I need to create multiple databases for multiple clients (1:1). Our solution needs to provide…
Hanzyusuf
  • 369
  • 5
  • 11
0
votes
0 answers

Normalising this database structure

We need help normalising the following database structure and we're a bit stumped. Here's the current structure: Templates id - primary name ... Languages id - primary name code ... Template Languages id - primary templateId -…
Craig
  • 337
  • 2
  • 10
0
votes
3 answers

PHP ORM with NOSQL and RDBMS support

Are there any PHP ORM projects which supports MySQL and NoSQL databases such as MongoDB? I am currently using RedBean to do MySQL ORM, however I woud like to introduce MongoDB to the applicatoin and perhaps even replace some of the MySQL with…
F21
  • 32,163
  • 26
  • 99
  • 170
0
votes
1 answer

How to get unique values from two different tables?

I've two tables: T1 & T2. My column of interest are 'Item' from T1 & 'Store' from T2. Here's my query & few options i've tried but could get desired result: Query1: (very time consuming - Its oracle DB) select distinct T1.Item,T2.Store…
Amin
  • 9
  • 1
  • 4
1 2 3
…
99 100