1 Linux Advanced Enterprise Server Management LINUX 2 Slides: 32 Download presentation 1 Linux Advanced Enterprise Server Management LINUX高级企业服务器管理 2 数据库的相关概念 • 数据(data) • 数据库(Database, DB) • 数据库管理系统(Database Management System) • 数据库的类型 p 纯文本数据库-DNS、口令 p 关系数据库 Ø Ø 企业级:Oracle, SQL Server, Sybase, Informix, DB 2 中小型:Postgre. SQL, Mysql, Access, Dbase, Paradox • Linux下的数据库 p p Mysql Postgre. SQL 6 SQL概述 • SQL(Structured Query Language)是一种综合、通用、 功能极强并且简洁易用的关系数据库语言 • SQL标准 p p p SEQUEL SQL 86 SQL 89(SQL 1) SQL 92(SQL 2) SQL 3 7 SQL的应用 • Oracle、SQL server、DB 2、Sybase、Postgre. SQL、 My. SQL都实现了SQL语言 • Dbase、Foxpro、Access等部分实现了SQL语言 • HTML中嵌入SQL语句可以通过WWW访问数据库 • 在VC、VB、DEPHI等高级语言中可以嵌入SQL语句 8 mysql的相关文件 • mysql的主目录 p /var/lib/mysql • mysql的启动/停止/重启 p p p service mysqld start service mysqld stop service mysqld restart 10 mysql的基本使用 • 启动 p service mysqld start • 连接到数据库 p mysql [-h hostname] [-u username] [-p[password]] [database] 12 Microsoft master data servicesConfidential computingAdvanced stored procedure examples in sql serverTjänsteintegrationTieto enterprise integration serverTieto enterprise integration serverWebcam server linuxLinux virtual server clusterServer linux emperorTwamp server linuxBuild in linuxRadius linuxLinux terminal server einrichtenInode 최대 개수Putting the enterprise into the enterprise systemPutting the enterprise into the enterprise systemGeneral securityUclinuxAdvanced group policy managementAdvanced farm management programAdvanced case managementMeredith and mantel three stage modelIntroduction to managerial accounting pptAdvanced cost and management accounting pptAoAdvanced certificate management studiesAdvanced train management systemAdvanced principles of fracture managementDirectionsAdvanced fms & security services pvt ltdBc adm examIcs 400: advanced ics for complex incidents-aberdeenThree column concept tibial plateau