243 questions
1
vote
0
answers
53
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 ...
- 11
0
votes
1
answer
47
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,175
1
vote
0
answers
99
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 ...
- 11
0
votes
0
answers
193
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 ...
- 47
0
votes
1
answer
82
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
195
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 ...
- 1
0
votes
1
answer
42
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
140
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 ...
- 3
0
votes
1
answer
766
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(...
- 1
0
votes
0
answers
791
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
44
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
1k
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,678
1
vote
0
answers
120
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)
...
- 1,315
0
votes
1
answer
169
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.
* ...
- 5
0
votes
1
answer
262
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,
...
- 53
0
votes
2
answers
736
views
Change attribute of another object B within object A in Python
Suppose I have two classes of objects, A and B. Both are linked together in a database. We have an Event and a series of Actions associated with each event, and some attributes of each.
class Event(...
- 155
0
votes
1
answer
417
views
Are the relations preserved when transferring data from a relational DB to S3?
There are options for transferring a DB snapshot from a relational database to S3 in AWS.
But S3 is an object store, so it only stores files (e.g. parquet).
Are the relationships (like keys) between ...
- 13.4k
1
vote
1
answer
805
views
how to add prefix in roomDatabase?
I have a problem in my roomDatabase.
I searched on google and found some solutions but I can't solve my problem.
Can anyone help me?
Note : I want to use Object Oriented in my project.
Error :
...
- 424
1
vote
1
answer
82
views
How do I nest an existing key-value pair inside another object in Mongodb?
I have a collection with multiple documents inside Mongodb. The document in this collection looks like -
{
"name": "xyz",
"address": "abc",
"...
- 724
-2
votes
1
answer
474
views
When to create a subtype or simply use optional attributes
I've been practicing with Oracle SQL Developer for some time using school assignments and encountered some kind of dilemma while doing the Entity Relationship Diagram for one of those, here's my issue:...
- 74
-1
votes
1
answer
125
views
Creating procedure with dynamic SQL
Here are the instructions:
A company wants to allow customers to do product search by selecting a product name or
description, and then typing a search term. Using native dynamic SQL, create a
...
- 13
0
votes
0
answers
391
views
Database Design for Addresses with Various Types
I'm designing my first database, and am considering 1 of 2 ways to create the "Address" table:
Create "Address" table with following columns:
PartyID, Address Type, Street, Apt/...
- 1
0
votes
1
answer
724
views
How to create a nested table of refs in Oracle SQL?
Consider the following problem:
There's the Transaction type and the Service type. Each transaction covers one or more services at a time. However, two different transactions may cover same services.
...
1
vote
3
answers
110
views
Dart Functions Not Responding As I Would Have Liked It To
I'm very new to flutter and dart, I'm having trouble with functions, I've already spent too much time here. Any help is appreciated. Thank You
`void main(){
Car myCar = Car(drive:slowDrive);
...
- 67
-1
votes
1
answer
242
views
What is the current viability of an OODBMS in game development?
So, I've been researching for quite some time now, but it seems that all the results I'm getting are fairly outdated. I'd like to know what the current state of object-oriented database management ...
- 39
2
votes
3
answers
4k
views
Python: How to add information to a dictionary using a class, then print key and values of added dictionary entry
I'm working on the following assignment and am new to using classes to create/store objects:
Employee Management System: This exercise assumes you have created the Employee class for Programming ...
- 23
0
votes
1
answer
247
views
Can I change an attribute name from a table derived from a type?
Folowing the Object-Relational Database model, I wanted to create the tables or_doctor and or_recepcionist derived from the type t_employee.
Here, follows the type structure:
DROP TYPE t_employee ...
-1
votes
1
answer
33
views
Can I create a SQL database schema where instead of having primary keys, I create new tables for each scenario ? What are its disadvantages? [closed]
For example - If I need 3 tables for my app - A,B and C.
When creating a new scenario/record instead of inserting a new row, I create a set of 3 new tables - A2,B2,C2
Next time when I create a new ...
- 7
0
votes
2
answers
914
views
Preventing duplicate value in local storage
I'm creating a library archive site containing a collection of my favorite reads. I have a click event listener on the books, adding them to my local storage key 'books' when doing so. I want it so ...
0
votes
3
answers
73
views
What am I doing wrong in this INSERT ROW statement (java)
I am trying to use a statement that will insert a row in a table once the user types a name and ID number into a text field. However I keep getting an error when trying to run the program and I ...
-1
votes
1
answer
322
views
Which design pattern can be most suited for building a recursive tree?
I want to choose a design pattern for the below case:
Ancestor Tree: An ancestor tree is a special type of family trees that keeps track of all
known ancestors of a person. The following is the data ...
- 33
0
votes
1
answer
151
views
need to know what is exactly a resizable dynamic data structure [closed]
I'm a software engineer student, and we are studying C. Actually we are deal with data structure, so in some of my search about hash tables especially linear probing I read the term of "resizable ...
- 322
0
votes
2
answers
162
views
Undestanding CRUD with Composition
I pretty want to understand how to organize my code. Let's say i have this class called "Brand" which has a "Product" object:
public class Brand {
public int ID { get; set; }
public int name { ...
0
votes
2
answers
273
views
How to store file data lines and pass it method to calculate into letters and print letter grades in another file? [closed]
class.txt
Reena Sam, 100, 90, 80, 100,
Donna D. Bartolome, 90, 90, 100, 100,
Chris Tui, 100, 90, 100, 70,
I'm new to java and I'm trying to figure out
how to store file data lines to calculate ...
- 23
0
votes
1
answer
314
views
Storing an object into a SQL database in Oracle
Simply trying to find the correct syntax/method to enter create SQL objects and store them inside an oracle database. (school project so it's got to be possible)
CREATE OR REPLACE TYPE Person AS ...
- 93
0
votes
0
answers
420
views
How to define user-defined types (Object-Oriented Database) in SQL Server 2017?
In our Database course in university, our reference book was Fundamentals of Database Systems by Elmasri. In Chapter 12 of this book, we were introduced to Object-Oriented database systems, in which ...
1
vote
1
answer
40
views
How to use classes to call for an object using a variable?
I am trying to work on a "keep the change" problem by using object oriented programming on Python. I made a class:
class BankAccount:
def __init__(self):
self.savings = 100
def ...
- 11
1
vote
2
answers
112
views
Printing an attribute of a instance in a list, only if it exist
I want to print a class attribute, part of a list of instances, only if this attribute exist
i created a class name Guitarist, that includes a name attribute, and otherItems (which usually is a ...
- 53
35
votes
3
answers
45k
views
JSON to Javascript Class
I have a http request that gets this Json object from a nosql database:
let jsonBody = {
birthday : 1997,
firstname: 'foo',
lastname:'bar'
}
Then I want to load this information into the ...
- 21.5k
0
votes
1
answer
658
views
How can I configure a widget that is in a different class?
I need the buttons within LeftFrame to change its appearance when clicked. In the class AccOne, I tried to do left_frame.acc1.config(releif='SUNKEN'), but I get NameError: name 'left_frame' not ...
- 115
0
votes
1
answer
826
views
MongoDB join 2 tables and select field is null
In MongoDB
I have a job sign up application. I have two collections- Jobs and HelperJobs.
The first collection contains all the jobs and the second maps Helpers to the jobs they signed up for.
I ...
-1
votes
1
answer
55
views
How can I apply classes to my Tkinter application?
I am trying to create an application where within the main frame, there are two other frames (side to side).
The left frame consist of buttons that are always visible. Those buttons will change the ...
- 115
2
votes
1
answer
804
views
Realm for Android: Many to Many Relationship
I am trying to learn Realm basics by implementing a simple Android project.
The idea is that user have several items and several item lists and an item can be added to any of these lists and a list ...
- 5,492
0
votes
1
answer
231
views
C# SQL - Updating child table with same value as parent table
I have a table materialGroup in which I store information about default material groups.
Example:
> MaterialGroup
> - ID
> - MaterialGroup_Name
> - MaterialGroup_Price
There is an ...
- 577
0
votes
1
answer
326
views
Error with Yahtzee Code: The truth value of an array with more than one element is ambiguous. Use a.any() or a.all()
This is my code for finding the probability of different die cases in Yahtzee. I've figured out the yahtzee, and full house methods. But when I do the is_it_large_straight method it gives me an error ...
- 3
1
vote
1
answer
3k
views
setting up existing laravel project in Ubuntu
How to setup existing laravel 5 project and there database in Ubuntu 14.04 using xampp?
- 49
2
votes
2
answers
1k
views
Variable from __init__ changed in one function, but not recognized as changed to other function
Sup, i'm doing a little account registration just for learning propose.
I created a class called Accounts and did many different functions to work with. With previous acknowledgment i knew that i need ...
- 355
1
vote
1
answer
298
views
Oracle, EXTENDS mus be declared
I'm trying to create object data types in Oracle.
I have an object type called type_transaction, I use this type of body
EXTENDS functions.
The compiler crashes the following error:
"identifier '...
- 11
0
votes
1
answer
105
views
Creating A use-Case Diagram... Am I over complicating this
Scenario: (sort of Call center) (1) Customer Requests technician. (2) Request goes into queue for technicians to see. (2b) Customer gets confirmation email about submitting data (3) Technicians ...
- 408
0
votes
0
answers
64
views
First time creating UML diagram. I have two data structures Manager and Employee what class do they derive from?
So I have a class called "PERSON" then three data structures "Employees" , "Manager" and "Customer" but manager should have everything that employee has but with more capabilities but not more member ...
- 408