第1章 MySQL簡介 - nuu.edu.tw

第1章 MySQL簡介 - nuu.edu.tw

1 MySQL - CH1 - CH1 1 - CH1 MySQL Access Access MySQL

- CH1 - CH1 - CH1 2 1-1 1-2 - CH1 1-3 MySQL - CH1 1-4 MySQL 1-5 Access

1-6 MySQL 1-7 - CH1 - CH1 3 1-1 (Database)Database) (Database)Client-Server Database) - CH1 WEB Internet - CH1

- CH1 - CH1 - CH1 4 1-2 - CH1 1-2-1 1-2-2 1-2-3 1-2-4 1-2-5 1-2-6 1-2-7

- CH1 - CH1 - CH1 - CH1 - CH1 5 1-2-1

. (Database) ) - CH1 - CH1 6 1-2-2

(Database)Record) ) - CH1 - CH1 7 1-2-3 (Database)File)

- CH1 - CH1 8 1-2-4 - CH1 - CH1 - CH1 - CH1 Network Mod) el Hierarchical Mod) el Relational Mod) el

- CH1 - CH1 9 Network Model - CH1 - CH1 10 (Hierarchical Model)Hierarchical Model)

- CH1 - CH1 11 Relational Model ..

- CH1 - CH1 12 1-2-5 - CH1 - CH1 (Database)Database Management Syste m, DBMS) - CH1 - CH1 - CH1

13 1-2-5 - CH1 ( ) - CH1 - CH1 - CH1 14

1-2-6 - CH1 (Database)One-Tier) - CH1 (Database) Two-Tier) - CH1 (Database) Three-Tier) - CH1 - CH1 - CH1 15 (Hierarchical Model)One-Tier) - CH1 - CH1

Database - CH1 - CH1 16 (Hierarchical Model) Two-Tier) - CH1 - CH1 (Database)Client Server) Client PC Server (Database)Database Server) Database File Server

LAN Client - CH1 - CH1 17 - CH1 ( ) SQL Datab ase Server

- CH1 - CH1 18 (Hierarchical Model) Three-Tier) - CH1 - CH1 (Database)Application Server, AS) Application Server

Database Server Web Server LAN Internet Client - CH1 - CH1 Browser 19

- CH1 ( ) WEB - CH1 - CH1 - CH1 20 1-2-7

MySQL Open Source - CH1 - CH1 21

1-3 MySQL - CH1 1-3-1 1-3-2 1-3-4 1-3-5 1-3-6 - CH1 - CH1 - CH1

22 1-4 MySQL 1-4-1 1-4-2 1-4-3 1-4-4 1-4-5 1-4-6 1-4-7

- CH1 - CH1 23 1-4-1

C C++ VB, C, C++, Eiffel, Java, Perl, PHP, Python, Ruby , Tcl API CPU - CH1 Transactional Non-transactional - CH1 - CH1 24 1-4-1 ( )

ISAM MySQL MyISAM B B-tree - CH1 (Database)o ne sweep multi-join) SQL

- CH1 - CH1 25 1-4-2 / Integer INT) FLOAT DOUBLE CHAR VARCHAR TEXT BLOB DATE TIME DATETIME TIMESTAMP YEAR SET ENUM

OpenGIS - CH1 - CH1 26 1-4-3 MySQL SQL MySQ L CH 10 - CH1 - CH1

27 1-4-4 MySQL Privilege Password) - CH1 - CH1 Host-based) MySQL MySQL - CH1 - CH1

28 1-4-5 MySQL - CH1 Linux 2.2-Intel 32 bit 2GB (LFS: $GB) Linux 2.4 (ext3 - CH1 ) 4TB

Solaris 9/10 16TB NetWare NSS - CH1 8TB Win32 FAT/FAT32 - CH1 2GB/4GB Win32 NTFS - CH1

2TB ( ) MacOS X HFS+ - CH1 2TB - CH1 - CH1 29 1-4-6 MySQL MyODBC ODBC - CH1 - CH1

