CN109739874A - Method, apparatus, computer equipment and the storage medium of data content are provided - Google Patents
Method, apparatus, computer equipment and the storage medium of data content are provided Download PDFInfo
- Publication number
- CN109739874A CN109739874A CN201811412873.8A CN201811412873A CN109739874A CN 109739874 A CN109739874 A CN 109739874A CN 201811412873 A CN201811412873 A CN 201811412873A CN 109739874 A CN109739874 A CN 109739874A
- Authority
- CN
- China
- Prior art keywords
- data content
- data
- query statement
- content
- code
- 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
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000003860 storage Methods 0.000 title claims abstract description 24
- 238000000605 extraction Methods 0.000 claims description 23
- 239000000284 extract Substances 0.000 claims description 22
- 238000012360 testing method Methods 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 6
- 238000007689 inspection Methods 0.000 claims description 4
- 238000012423 maintenance Methods 0.000 abstract description 10
- 238000012545 processing Methods 0.000 abstract description 10
- 238000010586 diagram Methods 0.000 description 19
- 230000006870 function Effects 0.000 description 7
- 238000007726 management method Methods 0.000 description 5
- 230000003993 interaction Effects 0.000 description 3
- 108020001077 Anthranilate Phosphoribosyltransferase Proteins 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000001627 detrimental effect Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application belongs to big data technical field, is related to providing method, apparatus, computer equipment and the storage medium of data content.The method of the offer data content includes: to be retrieved in local data dictionary in the Code for receiving data call side for request data content using the Code；There are when identical Code in retrieving the data dictionary, data content query statement is searched using the Code；When finding corresponding data content query statement, data content is extracted using the data content query statement；The data content extracted is returned to the data call side.The method of the offer data content is able to maintain same data content and is consistent in different function, is conducive to the management of data content, and quickly provides data content.In addition, the method for the offer data content can reduce the time for carrying out inspecting processing, be conducive to follow-up maintenance personnel's maintenance system.
Description
Technical field
The application belongs to big data technical field, is related to providing method, apparatus, computer equipment and the storage of data content
Medium.
Background technique
Data dictionary is the set of the information about data, that is, the definition to all elements for including in data flow diagram
Set.Data dictionary is the pith of database, is mainly used for storing relevant information used in database.Data dictionary pair
It is one group of read-only table for user, the content of usual data dictionary includes: the information of all schema objects in database, such as
Table, view, cluster and index etc.；Space of distribution, such as currently used how many space etc.；The default value of column, constraint information
Integrality；The name of user；User and role's rights that have been granted；The audit information that user accesses or uses；And other productions
Raw database information.Data dictionary is common to take the form of one group of table and view structure, is stored in the table space of system.
Under existing technical conditions, the description that same data content uses in different function is different.Similarly
Data content and ambiguity is easily caused using different descriptions, be unfavorable for the management of data content, be especially detrimental to quickly
Data content is provided.It describes unanimously, to need to spend a large amount of in different functions generally for the data content maintained like
Time carries out inspecting processing, therefore is unfavorable for follow-up maintenance personnel's maintenance system.
Summary of the invention
The embodiment of the present application, which discloses, provides method, apparatus, equipment and the storage medium of data content, it is intended to data tune
Data content is quickly provided with side.
Some embodiments of the present application disclose a kind of method of offer data content.It is described that the method for data content is provided
It include: in the Code for receiving data call side for request data content, using the Code in local data dictionary
In retrieved；There are when identical Code in retrieving the data dictionary, data content is searched using the Code and is looked into
Ask sentence；When finding corresponding data content query statement, data content is extracted using the data content query statement；It will
The data content extracted is returned to the data call side.
In some embodiments of the present application, the application data content query statement extract data content the step of wrap
It includes: using the local cache of data content query statement inquiry；There are the data contents in local cache
When the executive plan of query statement, data content is extracted using the data content query statement；In local cache not
There are when the executive plan of the data content query statement, syntax check is carried out to the data content query statement；In the data
When content search sentence passes through syntax check, semantic test is carried out to the data content query statement；It is inquired in the data content
When sentence passes through semantic test, data content to be checked is locked；Check the data call power of the data call side
Limit；When the data call side has data call permission, using the data content query statement in the to be checked of locking
Data content is extracted in data content.
In some embodiments of the present application, the application data content query statement extract data content the step of also
It include: to generate the optimal execution plan of the data content query statement when the data call side has data call permission.
In some embodiments of the present application, it is described generate the data content query statement optimal execution plan the step of
It include: to map the data content query statement with the data dictionary；The data content query statement is inquired
Data content corresponding statistical data and storage outline in the data dictionary combine and generate the data content query statement
Optimal execution plan.
In some embodiments of the present application, described the step of locking to data content to be checked includes: to pass through
The block of latch lockout data content corresponding with the data content query statement, prevents corresponding with the data content query statement
Data content block it is occupied.
In some embodiments of the present application, the step of data call permission for checking the data call side, is wrapped
It includes: checking whether the data call side is included in data call right list；It is included in the data call side described
When in data call right list, the data call side has data call permission.
In some embodiments of the present application, the application data content query statement extract data content the step of also
Include: based in the data content query statement field and table corresponding data content is searched in data buffer area；Institute
State in data buffer area that there are when corresponding data content, extract corresponding data content in the buffer area；In the data
In buffer area be not present corresponding data content, based in the data content query statement field and table search in the database
Corresponding data content；When there is corresponding data content in the database, corresponding data in the database are extracted
Content.
The embodiment of the application discloses a kind of device of offer data content.It is described that the device packet of data content is provided
It includes: Code retrieval module, for existing using the Code when receiving Code of the data call side for request data content
It is retrieved in local data dictionary；Sentence searching module, for there are identical in retrieving the data dictionary
When Code, data content query statement is searched using the Code；Data content extraction module, for finding corresponding number
When according to content search sentence, data content is extracted using the data content query statement；Data content sending module, for that will mention
The data content of taking-up is returned to the data call side.
In some embodiments of the present application, the data content extraction module includes: cache queries unit, is used for
Using the local cache of data content query statement inquiry；Extraction unit, for existing in local cache
When the executive plan of the data content query statement, data content is extracted using the data content query statement；Syntax check list
Member looks into the data content when for the executive plan of the data content query statement to be not present in local cache
It askes sentence and carries out syntax check；Semantic test unit, for when the data content query statement passes through syntax check, to the number
Semantic test is carried out according to content search sentence；Data content locks unit, for passing through semanteme in the data content query statement
When inspection, data content to be checked is locked；Data call scope check unit, for checking the data call side
Data call permission；The extraction unit is when the data call side has data call permission, using the data content
Query statement extracts data content in the data content to be checked of locking.
In some embodiments of the present application, the device for providing data content further includes that optimal execution plan generates mould
Block, the optimal execution plan generation module are used for when the data call side has data call permission, generate the data
The optimal execution plan of content search sentence.
In some embodiments of the present application, the optimal execution plan generation module includes: map unit, and being used for should
Data content query statement is mapped with the data dictionary；Generation unit, for being looked into the data content query statement
The data content of inquiry corresponding statistical data and storage outline in the data dictionary, which combine, generates data content inquiry language
The optimal execution plan of sentence.
In some embodiments of the present application, the data content locks unit and passes through latch lockout and the data content
The block of the corresponding data content of query statement prevents the block of data content corresponding with the data content query statement occupied.
In some embodiments of the present application, whether the data call scope check unit checks the data call side
Included in data call right list；It is described when the data call side includes in the data call right list
Data call side has data call permission.
In some embodiments of the present application, the data content extraction module is based in the data content query statement
Field and table search corresponding data content in data buffer area；The data content extraction module is in the data buffer area
In there are when corresponding data content, extract corresponding data content in the buffer area；The data content extraction module exists
In the data buffer area be not present corresponding data content, based in the data content query statement field and table in data
Corresponding data content is searched in library；There is corresponding data content in the database in the data content extraction module
When, extract corresponding data content in the database.
Some embodiments of the present application disclose a kind of computer equipment, including memory and processor, the memory
In be stored with computer program, the processor realizes any of the above-described kind of offer data content when executing the computer program
The step of method.
Some embodiments of the present application disclose a kind of computer readable storage medium, the computer readable storage medium
On be stored with computer program, the computer program realizes the side of any of the above-described kind of offer data content when being executed by processor
The step of method.
Compared with prior art, technical solution disclosed in the present application mainly have it is following the utility model has the advantages that
In embodiments herein, the method for providing data content includes: to be used for receiving data call side
When the Code of request data content, retrieved in local data dictionary using the Code；Retrieving the data
There are when identical Code in dictionary, data content query statement is searched using the Code；It is finding in corresponding data
When holding query statement, data content is extracted using the data content query statement；The data content extracted is returned to the number
According to called side.In embodiments herein, the Code of request data content is used in local data dictionary by application
It is retrieved, there are when identical Code in retrieving the data dictionary, searches data content inquiry using the Code
Sentence extracts data content using the data content query statement, therefore when finding corresponding data content query statement
The consistency (i.e. Code is consistent) for only needing that data call side is kept to describe same data content with data service side, just
It is able to maintain same data content to be consistent in different function, is conducive to the management of data content, and quickly mention
For data content.In addition, the method for providing data content, which can be reduced, to be carried out inspecting processing in embodiments herein
Time, be conducive to follow-up maintenance personnel's maintenance system.
Detailed description of the invention
Technical solution in ord to more clearly illustrate embodiments of the present application, below will be to needed in the embodiment attached
Figure is briefly described, it should be apparent that, the drawings in the following description are only some examples of the present application, for this field
For those of ordinary skill, without any creative labor, it can also be obtained according to these attached drawings other attached
Figure.
Fig. 1 provides the schematic diagram of data content for data service bearing data called side in the embodiment of the application；
Fig. 2 is that the schematic diagram of the method for data content is provided described in the embodiment of the application；
Fig. 3 is to show the step of extracting data content using the data content query statement described in the embodiment of the application
It is intended to；
The step of Fig. 4 is the optimal execution plan of the generation data content query statement described in the embodiment of the application
Schematic diagram；
Fig. 5 is to show the step of extracting data content using the data content query statement described in the embodiment of the application
It is intended to；
Fig. 6 is that the schematic diagram of the device of data content is provided described in the embodiment of the application；
Fig. 7 is the schematic diagram of data content extraction module 30 described in the embodiment of the application；
Fig. 8 is a kind of schematic diagram for the device for providing data content in another embodiment of the application；
Fig. 9 is the schematic diagram of optimal execution plan generation module 50 described in another embodiment of the application；
Figure 10 is 100 basic structure block diagram of computer equipment in the embodiment of the application.
Description of symbols:
Specific embodiment
The application in order to facilitate understanding is described more fully the application below with reference to relevant drawings.In attached drawing
Give the preferred embodiment of the application.But the application can realize in many different forms, however it is not limited to this paper institute
The embodiment of description.On the contrary, purpose of providing these embodiments is keeps the understanding to disclosure of this application more thorough
Comprehensively.
Unless otherwise defined, all technical and scientific terms used herein and the technical field for belonging to the application
The normally understood meaning of technical staff is identical.The term used in the description of the present application is intended merely to description tool herein
The purpose of the embodiment of body, it is not intended that in limitation the application.
A kind of method that the embodiment of the application discloses offer data content.
With reference to Fig. 1 and 2, wherein Fig. 1 provides data for data service bearing data called side in the embodiment of the application
The schematic diagram of content, Fig. 2 are that the schematic diagram of the method for data content is provided described in the embodiment of the application.
It anticipates as shown in fig. 1, in embodiments herein, by data call bearing data service side's request data
Hold.Specifically, the data call side sends data service request, the data to the data service side by interface url
Include the Code for request data content in service request.Agreement pair between the data call side and the data service side
In identical data content using identical Code, title etc..The data service side uses the side of data content presented below
Data call side described in normal direction provides data content.
It anticipates as shown in Figure 2, the method for providing data content includes:
S1: when receiving Code of the data call side for request data content, using the Code in local number
According to being retrieved in dictionary.
In embodiments herein, Code is made of characters such as several numbers, letters.
S2: there are when identical Code in retrieving the data dictionary, data content is searched using the Code and is looked into
Ask sentence.
S3: it when finding corresponding data content query statement, is extracted in data using the data content query statement
Hold.
In embodiments herein, the data content query statement is SQL (Structured Query
Language, structured query language, for accessing data and querying, updating, and managing relational database system) inquiry language
Sentence.
S4: the data content extracted is returned to the data call side.
Specifically, the data content extracted is returned to the data call by interface url by the data service side
Side.
In embodiments herein, the method for providing data content includes: to be used for receiving data call side
When the Code of request data content, retrieved in local data dictionary using the Code；Retrieving the data
There are when identical Code in dictionary, data content query statement is searched using the Code；It is finding in corresponding data
When holding query statement, data content is extracted using the data content query statement；The data content extracted is returned to the number
According to called side.In embodiments herein, the Code of request data content is used in local data dictionary by application
It is retrieved, there are when identical Code in retrieving the data dictionary, searches data content inquiry using the Code
Sentence extracts data content using the data content query statement, therefore when finding corresponding data content query statement
The consistency (i.e. Code is consistent) for only needing that data call side is kept to describe same data content with data service side, just
It is able to maintain same data content to be consistent in different function, is conducive to the management of data content, and quickly mention
For data content.In addition, the method for providing data content, which can be reduced, to be carried out inspecting processing in embodiments herein
Time, be conducive to follow-up maintenance personnel's maintenance system.
It is to extract data content using the data content query statement described in the embodiment of the application with reference to Fig. 3
Step schematic diagram.
It anticipates as shown in Figure 3, in some embodiments of the present application, the application data content query statement is extracted
The step of data content includes:
S31: using the local cache of data content query statement inquiry.
In embodiments herein, which is SQL statement.It is looked into using the SQL statement found
Ask local cache.The hash value of the SQL statement executed is stored in local cache.Server processes will be looked into
The SQL statement found is converted to ASII code, and the ASII code that conversion obtains then is passed to HASH function.The HASH function returns
One hash value is to server processes.Server processes, which are searched, whether there is identical hash value in local cache.
S32: there are when the executive plan of the data content query statement in local cache, using in the data
Hold query statement and extracts data content.
In embodiments herein, the executive plan is usually that database root is raw according to the data content query statement
At.The executive plan includes:
Inquiry plan, the main body of executive plan are the read-only data structures of a reentry, and referred to as inquiry plan can be by appointing
The user for quantity of anticipating uses.User's context is not stored in inquiry plan.The copy of inquiry plan is forever in local cache
It is remote to be no more than two.Wherein, the copy of an inquiry plan is used for all serial execution, and the copy of another inquiry plan is used
In all parallel execution.The copy of inquiry plan for executing parallel covers all parallel execution, but executes with parallel
Degree of parallelism it is unrelated.
Context is executed, the user for being each carrying out inquiry has one to execute exclusive data (such as parameter value) comprising it
Data structure.This data structure is known as executing context.The data structure for executing context may be reused.If user
It executes and inquires and one of data structure is not used, it will reinitialize the data structure with the context of new user.
In embodiments herein, which is SQL statement.Exist in local cache
When hash value identical with the SQL statement found, data content is extracted using the SQL statement.
S33: when the executive plan of the data content query statement being not present in local cache, in the data
Hold query statement and carries out syntax check.
In embodiments herein, which is SQL statement.It is not deposited in local cache
In hash value identical with the SQL statement found, syntax check is carried out to the SQL statement.The described pair of SQL statement carries out
Syntax check mainly checks whether the SQL statement meets the syntax rule of structured query language.
It, will be in the data when the data content query statement is not over syntax check in embodiments herein
Holding query statement, there are the prompt informations of syntax error to pass through interface url returned data called side.
S34: when the data content query statement passes through syntax check, semantic inspection is carried out to the data content query statement
It looks into.
In embodiments herein, the step of described pair of data content query statement carries out semantic test includes: clothes
After device process of being engaged in carries out syntax check to the data content query statement, to the table in the data content query statement, field, rope
Draw, view etc. is parsed, and compares table, field, index, view in the data dictionary etc. judges that the data content is inquired
Whether table, field, index, view of sentence etc. are comprising in the database.When the table of the data content query statement, field, rope
Draw, view etc. comprising in the database comprising in the database when, which passes through semantic test.
For example, the data content query statement is SQL statement.After server processes carry out syntax check to the SQL statement,
Table, field, index, view etc. in the SQL statement is parsed, and compares table, field, rope in the data dictionary
Draw, whether view etc. judges table, field, index, view of the data content query statement etc. comprising in the database.When this
When table, field, index, view of SQL statement etc. comprising including in the database in the database, the data content query statement
Pass through semantic test.
S35: when the data content query statement passes through semantic test, data content to be checked is locked.Institute
Stating to lock data content to be checked can prevent the structure of the data content described in query process from changing.
In embodiments herein, described the step of locking to data content to be checked includes: to pass through latch
Device (shared pool latch) locks the block of data content corresponding with the data content query statement, prevents and the data
The block of the corresponding data content of content search sentence is occupied.
It, will be in the data when the data content query statement is not over semantic test in embodiments herein
Holding query statement, there are the prompt informations of semantic error to pass through interface url returned data called side.
S36: the data call permission of the data call side is checked.
In embodiments herein, the step of data call permission for checking the data call side includes: inspection
Look into whether the data call side is included in data call right list；The data tune is included in the data call side
When in right list, the data call side has data call permission.
S37: when the data call side has data call permission, using the data content query statement in locking
Data content is extracted in data content to be checked.
In embodiments herein, when the data call side does not have data call permission, by the data tune
Pass through interface url returned data called side with the prompt information that side does not have data call permission.
In some embodiments of the present application, the application data content query statement extract data content the step of also
Include:
S38: it when the data call side has data call permission, generates the optimal of the data content query statement and holds
Row plan.
It is the optimal execution plan that the data content query statement is generated described in the embodiment of the application with reference to Fig. 4
Step schematic diagram.
As schematically shown in figure 4, the step of optimal execution plan for generating the data content query statement includes:
S381: the data content query statement is mapped with the data dictionary.
S382: the data content that the data content query statement is inquired corresponding statistical number in the data dictionary
According to the optimal execution plan for combining the generation data content query statement with storage outline.
In embodiments herein, the optimal execution plan can be by being preset at the Optimized model of data service side
It generates.
By generating the optimal execution plan of the data content query statement, be conducive to improve the data content query statement
Execution efficiency.
It is to extract data content using the data content query statement described in the embodiment of the application with reference to Fig. 5
Step schematic diagram.
Anticipate as shown in Figure 5, the application data content query statement extract data content the step of further include:
S391: based in the data content query statement field and table searched in data buffer area in corresponding data
Hold；
S392: there are when corresponding data content, extract corresponding number in the buffer area in the data buffer area
According to content；
S393: being not present corresponding data content in the data buffer area, based in the data content query statement
Field and table search corresponding data content in the database；
S394: it when there is corresponding data content in the database, extracts in the database in corresponding data
Hold.
In embodiments herein, which is SQL statement.Server processes are based on the SQL language
If field, the table etc. in sentence are searched in data buffer area in the corresponding data content data buffer area, there are corresponding numbers
According to content.There are when corresponding data content in the data buffer area, operation data contents extraction code is described to extract
Data content in data buffer area, while server processes are according to lru algorithm (a kind of page replacement algorithm of memory management)
Increase the access times of corresponding data content in the data buffer area.
When corresponding data content being not present in the data buffer area, server processes are based in the SQL statement
Field, table etc. search corresponding data content in the database.When there is corresponding data content in the database, fortune
Row data contents extraction code is to extract the data content in the database.
The embodiment of the application discloses a kind of device of offer data content.
With reference to Fig. 6, the schematic diagram of the device of data content is provided described in the embodiment for the application.
As schematically represented in fig. 6, the device for providing data content includes:
Code retrieval module 10, for receive data call side for request data content Code when, using institute
Code is stated to be retrieved in local data dictionary.
Sentence searching module 20, in retrieving the data dictionary there are when identical Code, using described
Code searches data content query statement.
Data content extraction module 30, for when finding corresponding data content query statement, using in the data
Hold query statement and extracts data content.
Data content sending module 40, for the data content extracted to be returned to the data call side.
In embodiments herein, the device for providing data content is receiving number by Code retrieval module 10
When being used for the Code of request data content according to called side, retrieved in local data dictionary using the Code；Pass through
Sentence searching module 20, there are when identical Code, searches data content using the Code in retrieving the data dictionary
Query statement；Through data content extraction module 30 when finding corresponding data content query statement, using in the data
Hold query statement and extracts data content；The data content extracted is returned to the data tune by data content sending module 40
With side.In embodiments herein, the device for providing data content is able to maintain data call side and data service side
For the consistency of same data content description, it is able to maintain same data content and is consistent in different function, had
Conducive to the management of data content, and quickly provide data content.In addition, in embodiments herein, the offer number
The time for carrying out inspecting processing can be reduced according to the device of content, is conducive to follow-up maintenance personnel's maintenance system.
It is the schematic diagram of data content extraction module 30 described in the embodiment of the application with reference to Fig. 7.
It anticipates as shown in Figure 7, in some embodiments of the present application, the data content extraction module 30 includes:
Cache queries unit 31, the cache local for application data content query statement inquiry.
Extraction unit 32, in local cache there are when the executive plan of the data content query statement,
Data content is extracted using the data content query statement.
Syntax check unit 33, based on the execution in local cache there is no the data content query statement
When drawing, syntax check is carried out to the data content query statement.
Semantic test unit 34, for looking into the data content when the data content query statement passes through syntax check
It askes sentence and carries out semantic test.
Data content locks unit 35, for when the data content query statement passes through semantic test, to be checked
Data content is locked.
In some embodiments of the present application, the data content locks unit 35 and passes through in latch lockout and the data
The block for holding the corresponding data content of query statement, prevents the block of data content corresponding with the data content query statement occupied
With.
Data call scope check unit 36, for checking the data call permission of the data call side.In the application
Some embodiments in, the data call scope check unit 36 checks whether the data call side is included in data call
In right list；When the data call side includes in the data call right list, the data call side has
Data call permission.
Further, the extraction unit 32 is when the data call side has data call permission, using the data
Content search sentence extracts data content.
It is a kind of schematic diagram for the device that data content is provided in another embodiment of the application with reference to Fig. 8.
It anticipates as shown in Figure 8, in some embodiments of the present application, the device for providing data content further includes most
Excellent executive plan generation module 50.The optimal execution plan generation module 50 is used to have data tune in the data call side
When with permission, the optimal execution plan of the data content query statement is generated.
It is the schematic diagram of optimal execution plan generation module 50 described in another embodiment of the application with reference to Fig. 9.
It anticipates as shown in Figure 9, in some embodiments of the present application, the optimal execution plan generation module 50 is wrapped
It includes:
Map unit 51, for mapping the data content query statement with the data dictionary.
Generation unit 52, the data content for being inquired the data content query statement are right in the data dictionary
The statistical data and storage outline answered combine the optimal execution plan for generating the data content query statement.
In some embodiments of the present application, the data content extraction module 30 is based in the data content query statement
Field and table corresponding data content is searched in data buffer area.
The data content extraction module 30 in the data buffer area there are when corresponding data content, described in extraction
Corresponding data content in buffer area.
Corresponding data content is not present in the data content extraction module 30 in the data buffer area, is based on the number
According in content search sentence field and table search corresponding data content in the database.
When the data content extraction module 30 has corresponding data content in the database, the data are extracted
Corresponding data content in library.
The embodiment of the application discloses a kind of data interaction system.
The data interaction system includes data call side and data service side.The data call side and data clothes
Business side is each configured at least one server and at least one database.The data call side and the data service side it
Between agreement for identical data content using identical Code, title etc..The data call side is needing to call the number
According to service side data content when, data service request is sent to the data service side by interface url, which asks
Include the Code for request data content in asking.The method that the data service side executes above-mentioned offer data content, with to
The data call side provides corresponding data content.
The embodiment of the application discloses a kind of computer equipment.Specifically referring to FIG. 10, being the implementation of the application
100 basic structure block diagram of computer equipment in example.
It anticipates as shown in Figure 10, the computer equipment 100 includes being in communication with each other connection memory by system bus
101, processor 102, network interface 103.It should be pointed out that illustrating only the computer with component 101-103 in Figure 10
Equipment 100, it should be understood that being not required for implementing all components shown, the implementation that can be substituted is more or less
Component.Those skilled in the art of the present technique should be appreciated that computer equipment here is that one kind can be according to being previously set or deposit
The instruction of storage, the automatic equipment for carrying out numerical value calculating and/or information processing, hardware includes but is not limited to microprocessor, dedicated
Integrated circuit (Application Specific Integrated Circuit, ASIC), programmable gate array (Field-
Programmable Gate Array, FPGA), it is digital processing unit (Digital Signal Processor, DSP), embedded
Equipment etc..
The computer equipment can be the calculating such as desktop PC, notebook, palm PC and cloud server and set
It is standby.The computer equipment can carry out people by modes such as keyboard, mouse, remote controler, touch tablet or voice-operated devices with user
Machine interaction.
The memory 101 include at least a type of readable storage medium storing program for executing, the readable storage medium storing program for executing include flash memory,
Hard disk, multimedia card, card-type memory (for example, SD or DX memory etc.), random access storage device (RAM), static random are visited
It asks memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), may be programmed read-only deposit
Reservoir (PROM), magnetic storage, disk, CD etc..In some embodiments, the memory 101 can be the calculating
The internal storage unit of machine equipment 100, such as the hard disk or memory of the computer equipment 100.In further embodiments, described
What memory 101 was also possible to be equipped on the External memory equipment of the computer equipment 100, such as the computer equipment 100
Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card dodge
Deposit card (Flash Card) etc..Certainly, the memory 101 can also both include the storage inside of the computer equipment 100
Unit also includes its External memory equipment.In the present embodiment, the memory 101 is installed on the computer commonly used in storage
The operating system and types of applications software of equipment 100, for example, above-mentioned offer data content method program code etc..In addition,
The memory 101 can be also used for temporarily storing the Various types of data that has exported or will export.
The processor 102 can be in some embodiments central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 102 is commonly used in described in control
The overall operation of computer equipment 100.In the present embodiment, the processor 102 is used to run to store in the memory 101
Program code or processing data, such as the program code of the method for above-mentioned offer data content is provided.
The network interface 103 may include radio network interface or wired network interface, which is commonly used in
Communication connection is established between the computer equipment 100 and other electronic equipments.
Present invention also provides another embodiments, that is, provide a kind of computer readable storage medium, the computer
Readable storage medium storing program for executing is stored with document information recording program, and the document information recording program can be held by least one processor
Row, so that at least one described processor executes the step of any one of the above provides the method for data content.
Finally it should be noted that, it is clear that embodiments described above is only some embodiments of the present application, rather than
Whole embodiments gives the preferred embodiment of the application in attached drawing, but is not intended to limit the scope of the patents of the application.The application
It can realize in many different forms, on the contrary, purpose of providing these embodiments is makes to disclosure of this application
Understanding it is more thorough and comprehensive.Although the application is described in detail with reference to the foregoing embodiments, for the skill of this field
For art personnel come, it can still modify to technical solution documented by aforementioned each specific embodiment, or to it
Middle some technical characteristics carry out equivalence replacement.All equivalent structures done using present specification and accompanying drawing content, directly
Or it is used in other related technical areas indirectly, similarly within the application scope of patent protection.
Claims (10)
1. a kind of provide the method for data content characterized by comprising
When receiving Code of the data call side for request data content, using the Code in local data dictionary
It is retrieved；
There are when identical Code in retrieving the data dictionary, data content query statement is searched using the Code；
When finding corresponding data content query statement, data content is extracted using the data content query statement；
The data content extracted is returned to the data call side.
2. providing the method for data content according to claim 1, which is characterized in that the application data content inquires language
Sentence extract data content the step of include:
Using the local cache of data content query statement inquiry；
There are when the executive plan of the data content query statement in local cache, language is inquired using the data content
Sentence extracts data content；
When the executive plan of the data content query statement being not present in local cache, language is inquired to the data content
Sentence carries out syntax check；
When the data content query statement passes through syntax check, semantic test is carried out to the data content query statement；
When the data content query statement passes through semantic test, data content to be checked is locked；
Check the data call permission of the data call side；
When the data call side has data call permission, using the data content query statement in the to be checked of locking
Data content is extracted in data content.
3. providing the method for data content according to claim 2, which is characterized in that the application data content inquires language
Sentence extracts the step of data content further include: when the data call side has data call permission, generates the data content
The optimal execution plan of query statement.
4. providing the method for data content according to claim 3, which is characterized in that described generation data content inquires language
Sentence optimal execution plan the step of include:
The data content query statement is mapped with the data dictionary；
The data content that the data content query statement is inquired corresponding statistical data and storage in the data dictionary
Outline combines the optimal execution plan for generating the data content query statement.
5. according to claim 2 provide data content method, which is characterized in that it is described to data content to be checked into
Row lock the step of include: by the block of latch lockout data content corresponding with the data content query statement, prevent and
The block of the corresponding data content of data content query statement is occupied.
6. providing the method for data content according to claim 1, which is characterized in that the inspection data call side
The step of data call permission includes: to check whether the data call side is included in data call right list；Described
When data call side includes in the data call right list, the data call side has data call permission.
7. according to claim 1 to the method for offer data content described in 6 any one, which is characterized in that the application number
The step of extracting data content according to content search sentence further include:
Based in the data content query statement field and table corresponding data content is searched in data buffer area；
There are when corresponding data content, extract corresponding data content in the buffer area in the data buffer area；
Corresponding data content is not present in the data buffer area, based on the field and table in the data content query statement
Corresponding data content is searched in the database；
When there is corresponding data content in the database, corresponding data content in the database is extracted.
8. a kind of provide the device of data content characterized by comprising
Code retrieval module, for receive data call side for request data content Code when, using the Code
It is retrieved in local data dictionary；
Sentence searching module, for, there are when identical Code, being searched using the Code in retrieving the data dictionary
Data content query statement；
Data content extraction module, for being inquired using the data content when finding corresponding data content query statement
Sentence extracts data content；
Data content sending module, for the data content extracted to be returned to the data call side.
9. a kind of computer equipment, including memory and processor, which is characterized in that be stored with computer journey in the memory
Sequence, the processor realizes the offer data content as described in any one of claims 1 to 7 when executing the computer program
The step of method.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program is realized when the computer program is executed by processor providing data content as described in any one of claims 1 to 7
The step of method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811412873.8A CN109739874B (en) | 2018-11-23 | 2018-11-23 | Method, apparatus, computer device and storage medium for providing data content |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811412873.8A CN109739874B (en) | 2018-11-23 | 2018-11-23 | Method, apparatus, computer device and storage medium for providing data content |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109739874A true CN109739874A (en) | 2019-05-10 |
| CN109739874B CN109739874B (en) | 2024-05-31 |
Family
ID=66358717
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811412873.8A Active CN109739874B (en) | 2018-11-23 | 2018-11-23 | Method, apparatus, computer device and storage medium for providing data content |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109739874B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021218033A1 (en) * | 2020-04-29 | 2021-11-04 | 平安科技（深圳）有限公司 | Dictionary data operation method and apparatus, readable storage medium, and terminal device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1321859A1 (en) * | 2001-12-18 | 2003-06-25 | Cognos Incorporated | System and method for retrieving data from a database system |
| US6678674B1 (en) * | 1998-07-09 | 2004-01-13 | Informex, Inc. | Data retrieving method and apparatus data retrieving system and storage medium |
| US20080214154A1 (en) * | 2005-11-01 | 2008-09-04 | Jorey Ramer | Associating mobile and non mobile web content |
| CN105589936A (en) * | 2015-12-11 | 2016-05-18 | 航天恒星科技有限公司 | Data query method and system |
| CN108334622A (en) * | 2018-02-08 | 2018-07-27 | 竞技世界（北京）网络技术有限公司 | A method of it obtains and formats complex data |
-
2018
- 2018-11-23 CN CN201811412873.8A patent/CN109739874B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6678674B1 (en) * | 1998-07-09 | 2004-01-13 | Informex, Inc. | Data retrieving method and apparatus data retrieving system and storage medium |
| EP1321859A1 (en) * | 2001-12-18 | 2003-06-25 | Cognos Incorporated | System and method for retrieving data from a database system |
| US20080214154A1 (en) * | 2005-11-01 | 2008-09-04 | Jorey Ramer | Associating mobile and non mobile web content |
| CN105589936A (en) * | 2015-12-11 | 2016-05-18 | 航天恒星科技有限公司 | Data query method and system |
| CN108334622A (en) * | 2018-02-08 | 2018-07-27 | 竞技世界（北京）网络技术有限公司 | A method of it obtains and formats complex data |
Non-Patent Citations (1)
| Title |
|---|
| 孙萧寒 等: "关系型数据库***查询优化分析", 甘肃科技, vol. 21, no. 03, 30 March 2005 (2005-03-30) * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021218033A1 (en) * | 2020-04-29 | 2021-11-04 | 平安科技（深圳）有限公司 | Dictionary data operation method and apparatus, readable storage medium, and terminal device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109739874B (en) | 2024-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107402992B (en) | Distributed NewSQL database system and full-text retrieval establishing method | |
| US10803197B1 (en) | Masking sensitive information in records of filtered accesses to unstructured data | |
| CN107273522B (en) | Multi-application-oriented data storage system and data calling method | |
| US8868595B2 (en) | Enhanced control to users to populate a cache in a database system | |
| US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
| US11698893B2 (en) | System and method for use of lock-less techniques with a multidimensional database | |
| US20180285475A1 (en) | Flexible record definitions for semi-structured data in a relational database system | |
| CN102760143A (en) | Method and device for dynamically integrating executing structures in database system | |
| US10664508B1 (en) | Server-side filtering of unstructured data items at object storage services | |
| CN113051268A (en) | Data query method, data query device, electronic equipment and storage medium | |
| US20220229657A1 (en) | Extensible resource compliance management | |
| CN113535677B (en) | Data analysis query management method, device, computer equipment and storage medium | |
| CN110928963B (en) | Column-level authority knowledge graph construction method for operation and maintenance service data table | |
| CN115269631A (en) | Data query method, data query system, device and storage medium | |
| US20120303608A1 (en) | Method and system for caching lexical mappings for rdf data | |
| CN117171108B (en) | Virtual model mapping method and system | |
| Ma et al. | Modeling and querying temporal RDF knowledge graphs with relational databases | |
| US8200673B2 (en) | System and method for on-demand indexing | |
| CN109739874A (en) | Method, apparatus, computer equipment and the storage medium of data content are provided | |
| US11372859B2 (en) | Efficiently supporting value style access of MOBs stored in SQL LOB column by providing value based semantics for LOBs in RDBMS | |
| CN116739336A (en) | Power grid disaster early warning method and system based on multi-source heterogeneous data fusion model | |
| CN116578614A (en) | Data management method, system, medium and equipment for pipeline equipment | |
| US11574217B2 (en) | Machine learning based identification and classification of database commands | |
| US11836130B2 (en) | Relational database blockchain accountability | |
| CN113868138A (en) | Method, system, equipment and storage medium for acquiring test data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |