CN101781986A - Method and device for transmitting and analyzing numerical flow of curve data in logging system - Google Patents
Method and device for transmitting and analyzing numerical flow of curve data in logging system Download PDFInfo
- Publication number
- CN101781986A CN101781986A CN201010107056A CN201010107056A CN101781986A CN 101781986 A CN101781986 A CN 101781986A CN 201010107056 A CN201010107056 A CN 201010107056A CN 201010107056 A CN201010107056 A CN 201010107056A CN 101781986 A CN101781986 A CN 101781986A
- Authority
- CN
- China
- Prior art keywords
- data
- numerical value
- curve
- value stream
- user
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method and a device for transmitting and analyzing numerical flow of curve data. The method comprises the following steps: acquiring data; sorting the data; receiving a request; analyzing the request submitted by a user, and generating an SQL sentence capable of calculating data from a data storage; calculating the data by using the SQL sentence, generating the numerical flow by using the acquired data result and transmitting the numerical flow; analyzing the numerical flow, and acquiring the curve data used in drawing a logging map; and drawing a curve in the logging map according to the acquired curve data and identifying formation lithology or hydrocarbon reservoir in scientific research and production for oil filed exploration and development. The device for transmitting and analyzing the numerical flow of the curve data comprises a data acquisition unit, a data storage unit, a user interaction device, a request analyzer, a numerical flow generator, a numerical flow analyzer and a judging device. Through the method and the device for transmitting and analyzing the numerical flow of the curve data, the data processing capability and accuracy are improved greatly.
Description
Technical field
The present invention relates to the geophysical exploration development field, for the geophysical exploration data are handled and recognition methods, information transmission and switching technology during the concrete B/S pattern geological logging figure that adopts three-layer architecture draws are embodied as the stream transmission of curve numeric type data in a kind of well log system and the method and apparatus of parsing.
Background technology
Well log is a kind of map that can react geologic features such as formation lithology, rerum natura, oiliness that utilizes the logging data gathered in the drilling process and log data to draw, graphical content comprise lithology, color, oiliness, fossil contain thing, hydrocarbon constituent content, change that parameter, bed boundary, the degree of depth, well log interpretation achievement, log, drilling time curve, mud property curve, gas are surveyed curve, landwaste contains discharge curve etc., is used for oil field prospecting exploitation research and production identification lithology and oil-gas Layer.After having possessed the Electronic Digital Data Acquisition technology, well log can adopt computer-aided drafting to realize.
Adopt the well log drawing system of three-layer architecture to constitute by graphic plotting device, data processor, data storage three parts.The graphic plotting device is responsible for the drafting and the demonstration of figure; Data processor is responsible for taking out from data storage and handling the required data of drawing, and is transferred to the graphic plotting device; Data storage is responsible for the storage and management of data.
Adopt the well log drawing system of this pattern, the speed of transfer of data and parsing is the key that influences system applies efficient between each parts.At present the transfer of data between each parts realizes with resolving the XML of employing technology more, XML can be easily with database in table change mutually, and can guarantee that data structure is accurate.Therefore, for the lithological profile that relates in the well log, hydrocarbon constituent content, change The data XML technology such as parameter, bed boundary to carry out exchanges data be a good selection, because the structure more complicated and the data volume of these data are little, be fit to transmit and parsing with the XML technology, the drawing response speed still can be accepted, the imperceptible too big time lag of user.But the text presentation gimmick of XML and the symbolism meeting of mark cause the data volume increase of the data volume of XML form than binary format, and especially when data volume was very big, the speed of transfer of data and parsing can become the bottleneck that influences drawing efficiency.Log in the well log, drilling time curve, mud property curve, gas are surveyed curve, landwaste and are contained curve data such as discharge curve to relate to data volume big, easily several thousand even up to ten thousand records, it is longer to utilize the XML technology to organize, transmit and resolve the required time to these data, has had a strong impact on well log and has drawn efficient.
Summary of the invention
Utilize the XML technology to transmit the problem of inefficiency when resolving in order to solve curve data in the well log system, the invention provides a kind of based on the curve numerical value flow transmission of logging data and log data and the method and apparatus of resolution data.
The curve data that relates in the well log comprises that log, drilling time curve, mud property curve, gas are surveyed curve, landwaste contains discharge curve etc., and this class data characteristic is that data volume is big, simple in structure and be the numeric type data.Take into full account these characteristics of curve data in the present invention, adopted numerical value stream technology that these data are encapsulated, transmit and resolve.
According to a first aspect of the present invention, the method for a kind of curve data numerical value flow transmission and parsing is provided, it may further comprise the steps:
Gather logging data and log data from situ of drilling well;
The logging data and the log data that get access to are processed and put in order;
Based on logging data and the log data after processing and the arrangement, receive the user and submit the request of data of drawing well log to;
Receive and resolve the request of submitting to up when the end user draws well log of asking for curve data, generation can be asked for the SQL statement of data from data storage;
The SQL statement that utilization parses is asked for data from data storage, the data that will ask for are carried out the encapsulation of numerical value stream according to the structure and the call format of numerical value stream then, generate numerical value stream;
Structure and call format according to numerical value stream are resolved numerical value stream, obtain curve data;
According to the curve in the curve data drafting well log that obtains, formation lithology or oil-gas Layer in the identification oil field prospecting exploitation research and production.
Wherein, the request that the user submits to is resolved, condition, the sort criteria of curve are tabulated, asked for to the table name at the required curve data of acquisition user place, the field name of curve, and utilize these request elements that parse to generate SQL statement according to the SQL standard combination; Specifically may further comprise the steps:
1. from user's request, extract the title of the tables of data of user's submission;
2. judge whether the table name that parses is empty.If table name is empty, then do not continue to resolve other content, return null statement, promptly return null character string, show that the request that the user submits to is incorrect, correctly do not parse SQL statement; Otherwise, continue to resolve the back content;
3. from user's request, extract the field name tabulation of all curve fields of user's submission;
4. judge whether the field name tabulation that parses is empty.If the field name tabulation does not then continue to resolve other content for empty, return null statement.Promptly return null character string, show that the request that the user submits to is incorrect, correctly do not parse SQL statement; Otherwise, continue to resolve the back content;
5. from user's request, extract the querying condition that is used to ask for data that the user submits to;
6. from user's request, extract the sort criteria that is used for data sorting that the user submits to;
7. according to the table name, field name tabulation, querying condition, the sort criteria that parse, construct and read the standard SQL statement that data are used.
Wherein, the record set of the curve data that utilizes SQL statement to ask for is carried out the encapsulation of numerical value stream according to the structure of numerical value stream with form, the correlation curve data are write in the numerical value stream, generate numerical value and flow; Specifically may further comprise the steps:
1. utilize the SQL statement that parses in the request analysis device in data storage, to obtain related data;
2. judge whether obtained data are empty.If be empty, in numerical value stream, write integer 0, show and do not get the data that satisfy user's request condition; If data are not empty, step below then continuing;
3. in numerical value stream, write the number of data points of curve.Because user's curve of once asking must be in same tables of data, so the number of data points of all curves of user's request all is identical, and the degree of depth also is identical.Therefore, the record strip number of data centralization is exactly the number of data points of curve, and the structure and the call format that flow according to numerical value write this integer value in the numerical value stream, as first content of numerical value stream;
4. according to the structure and the call format of numerical value stream, the depth value of the current record pointer indication data record of data centralization is write numerical value stream with the form of floating number;
5. according to the structure and the call format of numerical value stream, write the curve values of every curve under the current degree of depth successively, the curve values of the current record pointer indication data record of data centralization is write numerical value stream with the form of floating number successively according to the front and back order of field location;
6. judge whether the data of all depth points are all write numerical value stream.Judge promptly whether record pointer moves to the record set end; If be the last item record, then the generation of numerical value stream is finished.Otherwise, move a record behind the current record pointer with data set, locate next depth point, turn back to 4. step continuation execution.
Wherein, according to the structure and the call format of the numerical value stream that transmits between numerical value stream maker and the numerical value stream analyzer, logarithm value stream is resolved, and obtains to draw the concrete depth value and the curve values data of every required curve of well log.May further comprise the steps:
1. receive the numerical value stream that from numerical value stream maker, transmits, and, begin to read an integer numerical value, be the number of data points of curve from numerical value stream head according to structure and call format that numerical value flows;
2. whether the integer obtained of judgement is 0.Promptly judge to wait to plot whether have data point,, then return sky, show and do not get the data that the user wants curve plotting if this numerical value is 0; Otherwise, step below continuing;
3. according to the structure and the call format of numerical value stream, from numerical value stream, read a floating number, as the depth value of curve current data point;
4. according to the structure and the call format of numerical value stream,, from numerical value stream, read floating number successively, respectively as the curve values of every curve under this degree of depth according to the order of list of fields;
5. judge whether to read the end of this numerical value stream, if this numerical value stream is run through, then numerical value stream is resolved and is finished; Otherwise turn back to 3. step continuation execution.
According to a second aspect of the present invention, provide a kind of based on the curve data numerical value flow transmission of logging data and log data and the device of parsing, it comprises:
Data acquisition unit is used for obtaining logging data and log data from situ of drilling well;
Data reducer, the logging data and the log data that are used for getting access to are processed and are put in order;
User interaction means is used for the user and submits the request of data of drawing well log to;
The request analysis device is used to receive and resolve the association requests of submitting to up when the end user draws well log of asking for curve data, and generation can be asked for the SQL statement of data from data storage;
Numerical value stream maker, be connected with the request analysis device, the SQL statement that utilizes the request analysis device to parse is asked for the record set of curve data from data storage, the data that will ask for are carried out the encapsulation of numerical value stream according to the structure and the call format of numerical value stream then, generate numerical value stream;
The numerical value stream analyzer is connected with numerical value stream maker, is used to receive numerical value stream maker and passes the numerical value stream of coming, and resolve numerical value stream according to the structure and the call format of numerical value stream, obtains curve data;
Decision maker is used for according to formation lithology or oil-gas Layer in the Curves Recognition oil field prospecting exploitation research and production of the curve data drafting well log that obtains.
Preferably, the request analysis device is located in the data processor, is used to resolve the request of asking for curve data that the end user submits to up.The concrete function of request analysis device is as follows:
From user's request, extract the title of the tables of data of user's submission;
From user's request, extract the field name tabulation of all curve fields of user's submission;
From user's request, extract the querying condition that is used to ask for data that the user submits to;
From user's request, extract the sort criteria that is used for data sorting that the user submits to;
The table name that extracts, the legitimacy of field name tabulation are judged, error situation is carried out abnormality processing;
Generate the SQL statement of from data storage, asking for data according to standard SQL syntax rule.
Preferably, numerical value stream maker is located in the data processor, is connected with the request analysis device, is used for asking for data and generates numerical value stream from data storage.The concrete function of numerical value stream maker is as follows:
Utilize the SQL statement that parses in the request analysis device in data storage, to obtain curve data;
According to the structure and the call format of numerical value stream, in numerical value stream, write the record number (number of data points) of curve data with integer format, as first content of numerical value stream;
According to the structure and the call format of numerical value stream, in numerical value stream, write the curve values of depth value He each curve of each data point successively with the floating type form, generate numerical value and flow.
Preferably, the numerical value stream analyzer is located in the graphic plotting device and with numerical value stream maker and is connected, and is used to resolve the numerical value stream that transmits from numerical value stream maker, parses curve data from numerical value stream.The concrete function of numerical value stream analyzer is as follows:
According to the structure and the formal definition of numerical value stream, from numerical value stream, parse the number of data points of curve;
According to the structure and the formal definition of numerical value stream, from numerical value stream, parse the depth value of each depth point of curve;
According to the structure and the formal definition of numerical value stream, from numerical value stream, parse the curve values of every curve of user's request in each depth point correspondence;
The degree of depth to the curve that parses from numerical value stream is counted, the depth value of each depth point and each curve values this depth point under reorganize, and forms the curve data that the drafting single curve is used in the well log.
Especially, purposes based on the device of the curve data numerical value flow transmission of logging data and log data and parsing is, according to all kinds of curves in the curve data drafting well log that obtains, discern formation lithology or oil-gas Layer in the oil field prospecting exploitation research and production, for actual production provides technical support.
Use above-mentioned technical scheme, have very significantly technique effect in logging data and log data processing and oil-gas recognition, it has greatly improved the transmission and the analytic efficiency of curve data in the well log system, has shortened the time of well log drafting pattern.The well log system behind the present invention of using submits to from the user and asks to draw out whole well log and generally can both finish in the time of couple of seconds; And greatly enriched the technological means of oil-gas recognition, and then improved recognition efficiency.
Description of drawings
Fig. 1 is numerical value flow transmission of the present invention and resolver schematic diagram;
Fig. 2 is overall structure and the flow chart of the present invention in the well log drawing system;
Fig. 3 is the workflow diagram of the request analysis device among Fig. 2;
Fig. 4 is the workflow diagram of the numerical value stream maker among Fig. 2;
Fig. 5 is the workflow diagram of the numerical value stream analyzer among Fig. 2;
Fig. 6 is that the numerical value flow structure in the well log drawing system is formed schematic diagram.
The specific embodiment
Well log is a kind of map that can react geologic features such as formation lithology, rerum natura, oiliness that utilizes the logging data gathered in the drilling process and log data to draw, and is used for oil field prospecting exploitation research and production identification lithology and oil-gas Layer.
In the present invention, adopt the well log drawing system of three-layer architecture to constitute by graphic plotting device, data processor, data storage three parts.The graphic plotting device is responsible for receiving user's request, realizes the drafting and the demonstration of figure; Data processor is responsible for taking out from data storage and handling the required data of drawing, and is transferred to the graphic plotting device; Data storage is responsible for the storage and management of data.Adopt the well log drawing system of this pattern, the speed of transfer of data and parsing is the key that influences system applies efficient between each parts.
In the present invention, log in the well log, drilling time curve, mud property curve, gas are surveyed curve, landwaste and are contained curve data such as discharge curve and be numeric type data and relatively simple for structure, by a series of depth values, curve values to forming, but it is very big to relate to data volume, several thousand easily, up to ten thousand even hundreds of thousands bar data record; Adopt other parsings and transmission method, it is longer to utilize the XML technology to organize, transmit and resolve the required time to these data, has had a strong impact on well log and has drawn efficient.For this reason, the big curve data of data volume the invention provides a kind of method and apparatus with numerical value stream high efficiency of transmission and resolution data for this class formation is simple.
Next, by drawings and Examples the given technical scheme of the present invention is described in further detail.
The technological thought that the present invention is based on is: gather logging data and log data from situ of drilling well; The logging data and the log data that get access to are put in order; The user submits the request of data of drawing well log to; According to the drawing request that the user submits to, request content is resolved, obtain the data table name at the curve data place of user's request, querying condition and sort criteria that curve is used are tabulated, asked for to the bar number and the curve name field of curve.After parsing these request elements, according to the rule of standard SQL grammer, these request elements are made up, generation can be asked for the SQL statement of data; The data of utilizing SQL statement to ask for from data storage are encapsulated, generate numerical value stream.According to the structure and the call format of numerical value stream, at first in stream, write the number of data points of curve with the form of integer data; Write the related data of each depth point then successively according to data point degree of depth order from the superficial to the deep, all these data are all write with the form of floating type data and are become a mandarin, the data of any one depth point comprise: depth value and each curve are in the curve values of this depth point, and wherein the write sequence of curve values is consistent with the curve name field tab sequential of user's request; Logarithm value stream is resolved.Structure and call format according to numerical value stream, at first read the number of data points of first integer data as curve from the numerical value stream that receives, the data of each depth point are read in circulation then, all read with the floating type data, till reading the ending of flowing to whole numerical value, end loop.The data of each depth point are made of the curve values of depth value and each bar curve, and the order of the curve name field tabulation the when curve values that reads is asked according to the user is grouped on each bar curve successively.The number of data points that parses, the depth value of each depth point and the curve values of each curve all are stored in the corresponding internal storage structure, finish the parsing of logarithm value stream;
Draw the curve in the well log and discern formation lithology or oil-gas Layer in the oil field prospecting exploitation research and production according to the curve data that obtains.
Fig. 1 has used the device schematic diagram with numerical value flow transmission and resolution data method provided by the invention, and wherein this device comprises:
Data acquisition unit 1: be used for obtaining logging data and log data from situ of drilling well;
Data reducer 2: the logging data and the log data that are used for getting access to are put in order;
User interaction means 3: be used for the user and submit the request of data of drawing well log to;
Request analysis device 4: be located in the data processor, be used to resolve the curve plotting request of asking for curve data that the end user submits to up, generation can be asked for the SQL statement of data from data storage;
Numerical value stream maker 5: be located in the data processor, be connected with the request analysis device, the SQL statement that utilizes the request analysis device to parse is asked for the record set of curve data from data storage, the record set data that to ask for are then carried out the data flow encapsulation according to the structure and the call format of numerical value stream, the depth data and the curve values data of all curves are write in the numerical value stream successively according to regular named order, generate numerical value stream;
Numerical value stream analyzer 6: be located in the graphic plotting device, be connected with numerical value stream maker, be used to resolve the numerical value stream that transmits from numerical value stream maker, the numerical value stream analyzer is resolved according to the structure and the call format logarithm value stream of numerical value stream, and the curve data that parses is stored in the local internal memory, be used for decision maker and draw the curve of well logs and discern formation lithology or oil-gas Layer according to these data;
Decision maker 7: be used for drawing the curve of well log and discerning formation lithology or oil-gas Layer in the oil field prospecting exploitation research and production according to the curve data that obtains.
Fig. 2 is overall structure and a flow chart of having showed overall technical architecture of the present invention, and as shown in Figure 2, method of the present invention may further comprise the steps:
Step S201: gather logging data and log data from situ of drilling well;
Step S202: logging data and log data to collection in worksite are carried out analysis and arrangement;
Step S203: the user submits the request of data of drawing well log to;
Step S204: by the request analysis device user's request is resolved, generation can be asked for the SQL statement of data;
Step S205: judge whether SQL statement is empty.If be empty, execution in step S206 then, otherwise change step S207;
Step S206: the user asks wrong, skips the drafting of correlation curve, and feedback error information.
Step S207: utilize SQL statement in data storage, to read data by numerical value stream maker, utilize the data result that takes out to generate numerical value stream, and give the numerical value stream analyzer with the numerical value flow transmission.
Step S208: resolve by numerical value stream analyzer logarithm value stream, extract the curve data that satisfies graphic plotting device call format.
Step S209: judge read data whether be empty.If data are empty, then execution in step S210; Otherwise change step S211.
Step S210: no user request msg, the drafting of skipping correlation curve.
Step S211: decision maker utilizes data that the numerical value stream analyzer parses to draw the curve in the well log and discerns formation lithology or the oil-gas Layer of oil field prospecting developmental research in producing.
Below in conjunction with accompanying drawing 3-6, the relevant portion that the present invention relates to is described in detail respectively.
In Fig. 3, provided the workflow of step 204 request analysis device among Fig. 2, be used for parsing and ask for the SQL statement that data are used from the request that the user submits to, said method comprising the steps of:
Step S301: resolve table name.From user's request, extract the title of the tables of data of user's submission.
Step S302: judge whether the table name that is parsed by step S301 is empty.If table name is empty, then execution in step S303; Otherwise, change step S304.
Step S303: return null statement.Promptly return null character string, show that the request that the user submits to is incorrect, correctly do not parse SQL statement.
Step S304: resolve list of fields.From user's request, extract the field name tabulation of all curve fields of user's submission.
Step S305: judge whether the list of fields that is parsed by step S304 is empty.If list of fields is empty, then execution in step S303; Otherwise, change step S306.
Step S306: resolve the where condition.From user's request, extract the querying condition that is used to ask for data that the user submits to.
Step S307: resolve sort criteria.From user's request, extract the sort criteria that is used for data sorting that the user submits to.
Step S308: generate SQL statement, and pass to numerical value stream maker.According to table name, field name, querying condition, the sort criteria that step S301, step S304, step S306, step S307 are parsed, construct and read the standard SQL statement that data are used, and it is passed to numerical value stream maker.
In Fig. 4, provided the workflow of step 207 numerical value stream maker among Fig. 2, be used for asking for data and generating numerical value stream from data storage, said method comprising the steps of:
Step S401: utilize SQL statement to ask for data.In data storage, obtain related data according to the SQL statement that parses in the request analysis device.
Step S402: judge whether obtained data are empty.If be sky, then execution in step S403; Otherwise, change step S404.
Step S403: in numerical value stream, write integer 0.Show and do not get the data that satisfy user's request condition, change step S409 then.
Step S404: the number of data points that in numerical value stream, writes curve.Because user's curve of once asking must be in same tables of data, so the number of data points of all curves of user's request all is identical, and the degree of depth also is identical.Therefore, the record strip number of the data centralization that process step S401 obtains is exactly the number of data points of curve, and the structure and the call format that flow by numerical value shown in Figure 6 write this integer value in the numerical value stream, as first content of numerical value stream.
Step S405: the depth value that writes current data point.By numerical value stream format shown in Figure 6, the depth value of the current record pointer indication data record of data centralization is write numerical value stream with the form of floating number.
Step S406: write the curve values of every curve under the current degree of depth successively.By the structure and the call format of numerical value shown in Figure 6 stream, the curve values of the current record pointer indication data record of data centralization is write numerical value stream with the form of floating number successively according to the front and back order of field location.
Step S407: judge whether the data of all depth points are all write numerical value stream.Judge promptly whether record pointer moves to the record set end.If be the last item record, then execution in step S409; Otherwise, change step S408.
Step S408: record pointer moves down, and locatees next depth point.Move a record behind the current record pointer with data set, change step S405 then.
Step S409: return numerical value stream.To give the numerical value stream analyzer by the numerical value flow transmission that as above step generated.
In Fig. 5, provided the workflow of step 208 numerical value stream analyzer among Fig. 2, the numerical value stream analyzer is used to receive numerical value stream, and it is resolved, and generates the used curve data of graphic plotting device, may further comprise the steps:
Step S501: from numerical value stream, read an integer numerical value.The numerical value stream that reception transmits from numerical value stream maker, and, begin to read an integer from numerical value stream head by structure and call format that numerical value shown in Figure 6 flows, be the number of data points of curve.
Step S502: whether the integer that judgement obtains is 0.Promptly judge to wait to plot whether have data point, if this numerical value is 0, execution in step S503 then, otherwise change step S504.
Step S503: return sky.Show and do not get the data that the user wants curve plotting.
Step S504:, from numerical value stream, read a floating type numerical value, as depth value by the structure and the call format of numerical value stream shown in Figure 6.
Step S505:, and, from numerical value stream, read floating type numerical value successively, respectively as the curve values of every curve under this degree of depth according to list of fields by the structure and the call format of numerical value stream shown in Figure 6.
Step S506: judge whether numerical value stream is empty.Promptly judge whether to read the end of this numerical value stream, if this numerical value stream is run through, execution in step S507 then; Otherwise change step S504.
Step S507: return the curve data that from numerical value stream, reads, submit to graphic plotting device curve plotting.
Fig. 6 is a numerical value flow structure schematic diagram, has described the structure of whole numerical value stream.Provided the formation form of the numerical value stream of the n bar curve with m same depth point among the figure, article one is the number of data points of curve; Place each curve data of each depth point then successively according to curve data point order from the superficial to the deep, each curve data placement is in proper order: depth value, curve 1 are in the curve values under this degree of depth, the curve values of curve 2 under this degree of depth ... the curve values of curve n under this degree of depth.Wherein, curve 1, curve 2 ... this curve order of curve n is submitted the sequence consensus that the curve name field is tabulated in the request to the user.
Need to prove that the number of data points of curve is represented with the integer number, takies 4 bytes; The depth value of curve and curve values represent with the floating type number that all each floating number takies 4 bytes; The length of whole numerical value stream is by the number of data points of every curve and the bar number decision of curve, and the size of whole stream is 4m (n+1)+4 byte among Fig. 6.
From above-mentioned embodiment as can be seen,, greatly improved the transmission and the analytic efficiency of curve data in the well log system, shortened the time of well log drafting pattern by this use that utilizes the technology of numerical value flow transmission and resolution data.The well log system behind the present invention of using submits to from the user and asks to draw out whole well log and generally can both finish in the time of couple of seconds.
In addition, this technical scheme the construction of similar system later on provides new thinking for us.
As above-mentioned, clear described that the present invention proposes in detail based on the curve data numerical value flow transmission of logging data and log data and the method and the device of parsing, and use method of the present invention and device improves data processing speed and discern oil-gas Layer.But this area those skilled in the art are appreciated that under the situation of the spirit and scope of the present invention that do not deviate from the claims definition, can make multiple modification in form and details.
Claims (9)
1. the method for curve data numerical value flow transmission and parsing, it may further comprise the steps:
Gather logging data and log data from situ of drilling well;
The logging data and the log data that get access to are processed and put in order;
Based on logging data and the log data after processing and the arrangement, receive the user and submit the request of data of drawing well log to;
Receive and resolve the request of submitting to up when the end user draws well log of asking for curve data, generation can be asked for the SQL statement of data from data storage;
The SQL statement that utilization parses is asked for data from data storage, the data that will ask for are carried out the encapsulation of numerical value stream according to the structure and the call format of numerical value stream then, generate numerical value stream;
Structure and call format according to numerical value stream are resolved numerical value stream, obtain curve data;
According to the curve in the curve data drafting well log that obtains, formation lithology or oil-gas Layer in the identification oil field prospecting exploitation research and production.
2. the method for curve data numerical value flow transmission according to claim 1 and parsing, wherein the request that the user is submitted to is resolved, condition, the sort criteria of curve are tabulated, asked for to the table name at the required curve data of acquisition user place, the field name of curve, and utilize these request elements that parse to generate SQL statement according to the SQL standard combination; Specifically may further comprise the steps:
1. from user's request, extract the title of the tables of data of user's submission;
2. judge whether the table name that parses is empty.If table name is empty, then do not continue to resolve other content, return null statement, promptly return null character string, show that the request that the user submits to is incorrect, correctly do not parse SQL statement; Otherwise, continue to resolve the back content;
3. from user's request, extract the field name tabulation of all curve fields of user's submission;
4. judge whether the field name tabulation that parses is empty.If the field name tabulation does not then continue to resolve other content for empty, return null statement.Promptly return null character string, show that the request that the user submits to is incorrect, correctly do not parse SQL statement; Otherwise, continue to resolve the back content;
5. from user's request, extract the querying condition that is used to ask for data that the user submits to;
6. from user's request, extract the sort criteria that is used for data sorting that the user submits to;
7. according to the table name, field name tabulation, querying condition, the sort criteria that parse, construct and read the standard SQL statement that data are used.
3. the method for curve data numerical value flow transmission according to claim 1 and parsing, wherein will utilize the record set of the curve data that SQL statement asks for to carry out numerical value stream according to the structure of numerical value stream with form encapsulates, the correlation curve data are write in the numerical value stream, generate numerical value stream; Specifically may further comprise the steps:
1. utilize the SQL statement that parses in the resolver in data storage, to obtain related data;
2. judge whether obtained data are empty.If be empty, in numerical value stream, write integer 0, show and do not get the data that satisfy user's request condition; If data are not empty, step below then continuing;
3. in numerical value stream, write the number of data points of curve.Because user's curve of once asking must be in same tables of data, so the number of data points of all curves of user's request all is identical, and the degree of depth also is identical.Therefore, the record strip number of data centralization is exactly the number of data points of curve, and the structure and the call format that flow according to numerical value write this integer value in the numerical value stream, as first content of numerical value stream;
4. according to the structure and the call format of numerical value stream, the depth value of the current record pointer indication data record of data centralization is write numerical value stream with the form of floating number;
5. according to the structure and the call format of numerical value stream, write the curve values of every curve under the current degree of depth successively, the curve values of the current record pointer indication data record of data centralization is write numerical value stream with the form of floating number successively according to the front and back order of field location;
6. judge whether the data of all depth points are all write numerical value stream.Judge promptly whether record pointer moves to the record set end; If be the last item record, then the generation of numerical value stream is finished.Otherwise, move a record behind the current record pointer with data set, locate next depth point, turn back to 4. step continuation execution.
4. the method for curve data numerical value flow transmission according to claim 1 and parsing, wherein flow the structure and the call format of the numerical value stream that transmits between maker and the numerical value stream analyzer according to numerical value, logarithm value stream is resolved, and obtains to draw the concrete depth value and the curve values data of every required curve of well log.May further comprise the steps:
1. receive the numerical value stream that from numerical value stream maker, transmits, and, begin to read an integer numerical value, be the number of data points of curve from numerical value stream head according to structure and call format that numerical value flows;
2. whether the integer obtained of judgement is 0.Promptly judge to wait to plot whether have data point,, then return sky, show and do not get the data that the user wants curve plotting if this numerical value is 0; Otherwise, step below continuing;
3. according to the structure and the call format of numerical value stream, from numerical value stream, read a floating number, as the depth value of curve current data point;
4. according to the structure and the call format of numerical value stream,, from numerical value stream, read floating number successively, respectively as the curve values of every curve under this degree of depth according to the order of list of fields;
5. judge whether to read the end of this numerical value stream, if this numerical value stream is run through, then numerical value stream is resolved and is finished; Otherwise turn back to 3. step continuation execution.
5. one kind based on the curve data numerical value flow transmission of logging data and log data and the device of parsing, and it comprises:
Data acquisition unit is used for obtaining logging data and log data from situ of drilling well;
Data reducer, the logging data and the log data that are used for getting access to are processed and are put in order;
User interaction means is used for the user and submits the request of data of drawing well log to;
The request analysis device is used to receive and resolve the association requests of submitting to up when the end user draws well log of asking for curve data, and generation can be asked for the SQL statement of data from data storage;
Numerical value stream maker, be connected with the request analysis device, the SQL statement that utilizes the request analysis device to parse is asked for the record set of curve data from data storage, the data that will ask for are carried out the encapsulation of numerical value stream according to the structure and the call format of numerical value stream then, generate numerical value stream;
The numerical value stream analyzer is connected with numerical value stream maker, is used to receive numerical value stream maker and passes the numerical value stream of coming, and resolve numerical value stream according to the structure and the call format of numerical value stream, obtains curve data;
Decision maker is used for according to formation lithology or oil-gas Layer in the Curves Recognition oil field prospecting exploitation research and production of the curve data drafting well log that obtains.
6. the device of curve data numerical value flow transmission according to claim 5 and parsing, wherein the request analysis device is used to resolve the request of asking for curve data that the end user submits to up.The concrete function of request analysis device is as follows:
From user's request, extract the title of the tables of data of user's submission;
From user's request, extract the field name tabulation of all curve fields of user's submission;
From user's request, extract the querying condition that is used to ask for data that the user submits to;
From user's request, extract the sort criteria that is used for data sorting that the user submits to;
The table name that extracts, the legitimacy of field name tabulation are judged, error situation is carried out abnormality processing;
Generate the SQL statement of from data storage, asking for data according to standard SQL syntax rule.
7. the device of curve data numerical value flow transmission according to claim 5 and parsing, wherein numerical value stream maker is connected with the request analysis device, is used for asking for data and generates numerical value stream from data storage.The concrete function of numerical value stream maker is as follows:
Utilize the SQL statement that parses in the request analysis device in data storage, to obtain curve data;
According to the structure and the call format of numerical value stream, in numerical value stream, write the record number (number of data points) of curve data with integer format, as first content of numerical value stream;
According to the structure and the call format of numerical value stream, in numerical value stream, write the curve values of depth value He each curve of each data point successively with the floating type form, generate numerical value and flow.
8. the device of curve data numerical value flow transmission according to claim 5 and parsing, wherein the numerical value stream analyzer is connected with numerical value stream maker, is used to resolve the numerical value stream that transmits from numerical value stream maker, parses curve data from numerical value stream.The concrete function of numerical value stream analyzer is as follows:
According to the structure and the formal definition of numerical value stream, from numerical value stream, parse the number of data points of curve;
According to the structure and the formal definition of numerical value stream, from numerical value stream, parse the depth value of each depth point of curve;
According to the structure and the formal definition of numerical value stream, from numerical value stream, parse the curve values of every curve of user's request in each depth point correspondence;
The degree of depth to the curve that parses from numerical value stream is counted, the depth value of each depth point and each curve values this depth point under reorganize, and forms the curve data that the drafting single curve is used in the well log.
9. the device of curve data numerical value flow transmission according to claim 5 and parsing, its purposes based on the device of the curve data numerical value flow transmission of logging data and log data and parsing is, according to all kinds of curves in the curve data drafting well log that obtains, discern formation lithology or oil-gas Layer in the oil field prospecting exploitation research and production, for actual production provides technical support.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101070569A CN101781986B (en) | 2010-02-09 | 2010-02-09 | Method and device for transmitting and analyzing numerical flow of curve data in logging system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101070569A CN101781986B (en) | 2010-02-09 | 2010-02-09 | Method and device for transmitting and analyzing numerical flow of curve data in logging system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101781986A true CN101781986A (en) | 2010-07-21 |
| CN101781986B CN101781986B (en) | 2012-11-07 |
Family
ID=42522130
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010101070569A Active CN101781986B (en) | 2010-02-09 | 2010-02-09 | Method and device for transmitting and analyzing numerical flow of curve data in logging system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101781986B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108005649A (en) * | 2017-12-15 | 2018-05-08 | 中国石油集团川庆钻探工程有限公司 | The method that efficiency value differentiation formation fluid property is surveyed using gas |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5799148A (en) * | 1996-12-23 | 1998-08-25 | General Electric Company | System and method for estimating a measure of confidence in a match generated from a case-based reasoning system |
| US6282452B1 (en) * | 1998-11-19 | 2001-08-28 | Intelligent Inspection Corporation | Apparatus and method for well management |
| WO2001098631A1 (en) * | 2000-06-20 | 2001-12-27 | Baker Hughes Incorporated | Case-based drilling knowledge management system |
| CN1306147C (en) * | 2004-01-21 | 2007-03-21 | 上海神开科技工程有限公司 | Comprehensive logging system and method in petroleum giological survey process |
| CN101221250A (en) * | 2007-01-12 | 2008-07-16 | 大港油田集团有限责任公司 | Three-dimensional stratum characteristic decryption method based on geologic information acquisition data |
| CN101126921A (en) * | 2007-09-28 | 2008-02-20 | 四川石油管理局地质勘探开发研究院 | Gas well oil testing logging system |
-
2010
- 2010-02-09 CN CN2010101070569A patent/CN101781986B/en active Active
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108005649A (en) * | 2017-12-15 | 2018-05-08 | 中国石油集团川庆钻探工程有限公司 | The method that efficiency value differentiation formation fluid property is surveyed using gas |
| CN108005649B (en) * | 2017-12-15 | 2021-04-09 | 中国石油集团川庆钻探工程有限公司 | Method for distinguishing formation fluid properties by gas measurement efficiency value |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101781986B (en) | 2012-11-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8402058B2 (en) | Method and computer program product for geophysical and geologic data identification, geodetic classification, organization, updating, and extracting spatially referenced data records | |
| CN103955558B (en) | Method for collecting and processing engineering investigation data of different industries | |
| CN101501684A (en) | Joint optimization of wrapper generation and template detection | |
| EP1230566A1 (en) | Oilfield analysis systems and methods | |
| CN104504047B (en) | A kind of SOLID MINERAL RESOURCES reserve estimate system based on dual-layer data storehouse | |
| CN109299202B (en) | Geological space data sharing method based on GeoSciML | |
| CN101813789B (en) | Legend vectorization method and device of geological map | |
| CN103544185B (en) | A kind of logging data file storage method | |
| CN108762808A (en) | The generation method and system of interface document | |
| US20200183044A1 (en) | Computing System Assessment of Geological Similarity of Wells Employing Well-Log Data | |
| CN105069162A (en) | Informatized exploratory adit catalog data acquisition system and method | |
| CN106055629A (en) | Single well information management system | |
| CN109143342B (en) | Seismic exploration wireless acquisition data fusion method | |
| CN103235757B (en) | Several apparatus and method that input domain tested object is tested are made based on robotization | |
| CN101916275B (en) | Method and system for accessing log data of multiple data sources | |
| CN101781986B (en) | Method and device for transmitting and analyzing numerical flow of curve data in logging system | |
| CN107797980A (en) | A kind of geological prospecting borehole data processing and control system based on Internet of Things | |
| US20210383249A1 (en) | Automatic fact extraction | |
| CN201637863U (en) | Curve data numerical value stream transmission and analysis device based on logging data and log data | |
| CN113534283B (en) | Quantitative evaluation method for ore-forming element characteristics of sandstone-type uranium ores | |
| CN109165312A (en) | A kind of survey data management system | |
| CN108229624A (en) | A kind of rock core box Quick Response Code label generation and production method | |
| CN201637861U (en) | Lithostratigraphic data based legend vectorizing device of geological map | |
| CN106640053B (en) | A kind of method and device that Measurement While Drilling Data is received automatically and handled | |
| CN109885953A (en) | A kind of mapping method and device of model component |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C53 | Correction of patent for invention or patent application | ||
| CB03 | Change of inventor or designer information |
Inventor after: Zhang Chaohuan Inventor after: Zhao Lijuan Inventor after: Yu Youmei Inventor after: Xu Shengli Inventor after: Xu Ning Inventor after: Liu Qicheng Inventor after: Shen Yuan Inventor after: Gong Yaojin Inventor after: Liu Xiaobin Inventor after: Fan Chao Inventor before: Zhang Chaohuan Inventor before: Yu Youmei Inventor before: Xu Shengli Inventor before: Xu Ning Inventor before: Liu Qicheng Inventor before: Shen Yuan |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: INVENTOR; FROM: ZHANG CHAOHUAN YU YOUMEI XU SHENGLI XU NING LIU QICHENG SHEN YUAN TO: ZHANG CHAOHUAN YU YOUMEI XU SHENGLI XU NING LIU QICHENG SHEN YUAN GONG YAOJIN LIU XIAOBIN FAN CHAO ZHAO LIJUAN |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: CHINA PETROLEUM +. NATURAL GAS CO., LTD. Free format text: FORMER OWNER: ZHANG CHAOHUAN Effective date: 20130528 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 124010 PANJIN, LIAONING PROVINCE TO: 100007 DONGCHENG, BEIJING |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20130528 Address after: 100007 Beijing, Dongzhimen, North Street, No. 9, No. Patentee after: China Petroleum & Natural Gas Co., Ltd. Address before: 124010 No. 95, oil street, Xinglongtai District, Liaoning, Panjin Patentee before: Zhang Chaohuan |