30 1-4-7 MySQL - CH1 - CH1 31 1-5 Access

Access PC Access 1024 255 - CH1 (Database)API) - CH1 - CH1 32 1-5 Access (Hierarchical Model) )

Access SQL Access File Server File Server - CH1 - CH1 - CH1 33

1-6 MySQL 1-6-1 1-6-2 1-6-3 - CH1 - CH1 - CH1 34 1-6-1 MySQL TCP/IP Encryption

Integrity Autnenti cation - CH1 Intranet Information System - CH1 Extranet Information System - CH1 - CH1 35 1-6-2 API

ODBC TCP/IP Database Access MySQL - CH1 - CH1 36 1-6-2 (Hierarchical Model) )

NetBIOS API Server ODBC TCP/IP Database Access MySQL - CH1 - CH1

37 1-7 MySQL - CH1 - CH1 38

Recently Viewed Presentations

  • Daily Agenda 9/6/17

    Daily Agenda 9/6/17

    A stanza is "a group of lines in a poem, separated by spaces from other stanzas, much like a paragraph in prose." A . couplet. is "two lines of poetry, one after the other, that rhyme and are of the...
  • Plagiarism, Copyright, Fair Use and Intellectual Property

    Plagiarism, Copyright, Fair Use and Intellectual Property

    Citation Manuals Available in the Roberts-LaForge Library MLA Handbook for Writers of Research Papers (6th Edition) Publication Manual of the American Psychological Association (5th Edition) The Chicago Manual of Style (15th Edition) A Manual for Writers of Term Papers, Theses,...
  • The Great Migration & The Harlem Renaissance

    The Great Migration & The Harlem Renaissance

    La Frontiera del colore nell'era modernista HARLEM AGLI INIZI DELLA GRANDE MIGRAZIONE (1915-20) Paul Laurence Dunbar Apartments (anni Venti) Striver's Row IL 369° REGGIMENTO (17.2.1919) CLAUDE MCKAY, "IF WE MUST DIE" (1919) If we must die—let it not be like...
  • Understanding Organisations and the Role of HR (3HRC)

    Understanding Organisations and the Role of HR (3HRC)

    CIPD HR profession map. Role of HR in supporting change. Future State & Case for Change: A vivid picture of the future state is developed with clear understanding how this links to the wider organisational objectives, and the benefits at...
  • Alternative Technology Energy Facility RFI Meeting

    Alternative Technology Energy Facility RFI Meeting

    CDM Smith solid waste experience. Current solid waste system. Benefits and Limitations of Waste Conversion Technologies. Waste Conversion Technology Examples. The Long Term - 15 to 20 years in the future. COJ Solid Waste Strategy.
  • Tüberküloz Tedavisinde yeni yaklaşımlar

    Tüberküloz Tedavisinde yeni yaklaşımlar

    DOTS'UN AVANTAJLARI-2 -DOTS, sıklıkla fatal olan ve tedaviyi 100 misline kadar pahalılaştıran ilaç direncini önlemeye yardımcı olur. -DOTS kayıtlama ve izleme sistemi, kürü garanti etmek için, tedavinin tüm seyri boyunca her bir hastayı izler. -Bir yönetim stratejisi olarak ...
  • Quaternions and William Rowan Hamilton

    Quaternions and William Rowan Hamilton

    "Every morning in the early part of [October 1843], on my coming down to breakfast, your little brother, William Edwin, and yourself, used to ask me, 'Well, papa, can you multiply triplets?' Whereto I was always obliged to reply, with...
  • The Magnuson-Stevens Fishery Conservation & Management Act

    The Magnuson-Stevens Fishery Conservation & Management Act

    Tribal Issues of Interest White House est. 1st Council on Native American Affairs (6/13) EPA announces $635M plan to clean Upper Coeur d'Alene River Basin (9/12) Sen. Cantwell 1st female chair of Indian Affairs Graffiti of Alcatraz Occupation preserved by...