CN108280082A - A kind of extemporaneous querying method and system of statistical data - Google Patents
A kind of extemporaneous querying method and system of statistical data Download PDFInfo
- Publication number
- CN108280082A CN108280082A CN201710009824.9A CN201710009824A CN108280082A CN 108280082 A CN108280082 A CN 108280082A CN 201710009824 A CN201710009824 A CN 201710009824A CN 108280082 A CN108280082 A CN 108280082A
- Authority
- CN
- China
- Prior art keywords
- data
- dimension
- extemporaneous
- relevant information
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 32
- 238000012216 screening Methods 0.000 claims abstract description 20
- 230000008569 process Effects 0.000 claims abstract description 8
- 238000010276 construction Methods 0.000 claims description 7
- 238000012423 maintenance Methods 0.000 claims description 6
- 230000001105 regulatory effect Effects 0.000 claims description 6
- 238000000605 extraction Methods 0.000 abstract description 3
- 238000012545 processing Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000013480 data collection Methods 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 230000001419 dependent effect Effects 0.000 description 2
- 241000282813 Aepyceros melampus Species 0.000 description 1
- 241000251730 Chondrichthyes Species 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to the extemporaneous querying methods and system of a kind of statistical data.A kind of extemporaneous querying method of statistical data includes:The data dimension of statistical data is selected according to demand data and configures screening conditions;The relevant information of data dimension is loaded from database according to the data dimension and screening conditions;According to the relevant information structuring structured query sentence of the data dimension;Execute the structured query sentence, returned data result.Efficiently solving demand data personnel cannot self-service extraction data, excessively depend on BI engineer, and when proposition demand is passed through in premise number requirements of process, BI engineer analyzes demand, writes the flow for carrying several programs, report generation and mail and sending this complexity of report, time-consuming, the low problem of efficiency.
Description
Technical field
The present invention relates to the extemporaneous querying method of technical field of the computer network more particularly to a kind of statistical data and it is
System.
Background technology
In the epoch that big data is increasingly prevailing, it is intended to establish the statistics in big data before doing any one business decision
On analysis, these statistical data how are obtained, and it is very crucial that can quickly obtain statistical data as far as possible.At present
The universal way for obtaining data is BI engineer by writing data operation program, and data extraction is carried out using big data platform,
And serve data to demand data personnel.The detailed process of the prior art is:Business datum demand personnel are to BI engineer
It is proposed the demand of extraction data;BI engineer analyzes demand data;Write the program (structured query language of data operation
SQL);Data operation program is executed in big data platform;By data result generate data sheet (such as:Excel file format
Report);Data sheet is sent to demand data personnel by BI engineer in a manner of mail.
The above-mentioned prior art, which obtains statistical data, will pass through initiation extraction demand data, and BI engineer analyzes demand, writes
Program executes program and generates the process of report and mail transmission report, and not only flow is complicated, and speed is slow, it is longer to take,
Efficiency is very low, and the process for entirely obtaining statistical data needs BI engineer to participate in, and needs to write the program of data operation,
It is strongly dependent upon BI engineer.
Invention content
In view of this, the present invention provides a kind of extemporaneous querying method and system of statistical data, demand data people can be allowed
The data dimension for the statistical data that the self-service selection of member needs, the SQL of inquiry is generated according to the relevant information of data dimension, is submitted to
Big data platform carries out data operation, and data result is showed in real time, while providing data sheet export function, and then solves
The program for needing to write data operation is strongly dependent upon BI engineer, and speed is slow, takes longer, the very low problem of efficiency.
To achieve the above object, according to an aspect of the invention, there is provided a kind of extemporaneous querying method of statistical data.
The method of the present invention includes:The data dimension of statistical data is selected according to demand data and configures screening conditions;According to the number
The relevant information of data dimension is loaded from database according to dimension and screening conditions;According to the relevant information structure of the data dimension
Make structured query sentence;Execute the structured query sentence, returned data result.
Optionally, method of the invention further includes:Mass data in basic data group is pre-processed, is obtained regular
Business datum and storage;And data dimension maintenance is carried out to business datum, and by the relevant information storage of data dimension
In the database.
Optionally, method of the invention further includes:It is connected by java databases and is connect with data query engine;Return to number
According to the data result is shown and downloaded after result.
Optionally, the data query engine is Presto.
Optionally, method of the invention further includes:It calls the query interface of data query engine to inquire data, and returns
Return data result.
According to another aspect of the present invention, a kind of extemporaneous inquiry system of statistical data is provided.The system packet of the present invention
It includes:Extemporaneous enquiry module, database, big data platform;The extemporaneous enquiry module includes data selector and SQL constructors,
The data selector is used to select the data dimension of statistical data according to demand data and configures screening conditions;And according to institute
It states data dimension and screening conditions and loads the relevant information of data dimension from database;The SQL constructors are used for according to institute
State the relevant information structuring structured query sentence of data dimension;The big data platform is for executing the structuralized query language
Speech, returned data result.
Optionally, the big data platform is additionally operable to pre-process mass data in basic data group, and acquisition has rule
Business datum then and storage.The data source construction unit of the extemporaneous enquiry module carries out data dimension dimension to business datum
Shield, and in the database by the relevant information storage of data dimension.
Optionally, the extemporaneous enquiry module further includes:Connection unit is looked into for passing through the connection of java databases with data
Ask engine connection;Display unit shows and downloads the data result after being returned for data result.
Optionally, the data query engine is Presto.
Optionally, the big data platform is additionally operable to call the query interface of data query engine to inquire data, and
Returned data result.
According to the technique and scheme of the present invention, by selecting required data dimension and configuring screening conditions, and according to
The relevant information of these data dimensions, generating structure query statement SQL return to the data of inquiry after executing SQL query statement
As a result.Technical scheme of the present invention can inquire each dimension statistical data, and can return to statistical result in real time, convenient and efficient, efficiency
Height, and independent of BI engineer.
Further effect possessed by above-mentioned non-usual optional mode adds hereinafter in conjunction with specific implementation mode
With explanation.
Description of the drawings
Attached drawing does not constitute inappropriate limitation of the present invention for more fully understanding the present invention.Wherein:
Fig. 1 is a kind of schematic diagram of the extemporaneous querying method key step of statistical data according to the ... of the embodiment of the present invention;
Fig. 2 is a kind of flow chart of the extemporaneous querying method of statistical data according to the ... of the embodiment of the present invention;
Fig. 3 is a kind of schematic diagram of the main modular of the extemporaneous inquiry system of statistical data according to the ... of the embodiment of the present invention;
Fig. 4 is a kind of schematic diagram of the extemporaneous inquiry system of statistical data according to the ... of the embodiment of the present invention.
Specific implementation mode
It explains to the exemplary embodiment of the present invention below in conjunction with attached drawing, including the various of the embodiment of the present invention
Details should think them only exemplary to help understanding.Therefore, those of ordinary skill in the art should recognize
It arrives, various changes and modifications can be made to the embodiments described herein, without departing from scope and spirit of the present invention.Together
The description to known function and structure is omitted for clarity and conciseness in sample in following description.
Fig. 1 is a kind of schematic diagram of the extemporaneous querying method key step of statistical data according to the ... of the embodiment of the present invention.Such as
Shown in Fig. 1, a kind of key step of the extemporaneous querying method of statistical data of the embodiment of the present invention includes:
S11:The data dimension of statistical data is selected according to demand data and configures screening conditions.Demand data personnel Ke Tong
Data selector is crossed to select the data dimension of statistical data according to demand data and configure screening conditions.Before this, BI (commercial affairs
Intelligently) engineer pre-processes mass data in basic data group, obtains well-regulated business datum and store;And it is right
Business datum carries out data dimension maintenance, and in the database by the relevant information storage of data dimension.
S12:The relevant information of data dimension is loaded from database according to data dimension and screening conditions.Demand data people
Member is according to demand data, and from each data dimension of configuration, selection needs the data dimension checked, according to the data dimension of selection
Degree obtains data dimension relevant information from database, and (the relevant information of data dimension includes:Data table name, field name
Claim, the information such as field description), and the relevant information of data dimension is passed into SQL constructors.
S13:According to the relevant information structuring structured query sentence of data dimension.SQL constructors are according to data dimension phase
The information structuring structured query sentence (SQL) of pass.
S14:Execute structured query sentence, returned data result.Wherein, pass through java databases connection (JDBC) and number
It is connected according to query engine;Call the query interface of data query engine to inquire data, and returned data result;Can also show and
Downloading data is as a result, the implementation procedure makes execution efficiency greatly improve.Data query engine is Presto, and Presto is one
The distributed SQL query engine increased income, is provided with the api interfaces such as data query.It is attached, is submitted by JDBC and Presto
By the SQL that SQL constructors generate SQL is executed to Presto, Presto.Data query engine can also be Hive, Impala,
Shark or Stinger etc..
Fig. 2 is a kind of flow chart of the extemporaneous querying method of statistical data according to the ... of the embodiment of the present invention.As shown in Fig. 2,
A kind of extemporaneous querying method of statistical data of the embodiment of the present invention includes:
S201:Mass data in basic data group is pre-processed, well-regulated business datum is obtained and is stored.Big number
It is responsible for mass data storage and operation, including basic data fairground, business datum fairground and Presto three parts according to platform.Base
Collection and storage basic data of the plinth Data Mart for magnanimity big data, wherein basic data includes the day that user accesses website
Will information, merchandise news, comment information etc..Data according to certain business rule, are pushed to business number by basic data fairground
According to fairground, the data content of push is that the data content subscribed to according to business datum fairground determines, i.e. data subscription.BI engineerings
Teacher writes processing routine according to service conditions, and the mass data in basic data fairground is pre-processed, and will treated number
According to being stored, when being inquired to take one's seat faster.For example, on basic data fairground, order data processing is divided into and is abroad ordered
Single and domestic order, is stored in business datum fairground.Or classification processing is carried out to basic data according to dimension and (is completed and orders
Single, user's browsing, deposit shopping cart), and regular business datum is stored in business datum fairground by treated.
S202:Data dimension maintenance is carried out to business datum, and by the relevant information storage of data dimension in database
In.BI engineer safeguards the various data dimensions that big data platform is capable of providing, such as order dimension, commodity dimension, shop dimension
Degree etc., order dimension include the basic items such as O/No., lower single time, order status again.And by the relevant information of data dimension
Storage in the database, is used for data selector in query process.The relevant information of data dimension will also include data table name
Claim, field name, the information such as field description.After being safeguarded by the data dimension to statistical data, demand data is being looked into
The statistical data of needs can be inquired and count by the operations such as selecting data dimension when asking data, into without again
It relies on BI engineer and inquiry can be completed.
S203:The data dimension of statistical data is selected according to demand data and configures screening conditions.Demand data personnel's root
According to demand data, selection needs the data dimension checked from each data dimension of statistical data, and configures screening conditions.
S204:The relevant information of data dimension is loaded from database according to data dimension and screening conditions.Load out number
After the relevant information of dimension, the relevant information of data dimension is passed into SQL constructors.
S205:According to the relevant information structuring structured query sentence of data dimension.SQL constructors are according to data dimension phase
The information of pass, in conjunction with SQL syntax, the SQL statement (institutional query statement) of dynamic generation data query, and will construct
SQL statement passes to java databases connection (JDBC).
S206:It is connected by java databases and is connect with data query engine.Java databases connect JDBC (Java
Data Base Connectivity) it is responsible for being connected to data query engine Presto.
S207:Judge whether connection succeeds.If java databases connect and the success of data query engine, step is carried out
Otherwise S208 carries out step S211.
S208:Call the query interface of data query engine to inquire data.Data query engine Presto is called to provide
Data-query interfaces, and the SQL statement that SQL constructors generate is transmitted into Presto clusters in a manner of parameter, obtained
The data result collection of Presto inquiries.Data result collection is made of the data result and statistical result inquired.
S209:Returned data result.
S210:Displaying and downloading data result.It shows the information of the statistical data of each dimension, and data sheet (ratio is provided
Such as:Excel reports) export function.
S211:Prompt connection failure.
Fig. 3 is a kind of schematic diagram of the main modular of the extemporaneous inquiry system of statistical data according to the ... of the embodiment of the present invention.
As shown in figure 3, a kind of extemporaneous inquiry system 3 of statistical data of the embodiment of the present invention includes mainly:Database 31, extemporaneous inquiry
Module 32 and big data platform 33, wherein extemporaneous enquiry module 32 includes data selector and SQL constructors, data selector is used
In the data dimension for selecting statistical data according to demand data and configure screening conditions;And according to data dimension and screening conditions
The relevant information of data dimension is loaded from database.SQL constructors are used for according to the relevant information structuring structure of data dimension
Change query statement.Big data platform 33 is for executing structured query language, returned data result.Extemporaneous enquiry module also wraps
It includes:Connection unit, for being connect with data query engine by the connection of java databases;Display unit is returned for data result
Displaying and downloading data result after returning.Wherein, data query engine is Presto, can promote search efficiency.In addition, big data is flat
Platform is additionally operable to call the query interface of data query engine to inquire data, and returned data result.
Demand data personnel select the data dimension of statistical data according to demand data by data selector and configure sieve
Condition is selected, SQL constructors inquire language according to the relevant information of data dimension and SQL syntax generating structureization of load later
Then sentence is linked to big data platform by JDBC, execute SQL statement with query statistic data, and data result collection is returned
It is shown and downloads to data display unit.Big data platform is additionally operable in advance be located mass data in basic data group
Reason, obtains well-regulated business datum and stores.The data source construction unit of extemporaneous enquiry module, data are carried out by business datum
Dimension maintenance, and in the database by the relevant information storage of data dimension.
Fig. 4 is a kind of schematic diagram of the extemporaneous inquiry system of statistical data according to the ... of the embodiment of the present invention.As shown in figure 4,
A kind of extemporaneous inquiry system of statistical data of the embodiment of the present invention includes that extemporaneous enquiry module 41, database 42 and big data are flat
Platform 43.
Wherein, enquiry module 41 of taking one's seat includes data source construction unit 411, data selector 412,413 and of SQL constructors
Connection unit 414, display unit 415.BI engineer can safeguard what big data platform provided by data source construction unit 411
Various data dimensions, and by the relevant information storage of these data dimensions in database 42, so that data selector 412 is being looked into
It is used during asking.After processing of the business datum by data source construction unit 411, it can get demand personnel and can easily understand that
With the source data of processing.When demand personnel go for required statistical data, does not then have to rely on BI engineer, voluntarily pass through
Data selector selection data dimension (such as:O/No., order status, goods number, lower single time etc.), then SQL structures
Make dimensional information of the device according to selection, the SQL statement of construction inquiry data;Then big data platform is linked to by JDBC, held
Row SQL query statistical data, and data result collection is returned into data display module and is shown and downloads, complete inquiry.
Data selector 412, for demand data personnel according to demand data, from each of data source configuration of described dispensing unit
In data dimension, selection needs the data dimension checked, i.e., required data are read from database 42.According to the data dimension of selection
Degree obtains dimension data relevant information from database, and (the relevant information of dimension includes:Data table name, field name, word
The information such as segment description), and the relevant information of dimension is passed into SQL constructors.
The data dimension of statistical data is selected according to demand data by data selector 412 and configures screening conditions, is tied
SQL syntax, the SQL statement of 413 dynamic generation data query of SQL constructors are closed, and the SQL constructed is passed into connection unit
414.Wherein, connection unit 414 is that java databases connect JDBC (Java Data Base Connectivity).
Connection unit 414 is responsible for being linked to Presto clusters, the data-query interfaces for calling Presto to provide, and by SQL
The SQL statement that constructor generates transmits Presto clusters in a manner of parameter, obtains the data result collection of Presto inquiries.
Display unit 415 shows the information of the statistical data of each data dimension, and provide data sheet lead (such as:Excel
Report) go out function, convenient for check acquisition statistical data data result.
Big data platform 43 includes basic data fairground 418, business datum fairground 417 and Presto416.Basic data collection
City 418 for magnanimity big data collection and storage basic data (such as:The log information of user's access website, merchandise news,
Comment information etc.), and data are pushed to business datum fairground, the data content of push is root according to certain business rule
It is determined according to the data content that business datum fairground is subscribed to, i.e. data subscription.
Processing routine is write, basic data fairground in business datum fairground 417 for BI engineer according to service conditions
418 mass data is handled again, and data store by treated, when being inquired to take one's seat faster.Such as
On basic data fairground, order data processing is divided into overseas order and domestic order, is stored in business datum fairground.According to industry
Mass data in basic data cluster is pre-processed into well-regulated business datum by business, forms business datum cluster, can
Promote inquiry velocity.
Presto416 is a distributed SQL query engine increased income, and is provided with the api interface of data query.Pass through
JDBC is attached with Presto, and the SQL generated by SQL constructors is submitted to execute SQL to Presto, Presto, inquire number
According to and return to data display module.Data real-time query is realized using Presto, promotes the speed of inquiry.
Database 42 is relevant database, is stored for data persistence, and the data of storage include user information, big number
The relevant information of each data dimension etc. provided according to platform.
Above-mentioned specific implementation mode, does not constitute limiting the scope of the invention.Those skilled in the art should be bright
It is white, design requirement and other factors are depended on, various modifications, combination, sub-portfolio and replacement can occur.It is any
Modifications, equivalent substitutions and improvements made by within the spirit and principles in the present invention etc., should be included in the scope of the present invention
Within.
Claims (10)
1. a kind of extemporaneous querying method of statistical data, which is characterized in that including:
The data dimension of statistical data is selected according to demand data and configures screening conditions;
The relevant information of data dimension is loaded from database according to the data dimension and screening conditions;
According to the relevant information structuring structured query sentence of the data dimension;
Execute the structured query sentence, returned data result.
2. method according to claim 1, which is characterized in that further include:
Mass data in basic data group is pre-processed, well-regulated business datum is obtained and is stored;And
Data dimension maintenance is carried out to business datum, and in the database by the relevant information storage of data dimension.
3. method according to claim 1, which is characterized in that further include:
It is connected by java databases and is connect with data query engine;
The data result is shown and downloaded after returned data result.
4. method according to claim 3, which is characterized in that the data query engine is Presto.
5. method according to claim 1, which is characterized in that further include:
Call the query interface of data query engine to inquire data, and returned data result.
6. a kind of extemporaneous inquiry system of statistical data, which is characterized in that including:Extemporaneous enquiry module, database, big data are flat
Platform;
The extemporaneous enquiry module includes data selector and SQL constructors, and the data selector is used for according to demand data
It selects the data dimension of statistical data and configures screening conditions;And according to the data dimension and screening conditions from database
Load the relevant information of data dimension;The SQL constructors are used for according to the relevant information structuring structuring of the data dimension
Query statement;
The big data platform is for executing the structured query language, returned data result.
7. system according to claim 6, which is characterized in that
The big data platform is additionally operable to pre-process mass data in basic data group, obtains well-regulated business datum
And it stores;And
The data source construction unit of the extemporaneous enquiry module carries out data dimension maintenance to business datum, and by data dimension
Spend relevant information storage in the database.
8. system according to claim 6, which is characterized in that the extemporaneous enquiry module further includes:
Connection unit, for being connect with data query engine by the connection of java databases;
Display unit, for showing and downloading the data result after returned data result.
9. system according to claim 8, which is characterized in that the data query engine is Presto.
10. system according to claim 6, which is characterized in that the big data platform is additionally operable to call data query engine
Query interface to inquire data and returned data result.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710009824.9A CN108280082A (en) | 2017-01-06 | 2017-01-06 | A kind of extemporaneous querying method and system of statistical data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710009824.9A CN108280082A (en) | 2017-01-06 | 2017-01-06 | A kind of extemporaneous querying method and system of statistical data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108280082A true CN108280082A (en) | 2018-07-13 |
Family
ID=62800905
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710009824.9A Pending CN108280082A (en) | 2017-01-06 | 2017-01-06 | A kind of extemporaneous querying method and system of statistical data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108280082A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
CN110659294A (en) * | 2019-09-25 | 2020-01-07 | 北京明略软件系统有限公司 | Space-time data ad hoc query method, system, electronic device and storage medium |
CN111831623A (en) * | 2020-05-29 | 2020-10-27 | 大数金科网络技术有限公司 | Configurable ad hoc query system and method |
CN112434056A (en) * | 2020-10-12 | 2021-03-02 | 南京江北新区生物医药公共服务平台有限公司 | Method and device for inquiring detailed data |
CN112507353A (en) * | 2020-11-27 | 2021-03-16 | 中原银行股份有限公司 | Data extraction method and device |
CN112861495A (en) * | 2020-11-24 | 2021-05-28 | 辽宁振兴银行股份有限公司 | Method for generating impala SQL statement based on Excel template file |
CN113111239A (en) * | 2021-04-08 | 2021-07-13 | 北京联创新天科技有限公司 | Universal database operation method, device and storage medium thereof |
CN116860957A (en) * | 2023-07-25 | 2023-10-10 | 广州探迹科技有限公司 | Enterprise screening method, device and medium based on large language model |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105574052A (en) * | 2014-11-06 | 2016-05-11 | 中兴通讯股份有限公司 | Database query method and apparatus |
CN106066895A (en) * | 2016-06-30 | 2016-11-02 | 广东亿迅科技有限公司 | A kind of intelligent inquiry system |
-
2017
- 2017-01-06 CN CN201710009824.9A patent/CN108280082A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105574052A (en) * | 2014-11-06 | 2016-05-11 | 中兴通讯股份有限公司 | Database query method and apparatus |
CN106066895A (en) * | 2016-06-30 | 2016-11-02 | 广东亿迅科技有限公司 | A kind of intelligent inquiry system |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
CN109271411B (en) * | 2018-09-28 | 2023-08-29 | 中国平安财产保险股份有限公司 | Report generation method, report generation device, computer equipment and storage medium |
CN110659294A (en) * | 2019-09-25 | 2020-01-07 | 北京明略软件系统有限公司 | Space-time data ad hoc query method, system, electronic device and storage medium |
CN110659294B (en) * | 2019-09-25 | 2022-05-17 | 北京明略软件系统有限公司 | Space-time data ad hoc query method, system, electronic device and storage medium |
CN111831623A (en) * | 2020-05-29 | 2020-10-27 | 大数金科网络技术有限公司 | Configurable ad hoc query system and method |
CN112434056A (en) * | 2020-10-12 | 2021-03-02 | 南京江北新区生物医药公共服务平台有限公司 | Method and device for inquiring detailed data |
CN112861495A (en) * | 2020-11-24 | 2021-05-28 | 辽宁振兴银行股份有限公司 | Method for generating impala SQL statement based on Excel template file |
CN112507353A (en) * | 2020-11-27 | 2021-03-16 | 中原银行股份有限公司 | Data extraction method and device |
CN113111239A (en) * | 2021-04-08 | 2021-07-13 | 北京联创新天科技有限公司 | Universal database operation method, device and storage medium thereof |
CN113111239B (en) * | 2021-04-08 | 2024-03-29 | 北京联创新天科技有限公司 | General database operation method, device and storage medium thereof |
CN116860957A (en) * | 2023-07-25 | 2023-10-10 | 广州探迹科技有限公司 | Enterprise screening method, device and medium based on large language model |
CN116860957B (en) * | 2023-07-25 | 2024-04-16 | 广州探迹科技有限公司 | Enterprise screening method, device and medium based on large language model |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108280082A (en) | A kind of extemporaneous querying method and system of statistical data | |
CN107402989B (en) | Full-text retrieval establishing method and distributed NewSQL database system | |
US9672250B2 (en) | Database calculation engine | |
CN102982075B (en) | Support to access the system and method for heterogeneous data source | |
CN107103064B (en) | Data statistical method and device | |
US11023468B2 (en) | First/last aggregation operator on multiple keyfigures with a single table scan | |
CN107003868B (en) | Processing queries containing federated type operations | |
US20110137923A1 (en) | Xbrl data mapping builder | |
CN104838377A (en) | Integrating event processing with map-reduce | |
US9547646B2 (en) | User-created members positioning for OLAP databases | |
US20060129609A1 (en) | Database synchronization using change log | |
CN103745319B (en) | A kind of data provenance traceability system based on multi-state scientific workflow and method | |
Baumgartner et al. | Web data extraction for business intelligence: the lixto approach | |
US10459987B2 (en) | Data virtualization for workflows | |
JP2017120610A (en) | Update system for database using spreadsheet interface | |
Salem et al. | Active XML-based Web data integration | |
US20130166531A1 (en) | Data browser for group-by data access | |
US20120124110A1 (en) | Database, management server, and management program | |
US10713268B1 (en) | Methods and systems for social awareness | |
US10067980B2 (en) | Database calculation engine integrating hierarchy views | |
US10255316B2 (en) | Processing of data chunks using a database calculation engine | |
CN105630997A (en) | Data parallel processing method, device and equipment | |
US9037570B2 (en) | Optimization of business warehouse filters on complex calculation models | |
CN111143406A (en) | Database data comparison method and database data comparison system | |
US8930426B2 (en) | Distributed requests on remote data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180713 |