CN105404665A - JSON format data query management system - Google Patents
JSON format data query management system Download PDFInfo
- Publication number
- CN105404665A CN105404665A CN201510769650.7A CN201510769650A CN105404665A CN 105404665 A CN105404665 A CN 105404665A CN 201510769650 A CN201510769650 A CN 201510769650A CN 105404665 A CN105404665 A CN 105404665A
- Authority
- CN
- China
- Prior art keywords
- data
- formatted data
- json
- json formatted
- database
- 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.)
- Granted
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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a JSON format data query management system, aiming to improve the efficiency of querying JSON format data. In the system, a communication connection is established between an application client and an application server; a communication connection is established between the application server and a database server; the database server converts a data storage format of a data table in a database according to the JSON format required by the application client, so as to obtain a JSON format data view corresponding to the data table; the application client sends a JSON format data query request to the application server; the application server sends an SQL query statement to the database server; the database server acquires JSON format data displayed by the JSON format data view from the database according to the SQL query statement and sends the JSON format data to the application server; and the application client receives the JSON format data forwarded by the application server, and displays the JSON format data to a user.
Description
Technical field
The present invention relates to field of computer technology, be specifically related to a kind of inquiry management system of JSON formatted data.
Background technology
English full name: the JavaScriptObjectNotation of JSON() be a kind of data interchange format of lightweight.It is based on JavaScript(StandardECMA-2623rdEdition-December1999) a subset.JSON adopts the text formatting being totally independent of language, but also using the custom being similar to C language, the data interchange language that these characteristics make JSON become desirable, and it is easy to people and reads and write, and is also easy to machine simultaneously and resolves and generate.
JSON has the features such as the data scale of construction is little, Internet Transmission block, convenient conversion, is the general data transformat of current internet, applications data transmission.But what store in relational database general at present is all table data, the client of front end applications directly cannot inquire the data layout required for client from relational database, if want the inquiry needs existing database transformation being met to above-mentioned client, the database of bottom must be replaced to the database supporting that JSON data store, such as need to replace with: MongoDB, the databases such as Oracle12c, and the system reform workload of underlying database is huger, and the stability of system also cannot be protected in the process of transformation.
When current network application needs to obtain data, usually application server request of data condition being sent to backstage is needed, application server is to database server data query, application server is sent to the client of front end applications again after the table data returned from database server is integrated into JSON format string, existing data enquire method is all suitable for than being easier to for the network application of relational data, but at least there is following shortcoming: the client of front end applications needs by means of application server to complete the assembling of JSON format string, and when assembling JSON format string, application server needs all table datas inquired in ergodic data storehouse could synthesize JSON format string, this is consuming time and little for this step traveled through of inquiry that data volume in database is less, but the traversal of data often affects the response speed of whole system time larger for data query amount, this can reduce the efficiency of inquiry JSON format string greatly.
Summary of the invention
The object of the present invention is to provide a kind of inquiry management system of JSON formatted data, for improving the search efficiency of inquiry JSON formatted data.
In order to achieve the above object, the present invention adopts so following technical scheme:
The invention provides a kind of inquiry management system of JSON formatted data, comprise: applications client, application server and database server, set up between described applications client and described application server and have communication connection, set up between described application server and described database server and have communication connection, wherein
Described database server, carries out data memory format conversion for the JSON form needed according to described applications client to the tables of data in database, obtains the JSON formatted data view that described tables of data is corresponding;
Described applications client, for obtaining the JSON formatted data inquiry request of user's input, and sends to described application server by described JSON formatted data inquiry request;
Described application server, for receiving the JSON formatted data inquiry request that described applications client sends, generating SQL query statement according to described JSON formatted data inquiry request, and sending described SQL query statement to described database server;
Described database server, also for receiving the SQL query statement that described application server sends, from described database, get the JSON formatted data of described JSON formatted data view display according to described SQL query statement, send described JSON formatted data to described application server;
Described application server, also for receiving the described JSON formatted data that described database server sends, and forwards described JSON formatted data to described applications client;
Described applications client, also for receiving the described JSON formatted data that described application server forwards, shows described JSON formatted data to described user.
After adopting technique scheme, technical scheme provided by the invention will have the following advantages:
In the inquiry management system of the JSON formatted data provided in the embodiment of the present invention, the JSON form that can need according to applications client due to database server carries out data memory format conversion to the tables of data in database, obtain the JSON formatted data view that tables of data is corresponding, therefore when applications client initiates inquiry request, application server sends SQL query statement according to this inquiry request to database server, database server can get the JSON formatted data of JSON formatted data view display according to SQL query statement, application server only needs the JSON formatted data returned by database server to be transmitted to applications client, and carry out the assembling of JSON form when inquiring about at every turn without the need to application server, avoid the workload of the assembling JSON formatted data of application server, and database server only needs the conversion of the data memory format of database self, as long as and the conversion disposable transformation in database, without the need to all carrying out independent conversion to each inquiry request, the JSON form query display to database data is realized when keeping the inquiry mode of applications client constant, application server is not needed to carry out the character string assembling of JSON form according to each inquiry request, improve the search efficiency of inquiry JSON formatted data.
Accompanying drawing explanation
Fig. 1 provides a kind of composition structural representation of inquiry management system of JSON formatted data for the embodiment of the present invention;
Fig. 2 provides the process schematic inquiring about JSON formatted data in the inquiry management system of JSON formatted data for the embodiment of the present invention;
A kind of query script example schematic of dictionary table in the database that Fig. 3 provides for the embodiment of the present invention;
Fig. 4 carries out the view query example schematic after data memory format conversion for the dictionary table that the embodiment of the present invention provides.
Embodiment
Embodiments provide a kind of inquiry management system of JSON formatted data, for improving the search efficiency of inquiry JSON formatted data.
For making goal of the invention of the present invention, feature, advantage can be more obvious and understandable, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, the embodiments described below are only the present invention's part embodiments, and not all embodiments.Based on the embodiment in the present invention, the every other embodiment that those skilled in the art obtains, all belongs to the scope of protection of the invention.
Term in instructions of the present invention and claims and above-mentioned accompanying drawing " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, to comprise the process of a series of unit, method, system, product or equipment being not necessarily limited to those unit, but can comprise clearly do not list or for intrinsic other unit of these processes, method, product or equipment.
Below be described in detail respectively.
An embodiment of the inquiry management system of JSON formatted data of the present invention, can be applicable to the scene of the JSON formatted data inquiry that applications client is initiated, refer to shown in Fig. 1, the inquiry management system 100 of JSON formatted data provided by the invention, comprise: applications client 101, application server 102 and database server 103, set up between applications client 101 and application server 102 and have communication connection, set up between application server 102 and database server 103 and have communication connection, wherein
Database server 103, carries out data memory format conversion for the JSON form needed according to applications client 101 to the tables of data in database, obtains the JSON formatted data view that tables of data is corresponding;
Applications client 101, for obtaining the JSON formatted data inquiry request of user's input, and sends to application server 102 by JSON formatted data inquiry request;
Application server 102, for receiving the JSON formatted data inquiry request that applications client 101 sends, according to JSON formatted data inquiry request generating structured query language (StructuredQueryLanguage, SQL) query statement, and send SQL query statement to database server 103;
Database server 103, also for receiving the SQL query statement that application server 102 sends, getting the JSON formatted data of JSON formatted data view display, sending JSON formatted data to application server 102 from database according to SQL query statement;
Application server 102, also for receiving the JSON formatted data that database server 103 sends, and forwards JSON formatted data to applications client 101;
Applications client 101, also for receiving the JSON formatted data that application server 102 forwards, shows JSON formatted data to user.
In embodiments of the present invention, database server in a database data table memory time first can carry out data memory format conversion to this tables of data, the JSON form needed according to applications client is needed to change during data memory format conversion, it is JSON formatted data view by data table transmition, therefore database server can by disposable transformation during data table memory in a database in embodiments of the present invention, thus obtain JSON formatted data view, when subsequent applications client needs data query, database server directly can return the JSON formatted data of JSON formatted data view display.Embodiment of the present invention database server according to the JSON form that needs of applications client can be pre-configured JSON form, also can be the JSON form that this applications client directly got from applications client needs.
In embodiments of the present invention, the JSON formatted data view stored in database can demonstrate corresponding JSON formatted data, JSON formatted data view can be a query SQL statement, for showing the related data in one or more table or other views, the result that one is inquired about uses as a table by this JSON formatted data view, therefore JSON formatted data view can be counted as inquiry or a Virtual table of storage, JSON formatted data view derives from tables of data, JSON formatted data view is a Query Result inherently, therefore when applications client initiates inquiry request, database server can return JSON formatted data corresponding to JSON formatted data view to this applications client, eliminate the workload of the assembling JSON format string of application server in prior art, can using application server as a pure forwarding instrument in the embodiment of the present invention, thus reduce the load of application server, improve the search efficiency of applications client inquiry JSON formatted data.
In embodiments of the present invention, can adopt based on a kind of dynamic translation to the data query result in relational database, the JSON form that client is needed can carry out dynamic translation according to custom data form.By the JSON formatted data view that stores in database, specific tables of data is carried out to the different definition of data layout, the displaying of the different-format to same tables of data can be realized, meet user inquires about multiple JSON formatted data needs by applications client.
In the prior art, because application server is the assembling according to the inquiry request of each applications client, the table data inquired in database being carried out to JSON format string, therefore the assembling of application server to JSON form is changeless, if when the JSON form that the applications client of front end needs needs to adjust, application server also needs to increase newly and revises JSON packing algorithm, along with the continuous increase of systemic-function, the assembling form of required JSON also can along with increase, and this is unfavorable for that the function in system later stage is safeguarded.In order to further solve this problem, in some embodiments of the invention, database server, also for after the JSON Format adjusting that applications client needs, according to the JSON form after adjustment, the JSON formatted data view in database is modified, and the JSON formatted data view in a database after memory modify.
In embodiments of the present invention, can adopt based on a kind of dynamic translation to the data query result in relational database, the JSON form that client is needed can carry out dynamic translation according to custom data form.If if when the applications client of front end needs to adjust the form of JSON, data code in the database of database service management is without the need to adjusting, as long as modify to the corresponding JSON formatted data view in database, therefore the embodiment of the present invention can realize the de-lotus root of JSON format configuration and service code, drastically increases the maintainability of system.
In some embodiments of the invention, database server is when obtaining JSON formatted data view, and database service implement body can realize in the following way.Database server specifically for extracting the data composition data model meeting prerequisite from the tables of data in database; Row in usage data storehouse turns array function and the data model extracted is created as JSON formatted data view corresponding to tables of data.Wherein, tables of data in the embodiment of the present invention in database first carrys out garbled data according to prerequisite, by the data composition data model filtered out, such as prerequisite can be the content field needing to select from tables of data, specifically come pre-configured as required, the content not meeting prerequisite can filter out from tables of data, thus can get a data model.Usually there is row in a database and turns array function, such as, WMSYS.WM_CONCAT, or sys_connect_by_path etc. can data conversion in complete paired data model.By to the data in data model according to the structure of table and the conversion that puts in order, JSON formatted data view can be created out.
Further, state before this invention in the inquiry management system of the JSON formatted data described in embodiment, the tables of data in database is specially dictionary table.Such as, when database is specially oracle database, above-mentioned tables of data can refer to dictionary table.Dictionary table is the catalogue of the database of record that can access of user and application metadata.Little but the operation table the most frequently of the data volume of dictionary table shared by whole application the inside, dictionary table is converted to JSON formatted data view, application server all needs to assemble JSON formatted data process when each inquiry of applications client can be reduced.
In some embodiments of the invention, applications client, sends to application server specifically for adopting the interactive mode of asynchronous AJAX by JSON formatted data inquiry request.Wherein, AJAX is " AsynchronousJavascriptAndXML " (asynchronous JavaScript and XML), it is a kind of inquiry request mode creating interaction network page application, by asynchronous AJAX mode, transmission and the reception of JSON formatted data inquiry request between applications client and application server, can be realized.It should be noted that, applications client adopts the mode of asynchronous AJAX to send inquiry request just a kind of preferred implementation in embodiments of the present invention, in other embodiments of the present invention, applications client can also adopt other request send mode, the mode of JQuery+webservice such as can also be adopted to complete the transmission of inquiry request, and specific implementation can connected applications scene be determined.
By aforementioned to of the present invention illustrate known, in the inquiry management system of the JSON formatted data provided in the embodiment of the present invention, the JSON form that can need according to applications client due to database server carries out data memory format conversion to the tables of data in database, obtain the JSON formatted data view that tables of data is corresponding, therefore when applications client initiates inquiry request, application server sends SQL query statement according to this inquiry request to database server, database server can get the JSON formatted data of JSON formatted data view display according to SQL query statement, application server only needs the JSON formatted data returned by database server to be transmitted to applications client, and carry out the assembling of JSON form when inquiring about at every turn without the need to application server, avoid the workload of the assembling JSON formatted data of application server, and database server only needs the conversion of the data memory format of database self, as long as and the conversion disposable transformation in database, without the need to all carrying out independent conversion to each inquiry request, the JSON form query display to database data is realized when keeping the inquiry mode of applications client constant, application server is not needed to carry out the character string assembling of JSON form according to each inquiry request, improve the search efficiency of inquiry JSON formatted data.
For ease of better understanding and implement the such scheme of the embodiment of the present invention, corresponding application scenarios of illustrating below is specifically described.
Refer to shown in Fig. 2, for the embodiment of the present invention provides the process schematic inquiring about JSON formatted data in the inquiry management system of JSON formatted data.To be described the data query in relational database.To there being a row to turn the operation of row in the process of data query in relational database, such as relational database can be Oracle, MSSQL, MySql etc., can turn row operation in these databases by completing row.The embodiment of the present invention sets forth the query conversion flow process of data with the dictionary table mode of operation of oracle database, and other relational databases can complete corresponding data query result according to following flow process.
In large database, need to manage various categorical data (as the type of merchandise, type of play etc.).For the management of these types, go to safeguard if all set up a table for each type, that workload can to think and big, and need to go the name understanding each type list, to realize the association between multiple type list.Therefore need a kind of data model to complete the demand to varied type management, this data model is exactly dictionary table.
The data volume of dictionary table shared by whole application the inside is little, but an operation table the most frequently, data layout major part due to front end demand is all JSON form, and the data of inquiring about from relational database in prior art just can meet the requirement of the applications client of front end after all needing the two times transfer of application server, application server is caused to need to carry out conversion operations frequently to table data same in database, could adapt to the demand of JSON form, and conversion operations can waste the performance of system frequently.
The embodiment of the present invention replaces the data in application server to change by the conversion of the data memory format of database self, as long as and conversion disposable transformation in database, without the need to carrying out independent conversion to each query manipulation.Avoid the workload that application server in prior art needs to carry out data conversion, and the operation of itself is also disposable on database server impact, and the number of requests of front end applications do not have positively related relation.
In the inquiry management system of the JSON formatted data that the embodiment of the present invention provides, with oracle database as operation example, other relational databases can realize corresponding effect according to following steps.The list structure of the dictionary table of analytical database, extracts the data models such as the dictionary value of qualified dictionary type, dictionary title and correspondence, can comprise following several step:
1) the dictionary table TBL_CFG_DICT structure, in tentation data storehouse as shown in Figure 3, is a kind of query script example schematic of dictionary table in the database that the embodiment of the present invention provides.As long as the field such as content field DICTTYPE, DICTNAME, DICTVALUE when creating view, other are used as filtration and sequence.The result that data query goes out is as shown in table 1 below:
2), the row that carries of oracle database is used to turn array function WMSYS.WM_CONCAT and according to the structure of tables of data with put in order and create the JSON formatted data view VIEW_DICT of dictionary table.As shown in Figure 4, the dictionary table provided for the embodiment of the present invention carries out the view query example schematic after data memory format conversion to view query result.For the view query of safe and secret work order _ state.The SQL statement created is as follows:
createorreplaceviewview_dictas
selectt.dicttype,
’{type:”combobox”，options:{’’data’’:[’‖
wmsys.wm_concat(’{”value’’:’’’‖t.dictvalue‖’’’,text:”’‖
t.dictname‖’’’}’)‖’]}}’asPropertyGridValue,
’［’‖wmsys.wm_concat(’{’’id’’:”’‖t.dictvalue‖’’’,text:’’’‖
t.dictname‖”’}’)‖’’］’asComboxValue
fromTBL_CFG_DICTt
wheret.dictvalueisnotnull
groupbyt.dicttype;
3) the JSON format needs that the code, creating JSON formatted data view can need according to the applications client of front end specifically adjusts, and whole adjustment process all can not produce amendment to the data code in database, as long as the adjust structure synthesis SQL statement of JSON form front end applications client needed also passes to database server, database server just can be waited for after modifying to JSON formatted data view and inquire JSON formatted data.
In the inquiry management system of the JSON formatted data that the embodiment of the present invention provides, the JSON form that database server needs according to applications client carries out data memory format conversion to the tables of data in database, after obtaining JSON formatted data view corresponding to tables of data, the inquiry management system of JSON formatted data is to the query conversion process of JSON formatted data, mainly comprise following step, its process as shown in Figure 2:
Step one, applications client obtain the JSON formatted data query demand of user's input by front-end interface, and JSON formatted data inquiry request is sent to application server.
Step 2, application server convert SQL query statement to according to the inquiry request that applications client sends and are sent to database server.
JSON format view in the SQL statement Query Database that step 3, database server send according to application server.
The JSON format view that step 4, database server ergodic data library inquiry arrive, gets the JSON formatted data that this JSON format view is corresponding, and sends JSON formatted data to application server.
The JSON formatted data that database server returns by step 5, application server is transmitted to applications client.Due to the inherently JSON formatted data of the Query Result in database, so application server only needs the applications client result of data base querying intactly being returned to front end, in conventionally, expend performance again at ergodic data storehouse and assembling JSON format string.If the applications client of front end has also without the need to the data code in Update Table storehouse when needing amendment JSON form, as long as carried out adjusting by the form of the JSON formatted data view in database.
Step 6, applications client receive the JSON formatted data that application server forwards, and are shown to user to this JSON formatted data.
By aforementioned illustrate known, the embodiment of the present invention turns the conversion operations of row by means of the row of relational database, convert the data of script list storage state to JSON form by pictorial representation to store, the JSON form inquiry realized when keeping original inquiry mode constant database data is shown.And define the different-format Dynamic Display that can realize same data source by the different-format of JSON data layout view, not only increase the overall data operating performance of system, and achieve the configuration of data and the de-coupling of logical code, greatly reduce the maintenance cost in system later stage.
It should be noted that in addition, device embodiment described above is only schematic, the wherein said unit illustrated as separating component or can may not be and physically separates, parts as unit display can be or may not be physical location, namely can be positioned at a place, or also can be distributed in multiple network element.Some or all of module wherein can be selected according to the actual needs to realize the object of the present embodiment scheme.In addition, in device embodiment accompanying drawing provided by the invention, the annexation between module represents to have communication connection between them, specifically can be implemented as one or more communication bus or signal wire.Those of ordinary skill in the art, when not paying creative work, are namely appreciated that and implement.
Through the above description of the embodiments, those skilled in the art can be well understood to the mode that the present invention can add required common hardware by software and realize, and can certainly comprise special IC, dedicated cpu, private memory, special components and parts etc. realize by specialized hardware.Generally, all functions completed by computer program can realize with corresponding hardware easily, and the particular hardware structure being used for realizing same function also can be diversified, such as mimic channel, digital circuit or special circuit etc.But under more susceptible for the purpose of the present invention condition, software program realizes is better embodiment.Based on such understanding, technical scheme of the present invention can embody with the form of software product the part that prior art contributes in essence in other words, this computer software product is stored in the storage medium that can read, as the floppy disk of computing machine, USB flash disk, portable hard drive, ROM (read-only memory) (ROM, Read-OnlyMemory), random access memory (RAM, RandomAccessMemory), magnetic disc or CD etc., comprising some instructions in order to make a computer equipment (can be personal computer, server, or the network equipment etc.) perform method described in the present invention each embodiment.
In sum, above embodiment only in order to technical scheme of the present invention to be described, is not intended to limit; Although with reference to above-described embodiment to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in the various embodiments described above, or carries out equivalent replacement to wherein portion of techniques feature; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.
Claims (5)
1. the inquiry management system of a JSON formatted data, it is characterized in that, the inquiry management system of described JSON formatted data, comprise: applications client, application server and database server, set up between described applications client and described application server and have communication connection, set up between described application server and described database server and have communication connection, wherein
Described database server, carries out data memory format conversion for the JSON form needed according to described applications client to the tables of data in database, obtains the JSON formatted data view that described tables of data is corresponding;
Described applications client, for obtaining the JSON formatted data inquiry request of user's input, and sends to described application server by described JSON formatted data inquiry request;
Described application server, for receiving the JSON formatted data inquiry request that described applications client sends, generating SQL query statement according to described JSON formatted data inquiry request, and sending described SQL query statement to described database server;
Described database server, also for receiving the SQL query statement that described application server sends, from described database, get the JSON formatted data of described JSON formatted data view display according to described SQL query statement, send described JSON formatted data to described application server;
Described application server, also for receiving the described JSON formatted data that described database server sends, and forwards described JSON formatted data to described applications client;
Described applications client, also for receiving the described JSON formatted data that described application server forwards, shows described JSON formatted data to described user.
2. the inquiry management system of a kind of JSON formatted data according to claim 1, it is characterized in that, described database server, also for after the JSON Format adjusting that described applications client needs, according to the JSON form after adjustment, the JSON formatted data view in described database is modified, and the JSON formatted data view in the database after memory modify.
3. the inquiry management system of a kind of JSON formatted data according to claim 1, is characterized in that, described database server, specifically for extracting the data composition data model meeting prerequisite from the tables of data in described database; Use the row in described database to turn array function and the described data model extracted is created as JSON formatted data view corresponding to described tables of data.
4. the inquiry management system of a kind of JSON formatted data according to any one of claim 1 to 3, it is characterized in that, the tables of data in described database is specially dictionary table.
5. the inquiry management system of a kind of JSON formatted data according to any one of claim 1 to 3, it is characterized in that, described applications client, sends to described application server specifically for adopting the interactive mode of asynchronous AJAX by described JSON formatted data inquiry request.
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 true CN105404665A (en) | 2016-03-16 |
| CN105404665B 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) |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107154943A (en) * | 2017-05-22 | 2017-09-12 | 上海华测导航技术股份有限公司 | A kind of real-time navigation system for comprehensive security protection |
| 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 |
| CN107577802A (en) * | 2017-09-25 | 2018-01-12 | 山东浪潮商用***有限公司 | A kind of data base management method and device |
| CN107688659A (en) * | 2017-09-08 | 2018-02-13 | 北京奇艺世纪科技有限公司 | A kind of data processing method and device |
| CN107766393A (en) * | 2016-08-22 | 2018-03-06 | ***通信集团内蒙古有限公司 | Information processing method, client and server based on database |
| CN108073401A (en) * | 2017-12-29 | 2018-05-25 | 广州市玄武无线科技股份有限公司 | The execution method, apparatus and electronic equipment of a kind of service logic |
| CN108073590A (en) * | 2016-11-10 | 2018-05-25 | 北京国双科技有限公司 | The management method and device of document database |
| CN108153834A (en) * | 2017-12-14 | 2018-06-12 | 广州市玄武无线科技股份有限公司 | A kind of method, apparatus and electronic equipment of business intelligence application query data |
| CN109408580A (en) * | 2018-10-31 | 2019-03-01 | 北京百分点信息科技有限公司 | A kind of SQL compilation device and method across data source |
| CN109522307A (en) * | 2018-09-25 | 2019-03-26 | 中国平安人寿保险股份有限公司 | Server, the declaration form data query method based on Mongodb and storage medium |
| CN110191146A (en) * | 2019-03-21 | 2019-08-30 | 北京北信源软件股份有限公司 | A kind of long-range retrieval method of file based on browser and system |
| CN110865973A (en) * | 2018-08-08 | 2020-03-06 | 马上消费金融股份有限公司 | Data processing method and equipment and related device |
| CN111291074A (en) * | 2020-02-27 | 2020-06-16 | 北京思特奇信息技术股份有限公司 | Database query method, system, medium and device |
| CN111708784A (en) * | 2020-06-18 | 2020-09-25 | 辽宁振兴银行股份有限公司 | Universal row-to-column processing method |
| CN112559606A (en) * | 2019-09-26 | 2021-03-26 | 北京国双科技有限公司 | Conversion method and conversion device for JSON format data |
| CN112905687A (en) * | 2021-03-26 | 2021-06-04 | 深圳壹账通智能科技有限公司 | Data conversion method and device, electronic equipment and storage medium |
| CN110110150B (en) * | 2018-01-04 | 2023-07-07 | 北大医疗信息技术有限公司 | XML data reading method, reading device, computer equipment and storage medium |
Citations (5)
| 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 |
| US20140214809A1 (en) * | 2004-09-17 | 2014-07-31 | First American Financial Corporation | Method and system for query transformation for managing information from multiple datasets |
| CN104573115A (en) * | 2015-02-04 | 2015-04-29 | 新余兴邦信息产业有限公司 | Method and system for achieving integration interface supporting operation of multi-type databases |
-
2015
- 2015-11-12 CN CN201510769650.7A patent/CN105404665B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140214809A1 (en) * | 2004-09-17 | 2014-07-31 | First American Financial Corporation | Method and system for query transformation for managing information from multiple datasets |
| 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 |
|---|
| 《无线电通信技术》 * |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107766393A (en) * | 2016-08-22 | 2018-03-06 | ***通信集团内蒙古有限公司 | Information processing method, client and server based on database |
| 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 |
| CN108153834A (en) * | 2017-12-14 | 2018-06-12 | 广州市玄武无线科技股份有限公司 | A kind of method, apparatus and electronic equipment of business intelligence application query data |
| CN108073401A (en) * | 2017-12-29 | 2018-05-25 | 广州市玄武无线科技股份有限公司 | The execution method, apparatus and electronic equipment of a kind of service logic |
| 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 |
| CN110865973A (en) * | 2018-08-08 | 2020-03-06 | 马上消费金融股份有限公司 | 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 |
| CN109408580A (en) * | 2018-10-31 | 2019-03-01 | 北京百分点信息科技有限公司 | A kind of SQL compilation device and method across data source |
| 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 |
| CN111291074A (en) * | 2020-02-27 | 2020-06-16 | 北京思特奇信息技术股份有限公司 | Database query method, system, medium and device |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105404665B (en) | 2019-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105404665A (en) | JSON format data query management system | |
| CN110032604B (en) | Data storage device, translation device and database access method | |
| CN104123374B (en) | The method and device of aggregate query in distributed data base | |
| JP6761112B2 (en) | Methods and systems for server-side rendering of native content for presentation | |
| CN111177231B (en) | Report generation method and report generation device | |
| CN106407250B (en) | Information query method, device, system, server and client | |
| CN102521416B (en) | Data correlation query method and data correlation query device | |
| CN110633292A (en) | Query method, device, medium, equipment and system for heterogeneous database | |
| US20160314394A1 (en) | Method and device for constructing event knowledge base | |
| CN103955538A (en) | HBase data persistence and query methods and HBase system | |
| CN109902087B (en) | Data processing method and device for questions and answers and server | |
| CN104699742A (en) | Extreme visualization enabling extension for large data sets | |
| US20170060910A1 (en) | System and method of generating platform-agnostic abstract syntax tree | |
| CN109299219A (en) | Data query method, apparatus, electronic equipment and computer readable storage medium | |
| US20170060977A1 (en) | Data preparation for data mining | |
| CN111026931A (en) | Data query method, device, equipment and medium | |
| CN105302842A (en) | Data processing method and device | |
| CN109271428A (en) | Data pick-up method and method for exhibiting data based on geography information | |
| CN112949269A (en) | Method, system, equipment and storage medium for generating visual data analysis report | |
| US20140067853A1 (en) | Data search method, information system, and recording medium storing data search program | |
| US7529758B2 (en) | Method for pre-processing mapping information for efficient decomposition of XML documents | |
| CN105335466A (en) | Audio data retrieval method and apparatus | |
| CN100395752C (en) | Report data collection system and method | |
| CN113568923A (en) | Method and device for querying data in database, storage medium and electronic equipment | |
| CN111831684B (en) | Data query method, device and computer readable storage medium |
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. |