CN101882147B - Curve data storage device and method - Google Patents
Curve data storage device and method Download PDFInfo
- Publication number
- CN101882147B CN101882147B CN2010101752394A CN201010175239A CN101882147B CN 101882147 B CN101882147 B CN 101882147B CN 2010101752394 A CN2010101752394 A CN 2010101752394A CN 201010175239 A CN201010175239 A CN 201010175239A CN 101882147 B CN101882147 B CN 101882147B
- Authority
- CN
- China
- Prior art keywords
- curve
- data
- definition
- relation
- ordinate
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a curve data storage device and a curve data storage method. The curve data storage device comprises a bottom database management module, a curve database engine, a metadata management module, a module for converting curve structured query languages into standard structured query languages, and a curve data visualization module. The device provides a conversion mechanism from curve data to relation data to realize the storage of the curve data, and also provides an operational function which takes an integral curve as a basic object, and query results of the curve data are visual. In the curve data storage method, the inputted curve data is converted into the relation data for storage through the conversion mechanism from the curve data to the relation data, the integral curve can be used as the basic object to perform query, and the results can be displayed to users on a visual interface. The curve data storage device and the curve data storage method can help the users to explore the data better, only three relation data sheets are related in the curve data storage, and the query efficiency of the data is improved.
Description
Technical field
The invention belongs to field of computer data processing, be specifically related to a kind of curve data storage means and device thereof.
Background technology
For the informationization of enterprise's Traditional business process and administrative process, utilize traditional relation data library storage and management data, comparative maturity.The develop rapidly of Along with computer technology, the informatization of enterprise have entered into a new stage, and the significant work of this stage is that enterprise is information-based the business procedure of self.For example when product is made an experiment, generally all can utilize sensor to gather various test figures, the test figure that obtains through the appropriate location reason after these are collected just shows as the numeric type data sequence on mathematics.Each numeric type data sequence can be visualized as a curve, so just can regard a numeric type data sequence as a curve.In the face of the test figure of these magnanimity, the professional can not go to be concerned about each concrete coordinate points on the curve generally speaking, and care is the whole piece curve.At this moment, based on relational data model, the database that utilizes the traditional relational product to set up can not satisfy the informationalized needs of business procedure of this type enterprise effectively, mainly has the following problem.
(1) storage mode is complicated.See that from user's viewpoint relational data model is made up of one group of relation, the data structure of each relation is the bivariate table of a standard, wants to describe the related data information of the data object of this complicacy of curve, can cause storage mode to become complicated.
(2) inquiry and operation efficiency are on the low side.What the database that utilizes the traditional relational product to set up adopted is the mode of operation towards set; Can't be with curve as the basic operation object; When inquiring about with computing to the data object of this complicacy of curve; Can cause the joint operation of multilayer table, thus cause the inquiry and operation efficiency low.
(3) a visual data manipulation environment can't be provided.Traditional relational database only provides a kind of organizational form of data, data are not carried out visual, thereby can not help the distribution of user's observed data better, obtain relation and rule in the mass data.
University of Petroleum's journal (natural science edition) calendar year 2001 the 25th volume the 5th phase article numbering: the big data volume data type of the scale-of-two BLOB that proposition utilizes relational database ORACLE8 to provide in 100-5870 (2001) the 05-0100-02 literary composition that " utilizes database and graph processing technique to realize the storage and the management of logging trace data " deposits curve data; Though can effectively improve data storage efficiency; But still be as basic unit of storage with data point; When running into operation such as magnanimity curve data storage and curve calculation, efficient is still not high.
Summary of the invention
The invention provides a kind of curve data memory storage and storage means thereof; It is based upon on the traditional relational basis, provides a kind of curve data to the changing the mechanism of relation data, and has realized the storage to curve data; Simultaneously; It also provides with the whole piece curve is the operating function of basic object, and has realized the visual of curve data, thereby can help user's heuristic data better.
A kind of curve data memory storage is characterized in that, comprises like lower module:
Bottom data database management module, diagram database engine, metadata management module, curve structured query language are to normal structure query language modular converter, curve data visualization model.
The curve structured query language receives curve data storage request to normal structure query language modular converter; Convert the curve data storage request of input into the normal structure query statement, and the normal structure query statement is passed to the diagram database engine; Diagram database engine operative norm structured query sentence is accomplished the storage operation to relation data through bottom data database management module and relational database engine, and the result that the bottom data database management module is sent back passes to the curve data visualization model; The curve data visualization model is shown to the user with the result.
Said bottom data database management module administrative relationships database, the relation data that curve data is changed deposits in from relational database or reads.
Said metadata management module management, safeguard the metadata that relates in the entire curve data storage.
Said curve structured query language is to normal structure query language modular converter; Convert the curve data storage request that receives into the curve structured query statement; The metadata of utilizing the metadata management module to provide; The binding curve attribute converts the curve structured query statement into the normal structure query statement.
A kind of curve data storage means of the present invention may further comprise the steps:
Step 1: the user submits to the curve structured query language to normal structure query language modular converter through client applications or API with curve data storage request;
Step 2: the curve structured query language receives the curve data storage request that the user submits to normal structure query language modular converter, converts curve data storage request into the curve structured query statement;
Step 3: the metadata that the curve structured query language utilizes the metadata management module to provide to normal structure query language modular converter, the binding curve attribute converts the curve structured query statement into the normal structure query statement;
Step 4: diagram database engine operative norm structured query sentence, and through bottom data database management module and relational database engine, convert curve data into relation data and store in the relational database;
Step 5: judge whether new curve data storage request, if having, change step 1, if there is not execution in step six;
Step 6: data are carried out visual, finish the storage of this curve data;
At first; Relational database is delivered to the bottom data database management module with the relation data that is converted to through relational database engine; The bottom data database management module will receive to such an extent that relation data sends the diagram database engine to then; The diagram database engine sends the curve visualization model to, and last, the curve visualization model is carried out this relation data visual.
The curve attribute comprises the identification information of curve, the external information of curve and the internal information of curve in the said step 3.The identification information of curve is used for identifying the concrete curve of each bar; The external information of curve is used for explaining this curve and outside relation; The internal information of curve is used for explaining the shape attribute of this curve own.
A kind of curve data memory storage of the present invention and storage means thereof, its advantage is:
(1) a kind of curve data memory storage of the present invention can be managed a plurality of relational databases.Curve structured query language the changing the mechanism that provides through this device to the normal structure query language; For being distributed in the magnanimity numeric type data sequence in the disparate databases on the network; The user can be that base unit is analyzed them with the curve; And need not be concerned about which relational database these curve datas are stored on earth, and these curve datas be how to store etc. detailed problem.
(2) a kind of curve data storage means of the present invention helps business personnel and data analyst to find new pattern and trend from professional data centralization.This curve data memory storage not only has the memory function of curve data, goes back the service of offer curves visualization of data, and this can help the user fully to explore business datum, finds the relation and the rule that exist in the data.
(3) a kind of curve data memory storage of the present invention can reduce the application and development amount, improves the development efficiency of software systems.This device provides some application programming interfaces, and the developer can carry out secondary development on the basis of these application programming interfaces.Simultaneously; It also is the environment of an opening; The user can add the program of oneself therein according to different industry background and application demand, realizes specific operation and analytic function to curve data, thereby helps to improve the reusability of systems development process to existing work.
(4) a kind of curve data storage means of the present invention has improved the search efficiency of data.When curve is inquired about, can avoid the conjunctive query of multilayer table in the traditional relational, and only need look into three tables, just can find the concrete data of response curve.
Description of drawings
Fig. 1 is the system assumption diagram of a kind of curve data memory storage of the present invention;
Fig. 2 is a kind of curve data storage means of the present invention overview flow chart.
Embodiment
To combine accompanying drawing that the present invention is done further detailed description below.
At first combine Fig. 1 that a kind of curve data memory storage architecture is described.A kind of curve data memory storage comprises five basic function module: bottom data database management module 1, diagram database engine 2, metadata management module 3, curve structured query language are to normal structure query language modular converter 4, curve data visualization model 5.
The user is through client application module 8, or API 9 to the curve structured query language to normal structure query language modular converter 4 input curve data storage request; The curve structured query language asks that the curve data storage of input convert the normal structure query statement into to normal structure query language modular converter 4, and the normal structure query statement is passed to diagram database engine 2; Diagram database engine 2 operative norm structured query sentence are converted into the operation to database to the normal structure query statement, and through bottom data database management module 1 and the storage operation of relational database engine 7 completion to relation data; Diagram database engine 2 is passed to curve data visualization model 5 with the data result of bottom data database management module 1 storage; Curve data visualization model 5 is passed to client application module 8 with the data result of storage and is shown to the user.
Bottom data database management module 1, the relational database 6 of responsible junction curve database engine 2 and bottom deposits data in relational database 6 through relational database engine 7, or the data in the relational database 6 are taken out through relational database engine 7.Bottom data database management module 1 has shielded the detailed information of bottom relational database 6, the relational database 6 that needn't be concerned about bottom on earth usefulness be which kind of relational database product, realized the transparence of the isomery characteristic of underlying database.Bottom data database management module 1 also has a very important function, can manage a plurality of relational databases of bottom exactly.Relational database 6 can concentrate on the machine, also can be distributed on many machines in the network.For being distributed in the magnanimity numeric type data sequence in the disparate databases on the network; The user can be that base unit is analyzed them with the curve; And need not be concerned about which relational database these curve datas are stored on earth, and they be how to store etc. detailed problem.
Diagram database engine 2 is implementation centers of entire curve data storage.It is responsible for being converted into the operation to database to the curve structured query language to the normal structure query statement that normal structure query language modular converter 4 obtains; Through bottom data database management module 1 and the storage operation of relational database engine 7 completion to relation data; And be responsible for transmitting the data result of returning to bottom data database management module 1, send curve data visualization model 5 to.
The metadata that relates in the entire curve data storage is in charge of, is safeguarded to metadata management module 3.The curve structured query statement is converted in the normal structure query statement process to normal structure query language modular converter 4 at the curve structured query language, provide the transformation curve data storage required metadata.
The curve structured query language is to normal structure query language modular converter 4, and main being responsible for converts the curve structured query statement to the normal structure query statement.This module receives curve data storage request through client application module 8 or API 9; Convert curve data storage request into the curve structured query statement; On this basis; The metadata of utilizing metadata management module 3 to provide, the binding curve attribute converts the curve structured query statement into the normal structure query statement.On the basis of normal structure query language, according to the metadata that metadata management module 3 provides, be the basic operation object with the curve, the SQL of handling curve is provided., a curve data query statement through curve structured query language changing the mechanism in the normal structure query language modular converter 4, converts one or one group of corresponding standard structured query sentence into.The curve attribute comprises the identification information of curve, the external information of curve and the internal information of curve, and the identification information of curve is used for identifying the concrete curve of each bar; The external information of curve is used for explaining this curve and outside relation; The internal information of curve is used for explaining the shape attribute of this curve own.
Curve data visualization model 5, the responsible data that diagram database engine 2 is passed over are carried out visual, finally submit to client application module 8.Except that showing that in original coordinate unit curve data visualization model 5 also provides such as functions such as coordinate transform, coordinate system transformations the curve.If curve contains time dimension, so also providing with the time dimension is the curve animation display function on basis.
API 9 is meant some predefined functions, purpose provide application program and developer based on certain software or hardware visiting the ability of one group of routine, and need not to visit source code, or understand the details of internal work mechanism.
Described curve structured query statement; Converted through building the class of a curve statement: as to set up class of a curve CREATECURVE; Definition curve dimension DIMENSION, definition curve sign IDENTIFICATION, definition curved line relation RELATION; Definition curve attribute ATTRIBUTE, definition dimension data type and data type DECIMAL;
Each definition is specific as follows:
<building the class of a curve statement >: :=CREATE CURVE < curve class name>DIMENSION (< curve dimension definition>[; < curve dimension definition>} ... ]) IDENTIFICATION (< definition of curve sign >) RELATION (< curved line relation definition>[; < curved line relation definition>} ... ]) ATTRIBUTE (< curve attribute definition>[, < curve attribute definition>} ... ]);
< curve dimension definition >: :=< dimension name>< dimension data type>[NOT NULL]
< dimension data type >: :=DECIMAL [(< precision>[, < scale factor >])] | INTEGER|FLOAT|DATE
< definition of curve sign >: :=< identification name>< data type>[NOT NULL]
< curved line relation definition >: :=< relation name>< data type>[NOT NULL]
< curve attribute definition >: :=< attribute-name>< data type>[NOT NULL]
< data type >: :=DECIMAL [(< precision>[, < scale factor >])] |
INTEGER|FLOAT|CHAR (< length >) | DATE|LONG RAW
Wherein, NOT NULL representative is not empty; INTEGER, FLOAT, DATE, CHAR, LONG RAW represent that respectively data type is integer, floating type, date type, character type, variable length binary data type.
Described normal structure query statement, converted through creating new table CREAT TABLE, create the concrete definition of new table CREATTABLE as follows:
CREAT TABLE <table name>(< row name>< data type>[row level integrity constrains]
[, < row name>< data type>[row level integrity constrains]]
…
[, <table level integrity constrains >]).
Diagram database engine 2 operative norm structured query sentence; Through bottom data database management module 1 and the storage operation of relational database engine 7 completion to curve data; Specifically be all to use three tables to store each bar curve, three tables are the external information table of curve data flag information table, curve data and the internal information table of curve data:
Curve data flag information table comprises curve numbering, coordinate number, horizontal ordinate tables of data title, horizontal ordinate sign, horizontal ordinate minimum value sign, horizontal ordinate maximal value sign, horizontal ordinate paint type, ordinate tables of data title, ordinate sign, ordinate minimum value sign, ordinate maximal value sign, ordinate paint type;
The external information table of curve data comprises equipment under test title, test branch, test specimen title, test specimen grade, test type, direction of vibration, test class, measuring point title, measuring point direction, data type;
The internal information table of curve data comprises curve numbering, one to five rank peak value horizontal ordinate numerical value, one to five rank valley horizontal ordinate numerical value, one to five rank peak value Y value, one to five rank valley Y value, one to five rank peak value ordinate imaginary part numerical value, one to five rank valley ordinate imaginary part numerical value, mean value, root-mean-square value, horizontal ordinate minimum value, horizontal ordinate maximal value, ordinate minimum value, ordinate maximal value, curve picture.
The present invention uses a kind of curve data storage means of above-mentioned curve data memory storage, and is as shown in Figure 2, comprises the steps:
Step 1: the user directly utilizes client application module 8 or API 9, and curve data storage request is submitted to the curve structured query language to normal structure query language modular converter 4.
Step 2: the curve structured query language receives the curve data storage request that the user submits to normal structure query language modular converter 4, converts curve data storage request into the curve structured query statement.
The curve structured query language receives curve data storage request to normal structure query language modular converter 4, converts this request into the curve structured query statement through building the class of a curve statement as follows.Set up class of a curve CREATE CURVE, definition curve dimension DIMENSION, definition curve sign IDENTIFICATION, definition curved line relation RELATION, definition curve attribute ATTRIBUTE, definition dimension data type and data type DECIMAL.Each definition is specific as follows:
<building the class of a curve statement >: :=CREATE CURVE < curve class name>DIMENSION (< curve dimension definition>[; < curve dimension definition>} ... ]) IDENTIFICATION (< definition of curve sign >) RELATION (< curved line relation definition>[; < curved line relation definition>} ... ]) ATTRIBUTE (< curve attribute definition>[, < curve attribute definition>} ... ]);
< curve dimension definition >: :=< dimension name>< dimension data type>[NOT NULL]
< dimension data type >: :=DECIMAL [(< precision>[, < scale factor >])] | INTEGER|FLOAT|DATE
< definition of curve sign >: :=< identification name>< data type>[NOT NULL]
< curved line relation definition >: :=< relation name>< data type>[NOT NULL]
< curve attribute definition >: :=< attribute-name>< data type>[NOT NULL]
< data type >: :=DECIMAL [(< precision>[, < scale factor >])] |
INTEGER|FLOAT|CHAR (< length >) | DATE|LONG RAW
Step 3: utilize metadata management module 3, the binding curve attribute, the curve structured query language converts the curve structured query statement into the normal structure query statement to normal structure query language modular converter 4.
The metadata that metadata management module 3 provides is meant the data of storing used data element about curve data; For example; This data elements of test branch of using in the profile memory, its metadata are exactly record number, test branch Chinese, test branch's English name and the test branch base table title of finger to finger test branch.
The metadata of utilizing metadata management module 3 to provide; The external attribute of binding curve Data Labels attribute, curve data and the built-in attribute of curve data convert above-mentioned curve structured query statement to the normal structure query statement through creating new table CREAT TABLE.Create the concrete definition of new table CREAT TABLE as follows:
CREAT TABLE <table name>(< row name>< data type>[row level integrity constrains]
[, < row name>< data type>[row level integrity constrains]]
…
[, <table level integrity constrains >])
Step 4: diagram database engine 2 operative norm structured query sentence, and through bottom data database management module 1 and relational database engine 7, convert curve data into relation data and store in the relational database.
To pass through the curve structured query language and build the predicative sentence, pass to diagram database engine 2 to the normal structure query statement CREAT TABLE that normal structure query language modular converter 4 obtains.
Through carrying out above-mentioned normal structure query statement, each bar curve all uses three tables that its relevant information is stored, and three tables are the external information table of curve data flag information table, curve data and the internal information table of curve data.
Curve data flag information table comprises curve numbering, coordinate number, horizontal ordinate tables of data title, horizontal ordinate sign, horizontal ordinate minimum value sign, horizontal ordinate maximal value sign, horizontal ordinate paint type, ordinate tables of data title, ordinate sign, ordinate minimum value sign, ordinate maximal value sign, ordinate paint type.
The external information table of curve data comprises equipment under test title, test branch, test specimen title, test specimen grade, test type, direction of vibration, test class, measuring point title, measuring point direction, data type.
The internal information table of curve data comprises curve numbering, one to five rank peak value horizontal ordinate numerical value, one to five rank valley horizontal ordinate numerical value, one to five rank peak value Y value, one to five rank valley Y value, one to five rank peak value ordinate imaginary part numerical value, one to five rank valley ordinate imaginary part numerical value, mean value, root-mean-square value, horizontal ordinate minimum value, horizontal ordinate maximal value, ordinate minimum value, ordinate maximal value, curve picture.Step 5: judge whether new curve data storage request, if having, change step 1, if there is not execution in step six.
Step 6: data are carried out visual, finish the storage of this curve data.
At first, relational database 6 is delivered to bottom data database management module 1 with the relation data that is converted to through relational database engine 7.The relation data that is converted to comprises the external information table of curve data flag information table, curve data and the internal information table of curve data.
Then, bottom data database management module 1 receives after the internal information table of external information table and curve data of curve data flag information table, curve data, sends it to diagram database engine 2.
Then, diagram database engine 2 sends the external information table of curve data flag information table, curve data and the internal information table of curve data to curve visualization model 5.
At last, curve data visualization model 5 receives curve data flag information table, the external information table of curve data and the internal information table information of curve data that sends, and carries out it visual.
Claims (4)
1. a curve data memory storage is characterized in that, comprises that bottom data database management module, diagram database engine, metadata management module, curve structured query language are to normal structure query language modular converter and curve data visualization model;
The curve structured query language receives curve data storage request to normal structure query language modular converter; Convert the curve data storage request of input into the normal structure query statement, and the normal structure query statement is passed to the diagram database engine; Described curve structured query language is to normal structure query language modular converter; The concrete grammar that the curve data storage of input is asked to convert the normal structure query statement into is: convert the curve data storage request that receives into the curve structured query statement; The metadata of utilizing the metadata management module to provide; The binding curve attribute converts the curve structured query statement into the normal structure query statement; Diagram database engine operative norm structured query sentence converts curve data into relation data, accomplishes the storage operation to relation data through bottom data database management module and relational database engine; The storage data result that the diagram database engine is sent the bottom data database management module back passes to the curve data visualization model; The curve data visualization model is shown to the user with this result;
Bottom data database management module administrative relationships database, the relation data that curve data is changed deposits in from relational database or reads;
The metadata management module management, safeguard the metadata that relates in the entire curve data storage; The curve structured query statement is converted in the normal structure query statement process to normal structure query language modular converter at the curve structured query language, provide the transformation curve data storage required metadata;
Described curve structured query statement is that curve data storage request is converted through creating the class of a curve statement: set up class of a curve CREATE CURVE, definition curve dimension DIMENSION, definition curve sign IDENTIFICATION, definition curved line relation RELATION, definition curve attribute ATTRIBUTE and definition dimension data type and data type DECIMAL;
Each definition is specific as follows:
<building the class of a curve statement >: :=CREATE CURVE < curve class name>DIMENSION (< curve dimension definition>[; < curve dimension definition>} ... ]) IDENTIFICATION (< definition of curve sign >) RELATION (< curved line relation definition>[; < curved line relation definition>} ... ]) ATTRIBUTE (< curve attribute definition>[, < curve attribute definition>} ... ]);
< curve dimension definition >: :=< dimension name>< dimension data type>[NOT NULL]
< dimension data type >: :=DECIMAL [(< precision>[, < scale factor >])] | INTEGER|FLOAT|DATE
< definition of curve sign >: :=< identification name>< data type>[NOT NULL]
< curved line relation definition >: :=< relation name>< data type>[NOT NULL]
< curve attribute definition >: :=< attribute-name>< data type>[NOT NULL]
< data type >: :=DECIMAL [(< precision>[, < scale factor >])] |
INTEGER|FLOAT|CHAR (< length >) | DATE|LONG RAW
Wherein, NOT NULL representative is not empty; INTEGER, FLOAT, DATE, CHAR, LONG RAW represent that respectively data type is integer, floating type, date type, character type, variable length binary data type; Described normal structure query statement is that the curve structured query statement is converted through creating new table CREAT TABLE statement, creates the concrete definition of new table CREAT TABLE as follows:
CREAT TABLE <table name>(< row name>< data type>[row level integrity constrains]
[, < row name>< data type>[row level integrity constrains]]
...
[, <table level integrity constrains >]);
Described curve attribute comprises the identification information of curve, the external information of curve and the internal information of curve; The identification information of curve is used for identifying the concrete curve of each bar; The external information of curve is used for explaining this curve and outside relation; The internal information of curve is used for explaining the shape attribute of this curve own.
2. a kind of curve data memory storage according to claim 1 is characterized in that, said diagram database engine operative norm structured query sentence converts curve data into relation data, and each bar curve stores with three tables, specifically:
Curve data flag information table comprises curve numbering, coordinate number, horizontal ordinate tables of data title, horizontal ordinate sign, horizontal ordinate minimum value sign, horizontal ordinate maximal value sign, horizontal ordinate paint type, ordinate tables of data title, ordinate sign, ordinate minimum value sign, ordinate maximal value sign and ordinate paint type;
The external information table of curve data comprises equipment under test title, test branch, test specimen title, test specimen grade, test type, direction of vibration, test class, measuring point title, measuring point direction and data type;
The internal information table of curve data comprises curve numbering, one to five rank peak value horizontal ordinate numerical value, one to five rank valley horizontal ordinate numerical value, one to five rank peak value Y value, one to five rank valley Y value, one to five rank peak value ordinate imaginary part numerical value, one to five rank valley ordinate imaginary part numerical value, mean value, root-mean-square value, horizontal ordinate minimum value, horizontal ordinate maximal value, ordinate minimum value, ordinate maximal value and curve picture.
3. application rights requires a kind of curve data storage means of 1 said curve data memory storage, it is characterized in that, may further comprise the steps:
Step 1: the user submits to the curve structured query language to normal structure query language modular converter through client application module or API with curve data storage request;
Step 2: the curve structured query language receives the curve data storage request that the user submits to normal structure query language modular converter, converts curve data storage request into the curve structured query statement;
Described curve structured query statement, converted through building the class of a curve statement: as to set up class of a curve CREATECURVE, definition curve dimension DIMENSION, definition curve sign IDENTIFICATION, definition curved line relation RELATION, definition curve attribute ATTRIBUTE and definition dimension data type and data type DECIMAL;
Each definition is specific as follows:
<building the class of a curve statement >: :=CREATE CURVE < curve class name>DIMENSION (< curve dimension definition>[; < curve dimension definition>} ... ]) IDENTIFICATION (< definition of curve sign >) RELATION (< curved line relation definition>[; < curved line relation definition>} ... ]) ATTRIBUTE (< curve attribute definition>[, < curve attribute definition>} ... ]);
< curve dimension definition >: :=< dimension name>< dimension data type>[NOT NULL]
< dimension data type >: :=DECIMAL [(< precision>[, < scale factor >])] | INTEGER|FLOAT|DATE
< definition of curve sign >: :=< identification name>< data type>[NOT NULL]
< curved line relation definition >: :=< relation name>< data type>[NOT NULL]
< curve attribute definition >: :=< attribute-name>< data type>[NOT NULL]
< data type >: :=DECIMAL [(< precision>[, < scale factor >])] |
INTEGER|FLOAT|CHAR (< length >) | DATE|LONG RAW
Wherein, NOT NULL representative is not empty; INTEGER, FLOAT, DATE, CHAR, LONG RAW represent that respectively data type is integer, floating type, date type, character type, variable length binary data type;
Step 3: the metadata that the curve structured query language utilizes the metadata management module to provide to normal structure query language modular converter, the binding curve attribute converts the curve structured query statement into the normal structure query statement;
Said curve attribute comprises the identification information of curve, the external information of curve and the internal information of curve; The identification information of curve is used for identifying the concrete curve of each bar; The external information of curve is used for explaining this curve and outside relation; The internal information of curve is used for explaining the shape attribute of this curve own;
Described normal structure query statement, converted through creating new table CREAT TABLE, create the concrete definition of new table CREATTABLE as follows:
CREAT TABLE <table name>(< row name>< data type>[row level integrity constrains]
[, < row name>< data type>[row level integrity constrains]]
...
[, <table level integrity constrains >]);
Step 4: diagram database engine operative norm structured query sentence, and through bottom data database management module and relational database engine, convert curve data into relation data and store in the relational database;
Step 5: judge whether new curve data storage request, if having, change step 1, if there is not execution in step six;
Step 6: data are carried out visual, finish the storage of this curve data;
At first; Relational database is delivered to the bottom data database management module with the relation data that is converted to through relational database engine; The bottom data database management module will receive to such an extent that relation data sends the diagram database engine to then; The diagram database engine sends the curve visualization model to, and last, the curve visualization model is carried out this relation data visual.
4. a kind of curve data storage means according to claim 3; It is characterized in that; Convert curve data into relation data described in the step 4; Each bar curve all uses three tables to store, and three tables are the external information table of curve data flag information table, curve data and the internal information table of curve data;
Curve data flag information table comprises curve numbering, coordinate number, horizontal ordinate tables of data title, horizontal ordinate sign, horizontal ordinate minimum value sign, horizontal ordinate maximal value sign, horizontal ordinate paint type, ordinate tables of data title, ordinate sign, ordinate minimum value sign, ordinate maximal value sign and ordinate paint type;
The external information table of curve data comprises equipment under test title, test branch, test specimen title, test specimen grade, test type, direction of vibration, test class, measuring point title, measuring point direction and data type;
The internal information table of curve data comprises curve numbering, one to five rank peak value horizontal ordinate numerical value, one to five rank valley horizontal ordinate numerical value, one to five rank peak value Y value, one to five rank valley Y value, one to five rank peak value ordinate imaginary part numerical value, one to five rank valley ordinate imaginary part numerical value, mean value, root-mean-square value, horizontal ordinate minimum value, horizontal ordinate maximal value, ordinate minimum value, ordinate maximal value and curve picture.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101752394A CN101882147B (en) | 2010-05-12 | 2010-05-12 | Curve data storage device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101752394A CN101882147B (en) | 2010-05-12 | 2010-05-12 | Curve data storage device and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101882147A CN101882147A (en) | 2010-11-10 |
| CN101882147B true CN101882147B (en) | 2012-07-25 |
Family
ID=43054162
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010101752394A Expired - Fee Related CN101882147B (en) | 2010-05-12 | 2010-05-12 | Curve data storage device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101882147B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101982820B (en) * | 2010-11-22 | 2011-12-07 | 北京航空航天大学 | Curve display and inquiry method for large data quantity |
| US9043334B2 (en) | 2012-12-26 | 2015-05-26 | Industrial Technology Research Institute | Method and system for accessing files on a storage system |
| CN106528635B (en) * | 2016-10-12 | 2019-04-12 | 青岛大学 | Storage system, storage method and the querying method of 2-D data |
| CN108920667B (en) * | 2018-07-05 | 2022-03-01 | 中国石油天然气集团有限公司 | Logging data organization display method based on test depth and test time |
| CN109033388B (en) * | 2018-07-30 | 2021-10-29 | 华北理工大学 | Method for accurately reading point coordinates on graph picture |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101059810A (en) * | 2007-03-16 | 2007-10-24 | 华为技术有限公司 | System and method for implementing automatic optimization of data base system |
| CN101520801A (en) * | 2009-01-14 | 2009-09-02 | 中国科学院地理科学与资源研究所 | Method for storing space geometric objects to database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060009916A1 (en) * | 2004-07-06 | 2006-01-12 | Xitong Li | Quantitative PCR data analysis system (QDAS) |
-
2010
- 2010-05-12 CN CN2010101752394A patent/CN101882147B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101059810A (en) * | 2007-03-16 | 2007-10-24 | 华为技术有限公司 | System and method for implementing automatic optimization of data base system |
| CN101520801A (en) * | 2009-01-14 | 2009-09-02 | 中国科学院地理科学与资源研究所 | Method for storing space geometric objects to database |
Non-Patent Citations (4)
| Title |
|---|
| 张卫钢等.利用VC++实现接收数据到曲线的转换及其动态显示.《工业控制计算机》.2003,第16卷(第10期),第52-53页. * |
| 张燕等.工程曲线的数字化及数据的查询.《机械设计与制造》.2003,(第6期),第41-42页. * |
| 董国卿等.利用数据库和图形处理技术实现测井曲线数据的存储和管理.《石油大学学报(自然科学版)》.2001,第25卷(第5期),第100-101页. * |
| 赵卫强等.基于VB6.0的监控系统软件中数据存储及数据曲线实现方法的研究.《沈阳航空工业学院学报》.2003,第20卷(第1期),第31-34页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101882147A (en) | 2010-11-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7925658B2 (en) | Methods and apparatus for mapping a hierarchical data structure to a flat data structure for use in generating a report | |
| US7720873B2 (en) | Dynamic data discovery of a source data schema and mapping to a target data schema | |
| US8060531B2 (en) | Data query and location through a central ontology model | |
| Morzy et al. | On querying versions of multiversion data warehouse | |
| US20080016041A1 (en) | Spreadsheet-based relational database interface | |
| Kim et al. | Toward standardized exchange of plant 3D CAD models using ISO 15926 | |
| JP2000148814A (en) | Component part data management system and computer readable storage medium with component part data management program stored therein | |
| CN101882147B (en) | Curve data storage device and method | |
| US8005785B2 (en) | Apparatus and method for routing composite objects to a report server | |
| Eide et al. | Encoding cultural heritage information for the semantic web. procedures for data integration through cidoc-crm mapping | |
| Kriegel et al. | SQL bible | |
| Eid-Sabbagh et al. | A platform for research on process model collections | |
| Möller et al. | Why It Is Time for Yet Another Schema Evolution Benchmark: Visionary Paper | |
| Grün et al. | Pushing xpath accelerator to its limits | |
| Simon et al. | Aspects of the Long-Term Preservation of Digitized Catalogue Data: Analysis of the Databases of Integrated Collection Management Systems | |
| Alhammadi et al. | Developing a Historic Environment Record system for the management of heritage resources in the emirate of Abu Dhabi | |
| Kennedy et al. | The Right Tool for the Job: Data-Centric Workflows in Vizier | |
| Koch et al. | Representation of CityGML instance models in BaseX | |
| Bajral | Library automation with e-Granthalaya software | |
| Burrows | Linked Open Data and Medieval Studies: Some Lessons from the Mapping Manuscript Migrations Project | |
| Murtomaa | The impact of the functional requirements for bibliographic records recommendations on the ISBD (ER) | |
| Ahonen-Rainio | Metadata for geographic information | |
| Yu et al. | Object-relational data modelling for informetric databases | |
| Manso-Callejo et al. | The design of an automated workflow for metadata generation | |
| Kashyap | Classified Catalogue Code of Ranganathan: A proposal to make it compatible for developing compute based library information systems |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120725 Termination date: 20140512 |