This study evaluates mechanisms to secure relational databases against security vulnerabilities and utilized Postgresql and microsoft sql server due to data breach incidences reported across the world. Emulation exper...
详细信息
This study evaluates mechanisms to secure relational databases against security vulnerabilities and utilized Postgresql and microsoft sql server due to data breach incidences reported across the world. Emulation experiments with documentary review were employed to collect necessary study data. Identification of security features and vulnerabilities that are found to affect the data tier of the web applications were examined. The findings from the study have shown that microsoft sql server is more security feature-rich in terms of Confidentiality, Integrity, and Availability compared to Postgresql and microsoft sql server is more resilient to security attacks in its default behavior compared to Postgresql.
In this paper we present a system intended for content-based image retrieval tightly integrated with a relational database management system. Users can send query images over the appropriate web service channel or con...
详细信息
ISBN:
(纸本)9783319393841
In this paper we present a system intended for content-based image retrieval tightly integrated with a relational database management system. Users can send query images over the appropriate web service channel or construct database queries locally. The presented framework analyses the query image based on descriptors which are generated by the bag-of-features algorithm and local interest points. The system returns the sequence of similar images with a similarity level to the query image. The software was implemented in. NET technology and microsoft sql server 2012. The modular construction allows to customize the system functionality to client needs but it is especially dedicated to business applications. Important advantage of the presented approach is the support by SOA (Service-Oriented Architecture), which allows to use the system in a remote way. It is possible to build software which uses functions of the presented system by communicating over the web service API with the WCF technology.
microsoft sql server PowerPivot for Excel, or PowerPivot for short, is an in-memory business intelligence (BI) engine that enables Excel users to interactively create pivot tables over large data sets imported from so...
详细信息
microsoft sql server PowerPivot for Excel, or PowerPivot for short, is an in-memory business intelligence (BI) engine that enables Excel users to interactively create pivot tables over large data sets imported from sources such as relational databases, text files and web data feeds. Unlike traditional pivot tables in Excel that are defined on a single table, PowerPivot allows analysis over multiple tables connected via foreign-key joins. In many cases however, these foreign-key relationships are not known a priori, and information workers are often not be sophisticated enough to define these relationships. Therefore, the ability to automatically discover foreign-key relationships in PowerPivot is valuable, if not essential. The key challenge is to perform this detection interactively and with high precision even when data sets scale to hundreds of millions of rows and the schema contains tens of tables and hundreds of columns. In this paper, we describe techniques for fast foreign-key detection in PowerPivot and experimentally evaluate its accuracy, performance and scale on both synthetic benchmarks and real-world data sets. These techniques have been incorporated into PowerPivot for Excel.
Students practice Data Query, Manipulation, and Definition Language statements in a standard introductory relational database course. When teaching large classes, the teacher needs to review many student solutions. Do...
详细信息
ISBN:
(纸本)9798400705311
Students practice Data Query, Manipulation, and Definition Language statements in a standard introductory relational database course. When teaching large classes, the teacher needs to review many student solutions. Doing it by hand is laborious. However, this task can be quickly and accurately completed using a learning management system (LMS). Moodle is a widely used LMS that can be enhanced with the CodeRunner plugin to facilitate the evaluation of programming tasks. Unfortunately, a basic setup supports only the embedded database engine sqlite, which often is not the preferred choice for a course of this type. We present an open-source implementation that extends CodeRunner with popular client-server database engines, i.e., microsoft sql server, Mysql, and Postgresql. Our method checks the correctness of a student's query in terms of output and validates the query by investigating the parse tree derived from the grammar of a given Structured Query Language (sql) dialect. We present the system's evaluation results during a database course along with the implementation.
Data security is being one of the most crucial aspects to be focused on system development. However, using such a feature to enhance the security of data might affect the system's performance. This study aims to o...
详细信息
Data security is being one of the most crucial aspects to be focused on system development. However, using such a feature to enhance the security of data might affect the system's performance. This study aims to observe how substantial Transparent Data Encryption as a solution for data security on microsoft sql server will affect the database management system's performance. Each of the system performance is conducted with stress and load test. This paper concentrates on the upsides of using Transparent Data Encryption over standard database by finding how significant performance degradation has occurred in terms of Reliability and Efficiency.
Testing of newly programmed components is an integral part of software development. Data Generator for microsoft sql server is a tool for simple populating database tables with testing data which allows efficient data...
详细信息
Testing of newly programmed components is an integral part of software development. Data Generator for microsoft sql server is a tool for simple populating database tables with testing data which allows efficient database component testing for programmers, administrators and other database developers. Generated data can be structured using the parameters which are set in a simple user interface. Generated data correspond with database schema and constraints defined on columns. In following text we are going to describe the architecture and implementation details together with the necessary theoretical knowledge.
This paper presents a comparative study between on-premises databases and cloud databases regarding the response time of the database. It focuses on presenting the advantages of storing data and applications in the cl...
详细信息
This paper presents a comparative study between on-premises databases and cloud databases regarding the response time of the database. It focuses on presenting the advantages of storing data and applications in the cloud and, of course, on managing it in comparison with managing the same data and applications locally on one or more physical machines. A microsoft Azure account was created to manage the database that is stored in the cloud. To achieve comparative results, a specific testing architecture that uses a Universal Windows Platform app was created and used. The application is running locally on multiple physical machines and works with that database to extract data, operate, and upload new data. For local tests, the database was stored locally on a server, with and without replication, and for cloud tests, it was stored into a server in Central US. This paper provides a practical approach that could be used for examining the performance of basic database operations when dealing with a different number of user situations. As a result of tests carried out, we will highlight the many advantages of cloud data storage, such as data accessibility, speed, security, automation, and disaster recovery, and we will also try to offer an answer to the most common and important question: "Why cloud?"
The purpose of this article is to explore the steps and methods of performing examination analysis by microsoft Structured Query Language(sql) server database and compare the analytical effect with other two usually u...
详细信息
The purpose of this article is to explore the steps and methods of performing examination analysis by microsoft Structured Query Language(sql) server database and compare the analytical effect with other two usually used *** steps of examination analysis include creating database tables,importing data,editing sql scripts,calculating indicators,exporting analytical *** examination evaluation indicator consists of the difficulty index,degree of differentiate,reliability index,validity,and the standard *** part of the main program code was *** a practical example of examination analysis,the advantages of analysis paper quality using microsoft sql server are described.
暂无评论