CN108334609B - Method, device, equipment and storage medium for realizing JSON format data access in Oracle - Google Patents
Method, device, equipment and storage medium for realizing JSON format data access in Oracle Download PDFInfo
- Publication number
- CN108334609B CN108334609B CN201810107784.6A CN201810107784A CN108334609B CN 108334609 B CN108334609 B CN 108334609B CN 201810107784 A CN201810107784 A CN 201810107784A CN 108334609 B CN108334609 B CN 108334609B
- Authority
- CN
- China
- Prior art keywords
- json
- oracle
- key
- data
- format
- 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 OR CALCULATING; 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
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
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)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for realizing JSON format data access in Oracle, which comprises the following steps: reading JSON data and a key to be read of the JSON data; acquiring the position of the key to be read in the JSON data, and marking the position as a first index position; acquiring a first marker character' located after the first index position according to the first index position: "and is marked as a second index position; traversing the characters of the JSON data after the second index position until key characters detected in the traversing process are paired; and acquiring a value corresponding to the key to be read according to the position of the key character. The invention also discloses a device, equipment and a computer readable storage medium for realizing JSON format data access in Oracle, and the JSON format data can be conveniently accessed in Oracle.
Description
Technical Field
The invention relates to the field of databases, in particular to a method, a device, equipment and a storage medium for realizing JSON format data access in Oracle.
Background
Under the large development environment of the internet, JSON is widely applied as a lightweight and friendly format of Web services clients; oracle database products have a large share in the database industry, compared with Oracle12c issued only in 6 months in 2013, wherein Oracle11g, Oracle10g, Oracle9i and the like have a vast share; unfortunately, Oracle11g and earlier versions do not have a scheme to support the JSON data format.
The current scheme for supporting the JSON data format is the JSON _ ext library and the attached other libraries (hereinafter collectively referred to as the JSON _ ext library as a name). The method adopted during the conversion is as follows: firstly, converting the result data into an XML data format according to an XSL template, and then extracting and converting the data from the XML format into a JSON format. The data access and conversion path is as follows: string/number- > XLS- > XML- > custom JSON- > string/number.
However, the inventor finds that the current scheme has at least the following defects in the process of implementing the invention:
the internal implementation of a Json _ ext library refers to an XLS template and an XML format, and the format conversion is long;
the Json _ ext library and the auxiliary library are more, codes are redundant, internal calling is complex, and maintenance is difficult;
JSON data conversion speed of the Json _ ext library is low, and the JSON data conversion speed is particularly obvious in the environment with large data volume;
when the Json _ ext library is called, more Oracle database resources are occupied, and the high concurrency requirement of the Internet environment is difficult to deal with;
the Json _ ext library is abnormal when processing unknown data formats or special characters;
disclosure of Invention
In view of the above problems, an object of the present invention is to provide a method, an apparatus, a device and a storage medium for implementing JSON-formatted data access in Oracle, so as to implement convenient, fast and efficient storage and reading of JSON-formatted data in Oracle.
The embodiment of the invention provides a method for realizing JSON format data access in Oracle, which comprises the following steps:
reading JSON data and a key to be read of the JSON data;
acquiring the position of the key to be read in the JSON data, and marking the position as a first index position;
acquiring a first marker character' located after the first index position according to the first index position: "and is marked as a second index position;
traversing the characters of the JSON data after the second index position until key characters detected in the traversing process are paired;
and acquiring a value corresponding to the key to be read according to the position of the key character.
Preferably, the key characters include: "{" and "{" form a pair "}", "[" and "[" form a pair "]" "," "".
Preferably, before reading the JSON data and the key to be read of the JSON data, the method further includes:
and judging whether the JSON data meets the JSON standard format.
Preferably, when the JSON data is a JSON object array, the method further includes:
and acquiring the number of the objects of the value of the JSON object array and each object according to the logarithm of the key characters '{' and '}'.
Preferably, the method further comprises the following steps:
and deleting the value corresponding to the key to be read according to the position of the key character and the second index position.
Preferably, the method further comprises the following steps:
reading an Oracle character string;
acquiring keys of the Oracle character string and values corresponding to the keys, and storing the keys and the values into character strings in a JSON object format or character strings in a JSON array format.
Preferably, the method further comprises the following steps:
and converting the Oracle cursor into a character string in a JSON object format.
The embodiment of the invention also provides a device for realizing JSON format data access in Oracle, which comprises:
the data reading unit is used for reading JSON data and keys to be read of the JSON data;
the first index unit is used for acquiring the position of the key to be read in the JSON data and marking the position as a first index position;
a second indexing unit, configured to obtain, according to the first index position, a first marker character "located after the first index position: "and is marked as a second index position;
the traversal unit is used for traversing the characters behind the second index position of the JSON data until key characters are detected to appear in pairs in the traversal process;
and the value acquisition unit is used for acquiring a value corresponding to the key to be read according to the position of the key character.
The embodiment of the invention also provides a device for realizing JSON format data access in Oracle, which comprises a memory, a processor and a computer program stored in the memory, wherein the computer program can be executed by the processor to realize the method for realizing JSON format data access in Oracle.
Embodiments of the present invention further provide a computer-readable storage medium storing executable code, where the executable code is configured to be executed by at least one processor, so as to implement the method for implementing JSON-format data access in Oracle described above.
Drawings
In order to more clearly illustrate the technical solution of the present invention, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic flow chart of a method for implementing JSON-format data access in Oracle according to an embodiment of the present invention.
Fig. 2 is a schematic structural diagram of a device for implementing JSON-format data access in Oracle according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, an embodiment of the present invention provides a method for implementing JSON-formatted data access in Oracle, which can be executed by a device installed with an Oracle database, and includes the following steps:
s101, reading JSON data and a key to be read of the JSON data.
And S102, acquiring the position of the key to be read in the JSON data, and marking the position as a first index position.
S103, acquiring a first marker character' located after the first index position according to the first index position: "and is labeled as the second index position.
And S104, traversing the characters of the JSON data after the second index position until key characters are detected to appear in pairs in the traversing process.
And S105, acquiring a value corresponding to the key to be read according to the position of the key character.
In this embodiment, the device may be a computer, a SERVER, etc. which is installed with an Oracle database, and the Oracle database system is a set of software products provided by Oracle corporation of america (Oracle) and having a distributed database as a core, and is one of the most popular CLIENT/SERVER (CLIENT/SERVER) or B/S architecture databases at present. Such as SilverStream, is a database-based middleware. The Oracle database is the most widely used database management system in the world at present, is used as a general database system, and has a complete data management function; as a relational database, it is a complete relational product; it implements distributed processing functions as a distributed database. But all its knowledge can be used on various types of machines as long as it learns Oracle knowledge on one model.
Because Oracle11g and earlier versions do not support JSON data format, therefore, the embodiment of the invention creatively provides a series of light-weight functions and methods based on an Oracle built-in function and a PL/SQL technology (a procedural SQL language, which is a procedural extension of Oracle to a standard database language SQL, and connects the database technology and a procedural programming language, and is an application development language, and can use circulation and branch to process data, and combine the data manipulation function of SQL and a procedural language data processing function, and the use of PL/SQL makes SQL become a high-level programming language, and supports block operation, condition judgment, circulation statement, nesting and the like of the high-level language, and integrates with the data type of the database core, so that the SQL programming efficiency is higher), and the invention provides a series of functions and methods for developers to call, and realizes the mutual conversion of the Oracle data format and the JSON data format, the method can be universally used for Oracle products, can be called after compiling, and can be perfectly embedded into the Oracle products.
The following will illustrate the conversion process of the embodiment of the present invention with some examples:
assuming that current JSON data (JSON string) is' { "example": JSON "," key ": subKey": subValue "} and a key to be read is" key ", the device first obtains a position of the key to be read (" key ") in the JSON data after receiving the JSON data and marks the position as a first index position, wherein the device can obtain the position of the key to be read by traversing the JSON string. After obtaining the first index position, the device obtains a first marker character "located after the first index position: "and is labeled as the second index position. And then, the device traverses the characters after the second index position of the JSON data until the key characters detected in the traversing process all appear in pairs. Wherein the key character includes: "{" and "{" form a pair "}", "[" and "[" form a pair "]" "," "".
The traversal process of the present embodiment is explained in detail below, and the device is operated from ": starting, the first traversed character is '{', after that, the device traverses in sequence, and sequentially traverses four key characters 'in the process, when the first' is traversed, all the presented key characters appear in pairs, and then the traversal is finished.
In this embodiment, after the traversal is finished, the device may obtain a value corresponding to the key to be read according to the position of the key character. For example, in this embodiment, the key "corresponds to a value {" subKey ": subValue" }.
In this embodiment, after the key value pair is obtained, the key value pair may be saved as an Oracle string, so that the conversion from the Oracle string in the JSON data format to the Oracle string is realized, and thereafter, an operation of deleting the value may be performed.
Preferably, the method further comprises the following steps:
and judging whether the JSON data meets the JSON standard format.
In the present embodiment, in order to extract a value corresponding to a key, it is first determined whether JSON data satisfies the JSON standard format. Specifically, the device traverses the JSON data, judges whether a key-value pair exists in the traversal process, acquires the key-value pair if the key-value pair exists, further judges whether the traversed key characters "{ }" and "[ ]" are paired and have corresponding positions, if yes, indicates that the JSON data meets the JSON standard format, otherwise, indicates that the JSON data does not meet the JSON standard format, and exits the subsequent conversion process.
Preferably, when the JSON data is a JSON object array, the method further includes:
and acquiring the number of the objects of the value of the JSON object array and each object according to the logarithm of the key characters '{' and '}'.
In particular, for an array of JSON objects, for example
At this time, according to the above conversion method, the value corresponding to "array" can be obtained as:
according to the traversal result, the number of the objects of which the values comprise three pairs of { } ', namely the number of the objects of the value of the JSON object array is 3, can be obtained, and in addition, each object can be obtained according to the position of the { }'.
Preferably, the method further comprises the following steps:
and merging the JSON objects.
In the present embodiment, since each object has already been acquired according to the position of "{ }", these JSON objects can be merged. The merging of objects may be achieved, for example, by built-in merging functions or methods.
Preferably, the method further comprises the following steps:
reading an Oracle character string;
acquiring keys of the Oracle character string and values corresponding to the keys, and storing the keys and the values into character strings in a JSON object format or character strings in a JSON array format.
In this embodiment, the Oracle character string can also be converted into a character string in JSON format. During conversion, firstly, directly reading an Oracle character string, then acquiring a key of the Oracle character string and a value corresponding to the key according to a built-in function of Oracle, and then storing the key and the value into a character string in a JSON object format or a character string in a JSON array format according to the JSON format requirement, namely, converting the Oracle character string into the character string in the JSON format.
Preferably, the method further comprises the following steps:
and converting the Oracle cursor into a character string in a JSON object format.
In this embodiment, specifically, the Oracle cursor is a position entity mapped on a row of data in the result set, and with the cursor, a user can access any row of data in the result set, and after placing the cursor on a certain row, the data of the row can be operated, for example, data of a current row is extracted.
In this embodiment, the data of the current line can be extracted through the Oracle cursor, and then the data of the current line can be converted into a character string in the JSON object format according to the format requirements of JSON.
In summary, the method for realizing JSON-format data access in Oracle provided by the embodiment of the present invention is based on an Oracle built-in function and a data structure, and is encoded by a PL/SQL technology, the data format and the conversion process are simple, and the occupied Oracle database resources are few, so that the method is efficient and available, and can meet the high concurrency requirement of the internet environment; the invention has clear and simple internal logic, has different processing methods for different data formats, and has stability and fault tolerance; meanwhile, the invention supports the CLOB large object data format and has better efficiency.
Referring to fig. 2, an embodiment of the present invention further provides a device for implementing JSON-formatted data access in Oracle, including:
the data reading unit 10 is used for reading JSON data and keys to be read of the JSON data;
a first index unit 20, configured to obtain a position of the key to be read in the JSON data, and mark the position as a first index position;
a second indexing unit 30, configured to obtain, according to the first index position, a first marker character "located after the first index position: "and is marked as a second index position;
the traversal unit 40 is configured to traverse the characters after the second index position of the JSON data until key characters are detected to appear in pairs in a traversal process;
and a value obtaining unit 50, configured to obtain a value corresponding to the key to be read according to the position of the key character.
Preferably, the key characters include: "{" and "{" form a pair "}", "[" and "[" form a pair "]" "," "".
Preferably, the method further comprises the following steps:
and the JSON standard format judging unit is used for judging whether the JSON data meets the JSON standard format.
Preferably, the method further comprises the following steps:
and the JSON object acquisition unit is used for acquiring the number of the objects of the value of the JSON object array and each object according to the logarithm of the key characters '{'.
Preferably, the method further comprises the following steps:
and the value deleting unit is used for deleting the value corresponding to the key to be read according to the position of the key character and the second index position.
Preferably, the method further comprises the following steps:
the Oracle character string reading unit is used for reading an Oracle character string;
and the conversion unit is used for acquiring keys of the Oracle character strings and values corresponding to the keys, and storing the keys and the values into character strings in a JSON object format or character strings in a JSON array format.
Preferably, the method further comprises the following steps:
and the Oracle cursor conversion unit is used for converting the Oracle cursor into a character string in a JSON object format.
The device for realizing JSON format data access in Oracle provided by the embodiment of the invention is based on an Oracle built-in function and a data structure and coded by a PL/SQL technology, the data format and the conversion flow are simple, and the occupied Oracle database resources are few, so that the device has high efficiency and usability and can meet the high concurrency requirement of the Internet environment; the invention has clear and simple internal logic, has different processing methods for different data formats, and has stability and fault tolerance; meanwhile, the invention supports the CLOB large object data format and has better efficiency.
The embodiment of the invention also provides equipment for realizing JSON format data access in Oracle. The apparatus of this embodiment comprises: a processor, a memory, and a computer program stored in the memory and executable on the processor. The processor, when executing the computer program, implements the steps in the above embodiments, such as step S10 shown in fig. 1. Alternatively, the processor, when executing the computer program, implements the functions of the units in the above-described device embodiments, such as the data reading unit 10 shown in fig. 2.
Illustratively, the computer program may be partitioned into one or more modules that are stored in the memory and executed by the processor to implement the invention. The one or more modules may be a series of computer program instruction segments capable of performing certain functions, the instruction segments describing the execution of the computer program in the device.
The device may be a desktop computer, a notebook, a palm top computer, a cloud server, or other computing device. The apparatus may include, but is not limited to, a processor, a memory, a display. It will be appreciated by those skilled in the art that the schematic diagram is merely an example of a device and does not constitute a limitation of a device, and may include more or fewer components than shown, or some components in combination, or different components, e.g., the terminal device of the page selection may also include an input output device, a network access device, a bus, etc.
The Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like, said processor being the control centre for the page selected terminal device, the various parts of the whole device being connected by various interfaces and lines.
The memory may be configured to store the computer program and/or module, and the processor may implement various functions of the terminal device for page selection by executing or executing the computer program and/or module stored in the memory and calling data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function (such as a sound playing function, a text conversion function, etc.), and the like; the storage data area may store data (such as audio data, text message data, etc.) created according to the use of the cellular phone, etc. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
Wherein the device-integrated module, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in a computer-readable storage medium. Based on such understanding, all or part of the flow of the method according to the embodiments of the present invention may also be implemented by a computer program, which may be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method embodiments may be implemented. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, and the like. It should be noted that the computer readable medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable media does not include electrical carrier signals and telecommunications signals as is required by legislation and patent practice.
It should be noted that the above-described device embodiments are merely illustrative, where the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. In addition, in the drawings of the embodiment of the apparatus provided by the present invention, the connection relationship between the modules indicates that there is a communication connection between them, and may be specifically implemented as one or more communication buses or signal lines. One of ordinary skill in the art can understand and implement it without inventive effort.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention.
While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (8)
1. A method for realizing JSON format data access in Oracle is characterized by comprising the following steps:
reading JSON data and a key to be read of the JSON data;
acquiring the position of the key to be read in the JSON data, and marking the position as a first index position;
acquiring a first marker character' located after the first index position according to the first index position: "and is marked as a second index position;
traversing the characters of the JSON data after the second index position until key characters detected in the traversing process are paired;
acquiring a value corresponding to a key to be read according to the position of the key character;
reading an Oracle character string;
acquiring keys of an Oracle character string and values corresponding to the keys, and storing the keys and the values into character strings in a JSON object format or character strings in a JSON array format; during conversion, firstly directly reading an Oracle character string, then acquiring a key of the Oracle character string and a value corresponding to the key according to a built-in function of Oracle, and then storing the key and the value into a character string in a JSON object format or a character string in a JSON array format according to the JSON format requirement;
and converting the Oracle cursor into a character string in a JSON object format.
2. The method for implementing JSON format data access in Oracle according to claim 1, wherein the key character comprises: "{" and "{" form a pair "}", "[" and "[" form a pair "]" "," "".
3. The method for realizing JSON format data access in Oracle according to claim 1, wherein before reading JSON data and the key to be read of the JSON data, the method further comprises:
and judging whether the JSON data meets the JSON standard format.
4. The method for realizing JSON format data access in Oracle according to claim 2, wherein when the JSON data is JSON object array, the method further comprises:
and acquiring the number of the objects of the value of the JSON object array and each object according to the logarithm of the key characters '{' and '}'.
5. The method for realizing JSON format data access in Oracle according to claim 1, further comprising:
and deleting the value corresponding to the key to be read according to the position of the key character and the second index position.
6. An apparatus for implementing JSON format data access in Oracle, comprising:
the data reading unit is used for reading JSON data and keys to be read of the JSON data;
the first index unit is used for acquiring the position of the key to be read in the JSON data and marking the position as a first index position;
a second indexing unit, configured to obtain, according to the first index position, a first marker character "located after the first index position: "and is marked as a second index position;
the traversal unit is used for traversing the characters behind the second index position of the JSON data until key characters are detected to appear in pairs in the traversal process;
a value obtaining unit, configured to obtain a value corresponding to a key to be read, according to the position of the key character;
the Oracle character string reading unit is used for reading an Oracle character string;
the conversion unit is used for acquiring keys of the Oracle character string and values corresponding to the keys, and storing the keys and the values into character strings in a JSON object format or character strings in a JSON array format; during conversion, firstly directly reading an Oracle character string, then acquiring a key of the Oracle character string and a value corresponding to the key according to a built-in function of Oracle, and then storing the key and the value into a character string in a JSON object format or a character string in a JSON array format according to the JSON format requirement;
and the Oracle cursor conversion unit is used for converting the Oracle cursor into a character string in a JSON object format.
7. An apparatus for enabling JSON formatted data access in Oracle comprising a memory, a processor and a computer program stored in said memory, said computer program being executable by said processor to implement a method for enabling JSON formatted data access in Oracle as claimed in any one of claims 1 to 5.
8. A computer readable storage medium having stored thereon executable code configured for execution by at least one processor to implement a method of implementing JSON formatted data access in Oracle as claimed in any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810107784.6A CN108334609B (en) | 2018-02-02 | 2018-02-02 | Method, device, equipment and storage medium for realizing JSON format data access in Oracle |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810107784.6A CN108334609B (en) | 2018-02-02 | 2018-02-02 | Method, device, equipment and storage medium for realizing JSON format data access in Oracle |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108334609A CN108334609A (en) | 2018-07-27 |
| CN108334609B true CN108334609B (en) | 2020-04-07 |
Family
ID=62927895
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810107784.6A Active CN108334609B (en) | 2018-02-02 | 2018-02-02 | Method, device, equipment and storage medium for realizing JSON format data access in Oracle |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108334609B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111626018B (en) * | 2019-02-28 | 2023-07-28 | 北京数聚鑫云信息技术有限公司 | Method and device for constructing JSON formatted data |
| CN111666295B (en) * | 2019-03-05 | 2023-12-26 | 深圳市天软科技开发有限公司 | Data extraction method, terminal device and computer readable storage medium |
| US12124517B2 (en) | 2019-03-05 | 2024-10-22 | Shenzhen Tinysoft Co., Ltd. | Method for data extraction, terminal device and computer-readable storage medium |
| CN111832259B (en) * | 2019-04-12 | 2023-09-12 | 中国联合网络通信集团有限公司 | JSON data generation method and equipment |
| CN110046288A (en) * | 2019-04-19 | 2019-07-23 | 新华三技术有限公司 | The method and device of data is extracted from message body |
| CN110247665A (en) * | 2019-05-16 | 2019-09-17 | 芜湖智久机器人有限公司 | Compression method, device and the computer readable storage medium of JSON data |
| CN112232028B (en) * | 2020-10-28 | 2023-01-03 | 南方电网科学研究院有限责任公司 | Processing method and device of recording channel data, terminal equipment and storage medium |
| CN113608889B (en) * | 2021-07-13 | 2024-08-23 | 广州市百果园网络科技有限公司 | Message data processing method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105138683A (en) * | 2015-09-15 | 2015-12-09 | 歌尔声学股份有限公司 | Method and system for converting JSON data into two-dimensional array |
| CN105354020A (en) * | 2015-09-30 | 2016-02-24 | 武汉钢铁(集团)公司 | Json format data analytic method and data receiving end |
| CN105608142A (en) * | 2015-12-17 | 2016-05-25 | 浙江大华技术股份有限公司 | Storage method and device of Json data |
| CN106648923A (en) * | 2016-10-11 | 2017-05-10 | 浪潮（苏州）金融技术服务有限公司 | Automatic business processing method based on Oracle database client |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9659045B2 (en) * | 2013-11-08 | 2017-05-23 | Oracle International Corporation | Generic indexing for efficiently supporting ad-hoc query over hierarchically marked-up data |
| US9971574B2 (en) * | 2014-10-31 | 2018-05-15 | Oracle International Corporation | JSON stylesheet language transformation |
-
2018
- 2018-02-02 CN CN201810107784.6A patent/CN108334609B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105138683A (en) * | 2015-09-15 | 2015-12-09 | 歌尔声学股份有限公司 | Method and system for converting JSON data into two-dimensional array |
| CN105354020A (en) * | 2015-09-30 | 2016-02-24 | 武汉钢铁(集团)公司 | Json format data analytic method and data receiving end |
| CN105608142A (en) * | 2015-12-17 | 2016-05-25 | 浙江大华技术股份有限公司 | Storage method and device of Json data |
| CN106648923A (en) * | 2016-10-11 | 2017-05-10 | 浪潮（苏州）金融技术服务有限公司 | Automatic business processing method based on Oracle database client |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108334609A (en) | 2018-07-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108334609B (en) | Method, device, equipment and storage medium for realizing JSON format data access in Oracle | |
| CN110704398B (en) | Database migration method and device from MySQL to Oracle and computer equipment | |
| CN111400387B (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
| CN109508355B (en) | A data extraction method, system and terminal device | |
| CN110795464B (en) | Method, device, terminal and storage medium for checking field of object marker data | |
| CN113609128B (en) | Method, device, terminal equipment and storage medium for generating database entity class | |
| CN115357625A (en) | Structured data comparison method and device, electronic equipment and storage medium | |
| CN115104092B (en) | Data synchronization method and related device | |
| CN110569243B (en) | Data query method, data query plug-in and data query server | |
| CN114090671A (en) | Data import method and device, electronic equipment and storage medium | |
| CN110490724A (en) | The storage method and device of account data | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN117493309A (en) | Standard model generation method, device, equipment and storage medium | |
| CN117708164A (en) | Data storage method, device and equipment based on parallel processing database | |
| CN114756140B (en) | Method, device, electronic device and storage medium for inputting rare characters | |
| CN113741864B (en) | Automatic semantic service interface design method and system based on natural language processing | |
| CN117010358A (en) | Message card generation method, device, computer equipment and storage medium | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components | |
| CN116414859B (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN109324838B (en) | Execution method and execution device of single chip microcomputer program and terminal | |
| CN115757174A (en) | Database difference detection method and device | |
| CN116775599A (en) | Data migration method, device, electronic equipment and storage medium | |
| CN115543936A (en) | Method, device and equipment for constructing model files in batches and storage medium | |
| CN108334621B (en) | Database operation method, device, equipment and computer readable storage medium | |
| CN113268483A (en) | Request processing method and device, electronic equipment and storage medium |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 510635 Room 2301-2341, 23 South Tower, 28 Longkou Hengjie, Tianhe District, Guangzhou City, Guangdong Province Applicant after: Bee Assistant Co., Ltd. Address before: 510635 Room 2301-2341, 23 South Tower, 28 Longkou Hengjie, Tianhe District, Guangzhou City, Guangdong Province Applicant before: Guangdong bee assistant network technology Limited by Share Ltd |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |