This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format. There is a great am...This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format. There is a great amount of work done regarding comparison of multiple database management applications on the basis of their performances, security etc., but we have limited information available where these databases are assessed on the basis of provided data. This study will mainly focus on looking at all the possibilities that both these database types offer us when handling data in JSON. We will accomplish this by implementing a series of experiments while taking into consideration that the subjected data does not require to be normalized;and therefore, evaluate the outcome to conclude the result.展开更多
In this paper, we research on the research on the mass structured data storage and sorting algorithm and methodology for SQL database under the big data environment. With the data storage market development and center...In this paper, we research on the research on the mass structured data storage and sorting algorithm and methodology for SQL database under the big data environment. With the data storage market development and centering on the server, the data will store model to data- centric data storage model. Storage is considered from the start, just keep a series of data, for the management system and storage device rarely consider the intrinsic value of the stored data. The prosperity of the Internet has changed the world data storage, and with the emergence of many new applications. Theoretically, the proposed algorithm has the ability of dealing with massive data and numerically, the algorithm could enhance the processing accuracy and speed which will be meaningful.展开更多
Data-Base Management System (DBMS) is the current standard for storing information. A DBMS organizes and maintains a structure of storage of data. Databases make it possible to store vast amounts of randomly created i...Data-Base Management System (DBMS) is the current standard for storing information. A DBMS organizes and maintains a structure of storage of data. Databases make it possible to store vast amounts of randomly created information and then retrieve items using associative reasoning in search routines. However, design of databases is cumbersome. If one is to use a database primarily to directly input information, each field must be predefined manually, and the fields must be organized to permit coherent data input. This static requirement is problematic and requires that database table(s) be predefined and customized at the outset, a difficult proposition since current DBMS lack a user friendly front end to allow flexible design of the input model. Furthermore, databases are primarily text based, making it difficult to process graphical data. We have developed a general and nonproprietary approach to the problem of input modeling designed to make use of the known informational architecture to map data to a database and then retrieve the original document in freely editable form. We create form templates using ordinary word processing software: Microsoft InfoPath 2007. Each field in the form is given a unique name identifier in order to be distinguished in the database. It is possible to export text based documents created initially in Microsoft Word by placing a colon at the beginning of any desired field location. InfoPath then captures the preceding string and uses it as the label for the field. Each form can be structured in a way to include any combination of both textual and graphical fields. We input data into InfoPath templates. We then submit the data through a web service to populate fields in an SQL database. By appropriate indexing, we can then recall the entire document from the SQL database for editing, with corresponding audit trail. Graphical data is handled no differently than textual data and is embedded in the database itself permitting direct query approaches. This technique makes it possible for general users to benefit from a combined text-graphical database environment with a flexible non-proprietary interface. Consequently, any template can be effortlessly transformed to a database system and easily recovered in a narrative form.展开更多
The remote data collection system based on SOL Server database technology was developed by Visual C++and SQL Server database technology together.The Client/Server mode was adopted.The system adopted the database searc...The remote data collection system based on SOL Server database technology was developed by Visual C++and SQL Server database technology together.The Client/Server mode was adopted.The system adopted the database search technologi- cal-ADO to work out the communication procedure of the server.And the old data of corresponding memory units were upgraded by the new data which gathered from PLC through serial port real time in the database.The Client utilizes the network technology and database technology through queries procedure to access the data information in the database.Thus a large number of relevant data that the production line operated were obtained.The goal of understanding operation conditions of product line was achieved through analysis of these data.This system has been debugged by the experiment successfully.展开更多
基于SQL Server Analysis Services(简称SSAS)提供的Microsoft关联规则挖掘算法和事务数据挖掘功能,通过利用Arc GIS软件、空间数据库引擎Arc SDE和数据库SQL Server软件,提出了一种新的土地地类关系挖掘实现方案。首先结合空间数据挖掘...基于SQL Server Analysis Services(简称SSAS)提供的Microsoft关联规则挖掘算法和事务数据挖掘功能,通过利用Arc GIS软件、空间数据库引擎Arc SDE和数据库SQL Server软件,提出了一种新的土地地类关系挖掘实现方案。首先结合空间数据挖掘(Spatial Data Mining,SDM)相关技术方法,以土地利用数据库为基础,实现空间数据提取;然后通过空间关联操作将空间信息转化为事务,最后在SSAS中创建多维数据集,完成相关数据挖掘任务。基于某市实例土地利用数据库,采用该方法探测相邻地类间的隐含关系,通过建立相邻地类图斑空间关联规则挖掘模型,设置不同的参数,得到了一系列比较实用合理的关联规则,通过实践证明了这种方案的有效性。展开更多
介绍了在以Delphi 7.0作为前台开发工具,SQL Server 2000作为后台服务器开发数据库过程中,JPEG格式图像数据存储和读取显示的两种方法,即内存流法和路径链接法。使用内存流法可以减少磁盘操作,更易于数据库的维护和管理,还可提高数据的...介绍了在以Delphi 7.0作为前台开发工具,SQL Server 2000作为后台服务器开发数据库过程中,JPEG格式图像数据存储和读取显示的两种方法,即内存流法和路径链接法。使用内存流法可以减少磁盘操作,更易于数据库的维护和管理,还可提高数据的安全性;使用路径链接法加快了数据库的检索速度和图像数据传输速度,极大地扩展了图像数据库的信息量。这两种方法对于图像数据库的应用开发有着重要意义。展开更多
为解决传统的关系型数据库在海量数据的存储和访问效率中存在的瓶颈问题,提出了一种基于非关系型(NoSQL:Not only SQL)数据库的地学大数据高效存储方法。同时以MongoDB为代表,通过C#语言编写测试程序,与SQL Server在地学大数据的存储、...为解决传统的关系型数据库在海量数据的存储和访问效率中存在的瓶颈问题,提出了一种基于非关系型(NoSQL:Not only SQL)数据库的地学大数据高效存储方法。同时以MongoDB为代表,通过C#语言编写测试程序,与SQL Server在地学大数据的存储、查询等方面进行了性能对比。结果表明,与传统关系型数据库相比,NoSQL数据库的增、删和查询耗时明显降低,尤其是针对海量的非结构化、半结构化数据,其性能优势更加明显。展开更多
SQL Server Mobile为移动设备和嵌入式设备提供了一个压缩的数据库解决方案。通过使用Microsoft VisualStudio工具,开发者可以将SQL Server的数据库管理能力扩展到移动设备上。介绍了在基于WINCE的移动设备上开发SQL Server Mobile数据...SQL Server Mobile为移动设备和嵌入式设备提供了一个压缩的数据库解决方案。通过使用Microsoft VisualStudio工具,开发者可以将SQL Server的数据库管理能力扩展到移动设备上。介绍了在基于WINCE的移动设备上开发SQL Server Mobile数据库的方法。并结合多媒体词典数据库的开发,详细分析了在系统开发中涉及的几项关键技术,对于嵌入式移动数据库的开发具有一定的参考价值。展开更多
文摘This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format. There is a great amount of work done regarding comparison of multiple database management applications on the basis of their performances, security etc., but we have limited information available where these databases are assessed on the basis of provided data. This study will mainly focus on looking at all the possibilities that both these database types offer us when handling data in JSON. We will accomplish this by implementing a series of experiments while taking into consideration that the subjected data does not require to be normalized;and therefore, evaluate the outcome to conclude the result.
文摘In this paper, we research on the research on the mass structured data storage and sorting algorithm and methodology for SQL database under the big data environment. With the data storage market development and centering on the server, the data will store model to data- centric data storage model. Storage is considered from the start, just keep a series of data, for the management system and storage device rarely consider the intrinsic value of the stored data. The prosperity of the Internet has changed the world data storage, and with the emergence of many new applications. Theoretically, the proposed algorithm has the ability of dealing with massive data and numerically, the algorithm could enhance the processing accuracy and speed which will be meaningful.
文摘Data-Base Management System (DBMS) is the current standard for storing information. A DBMS organizes and maintains a structure of storage of data. Databases make it possible to store vast amounts of randomly created information and then retrieve items using associative reasoning in search routines. However, design of databases is cumbersome. If one is to use a database primarily to directly input information, each field must be predefined manually, and the fields must be organized to permit coherent data input. This static requirement is problematic and requires that database table(s) be predefined and customized at the outset, a difficult proposition since current DBMS lack a user friendly front end to allow flexible design of the input model. Furthermore, databases are primarily text based, making it difficult to process graphical data. We have developed a general and nonproprietary approach to the problem of input modeling designed to make use of the known informational architecture to map data to a database and then retrieve the original document in freely editable form. We create form templates using ordinary word processing software: Microsoft InfoPath 2007. Each field in the form is given a unique name identifier in order to be distinguished in the database. It is possible to export text based documents created initially in Microsoft Word by placing a colon at the beginning of any desired field location. InfoPath then captures the preceding string and uses it as the label for the field. Each form can be structured in a way to include any combination of both textual and graphical fields. We input data into InfoPath templates. We then submit the data through a web service to populate fields in an SQL database. By appropriate indexing, we can then recall the entire document from the SQL database for editing, with corresponding audit trail. Graphical data is handled no differently than textual data and is embedded in the database itself permitting direct query approaches. This technique makes it possible for general users to benefit from a combined text-graphical database environment with a flexible non-proprietary interface. Consequently, any template can be effortlessly transformed to a database system and easily recovered in a narrative form.
文摘The remote data collection system based on SOL Server database technology was developed by Visual C++and SQL Server database technology together.The Client/Server mode was adopted.The system adopted the database search technologi- cal-ADO to work out the communication procedure of the server.And the old data of corresponding memory units were upgraded by the new data which gathered from PLC through serial port real time in the database.The Client utilizes the network technology and database technology through queries procedure to access the data information in the database.Thus a large number of relevant data that the production line operated were obtained.The goal of understanding operation conditions of product line was achieved through analysis of these data.This system has been debugged by the experiment successfully.
文摘基于SQL Server Analysis Services(简称SSAS)提供的Microsoft关联规则挖掘算法和事务数据挖掘功能,通过利用Arc GIS软件、空间数据库引擎Arc SDE和数据库SQL Server软件,提出了一种新的土地地类关系挖掘实现方案。首先结合空间数据挖掘(Spatial Data Mining,SDM)相关技术方法,以土地利用数据库为基础,实现空间数据提取;然后通过空间关联操作将空间信息转化为事务,最后在SSAS中创建多维数据集,完成相关数据挖掘任务。基于某市实例土地利用数据库,采用该方法探测相邻地类间的隐含关系,通过建立相邻地类图斑空间关联规则挖掘模型,设置不同的参数,得到了一系列比较实用合理的关联规则,通过实践证明了这种方案的有效性。
文摘介绍了在以Delphi 7.0作为前台开发工具,SQL Server 2000作为后台服务器开发数据库过程中,JPEG格式图像数据存储和读取显示的两种方法,即内存流法和路径链接法。使用内存流法可以减少磁盘操作,更易于数据库的维护和管理,还可提高数据的安全性;使用路径链接法加快了数据库的检索速度和图像数据传输速度,极大地扩展了图像数据库的信息量。这两种方法对于图像数据库的应用开发有着重要意义。
文摘为解决传统的关系型数据库在海量数据的存储和访问效率中存在的瓶颈问题,提出了一种基于非关系型(NoSQL:Not only SQL)数据库的地学大数据高效存储方法。同时以MongoDB为代表,通过C#语言编写测试程序,与SQL Server在地学大数据的存储、查询等方面进行了性能对比。结果表明,与传统关系型数据库相比,NoSQL数据库的增、删和查询耗时明显降低,尤其是针对海量的非结构化、半结构化数据,其性能优势更加明显。
文摘SQL Server Mobile为移动设备和嵌入式设备提供了一个压缩的数据库解决方案。通过使用Microsoft VisualStudio工具,开发者可以将SQL Server的数据库管理能力扩展到移动设备上。介绍了在基于WINCE的移动设备上开发SQL Server Mobile数据库的方法。并结合多媒体词典数据库的开发,详细分析了在系统开发中涉及的几项关键技术,对于嵌入式移动数据库的开发具有一定的参考价值。
