CN110321360A - The processing method and relevant device of list data - Google Patents
The processing method and relevant device of list data Download PDFInfo
- Publication number
- CN110321360A CN110321360A CN201910613577.2A CN201910613577A CN110321360A CN 110321360 A CN110321360 A CN 110321360A CN 201910613577 A CN201910613577 A CN 201910613577A CN 110321360 A CN110321360 A CN 110321360A
- Authority
- CN
- China
- Prior art keywords
- function
- nested tables
- instruction
- handling function
- nested
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
This application provides a kind of processing method of list data and its relevant device, can reduce in database can nested tables processing difficulty, improve processing speed.This method comprises: obtain to can nested tables object run instruct, object run instruction in carry to can nested tables order and can nested tables parameter information, can nested tables include a root table, root table include N number of sub-table, wherein, N is the positive integer more than or equal to 0;It is instructed according to object run and determines M handling function, M handling function is can handling function corresponding with object run instruction in nested tables handling function system, the multiple handling functions that can be stored in nested tables handling function system including M handling function, wherein, M is the positive integer more than or equal to 1;According to can nested tables parameter information and M handling function determine objective result, objective result instruction to can the operations of nested tables whether succeed.
Description
Technical field
This application involves software field more particularly to the processing methods and its relevant device of a kind of list data.
Background technique
In many software applications, can all there is an operation of a large amount of table class data, including table creation, newly-increased, modification,
Inquiry, destruction etc..
Traditional approach can define many table class data processing functions according to business demand and remove operating database, and be inserted into
The SQL statement of various database manipulations, logic are extremely complex.This requires programming personnels must be familiar with database manipulation language
And the logical relation between data form, it is big in turn result in learning cost height, processing difficulty.
Summary of the invention
This application provides a kind of processing method of list data and its relevant device, can reduce can be embedding in database
The processing difficulty of table class data is covered, processing speed is improved.
The first aspect of the embodiment of the present application provides a kind of processing method of list data, comprising:
Obtain to can the object runs of nested tables instruct, carried in object run instruction to it is described can be nested
The order of table and it is described can nested tables parameter information, it is described can nested tables include a root table, described table include
N number of sub-table, wherein N is the positive integer more than or equal to 0;
It is instructed according to the object run and determines M handling function, the M handling function is can nested tables operation
Handling function corresponding with object run instruction in function system, it is described to be stored in nested tables handling function system
There are multiple handling functions including the M handling function, wherein M is the positive integer more than or equal to 1;
According to it is described can nested tables parameter information and the M handling function determine objective result, the target
As a result indicate to it is described can the operations of nested tables whether succeed, and the objective result and the M handling function have pass
Connection relationship.
Optionally, described instructed according to the object run determines that M handling function includes:
By instruction explain execution system judge object run instruction grammer whether mistake, described instruction explains
The corresponding grammer of a plurality of instruction being stored in execution system including the corresponding grammer of the target instruction target word;
If it is not, then explaining that the grammar compilation rule in execution system compiles object run instruction according to instruction
It translates, to generate program statement corresponding with object run instruction;
The M handling function is called by described program sentence.
Optionally, it is described according to can nested tables parameter information and the M handling function determine target knot
Fruit includes:
Described in judgement can the mark of table mark in the parameter information of nested tables and the table stored in database be
No matching, it is described can nested tables parameter information include it is described can nested tables table mark, index field and table
Field, be stored in the database including it is described can multiple tables including nested tables;
If so, by the M handling function to it is described can the parameter informations of nested tables handle, obtain described
Objective result.
Optionally, it is described by the M handling function to it is described can the parameter informations of nested tables handle, obtain
The objective result includes:
When the M handling function includes table creation function, by the table create function to it is described can be nested
The table mark of table, index field and table field are handled, with described in generating can nested tables formatting number
According to;
By it is described can nested tables format data store into the database with it is described can nested tables it is corresponding
Storage region;
Return to the objective result, described in the objective result instruction can nested tables create successfully.
Optionally, described table includes at least one root record, every height when N is greater than 0, in N number of sub-table
Table includes at least one record, and each subrecord at least one described subrecord includes Hidden field, the implicit word
Section write-in target record mark, the target record identifies corresponding with comprising recording for the Hidden field in described table
Root table record.
Optionally, the M handling function is at least one of following handling function:
Table creates function, the new increasing function of charting, charting and deletes function, charting Modification growth function, table
Record queries function, charting function reading, table destroy function and the new increasing function of index.
The embodiment of the present application second aspect provides a kind of processing unit of list data, comprising:
Acquiring unit, for obtain to can nested tables object run instruction, carry in object run instruction
To it is described can nested tables order and it is described can nested tables parameter information, it is described can nested tables include a root table,
Described table includes N number of sub-table, wherein N is the positive integer more than or equal to 0;
First determination unit determines M handling function, the M handling function for instructing according to the object run
For can handling function corresponding with object run instruction in nested tables handling function system, it is described can nested tables behaviour
Make to be stored with multiple handling functions including the M handling function in function system, wherein M is more than or equal to 1
Positive integer;
Second determination unit, for according to can nested tables parameter information and the M handling function determine
Objective result, objective result instruction to it is described can the operations of nested tables whether succeed, and the objective result with it is described
M handling function has incidence relation.
Optionally, first determination unit is specifically used for:
By instruction explain execution system judge object run instruction grammer whether mistake, described instruction explains
The corresponding grammer of a plurality of instruction being stored in execution system including the corresponding grammer of the target instruction target word;
If it is not, then explaining that the grammar compilation rule in execution system compiles object run instruction according to instruction
It translates, to generate program statement corresponding with object run instruction;
The M handling function is called by described program sentence.
Optionally, second determination unit is specifically used for:
Described in judgement can the mark of table mark in the parameter information of nested tables and the table stored in database be
No matching, it is described can nested tables parameter information include it is described can nested tables table mark, index field and table
Field, be stored in the database including it is described can multiple tables including nested tables;
If so, by the M handling function to it is described can the parameter informations of nested tables handle, obtain described
Objective result.
Optionally, second determination unit by the M handling function to it is described can nested tables parameter information into
Row processing, obtaining the objective result includes:
When the M handling function includes table creation function, by the table create function to it is described can be nested
The table mark of table, index field and table field are handled, with described in generating can nested tables formatting number
According to;
By it is described can nested tables format data store into the database with it is described can nested tables it is corresponding
Storage region;
Return to the objective result, described in the objective result instruction can nested tables create successfully.
Optionally, described table includes at least one root record, every height when N is greater than 0, in N number of sub-table
Table includes at least one record, and each subrecord at least one described subrecord includes Hidden field, the implicit word
Section write-in target record mark, the target record identifies corresponding with comprising recording for the Hidden field in described table
Root table record.
Optionally, the M handling function is at least one of following handling function:
Table creates function, the new increasing function of charting, charting and deletes function, charting Modification growth function, table
Record queries function, charting function reading, table destroy function and the new increasing function of index.
The third aspect of the embodiment of the present application provides a kind of computer readable storage medium, including instruction, when instruction exists
When being run on computer, so that computer executes the method as described in above-mentioned various aspects.
6th aspect of the embodiment of the present application provides a kind of computer program product comprising instruction, when it is being calculated
When being run on machine, so that computer executes the method as described in above-mentioned various aspects.
In view of the foregoing it is apparent that in embodiment provided by the present application, obtain to can the object runs of nested tables refer to
It enables;Instructed according to object run and determine M handling function, M handling function for can in nested tables handling function system with mesh
The corresponding handling function of operational order is marked, can be stored with including M handling function in nested tables handling function system
Multiple handling functions;According to can nested tables parameter information and M handling function determine that object run instructs corresponding mesh
Mark as a result, objective result instruction to can nested tables class data whether operate success.Due to that can shift to an earlier date in the application can be nested
Multiple table handling functions are stored in table handling function system, it, can be according to operational order from can when obtaining operational order
Corresponding table handling function is got in nested tables handling function system, and can be nested according to what is carried in operational order
The parameter information and table handling function of table generate objective result, objective result instruction to can nested tables operation
Whether succeed.For the existing SQL sentence by various database manipulations, can reduce can be nested in database
The processing difficulty of table improves processing speed.
Detailed description of the invention
Fig. 1 be it is provided by the embodiments of the present application can nested tables class data operation system architecture diagram;
Fig. 2 is the flow diagram of the processing method of list data provided by the embodiments of the present application;
Fig. 3 is the virtual architecture schematic diagram of the processing unit of list data provided by the embodiments of the present application;
Fig. 4 is the hardware structural diagram of server provided by the embodiments of the present application.
Specific embodiment
The description and claims of this application and term " first ", " second ", " third ", " in above-mentioned attached drawing
The (if present)s such as four " are to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should
Understand that the data used in this way are interchangeable under appropriate circumstances, so that the embodiments described herein can be in addition to herein
Sequence other than diagram or the content of description is implemented.In addition, term " includes " and " having " and their any deformation, meaning
Figure be to cover it is non-exclusive include, for example, containing the process, method of a series of steps or units, system, product or setting
It is standby those of to be not necessarily limited to be clearly listed step or unit, but may include be not clearly listed or for these mistakes
The intrinsic other step or units of journey, method, product or equipment.
Can nested tables to refer to the type table not only include several fields, can also include several sub-tables, and sublist
Lattice can continue comprising next stage sub-table, and the type table can be from nested (oneself including oneself).
If all tables in database are defined as object according to business demand, table can also be to object definition
Equally realize that nested includes sub-table.Such as: bicycle is an object, can be expressed with a table.Below with " certainly
Driving " is that object description can nested tables:
" tire " table is a subobject of " bicycle " object, can be used as the sub-table of " bicycle " table,
" wheel hub " table is the sub-table of " tire " table again, and so on, " bicycle " table is exactly the root of bicycle object, packet
Containing a series of sub-table, the set membership table class object of this tree structure can be realized with a kind of data structure.When wanting
Obtain any information of " bicycle " object, it can as the operation of access object class data, provide a table pointer
Variable may have access to, and without the incidence relation as traditional approach inquiry father and son's table, operates a series of SQL statements, improves
Service speed.
So having the processing method and instruction system of this special data form, a variable parameter and one are realized
Item instruction is the big flow function and sentence of alternative traditional approach, and easily operating database, can also avoid traditional programming
The mistake of sentence.
Combine Fig. 1 to the processing method of list data provided by the embodiments of the present application and the system tray of relevant device first
Structure is illustrated:
Referring to Fig. 1, Fig. 1 be it is provided by the embodiments of the present application can nested tables class data operation system 100 framework
Figure, the system include four parts:
Instruction explain execution system 101, can nested tables handling function system 102, Persistent Store Database 103, memory
Storing data library 104.
Instruction explains that execution system 101 is responsible for explaining the operational order of list data, checks syntax rule, root
According to operational order and its parameter logistics, be construed to can the corresponding function operation of nested tables handling function system, and execute the behaviour
Make instruction respective operations;
Can nested tables handling function system 102 include a series of form-oriented class objects handling function, including table
It creates function, the new increasing function of charting, charting Modification growth function, charting and deletes function, charting inquiry letter
Number, table destroy function and the new increasing function of index etc..These functions are according to table class object logic, respectively to persistently depositing
It stores up database 103 or data stored in memory library 104 sends database operating instruction, realize respective function function;
Persistent Store Database 103 refers to the number on the media such as the FLASH for being stored in terminal device or server, hard disk
According to library system, such as: mySQL, SQLLite etc..
Data stored in memory library 104 refers to the database being stored in current thread memory.
Below with reference to Fig. 2, with the angle of the processing unit of list data to list data provided by the embodiments of the present application
Processing method is illustrated, and the processing unit of the list data can be server, or the service list in server
Member, specifically without limitation.
Referring to Fig. 2, Fig. 2 is the flow diagram of the processing method of list data provided by the embodiments of the present application, packet
It includes:
201, obtain to can nested tables object run instruct.
In the present embodiment, the processing unit of list data it is available to can nested tables object run instruct, example
Such as the object run instruction can for can nested tables newly-built instruction programmed statements (such as C language sentence), either
To can record in nested tables deletion instruction, specifically without limitation, wherein carrying in object run instruction can be embedding
Cover table order and can nested tables parameter information, wherein this can nested tables include a root table, the root table include N
A sub-table, wherein N is the positive integer more than or equal to 0.
It should be noted that root table includes at least one root record, each sublist when N is greater than 0, in N number of sub-table
Lattice include at least one record, and each subrecord at least one subrecord includes Hidden field, and target is written in Hidden field
Record identification, target record are identified in root table and are recorded with the corresponding table that record comprising Hidden field.That is, root table
The inside contains at least one root record, and root table is the parent table of N number of sublist, can also increase by one in every record of sublist
The mark that this records corresponding father's charting is written in a Hidden field, the Hidden field, and the father and son established between record is closed
Connection, every father's charting can be associated with 0 or a plurality of sub-table record.Every strip charting must be associated with a parent table
Record.
It should be noted that can also be with nested sublist in the target sublist, which is in N number of sub-table
Any one, when nested sublist again in target sublist, which is parent table, target sublist with it is embedding in target sublist
The relationship covered between the record of sublist is similar with the relationship of the record between target sublist and root table, above-mentioned to have been carried out
It is bright that specifically details are not described herein again.In addition, the nested situation of table can nested multilayer according to the actual situation, such as root table includes
First layer sublist, first layer sublist include second layer sublist again, and second layer sublist includes third layer sublist again, are not limited specifically
It is fixed.
202, it is instructed according to object run and determines M handling function
In the present embodiment, data processing equipment can instruct according to object run and determine M handling function, wherein the M
A handling function be can table handling function corresponding with object run instruction in nested tables handling function system, can nesting
The multiple handling functions being stored with including each handling function of M in table handling function system, M are just more than or equal to 1
Integer.
Specifically, can by instruction explain execution system judge object run instruction grammer whether mistake, instruction solve
Release the corresponding grammer of a plurality of instruction being stored with including the corresponding grammer of target instruction target word in execution system;
If it is not, then explain that the grammar compilation rule in execution system is compiled object run instruction according to instruction, with
Generate program statement corresponding with object run instruction;
M handling function is called by described program sentence.
It should be noted that the operation to table class data for convenience, the embodiment of the present application can have been formulated a set of in advance
Execution system is explained in instruction, can be embedded into any programming language and be used.Every to can nested tables operational order, all
Can by by instruction explain execution system judge grammer whether mistake, and when syntactically correct, according to instruction explanation execution
Grammar compilation rule in system is compiled, and generates corresponding program statement, below following use C language as elements of grammar
(also can also be that others become language, specifically without limitation, are only illustrated by taking C language as an example herein certainly), to can be embedding
The grammer for covering the various operational orders of table is illustrated:
1, a key is defined for table class data type (i.e. above-mentioned described can the corresponding data type of nested tables)
Word.
Data type keyword is that compiler identifies the statement of the data type, example, the unique identification of variable-definition.
It such as can be the key definition of table class data type are as follows: table (by way of example only).
2, it is a kind of statement grammer of table class dtd--data type definition, realizes the statement and creation of one group of table class data.
Similar with structured data type, table class data type may have multiple groups in a function body, it is necessary to be every
One group of table states a table class.In addition, table class can be created in two kinds of storaging mediums: persistent storage and memory storage,
There are three types of storage forms: memory storage (such as the 104 data stored in memory libraries stored into Fig. 1), persistent storage (example
103 Persistent Store Databases as shown in figure 1) or two kinds of storage modes simultaneously, it must indicate that storage shape when stating table class
Formula is below illustrated statement mode:
Memory storage table class data assertion: table student { };
Persistent storage table class data assertion: persistent table student { };
The table class data assertion of two kinds of storage forms: double table student { };
In addition, if wanting specific field inside definition tables class student table, which can be as following
Mode is write:
table student{string name;char gender;int age};/ * states one in memory storage
A student table */;
persistent table student{string name;char gender;int age};/ * is deposited persistently
In storage state a student table */;
If wanted there are sublist inside definition tables class student table, the statement mode can enter following manner into
Row is write:
table student_grade{string name;char gender;int age;table grade
{string course;int score}};One table student_grade* comprising sublist grade of/* statement/.
3, the grammer that certain field settings index in table class data.
When table class data are especially big, index must be used to accelerate search speed when inquiring specified data.For example, one
The table at a age comprising student can be defined as the age of student index field, and statement mode is exemplified below:
index student{age};/ * to student table age field establish index */
index student_grade.grade{course};The course field of/* to sublist in the main table of student
Foundation index */;
Composite index can also be defined, statement mode is exemplified below:
index student{gender;age};For/* to the gender of student table, age field establishes compound rope
Draw.
4, the grammer of the pointer variable of table class data is stated;
In order to operate the data in table class, it is necessary to which the pointer variable of table class corresponding data is directed toward in definition.It can determine
Adopted pointer is directed toward whole fields of charting, can also define directed section field.Student form definition one can be given
A pointer variable is directed toward all fields and sublist, defines grammer and is exemplified below:
table student*studentPointer;
If student table exists in two kinds of storaging mediums simultaneously, need to indicate the medium that variable is directed toward, language
Method is exemplified below:
persistent table student*studentPointer;/ * indicates that pointer variable is directed toward in persistent storage
Table */
When the pointer variable of student table section field is directed toward in definition, it is as follows to define grammer:
table student_grade{name;age;grade{course}} *studentNamePointer;/ * table
Show that pointer variable is directed only to the name of student_grade table, the course field * of age field and sublist grade/
Note: if table is stored only in a kind of medium, in definition pointer variable, without indicating medium.If table
Lattice are stored in two kinds of media simultaneously, then pointer variable must indicate that medium, default to and are directed toward memory storage medium.
5, to the grammer of table class pointer variable assignment recording mechanism;
By the way that the newly-built record automatic assignment of table, newly-built recording mechanism is stored in table variable, and syntax format is illustrated such as
Under:
table student*studentPointer;
New*studentPointer={ { " LiXiaoMing ", 1,12 }, { " LiuXiaoFang ", 0,12 } };/ * table
Show and give student table newly-increased two records, the recording mechanism of newly-increased entry is stored in studentPointer in a manner of array
* in pointer variable/;
Can also be in variable declarations, directly to variable assignments, syntax format is exemplified below:
Table student*studentPointer=0;/ * or more code indicates that studentPointer variable is directed toward
No. 0 record * of student table/;
One array of table variable assignments can also be given, syntax format is exemplified below:
Table student*studentPointer={ 2,3 };/ * indicates that studentPointer variable is directed toward
The 2 of student table, No. 3 record */;
One conditional expression of table variable assignments can also be given, syntax format is exemplified below: studentPointer=
(gender==1AND age==12);/ * searches the institute that gender field is 1 and age field is 12 in student table
Have recording mechanism, and be assigned to table variable studentPointer*/
Can also be empty to table variable assignments, it goes to read list data at this time, then it represents that read all records in table
Data.Syntax format is exemplified below:
Table student*studentPointer=NULL.
6, to the grammer of the newly-increased record of table class data.
Table class data can increase charting newly, and syntax format is exemplified below:
table student*studentPointer;/ * is that student table states a pointer variable
studentPointer*/
New*studentPointer={ { " LiXiaoMing ", 1,12 }, { " LiuXiaoFang ", 0,12 } };/ * table
Show and give student table newly-increased two records, the recording mechanism of newly-increased entry is stored in studentPointer in a manner of array
* in pointer variable/;
For the student_grade table comprising sublist, the grammer of newly-increased charting is exemplified below:
table student_grade*studentPointer;/ * is that student_grade table states a pointer
Variable studentPointer*/;
New*studentPointer=" LiXiaoMing ", and 1,12, { " mathematics ", 75 }, { " English ", 85 },
{ " Chinese language ", 95 } } }, { " LiuXiaoFang ", 0,12, { { " mathematics ", 75 }, { " English ", 85 }, { " Chinese language ", 95 } } } };/*
Be represented to student_grade table and increase two chartings newly, the sublist of every charting increase newly 3 record */;
It should be noted that newly-increased recording mechanism can be stored in table variable after increasing charting newly by table variable
Array.
It can not certainly be by pointer variable directly to table assignment, below to how direct not by pointer variable
The grammer of table assignment is illustrated:
New student={ { " LiXiaoMing ", 1,12 }, { " LiuXiaoFang ", 0,12 } }.
Also individually can also give the sublist grade of certain of student_grade record newly-increased record, below to how
Individually it is illustrated to the grammer of the newly-increased record of sublist grade of certain record of student_grade:
StudentPointer=0;/ * allow pointer variable be directed toward student_grade table the 0th article of record */;
New*studentPointer.grade={ { " mathematics ", 75 }, { " English ", 85 }, { " Chinese language ", 95 } };/ * table
Show the sublist grade to No. 0 of student_grade record be written 3 new record */.
Furthermore it is also possible to not by pointer, it is directly newly-increased to No. 0 record sublist of student_grade table to record, under
In face of how not by pointer, the grammer for directly recording the newly-increased record of sublist to student_grade table 0 is illustrated
Illustrate:
New student_grade [0] .grade={ { " mathematics ", 75 }, { " English ", 85 }, { " Chinese language ", 95 } };
It should be noted that a wherein note for record can also be directed toward to pointer variable if pointer variable is array
New record is written in the sublist of record, and concrete example is as follows:
StudentPointer={ 2,3 };/ * allows the 2nd, 3 of pointer variable direction student_grade table to remember
Record */;
New*studentPointer [1] .grade={ { " mathematics ", 75 }, { " English ", 85 }, { " Chinese language ", 95 } }/*
Be represented to No. 3 of student_grade records sublist grade be written 3 new record */.
7, the grammer of table class data deletion record.
The grammer of various mode deletion records is illustrated below:
(1), it is exemplified below by the syntax format of the record of pointer variable Delete Table class data:
Table student studentPointer={ 2,3 };/ * states that studentPointer variable is directed toward table
The 2nd, the 3 record * of student/;
* studentPointer=NULL;2nd, 3 record * of table pointed by/* deletion studentPointer/;
(2), the syntax format of the corresponding record of direct Delete Table is exemplified below:
Student [2]=NULL;The 2nd article of record * of/* Delete Table student/
Student=NULL;All record * of/* Delete Table student/;
(3), it is exemplified below by the syntax format of the record of sublist in pointer variable Delete Table:
Table student_grade studentPointer=2;
* studentPointer.grade [0]=NULL;/ * deletes the 2nd article of table note pointed by studentPointer
The 0th article of record * of the sublist grade of record/;
* studentPointer.grade=NULL;/ * deletes the 2nd article of table record pointed by studentPointer
Sublist grade all record */;
(4), when pointer variable stores a plurality of record, the sublist designated recorder of certain record in variable, grammer to be deleted
Format is exemplified below:
Table student_grade studentPointer={ 2,3 };
* studentPointer [1] .grade [0]=NULL;It is signified that/* deletes the 1st column data of studentPointer
The 0th article of record * of the sublist grade recorded to the 3rd article of table/;
(5), in direct Delete Table sublist relative recording, syntax format is exemplified below:
Student [2] .grade [0]=NULL;The 0th of the sublist grade of the 2nd article of/* Delete Table student record
Item record */.
8, the grammer of table class data modification record.
The grammer recorded below to various modes to table class data modification is illustrated:
(1), charting is modified by pointer variable, syntax format is exemplified below:
Table student_grade studentPointer={ 2,3 };/ * statement studentPointer variable refers to
To table student the 2nd, 3 record */;
* studentPointer={ { " LiXiaoMing ", 1,12 }, { " LiuXiaoFang ", 0,12 } };/ * modification
2nd, 3 record * of studentPointer direction table/;
* studentPointer [0] .grade [0]={ " mathematics ", 75 };/ * modifies the 0th columns of studentPointer
According to the sublist grade for being directed toward the 2nd article of table record the 0th article of record content */;
* studentPointer.name={ " LiXiaoMing ", " LiuXiaoFang " };/ * modifies variable
The name field * for the 2nd, 3 record that studentPointer is directed toward/.
(2) if, table pointer variable only define be directed toward table part field, by variable can only be to specifying part
Divide field modification, syntax format is exemplified below:
Table student { name, age } studentPointer={ 0,1 };/ * states that studentPointer becomes
The name of amount direction table student, age field */;
* studentPointer={ { " LiXiaoMing ", 12 }, { " LiuXiaoFang ", 12 } };/ * is two names
Be assigned to respectively with the age table student the 0th, 1 record name field */
(3), the record of table is directly modified, syntax format is exemplified below:
Student_grade [2]={ " LiXiaoMing ", 1,12 };/ * modifies the 2nd article of table student_grade
Record */;
Student_grade [2] .grade [0]={ " mathematics ", 75 };/ * modifies the 2nd article of table student_grade
The 0th article of record content * of the sublist grade of record/.
(4), directly the single field of modification table record, syntax format are exemplified below:
Student [0] .name=" LiXiaoMing ";/ * modifies the name word of the 0th article of record of table student
Section */.
9, the grammer of table class data is read.
Charting is assigned to structural body variable it may first have to define field and sublist one in one and table variable
The structured data type of cause re-defines the single variable or array of this structural body, then the record that table variable is directed toward is assigned
It is worth and gives the structural body variable.Syntax format is exemplified below:
Struct str_student { string name, char gender, int age } student1 [];
Table student*studentPointer={ 2,3 };
Student1 []=* studentPointer;
The above code indicates that the numerical value the 2nd, No. 3 record in table student is assigned to Array for structural body
student1。
When studentNamePointer table variable-definition is directed only to part field, then reading table is removed with the variable
When lattice data, the field specified in variable can only be read.Syntax format is exemplified below:
Struct str_student { string name, int age } student1 [];
Table student { name, age } * studentNamePointer={ 2,3 };
Student1 []=* studentNamePointer;/ * read variable be directed toward corresponding record part field to tie
Structure body str_student*/;
The data of the specific field of table variable are directly read into an aray variable, such as to read student table
Into an array, syntax format is exemplified below the name of all students in lattice:
string str_name[];
Table student*studentPointer=(age==12);
Str_name []=* studentPointer.name;
The above code indicates the name assignment array str_name [] all students for being 12 of age in table student
In.
The data for reading the specific field of table are embedded into some operation expressions, and syntax format is exemplified below:
Int score_total=0;
int n;
Table student*studentPointer=0;
For (n=0;n
Score_total=score_total+*studentPointer.grade [n] .score;/ * handle
The score data accumulation * that studentPointer direction charting sublist graded the 0th, 1,2 is recorded/;
Data in the field of table are directly read, syntax format is exemplified below:
Int score_total=0;
int n;
For (n=0;n
Score_total=score_total+student [0] .grade [n] .score;/ * handle
The score data accumulation * that student charting sublist graded the 0th, 1,2 is recorded/.
Above to the grammer of various operational orders, the corresponding handling function of each grammer, such as read table class data
Grammer, the program statement obtained by the grammar compilation can with adopting form record function reading be operated to database.
In addition, can be compiled by above-mentioned various modes to operational order after getting operational order, target behaviour is obtained
Make to instruct corresponding program statement, M handling function is called by program statement later.
203, according to can nested tables parameter information and M handling function determine objective result.
It, can be according to can obtain can be after the parameter information and each handling function of M of nested tables in the present embodiment
The parameter information of nested tables and M handling function determine objective result, wherein objective result instruction is to can nested table
Whether the operation of lattice class data succeeds, and objective result has incidence relation with M handling function, that is to say, that an operation
Function can correspond to one as a result, e.g. indicating successful information, perhaps returning to error code or returning the information to be inquired of goods.Tool
Body, judgement can table mark in the parameter information of nested tables and the table that is stored in database identify whether to match,
Can nested tables parameter information include can the table marks of nested tables, index field and table field, in database
It is stored with including can multiple tables including nested tables;If so, by M handling function to can nested tables parameter believe
Breath is handled, and objective result is obtained.
It should be noted that the M handling function is such as at least one of minor function: table creates function, table note
Record new increasing function, charting deletes function, charting Modification growth function, charting query function, charting read letter
Number, table destroy function and the new increasing function of index.
(the programming language of the following table handling function C language in the following, be illustrated to the execution process of M table
It is illustrated for speech, also can also be other programming languages certainly, specifically without limitation):
1, table creates function.
The table creation function effect be in the database newly-increased one can nested tables object.The table objects can
To include sub-table object.Meanwhile table creation function also needs to define the numerical value class of the field of all tables in object
Type.
The input parameter that the table creates function is an object array, such as: struct tableAttrib { string
tablename[];string parent[];struct field{string fieldname[];int type[];
string link_table[]}[]}。
The output parameter of table creation function is the instruction information for creating table success or creation table failure.
When the M handling function includes table creation function:
By table create function to can the table marks of nested tables, index field and table field handle,
With generate can nested tables format data;
By can nested tables format data store into database with can the corresponding storage region of nested tables;
Return objective result, objective result instruction can nested tables create successfully.
That is, can inquire first can all titles in the parameter information of nested tables whether in data
It is had existed in library, if it does not exist, then returning to error message, and if it exists, then by object run function to can nested tables
Table mark, index field and table field handled, with generate can nested tables format data, and can
Nested tables and can nested tables format data store to can the corresponding storage region of nested tables, and return target
As a result, the objective result instruction can nested tables create successfully.
It should be noted that can the storage format of nested tables in the database include two parts: a part is to each
Table carries out the format definition of objectification, which is defined by one in database special table class object;Another part
It is to express the pass of every record and its parent record Hidden field can be increased in the record of nested tables all sublists for including
System.Each table class object in the table objects special definition database, every root table record the definition of a corresponding table,
Wherein " form attributes " include " title " of active sheet and the parent table title of active sheet;" index " defines often
The index field of a table;" table field " defines the contingency table of the title of each field, value type and the field
Lattice.
2, the new increasing function of charting.
The new increasing function of charting is that specified table class data object increases one or more groups of data newly, and every group of data can be with
The record of record comprising root table and its a plurality of sub-table, or specify the record and its a plurality of son of some sub-table
The record of table.
The input parameter of the new increasing function of the charting is an object array, such as: struct tableRecord
{string tableName[];string parent[];struct tableData {intparent[];string
fieldValue[][]}[]}。
When the new increasing function of charting runs succeeded, output parameter is an object array, such as: struct
tableRecord{string tableName[];int record[][]}.
When the new increasing function of charting executes failure, output parameter is error codes.
When increasing function new including charting in M handling function:
First inquiry can all titles in the parameter information of nested tables whether have existed in the database,
And be set membership, if there is no error message is then returned, otherwise since can be the root table of nested tables class data toward number
It adds and records according to library, the parent table record of return is backfilling into the parent record field location of sub-table again, from level to level down new record
Each sublist is written, and obtains the recording mechanism of return, finally returns to the recording mechanism that can be increased newly in nested tables class data.
3, charting deletes function.
Charting, which deletes function, can delete the record and its sublist record of specified table, can be and open from root table
Begin to delete, can also be deleted since any sub-table.
The input parameter that the charting deletes function is two parameters, and one is title, and one is record number
Group.The output parameter that the charting deletes function is the instruction information of success or failure.
Below with can nested tables class data instance to charting delete function execution process be illustrated:
Inquiry can specify title (such as can some sublist) in nested tables in the parameter information of nested tables
Whether have existed in the database, if there is no error message is then returned, wants deletion record number if it is present obtaining
Sublist record, then search the sublist record of sublist to be deleted record, according to this recurrence and save all titles to be deleted and
Its recording mechanism deletes all chartings found, and returns to objective result, i.e. successful information or failure information.
4, charting Modification growth function.
Charting Modification growth function can modify the record of the specific field of specified table.
The input parameter of the charting Modification growth function is two parameters, and one indicates table, field and recording mechanism
Object, such as: struct tableRecord { string tableName; stringtableField[];int record
[]};One is object array, such as: stuct field { intfield1 [];char field2[]}.
The output parameter of the charting Modification growth function is the instruction information of success or failure.
When in M handling function including charting Modification growth function:
Whether inquiry can specify title (table that can be to be modified in nested tables) in the parameter information of nested tables
It has existed, if there is no error message is then returned, is otherwise write to the field of specified table corresponding record number in the database
Enter corresponding data, when being written successfully, returns to successfully instruction information and return to the instruction information of failure when failure is written.
5, charting query function.
Charting query function can inquire the record of specified chart symbols condition according to conditional expression and export note
Record number.
The input parameter of the charting query function is two parameters, and one is to indicate title, such as: string
tableName;One string argument, such as: " field2 > 2 field1==1AND ".
When the charting query function successful execution, the parameter of output is an array, such as: int record [].
When in M handling function including charting query function:
Inquiry can specify whether title has existed in the database in the parameter information of nested tables, if not
In the presence of error message is then returned, qualified recording mechanism in specified table is otherwise according to condition inquired, query function then returns
Recording mechanism array, inquiry failure, then return and unsuccessfully indicate information.
6, charting function reading.
Charting function reading can specify table, field and recording mechanism, read the corresponding note of table and its sub-table
Record data.
The input parameter of the charting function reading is an object array, such as: struct tableMain { string
tableName[];string field[][];int record[][]}.
When the charting function reading runs succeeded, output parameter is an object array, such as: struct result
{string tableName[];struct field{int field1[];char field2[]}[]}.
When in M handling function including charting function reading:
Inquiry can specify whether title has existed in the database in the parameter information of nested tables, if not
In the presence of error message is then returned, the field data for otherwise reading the specified corresponding record of table when reading successfully, is returned later
The field data for the corresponding record of specified table that readback takes then returns when reading incident and unsuccessfully indicates information.
7, table destroys function.
Table, which destroys function, can destroy specified table and its sub-table, all destroy including all data in table.
The input parameter that the table destroys function is a title, such as: string tableName.
The output parameter that the table destroys function is the instruction information of success or failure.
When M charting function includes that table destroys function:
Inquiry can specify whether title has existed in the database in the parameter information of nested tables, if not
In the presence of error message is then returned, specified table and the corresponding sub-table of specified table are otherwise destroyed, when destroying successfully, is returned
It destroys and successfully indicates information, when destroying failure, return to destruction and unsuccessfully indicate information;
In view of the foregoing it is apparent that in embodiment provided by the present application, obtain to can the object runs of nested tables refer to
It enables;Instructed according to object run and determine M handling function, M handling function for can in nested tables handling function system with mesh
The corresponding handling function of operational order is marked, can be stored with including M handling function in nested tables handling function system
Multiple handling functions;According to can nested tables parameter information and M handling function determine that object run instructs corresponding mesh
Mark as a result, objective result instruction to can nested tables class data whether operate success.Due to that can shift to an earlier date in the application can be nested
Multiple table handling functions are stored in table handling function system, it, can be according to operational order from can when obtaining operational order
Corresponding table handling function is got in nested tables handling function system, and can be nested according to what is carried in operational order
The parameter information and table handling function of table generate objective result, objective result instruction to can nested tables operation
Whether succeed.For the existing SQL sentence by various database manipulations, can reduce can be nested in database
The processing difficulty of table improves processing speed.
The processing method of list data provided by the embodiments of the present application is illustrated above, below with reference to Fig. 3 to this Shen
Please the processing unit of list data that provides of embodiment be illustrated.
Referring to Fig. 3, Fig. 3 is the embodiment schematic diagram of the processing unit of list data provided by the embodiments of the present application, it should
The processing unit of list data includes:
Acquiring unit 301, for obtain to can nested tables object run instruction, take in object run instruction
With to it is described can nested tables order and it is described can nested tables parameter information, it is described can nested tables include one
Root table, described table include N number of sub-table, wherein N is the positive integer more than or equal to 0;
First determination unit 302 determines M handling function for instructing according to the object run, the M operation
Function be can handling function corresponding with object run instruction in nested tables handling function system, it is described can nested table
The multiple handling functions being stored in lattice handling function system including the M handling function, wherein M is to be greater than or wait
In 1 positive integer;
Second determination unit 303, for according to can nested tables parameter information and the M handling function
Determine objective result, the objective result instruction to it is described can the operations of nested tables whether succeed, and the objective result with
The M handling function has incidence relation.
Optionally, first determination unit 302 is specifically used for:
By instruction explain execution system judge object run instruction grammer whether mistake, described instruction explains
The corresponding grammer of a plurality of instruction being stored in execution system including the corresponding grammer of the target instruction target word;
If it is not, then explaining that the grammar compilation rule in execution system compiles object run instruction according to instruction
It translates, to generate program statement corresponding with object run instruction;
The M handling function is called by described program sentence.
Optionally, second determination unit 303 is specifically used for:
Described in judgement can the mark of table mark in the parameter information of nested tables and the table stored in database be
No matching, it is described can nested tables parameter information include it is described can nested tables table mark, index field and table
Field, be stored in the database including it is described can multiple tables including nested tables;
If so, by the M handling function to it is described can the parameter informations of nested tables handle, obtain described
Objective result.
Optionally, second determination unit 303 by the M handling function to it is described can nested tables parameter believe
Breath is handled, and obtaining the objective result includes:
When the M handling function includes table creation function, by the table create function to it is described can be nested
The table mark of table, index field and table field are handled, with described in generating can nested tables formatting number
According to;
By it is described can nested tables format data store into the database with it is described can nested tables it is corresponding
Storage region;
Return to the objective result, described in the objective result instruction can nested tables create successfully.
Optionally, described table includes at least one root record, every height when N is greater than 0, in N number of sub-table
Table includes at least one record, and each subrecord at least one described subrecord includes Hidden field, the implicit word
Section write-in target record mark, the target record identifies corresponding with comprising recording for the Hidden field in described table
Root table record.
Optionally, the M handling function is at least one of following handling function:
Table creates function, the new increasing function of charting, charting and deletes function, charting Modification growth function, table
Record queries function, charting function reading, table destroy function and the new increasing function of index.
In view of the foregoing it is apparent that in embodiment provided by the present application, obtain to can the object runs of nested tables refer to
It enables;Instructed according to object run and determine M handling function, M handling function for can in nested tables handling function system with mesh
The corresponding handling function of operational order is marked, can be stored with including M handling function in nested tables handling function system
Multiple handling functions;According to can nested tables parameter information and M handling function determine that object run instructs corresponding mesh
Mark as a result, objective result instruction to can nested tables class data whether operate success.Due to that can shift to an earlier date in the application can be nested
Multiple table handling functions are stored in table handling function system, it, can be according to operational order from can when obtaining operational order
Corresponding table handling function is got in nested tables handling function system, and can be nested according to what is carried in operational order
The parameter information and table handling function of table generate objective result, objective result instruction to can nested tables operation
Whether succeed.For the existing SQL sentence by various database manipulations, can reduce can be nested in database
The processing difficulty of table improves processing speed.
Fig. 4 is the hardware structural diagram of server provided by the embodiments of the present application, the server 400 can because configuration or
Performance is different and generates bigger difference, may include one or more central processing units (central
Processing units, CPU) 422 (for example, one or more processors) and memory 432, one or one with
The storage medium 430 (such as one or more mass memory units) of upper storage application program 442 or data 444.Its
In, memory 432 and storage medium 430 can be of short duration storage or persistent storage.The program for being stored in storage medium 430 can
To include one or more modules (diagram does not mark), each module may include to the series of instructions in server
Operation.Further, central processing unit 422 can be set to communicate with storage medium 430, execute on server 400
Series of instructions operation in storage medium 430.
The central processing unit 422 is for executing the step as performed by the processing unit of list data in above-mentioned Fig. 2.
The embodiment of the present application also provides a kind of storage mediums, are stored thereon with program, when which is executed by processor
The step of realizing the processing method of list data described above.
A kind of computer readable storage medium of the embodiment of the present application, including instruction, when run on a computer, make
Obtain the processing method that computer executes list data described above.
The embodiment of the present application also provides a kind of equipment, equipment includes processor, memory and stores on a memory simultaneously
The program that can be run on a processor, processor realize the processing method of list data described above when executing program.
Equipment herein can be server, PC, PAD, mobile phone etc..
Present invention also provides a kind of computer program products, when executing in the processing equipment in list data, are suitable for
The processing method of list data described above may be implemented when executing computer program product.
It is apparent to those skilled in the art that for convenience and simplicity of description, foregoing description is
System, the specific work process of device and unit can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
In several embodiments provided herein, it should be understood that disclosed system, device and method can be with
It realizes by another way.For example, the apparatus embodiments described above are merely exemplary, for example, unit is drawn
Point, only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components
It can be combined or can be integrated into another system, or some features can be ignored or not executed.Another point, it is shown or
The mutual coupling, direct-coupling or communication connection discussed can be through some interfaces, device or unit it is indirect
Coupling or communication connection can be electrical property, mechanical or other forms.
Unit may or may not be physically separated as illustrated by the separation member, show as unit
Component may or may not be physical unit, it can it is in one place, or may be distributed over multiple nets
On network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, each functional unit in each embodiment of the application can integrate in one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If integrated unit is realized in the form of SFU software functional unit and when sold or used as an independent product,
It can store in a computer readable storage medium.Based on this understanding, the technical solution of the application substantially or
Person says that all or part of the part that contributes to existing technology or the technical solution can body in the form of software products
Reveal and, which is stored in a storage medium, including some instructions are with so that a computer is set
Standby (can be personal computer, local client or the network equipment etc.) executes the complete of the embodiment method of the application Fig. 2
Portion or part steps.And storage medium above-mentioned include: USB flash disk, mobile hard disk, read-only memory (read-only memory,
ROM), random access memory (random access memory, RAM), magnetic or disk etc. are various can store program
The medium of code.
More than, above embodiments are only to illustrate the technical solution of the application, rather than its limitations;Although referring to aforementioned
The application is described in detail in embodiment, those skilled in the art should understand that: it still can be to aforementioned
Technical solution documented by each embodiment is modified or equivalent replacement of some of the technical features;And these are repaired
Change or replaces, the spirit and scope of each embodiment technical solution of the application that it does not separate the essence of the corresponding technical solution.
Claims (10)
1. a kind of processing method of list data characterized by comprising
Obtain to can the object runs of nested tables instruct, carried in object run instruction to it is described can nested tables
Order and it is described can nested tables parameter information, it is described can nested tables include a root table, described table includes N number of sublist
Lattice, wherein N is the positive integer more than or equal to 0;
It is instructed according to the object run and determines M handling function, the M handling function is can nested tables handling function system
Handling function corresponding with object run instruction in system, it is described to be stored in nested tables handling function system including institute
State multiple handling functions including M handling function, wherein M is the positive integer more than or equal to 1;
According to it is described can nested tables parameter information and the M handling function determine objective result, the objective result
Indicate to it is described can the operations of nested tables whether succeed, and the objective result and the M handling function are with being associated with
System.
2. the method according to claim 1, wherein described determine M operation according to object run instruction
Function includes:
By instruction explain execution system judge object run instruction grammer whether mistake, described instruction explanation executes system
The corresponding grammer of a plurality of instruction being stored in system including the corresponding grammer of the target instruction target word;
If it is not, then explain that the grammar compilation rule in execution system is compiled object run instruction according to instruction, with
Generate program statement corresponding with object run instruction;
The M handling function is called by described program sentence.
3. according to the method described in claim 2, it is characterized in that, it is described according to can nested tables parameter information and
The M handling function determines that objective result includes:
The table that can be stored in table mark in the parameter information of nested tables and database described in judgement identifies whether
Match, it is described can nested tables parameter information include it is described can nested tables table mark, index field and table field,
Be stored in the database including it is described can multiple tables including nested tables;
If so, by the M handling function to it is described can the parameter informations of nested tables handle, obtain the target knot
Fruit.
4. according to the method described in claim 3, it is characterized in that, it is described by the M handling function to it is described can nested table
The parameter information of lattice is handled, and is obtained the objective result and is included:
When the M handling function include table creation function when, by the table create function to it is described can nested tables
Table mark, index field and table field handled, with described in generating can nested tables format data;
By it is described can nested tables format data store into the database with it is described can the corresponding storage of nested tables
Region;
Return to the objective result, described in the objective result instruction can nested tables create successfully.
5. according to the method described in claim 4, it is characterized in that, described table includes at least one root record, when N is greater than 0
When, each sub-table in N number of sub-table includes at least one record, every height note at least one described subrecord
Record includes Hidden field, Hidden field write-in target record mark, the target record identify in described table with comprising
The Hidden field records corresponding table record.
6. the method according to any one of claims 1 to 5, which is characterized in that the M handling function is following operation
At least one of function:
Table creates function, the new increasing function of charting, charting and deletes function, charting Modification growth function, charting
Query function, charting function reading, table destroy function and the new increasing function of index.
7. a kind of processing unit of list data characterized by comprising
Acquiring unit, for obtain to can nested tables object run instruction, carry to institute in object run instruction
State can nested tables order and it is described can nested tables parameter information, it is described can nested tables include a root table, it is described
Root table includes N number of sub-table, wherein N is the positive integer more than or equal to 0;
First determination unit determines M handling function for instructing according to the object run, and the M handling function is can
Handling function corresponding with object run instruction in nested tables handling function system, it is described can nested tables handling function
The multiple handling functions being stored in system including the M handling function, wherein M is just whole more than or equal to 1
Number;
Second determination unit, for according to can nested tables parameter information and the M handling function determine target
As a result, objective result instruction to it is described can the operations of nested tables whether succeed, and the objective result is grasped with described M
Make function with incidence relation.
8. device according to claim 7, which is characterized in that first determination unit is specifically used for:
By instruction explain execution system judge object run instruction grammer whether mistake, described instruction explanation executes system
The corresponding grammer of a plurality of instruction being stored in system including the corresponding grammer of the target instruction target word;
If it is not, then explain that the grammar compilation rule in execution system is compiled object run instruction according to instruction, with
Generate program statement corresponding with object run instruction;
The M handling function is called by described program sentence.
9. a kind of computer readable storage medium, which is characterized in that including instruction, when run on a computer, make to succeed in one's scheme
The step of processing method of list data described in any one of calculation machine perform claim requirement 1 to 6.
10. a kind of computer program product comprising instruction, when run on a computer, so that computer executes above-mentioned power
Benefit require any one of 1 to 6 described in list data processing method the step of.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910613577.2A CN110321360A (en) | 2019-07-08 | 2019-07-08 | The processing method and relevant device of list data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910613577.2A CN110321360A (en) | 2019-07-08 | 2019-07-08 | The processing method and relevant device of list data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110321360A true CN110321360A (en) | 2019-10-11 |
Family
ID=68121478
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910613577.2A Pending CN110321360A (en) | 2019-07-08 | 2019-07-08 | The processing method and relevant device of list data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110321360A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111045647A (en) * | 2019-11-20 | 2020-04-21 | 深圳市云智融科技有限公司 | Information determination method and related equipment |
CN112035572A (en) * | 2020-08-21 | 2020-12-04 | 西安寰宇卫星测控与数据应用有限公司 | Static method, device, computer equipment and storage medium for creating table instance |
CN112650967A (en) * | 2020-12-30 | 2021-04-13 | 创业慧康科技股份有限公司 | Method, device, equipment and medium for realizing webpage front end of medical form componentization |
CN115329010A (en) * | 2022-10-11 | 2022-11-11 | 深圳市瓴码云计算有限公司 | Data processing method of distributed relational database |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104008135A (en) * | 2014-05-07 | 2014-08-27 | 南京邮电大学 | Multi-source heterogeneous database fusion system and data query method thereof |
CN107665216A (en) * | 2016-07-29 | 2018-02-06 | 银联数据服务有限公司 | A kind of data bank access method and middleware |
US20180260451A1 (en) * | 2017-03-08 | 2018-09-13 | Microsoft Technology Licensing, Llc | Database query for histograms |
CN109656951A (en) * | 2018-12-18 | 2019-04-19 | 北京华电天仁电力控制技术有限公司 | Method and inquiry system based on expression formula inquiry data |
-
2019
- 2019-07-08 CN CN201910613577.2A patent/CN110321360A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104008135A (en) * | 2014-05-07 | 2014-08-27 | 南京邮电大学 | Multi-source heterogeneous database fusion system and data query method thereof |
CN107665216A (en) * | 2016-07-29 | 2018-02-06 | 银联数据服务有限公司 | A kind of data bank access method and middleware |
US20180260451A1 (en) * | 2017-03-08 | 2018-09-13 | Microsoft Technology Licensing, Llc | Database query for histograms |
CN109656951A (en) * | 2018-12-18 | 2019-04-19 | 北京华电天仁电力控制技术有限公司 | Method and inquiry system based on expression formula inquiry data |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111045647A (en) * | 2019-11-20 | 2020-04-21 | 深圳市云智融科技有限公司 | Information determination method and related equipment |
CN112035572A (en) * | 2020-08-21 | 2020-12-04 | 西安寰宇卫星测控与数据应用有限公司 | Static method, device, computer equipment and storage medium for creating table instance |
CN112035572B (en) * | 2020-08-21 | 2024-03-12 | 西安寰宇卫星测控与数据应用有限公司 | Static method, device, computer equipment and storage medium for creating form instance |
CN112650967A (en) * | 2020-12-30 | 2021-04-13 | 创业慧康科技股份有限公司 | Method, device, equipment and medium for realizing webpage front end of medical form componentization |
CN115329010A (en) * | 2022-10-11 | 2022-11-11 | 深圳市瓴码云计算有限公司 | Data processing method of distributed relational database |
CN115329010B (en) * | 2022-10-11 | 2023-06-27 | 深圳市瓴码云计算有限公司 | Data processing method of distributed relational database |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110321360A (en) | The processing method and relevant device of list data | |
US10860548B2 (en) | Generating and reusing transformations for evolving schema mapping | |
CN107491561B (en) | Ontology-based urban traffic heterogeneous data integration system and method | |
US8185509B2 (en) | Association of semantic objects with linguistic entity categories | |
CN104765731B (en) | Database inquiry optimization method and apparatus | |
CN102023979B (en) | Meta-data management method and system | |
EP0583117A2 (en) | A device and method for converting computer programming languages | |
US7949675B2 (en) | Data retrieval method | |
CA3078018A1 (en) | Scalable analysis platform for semi-structured data | |
US6317749B1 (en) | Method and apparatus for providing relationship objects and various features to relationship and other objects | |
CN101493820A (en) | Medicine Regulatory industry knowledge base platform and construct method thereof | |
CN101458692A (en) | Strategic material industry knowledge base platform and construct method thereof | |
CN109491658A (en) | The generation method and device of computer-executable code data | |
CN110502227A (en) | The method and device of code completion, storage medium, electronic equipment | |
CN108009270A (en) | A kind of text searching method calculated based on distributed memory | |
CN109657803A (en) | The building of machine learning model | |
CN107818181A (en) | Indexing means and its system based on Plcient interactive mode engines | |
CN101388034B (en) | Arrangement and method for processing data base | |
Kabiri et al. | Towards a framework for conceptual modeling of ETL processes | |
CN102279886A (en) | Method and equipment for processing metadata | |
CN105488170B (en) | A kind of approaches to IM and device of ERP system | |
CN107025110A (en) | A kind of tense modeling method based on software development key element and its contact | |
CN104834742A (en) | ETL architecture management method based on SCA | |
CN113448942B (en) | Database access method, device, equipment and storage medium | |
US9959295B1 (en) | S-expression based computation of lineage and change impact analysis |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191011 |
|
RJ01 | Rejection of invention patent application after publication |