相關主題
商品描述
Fully updated and expanded from the previous edition, A Practical Guide to Database Design, Second Edition is 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.
商品描述(中文翻譯)
《資料庫設計實用指南（第二版）》是從前一版全面更新和擴展而來，旨在幫助參與資料庫系統或應用程式設計或開發的人士。書中首先說明如何開發第三正規型（Third Normal Form）資料模型，將資料放置在「應該在的位置」。讀者將逐步了解正規化過程，首先使用一組簡單的資料需求，然後再使用更複雜的資料需求。接下來，將回顧每個邏輯資料模型的使用分析，並產生滿足用戶性能需求的物理資料模型。最後，將每個物理資料模型作為輸入，使用 Microsoft Access 和 SQL Server 創建資料庫。
本書接著展示如何使用業界領先的資料建模工具來定義和管理邏輯及物理資料模型，以及如何創建資料定義語言（Data Definition Language）語句，以在 SQL Server、Oracle 或其他類型的資料庫管理系統（DBMS）中創建或更新資料庫。
有一章專門說明如何使用 Microsoft Access 創建用戶介面，以檢視和更新該資料庫中的基礎表格，以及位於 SQL Server 或 Oracle 中的表格。
對於參與網路活動或支援的用戶，有一章說明如何使用 PERL 從日誌檔案中提取感興趣的記錄，然後展示如何將這些提取的記錄載入一個或多個 SQL Server 的「追蹤」表格，並為分析師在檢視感興趣的活動時添加狀態標記。這些狀態標記用於標記/標示已收集的記錄為「已檢視」、「待處理」（目前正在分析中）和「已解決」。最後一章展示如何使用 PHP 建立基於網頁的 GUI，以查詢這些追蹤表格，並允許分析師檢視新活動、標記需要調查的項目，並最終標記已調查和解決的項目。請注意，本書提供了完整的 PERL 和 PHP GUI 的程式碼/腳本。
作者簡介
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.
作者簡介(中文翻譯)
雷克斯·霍根擁有超過 40 年的資料庫管理員和軟體工程師經驗。其中包括在西南貝爾/AT&T 超過 17 年的經驗，期間他成為該公司的首席資料庫專家。在此期間，他還在密蘇里州聖路易斯的華盛頓大學資料處理研究中心教授各種本科和研究生課程。之後，他在 TRW/Northrop Grumman 工作了 16 年，主要擔任 DBA/高級軟體工程師，專注於資料庫系統和應用程式的快速設計與開發。最後，他在空軍特別調查辦公室擔任計算機科學家五年，開發計算機系統以監控美國空軍的網路流量使用情況。他撰寫和合著了幾本書籍，包括 資料庫設計實用指南（第一版）、IMS 資料庫的診斷技術 和 IMS 資料庫管理。
