CN108153834B - Method and device for querying data by commercial intelligent application and electronic equipment - Google Patents
Method and device for querying data by commercial intelligent application and electronic equipment Download PDFInfo
- Publication number
- CN108153834B CN108153834B CN201711341441.8A CN201711341441A CN108153834B CN 108153834 B CN108153834 B CN 108153834B CN 201711341441 A CN201711341441 A CN 201711341441A CN 108153834 B CN108153834 B CN 108153834B
- Authority
- CN
- China
- Prior art keywords
- description
- data model
- model
- describing
- business intelligence
- 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.)
- Active
Links
Images
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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
-
- 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/245—Query processing
- G06F16/2452—Query translation
Abstract
The invention discloses a method, a device and electronic equipment for querying data by commercial intelligent application, wherein the method comprises the following steps: describing the data model by adopting JSON description rules to obtain JSON description of the data model; describing the query analysis model by adopting JSON description rules to obtain JSON description of the query analysis model; resolving the JSON description of the data model into an SQL script; and sending the SQL script to the business intelligent application according to the JSON description of the query analysis model. According to the method, the JSON description rule is used for describing the data model and the query analysis model, the JSON description is analyzed through the analysis engine, the SQL script is generated and provided for the business intelligent application, and the OLAP query analysis engine supporting the SQL grammar is connected. The syntax conversion step from the commercial intelligence application to the OLAP query analysis engine is reduced.
Description
Technical Field
The invention relates to the technical field of virtual reality, in particular to a method and a device for querying data by business intelligent application and electronic equipment.
Background
The bi (business intelligence), which is a complete solution, is used to effectively integrate the existing data in the enterprise, quickly and accurately provide reports and provide decision basis, and help the enterprise make intelligent business operation decision.
OLAP (On line Transaction Processing) is a software technology that enables an analyst to quickly, consistently, and interactively view information from various aspects for the purpose of understanding data in depth.
Business intelligence BI tools typically need to interact through a specific protocol or xmla protocol when interfacing with an OLAP engine. Among them, xmla (XML for analysis) is an XML protocol based on Simple Object Access Protocol (SOAP) that is designed specifically for general data access to any standard multidimensional data source residing on a network. The operation of business intelligence application is converted into MDX grammar and then interacts with OLAP, and the independently developed OLAP engine or the data analysis engine based on SQL query cannot be directly used, and usually needs to be converted again, namely MDX is converted into SQL grammar again. Multiple conversions can cause compatibility problems.
Disclosure of Invention
It is an object of the present invention to provide a new solution to at least one of the above problems.
According to a first aspect of the present invention, there is provided a method for querying data by a business intelligence application, comprising:
describing a data model by adopting a JSON description rule to obtain JSON description of the data model;
describing a query analysis model by adopting a JSON description rule to obtain JSON description of the query analysis model;
analyzing the JSON description of the data model into an SQL script; and the number of the first and second groups,
and analyzing and converting the JSON description of the query analysis model and the SQL script execution result into a data model and sending the data model to the business intelligent application.
Optionally, the describing, by using JSON description rules, the query analysis model includes:
generating a JSON description of a query model in response to query behavior of the business intelligence application against the data model.
Optionally, the sending the executed and processed result of the SQL script to the business intelligence application according to the description of the query analysis model includes:
generating a data model for describing the business intelligent application display according to the description of the query analysis model and the SQL script;
providing the data model describing the business intelligence application presentation to the business intelligence application.
Optionally, the method further includes:
rendering, by the business intelligence application, the data model describing the business intelligence application presentation.
According to a second aspect of the present invention, there is provided an apparatus for querying data by a business intelligence application, comprising:
the first description module is used for describing a data model by adopting a JSON description rule to obtain JSON description of the data model;
the second description module is used for describing the query analysis model by adopting JSON description rules to obtain JSON description of the query analysis model;
the analysis module is used for analyzing the JSON description of the data model into an SQL script; and the number of the first and second groups,
and the sending module analyzes and converts the JSON description of the query analysis model and the SQL script execution result into a data model and sends the data model to the business intelligent application.
Optionally, the second description module is further configured to:
generating a JSON description of a query model in response to query behavior of the business intelligence application against the data model.
Optionally, the sending module further includes:
the generating unit is used for generating a data model for describing the business intelligent application display according to the description of the query analysis model and the SQL script;
a providing unit for providing the data model for describing the business intelligence application presentation to the business intelligence application.
Optionally, the apparatus further comprises:
a rendering module to render, by the business intelligence application, the data model describing the business intelligence application presentation.
According to a third aspect of the invention, there is provided an electronic device comprising an apparatus according to the second aspect of the invention.
According to a fourth aspect of the present invention, there is provided an electronic device, comprising a processor and a memory, the memory being arranged to store instructions for controlling the processor to operate to perform the method according to the first aspect of the present invention.
The method has the advantages that the JSON description rule is used for describing the data model and the query analysis model, the JSON description is analyzed through the analysis engine, the SQL script is generated and provided for the commercial intelligent application, and the OLAP query analysis engine supporting the SQL grammar is connected. The syntax conversion step from the commercial intelligence application to the OLAP query analysis engine is reduced.
Other features of the present invention and advantages thereof will become apparent from the following detailed description of exemplary embodiments thereof, which proceeds with reference to the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description, serve to explain the principles of the invention.
FIG. 1 is a flow diagram of one embodiment of a method for querying data for a business intelligence application in accordance with the present invention;
FIG. 2 is a block schematic diagram of an implementation structure of an apparatus for querying data for a business intelligence application in accordance with the present invention;
FIG. 3 is a block diagram of an implementation structure of an electronic device according to the present invention;
FIG. 4 is a diagram of one embodiment of a relationship between dimension tables and fact tables in a business intelligence analysis.
Detailed Description
Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that: the relative arrangement of the components and steps, the numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.
The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the invention, its application, or uses.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail but are intended to be part of the specification where appropriate.
In all examples shown and discussed herein, any particular value should be construed as merely illustrative, and not limiting. Thus, other examples of the exemplary embodiments may have different values.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, further discussion thereof is not required in subsequent figures.
FIG. 1 is a flow diagram of one embodiment of a method for querying data for a business intelligence application in accordance with the present invention.
According to fig. 1, the method comprises the following steps:
and step S110, describing the data model by adopting a JSON description rule to obtain JSON description of the data model.
JSON (JSON Object tagging) is a lightweight data exchange format. It stores and represents data in a text format that is completely independent of the programming language, based on a subset of ECMAScript (the js specification specified by w3 c). The compact and clear hierarchy makes JSON an ideal data exchange language. The network transmission method is easy to read and write by people, is easy to analyze and generate by machines, and effectively improves the network transmission efficiency.
FIG. 4 is a diagram of one embodiment of a relationship between dimension tables and fact tables in a business intelligence analysis. And describing the data model by adopting the JSON description rule, namely describing the relationship between the dimension table and the fact table in the business intelligent analysis by adopting the JSON description rule. The relationship between the dimension table and the fact table in the business intelligent analysis can be obtained directly based on the database or can be obtained based on other third-party tools.
In this embodiment, the JSON description of the data model may be:
wherein, inds represents a fact table index, columns represent an attribute column of the fact table, tablename represents a corresponding physical table, relationship definition represents an association relationship between dimensions and the fact table, relationship definition.
And step S120, describing the query analysis model by adopting a JSON description rule to obtain JSON description of the query analysis model.
Specifically, the JSON description of the query model is generated in response to the query behavior of the business intelligence application against the data model.
In the above embodiment, based on the data model already described by using the JSON description rule, describing a series of contents of the query analysis model by using the JSON description rule includes: the method comprises the steps of querying dimensionality, indexes, cross relations between the dimensionality and the indexes, rendering types, data formatting, dimensionality drilling conditions, data filtering conditions and the like.
If the data model needs to be queried, the definition of the query behavior generates JSON description of the query model: such as: grouping according to marketing organization, checking sales, and rendering into column chart, the query analysis model JSON description can be:
the reportefinerepresents a root node of a query line, neiddrill represents whether drilling is needed or not, neidsubtotal requires subtotal, widget represents a graph type which needs to be rendered finally, such as bar represents a histogram, rows represents a line or horizontal axis dimension, columns represents a column dimension, measureup represents index grouping description, measureup represents index sequence, measureup represents whether the graph is used for alternative or not, default does not participate in rendering, measureup represents format definition of index data, measureup represents graph, chartste represents a graph which is rendered, such as bar column, line broken line, slices represents screening parameter definition, services represents coding parameter value.
And S130, resolving the JSON description of the data model into an SQL script.
Specifically, the JSON description of the data model may be sent to a server parsing engine to be parsed into an SQL script.
And step S140, sending the SQL script to the business intelligent application according to the JSON description of the query analysis model.
Further, a data model for describing the presentation of the voice intelligent application can be generated according to the description of the query analysis model and the SQL script, and then provided to the business intelligent application. And rendering the data model describing the presentation of the voice intelligence application through the business intelligence application.
This embodiment is described in the following steps of grouping by [ marketing organization ], viewing [ sales ], and rendering as [ histogram ]:
analyzing the content of the select and the content of the group by according to rows, and if the newSutotal is equal to true, replacing the content of the group by with a group by roll or a group by cube.
From part, for example, from bi _ face _ sample _ move _ the same _ face _ sample _ present _ same join _ di _ m _ sample ═ bi _ di _ m _ sample.
And executing the SQL script, and sending the result to the business intelligent application for UI rendering according to JSON description of the query model.
Therefore, through the method, the JSON description rule is used for describing the data model and the query analysis model, the JSON description is analyzed through the analysis engine, the SQL script is generated and provided for the business intelligent application, and the OLAP query analysis engine supporting the SQL grammar is connected. The syntax conversion step from the commercial intelligence application to the OLAP query analysis engine is reduced.
The invention also provides a device for querying the data by the commercial intelligent application. Fig. 2 is a block diagram of an implementation structure of an apparatus for querying data by an intelligent application according to the present invention.
According to fig. 2, the apparatus includes a first description module 210, a second description module 220, a parsing module 230, and a sending module 240. The first description module 210 is configured to describe the data model by using a JSON description rule to obtain JSON description of the data model; the second description module 220 is configured to describe the query analysis model by using JSON description rules to obtain JSON descriptions of the query analysis model; the parsing module 230 is configured to parse JSON description of the data model into SQL script; the sending module 240 is configured to send the SQL script to the business intelligence application according to the JSON description of the query analysis model.
Specifically, the second description module 220 is further configured to: a JSON description of the query model is generated in response to query behavior of the business intelligence application against the data model.
Further, the sending module 240 further includes a generating unit and a providing unit, wherein the generating unit is configured to generate a data model for describing the business intelligence application display according to the description of the query analysis model and the SQL script; the providing unit is used for providing the data model for describing the business intelligence application display to the business intelligence application.
On this basis, the device also comprises a rendering module used for rendering the data model used for describing the business intelligence application display through the business intelligence application.
The invention also provides an electronic device, and in one aspect, the virtual reality device comprises the above device for querying data by the business intelligence application.
Fig. 3 is a block schematic diagram of an implementation structure of the electronic device according to another aspect of the invention.
As shown in fig. 3, the electronic device 300 comprises a memory 301 and a processor 302, the memory 301 is used for storing instructions for controlling the processor 302 to operate so as to execute the above method for querying data by a business intelligence application.
The processor 302 may be, for example, a central processing unit CPU, a microprocessor MCU, or the like. The memory 301 includes, for example, a ROM (read only memory), a RAM (random access memory), a nonvolatile memory such as a hard disk, and the like.
In addition, the electronic device 300 comprises, according to fig. 3, interface means 303, input means 304, display means 305, communication means 306, a loudspeaker 307, a microphone 308, etc. Although a plurality of devices are shown in fig. 3, the electronic apparatus of the present invention may involve only some of the devices, for example, the processor 301, the memory 302, the display device 305, and the like.
The communication device 306 can perform wired or wireless communication, for example.
The interface device 303 includes, for example, a headphone jack, a USB interface, and the like.
The input device 304 may include, for example, a touch screen, a key, and the like.
The display device 305 is, for example, a liquid crystal display panel, a touch panel, or the like.
The electronic device 300 of the present invention may be, for example, an electronic product such as a mobile phone and a tablet computer.
The above embodiments mainly focus on differences from other embodiments, but it should be clear to those skilled in the art that the above embodiments can be used alone or in combination with each other as needed.
The embodiments in the present disclosure are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments, but it should be clear to those skilled in the art that the embodiments described above can be used alone or in combination with each other as needed. In addition, for the device embodiment, since it corresponds to the method embodiment, the description is relatively simple, and for relevant points, refer to the description of the corresponding parts of the method embodiment. The system embodiments described above are merely illustrative, in that modules illustrated as separate components may or may not be physically separate.
The present invention may be an apparatus, method and/or computer program product. The computer program product may include a computer-readable storage medium having computer-readable program instructions embodied therewith for causing a processor to implement various aspects of the present invention.
The computer readable storage medium may be a tangible device that can hold and store the instructions for use by the instruction execution device. The computer readable storage medium may be, for example, but not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. Computer-readable storage media as used herein is not to be construed as transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission medium (e.g., optical pulses through a fiber optic cable), or electrical signals transmitted through electrical wires.
The computer-readable program instructions described herein may be downloaded from a computer-readable storage medium to a respective computing/processing device, or to an external computer or external storage device via a network, such as the internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in the respective computing/processing device.
The computer program instructions for carrying out operations of the present invention may be assembler instructions, Instruction Set Architecture (ISA) instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The computer-readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider). In some embodiments, aspects of the present invention are implemented by personalizing an electronic circuit, such as a programmable logic circuit, a Field Programmable Gate Array (FPGA), or a Programmable Logic Array (PLA), with state information of computer-readable program instructions, which can execute the computer-readable program instructions.
Aspects of the present invention are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer-readable program instructions.
These computer-readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer-readable program instructions may also be stored in a computer-readable storage medium that can direct a computer, programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer-readable medium storing the instructions comprises an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer, other programmable apparatus or other devices implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. It is well known to those skilled in the art that implementation by hardware, by software, and by a combination of software and hardware are equivalent.
Having described embodiments of the present invention, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the embodiments disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terms used herein were chosen in order to best explain the principles of the embodiments, the practical application, or technical improvements to the techniques in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein. The scope of the invention is defined by the appended claims.
Claims (8)
1. A method for querying data by a business intelligence application, comprising:
describing a data model by adopting JSON description rules to obtain JSON description of the data model, wherein the data model is a relation between a dimension table and a fact table in business intelligent analysis;
describing a query analysis model of business intelligence application by adopting JSON description rules to obtain JSON description of the query analysis model;
analyzing the JSON description of the data model into an SQL script; generating a data model for describing the business intelligent application display according to the JSON description of the query analysis model and the execution result of the SQL script in an OLAP engine; providing the data model describing the business intelligence application presentation to the business intelligence application.
2. The method of claim 1, wherein describing a query analysis model of a business intelligence application using JSON description rules comprises:
generating a JSON description of a query model in response to query behavior of the business intelligence application against the data model.
3. The method of claim 1, further comprising:
rendering, by the business intelligence application, the data model describing the business intelligence application presentation.
4. An apparatus for querying data for a business intelligence application, comprising:
the system comprises a first description module, a second description module and a third description module, wherein the first description module is used for describing a data model by adopting a JSON description rule to obtain JSON description of the data model, and the data model is a relation between a dimension table and a fact table in business intelligent analysis;
the second description module is used for describing a query analysis model of the business intelligence application by adopting JSON description rules to obtain JSON description of the query analysis model;
the analysis module is used for analyzing the JSON description of the data model into an SQL script; and the number of the first and second groups,
the sending module is used for generating a data model for describing the business intelligent application display according to the JSON description of the query analysis model and the execution result of the SQL script in an OLAP engine; providing the data model describing the business intelligence application presentation to the business intelligence application.
5. The apparatus of claim 4, wherein the second description module is further configured to:
generating a JSON description of a query model in response to query behavior of the business intelligence application against the data model.
6. The apparatus of claim 4, further comprising:
a rendering module to render, by the business intelligence application, the data model describing the business intelligence application presentation.
7. An electronic device, characterized in that it comprises an apparatus according to any of claims 4-6.
8. An electronic device comprising a processor and a memory, the memory to store instructions to control the processor to operate to perform the method of any of claims 1-3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711341441.8A CN108153834B (en) | 2017-12-14 | 2017-12-14 | Method and device for querying data by commercial intelligent application and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711341441.8A CN108153834B (en) | 2017-12-14 | 2017-12-14 | Method and device for querying data by commercial intelligent application and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108153834A CN108153834A (en) | 2018-06-12 |
| CN108153834B true CN108153834B (en) | 2020-11-06 |
Family
ID=62466150
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711341441.8A Active CN108153834B (en) | 2017-12-14 | 2017-12-14 | Method and device for querying data by commercial intelligent application and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108153834B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112039989B (en) * | 2020-08-31 | 2023-02-21 | 广州品唯软件有限公司 | Data drilling method, proxy server, service calling system and medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| CN105205085A (en) * | 2014-06-30 | 2015-12-30 | 中兴通讯股份有限公司 | Multi-dimensional analysis method and device for mass data |
| CN107301206A (en) * | 2017-06-01 | 2017-10-27 | 华南理工大学 | A kind of distributed olap analysis method and system based on pre-computation |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103605651A (en) * | 2013-08-28 | 2014-02-26 | 杭州顺网科技股份有限公司 | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis |
| CN104657384A (en) * | 2013-11-21 | 2015-05-27 | 航天信息股份有限公司 | Dynamic allocation report data processing method based on two-dimension relationship |
| US9921945B2 (en) * | 2015-04-06 | 2018-03-20 | Adp, Llc | Automatic verification of JSON data |
| US9959607B2 (en) * | 2015-07-07 | 2018-05-01 | Adp, Llc | Automatic verification of graphic rendition of JSON data |
| US20170024432A1 (en) * | 2015-07-24 | 2017-01-26 | International Business Machines Corporation | Generating sql queries from declarative queries for semi-structured data |
| CN105404665B (en) * | 2015-11-12 | 2019-04-26 | 南威软件股份有限公司 | A kind of inquiry management system of JSON formatted data |
| CN106095824A (en) * | 2016-06-01 | 2016-11-09 | 浪潮电子信息产业股份有限公司 | A kind of JSON format text imports the method for data base |
-
2017
- 2017-12-14 CN CN201711341441.8A patent/CN108153834B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105205085A (en) * | 2014-06-30 | 2015-12-30 | 中兴通讯股份有限公司 | Multi-dimensional analysis method and device for mass data |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| CN107301206A (en) * | 2017-06-01 | 2017-10-27 | 华南理工大学 | A kind of distributed olap analysis method and system based on pre-computation |
Non-Patent Citations (4)
| Title |
|---|
| Java小程序：将json文件中树信息转换成insert sql脚本;lynfoolbird;《https://blog.csdn.net/qq_29929059/article/details/70477812》;20170422;全文 * |
| OLAP中查询优化以及多维数据模型的研究;黄金钗;《中国优秀硕士学位论文全文数据库 信息科技辑》;20100115(第1期);全文 * |
| 基于Pentaho的电话中心商务智能系统设计与实现;曾希强;《中国优秀硕士学位论文全文数据库 信息科技辑》;20140115(第1期);全文 * |
| 电子政务系统开发平台关键技术研发;侯济恭等;《武汉理工大学学报（信息与管理工程版）》;20101231;第32卷(第6期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108153834A (en) | 2018-06-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11645471B1 (en) | Determining a relationship recommendation for a natural language request | |
| US9953022B2 (en) | Natural language metric condition alerts | |
| US9275120B2 (en) | Easy query | |
| US11288319B1 (en) | Generating trending natural language request recommendations | |
| US9607063B1 (en) | NoSQL relational database (RDB) data movement | |
| US11017764B1 (en) | Predicting follow-on requests to a natural language request received by a natural language processing system | |
| US20160364770A1 (en) | System for high volume data analytic integration and channel-independent advertisement generation | |
| US11269872B1 (en) | Intent-based natural language processing system | |
| EP2717201A1 (en) | Natural language metric condition alerts orchestration | |
| CN111177231A (en) | Report generation method and report generation device | |
| EP2717202A1 (en) | Natural language metric condition alerts users interfaces | |
| US10769137B2 (en) | Integration query builder framework | |
| US9959607B2 (en) | Automatic verification of graphic rendition of JSON data | |
| US10877985B2 (en) | Systems and methods for making visual data representations actionable | |
| US11475053B1 (en) | Providing completion recommendations for a partial natural language request received by a natural language processing system | |
| CN111563385A (en) | Semantic processing method, semantic processing device, electronic equipment and media | |
| CN108108986B (en) | Design method and device of customer relationship management system and electronic equipment | |
| US20150317572A1 (en) | On-Demand Enrichment of Business Data | |
| US20200097591A1 (en) | Automated Data Enrichment and Signal Detection for Exploring Dataset Values | |
| US11442930B2 (en) | Method, apparatus, device and storage medium for data aggregation | |
| CN113419789A (en) | Method and device for generating data model script | |
| CN111382256A (en) | Information recommendation method and device | |
| CN108153834B (en) | Method and device for querying data by commercial intelligent application and electronic equipment | |
| US8793272B2 (en) | Query transformation | |
| US9146958B2 (en) | System and method for report to report generation |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP02 | Change in the address of a patent holder |
Address after: 510000 room 23bd, No. 109, system West Road, Tianhe District, Guangzhou City, Guangdong Province Patentee after: GUANGZHOU XUANWU WIRELESS TECHNOLOGY Co.,Ltd. Address before: 32B, no.103b, TianLiHe Road, Guangzhou, 510000 Patentee before: GUANGZHOU XUANWU WIRELESS TECHNOLOGY Co.,Ltd. |
|
| CP02 | Change in the address of a patent holder |