Conceptual Data Modeling and Database Design: A Fully Algorithmic Approach, Volume 1: The Shortest Advisable Path
暫譯: 概念資料建模與資料庫設計:完全算法化的方法,第一卷:最短建議路徑
Mancas, Christian
- 出版商: Apple Academic Press
- 出版日期: 2021-03-31
- 售價: $3,570
- 貴賓價: 9.5 折 $3,392
- 語言: 英文
- 頁數: 698
- 裝訂: Quality Paper - also called trade paper
- ISBN: 1774635453
- ISBN-13: 9781774635452
-
相關分類:
Algorithms-data-structures、資料庫
海外代購書籍(需單獨結帳)
相關主題
商品描述
This new book aims to provide to both beginners and experts with a completely algorithmic approach to data analysis and conceptual modeling, database design, implementation, and tuning, starting from vague and incomplete customer requests and ending with IBM DB/2, Oracle, MySQL, MS SQL Server, or Access based software applications. A rich panoply of solutions to actual useful data sub-universes (e.g. business, university, public and home library, geography, history, etc.) is provided, constituting a powerful library of examples.
Four data models are presented and used: the graphical Entity-Relationship, the mathematical EMDM, the physical Relational, and the logical deterministic deductive Datalogones. For each one of them, best practice rules, algorithms, and the theory beneath are clearly separated. Four case studies, from a simple public library example, to a complex geographical study are fully presented, on all needed levels.
Several dozens of real life exercises are proposed, out of which at least one per chapter is completely solved. Both major historical and up-to-date references are provided for each of the four data models considered.
The book provides a library of useful solutions to real-life problems and provides valuable knowledge on data analysis and modeling, database design, implementation, and fine tuning.
商品描述(中文翻譯)
這本新書旨在為初學者和專家提供一種完全以演算法為基礎的數據分析和概念建模、資料庫設計、實作及調整的方法,從模糊且不完整的客戶需求開始,最終以 IBM DB/2、Oracle、MySQL、MS SQL Server 或 Access 為基礎的軟體應用結束。書中提供了針對實際有用的數據子宇宙(例如商業、大學、公共和家庭圖書館、地理、歷史等)的豐富解決方案,構成了一個強大的範例庫。
書中介紹並使用了四種數據模型:圖形化的實體-關聯模型(Entity-Relationship)、數學的 EMDM、物理的關聯模型(Relational)以及邏輯的確定性推導 Datalogones。對於每一種模型,最佳實踐規則、演算法及其背後的理論都被清楚地分開。書中完整呈現了四個案例研究,從簡單的公共圖書館範例到複雜的地理研究,涵蓋所有必要的層面。
書中提出了數十個現實生活中的練習,其中每一章至少有一個完全解決的範例。對於考慮的四種數據模型,書中提供了主要的歷史和最新的參考資料。
這本書提供了一個有用的解決方案庫,針對現實生活中的問題,並提供有關數據分析和建模、資料庫設計、實作及微調的寶貴知識。
作者簡介
Christian Mancas, PhD, is currently an associate professor with both the Mathematics and Computer Science Departments of Ovidius University, Constanta, Romania, and the Engineering Taught in Foreign Languages Department (Computer Science and Telecommunications in English stream) of Politehnica University, Bucharest, Romania (as an invited professor). Since 2012, he is also a database architect with Asentinel International srl, Bucharest, a subsidiary of Asentinel LLC, Memphis, Tennessee. His specialties include university teaching, R&D, business analysis, conceptual data and knowledge modeling and querying, client-server, hierarchical software architecture, object-oriented, event-driven design, structured development, complex project and small IT company management, Datalog, SQL, C#, XML programming, etc.
Professor Christian Mancas has published dozens of scientific papers (in Romania, USA, Austria, and Greece), which have been indexed by ACM Digital Library, Zentralblatt, Scopus, DBLP, Arnetminer, Researchr, TDGS, SCEAS, etc. He has also published three books in Romanian and dozens of reviews (mostly in USA, including ACM Reviews). He was a Program Committee member and session chairman for several software conferences in USA, Austria, and Romania, and he is a member of several associations (including ACM, the Romanian Mathematics Sciences Society, and the International Who's Who of Professionals). Since 2006, his biography is included in Marquis Who's Who in the World and Who's Who in Science and Engineering and Hubners' Who's Who in Romania.
Since 1990, he also worked for several IT startups, including his own DATASIS Consult srl (co-owned with his good friend and faculty colleague Ion Draghicescu) and DATASIS ProSoft srl (who had 25 programmers working for the design and development of several ERP-type database applications for customers from France, UK, Switzerland, USA, Israel, Greece, and Romania).
His main research areas are conceptual data and knowledge modeling and querying; database design, implementation, and optimization; as well as the architecture, design, development, fine-tuning, and maintenance of data and knowledge base management systems.
Dr. Mancas graduated in 1977 from the Computers Department of Politehnica University of Bucharest, Romania, with a thesis on Generating Parsers for LR(k) Grammars, under the supervision of Professor Dan Luca Serbanati. Up until the fall of communism in 1990, he worked as a software engineer and, since 1980, R&D manager of a state-owned Computer Center in Bucharest (contributing to the design, development, and maintenance of a dedicated ERP), also conducting (from time to time) computer programming labs at Politehnica University of Bucharest, but for political reasons, he was not accepted for PhD studies. He started this program under the supervision of Professor Cristian Giumale in 1992 and obtained his PhD in 1997 from the above department, with a thesis on Conceptual Data and Knowledge Modeling.
作者簡介(中文翻譯)
克里斯蒂安·曼卡斯(Christian Mancas),博士,目前是羅馬尼亞康斯坦察奧維迪烏斯大學數學與計算機科學系的副教授,以及羅馬尼亞布加勒斯特波利特尼卡大學外語授課工程系(英語流的計算機科學與電信)的受邀教授。自2012年以來,他還擔任羅馬尼亞布加勒斯特Asentinel International srl的數據庫架構師,該公司是田納西州孟菲斯的Asentinel LLC的子公司。他的專長包括大學教學、研發、商業分析、概念數據與知識建模及查詢、客戶端-伺服器架構、層次式軟體架構、物件導向、事件驅動設計、結構化開發、複雜專案及小型IT公司的管理、Datalog、SQL、C#、XML程式設計等。
克里斯蒂安·曼卡斯教授已在羅馬尼亞、美國、奧地利和希臘發表了數十篇科學論文,這些論文已被ACM數字圖書館、Zentralblatt、Scopus、DBLP、Arnetminer、Researchr、TDGS、SCEAS等索引。他還出版了三本羅馬尼亞文書籍和數十篇書評(主要在美國,包括ACM Reviews)。他曾擔任美國、奧地利和羅馬尼亞幾個軟體會議的程序委員會成員和會議主席,並且是幾個協會的成員(包括ACM、羅馬尼亞數學科學學會和國際專業人士名錄)。自2006年以來,他的傳記被收錄於《馬奎斯世界名人錄》和《科學與工程名人錄》以及《霍布納羅馬尼亞名人錄》中。
自1990年以來,他還為幾個IT初創公司工作,包括他自己的DATASIS Consult srl(與他的好朋友及教職同事Ion Draghicescu共同擁有)和DATASIS ProSoft srl(該公司有25名程式設計師為來自法國、英國、瑞士、美國、以色列、希臘和羅馬尼亞的客戶設計和開發幾個ERP類型的數據庫應用程式)。
他的主要研究領域包括概念數據與知識建模及查詢;數據庫設計、實施和優化;以及數據和知識庫管理系統的架構、設計、開發、微調和維護。
曼卡斯博士於1977年畢業於羅馬尼亞布加勒斯特波利特尼卡大學計算機系,論文題目為《LR(k)文法的解析器生成》,指導教授為丹·盧卡·塞爾巴納提教授。在1990年共產主義垮台之前,他擔任軟體工程師,自1980年起擔任布加勒斯特一家國有計算機中心的研發經理(參與設計、開發和維護專用ERP),並不時在布加勒斯特波利特尼卡大學進行計算機程式設計實驗室的教學,但因政治原因未能被接受攻讀博士學位。他於1992年在克里斯蒂安·久馬萊教授的指導下開始該計畫,並於1997年在上述系所獲得博士學位,論文題目為《概念數據與知識建模》。