Study on Textual Data Sources Based Real-Time ETL

Wen Qi; Jie  Song

doi:10.4028/www.scientific.net/AMR.756-759.1541

Paper Titles

Research and Application of Cloud Computing Technology in Agricultural Information Resources Sharing Service
p.1522

A New Improved Data Acquisition System for Electrical Capacitance Tomography
p.1527

Security Management of Movable Storage Device Based on File System
p.1532

Study on Properties of Expanded Sturmian Sequences
p.1536

Study on Textual Data Sources Based Real-Time ETL
p.1541

On Computer Security in E-Commerce
p.1547

Research on Image Color Balancing Based on Illumination Correction
p.1551

Design and Implementation of E-Government Platform Based on Web GIS and Cloud Computing
p.1556

The Exploration of Computer Assisted Language Learning and the Cultivation of Fresh Talents
p.1561

HomeAdvanced Materials ResearchAdvanced Materials Research Vols. 756-759Study on Textual Data Sources Based Real-Time ETL

Study on Textual Data Sources Based Real-Time ETL

Abstract:

This paper focuses on the issues of real time ETL based on the semi-structured textural data sources. Because the mapping between text data and relational database relies on object-orient programming language, the paper first implements a text-object-relation mapping model for textual data sources based real-time ETL,and then studies the characteristic of real-time and security of purposed model. The cache mechanism aims to solve the performance difference between object-text mapping and object-relation mapping,and furthermore both encryption and signature mechanism aim to guarantee the security of the data in cache. The theoretical analysis and experiments prove the high efficiency and practicality of the mapping model.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Advanced Materials Research (Volumes 756-759)

Pages:

1541-1546

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.756-759.1541

Citation:

Cite this paper

Online since:

September 2013

Authors:

Wen Qi, Jie Song

Keywords:

Cache, Data Warehouse, ORM, OTM, Real-Time ETL, Security

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] S W Ambler. The fundamentals of mapping objects to relational databases, Information on http: /www. agiledata. org.

Google Scholar

[2] J Gray, D T Liu, M A Nieto-Santisteban, A Szalay, D J DeWitt, and G Heber, Scientific data management in the coming decade, SIGMOD Record, Vol. 34, No. 4, 2005, pp.34-41.

DOI: 10.1145/1107499.1107503

Google Scholar

[3] Information on http: /www. nodc. noaa. gov.

Google Scholar

[4] P Buneman, S B Davidson, M F Fernandez, and D Suciu. Adding Structure to Unstructured Data, In: Proceedings of ICDT, 1997, 336-350.

DOI: 10.1007/3-540-62222-5_55

Google Scholar

[5] R L Rivest, A Shamir, and L Adleman. A method for obtaining digital signatures and public-key cryptosystems, Commun ACM, Vol. 21, No. 2, 2002, pp.120-126.

DOI: 10.1145/359340.359342

Google Scholar

[6] Ya Yao Z, An Efficient View Maintenance Algorithm, Journal of Computer Research and Development, Vol. 40, No. 4, 2003, pp.627-633.

Google Scholar