Database and file system access method and apparatus

A file system and access device technology, which is applied in the field of database and file system access, can solve problems such as high technical threshold and difficulty in getting started

Active Publication Date: 2017-06-27
SHANXI CHINA MOBILE COMM CORP
View PDF5 Cites 31 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] To sum up, in order to cope with different access methods corresponding to different databases or file systems, data users may need to write SQL statements, Shell scripts and Map/Reduce programs to process data at the same time, resulting in data users needing to learn different Access technology accesses data, which increases the technical threshold and is not easy to get started
[0005] At present, in order to solve the above-mentioned difference

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database and file system access method and apparatus
  • Database and file system access method and apparatus
  • Database and file system access method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] See figure 1 , Which shows a method for accessing a database and a file system provided by an embodiment of the present invention, and the method may include:

[0028] S101: Determine the type of the source database or source file system corresponding to the table name and keyword in the input standard SQL statement according to the metadata;

[0029] Specifically, the input standard SQL statement can be written by the user according to requirements, or can be automatically generated by the program, and at the same time, the user can input the above standard SQL statement through a command-line interface (CLI).

[0030] In the specific implementation process, a standard SQL statement may involve multiple table names and keywords. Due to different data sources, the execution of the above standard SQL statement requires access to different databases or file systems. Here, metadata can be used to determine the data source or source file system of the table name and keyword source...

Embodiment 2

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Embodiments of the invention disclose a database and file system access method and apparatus. The method comprises the steps of determining a source database or source file system type corresponding to a table name and a keyword in an input standard SQL (Structured Query Language) statement according to metadata; when the source database or source file system type of the table name and the keyword in the standard SQL statement is an RDBMS (Relational Database Management System) or an MPP (Massive Parallel Processing) system, correspondingly transmitting the standard SQL statement in which the table name and the keyword are located to the RDBMS or the MPP system; when the source database or source file system type of the table name and the keyword in the standard SQL statement is a distributed computing Hadoop system or an NoSQL (Not Only Structured Query Language) database, analyzing the table name and the keyword, correspondingly generating an access statement capable of running in the Hadoop system or the NoSQL database, and correspondingly transmitting the access statement capable of running in the Hadoop system or the NoSQL database to the Hadoop system or the NoSQL database; and receiving an access processing result from the RDBMS, the MPP system, the Hadoop system or the NoSQL database.

Description

Technical field [0001] The invention relates to database management technology and file system access technology, in particular to a method and device for accessing a database and a file system. Background technique [0002] Currently, the existing big data processing platforms generally adopt a mashup architecture, generally including relational database management systems (RDBMS, Relational Database Management System), Massive Parallel Processing (MPP) systems, and non-relational databases (NoSQL, Not OnlySQL). ) And all or part of the components in the distributed computing Hadoop system. [0003] However, when accessing the above four databases or file systems, the required access methods are different. For example, commonly used RDBMS systems have similar storage methods and access methods, and data processing generally uses structured query languages ​​(SQL, Structured Query Language), supports the American National Standards Institute (ANSI, American National Standards Inst...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/13G06F16/2433G06F16/27
Inventor 秦晓飞王峰胡建强邢刚
Owner SHANXI CHINA MOBILE COMM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap