SBAdesc pics

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Slide1: 

Dept [0..*] dname: string location: string [1..*] Emp [0..*] name: string age: integer sal: integer [0..1] worksIn [1..1] employs [1..*] i50 Dept i51 dname ”Trade” i52 location ”Paris” i53 location „Rome” i54 employs i10 i60 Dept i61 dname ”Ads” i62 location ”Berlin” i63 employs i30 i64 employs i20 i30 Emp i31 name ”Lee” i32 age 20 i33 worksIn i60 i10 Emp i11 name ”Doe” i12 age 29 i13 sal 1900 i14 worksIn i50 i20 Emp i21 name ”Poe” i22 age 41 i23 sal 2500 i24 worksIn i60

Slide4: 

Company C# 102030 CName Syntex Boss employs employs employs Employee Name Doe Salary 1500 worksIn Employee Name Lee Salary 2000 worksIn Employee Name Poe Salary 2500 worksIn

Slide9: 

S – Objects < i1, Person, {< i2, name, ”Doe”>, ... } >, < i5, Emp, {< i6, name, ”Poe”>, < i7, sal, 2000>, < i8, worksIn, i22>, ... } >, < i9, Emp, {< i10, name, ”Lee”>, < i11, sal, 900>, < i16, worksIn, i33>, ...} > C - Classes < i40, PersonClass, {< i41, age, (...the code of the method age)>, ... other invariants of the PersonClass... } >, < i50, EmpClass, { < i51, changeSal, (... the code of the method changeSal...)>, < i52, netSal, (... the code of the method netSal ...)>, ... other invariants of the EmpClass... } > R - Start identifiers i1, i5, i9 CC - Inheritance among classes < i50, i40> SC - Membership of objects within classes < i1, i40>, < i5, i50>, < i9, i50>

Slide11: 

Student Employee Club-member Student Tax-payer Dog-owner Person Patient

Slide12: 

S – Objects (and roles) <i1, Person, { <i2, name, ”Doe” >, <i3, born, 1948 > } >, <i4, Person, { <i5, name, ”Poe” >, <i6, born, 1975 >} >, <i7, Person, { <i8, name, ”Lee” >, <i9, born, 1951 >} >, <i13, Emp, { <i14, sal, 2500 >, <i15, worksIn, i127> } >, <i16, Emp, { <i17, sal, 1500 >, <i18, worksIn, i128> } >, <i19, Student, { <i20, studentNo, 223344 >, <i21, faculty, ”Physics” >} > ..... C - Classes <i40, PersonClass , { <i41, age, (...code of the method Age...) >, ...other properties of PersonClass...}>, <i50, EmpClass , {<i51, changeSal, (...code of the method changeSal...) >, <i52, netSal, (...code of the method netSal...) >, ...other properties of EmpClass... }>, <i60, StudentClass , { <i61, avgScore, (... code of the method AvgScore...) >, ...other properties of StudentClass ... }>, ..... R – Root identifiers i1, i4, i7, i13, i16, i19, ... CC - Inheritance between classes Empty. SC - Membership of objects and roles in classes < i1, i40>, < i4, i40>, < i7, i40>, < i13, i50>, < i16, i50>, < i19, i60> , ... SS – Inheritance between roles and objects < i13, i4>, < i16, i7>, < i19, i7> , ...

Slide15: 

Variables declared within block b Variables and actual parameters of procedure p2 Variables and actual parameters of procedure p1 ........ Global variables Top of the stack Bottom of the stack the order of searching for variable X

Slide16: 

i1 Emp i5 Emp i9 Emp i17 Dept i22 Dept Persistent (shared) objects i127 X i128 Y Volatile (non-shared) objects Client Server

Slide30: 

Emp where ( sal > 1000 ) i1 i5 i9 i3 i7 i11 i1 i5 Result returned by query Emp Results returned by query sal Iteration over elements of the previous result Dereference forced by > 2500 2000 900 Results returned by query 1000 1000 1000 1000 true true false Results returned by query sal>1000 Final result of the query Emp(i1) Emp(i5) Emp(i9) Dept(i17) Dept(i22) ENVS before evaluation

Slide31: 

Emp e# name job sal worksIn Dept d# dname boss Location d# loc Address e# city street house# Relational schema Dept [0..*] d# dname loc[1..*] Object-oriented schema (class diagram) worksIn employs[1..*] Emp [0..*] e# name job sal Address [0..1] city street house# manages[0..1] boss

Slide32: 

