distributed database query optimization is very important in business field. This paper proposes an optimization based on genetic algorithm and immune theory. distributed database query is optimized by genetic coding ...
详细信息
distributed database query optimization is very important in business field. This paper proposes an optimization based on genetic algorithm and immune theory. distributed database query is optimized by genetic coding and immune vaccine construction. Then, through the experimental data test, it proves that the algorithm has 13% higher efficiency than the standard genetic algorithm, which shows that the algorithm has better performance.
This paper proposes a distributed data clustering technique based on deep neural network. First, each record in the distributed database is taken as an input vector, and its characteristics are extracted and input to ...
详细信息
This paper proposes a distributed data clustering technique based on deep neural network. First, each record in the distributed database is taken as an input vector, and its characteristics are extracted and input to the input layer of the depth neural network. The weight of the connection is trained by BP algorithm, and the training of depth neural network output is realized by adjusting the weight. Finally, the data clustering results are judged according to the similarity of the current vector corresponding to the output data. Experimental results based on small-scale distributed systems show that this method has better test set accuracy than traditional k-means clustering method, and is more suitable for large-scale data clustering in the distributed environments.
Shared-nothing architecture has been widely used in distributed databases to achieve good scalability. While it offers superior performance for local transactions, the overhead of processing distributed transactions c...
详细信息
ISBN:
(纸本)9781450335317
Shared-nothing architecture has been widely used in distributed databases to achieve good scalability. While it offers superior performance for local transactions, the overhead of processing distributed transactions can degrade the system performance significantly. The key contributor to the degradation is the expensive two-phase commit (2PC) protocol used to ensure atomic commitment of distributed transactions. In this paper, we propose a transaction management scheme called LEAP to avoid the 2PC protocol within distributed transaction processing. Instead of processing a distributed transaction across multiple nodes, LEAP converts the distributed transaction into a local transaction. This benefits the processing locality and facilitates adaptive data repartitioning when there is a change in data access pattern. Based on LEAP, we develop an online transaction processing (OLTP) system, L-Store, and compare it with the state-of-the-art distributed in-memory OLTP system, H-Store, which relies on the 2PC protocol for distributed transaction processing, and HL-Store, a H-Store that has been modified to make use of LEAP. Results of an extensive experimental evaluation show that our LEAP-based engines are superior over H-Store by a wide margin, especially for workloads that exhibit locality-based data accesses.
Concurrency manipulates the control of concurrent transaction execution. distributed database management system enforce concurrency manipulate to make sure serializability and isolation of transaction. Lots of researc...
详细信息
ISBN:
(纸本)9781467366809;9781467366793
Concurrency manipulates the control of concurrent transaction execution. distributed database management system enforce concurrency manipulate to make sure serializability and isolation of transaction. Lots of research has been done on this area and a number of algorithms have been purposed. In this article, we are comparing few algorithms for preserving the ACID property (atomicity, consistency, isolation, and durability) of transactions in DDBMS.
This paper proposes an intelligent microgrid energy management system (iEMS). It aims to develop and demonstrate an intelligent system at campus site through seamless integration of energy generation, storage and dema...
详细信息
ISBN:
(纸本)9781467388450
This paper proposes an intelligent microgrid energy management system (iEMS). It aims to develop and demonstrate an intelligent system at campus site through seamless integration of energy generation, storage and demand management facilities across the electric, thermal, and gas networks. This system will also have an enhanced information and communication technology (ICT) platform for supply and demand management as well as real-time energy market interactions. The major innovations proposed by the iEMS encompass advanced ICT tools such as forecasting, predictive modelling for harmonization of multi-energy grids and enabling real-time energy market interactions for maximizing cost savings without compromising operational effectiveness and grid stability. These innovations serve to either enhance system level energy savings or facilitate system integration by using advanced distributed database system and protocols such as IEEE 1888 for communication and control.
The existing distributed database is mainly based on the limited scale network environment. Many systems implement algorithms are difficult to apply when it needs to be expanded or involved into the field of distribut...
详细信息
The existing distributed database is mainly based on the limited scale network environment. Many systems implement algorithms are difficult to apply when it needs to be expanded or involved into the field of distributed query processing, distributed transaction processing and data replication. In this paper, one real-time transaction management architecture and its details are proposed to improve the efficacy of SQL processing based on distributed database system. The seven primary functional models in the server cluster part and four functional models in the distributed database part are designed to enhance the query function such as insert or update in our network environment. The experiments and results proved that our method is more efficient than traditional methods.
The Internet will become to the Internet of Things (IoT). It provides connectivity for everyone and everything that embeds some intelligence in Internet-connected objects to communicate, exchange information, take dec...
详细信息
ISBN:
(纸本)9781509011254
The Internet will become to the Internet of Things (IoT). It provides connectivity for everyone and everything that embeds some intelligence in Internet-connected objects to communicate, exchange information, take decisions, invoke actions and provide amazing services. This will bring a new ubiquitous computing and communication era and change people's lives (drastically/entirely). Moreover, the most important component in IoT is database that used for collecting and storing a lot of data from ubiquitous sensing devices. Even though, cloud-based storage solutions are becoming increasingly popular in recent years, it is inconvenient for residential environments because the sensing devices should be connected to the internet for simultaneously sending data to cloud computing. However, this solution has a high cost implication and high power consumption. Therefore, the credit-card sized computer which is fully functional is a good alternative. It is small and inexpensive computer that provides a new opportunity for IoT hardware. As a result, it is possible to use Raspberry Pi as a database server. In this paper, we will explain how to construct a database server for IoT middleware that has data distribution and low-power consumption by using credit-card size computers which have satisfactory performances and affordable price.
For many years, there are tendencies to support collaborative work of companies of the energy sector, but only the arrival of cloud computing open the door for the implementation of these ideas and aspirations. This a...
详细信息
ISBN:
(纸本)9781509029020
For many years, there are tendencies to support collaborative work of companies of the energy sector, but only the arrival of cloud computing open the door for the implementation of these ideas and aspirations. This actually means a transition to advanced business model and platform with possibilities for launching energy efficient convergent services. From currently available cloud deployment models, as adequate for the energy sector will be considered a hybrid model, as a very efficient, flexible and comprehensive solution. Immediately after the establishment of a common cloud environment the focus of research redirects to the crucial problem of the organization and management of this complex, highly-distributed environment? Especially regarding transactional cloud database and maintaining its consistency. So far, there have been applied conventional methods for preserving consistency and the other ACID rules in highly-distributed transactional environments. However, the actual goal is to make a step forward and to find the optimal solution for preserving the consistency of the entire cloud DBMS. Therefore, this paper discusses adaptable and dynamic approach to preserving consistency of transactional cloud database called TBC (Tree-Based Consistency) approach. It will be shown that this approach provides optimal results and the expected performance of the entire cloud environment.
Relational database management systems (RDBMS) have served as the common choice for the storage of critical information in enterprises or organizations for decades. They are easily understood and applied, but traditio...
详细信息
ISBN:
(纸本)9781467383028
Relational database management systems (RDBMS) have served as the common choice for the storage of critical information in enterprises or organizations for decades. They are easily understood and applied, but traditional RDBMS exist some congenital shortcomings, such as expanding difficult. With the accelerating process of social informationization, the last few years have seen an explosive increase in the volume of data from various applications and they are likely to be stored in different sites. We have to face the uncomfortable fact that traditional RDBMS architectures have reached their limits and could no longer keep pace with the demand of modern society. In this paper, we introduce an innovative distributed database solution based on MySQL to meet the needs of horizontal scalability without affecting the specific implementation of application, which lets users think that it's a single MySQL database logically, actually being a distributed database system physically.
Since the era of big data is coming, the first important problem is how to enhance the speed of database query. For the query optimization of distributed database, the speed of query depends on the data transfer and o...
详细信息
ISBN:
(纸本)9781467395878
Since the era of big data is coming, the first important problem is how to enhance the speed of database query. For the query optimization of distributed database, the speed of query depends on the data transfer and order of join. The cost model minimizing communication cost is the emphasis of research. Parallel Genetic Algorithm-Max-Min Ant System was proposed to seek a best query execution plan, which combines faster convergence of Genetic Algorithm, globally search ability of Max-Min Ant System and parallel property of both them. The experiment results show that the proposed algorithm is effective for query processing of multi-join, and plays important role in improving the performance of distributed database.
暂无评论