![](https://csdnimg.cn/release/downloadcmsfe/public/img/no-data.51c5211b.png)
![](https://csdnimg.cn/release/downloadcmsfe/public/img/good-course.ff455529.png)
- 图书管理系统课程设计报告(基于JAVA和SQLServer)初学者学习。资源来源于网络,希望共同学习图书馆(对书本的管理) 1. 初始化图书馆的书本 2. 图书馆有提供借书给用户的功能 3. 图书馆有提供用户还书到图书馆的功能 4. 图书馆提供 查询图书馆的所有图书的功能 2. 用户系统(对用户管理) 1. 初始化用户 2. 用户管理提供注册用户的功能(用户名:首字母小写,至少6位。密码:必须包含小写字母,大写字母,数字,至少6位) 3. 用户管理提供用户登录的功能 3. 用户(用户本身图书的管理) 1. 用户可以借书到自己的书包 2. 用户可以把自己借到的书本归还给图书馆 3. 用户可以查询自己已经借阅到的图书 功能分析: 1. 只有用户登录后才能显示与书籍相关信息
0 981浏览
会员免费 - SQL Server 2019安装教程(含下载方式).pdfSQL Server 2019安装教程
0 2579浏览
会员免费 - 数据库-课表数据库关于课表的文档,涉及到课表的设计,课表的建立,以及在数据库中的分析
0 478浏览
会员免费 - 数据挖掘原理与应用——SQL Server 2005 数据库数据挖掘原理与应用——SQL Server 2005 数据库,ZhaoHui Tang著,杨大川审校
4 66浏览
会员免费 - 新浪微博OAuth授权新浪微博OAuth授权的Java实现,这篇文章中,我想用比较通俗的语言来解释OAuth协议。
4 89浏览
会员免费 - sql server 2008基础应用和开发实战教程(附视频)该文档中包含关于sql server 2008版本的所有基础知识,从基础的理论知识到实践代码,针对每个知识,都附带对应的视频教程。
1 233浏览
会员免费 - SQL Server 2019 for Windows Server 2019无域搭建always-on.pdf本文介绍了SQL Server 2019 for Windows Server 2019无域搭建always-on。测试通过后,采用图文结合的方式,说明和讲解了SQL Server 2019 for Windows Server 2019无域搭建always-on的方法、步骤及关键点。
5 717浏览
会员免费 - Pro SQL Server 2012 Reporting ServicesPro SQL Server 2012 Reporting Services
5 61浏览
会员免费 - SQL_Server_2008维护计划实现数据库定时自动备份SQL_Server_2008维护计划实现数据库定时自动备份
5 664浏览
会员免费 - 在Excel中直接打开SQL数据库的视图、表和存储过程摘要:Excel使用广泛,特别在管理工作中,希望直接能从数据库中提取数据。但是,数据库通常不能随便操作的,那么,怎样才能在Excel中取出自己希望的数据呢?我们在Excel中做了开发,实现在Excel中直接打开SQL数据库的视图、表和存储过程,视图和存储过程是由使用者编写,表肯定是SQL服务器中固有的。
0 684浏览
会员免费 - SQL Server 数据库系统加固规范SQL Server 数据库系统加固规范, 自己看吧。
0 277浏览
会员免费 - SQL Server 海量数据查询代码优化以及建议SQL Server 海量数据查询代码优化以及建议: 海量数据是大家容易碰到的一个难题,本文档给出了中肯的建议
0 766浏览
会员免费 - AdventureWorks数据库说明及其他AdventureWorks数据库说明及其他
5 118浏览
会员免费 - MS-TDS协议规范最新版[v20120328][MS-TDS]:Tabular Data Stream Protocol Specification [MS-TDS] — v20120328 Tabular Data Stream Protocol Specification Copyright © 2012 Microsoft Corporation. Release: Wednesday, March 28, 2012
4 386浏览
会员免费 - SQL Server 2012 高可用性解决方案SQL Server 2012 高可用性解决方案
0 721浏览
会员免费 - 数据库面试笔试题集.pdf数据库面试笔试题集。对正在找工作的人来说。。绝对的福音。。赶紧看吧。。说不定面试官就会问到哦。。
4 61浏览
会员免费 - 实验室安排管理系统数据库,软件工程的实验室安排管理系统,很好的文档和代码。
4 452浏览
会员免费 - SQL Server 2012 Tutorials - Reporting ServicesSQL Server 2012 Tutorials - Reporting Services
0 79浏览
会员免费 - 微软数据库考试70-768: Exam Ref 70-768 Developing SQL Data Models微软MCSA认证考试70-768 Developing SQL Data Models Course OutlineModule 1: Introduction to Business Intelligence and Data ModelingThis module introduces key BI concepts and the Microsoft BI product suite.Lessons Introduction to Business Intelligence The Microsoft business intelligence platform Lab : Exploring a BI Solution Exploring a Data Warehouse Exploring a data model After completing this module, students will be able to: Describe BI scenarios, trends, and project roles. Describe the products that make up the Microsoft BI platform. Module 2: Creating Multidimensional Databases This module describes how to create multidimensional databases using SQL Server Analysis Services.Lessons Introduction to Multidimensional Analysis Data Sources and Data Source Views Cubes Overview of Cube Security Configure SSAS Monitoring SSAS Lab : Creating a multidimensional database Creating a Data Source Creating and Configuring a data Source View Creating and Configuring a Cube Adding a Dimension to a Cube After completing this module, you will be able to: Describe considerations for a multidimensional database. Create data sources and data source views. Create a cube Implement security in a multidimensional database. Configure SSAS to meet requirements including memory limits, NUMA and disk layout. Monitor SSAS performance. Module 3: Working with Cubes and DimensionsThis module describes how to implement dimensions in a cube.Lessons Configuring Dimensions Defining Attribute Hierarchies Implementing Sorting and Grouping Attributes Slowly Changing Dimensions Lab : Working with Cubes and Dimensions Configuring Dimensions Defining Relationships and Hierarchies Sorting and Grouping Dimension Attributes After completing this module, you will be able to: Configure dimensions. Define attribute hierarchies. Implement sorting and grouping for attributes. Implement slowly changing dimensions. Module 4: Working with Measures and Measure GroupsThis module describes how to implement measures and measure groups in a cube.Lessons Working with Measures Working with Measure Groups Lab : Configuring Measures and Measure Groups Configuring Measures Defining Regular Relationships Configuring Measure Group Storage After completing this module, you will be able to: Configure measures. Configure measure groups. Module 5: Introduction to MDXThis module describes the MDX syntax and how to use MDX.Lessons MDX fundamentals Adding Calculations to a Cube Using MDX to Query a Cube Lab : Using MDX Querying a cube using MDX Adding a Calculated Member After completing this module, you will be able to: Use basic MDX functions. Use MDX to add calculations to a cube. Use MDX to query a cube. Module 6: Customizing Cube FunctionalityThis module describes how to customize a cube.Lessons Implementing Key Performance Indicators Implementing Actions Implementing Perspectives Implementing Translations Lab : Customizing a Cube Implementing an action Implementing a perspective Implementing a translation After completing this module, you will be able to: Implement KPIs in a Multidimensional database Implement Actions in a Multidimensional database Implement perspectives in a Multidimensional database Implement translations in a Multidimensional database Module 7: Implementing a Tabular Data Model by Using Analysis ServicesThis module describes how to implement a tabular data model in Power Pivot.Lessons Introduction to Tabular Data Models Creating a Tabular Data Model Using an Analysis Services Tabular Data Model in an Enterprise BI Solution Lab : Working with an Analysis Services Tabular Data Model Creating an Analysis Services Tabular Data Model Configure Relationships and Attributes Configuring Data Model for an Enterprise BI Solution. After completing this module, students will be able to: Describe tabular data models Describe how to create a tabular data model Use an Analysis Services Tabular Model in an enterprise BI solution Module 8: Introduction to Data Analysis [removed]DAX)This module describes how to use DAX to create measures and calculated columns in a tabular data model.Lessons DAX Fundamentals Using DAX to Create Calculated Columns and Measures in a Tabular Data Model Lab : Creating Calculated Columns and Measures by using DAX Creating Calculated Columns Creating Measures Creating a KPI Creating a Parent – Child Hierarchy After completing this module, students will be able to: Describe the key features of DAX Create calculated columns and measures by using DAX Module 9: Performing Predictive Analysis with Data MiningThis module describes how to use data mining for predictive analysis.Lessons Overview of Data Mining Creating a Custom Data Mining Solution Validating a Data Mining Model Connecting to and Consuming a Data-Mining Model Using the Data Mining add-in for Excel Lab : Using Data Mining Creating a Data Mining Structure and Model Exploring Data Mining Models Validating Data Mining Models Consuming a Data Mining Model Using the Excel Data Mining add-in After completing this module, students will be able to: Describe considerations for data mining Create a data mining model Validate a data mining model Connect to a data-mining model Use the data mining add-in for Excel
0 282浏览
会员免费 - intouch与SQL连接方法intouch与SQL连接方法
0 1030浏览
会员免费 - Microsoft SQL Server 2008 Integration Services Problem, Design, Solution.pdfssis 这个是 学习的重点 不看都不行
5 146浏览
会员免费 - Data Model Resource Book vol 1Data Model Resource Book vol 1, Data Model领域经典之一
0 101浏览
会员免费 - SSIS入门一个印度人写的SSIS入门教程,我自己看过,很不错的入门教程,适合初学者。 不过是英语,但是有截图,所以应该还好。
4 906浏览
会员免费 - SQL Server 2012 Tutorials - Transact SQL DML ReferenceSQL Server 2012 Tutorials - Transact SQL DML Reference
0 69浏览
会员免费 - SQL SERVER数据库附加失败解决办法各种数据库附加失败的解决办法,共享给大家,希望对大家有帮助!
0 2502浏览
会员免费 - High Performance SQL Server The Go Faster Book PDFHigh Performance SQL Server The Go Faster Book PDF 英文 文字版
0 107浏览
会员免费 - Inside Microsoft SQL Server 2008: T-SQL ProgrammingInside Microsoft SQL Server 2008_T-SQL Programming
5 180浏览
会员免费 - SQL_Server_2008_参数化行筛选的合并复制的配置图解SQL_Server_2008_参数化行筛选的合并复制的配置图解
0 146浏览
会员免费 - 数据库系统概念(第五版)这本书基本涵盖了数据库领域方方面面的基础原理
0 1082浏览
会员免费 - MCITP SELF-PACED TRAINING KIT 70-640MCITP SELF-PACED TRAINING KIT 70-640
0 81浏览
会员免费 - Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012
0 52浏览
会员免费 - SQLServer 2008编程入门经典(第3版)SQLServer 2008编程入门经典(第3版)
0 126浏览
会员免费 - ODBC MFC教程这是一份ODBC MFC的简单教程。更方便大家迅速,简单掌握最基本的知识要点。
3 73浏览
会员免费 - 一千万条以上记录分页数据库优化经验总结别人写的一篇文章,觉得不错,分享给大家。
3 760浏览
会员免费 - Inside Microsoft SQL Server 2008 - T-SQL Querying《Microsoft SQL Server 2008技术内幕:T-SQL查询》这本书的英文原版 本书全面深入地介绍了Microsoft SQL Server 2008 中高级T-SQL 查询、性能优化等方面的内容,以及SQLServer 2008 新增加的一些特性。主要内容包括SQL 的基础理论、查询优化、查询算法及复杂度,以及在使用子查询、表表达式、排名函数、数据聚合和透视转换、TOP 和APPLY、数据修改、分区表、特殊数据结构等实际应用时会遇到的各种高级查询问题和解决方案。作为一本讲述T-SQL 高级查询的专业图书,本书旨在结合实践中的各种常见问题,教读者如何用SQL 作为语言工具来思考问题,揭示基于集合查询的强大威力。本书内容丰富、文字简洁明快,列举的实例具有一定的难度,而且实用性很强,可以把它们作为解决实际问题的标准模式。阅读本书,可以充分地理解T-SQL 语言和良好的编程实践,学会如何编写更加有效而强大的查询语句。
5 195浏览
会员免费 - SSRS 报表集成解决方案SQL Server Reporting_Service报表集成解决方案
4 219浏览
会员免费 - Microsoft-SQL Server 2008 Reporting Services Step by Step(2009).pdfMicrosoft-SQL Server 2008 Reporting Services Step by Step(2009).pdf, 学习2008 报表服务的好书
5 105浏览
会员免费 - 数据库系统概念中文版 答案 详解数据库系统概念中文版 答案 详解
4 193浏览
会员免费 - 数据仓库 ETL SSIS数据仓库 ETL SSIS 理论知识 名家著作
0 815浏览
会员免费 - SQL Server 2016 Developer's Guide 1st edUtilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications Work with temporal tables to get information about data stored in the table at any point in time A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience
5 112浏览
会员免费 - Windows Server 2012 + SQL Server 2016安装必读Windows Server 2012 + SQL Server 2016安装必读
5 1106浏览
会员免费 - SQL完全手册(第2版)(完全手册丛书)SQL完全手册(第2版)(完全手册丛书) 出版社:电子工业出版社 出版日期:2010/1/1 作 者:James R.Groff Paul N.Weinberg[美] ISBN:9787121099687 SQL是当今信息处理领域最热门的技术之一,随着SQL规范的不断完善和普及,SQL已成为各数据库厂商必须遵循的标准。熟悉和了解SQL的原理和方法,是所有与数据处理有关的人员必须掌握的技能。本书是在前一版的基础上修订而成的。内容涉及SQL命令和语句的使用方法、关系数据库的建立、数据库对象的载人和修改、强大查询的执行、性能调优以及安全政策的实现等。读者还会学到如何采用DDL语句和API、集成XML和Java脚本、使用SQL对象、建立Web服务器、处理远程访问及执行分布式事务等知识。此外,本书还介绍了用于管理运行在掌上设备和无线设备上的内存数据库、流数据库和嵌入式数据库技术。 本书对SQL技术的使用和发展进行了全面的讨论。全书分为六大部分。第一部分介绍什么是SQL,并从市场角度讲述其作为数据库语言的作用。第二部分描述SQL中的数据库查询功能。第三部分探讨如何添加、删除和更新现有数据库的数据。第四部分介绍创建和管理基于SQL的数据库的方法。第五部分介绍应用程序使用SQL进行数据库访问的方法。第六部分分析SQL的使用情况以及基于SQL的DBMS产品的现状。与前一版相比,这一版本中包含了一些新的章节,专门讲述SQL在应用服务器架构中的作用、SQL与XML的集成,以及其他对象技术(包括商务智能数据库、内存数据库、流数据库和嵌入式数据库)。全书不仅介绍了SQL的基本知识、SQL的发展历程,而且提供了各主要数据库开发商在数据库领域的成长信息。因此,本书适用于希望理解和学习SQL的任何人,包括数据库用户、从事数据处理工作的专业人士、架构设计师、程序员、学生和管理人员。
5 43浏览
会员免费 - iFix通过DDE读写EXCEL数据iFix通过DDE读写EXCEL数据
0 284浏览
会员免费 - SQL Server2012安装图解及意外解决SQL Server2012安装图解及常见意外解决;
0 2488浏览
会员免费 - SQL Server 2014 Development Essentials - Masood-Al-Farooq, Basit A. [SRG].pdfWhat this book covers Chapter 1, Microsoft SQL Server Database Design Principles, explains the database design process and the architecture and working of the SQL Server 2014 Storage Engine. This chapter covers the database development life cycle in detail, including the normalization and denormalization process, beneits of choosing appropriate data types, and the functioning of the SQL Server 2014 Storage Engine. Chapter 2, Understanding DDL and DCL Statements in SQL Server, introduces the reader to the SQL Server 2014 Transact-SQL language elements and SQL Server 2014 Management Studio (SSMS 2014). This chapter explains Transact-SQL DDL, DCL, and DML language elements in detail, and how you can use them to create, manage, and secure SQL Server 2014 databases, schemas, and tables. This chapter also shows you how you can use SQL Server Management Studio to create and manage SQL Server 2014 databases, schemas, and tables. Finally, this chapter covers the purpose of SQL Server 2014 system databases and highlights the advantages and disadvantages of database recovery models. Chapter 3, Data Retrieval Using Transact-SQL Statements, demonstrates how to query data from tables, how to write multiple table queries, and how to group, organize, and pivot result set data. This chapter explores the basic form of the SELECT statement and how it can be used to query data from tables. This chapter also highlights the different categories of built-in T-SQL functions and how you can use them in your SELECT statements. This chapter also explains different techniques that you can use to combine data from multiple tables, how to organize the data, and how to generate the summary data by grouping or pivoting it. Finally, this chapter covers the purpose of the CTE and SQL Server 2014 windowing functions and how to use them to quickly solve complex analytical tasks. Chapter 4, Data Modiication with SQL Server Transact-SQL Statements, illustrates how to add, modify, and delete data in tables using Transact-SQL DML statements. This chapter covers how to add data to a table using the INSERT statement, how to delete the data using the DELETE statement, and how to update existing data using the UPDATE statement. This chapter also covers the SELECT…INTO, MERGE, and TRUNCATE TABLE statements, and it highlights the key new enhancements of these statements in SQL Server 2014. Chapter 5, Understanding Advanced Database Programming Objects and Error Handling, covers reusable programming objects that includes views, stored procedures (normal and natively compiled), functions and triggers (based on either DDL or DML), SQL Server 2014 control-of-low statements, and structured error handling blocks. This chapter shows you how you can declare and use variables and how you can use control-of-low statements to control your program execution. Next, it explains the purpose of views, stored procedures, user-deined functions, and triggers, and highlights the guidelines and restrictions to design each of these programmable objects. This chapter also illustrates how to handle errors that occur within Transact-SQL batches and programmable objects using the TRY...CATCH construct. Chapter 6, Performance Basics, explains performance-related features of SQL Server 2014. This chapter irst explains the architecture of the SQL Server Relational Engine. Then, it introduces the architecture of the SQL Server 2014 in-memory technology. Next, it covers all SQL Server 2014 index types and how they can be used to achieve optimal query performance while reducing the overall response time. Then, it explores the architectural differences of B-tree, Bw-tree, and xVelocity columnstore indexes. Finally, it explains core performance topics such as SQL Server query optimization statistics, SQL Server transactions and locks, and tools that come with SQL Server 2014 Database Engine, which you can use to monitor and troubleshoot its Database Engine performance.
0 124浏览
会员免费 - 数据库期末复习北京林业大学数据库期末复习资料,题型有单选、填空、简答、关系代数运算、设计题SQL。
0 321浏览
会员免费 - 从Sqlserver移植到DM参考手册[csdn]从Sqlserver迁移到DM数据库介绍文档: 第 1 章 概述 2 第 2 章 移植过程 2 2.1 待移植系统分析 2 2.1.1 统计SqlServer数据库基础信息 2 2.1.2 统计SQLServer数据中的对象以及表数据量 2 2.2 准备移植环境 3 2.2.1 DM移植环境 4 2.2.2 SqlServer移植环境 5 2.3 常规对象及数据迁移 6 2.3.1 指定迁移计划 6 2.3.2 表对象迁移 6 2.3.3 视图对象迁移 9 2.3.4 处理迁移过程中的错误 11 2.4 TSQL移植 20 2.4.1 导出待移植对象的脚本 20 2.4.2 运行脚本并处理错误 24 2.5 核对数据库移植结果 25 2.6 数据库移植完毕后的收尾工作 26 2.7 应用移植 28 2.7.1 JAVA接口 28 2.7.2 DOT NET接口 36 2.8 系统测试与优化 39 第 3 章 附录 39 3.1 DM7与Sqlserver2008对比 39 3.1.1 数据类型 40 3.1.2 常用函数 40 3.1.3 TSql与DM-Sql 43
5 439浏览
会员免费 - 房产中介管理系统PDF格式的房产中介管理系统,本人的课程设计哦!
0 1244浏览
会员免费 - excel表格和wincc的报表如何使用WinCC DataMonitor基于Web发布浏览Excel报表文档
2 269浏览
会员免费 - Professional Microsoft SQL Server 2012 Reporting Services(Wrox,2012).SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors.
5 99浏览
会员免费 - 数据库(SQL ORCAl)参考手册主要数据库参考资料,比较系统介绍数据库的相关知识。
5 80浏览
会员免费 - SQL语句大全【经典教程】.pdfSQL语句大全【经典教程】适合初学者,很有用。
5 568浏览
会员免费 - SQL基础详解SQL基础详解 什么是SQL SQL能做什么 SQL语句 SQL语句后面的分号 SQL DML和DDL SQL SELECT 语法 SQL SELECT 实例 SQL WHERE 语法
4 76浏览
会员免费 - 郑州大学数据库期末试题郑州大学数据期末试题
2 806浏览
会员免费 - sqlserver利用linkserver链接oracle操作手册sqlserver利用linkserver链接oracle操作手册
5 560浏览
会员免费 - SSIS简明教程这个指南主要包含了SSIS的一些基础知识、技巧,希望可以帮助到你
0 525浏览
会员免费 - MFC实现SQL数据库ADO连接(适合菜鸟)帮助菜鸟轻松学习MFC 连接SQL,不要为没有资源而感到迷茫。 这是一篇简单化的文章,适合我们这些菜鸟共同探讨学习耶!!!
0 379浏览
会员免费 - SQL server 2000使用4G以上的内存在安装了Windows Server 2003 32位企业版,安装了SQL Server 2000 SP4企业版。发现SQLServer.exe只使用了1.7G内存,介绍使用到4G以上内存设置方法。
5 209浏览
会员免费 - 基于数据仓库的房地产数据分析系统基于数据仓库的房地产数据分析系统
0 398浏览
会员免费 - SQL Server 2012 深入解析与性能优化 第3版(有书签版)SQL Server、SQL Server 2012 进行深入解析与性能优化 做了书签
5 174浏览
会员免费