CN105404665B - A kind of inquiry management system of JSON formatted data - Google Patents
A kind of inquiry management system of JSON formatted data Download PDFInfo
- Publication number
- CN105404665B CN105404665B CN201510769650.7A CN201510769650A CN105404665B CN 105404665 B CN105404665 B CN 105404665B CN 201510769650 A CN201510769650 A CN 201510769650A CN 105404665 B CN105404665 B CN 105404665B
- Authority
- CN
- China
- Prior art keywords
- data
- formatted data
- json
- database
- json formatted
- 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
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/258—Data format conversion from or to a database
Abstract
The present invention discloses a kind of inquiry management system of JSON formatted data, improves the search efficiency of inquiry JSON formatted data.Within the system, establishing between applications client and application server has communication connection, establishing between application server and database server has communication connection, the JSON format that database server is needed according to applications client carries out data memory format conversion to the tables of data in database, obtains the corresponding JSON formatted data view of tables of data；JSON formatted data inquiry request is sent to application server by applications client, application server sends SQL query statement to database server, database server gets the JSON formatted data that JSON formatted data view is shown according to SQL query statement from database, JSON formatted data is sent to application server, applications client receives the JSON formatted data of application server forwarding, shows JSON formatted data to user.
Description
Technical field
The present invention relates to field of computer technology, and in particular to a kind of inquiry management system of JSON formatted data.
Background technique
JSON(full name in English: JavaScript Object Notation) be a kind of lightweight data interchange format.
It is based on a subset of JavaScript(Standard ECMA-262 3rd Edition-December 1999).
JSON uses the text formatting for being totally independent of language, but also uses the habit similar to C language, these characteristics make JSON
As ideal data interchange language, it is easy to people and reads and write, while is also easy to machine parsing and generating.
JSON has the characteristics that the data scale of construction is small, network transmission block, facilitates conversion, is current Internet application data transmission
Key data transformat.But that store in relational database general at present is all table data, the client of front end applications
End can not be directly from inquiring data format required for client in relational database, if it is desired to existing database into
Row is transformed to meet the inquiry needs of above-mentioned client, and the database of bottom must be substituted for the number for supporting the storage of JSON data
According to library, such as need to replace are as follows: the databases such as MongoDB, Oracle12c, and the system reform workload of underlying database is
Huger, and the stability of system can not also be protected during transformation.
When network application needs to obtain data at present, it usually needs send request of data condition to the application service on backstage
Device, application server inquire data, the table data that application server will be returned from database server to database server
It is integrated into the client for being transmitted to front end applications after JSON format string again, existing data query method is for relationship type
The network application of data is all easier to be applicable in, but at least have the following disadvantages: front end applications client need by means of
Come when completing the assembling of JSON format string, and assembling JSON format string, application server needs time application server
JSON format string could be synthesized by going through all table datas inquired in database, this is smaller for data volume in database
This traversal of inquiry the step of it is time-consuming and less, but it is larger for inquiry data volume when data traversal often will affect entirely
The response speed of system, the efficiency of inquiry JSON format string can be greatly reduced in this.
Summary of the invention
The purpose of the present invention is to provide a kind of inquiry management systems of JSON formatted data, for improving inquiry JSON lattice
The search efficiency of formula data.
In order to achieve the above object, the present invention uses such following technical solution:
The present invention provides a kind of inquiry management system of JSON formatted data, comprising: applications client, application server and
Database server, establishing between the applications client and the application server has communication connection, the application server
Establishing between the database server has communication connection, wherein
The database server, the JSON format for being needed according to the applications client is to the data in database
Table carries out data memory format conversion, obtains the corresponding JSON formatted data view of the tables of data；
The applications client, for obtaining the JSON formatted data inquiry request of user's input, and by the JSON lattice
Formula data inquiry request is sent to the application server；
The application server, the JSON formatted data inquiry request sent for receiving the applications client, according to
The JSON formatted data inquiry request generates SQL query statement, and sends the SQL query language to the database server
Sentence；
The database server is also used to receive the SQL query statement that the application server is sent, according to described
SQL query statement gets the JSON formatted data that the JSON formatted data view is shown, Xiang Suoshu from the database
Application server sends the JSON formatted data；
The application server, is also used to receive the JSON formatted data that the database server is sent, and to
The applications client forwards the JSON formatted data；
The applications client is also used to receive the JSON formatted data of the application server forwarding, Xiang Suoshu
User shows the JSON formatted data.
After adopting the above technical scheme, technical solution provided by the invention will have the following advantages:
In the inquiry management system of JSON formatted data provided in an embodiment of the present invention, since database server can be with
The JSON format needed according to applications client carries out data memory format conversion to the tables of data in database, obtains tables of data
Corresponding JSON formatted data view, therefore when applications client initiates inquiry request, application server is asked according to the inquiry
It asks to database server and sends SQL query statement, database server can get JSON format according to SQL query statement
The JSON formatted data that Data View is shown, the JSON formatted data that application server only needs to return to database server turn
Applications client is issued, the assembling of JSON format is carried out in each inquiry without application server, avoids application
The workload of the assembling JSON formatted data of server, and database server only needs the data of database itself to store lattice
The conversion of formula, as long as and the conversion disposable transformation in database, without each inquiry request is all carried out individually
Conversion, keep applications client inquiry mode it is constant in the case where realize the JSON format of database data is inquired it is aobvious
Show, does not need application server and assembled according to the character string that each inquiry request carries out JSON format, improve inquiry JSON format
The search efficiency of data.
Detailed description of the invention
Fig. 1 provides a kind of composed structure schematic diagram of the inquiry management system of JSON formatted data for the embodiment of the present invention；
Fig. 2 provides the mistake that JSON formatted data is inquired in the inquiry management system of JSON formatted data for the embodiment of the present invention
Journey schematic diagram；
Fig. 3 is a kind of query process example schematic of dictionary table in database provided in an embodiment of the present invention；
Fig. 4 is that dictionary table provided in an embodiment of the present invention carries out the view query citing signal after data memory format conversion
Figure.
Specific embodiment
The embodiment of the invention provides a kind of inquiry management systems of JSON formatted data, for improving inquiry JSON format
The search efficiency of data.
In order to make the invention's purpose, features and advantages of the invention more obvious and easy to understand, below in conjunction with the present invention
Attached drawing in embodiment, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that disclosed below
Embodiment be only a part of the embodiment of the present invention, and not all embodiments.Based on the embodiments of the present invention, this field
Technical staff's every other embodiment obtained, shall fall within the protection scope of the present invention.
Term " includes " in description and claims of this specification and above-mentioned attached drawing and " having " and they
Any deformation, it is intended that covering non-exclusive includes so as to a series of process, method comprising units, system, product or to set
It is standby to be not necessarily limited to those units, but be not clearly listed or these process, methods, product or equipment are consolidated
The other units having.
It is described in detail separately below.
One embodiment of the inquiry management system of JSON formatted data of the present invention can be applied to applications client initiation
The scene of JSON formatted data inquiry, refering to Figure 1, the inquiry management system of JSON formatted data provided by the invention
100, comprising: applications client 101, application server 102 and database server 103, applications client 101 and application service
Establishing between device 102 has communication connection, and establishing between application server 102 and database server 103 has communication connection,
In,
Database server 103, the JSON format for being needed according to applications client 101 is to the tables of data in database
Data memory format conversion is carried out, the corresponding JSON formatted data view of tables of data is obtained；
Applications client 101, for obtaining the JSON formatted data inquiry request of user's input, and by JSON formatted data
Inquiry request is sent to application server 102；
Application server 102, for receiving the JSON formatted data inquiry request of the transmission of applications client 101, according to
JSON formatted data inquiry request generates structured query language (Structured Query Language, SQL) and inquires language
Sentence, and SQL query statement is sent to database server 103；
Database server 103 is also used to receive the SQL query statement of the transmission of application server 102, according to SQL query
Sentence gets the JSON formatted data that JSON formatted data view is shown from database, sends to application server 102
JSON formatted data；
Application server 102 is also used to receive the JSON formatted data of the transmission of database server 103, and objective to application
Family end 101 forwards JSON formatted data；
Applications client 101 is also used to receive the JSON formatted data of the forwarding of application server 102, shows to user
JSON formatted data.
In embodiments of the present invention, database server in the database data table memory when can first to the tables of data into
The conversion of row data memory format, needs the JSON format needed according to applications client to be turned when data memory format is converted
Change, by data table transmition be JSON formatted data view, therefore in embodiments of the present invention database server can by
Disposable transformation in database when data table memory, so that JSON formatted data view is obtained, when subsequent applications client needs
When inquiring data, database server can directly return to the JSON formatted data that JSON formatted data view is shown.This hair
Bright embodiment database server according to applications client need JSON format can be preconfigured JSON format,
It can be the JSON format that the applications client being directly obtained from applications client needs.
In embodiments of the present invention, the JSON formatted data view stored in database can show corresponding JSON lattice
Formula data, JSON formatted data view can be a query SQL sentence, for showing in one or more tables or other views
Related data, which to use therefore JSON format number using the result that one is inquired as a table
The inquiry or a Virtual table of storage can be counted as according to view, JSON formatted data view derives from tables of data, JSON lattice
Itself is a query results for formula Data View, therefore when applications client initiates inquiry request, database server can
To return to the corresponding JSON formatted data of JSON formatted data view to the applications client, application clothes in the prior art are eliminated
Be engaged in device assembling JSON format string workload, can be pure using application server as one in the embodiment of the present invention
Forwarding tool improves the search efficiency of applications client inquiry JSON formatted data to reduce the load of application server.
In embodiments of the present invention, can turn using based on a kind of dynamic to the data query result in relational database
It changes, the JSON format that client is needed carries out dynamic translation according to custom data format.Pass through data
The JSON formatted data view stored in library carries out the different definition of data format to specific tables of data, may be implemented to same
The displaying of the different-format of a tables of data meets the needs that user inquires multiple JSON formatted datas by applications client.
Conventionally, as application server is according to the inquiry request of each applications client come in database
The table data inquired carries out the assembling of JSON format string, therefore application server is fixed to the assembling of JSON format
Constant, if the JSON format that the applications client of front end needs needs to adjust, application server is also needed newly-increased and is repaired
Change JSON packing algorithm, with being continuously increased for system function, the assembling format of required JSON also can be with increase, this is unfavorable for
The function in system later period is safeguarded.In order to further solve the problems, such as this, in some embodiments of the invention, database service
Device is also used to after the JSON Format adjusting that applications client needs, according to JSON format adjusted in database
JSON formatted data view is modified, and stores modified JSON formatted data view in the database.
In embodiments of the present invention, can turn using based on a kind of dynamic to the data query result in relational database
It changes, the JSON format that client is needed carries out dynamic translation according to custom data format.If front end
Applications client if necessary to data generation when being adjusted to the format of JSON, in the database of database server management
Code is without being adjusted, as long as modifying to the corresponding JSON formatted data view in database, therefore the present invention
The de- lotus root of JSON format configuration and service code may be implemented in embodiment, greatly improves the maintainability of system.
In some embodiments of the invention, database server is when obtaining JSON formatted data view, database clothes
Business implement body can be realized in the following way.Database server is specifically used for extracting from the tables of data in database
The data for meeting prerequisite constitute data model；Turn array function using the row in database to create the data model extracted
For the corresponding JSON formatted data view of tables of data.Wherein, the tables of data in the embodiment of the present invention in database is first according to preset
Condition carrys out garbled data, the data filtered out is constituted data model, such as prerequisite can be needs and select from tables of data
Content field out is pre-configured with specific reference to needing, and the content for being unsatisfactory for prerequisite can be filtered out from tables of data,
So as to get a data model.Usually turn array function in the presence of row in the database, for example, WMSYS.WM_CONCAT,
Or sys_connect_by_path etc. can data conversion in complete paired data model.By to the number in data model
According to the structure according to table and the conversion to put in order, it can be created that JSON formatted data view.
Further, it is stated in the inquiry management system of JSON formatted data described in embodiment before this invention, data
Tables of data in library is specially dictionary table.For example, when database is specially oracle database, what above-mentioned tables of data can refer to
It is dictionary table.Dictionary table is the catalogue of user's accessible database of record and application metadata.Dictionary table is entire
A but operation the most frequent table little using data volume shared by the inside, is converted to JSON formatted data for dictionary table
View, it is possible to reduce application server requires the process of assembling JSON formatted data in each inquiry of applications client.
In some embodiments of the invention, applications client, will specifically for the interactive mode using asynchronous AJAX
JSON formatted data inquiry request is sent to application server.Wherein, AJAX is " Asynchronous Javascript And
XML " (asynchronous JavaScript and XML) is a kind of inquiry request mode of creation interaction network page application, passes through asynchronous AJAX
Sending and receiving for JSON formatted data inquiry request may be implemented in mode between applications client and application server.It needs
Illustrate, it is a kind of excellent that applications client sends inquiry request by the way of asynchronous AJAX in embodiments of the present invention
The implementation of choosing, in other embodiments of the invention, applications client can also request sending methods using other,
Such as the transmission of inquiry request can also be completed by the way of JQuery+webservice, specific implementation can be tied
Application scenarios are closed to determine.
By it is aforementioned to illustration of the invention it is found that JSON formatted data provided in an embodiment of the present invention inquiry
In management system, since database server can be according to the JSON format that applications client needs to the tables of data in database
Data memory format conversion is carried out, obtains the corresponding JSON formatted data view of tables of data, therefore when applications client initiation is looked into
When asking request, application server sends SQL query statement to database server according to the inquiry request, and database server can
To get the JSON formatted data that JSON formatted data view is shown according to SQL query statement, application server only need by
The JSON formatted data that database server returns is transmitted to applications client, is inquiring every time without application server
The assembling of Shi Jinhang JSON format avoids the workload of the assembling JSON formatted data of application server, and database takes
Business device only need database itself data memory format conversion, as long as and the conversion disposable transformation in database be
Can, without all individually being converted to each inquiry request, in the situation for keeping the inquiry mode of applications client constant
The lower JSON format query display realized to database data does not need application server according to each inquiry request and carries out JSON
The character string of format assembles, and improves the search efficiency of inquiry JSON formatted data.
In order to facilitate a better understanding and implementation of the above scheme of the embodiment of the present invention, corresponding application scenarios of illustrating below come
It is specifically described.
It please refers to shown in Fig. 2, is provided for the embodiment of the present invention in the inquiry management system of JSON formatted data and inquire JSON
The process schematic of formatted data.It is illustrated for the data query in relational database.To looking into relational database
The operation for having a row to turn column in the processing of data is ask, such as relational database can be Oracle, MSSQL, MySql etc.,
It can turn column operation by completing row in these databases.The embodiment of the present invention is with the dictionary table handling side of oracle database
Formula illustrates that the inquiry flow path switch of data, other relational databases can complete corresponding data query according to following below scheme
As a result.
In large database, need to manage various categorical datas (such as type of merchandise, type of play).It is right
In the management of these types, a table is all established if it is each type and goes to safeguard, that workload be can think and big, and
Also need to understand the name of each type list, to realize the association between multiple type lists.Therefore a kind of data mould is needed
For type to complete the demand to varied type management, this data model is exactly dictionary table.
Dictionary table data volume shared inside entire application is little, but operates a table the most frequent, due to
It is all JSON format that the data format of front end demand is most of, and the data inquired from relational database in the prior art all need
The requirement that just can satisfy the applications client of front end after the two times transfer of application server is wanted, application server is caused to need pair
Same table data carries out frequent conversion operation in database, just adapts to the demand of JSON format, and frequently converts
Operation can waste the performance of system.
The embodiment of the present invention replaces the number in application server by the conversion of the data memory format of database itself
According to conversion, as long as and the conversion disposable transformation in database, without individually being turned to each inquiry operation
It changes.The workload that application server in the prior art needs to carry out data conversion is avoided, and the operation of itself is to database
Server influences to be also that disposable and front end applications number of requests do not have positively related relationship.
In the inquiry management system of JSON formatted data provided in an embodiment of the present invention, use oracle database as operation
Example, other relational databases can realize corresponding effect according to the following steps.The table knot of the dictionary table of analytical database
Structure extracts the data models such as qualified dictionary type, dictionary title and corresponding dictionary value, may include following several steps
It is rapid:
1) the dictionary table TBL_CFG_DICT structure in database, is assumed as shown in figure 3, being provided in an embodiment of the present invention
A kind of query process example schematic of dictionary table in database.As long as content field DICTTYPE when creating view,
The fields such as DICTNAME, DICTVALUE, other are used as filtering and sequence.The result that data query goes out is as shown in table 1 below:
2), turn array function WMSYS.WM_CONCAT and according to the structure of tables of data using the row that oracle database carries
With the JSON formatted data view VIEW_DICT for creating dictionary table that puts in order.View query result is as shown in figure 4, be this hair
The dictionary table that bright embodiment provides carries out the view query example schematic after data memory format conversion.With safe and secret work
For the view query of list _ state.The SQL statement of creation is as follows:
create or replace view view_dict as
select t.dicttype,
' { type: " combobox ", options:{ ' ' data ' ': [' ‖
wmsys.wm_concat(’{”value’’ :’’’ ‖t. dictvalue‖’’’,text:”’ ‖
t.dictname ‖’’’}’) ‖’]}}’as PropertyGridValue,
' ' ‖ wmsys. wm_concat (' ' ' id ' ': " ' ‖ t.dictvalue ‖ ' ' ', text: ' ' ' ‖
T.dictname ‖ " ' } ') ‖ ' ' ] ' as ComboxValue
from TBL_CFG_DICT t
where t. dictvalue is not null
group by t.dicttype;
3) the JSON format needs that the code of JSON formatted data view can be needed according to the applications client of front end, are created
It is specifically adjusted, and entirely adjustment process will not all generate modification to the data code in database, as long as by front end
The adjustment structure synthesis SQL statement for the JSON format that applications client needs simultaneously passes to database server, database
Server can wait after modifying to JSON formatted data view and inquire JSON formatted data.
In the inquiry management system of JSON formatted data provided in an embodiment of the present invention, database server is according to application visitor
The JSON format that family end needs carries out data memory format conversion to the tables of data in database, obtains the corresponding JSON of tables of data
After formatted data view, the inquiry management system of JSON formatted data is to the inquiry conversion process of JSON formatted data, mainly
Including following steps, process is as shown in Figure 2:
Step 1: applications client obtains the JSON formatted data query demand that user inputs by front-end interface, and will
JSON formatted data inquiry request is transmitted to application server.
It is sent out Step 2: application server is converted into SQL query statement according to the inquiry request that applications client is sent
It is sent to database server.
Step 3: database server inquires the JSON format in database according to the SQL statement that application server is sent
View.
Step 4: the JSON format view that database server ergodic data library inquiry arrives, gets JSON format view
Scheme corresponding JSON formatted data, and sends JSON formatted data to application server.
Step 5: the JSON formatted data that database server returns is transmitted to applications client by application server.By
Query result inherently JSON formatted data in database, so application server is only needed the knot of data base querying
Fruit intactly returns to the applications client of front end, without according to expending performance again in ergodic data in the prior art
Library and assembling JSON format string.If without modification when the applications client of front end modification JSON format in need
Data code in database, as long as the format of the JSON formatted data view in database is adjusted.
Step 6: applications client receives the JSON formatted data of application server forwarding, it is aobvious to the JSON formatted data
Show to user.
By aforementioned illustration it is found that the embodiment of the present invention turns the conversion operation of column by means of the row of relational database,
The data of script list storage state are converted into the storage of JSON format by pictorial representation, so that keeping original inquiry mode
It realizes to inquire the JSON format of database data in the case where constant and show.And pass through the difference of JSON data format view
Format defines the different-format Dynamic Display that may be implemented to same data source, not only increases the overall data operability of system
Can, and the configuration of data and the decoupling of logical code are realized, greatly reduce the maintenance cost in system later period.
In addition it should be noted that, the apparatus embodiments described above are merely exemplary, wherein described as separation
The unit of part description may or may not be physically separated, component shown as a unit can be or
It can not be physical unit, it can it is in one place, or may be distributed over multiple network units.It can be according to reality
Border needs to select some or all of the modules therein to achieve the purpose of the solution of this embodiment.In addition, provided by the invention
In Installation practice attached drawing, the connection relationship between module indicates there is communication connection between them, specifically can be implemented as one
Item or a plurality of communication bus or signal wire.Those of ordinary skill in the art are without creative efforts, it can
It understands and implements.
Through the above description of the embodiments, it is apparent to those skilled in the art that the present invention can borrow
Help software that the mode of required common hardware is added to realize, naturally it is also possible to by specialized hardware include specific integrated circuit, specially
It is realized with CPU, private memory, special components and parts etc..Under normal circumstances, all functions of being completed by computer program are ok
It is easily realized with corresponding hardware, moreover, being used to realize that the specific hardware structure of same function is also possible to a variety of more
Sample, such as analog circuit, digital circuit or special circuit etc..But software program is real in situations more for the purpose of the present invention
It is now more preferably embodiment.Based on this understanding, technical solution of the present invention substantially in other words makes the prior art
The part of contribution can be embodied in the form of software products, which is stored in the storage medium that can be read
In, such as the floppy disk of computer, USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory
Device (RAM, Random Access Memory), magnetic or disk etc., including some instructions are with so that a computer is set
Standby (can be personal computer, server or the network equipment etc.) executes method described in each embodiment of the present invention.
In conclusion the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although referring to upper
Stating embodiment, invention is explained in detail, those skilled in the art should understand that: it still can be to upper
Technical solution documented by each embodiment is stated to modify or equivalent replacement of some of the technical features；And these
It modifies or replaces, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution.
Claims (5)
1. a kind of inquiry management system of JSON formatted data, which is characterized in that the searching and managing system of the JSON formatted data
System, comprising: applications client, application server and database server, the applications client and the application server it
Between establish have communication connection, between the application server and the database server establish have communication connection, wherein
The database server, JSON format for being needed according to the applications client to the tables of data in database into
The conversion of row data memory format, obtains the corresponding JSON formatted data view of the tables of data, the tables of data in the database
The disposable transformation that is converted to of data memory format is carried out, the JSON formatted data view derives from tables of data, the JSON
Formatted data view is used as the Virtual table of query result；
The applications client, for obtaining the JSON formatted data inquiry request of user's input, and by the JSON format number
The application server is sent to according to inquiry request；
The application server, the JSON formatted data inquiry request sent for receiving the applications client, according to described
JSON formatted data inquiry request generates SQL query statement, and sends the SQL query statement to the database server；
The database server is also used to receive the SQL query statement that the application server is sent, is looked into according to the SQL
It askes sentence and gets the JSON formatted data that the JSON formatted data view is shown from the database, taken to the application
Business device sends the JSON formatted data；
The application server, is also used to receive the JSON formatted data that the database server is sent, and to described
Applications client forwards the JSON formatted data；
The applications client is also used to receive the JSON formatted data of the application server forwarding, Xiang Suoshu user
Show the JSON formatted data.
2. a kind of inquiry management system of JSON formatted data according to claim 1, which is characterized in that the database
Server is also used to after the JSON Format adjusting that the applications client needs, according to JSON format adjusted to institute
The JSON formatted data view stated in database is modified, and stores modified JSON formatted data in the database
View.
3. a kind of inquiry management system of JSON formatted data according to claim 1, which is characterized in that the database
Server meets the data composition data model of prerequisite specifically for extracting in tables of data from the database；
Turn array function using the row in the database and the data model extracted is created as the corresponding JSON of the tables of data
Formatted data view.
4. a kind of inquiry management system of JSON formatted data according to any one of claim 1 to 3, feature exist
In the tables of data in the database is specially dictionary table.
5. a kind of inquiry management system of JSON formatted data according to any one of claim 1 to 3, feature exist
In the applications client, specifically for being sent out the JSON formatted data inquiry request using the interactive mode of asynchronous AJAX
Give the application server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510769650.7A CN105404665B (en) | 2015-11-12 | 2015-11-12 | A kind of inquiry management system of JSON formatted data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510769650.7A CN105404665B (en) | 2015-11-12 | 2015-11-12 | A kind of inquiry management system of JSON formatted data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105404665A CN105404665A (en) | 2016-03-16 |
| CN105404665B true CN105404665B (en) | 2019-04-26 |
Family
ID=55470154
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510769650.7A Active CN105404665B (en) | 2015-11-12 | 2015-11-12 | A kind of inquiry management system of JSON formatted data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105404665B (en) |
Families Citing this family (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107766393B (en) * | 2016-08-22 | 2021-12-14 | 中国移动通信集团内蒙古有限公司 | Information processing method based on database, client and server |
| CN108073590A (en) * | 2016-11-10 | 2018-05-25 | 北京国双科技有限公司 | The management method and device of document database |
| CN107169103A (en) * | 2017-05-17 | 2017-09-15 | 南京焦点领动云计算技术有限公司 | A kind of universal architecture data store query method and system |
| CN107193021A (en) * | 2017-05-22 | 2017-09-22 | 上海华测导航技术股份有限公司 | A kind of real-time navigation method of comprehensive security protection |
| CN107154943A (en) * | 2017-05-22 | 2017-09-12 | 上海华测导航技术股份有限公司 | A kind of real-time navigation system for comprehensive security protection |
| CN107688659A (en) * | 2017-09-08 | 2018-02-13 | 北京奇艺世纪科技有限公司 | A kind of data processing method and device |
| CN107577802A (en) * | 2017-09-25 | 2018-01-12 | 山东浪潮商用系统有限公司 | A kind of data base management method and device |
| CN108153834B (en) * | 2017-12-14 | 2020-11-06 | 广州市玄武无线科技股份有限公司 | Method and device for querying data by commercial intelligent application and electronic equipment |
| CN108073401B (en) * | 2017-12-29 | 2020-09-15 | 广州市玄武无线科技股份有限公司 | Method and device for executing business logic and electronic equipment |
| CN110110150B (en) * | 2018-01-04 | 2023-07-07 | 北大医疗信息技术有限公司 | XML data reading method, reading device, computer equipment and storage medium |
| CN110865973B (en) * | 2018-08-08 | 2021-12-07 | 马上消费金融股份有限公司 | Data processing method and equipment and related device |
| CN109522307A (en) * | 2018-09-25 | 2019-03-26 | 中国平安人寿保险股份有限公司 | Server, the declaration form data query method based on Mongodb and storage medium |
| CN109408580B (en) * | 2018-10-31 | 2020-10-20 | 北京百分点信息科技有限公司 | Cross-data-source SQL compiling device and method |
| CN110191146A (en) * | 2019-03-21 | 2019-08-30 | 北京北信源软件股份有限公司 | A kind of long-range retrieval method of file based on browser and system |
| CN112559606A (en) * | 2019-09-26 | 2021-03-26 | 北京国双科技有限公司 | Conversion method and conversion device for JSON format data |
| CN111291074B (en) * | 2020-02-27 | 2023-03-28 | 北京思特奇信息技术股份有限公司 | Database query method, system, medium and device |
| CN111708784A (en) * | 2020-06-18 | 2020-09-25 | 辽宁振兴银行股份有限公司 | Universal row-to-column processing method |
| CN112905687A (en) * | 2021-03-26 | 2021-06-04 | 深圳壹账通智能科技有限公司 | Data conversion method and device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103389991A (en) * | 2012-05-09 | 2013-11-13 | 阿里巴巴集团控股有限公司 | Data interaction method, data interaction device, data conversion method and data conversion device |
| CN103440303A (en) * | 2013-08-21 | 2013-12-11 | 曙光信息产业股份有限公司 | Heterogeneous cloud storage system and data processing method thereof |
| CN103678575A (en) * | 2013-12-11 | 2014-03-26 | 四川九洲电器集团有限责任公司 | Method and system for achieving unified processing on multiple database data through middleware |
| CN104573115A (en) * | 2015-02-04 | 2015-04-29 | 新余兴邦信息产业有限公司 | Method and system for achieving integration interface supporting operation of multi-type databases |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8694532B2 (en) * | 2004-09-17 | 2014-04-08 | First American Data Co., Llc | Method and system for query transformation for managing information from multiple datasets |
-
2015
- 2015-11-12 CN CN201510769650.7A patent/CN105404665B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103389991A (en) * | 2012-05-09 | 2013-11-13 | 阿里巴巴集团控股有限公司 | Data interaction method, data interaction device, data conversion method and data conversion device |
| CN103440303A (en) * | 2013-08-21 | 2013-12-11 | 曙光信息产业股份有限公司 | Heterogeneous cloud storage system and data processing method thereof |
| CN103678575A (en) * | 2013-12-11 | 2014-03-26 | 四川九洲电器集团有限责任公司 | Method and system for achieving unified processing on multiple database data through middleware |
| CN104573115A (en) * | 2015-02-04 | 2015-04-29 | 新余兴邦信息产业有限公司 | Method and system for achieving integration interface supporting operation of multi-type databases |
Non-Patent Citations (1)
| Title |
|---|
| 倪睿熙."一种基于JSON 的异构数据查询方法".《无线电通信技术》.2013,第39卷(第1期),第73-76页. |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105404665A (en) | 2016-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105404665B (en) | A kind of inquiry management system of JSON formatted data | |
| US11068439B2 (en) | Unsupervised method for enriching RDF data sources from denormalized data | |
| US8612486B2 (en) | Configuration management visualization | |
| CN105359144B (en) | Natural Language Search result for intent query | |
| US11899681B2 (en) | Knowledge graph building method, electronic apparatus and non-transitory computer readable storage medium | |
| JP5873935B2 (en) | Database management method, management computer and storage medium | |
| US7711704B2 (en) | System and method of providing date, arithmetic and other relational functions for OLAP sources | |
| Lee et al. | SQL-to-NoSQL schema denormalization and migration: a study on content management systems | |
| CN107451109A (en) | Report form generation method and system | |
| US10803083B2 (en) | System and method of generating platform-agnostic abstract syntax tree | |
| JP2019530921A (en) | Method and system for server-side rendering of native content for presentation | |
| US9495437B1 (en) | System and method for accessing dimensional databases | |
| US20120331010A1 (en) | Systems And Methods For Performing A Query On A Distributed Database | |
| Bohlouli et al. | Towards an integrated platform for big data analysis | |
| US8732159B2 (en) | Generic outer join across database borders | |
| JP6849723B2 (en) | Methods and devices for generating information | |
| US20140330827A1 (en) | Methods and systems to operate on group-by sets with high cardinality | |
| US20170060977A1 (en) | Data preparation for data mining | |
| CN106294402A (en) | The data search method of a kind of heterogeneous data source and device thereof | |
| Kuderu et al. | Relational database to NoSQL conversion by schema migration and mapping | |
| CN111026931A (en) | Data query method, device, equipment and medium | |
| US20140067853A1 (en) | Data search method, information system, and recording medium storing data search program | |
| JP5597623B2 (en) | Database processing method | |
| US20190370375A1 (en) | Enabling data source extensions | |
| CN112818277A (en) | Webpage generation method and device, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into 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 | ||
| CP02 | Change in the address of a patent holder |
Address after: 362000 Fujian province Quanzhou Fengze District Feng Road South Building 2 building Patentee after: Linewell Software Co., Ltd. Address before: 362000 Fujian province Quanzhou Fengze District Feng Road South Building 4 Building Patentee before: Linewell Software Co., Ltd. |