Stack Overflow
Stack Overflow

Questions tagged [object-relational-model]

101 questions
13
votes
2 answers

Object oriented vs. object relational database difference

I have been reading about database models and still do not understand what are the fundamental differences between object oriented and object relational models. I learned so far that object relational database is a relational database also which…
ps-aux
  • 11,627
  • 25
  • 81
  • 128
7
votes
2 answers

Is it a bad idea to use a database's primary key as business object identifier?

I wonder, is it bad or good idea to use auto increment primary key as business entity identifier such as Partner Id or Account Number? Also, what pitfalls I can face if I'll choose that approach?
Vokinneberg
  • 1,912
  • 2
  • 18
  • 31
6
votes
2 answers

Update a table and its related model in laravel?

I have client table and client_address info table. I need to update both table when updating client.my model classes given below, class Client extends Model { public function addressInfo() { return…
gsk
  • 2,329
  • 8
  • 32
  • 56
5
votes
2 answers

Should I learn Linq to SQL even though its being rolled into Entity Framework?

I am looking to learn Linq to query MS SQL databases, but am unsure of which path to take. I read recently that Linq to SQL is being rolled into Entity Framework, and development has maybe stagnated. Is it worth learning Linq to SQL still? Or should…
csjohnst
  • 1,678
  • 3
  • 17
  • 24
5
votes
1 answer

multiple/split class associations in sqlalchemy

I have the following objects and relations defined. This is actually quite a simple case, and I am providing all those fields just to show why I believe inhalation and injection anesthesia should be defined by two different classes. class…
TheChymera
  • 17,004
  • 14
  • 56
  • 86
4
votes
3 answers

Which Javascript MVC framework best handles relational data?

I'm looking to try, for the first time, a JavaScript MVC framework like Knockout, Backbone.js, Spine, JavaScriptMVC, etc. I've started looking at some of the documentation available for these frameworks and I'm having trouble finding examples of how…
Adam
  • 43,763
  • 16
  • 104
  • 144
4
votes
2 answers

connect SQLAlchemy ORM with the objects from sql core expression?

I have to use SQLalchemy Core expression to fetch objects because ORM can't do "update and returning". (the update in ORM doesn't has returning) from sqlalchemy import update class User(ORMBase): ... # pure sql expression, the object returned…
WeiChing 林煒清
  • 4,452
  • 3
  • 30
  • 65
4
votes
6 answers

Does exist ORM / Framework that converts data automatically when I want to change column datatype in table?

Assume that I have existing database with existing data. Is there any framework / ORM that generates data conversion SQL scripts when I need change column datatype? Of course there is problem with conversions like float to int string to int ,…
Michał Kuliński
  • 1,928
  • 3
  • 27
  • 51
4
votes
2 answers

How can I define a type in oracle11g that references a collection of that type?

I want to do something like this create type Item as object ( id number, subitems table of ref Item ) but oracle throws an exception when I try to do it. Is this possible, and if yes then how?
pablochan
  • 5,625
  • 27
  • 42
3
votes
1 answer

What is an extended SQL schema?

I have an assignment where one of the questions is asking for an "extended SQL schema" of a given object-relational database. Does anyone have an idea of what this question means? The given database tables are: car_parts, engine_parts, tires and…
Mason
  • 31
  • 1
3
votes
1 answer

Data Annotation or Fluent API? Best Practise for supporting various ORM's

I am looking into implementing a form a Data Validation on at the Data Layer of my application. I am looking to accept a specific string input into my data model, but am struggling to know how best to implement this. I am currently looking into…
user9443374
3
votes
1 answer

How can I represent this Game Owner Relationship in Laravel's Eloquent

I'm trying to tease out a logical problem that I'm having and I didn't know where else to ask! I have two Objects whose relationship I'm trying to describe; the User and the Game. So, right now, I have that a User belongs to many Games, and that a…
Martin T.
  • 445
  • 1
  • 7
  • 18
3
votes
1 answer

Oracle sqlplus - defining typed table with no attributes but nested tables

I have an problem with my homework. I have the following type definitions: -- Type definitions CREATE OR REPLACE TYPE languages_table_t AS TABLE of VARCHAR2(20); / CREATE OR REPLACE TYPE phones_table_t AS TABLE of NUMBER; / CREATE OR REPLACE TYPE…
Throoze
  • 3,988
  • 8
  • 45
  • 67
2
votes
4 answers

Dynamic Database/Key - Value/Entity - Key Value Dillemma

I have been programming relational database for many years, but now have come across an unusual and tricky problem: I am building an application that needs to have very quick and easily defined entities (by the user). Instances of these entities…
Paul Grimshaw
  • 19,894
  • 6
  • 40
  • 59
2
votes
1 answer

ORA-00927: missing equal sign when trying to update table in object-relational DB

i'm trying to understand object-relational technology and created parent type: CREATE OR REPLACE TYPE STUDENT AS OBJECT( FIO VARCHAR2(200), Bday DATE, Pas_Id NUMBER(20), Address VARCHAR2(50)) NOT INSTANTIABLE NOT FINAL; child…
Den
  • 55
  • 4
1
2 3 4 5 6 7