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

Model java class as joined result in JPA

Consider the following data. This is a fictional online store system. Surcharge store the surcharge configuration base on different goods category (food or clothing) and payment means (cash or credit card). Packaging store the available packaging…
Mr. Brickowski
  • 1,134
  • 1
  • 8
  • 20
0
votes
0 answers

Is there any way to count identifiers of Stored Procedures?

Is there any way to count identifiers of SQL Stored Procedures and/or functions? This identifiers can be: SELECT, UPDATE, DELETE, IF, While or other SQL Expression. An identifier is the minimum unit of separation of the SQL interpreter and from what…
João Costa
  • 33
  • 1
  • 6
0
votes
1 answer

How to enable index-sequential files in postgres

I am writing an application backed by Postgres DB. The application is like a logging system, the main table is like this create table if not exists logs ( user_id bigint not null, log bytea not null, timestamp…
GeauxEric
  • 2,814
  • 6
  • 26
  • 33
0
votes
2 answers

Postgres extracting data from a huge table based on non-indexed column

We have a table on production which has been there for quite some time and the volume of that table is huge(close to 3 TB), since most of the data in this table is stale and unused we are planning to get rid of historical data which does not have…
vaibhav
  • 3,929
  • 8
  • 45
  • 81
0
votes
0 answers

Consideration of fames in SQL windowing functions

In almost all RDMS products, we have windowing functions. Broadly, they are classified as: Ranking functions (e.g: rank(), dense_rank() etc...) Aggregate functions (e.g: sum(), avg() etc..) Analytic functions (e.g: first(), lag() etc..) In my…
user3103957
  • 636
  • 4
  • 16
0
votes
1 answer

transformation into BCNF with only a relation and no data

I have to transform this following relation into BCNF. But the exercise did not indicate what are the primary determinant. Nothing is underline. I know the different steps but I have some difficulties to write the functional dependencies because I…
Eileen
  • 21
  • 3
0
votes
2 answers

Using Docker with official Progress OpenEdge RDBMS images

I found out that Progress has provided official docker images for their RDBMS. I managed to pull the following image: docker pull store/progresssoftware/oedb:12.2.3_adv-ent I tried following the instructions to set it up, but they ask you to edit…
W0lfw00ds
  • 2,018
  • 14
  • 23
0
votes
1 answer

Customising the result of the query as per the business requirement via alias not working in Oracle Database?

Oracle database is case insensitive and thus if I put any alias also the column name is always in capital letters. For e.g. If I run the following query: Select ID as Id, AGE as Age, NAME as Name from Employee; The result set columns would be like…
user14251427
0
votes
4 answers

Can't decide database structure. Which one should i go for?

I'm developing small application for a company. What they want me to do is some kind of event website which they can add participants for each event. My question is should I have one table for all the participants for all events or should I create a…
Ozan Emre Orhan
  • 1
0
votes
1 answer

How to create a table similar to another table without copying the data at creation?

I have a table books, I want to create table Book101 and then copy the contents of table books into it.
user14842715
0
votes
1 answer

has_many, has_one association with composite foreign keys

I am trying to wrap my head around how I am going to be able to have a has_many (or has_one in my case) association with a compound foreign_key. For my example Assume this: Imagine I am managing relationships between sellers and buyers, there is an…
leifg
  • 8,668
  • 13
  • 53
  • 79
0
votes
1 answer

Consider nullable parameters in an sql, can be built up either with if conditions or using a conditional where clause. Which one is better to use

I have so many dynamic queries in my project and there may be 2 ways to build up a dynamic query. I have shown them below, Conditional where @Query("select c from Customer c where " + " (:name IS NULL OR c.name LIKE %:name%) "+ …
Ömer
  • 84
  • 8
0
votes
1 answer

How to share phpMyAdmin DBMS to another computer outside network (LAN)?

I am very new in this environment and currently having this difficulty to share my DBMS work to my teammates. Tried to find solutions but mostly it was a solution if it's from the same network. Is there any way (in details) how can I share it from…
codiecub15
  • 51
  • 1
  • 1
  • 6
0
votes
2 answers

How to alter a column's length (in character) in Oracle 10G?

I am using Oracle 10 G, I want to decrease a column size from 30 to 20 characters. Table name is member, column is member_name, it's a varchar2(30) data type. My question: is there any query to do it? If so, what is it?
user14842715
0
votes
1 answer

Migrating data from RDBMS to Arango DB: Bulk upload

Iam trying to move data from RDBMS to ArangoDB. I wanted to know if there are any tools for transforming the RDBMS data to collections and edges to do a bulk upload to ArangoDB. I could also see that ArangoDB bulk upload API allows only one type of…
pacman
  • 725
  • 1
  • 9
  • 28
1 2 3
…
99 100