460 likes | 557 Views
Selected Topics of Information Technologies. Prof. Dr. Yang Dehua School of Economics and Management Tongji University. Outlines. Data Resource Management Computer Networks. Data and Information. Data Information Information Quality Timeliness Relevancy Forms.
E N D
Selected Topics of Information Technologies Prof. Dr. Yang Dehua School of Economics and Management Tongji University
Outlines Data Resource Management Computer Networks
Data and Information Data Information Information Quality Timeliness Relevancy Forms
Data Resources and Organization Foundation Data Concepts Character Field Record File/Table Database
Data Organization Personnel Database Logical Data Elements Payroll File Benefits File Employee Record1 Employee Record2 Employee Record1 Employee Record2 Insur-ance Field Insur-ance Field Name field SS No Field Salary Filed Name field SS No Field Salary Filed Name field SS No Field Name field SS No Field 275-32 200.0 Smith 234-98 150.0 Jones 275-32 50.0 Smith 234-98 30.0 Jones
Database Systems Applications1 DBMS Applications2 Data Applications3 ...
Database Types Types of Databases Operational databases Distributed databases External databases Hypermedia databases
Data Models Data Models Hierarchical Network Relational Object Oriented Database
Data Warehouse Enterprise Data Warehouse(EDW) Data Marts Data Analysis and Decision Making
Data Warehouse--Components Operational, External,Other Databases Users OLAP Enterprise Data Warehouse Data Mart Data Management Subsystem Data Acquisition Subsystem Data Access and Delivery Subsystem Metadata Directory Metadata Repository Metadata Management Subsystem Web information Systems Warehouse Design Subsystem
Data Mining Data Mining To discover correlations, patterns, and trends in vast amount of business data stored in data warehouses Models and Algorithms Statistical models Optimizations Forecasting
Data Mining Processes ETL Interpretation/Evaluation Selection Transformation Mining Targeted Data Data Warehouse Patterns Knowledge Databases
Database Software Commercial Software Oracle DB2 MS SQL Server
Database Software(FOSS) Free Open Source Software MySQL PostgreSQL
Computer Networks Computer Systems Computer Hardware Computer System Software Computer Application Software Users
Computer Systems Hardware, Software, and People Hardware System Software Application Software Computer Users
Computer Telecommunications Telecommunications Model Telecommunications Channels/Media Telecommunications Processors Telecommunications Processors PCs, NCs, and Other Terminals Computers Telecommunications Software
Computer Telecommunications Communication Example -- Dial-up Network Telephone Line Processors PC Modem Modem PC
Computer Network Types Computer Networks In Area Covered Perspective Local Area Networks(LAN) Municipal Area Network(MAN) Wide Area Networks(WAN) In Network Ownership Pespective Public Networks Private Networks Virtual Private Networks(VPN)
Computer Network Types • In Communication Media Pespective • Wired Networks • Wireless Networks
Client/Server Computing C/S Structure Requests Data and Services
Intranet Computing Multi-Tier Architecture
Network Protocols Basic Functions of Networks Communications Resource Sharing Some Frequently Used Protocols NetBEUI IPX/SPX TCP/IP
The Internet The Internet Features Internetworking TCP/IP Protocols Public Networks Global Information Dissemination Huge Volume of Information Quick and Convenient Access Low Cost
The Internet Structure The Internet Routing
The Internet Address The Internet Addresses Internet Device Identification The Internet Addresses IP v4: 4 bytes; 202.89.132.56 127.0.0.1 IP v6: 16 bytes 1080:0000:0000:0000:0008:0800:200C:417A 0000:0000:0000:0000:0000:0000:0A00:0001
The Internet Domain Names • Domain Names • www.myserver.com --> 202.9.13.201 • Domain Name Service(DNS) • Top Level Domain(TLD) Names • By Country or Region Acronyms: • cn, us, hk, de, ... ... • By Industries, Businesses, Governments and Organizations • com, gov, mil, edu, net, org • Hierarchy of Domain Name Services
Internet TLD Additional Top Level Domain Names after 1980 aero (for the air-transport industry) biz (for businesses) coop (for cooperatives) Info (for all uses) Musium (for museums) Name (for individuals) Pro (for professions)
Basic Internet Services E-Mail WWW FTP BBS WEBCAST ...
Intranets and Extranets Intranet A corporate network that functions with the Internet technologies, usually guarded by firewalls when connected with the Internet. Extranet A network that links the intranets of business partners over the Internet.
Internet Web Site The Relations among Internet, intranets and extranets in an Enterprise Internet Links Engineering Server Marketing Server Extranet Links Extranet Links Corporate Intranet H. R. Server Legacy Data Server Customers Suppliers Intranet Links Other Company Locations Enterprise Internet, Intranets and Extranets
Intranet Structure Enterprise Intranet Structure
Extranet Connections • Enterprise Extranets
WAN Connections Classes of WAN Connections: PSTN[public switched telephone (voice) networks] Connected via PBX (private branch exchange) to local telco exchanges, circuit switched, charged by time ISDN ADSL
WAN Connections PSDN (public switched data networks) Connected directly, packet switched, charged by volume/capacity DDN ATM FDDI
Internet Connections FTTx+LAN 10M/100M/1000MBPS Fibre Optic Cable ADSL 512K/1M/2M/4MBPS Cable Modem 512KBPS(U)/1MBPS(D) Wireless Network WiFi(b,g,n), WiMax, Mobile Communications BPL(Broadband over Power Line) VPN
Wireless Technologies Wireless Standards/Technologies: IrDA – short distance, peripheral connections Bluetooth - short distance, <720Kbps, used on mobiles IEEE 802.11b/g /n(Wifi) – mature, cheap, <11/54/300Mbps, used on laptops, patchy coverage WiMax(Worldwide Interoperability for Microwave Access) - new, long distance, <70mbps, 31 miles range Mobile Communications
Mobile Communications Provide Pervasive Computing/Services Voice Services: Cellular network, limited frequencies, location based Standards: GSM (Global Systems for Mobile Communication) (2G) CDMA (Code Division Modulation Access) (3G) Data Transfer WAP I-Mode Data access by CDMA
SSL VPN (Example) RAID Disks Anti-Virus Server Network Mgmt Fiber Switch App/Data Server IDS SSL VPN Gateway Switch Apps and Data Area FTP Server Firewall Web Server Router E-Mail Server DMZ Area InternetSSL VPN Tunnel
IPSec VPN (Example) RAID HDS Thunder9532V Anti-Virus Mcafee Network Mgmt CWW-6.1-WIN Fiber Switch BR-3200-0011 IBM P650 IBM P650 IDS CVI-S100-1-P Apps/Data Zone Switch WS-C3550-48-SMI FirewallNGFW4000 FTP X235-8671-L1C VPN RouterC2621XM-2FE/VPN/K9 Web Server X205-8480-42X Internet IP SEC Tunnel E-Mail X205-8480-42X VPN RouterC2621XM-2FE/VPN/K9 VPN RouterC2621XM-2FE/VPN/K9 Firewall NGFW3000 Firewall NGFW3000 IDS CVI-S100-1-P IDS CVI-S100-1-P