data modeling
Download
Skip this Video
Download Presentation
Data Modeling

Loading in 2 Seconds...

play fullscreen
1 / 20

Data Modeling - PowerPoint PPT Presentation


  • 70 Views
  • Uploaded on

Data Modeling. ER SADT UML. Data Modeling: ER. Entity-relationship diagram Entity: attributes Relationship: (smth)-(smth). Data Modeling: ER. CREATE TABLE ID (HD INTEGER NOT NULL, BD INTEGER,

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Data Modeling' - tuyet


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
data modeling
Data Modeling
  • ER
  • SADT
  • UML
data modeling er
Data Modeling: ER
  • Entity-relationship diagram
  • Entity: attributes
  • Relationship: (smth)-(smth)
data modeling er1
Data Modeling: ER

CREATE TABLE ID (HD INTEGER NOT NULL,

BD INTEGER,

CONSTRAINT hd_pk PRIMARY KEY (HD))

CREATE TABLE ProperMotion (HD INTEGER NOT NULL,

PMX DOUBLE,

PMY DOUBLE,

CONSTRAIN hd_fk FOREIN KEY (HD)

REFERENCES hd_pk)

SELECT T1.HD, T1.BD, T2.PMX, T2.PMY FROM ID T1, ProperMotion T2 where

T2.HD=T1.HD

slide4
SADT
  • Structured Analysis and Design Technique
  • Integration Definition for Function Modeling -0
  • Simple 2-elements diagram
uml unified modeling language
UML: Unified Modeling Language
  • SW design
  • Data processing design
  • Design → Implementation
  • Object-oriented approarch
  • Database design
uml use case diagram
UML: Use Case Diagram
  • Actor
  • Use Case
  • First step in developing
  • Define use cases
  • Do not go in details
uml activity diagram
UML: Activity Diagram
  • Initial State
  • Activity
  • Final (End) State
  • Connector (Fork/Union)
uml interaction diagram
UML: Interaction Diagram
  • Object (participant)
  • Lifeline
  • Message
uml class diagram
UML: Class Diagram
  • Class
  • Object
  • Relashionship
uml diagrams
UML: diagrams
  • Package diagram
  • Component diagram
  • Deployment diagram
  • Statechart diagram
data modeling uml
Data Modeling: UML
  • the same primitives for another purposes
  • data processing

diagram of classes

diagram of tables

slide15
XML
  • Extensible Markup Language
  • Self-describing format
  • Standard Generalized Markup Language
  • HTML
  • XML Schema
  • XSLT
xml structure
XML: structure
  • Node (Element)
  • Text
  • Attributes
python
Python
  • Python language www.python.org
  • Object-oriented, modular, API
  • language-interpreter
  • Functions def
  • Classes class
python an example
Python: an example

from math import pi, sin, cos, sqrt, asin, atan, atan2

from astro.util.extinction import p2i

class IDLLibError(Exception):

pass

def total(a,b):

try:

if(len(a)!=len(b)):

raise IDLLibError, \'total: the same size for input matrix\'

except:

raise IDLLibError, \'total: input are two matrix of the same size\'

x=0.0

for i in range(len(a)):

x=x+a[i]*b[i]

return x

python an example1
Python: an example

import MySQLdb

conn = MySQLdb.connect(host = "localhost",user = "root",passwd = "",

unix_socket="/home/belikov/mysql/mysql.sock",

read_default_file="/home/belikov/mysql/my.cnf")

cursor = conn.cursor ()

cursor.execute ("DROP DATABASE PROB")

cursor.execute ("CREATE DATABASE PROB")

cursor.execute ("USE PROB")

cursor.execute ("CREATE TABLE TWOMASS (RA DOUBLE, DECL DOUBLE)")

cursor.close ()

conn.close ()

slide20
R
  • Language for wrapping statistical computing
  • Site: www.r-project.org
  • Arrays
  • Plotting
  • Aggregate functions
ad