Questions tagged [object-oriented-database]
ODBMS: a database management system that represents information as objects, like in object-oriented programming
object-oriented-database
249
questions
1
vote
0
answers
18
views
How do I get the data for both my hibernate object and its referenced objects if the referenced table has many entries?
I'm not as experienced with tables, and hibernate best practices. If I have two tables
Books and Authors, but there's millions of entries for both Books and Authors, if I want to read/retrieve all ...
0
votes
1
answer
33
views
How to reference the primary key at the derived part of the same table?
Let's consider the following two, simplified tables:
CREATE TABLE payments
(
id bigserial NOT NULL PRIMARY KEY,
method int,
method_name name,
total numeric,
payment_date timestamp ...
1
vote
0
answers
77
views
How to reflect inheritance in Realm React Native JS?
I have the following situation:
There are a Divisions, each consist of List of elements. Those elements can be LineChart, DataTable and etc. I want to find a design solution, where Division can ...
0
votes
0
answers
191
views
Complete the code segment to insert the following data using prepared statement in the existing table ‘PLAYERS’
The given question ask me to complete the code to insert two rows in the given table as shown in the image. Some part of code is already given in question which I can't edit and some part of code is ...
0
votes
1
answer
68
views
Type created with compilation errors
Code:
CREATE OR REPLACE TYPE Address AS OBJECT (
city VARCHAR2(15),
state VARCHAR2(15),
pin NUMBER(6));
CREATE OR REPLACE TYPE Student AS OBJECT (
id NUMBER(3),
fName VARCHAR2(10),
lName VARCHAR2(10),...
0
votes
1
answer
152
views
ORA-02330: datatype specification not allowed
I tried creating a an object table after successfully creating an object type but i got the error
'datatype specification not allowed'.
Please what am i doing wrong. I am lost at this point.
CREATE ...
0
votes
1
answer
35
views
I have created the below table stafftable but when I'm trying to insert it's showing an error
CREATE TYPE accounttype AS OBJECT( no varchar2(10), name varchar2(10), balance number(10), dob date, member function age return number );
CREATE TYPE BODY accounttype AS
MEMBER FUNCTION age RETURN ...
-1
votes
1
answer
127
views
How to use other table object in another table
This is my first question.
So Im trying to use act_no varchar2(10), act_name varchar2(10) of type accounttype in account_branchtype.
So I entered the command = create or replace type ...
0
votes
1
answer
439
views
Get data from nested tables
I'm starting with object-oriented databases and I have a lot of questions about it :-(
Having the following structure:
CREATE OR REPLACE TYPE typeAuthor AS OBJECT(
aId INTEGER,
aName VARCHAR(...
0
votes
0
answers
577
views
Clickhouse Extremely Slow
I'm attempting to benchmark clickhouse against postgres for API use.
The dataset is ~40M records
SELECT
name,
web_url,
image_url,
visitor_id,
web_id
FROM analytics WHERE event_id =...
0
votes
0
answers
35
views
What can I put in my question true/false question maker so that it can be user friendly?
I am not quite done with my code yet, but I need help with my true/false question maker so that it can set user inputted questions as either true or false. Then when the program is executed with def ...
1
vote
1
answer
973
views
How do I create a Data Access Layer objects from database first approach?
I have built a SQL database with my CustomerDetails, ProductDetails, OrderDetails from scratch and also stored procedures to create new Customers, new Products and Orders.
So now I want to build a ...
1
vote
0
answers
104
views
Graphql + MongoDB : updating a deep nested object [Partial Update the object]
I have a huge database with 1000s of records. There are different types of "Groups" and each child object(group assignments) has different levels of nesting, (refer to the code below)
...
0
votes
1
answer
163
views
BlueJ Object Oriented Programming
public class DigitalClock
{
private int m;
private int h;
private int s;
//Fill in the necessary fields below
/**
* Constructor for objects of class DigitalClock
* Replace the constructor.
* ...
0
votes
1
answer
231
views
add values to nested table from another table (oracle)
I am trying to insert values to a nested table with an object of another table. This is what I'm trying (Sorry, I'm new working with dbs):
INSERT INTO Ocurrences (..., oSpace) VALUES
(other inserts,
...