( Dept join avg((employs . Emp ) . sal ) ) Emp(..) Emp(..), ... Dept(..) Dept(..) ... Emp(..) Emp(..), ... Dept(..) Dept(..) ... d#(..), dname(..) loc(..) loc(..) ... employs(..) employs(..) ... boss(..) Emp(..) Emp(..), ... Dept(..) Dept(..) ... Emp(..) d#(..), dname(..) loc(..) loc(..) ... employs(..) employs(..) ... boss(..) Emp(..) Emp(..), ... Dept(..) Dept(..) ... d#(..), dname(..) loc(..) loc(..) ... employs(..) employs(..) ... boss(..) Emp(..) Emp(..), ... Dept(..) Dept(..) ... e#(..) name(..) job(..) sal(..) worksIn(..) manages(..) d#(..), dname(..) loc(..) loc(..) ... employs(..) employs(..) ... boss(..) Emp(..) Emp(..), ... Dept(..) Dept(..) ... d#(..), dname(..) loc(..) loc(..) ... employs(..) employs(..) ... boss(..) Emp(..) Emp(..), ... Dept(..) Dept(..) ...

Slide35: 

Calculation of parameters, binding the name MyMethod and firing the method result(q0) Previous QRES state Operator where Evaluation of q0 Removing the results of q1, q2 Processing of the MyMethod body After completing MyMethod ....... Global sections time result(q2) result(q1) result(q0) Previous QRES state result(q0) Previous QRES state result(q) result(q0) Previous QRES state nested(r1) nested(iMC) ....... Global sections p1(result(q1)) p2(result(q2)) x1(..) x2(..) nested(r1) nested(iMC) ....... Global sections nested(r1) nested(iMC) ....... Global sections

Slide36: 

Emp[0..*] e# job[1..*] sal[0..1] changeSal(newSal) netSal( ) Dept[0..*] d# dname loc[1..*] budget() employs[1..*] worksIn Person[0..*] name birthYear age() Address [0..1] city street house# manages[0..1] boss

Slide38: 

Properties of the currently processed Emp role Properties of the EmpClass Properties of the Person super-role of the Emp role Properties of the PersonClass Database section Search order sal(i17) worksIn(i18) changeSal(i51) netSal(i52 ) ... name(i8) born(i9) age(i41) ... ......... Person(i1) Person(i4) Person(i7) Emp(i13) Emp(i16) Student(i19) ... ......... Bottom of ENVS

Slide41: 

Emp[0..1] e# job[1..*] sal[0..1] changeSal(newSal) netSal( ) Dept[0..*] d# dname loc[1..*] budget() employs[1..*] studiesAt manages boss Person[0..*] name birthYear age( ) Address [0..1] city street house# Student[0..*] s# faculty[0..1] scholarship avgScore( ) Exam[0..*] subject score School[0..*] name city worksIn teaches[0..*] Manager[0..1]

Slide42: 

Software: strategic decisions, analysis, design, construction, testing, documentation, deployment, user training, operation, maintenance, modifications, etc. The world of the problem domain: complex, interdependent knowledge, business processes, aspects, problems and solutions. The world of analysis and design: teams of people having limitations of memory, perception, expressing information and communication. The world of software users: psychological factors, ergonomy, limitations of memory, tendency to errors and abuse, ownership, intellectual properties, privacy, security, etc. The world of computer technologies: hardware, software, networks, languages, methodologies, tools, facilities, standards, etc.

Slide43: 

Human perception of the problem domain Abstract conceptual model of the problem domain Programmer’s view of data structures and operations mapping mapping

Slide44: 

Real objects or concepts in the problem domain Classes of abstract objects in the conceptual model of the problem domain Objects and their classes as data structures within an object-oriented database seamless mapping seamless mapping

Slide45: 

Employer Employee Employment Details 1..* 0..*

Slide46: 

Broker Deal Subject Date Price Person Name Buyer Seller Broker Person Name Buyer Seller Deal Subject Date Price

Slide47: 

Deal House 1995.08.16 40000 Deal Car 1998.05.15 20000 Person Kim Broker Deal Car 1998.05.15 20000 Person Lee Person Noe Buyer Seller Broker Deal House 1995.08.16 40000 Person Poe Person Doe Buyer Seller Person Kim Broker Person Lee Person Noe Buyer Seller Broker Person Poe Person Doe Buyer Seller

Slide48: 

Employee employee# job salary company# netSalary() changeSalary(...) Student student# yearOfStudy faculty insertScore(...) acceptSemester() Person firstName lastName dateOfBirth age() object object object object object object object object inheritance

Slide49: 

Student Employee Club-member Student Tax-payer Dog-owner Person Patient

Slide50: 

Person Name Doe BirthYesr 1948 PersonClass Name BirthYear Age() EmployeeClass Salary Job NetSalary() ChangeSalary(..) StudentClass Semester StudentNo NewScore(...) AvgScore() Classes Person Name Brown BirthYear 1975 Employee Salary 2500 Job analyst Person Name Jones BirthYear 1940 Student Semester 4 StudentNo 556677 Objects with roles Company Name Bank works_in works_in School Name NYA studies_at School Name MLI studies_at is_a_customer_of Person Name Smith BirthYear 1951 Employee Salary 1500 Job clerk Student Semester 7 StudentNo 223344 is a member of association link inherits from dynamically inherits from

authorStream Live Help