Max Indelicato曾发表过一篇文章《NoSQL on the Microsoft Platform 从可查询的分布式解决方案，如MongoDB，到简单的分布式Key/Value存储解决方案，如Cassandra。此外，还有Riak，Tokyo Cabinet，Voldemort，CouchDB和Redis。但目前仅有少量的NoSQL项目支持
Max Indelicato曾发表过一篇文章《NoSQL on the Microsoft Platform
从可查询的分布式解决方案，如MongoDB，到简单的分布式Key/Value存储解决方案，如Cassandra。此外，还有Riak，Tokyo Cabinet，Voldemort，CouchDB和Redis。但目前仅有少量的NoSQL项目支持在Windows平台上运行，如果要说到生产应用那就更少了。
Memcached
Memcached传统上认为它不属于NoSQL的范畴，而是一个分布式Key/Value内存缓存解决方案，它可以用来存储各种各样的临时数据集，存储方式和其它NoSQL数据库解决方案没有什么差别。
NorthScale提供了适合于32位和64位Windows平台的Memcached程序包，可从这里免费下载。
MongoDB
MongoDB是一个基于文档（JSON风格）的数据存储引擎，通过它的自动分片功能可实现良好的水平扩展能力，它使用了一个简单但功能很强大的基于JavaScript/JSON的查询语言，提供了快速插入和更新能力，主要归功于它的低开销原子修改程序。此外，使用Map/Reduce实现了跨多个MongoDB数据库聚合和数据处理。
MongoDB背后的10Gen公司前不久正式宣布了对Windows平台的支持。MongoDB目前的最新版本是1.6.0，许多大型Web站点现在都在使用它。关于MongoDB Windows版本的更多信息请移步这里，对应的版本可从这里下载。
sones GraphDB
sones GraphDB是一个企业图形数据存储引擎，它使用C#语言开发，并且是开源的，对于非商业目的可以免费下载，但如果用于商业目的则需要购买商业许可。
图形数据库和我们常说的NoSQL数据库存储方式是不同的，它们更善于处理一类特定的问题：数据集包含了大量的关系，需要快速高效地遍历这些关系。
图形数据库一个常见的用例就是用来存储社交关系或社交图，通常，这些社交图由许多节点组成，节点之间存在许多独立的关系，这是传统关系数据库很难处理好的问题域。如果你对sones GraphDB感兴趣，可从这里下载它的源代码，更多信息请访问该项目的官方网站。
Voldemort
Voldemort是一个分布式Key/Value存储系统，LinkedIn用它解决了网站的高扩展性存储问题，简单的分区功能已经不能满足LinkedIn的需要。Voldemort使用Java编写，因此借助Java的跨平台特性，它也可以运行在Windows平台上。请阅读这篇文章了解如何在Windows平台上安装Voldemort。
NoSQL项目机会
对于Microsoft世界来说这是一个激动人心的时刻，但目前Microsoft阵营采用NoSQL的节奏还非常慢，因对机会也比较多，如果能开发出优秀的NoSQL托管存储解决方案，一定会很受欢迎。
ESENT分布式数据存储
关于ESENT，我能想到最恰当的比喻是，它是Microsoft世界的BerkeleyDB，鲜为人知，很少有.NET开发人员使用它，但它的性能和可靠性已经经受住了时间的考验。
ESENT是一个原生支持Windows的嵌入式数据库引擎，它是CodePlex上的一个托管项目，最新的Windows版本已经内置了esent.dll。
我做了一些测试，它的速度真是太快了，每秒可以执行大约10万次插入操作，够变态吧。关于性能的更多统计数字请看这里。
内存字典式分布式数据存储
内存字典式分布式数据存储和ESENT有点类似，但不同的是它的数据完全存储在内存中。他可以作为分布式缓存的基础，也可以跨一系列节点复制数据而实现持久化，任何时间只要有一个节点可用，数据都是可以访问的，Amazon或其它基于云的非持久化服务器解决方案可以完美地实现托管，我是这种解决方案的坚决支持者。
最后的想法
对.NET开发人员来说，使用NoSQL解决方案目前还有一些限制，但随时间的推移，肯定会有越来越多的NoSQL解决方案可供选择，作为一名.NET开发人员，我们也应该参与到这些项目中去，以期早日解决现在存在的问题，这也是.NET开发人员的一次难得的机会。
我认为能给Microsoft阵营介绍NoSQL解决方案是一件非常兴奋的事，以后我也将努力参与到这些项目中去，如果你也愿意成为一名志愿者，我们随时欢迎你。
【人物小传】
Max Indelicato
Max Indelicato
Stride & Associates公司基础架构和软件开发主管。
Max曾在很多公司工作过，包括创业公司、成长型商业公司及刚成立的企业。他担任过核心架构师、技术主管以及此类的职务。 他曾创建并维护了手机交易平台、高扩展性的面向公众的电子商务网站及一系列可以支持固定收益有价证券财务实体的金融应用软件。
http://www.dotnetconvo.com/post/view/2010/8/9/nosql-on-the-microsoft-platform
译文链接：http://database.51cto.com/art/201008/219470.htm
What are stored procedures in MySQL?May 01, 2025 am 12:27 AMStored procedures are precompiled SQL statements in MySQL for improving performance and simplifying complex operations. 1. Improve performance: After the first compilation, subsequent calls do not need to be recompiled. 2. Improve security: Restrict data table access through permission control. 3. Simplify complex operations: combine multiple SQL statements to simplify application layer logic.
How does query caching work in MySQL?May 01, 2025 am 12:26 AMThe working principle of MySQL query cache is to store the results of SELECT query, and when the same query is executed again, the cached results are directly returned. 1) Query cache improves database reading performance and finds cached results through hash values. 2) Simple configuration, set query_cache_type and query_cache_size in MySQL configuration file. 3) Use the SQL_NO_CACHE keyword to disable the cache of specific queries. 4) In high-frequency update environments, query cache may cause performance bottlenecks and needs to be optimized for use through monitoring and adjustment of parameters.
What are the advantages of using MySQL over other relational databases?May 01, 2025 am 12:18 AMThe reasons why MySQL is widely used in various projects include: 1. High performance and scalability, supporting multiple storage engines; 2. Easy to use and maintain, simple configuration and rich tools; 3. Rich ecosystem, attracting a large number of community and third-party tool support; 4. Cross-platform support, suitable for multiple operating systems.
How do you handle database upgrades in MySQL?Apr 30, 2025 am 12:28 AMThe steps for upgrading MySQL database include: 1. Backup the database, 2. Stop the current MySQL service, 3. Install the new version of MySQL, 4. Start the new version of MySQL service, 5. Recover the database. Compatibility issues are required during the upgrade process, and advanced tools such as PerconaToolkit can be used for testing and optimization.
What are the different backup strategies you can use for MySQL?Apr 30, 2025 am 12:28 AMMySQL backup policies include logical backup, physical backup, incremental backup, replication-based backup, and cloud backup. 1. Logical backup uses mysqldump to export database structure and data, which is suitable for small databases and version migrations. 2. Physical backups are fast and comprehensive by copying data files, but require database consistency. 3. Incremental backup uses binary logging to record changes, which is suitable for large databases. 4. Replication-based backup reduces the impact on the production system by backing up from the server. 5. Cloud backups such as AmazonRDS provide automation solutions, but costs and control need to be considered. When selecting a policy, database size, downtime tolerance, recovery time, and recovery point goals should be considered.
What is MySQL clustering?Apr 30, 2025 am 12:28 AMMySQLclusteringenhancesdatabaserobustnessandscalabilitybydistributingdataacrossmultiplenodes.ItusestheNDBenginefordatareplicationandfaulttolerance,ensuringhighavailability.Setupinvolvesconfiguringmanagement,data,andSQLnodes,withcarefulmonitoringandpe
How do you optimize database schema design for performance in MySQL?Apr 30, 2025 am 12:27 AMOptimizing database schema design in MySQL can improve performance through the following steps: 1. Index optimization: Create indexes on common query columns, balancing the overhead of query and inserting updates. 2. Table structure optimization: Reduce data redundancy through normalization or anti-normalization and improve access efficiency. 3. Data type selection: Use appropriate data types, such as INT instead of VARCHAR, to reduce storage space. 4. Partitioning and sub-table: For large data volumes, use partitioning and sub-table to disperse data to improve query and maintenance efficiency.
How can you optimize MySQL performance?Apr 30, 2025 am 12:26 AMTooptimizeMySQLperformance,followthesesteps:1)Implementproperindexingtospeedupqueries,2)UseEXPLAINtoanalyzeandoptimizequeryperformance,3)Adjustserverconfigurationsettingslikeinnodb_buffer_pool_sizeandmax_connections,4)Usepartitioningforlargetablestoi
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
Notepad++7.3.1
Easy-to-use and free code editor
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
Dreamweaver CS6
Visual web development tools
