DATABASE
DATABASE 1
Databse introduction Database creation and maintenance Database query
• Databse introduction • Database creation and maintenance • Database query
User INTRODUCTION TO DATABASE Application software o Typical cases 。Bank DBMS 。Supermarket ·Medical records Operating system Database VB Database VC++ engine SQL DBMS PowerBuilder Applicatio Database n software Delphi ORACLE ACCESS FOXPRO SOL SERVER
Typical cases Bank Supermarket Medical records INTRODUCTION TO DATABASE 3 Applicatio n software DBMS VB VC++ PowerBuilder Delphi ACCESS SQL SERVER ORACLE FOXPRO SQL Database engine Database User Application software DBMS Operating system Database
BASIC CONCEPTS 1.Database(DB) A database is a structured collection of data 2.Database Management System(DBMS) A set of programs that enables you to store,modify,and extract information from a database,it also provides users with tools to add,delete,access,modify,and analyze data stored in one location ·Microsoft Acess Oracle;SQLServer;MySQL;(network) 3.Database Application software Software developed by some tools(e.g.Visual C++)for database applications in certain environment
BASIC CONCEPTS 4 1. Database (DB) • A database is a structured collection of data 2. Database Management System (DBMS) • A set of programs that enables you to store, modify, and extract information from a database, it also provides users with tools to add, delete, access, modify, and analyze data stored in one location • Microsoft Acess • Oracle; SQLServer; MySQL ; (network) 3. Database Application software • Software developed by some tools (e.g. Visual C++) for database applications in certain environment
DATABASE HISTORY >3 phases for data management ·Managed manually ·Managed with files Managed with database 5
DATABASE HISTORY ➢ 3 phases for data management Managed manually Managed with files Managed with database 5