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.展开更多
This research paper has provided the methodology and design for implementing the hybrid author recommender system using Azure Data Lake Analytics and Power BI. It offers a recommendation for the top 1000 Authors of co...This research paper has provided the methodology and design for implementing the hybrid author recommender system using Azure Data Lake Analytics and Power BI. It offers a recommendation for the top 1000 Authors of computer science in different fields of study. The technique used in this paper is handling the inadequate Information for citation;it removes the problem of cold start, which is encountered by very many other recommender systems. In this paper, abstracts, the titles, and the Microsoft academic graphs have been used in coming up with the recommendation list for every document, which is used to combine the content-based approaches and the co-citations. Prioritization and the blending of every technique have been allowed by the tuning system parameters, allowing for the authority in results of recommendation versus the paper novelty. In the end, we do observe that there is a direct correlation between the similarity rankings that have been produced by the system and the scores of the participant. The results coming from the associated scrips of analysis and the user survey have been made available through the recommendation system. Managers must gain the required expertise to fully utilize the benefits that come with business intelligence systems [1]. Data mining has become an important tool for managers that provides insights about their daily operations and leverage the information provided by decision support systems to improve customer relationships [2]. Additionally, managers require business intelligence systems that can rank the output in the order of priority. Ranking algorithm can replace the traditional data mining algorithms that will be discussed in-depth in the literature review [3].展开更多
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.展开更多
PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored program units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity ...PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored program units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an interface between SQL database and DEVELOPER. Therefore, it is important to test these modules that consist of procedures and functions. In this paper, a new genetic algorithm (GA), as search technique, is used in order to find the required test data according to branch criteria to test stored PL/SQL program units. The experimental results show that this was not fully achieved, such that the test target in some branches is not reached and the coverage percentage is 98%. A problem rises when target branch is depending on data retrieved from tables;in this case, GA is not able to generate test cases for this branch.展开更多
Building the new countryside construction database plays an important role in improving the construction efficiency,and enhancing the level of major project management.On the basis of detailed analysis of features of ...Building the new countryside construction database plays an important role in improving the construction efficiency,and enhancing the level of major project management.On the basis of detailed analysis of features of the new countryside construction data,we give an overview of the database design based on ArcSDE and SQL Server,and elaborate the association between data classification organization,database conceptual design,logical design,spatial data,and thematic attribute data.Finally,taking the provincial new countryside demonstration zone in Yanjiang District of Sichuan Province for example,we build the new countryside construction database.展开更多
提高数据挖掘的效率是目前信息技术研究的热点问题之一。介绍了数据挖掘的概念、过程模型以及体系结构,讨论了基于Microsoft SQL Server 2005的数据挖掘方案和采用SQL Server分析服务实现数据挖掘的相关技术。采用SQLServer分析服务的...提高数据挖掘的效率是目前信息技术研究的热点问题之一。介绍了数据挖掘的概念、过程模型以及体系结构,讨论了基于Microsoft SQL Server 2005的数据挖掘方案和采用SQL Server分析服务实现数据挖掘的相关技术。采用SQLServer分析服务的数据挖掘,实现了数据挖掘、数据仓库与应用程序的紧密耦合,从而大大提高了数据挖掘的效率。展开更多
数据库实现是当前STEP数据模型实现数据交换的较优方法。研究STEP数据模型在关系数据库SQL Server上的映射,介绍数据字典的建立,详细阐述EXPRESS数据模式向SQL Server 2000转换的规则和方法,并给出一个具体的应用实例。结果表明,在关系...数据库实现是当前STEP数据模型实现数据交换的较优方法。研究STEP数据模型在关系数据库SQL Server上的映射,介绍数据字典的建立,详细阐述EXPRESS数据模式向SQL Server 2000转换的规则和方法,并给出一个具体的应用实例。结果表明,在关系数据库SQL Server上实现STEP数据模型的映射是可行的。展开更多
文摘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.
文摘This research paper has provided the methodology and design for implementing the hybrid author recommender system using Azure Data Lake Analytics and Power BI. It offers a recommendation for the top 1000 Authors of computer science in different fields of study. The technique used in this paper is handling the inadequate Information for citation;it removes the problem of cold start, which is encountered by very many other recommender systems. In this paper, abstracts, the titles, and the Microsoft academic graphs have been used in coming up with the recommendation list for every document, which is used to combine the content-based approaches and the co-citations. Prioritization and the blending of every technique have been allowed by the tuning system parameters, allowing for the authority in results of recommendation versus the paper novelty. In the end, we do observe that there is a direct correlation between the similarity rankings that have been produced by the system and the scores of the participant. The results coming from the associated scrips of analysis and the user survey have been made available through the recommendation system. Managers must gain the required expertise to fully utilize the benefits that come with business intelligence systems [1]. Data mining has become an important tool for managers that provides insights about their daily operations and leverage the information provided by decision support systems to improve customer relationships [2]. Additionally, managers require business intelligence systems that can rank the output in the order of priority. Ranking algorithm can replace the traditional data mining algorithms that will be discussed in-depth in the literature review [3].
文摘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.
文摘PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored program units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an interface between SQL database and DEVELOPER. Therefore, it is important to test these modules that consist of procedures and functions. In this paper, a new genetic algorithm (GA), as search technique, is used in order to find the required test data according to branch criteria to test stored PL/SQL program units. The experimental results show that this was not fully achieved, such that the test target in some branches is not reached and the coverage percentage is 98%. A problem rises when target branch is depending on data retrieved from tables;in this case, GA is not able to generate test cases for this branch.
基金Supported by Fundamental Research Project of Sichuan Provincial Department of Finance in 2012
文摘Building the new countryside construction database plays an important role in improving the construction efficiency,and enhancing the level of major project management.On the basis of detailed analysis of features of the new countryside construction data,we give an overview of the database design based on ArcSDE and SQL Server,and elaborate the association between data classification organization,database conceptual design,logical design,spatial data,and thematic attribute data.Finally,taking the provincial new countryside demonstration zone in Yanjiang District of Sichuan Province for example,we build the new countryside construction database.
文摘提高数据挖掘的效率是目前信息技术研究的热点问题之一。介绍了数据挖掘的概念、过程模型以及体系结构,讨论了基于Microsoft SQL Server 2005的数据挖掘方案和采用SQL Server分析服务实现数据挖掘的相关技术。采用SQLServer分析服务的数据挖掘,实现了数据挖掘、数据仓库与应用程序的紧密耦合,从而大大提高了数据挖掘的效率。
文摘数据库实现是当前STEP数据模型实现数据交换的较优方法。研究STEP数据模型在关系数据库SQL Server上的映射,介绍数据字典的建立,详细阐述EXPRESS数据模式向SQL Server 2000转换的规则和方法,并给出一个具体的应用实例。结果表明,在关系数据库SQL Server上实现STEP数据模型的映射是可行的。
