TAILIEUCHUNG - Ebook Database processing - Fundamentals, design, and implementation (13th edition): Part 2

(BQ) Part 2 book "Database processing - Fundamentals, design, and implementation" has contents: SQL for database construction and application processing, database redesign, managing multiuser databases, managing databases with SQL server 2012, oracle database 11g release 2, and MySQL other contents. | 308 04/09/13 10:09 AM Database Implementation P a r t In Chapter 5, we discussed how to create a data model for a new database, and in Chapter 6, we demonstrated how to transform that data model into a database design that we can use to build an actual database in a relational DBMS. We used the View Ridge Gallery (VRG) database as our example in Chapter 6 and finished with a complete set of specifications for the VRG database. In Part 3, we will implement the VRG database design in SQL Server 2012 (with versions for Oracle Database 11g Release 2 and MySQL shown in Chapters 10B and 10C, respectively). Part 3 consists of two chapters. Chapter 7 presents SQL data definition language statements for constructing database components and describes the SQL data manipulation statements for inserting, updating, and deleting data. You will also learn how to construct and use SQL views. The chapter concludes with an introduction to embedding SQL statements in application programs and SQL/Persistent Stored Modules (SQL/PSM), which leads to a discussion of SQL triggers and stored procedures. Chapter 8 presents the use of SQL statements to redesign databases. It presents SQL correlated subqueries and then introduces SQL statements using the SQL EXISTS and NOT EXISTS keywords. Both of these advanced SQL statements are needed for database redesign. Chapter 8 also describes database reverse engineering, surveys common database redesign problems, and shows how to use SQL to solve database ­redesign problems. 309 3 04/09/13 10:11 AM SQL for Database Construction and Application Processing 7 Chapter Objectives ● To create and manage table structures using SQL statements ● To understand how referential integrity actions are implemented in SQL statements ● To create and execute SQL constraints ● To understand several uses for SQL views ● To use .

• Cơ sở dữ liệu
• Database processing
• SQL for database construction
• Application processing
• Database redesign
• Managing multiuser databases
• Managing databases
• Database design
• Database development
• Relational databases
• Database environments
• Client server processing
• Parallel database processing
• Fundamentals of database systems
• Database systems
• Database design theory
• File structures
• Query processing
• Database tuning
• Transaction processing
• Concurrency control
• Database system concepts
• Lecture Database system concepts
• Database languages
• Advanced transaction processing
• Database concepts
• Lecture Database concepts
• Database fundamentals
• Database management
• Database processing environment
• Database System
• Lecture Database Systems
• Transaction processing monitors
• Transactional workflows
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Multidatabase query processing
• query rewriting
• Query Processing and Optimization
• Translating SQL Queries into Relational Algebra
• Using Selectivity
• Database Management Systems
• Transaction Processing Concepts and Theory
• Desirable Properties of Transactions
• Characterizing Schedules based on Recoverability
• 1 Introduction to Transaction Processing
• Distributed query processing
• Lecture Database system
• Structured query language
• The relational model
• Database design using normalization
• The entity relationship model
• Transforming data models
• Algorithms for Query Processing and Optimization
• Algorithms for External Sorting
• Algorithms for SELECT and JOIN Operations
• Data Versus Information
• File Processing Systems
• Database Development Process
• Analyzing Database Requirements
• Modeling Multiple Relationships
• Measures of query cost
• Formal relational query languages
• Relational database design
• Query optimization
• Lecture Database management systems
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Database definition
• Commercial applications
• File processing system
• Lecture Distributed Database Management Systems
• Distributed Database Management Systems
• Bài giảng Hệ quản trị cơ sở dữ liệu phân tán
• Traditional file processing system
• Database approach
• Distributed computing system
• Database  Management Systems
• Transaction  Processing
• dirty data
• cascading rollback
• transactions complete
• Fuzzy object algebra expression
• Fuzzy OODB
• Query optimizatio
• Fuzzy object oriented database
• programming data
• database
• computer tips
• MySQL
• computer data
• data management