Object-Relational Database Management Systems (ORDBMS) are similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language
Questions tagged [ordbms]
25 questions
18
votes
1 answer
What does PostgreSQL to be ORDBMS mean?
Query has not much helped.
As mentioned here, PostgreSQL is ORDBMS.
here, it explains PostgreSQL being RDBMS.
What does it mean that PostgreSQL is an ORDBMS? Is it about supporting user defined datatypes?
overexchange
- 15,768
- 30
- 152
- 347
13
votes
2 answers
Difference between RDBMS and ORDBMS
It happened to me when I was reading about PostgreSQL on its wiki page where it refers to itself as an ORDBMS. I always knew about Microsoft SQL Server which is an RDBM system. Can someone help me understand the main differences between Relational…
RBT
- 24,161
- 21
- 159
- 240
6
votes
2 answers
Nested table in mysql
I have 2 tables. USER table with all personal details and TWEETTABLE with all tweets from user's timeline retrieved through twitter api
User table
id|twitter_user_name|firstname|lastname|email
-----------------------------------------------
1…
Nithin Nampoothiry
- 189
- 3
- 12
4
votes
1 answer
What is the difference between an ORM and an ORDBMS?
They seem very similar to me. I don't understand the difference Maybe a programming example for ORDBMS?
johnny
- 19,272
- 52
- 157
- 259
2
votes
1 answer
How do i create a trigger that needs to check if the new value is on an array in the same table (oracle 11g)
I have a table area and doctor. The doctor has a varray of specialities and a reference of the area that works in. The trigger that i am trying to create checks if the name of the area that i will be referencing in the update is the same as the name…
tlalco
- 352
- 4
- 19
2
votes
1 answer
Referencing a row from another table (PostgreSQL)
I'm new to PostgreSQL and I'm struggling to understand how to use a reference to an 'instance' (or row) from a table as a value within a row of another table.
Here is my desired result:
class User{
int age;
Post[] posts;
}
class Post{
int…
Andy
- 221
- 3
- 12
1
vote
1 answer
How to fix "ORA-01401: inserted value too large for column" while inserting in multilevel nested table
Below is the Table/Object type Creation Query. Tables are created successfully
CREATE TYPE ft_obj AS OBJECT (
ftid NUMBER(5),
ftlocation VARCHAR(30),
country VARCHAR(10)
);
/
CREATE TABLE ft_table OF ft_obj (
ftid…
user1882624
- 303
- 2
- 4
- 16
1
vote
2 answers
How can I delete a member function created in oracle
How can I delete a member function created inside oracle type object without dropping the entire type?
Ashane.E
- 109
- 10
1
vote
1 answer
How execute a member procedure on a table of objects record?
I'm currently working on Oracle11g and I've come to grips with Table of objects.
Classic example:
create or replace TYPE T_person AS OBJECT
(
name varchar2(20),
surname varchar2(20),
MEMBER PROCEDURE Set_Sir
);
/
create or replace TYPE BODY…
Fantazzini
- 13
- 3
1
vote
1 answer
ora-22979: cannot INSERT object view REF or user-defined REF
I try to insert/update a Ref via Java JDBC into an oracle12c db.
The type is defined as:
CREATE OR REPLACE TYPE AngestellterTyp UNDER PersonTyp (
PersonalNr INTEGER,
Rang VARCHAR(200),
Einstellung DATE,
TelefonBuero …
Florian Kroschewski
- 21
- 4
1
vote
1 answer
where should data integrity be maintained?
The simplified scenario first:
Merchants have products
Merchants have categories
Products have subcategories
A merchant's products' categories must have the merchant's category as the parent category
This is modelled using the RDBMS approach. I'm…
madhukar93
- 507
- 5
- 23
0
votes
1 answer
Is there a kind of ORDBMS where I can create classes on the fly?
It is a bit hard to explain, what I am looking for:
Searching for a DB which stores objects (similar to e.g. https://www.objectdb.com/) but where classes are not defined by the Java code but in the DB itself - on the fly.
So that there it shall be…
Andreas
- 523
- 5
- 15
0
votes
0 answers
object tables relation ships
I am newbie in OODB. I have been trying to solve this task for several days. It just doesn't work out whether, someone can help me and write a small example for understanding?
Task:
Create 3 object tables with nested objects (object in object).
The…
pumpk1n
- 1
- 1
0
votes
0 answers
What is the compilation error in this code... I tried my best but I could not resolve the error
I want to add this member function to the type I created. I already altered the type.
I want to know what is the compilation error in this code and I want to know the solution for this?
This code is related to ORDB(Object Relational Database).
I…
user10791666
0
votes
1 answer
Map many to many relationship in object relational database (Oracle)
If you have a many to many relationship between book and category you can map it to object oriented model as shown below based on How to design many-to-many relationships in an object database?
Book {
Collection categories
}
Category…
Lakshin Karunaratne
- 446
- 1
- 6
- 19