A method and apparatus for generating and calling big data
A big data and data technology, applied in the field of big data generation and invocation methods and devices, can solve problems such as difficult to achieve test goals, difficult to traverse encrypted data, data type restrictions, etc., to achieve analysis and processing, and simplify the system. The effect of building, reducing execution time
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0052] Such as figure 1 with figure 2 As shown, a method for generating and calling big data according to an embodiment of the present invention is provided, including the following steps:
[0053] S101 acquires data;
[0054] Specifically, use etl and / or hive tools to obtain data.
[0055] etl, which is the abbreviation of Extract-Transform-Load in English, is used to describe the process of extracting, transforming, and loading data from the source to the destination. The term etl is more commonly used in data warehouses, but its objects are not limited to data warehouses. ETL is an important part of building a data warehouse. Users extract the required data from the data source, after data cleaning, and finally load the data into the data warehouse according to the pre-defined data warehouse model.
[0056] The quality problems of etl are specifically manifested in several characteristics such as correctness, completeness, consistency, completeness, validity, timelines...
example
[0112] CREATE TABLE STUDENT INFO
[0113] (
[0114] NAME STRING,
[0115] FAVORITE ARRAY ,
[0116] COURSE MAP,
[0117] ADDRESS STRUCT
[0118] )
[0119] Query syntax: SELECT S.NAME,S.FAVORITE[0],S.COURSE["ENGLISH"],S.ADDRESS.CITY FROM STUDENTINFO S;
[0120] hive partition table
[0121] Create partition table: create table employee(name string,age int,sex string) partitioned by(city string)row format delimited fields terminated by'\t';
[0122] Partition table loading data: load data local inpath' / usr / local / lee / employee'intotable employee partition(city='hubei').
[0123] S102 encrypting data to obtain encrypted data;
[0124] S103 importing the encrypted data into the database;
[0125] The database is a local database.
[0126] S104 responds to the keyword input by the user to view the request of the target data associated with the keyword;
[0127] Specifically, the sql script is used to find out the address and message of the target...
Embodiment 2
[0160] Such as image 3 As shown, a device for generating and invoking big data according to another embodiment of the present invention is provided, including:
[0161] An acquisition module A201, configured to acquire data;
[0162] Specifically, the acquiring module A201 uses etl and / or hive tools to acquire data.
[0163] An encryption module A202, configured to encrypt data to obtain encrypted data;
[0164] The storage module A203 is used to import encrypted data into the database;
[0165] The database is a local database.
[0166] Response module A204, for responding to the keyword input by the user to view the request of the data associated with the keyword;
[0167] The processing module A208 specifies the type of the target data.
[0168] The first configuration module A205 is used to configure the address and message of the target data;
[0169] Specifically, the first configuration module A205 configures the address of the target data in...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com