SQL Performance Tuning

本書全面探討了大語言模型（通常可簡稱“大模型”）在應用開發中的核心技術與實現。內容涵蓋了大語言模型的基本原理、微調與優化技術、複雜項目開發流程及高效實用的工程實踐案例，通過結構化的模塊設計和詳細的代碼解析，幫助讀者快速掌握相關技術並應用於真實場景，搭建從理論到實踐的完整知識體系。本書分為四部分，共10章，系統梳理了大語言模型的核心架構與原理，深入講解了Transformer模型的構造與訓練機制，全面介紹了現代微調方法（如LoRA、P-Tuning等）以及模型量化、編譯與推理優化的關鍵技術。針對應用場景，本書結合多個企業級實際案例，包括電商智能客服平臺、編程輔助插件、尋人檢索數據庫和硬件開發工程師助理等，詳細展示了從需求分析、數據處理、模型選擇到上線部署的完整開發流程。這些案例不僅強調技術實現，還融入了工程實踐中常見的問題與解決方案，為讀者提供了豐富的參考資料。本書適合對大語言模型感興趣的技術愛好者、希望深入研究模型微調與優化的科研人員、從事人工智能開發的工程師和產品經理，同時也適合高等院校相關專業學習大語言模型的師生。同時，隨書附贈案例代碼、教學視頻及授課用PPT，讀者可通過掃封底二維碼獲取。無論是初學者學習理論基礎、學生探索前沿技術，還是工程師在一線工作中進行實踐開發，本書都能提供系統化的知識體系和實用的開發技能。

"AI expert Jerry Kaplan explains how generative AI will revolutionize virtually every human activity. Highly recommended." - Francis Fukuyama, Political scientist and author of The End of History and the Last Man Advances in Generative Artificial Intelligence (GAI) have created a new class of computer systems that exhibit astonishing proficiency on a wide variety of tasks with superhuman performance, producing novel text, images, music, and software by analyzing enormous collections of digitized information. Soon, these systems will provide expert medical care; offer legal advice; draft documents; write computer programs; tutor our children; and generate music and art. These advances will accelerate progress in science, art, and human knowledge, but they will also bring new dangers. Have we finally discovered the holy grail of AI - machines that match or exceed human intelligence? Which industries and professions will thrive, and which will wither? What risks and dangers will it pose?

MEMS Heat Exchangers reviews key design, fabrication and modeling aspects involved in engineering microscale heat exchangers. It provides detailed equations for designing three core types of MEMS heat exchangers: heat pipes, two-fluid heat exchangers, and heat sinks. Prior to analyzing the details of MEMS heat exchanger design, the book provides relevant information on microfluidic heat transfer and fluid mechanics. In addition, the book provides detailed information on the techniques required for fabricating MEMS heat exchangers including mechanical machining and microfabrication. The book also details several thermal performance enhancement techniques that have been proposed and applied in recent years to MEMS heat exchangers.

本書從會計和商業數據分析、建模與評估、可視化、審計數據分析、財務報表數據等角度分析信息技術和大數據在會計、審計中的應用。全書著重強調實踐操作，每章主體內容以及每章末尾的實踐案例，為學生提供了數據庫的使用方法，幫助學生提出問題、下載數據、執行測試，然後交流測試結果。全書還關注數據分析工具，重點介紹了如何使用Excel、Access(包括SQL)、Tableau、IDEA和Weka等進行數據分析，便於學生比較不同的工具，從而選擇適用於不同數據分析、數據可視化以及交流分析結果的工具。

本書編寫的指導思想是以“實用，好用，夠用”為原則，幫助用戶掌握數據庫系統的基本原理、技術和方法，提高所學知識解決實際問題的動手能力。以圖書管理系統和生產管理系統為練習實例，從具體問題分析開始，在解決問題的過程中講解知識，介紹操作技能。全書的示例均用SQL語句實施和管理，可作為初學者的入門指南，又可作為中、高級用戶的參考手冊，同時也可作為各大中專院校和培訓班的數據庫基礎教材。本書總共包含8個章節，其中第1,2章主要講解數據庫基礎知識及安裝方法；第3,4,5,6章主要講解數據庫設計及基本操作，包括如何設計E-R圖，數據庫及表的基本操作，對數據的增刪改查等常用操作；第7章主要講解索引，提高MySQL查詢效率；第8章主要講解存儲過程及函數，包括MySQL流程控制語句，創建和管理存儲過程的方法。

Prestressing concrete technology is critical to understanding problems in existing civic structures including railway and highway bridges; to the rehabilitation of older structures; and to the design of new high-speed railway and long-span highway bridges. Analysis and Design of Prestressed Concrete delivers foundational concepts, and the latest research and design methods for the engineering of prestressed concrete, paying particular attention to crack resistance in the design of high-speed railway and long-span highway prestressed concrete bridges. The volume offers readers a comprehensive resource on prestressing technology and applications, as well as the advanced treatment of prestress losses and performance. Key aspects of this volume include analysis and design of prestressed concrete structures using a prestressing knowledge system, from initial stages to service; detailed loss calculation; time-dependent analysis on cross-sectional stresses; straightforward, simplified methods

Topology optimization is a digital method for designing objects in order to achieve the best structural performance, sometimes in combination with other physical requirements. Topology optimization tools use mathematical algorithms, such as the finite element method and gradient computation, to generate designs based on desired characteristics and predetermined constraints. Initially a purely academic tool, topology optimization has advanced rapidly and is increasingly being applied to the design of a wide range of products and components, from furniture to spacecraft. To explore the potential and challenges of topology optimization, the National Academies of Sciences, Engineering, and Medicine hosted a two-day workshop on November 19-20, 2019, Exploiting Advanced Manufacturing Capabilities: Topology Optimization in Design. The workshop was organized around three main topics: how topology optimization can incorporate manufacturability along with functional design; challenges and opport

本書是計算機科學與技術有關專業核心的課程教材。主要分為五個部分：第一部分為綜述，包括基本概念、數據庫發展歷史、數據庫管理系統等。第二部分為基礎篇，包括關系數據庫和關系數據庫標準語言SQL。第三部分為設計與應用篇，包括關係查詢處理和優化、實體―聯繫建模、關係數據理論、數據庫設計、數據庫編程和數據庫設計具體案例等。第四部分為管理篇，包括數據庫安全性、數據庫恢復技術、併發控制。第五部分為新技術篇，包括現階段數據庫系統的發展特點及發展趨勢。本書適應應用型本科辦學的新特點和新要求，適用於計算機類專業的教師和學生的實際需求。

本書以在數字化背景下，數據產品從業者的數據技術、數據技能、數據思維、數據方法、數據模型、產品用戶/客戶增長實戰經驗為基調，體系化撰寫了數字化和數據產品的數據經驗知識和案例。隨書附贈豐富的原始數據和源代碼，方便讀者對數據分析案例進行實操練習。本書內容全，結構完整。首先，講解了數據指標體系搭建和數據埋點案例；然後按照細節講解數據分析流程、數據采集方法、數據挖掘整體方法；緊接著通過實操案例講解了的數據產品工具，如EXCEL、Python、SQL、Anaconda、AB測試等工具，驅動數據增長的實戰模型，如ARIMA、AHP、LTV、AARRR等，以及數據倉庫和大數據平臺的搭建方法；最後講解了數據中台和數據安全、數據智能應用場景、用戶增長實戰案例。本書適合數字化市場下的數據產品從業者閱讀，主要讀者人群包含數據產品經理、數據運營人員、數據產品技術人員、數據領域創業者和相關專業的學生。