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

Embedded databases for ASP.NET

I need an embedded database solution that can be used from within an ASP.NET application. Unfortunately, it seems that SQL Server compact edition does not support ASP.NET and my web host does not avail me SQL Server. MS Access is an option. But…
mihsathe
  • 8,904
  • 12
  • 38
  • 54
0
votes
1 answer

NoSQL Offline/Standalone - Query GraphDB File directly without exe application?

Every relationship database can be used without the need for installation of any software or tools, as most of the query read/write is all done to read a file that stores data in a specific format. Can the same thing be done with a graph database…
user3681384
  • 105
  • 9
0
votes
0 answers

SQLite 3 cannot read edits of database

I am writing a very simple Go app that uses sqlite 3 and during testing I noticed that when I insert a new row into the database with i.e. SQLPro, while the app is running, this app won't notice the new data. For testing purposes I tried running…
DomeWTF
  • 2,342
  • 4
  • 33
  • 46
0
votes
1 answer

Costs Analysis based on the structure file

I'm preparing for my RDBMS theorical exams, and I'm stuck in a concept. A hashed index has an occupancy of the 80% of a page, which means that the data file size will be 1.25. Why 1.25? Because 0.25 corresponds to 1/4, which is the 20% of the…
SHl MRJ
  • 63
  • 10
0
votes
1 answer

Can we access a record in SQL table using primary key in O(1) time?

I want to know that while finding a record using the primary key does RDBMS takes O(1) time or not?
Dishant Vashistha
  • 11
  • 2
0
votes
2 answers

RDBMS (SQL) storing time series with variable labels / extra column attributes?

I want to set up a RDBMS for structured time series data of limited size (about 6000 series, 50mb of data) at various frequencies (daily, monthly, quarterly, annual CY and annual FY), and I want to run SQL queries on the database (mostly join…
Sebastian
  • 1,067
  • 7
  • 12
0
votes
2 answers

Does it make sense to create a separate index against a column, that is also a part of the composite primary key?

I am using MySQL as my RDBMS. But I think it must be applicable to other relational DBs. I have a table Z, where I have 5 columns: a, b, c, d, e. Columns a, b, c comprise a composite primary key. Now, when it comes down to querying in the WHERE…
Ihor M.
  • 2,728
  • 3
  • 44
  • 70
0
votes
0 answers

Flatten a Table in SQL with dynamic column name

I have following table MyTable RequestId| Name|Phone| ContactEmail |RoleType| Address |TypeOfContact 1 | abc |123 |abc@gmail.com |null | NULL |Primary 1 | kbd |133 |kbd@gmail.com |A | Address1 |Local I…
Aathira
  • 655
  • 3
  • 14
  • 31
0
votes
1 answer

Is there a way to understand what algorithms does PostgreSQL use to implement relational operators without having to read the source code?

PostgreSQL makes use of intraoperation parallelism and that is of interest to me (for my undergad final year research project). I would like to know how operations like selection, projection, join, etc are parallelized, but when I tried to look at…
BovineScatologist
  • 145
  • 1
  • 7
0
votes
1 answer

Why is there no program-data independence in traditional file processing?

"In traditional file processing, the structure of data files is embedded in the application programs, so any changes to the structure of a file may require changing all programs that access that file. By contrast, DBMS access programs do not require…
Ayush Kumar
  • 13
  • 3
0
votes
1 answer

Most efficient multi level commenting system

I'm building a multi level commenting system and need a solution for quick reads and writes. I've looked into adjacency list and nested set and it seems to me that for my particular scenario neither is the right method to use, so I'm looking into…
DavidW
  • 5,069
  • 14
  • 46
  • 68
0
votes
1 answer

Import on-premise RDBMS data into AWS Athena

I am looking for ways to import RDBMS data into AWS Athena in a cost effective way using only Python as a tool. I am able to do the above using PySpark but now I only have to use Python. Can someone suggest some tutorials for this?
TeeKay
  • 1,025
  • 2
  • 22
  • 60
0
votes
1 answer

How to store unique list with properties in MySQL

I want to store data like the following, unique is on user_id and lids, in MySQL: recordid user_id lids length breadth ------------------------------------------------------------ 1 1 l1,l2 10 …
Sunil Kumar
  • 622
  • 1
  • 12
  • 33
0
votes
2 answers

Total amount of sales done for each product using SQL

Here is the structure of 1st Table called Product. PRODID PDESC PRICE CATEGORY DISCOUNT 101 BALL 10 SPORTS 5 102 SHIRT 20 APPAREL 10 Here is the structure of 2nd table called…
Rahul Kulkarni
  • 29
  • 1
  • 4
0
votes
1 answer

Display all employees where employees hired before 21-NOV-1989 (1989-11-21) in MySQL

My Database has a table named "employee" and "hire_date" column in it. I tried to fire following Query, but got empty set: mysql> SELECT * from employees -> WHERE hire_date < 1989-11-21; Empty set, 1 warning (0.00 sec) Though I have…
Mukul Chikhalkar
  • 90
  • 1
  • 9
1 2 3
…
99 100