Hogan A Practical Guide to Database Design

2. Auflage 2018
ISBN: 978-1-351-26546-1
Verlag: Taylor & Francis
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 430 Seiten

Fully updated and expanded from the previous edition,A Practical Guide to Database Design, Second Editionis intended for those involved in the design or development of a database system or application. It begins by illustrating how to develop a Third Normal Form data model where data is placed where it belongs. The reader is taken step-by-step through the Normalization process, first using a simple then a more complex set of data requirements. Next, usage analysis for each Logical Data Model is reviewed and a Physical Data Model is produced that will satisfy user performance requirements. Finally, each Physical Data Model is used as input to create databases using both Microsoft Access and SQL Server.
The book next shows how to use an industry-leading data modeling tool to define and manage logical and physical data models, and how to create Data Definition Language statements to create or update a database running in SQL Server, Oracle, or other type of DBMS.
One chapter is devoted to illustrating how Microsoft Access can be used to create user interfaces to review and update underlying tables in that database as well as tables residing in SQL Server or Oracle.
For users involved with Cyber activity or support, one chapter illustrates how to extract records of interest from a log file using PERL, then shows how to load these extracted records into one or more SQL Server tracking tables adding status flags for analysts to use when reviewing activity of interest. These status flags are used to flag/mark collected records as Reviewed, Pending (currently being analyzed) and Resolved. The last chapter then shows how to build a web-based GUI using PHP to query these tracking tables and allow an analyst to review new activity, flag items that need to be investigated, and finally flag items that have been investigated and resolved. Note that the book has complete code/scripts for both PERL and the PHP GUI.

Autoren/Hrsg.

Hogan, Rex

Fachgebiete

• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Data Mining
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Spiele-Programmierung, Rendering, Animation

Inhaltsverzeichnis

1. Overview of Databases1.1 What’s a "Database"? 1.2 Guranteed Accuracy and Availability of Data1.3 Dynamic alteration of design1.4 Dynamic Queries – any data, any time1.5 Referential Integrity Enforcement1.6 Backup/Recovery1.7 Failover1.8 Typical Installation

2. Normalization2.1 Introduction2.2 The "Language of Normalization"2.3 Creating the Entity/Attribute List2.4 Cleaning Up the Entity/Attribute List2.5 Normalization2.6 Creating the Data Model2.7 Fourth Normal Form2.8 Fifth Normal Form

3. Database Implementation3.1 Logical to Physical Design3.2 Usage Path Analysis3.3 Table Key and Column Data Types3.4 Indexes3.5 Table Creation

4. Normalization and Physical Design Exercise4.1 Introduction4.2 Creating the Entity/Attribute List4.3 First Normal Form4.4 The Logical Data Model4.5 Second Normal Form4.6 Third Normal Form4.7 The Physical Data Model

5. The erwin Data Modeling Tool5.1 What is a Data Modeling Tool? 5.2 Why do I need a Data Modeling Tool? 5.3 Reverse Engineering5.4 Change Management5.5 Download and Install erwin Trial Software5.6 Create the University Logical Data Model5.7 Create the University Physical Data Model5.9 Create a SQL Server University Database

6. Using Microsoft Access6.1 Overview6.2 Modifications to the Database Design6.3 Loading Data Into Tables6.4 Creating Queries6.5 Using Forms6.6 Generating Reports6.7 Deploying Access for a Team of Users6.8 The Role of Pass-Thru Queries

7. Using SQL Server7.1 Overview7.2 Database Creation/Installation7.3 Creating Databases7.4 User Roles7.5 Authorized Users7.6 Backup/Recovery7.7 Loading Data Into Tables7.8 Creating Views7.9 Manual Queries and Edits7.10 Using Stored Procedures7.11 Using SQL Server Agent

8. Using Perl to Extract and Load Data8.1 Why Perl? 8.2 Perl vs. Python8.3 Windows vs Unix8.4 Review key matching features8.5 Monitor SQL Server logs8.6 Monitoring Windows Logs8.7 Other Applications and Uses8.8 Loading Data into Tables8.9 Summary

9. Building User Interfaces9.1 Used in Typical Office Environment9.2 Use Microsoft Access as GUI9.3.NET Framework9.4 PHP9.5 JAVA

10. Creating the University Database Application10.1 Create tables for University environment10.2 Create Relationships to Enforce Referential Integrity10.3 Design a Screen to Add New Students10.4 Create a Screen to Enroll Students in a Class10.5 Create a Screen to Assign Grades10.6 Create Screens to Enter Midterm and Final Grades10.7 Create a "Main" Menu10.8 Developing Applications for University Administrators

11. PHP Implementation and Used11.1 Why PHP? 11.2 System Components11.3 Design of Web-based Interface11.4 Script Logic

Über Autor(innen)

Rex Hogan has over 40 years experience as a database administrator and as a software engineer. This includes over 17 years of experience with Southwestern Bell/AT&T where he became their lead database specialist. During this period, he also taught various undergraduate and graduate classes at Washington University’s Center for the Study of Data Processing in St. Louis, MO. He then worked for TRW/Northrop Grumman for 16 years, primarily as a DBA/senior software engineer where he became a specialist in the rapid design and development of database systems and applications. Finally, he worked for five years as a computer scientist for the Air Force Office of Special Investigations, where he developed computer systems to monitor usage of USAF internet traffic. He has authored and co-authored several books, including A Practical Guide to Database Design (first edition), Diagnostic Techniques for IMS DataBases,and Managing IMS Databases.