Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)

Research on Big Data Volume Storage Structure Design and Quick Query Mechanism of Oracle Database

Authors
Dingfa Liu
Corresponding Author
Dingfa Liu
Available Online May 2017.
DOI
https://doi.org/10.2991/msmee-17.2017.8How to use a DOI?
Keywords
Big data; data segmentation; indexing; query optimization; distributed
Abstract

Based on a mobile resource management platform, this paper provides a solution for the effective storage and querying of the massive structured data and unstructured data was generated by research and analysis. In the aspect of structured data, this paper first divides the database vertically according to the characteristics of the business, stores the data of the write operation more frequently and stores the data more frequently in the different database, and improves the reading and writing performance of the data. For the basic information of equipment and statistical information related to the existence of large concurrent read operation, the data has been cut again, the two kinds of information on different libraries, and further improve the system to deal with high concurrent read query capabilities.

Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

Volume Title
Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)
Series
Advances in Engineering Research
Publication Date
May 2017
ISBN
978-94-6252-346-3
ISSN
2352-5401
DOI
https://doi.org/10.2991/msmee-17.2017.8How to use a DOI?
Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Cite this article

TY  - CONF
AU  - Dingfa Liu
PY  - 2017/05
DA  - 2017/05
TI  - Research on Big Data Volume Storage Structure Design and Quick Query Mechanism of Oracle Database
BT  - Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)
PB  - Atlantis Press
SP  - 33
EP  - 38
SN  - 2352-5401
UR  - https://doi.org/10.2991/msmee-17.2017.8
DO  - https://doi.org/10.2991/msmee-17.2017.8
ID  - Liu2017/05
ER  -