CN101021876A - Data management method, equipment and data bank system - Google Patents
Data management method, equipment and data bank system Download PDFInfo
- Publication number
- CN101021876A CN101021876A CN 200710087320 CN200710087320A CN101021876A CN 101021876 A CN101021876 A CN 101021876A CN 200710087320 CN200710087320 CN 200710087320 CN 200710087320 A CN200710087320 A CN 200710087320A CN 101021876 A CN101021876 A CN 101021876A
- Authority
- CN
- China
- Prior art keywords
- field
- sublist
- data
- indication
- virtual
- 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
Images
Abstract
This invention discloses a data management method, which maps a field of a basic data list onto a virtual sub-list provided to the management interface facing application. This invention also provides related data management devices and a database system and the operator can define a necessary data structure and realize a data structure facing application by any combination of basic data list fields, either the data dimension expansion or modification of a structure character can be realized by re-structuring virtual sub-lists easily.
Description
Technical field
The present invention relates to database technical field, be specifically related to data managing method, equipment and Database Systems.
Background technology
The data storage that generally adopts and the pattern of Managed Solution are generally at present: based on the Sybase system, and earlier according to concrete service needed, the structure of definition of data table, and then exploitation application corresponding system cooperates with it.
Because application system is directly operated database table, database table structure need depend on business demand and carry out the characterization definition.This needs the business personnel to cooperate with the technician, proposes business demand by the business personnel, carries out Custom Design by the developer, and then develops the application corresponding system and go this characterization data structure is managed.
Based on above-mentioned pattern, if in the use of Database Systems, the data library structure is had the expansion demand, even only increase a data dimension field, because application system is to develop corresponding to initial data structure, directly carry out, therefore also need redesign towards this data structure.And,, cause overlapping development because therefore database structure in the face of different industry characteristic and industry requirements, exists a large amount of functionally similar systems with professional closely related.With the excavation to user's base attribute and behavior property is example, and this function is widely used in every field, for example internet, mobile communication etc.For adapting to concrete industry characteristic, exist various functionally similar digging systems, cause waste of human resource.And along with the change of user personality and the appearance of new features, system need constantly carry out related data structure modification and application system upgrading, causes difficult in maintenance.
Summary of the invention
Given this, be necessary to provide a kind of saving manpower, maintenance to be easy to data managing method.
Based on the design of above-mentioned data managing method, provide a kind of data management apparatus.
Simultaneously, provide a kind of Database Systems.
A kind of data managing method comprises the steps:
Set up the incidence relation of the base table field of the sublist field of the first virtual sublist and master data table; Reception is to the data management indication of the sublist field of the first virtual sublist; And, the data management operations that is implemented as the base table field is indicated in the data management of described antithetical phrase literary name section according to described incidence relation.
A kind of data management apparatus, this equipment comprises:
Receiving element, described receiving element comprise reception subelement one and receive subelement two; Described reception subelement one is used to receive field management indication; Described reception subelement two is used to receive the data management indication; The field administrative unit is used for setting up or deleting according to described field management indication the incidence relation of the base table field of the sublist field of virtual sublist and master data table; Data Management Unit is used for according to the incidence relation that described field administrative unit provides, the data management operations that is implemented as the base table field being indicated in the data management of antithetical phrase literary name section according to described data management indication.
A kind of Database Systems comprise:
Data management apparatus, data storage device, data acquisition equipment and data extraction device; Described data management apparatus adopts said structure; Described data storage device is used to provide the master data table; Control according to described data management apparatus is carried out data management operations to the base table field of master data table, imports data or provides data to described data extraction device from described data acquisition equipment; Described data acquisition equipment is used for control according to described data management apparatus from the external data source image data and offer described data storage device; Described data extraction device is used for extracting data and offering outer application system from described data storage device according to the control of described data management apparatus.
The embodiment of the invention adopts field mappings with the master data table on virtual sublist, the method of application oriented administration interface is provided by virtual sublist, make that operating personnel can be by the combination in any to master data literary name section, define the data structure that needs, can realize flexibly that application oriented data structure builds.No matter be that data dimension expansion or architectural characteristic are revised and can easily be realized by the reconstruct to virtual sublist, need not the overlapping development total system, save manpower.And, because the modification to the virtual subnet list structure does not cause change to the database object of reality on the administration interface, guaranteed the stability of database master data table, reduce maintenance difficulties.
Description of drawings
Fig. 1 is the embodiment of the invention one a data managing method schematic flow sheet;
Fig. 2 is the data management apparatus structural representation that is applied to the embodiment of the invention one method;
Fig. 3 is the database system structure synoptic diagram that is applied to the embodiment of the invention one method.
Embodiment
The embodiment of the invention provides a kind of data managing method, on virtual sublist, provides application oriented administration interface by virtual sublist with the field mappings of master data table.The embodiment of the invention also correspondingly provides data management apparatus and the Database Systems that are applicable to said method.Below be elaborated respectively.
Embodiment one, a kind of data managing method, flow process as shown in Figure 1, this method may further comprise the steps:
Steps A 1, reception sublist increase indication, increase indication according to sublist and set up the first virtual sublist;
In the embodiment of the invention, administration interface can be provided the data structure of presenting to application system according to the different virtual sublist of needs definition of business by virtual sublist.
Can set up new virtual sublist by the mode of in the sublist information table, inserting a new record.Table 1 has provided an example of definition sublist information table:
Table 1
| Field name | Explanation of field | Type length | Major key whether | Index whether |
| Table_id | Sublist sign (ID) | number(10) | Be | |
| table_name | The sublist title | varchar2(30) | Be |
Wherein, number (10) expression length is no more than 10 integer data; Varchar2 (30) expression length is no more than 30 character string data; Sublist ID is and the unique corresponding identification of virtual sublist to can be used as the major key of sublist information table; The sublist name is called the friendly name of virtual subnet surface to administration interface, can be Chinese, and general sublist title also is unique, and the sublist title can be used as the index of sublist information table.Certainly, except sublist ID and sublist Chinese, also can write down other information of virtual sublist in the sublist information table, for example Field Count, field name etc. can be determined as required.Also be fine if only comprise sublist ID in the sublist information table, administration interface is directly by sublist ID managing virtual sublist.
Above-mentioned steps A1 can independently carry out, and subsequent step can be based on the basic enterprising line operate that virtual sublist is provided.
The incidence relation of the base table field of steps A 2, the sublist field of setting up the first virtual sublist and master data table;
In embodiments of the present invention, the master data table is the physics table of database actual storage, can obtain some virtual sublists by field mappings on the basis of this master data table, and these virtual sublists can be formed by the field combination in any of master data table.For making the master data table have enough data extensibilities, can be as required for it be provided with abundant field, and enough sufficient field type.With the data message relevant with the mobile subscriber is example, and table 2 has provided an example of definition master data table:
Table 2
| Field name | Explanation of field | Type length | Whether can be empty | Default value | Major key whether |
| phone_num | Subscriber Number | varchar2(16) | Not | Be | |
| str1 | String data 1 | varchar2(20) | Be | null | |
| ...... | ...... | ...... | ...... | ...... | |
| str30 | String data 30 | varchar2(20) | Be | null | |
| float1 | Floating type data 1 | number(10，2) | Be | null | |
| ...... | ...... | ...... | ...... | ...... | |
| float30 | Floating type data 30 | number(10，2) | Be | null | |
| num1 | Numeric type data 1 | number(7) | Be | null | |
| num30 | Numeric type data 30 | number(7) | Be | null |
Wherein, number () is the same with the implication of varchar2 (); Length was no more than 2 floating type data after number (10,2) expression length was no more than 10 and radix point.In the definition of above-mentioned master data table, characteristic according to the mobile subscriber, define a Subscriber Number field as major key, in addition, each 30 of the fields of three types of character string type, integer and floating types have been defined, totally 90 fields, this field of three types can contain general UAD at present.90 fields in this master data table except that major key all can be sky (null), can be by virtual sublist according to application demand mapping use.Certainly, the master data table also can meaningless field as major key, for example the nothing that generates automatically of system repeats numbering etc.Carry out the major key of the shared master data table of virtual sublist that field mappings obtains, be used for related relation to each other.
The incidence relation of base table field and sublist field can be kept in the field mappings table.Table 3 has provided an example of define field mapping table:
Table 3
| Field name | Explanation of field | Type length | Default value | Major key whether |
| field_name | Master data table field name | varchar2(30) | Be |
| field_type | Field type: 1-character string type; The 2-integer; The 3-floating type | number(1) | ||
| status | User mode: 0-does not use; 1-uses | number(1) | 0 | |
| table_id | Affiliated sublist ID | number(10) |
This table can initially generate when the master data table is built table, has shone upon all other fields except that major key in the master data table.Each field name is in full accord in the value of the field_name field that is write down and the master data table, and perseverance is: " str1 " ... " str30 ", " float1 ' ... " float30 ", " num1 " ... " num30 ".This title is unique corresponding with the base table field, can be used as the major key of field mappings table.Field_type is the field type actual value of the corresponding base table field of field_name.When initial, the status that each sublist ID that writes down in each field_name and the sublist information table is corresponding is 0, shows that the base table field is also by virtual sublist mapping use.Sublist ID can be used as the index of field mappings table, can improve the speed of carrying out the inquiry of field mappings table based on sublist ID.
The following process of setting up with reference to this field mappings table explanation incidence relation.Incidence relation in the base table field of the sublist field of setting up virtual sublist and master data table, when promptly carrying out the base table field to the mapping of virtual sublist, can be divided into two kinds of situations, a kind of is will also not have the base table field mappings of related sublist field to virtual sublist, and another kind is that the base table field mappings that will be associated with the sublist field of other virtual sublists arrives new virtual sublist.Certainly, system also can be set to only allow the appearance of first kind of situation, i.e. the sublist field that is mapped to a virtual sublist that base table field can only be unique.Respectively both of these case is described below:
One, carry out the not mapping of the base table field of associated virtual sublist, step comprises:
Steps A 211, the field that receives the first virtual sublist increase indication, and this field increases the attribute description that comprises the sublist field that needs increase in the indication;
Corresponding to the definition of above-mentioned master data table, the sublist field attribute is the type length of this sublist field; For example, suppose that requiring in the field increase indication is the sublist field that the first virtual sublist increases a floating type.
Steps A 212, attribute description and the state of selecting matching field to increase in the indication are set to not related with any sublist field base table field;
Can in the field mappings table, select a field_type coupling and status to be 0 field_name record arbitrarily; Suppose and be chosen as " float15 "
The state of steps A 213, selected base table field is set to related with the sublist field of the first virtual sublist.
Show in the field mappings table to be exactly that the status of its corresponding first virtual sublist table_id is set to 1.For example, the status of " float15 " corresponding first virtual sublist table_id is set to 1 in the field mappings table, like this, just the base table field " float15 " in the master data table has been mapped to the first virtual sublist, sublist field as the first virtual sublist, the first virtual sublist can be used " float15 " sign as this sublist field equally, will provide more excellent identification schemes in follow-up embodiment.
Two, carry out the mapping of the base table field of associated virtual sublist, step comprises:
Steps A 221, obtain and show the sublist field of the second virtual sublist;
Can list existing virtual sublist by the sublist information table, and, be shown as associated base table field name in the present embodiment according to the sublist ID in the sublist information table obtains each virtual sublist from the field mappings table all sublist fields;
Steps A 222, the field that receives the first virtual sublist increase indication, and described field increases the appointment that comprises in the indication certain sublist field of the second virtual sublist;
System can specify the new field of the sublist field of an existing virtual sublist as the first virtual sublist according to the needs of practical application;
Steps A 223, according to the incidence relation of the sublist field and the base table field of appointment, the state of this base table field is set to related with the sublist field of the first virtual sublist.
Show in the field mappings table that the status of the corresponding first virtual sublist table_id of this base table field is set to 1 exactly.
Behind the incidence relation of the base table field of the sublist field of having set up the first virtual sublist and master data table, system can operate the master data table based on the list structure of the defined first virtual sublist.
Steps A 3, reception are indicated the data management of the sublist field of the first virtual sublist, according to described incidence relation, the data management operations that is implemented as the base table field are indicated in the data management of described antithetical phrase literary name section.
Alleged data management indication can comprise the various operations indications to the data object, for example insertion of field data, renewal, deletes and searches etc.System can import the data that collect from external data source for certain sublist field of the first virtual sublist, also can carry out searching and extracting of data based on the sublist field attribute.The above-mentioned data storage and the way to manage that provide based on the embodiment of the invention, system carries out the inquiry of various dimensions, many records and exports very convenient, as long as define corresponding virtual sublist, efficient is very high, and the efficient influence that increased by the dimension condition.
Steps A 4, except the increase of sublist and field indication, also can handle deletion indication to sublist and field, to carry out the releasing of field mappings relation, specifically comprise step:
Steps A 41, reception are indicated the field deletion of the first virtual sublist, comprise the appointment to certain sublist field of the first virtual sublist in this field deletion indication;
Steps A 42, to specify the state of the related base table field of sublist field to be set to not related with the sublist field of the first virtual sublist with this;
Show in the field mappings table that the status of the corresponding first virtual sublist table_id of this base table field is set to 0 exactly.
Steps A 43, reception are indicated the sublist deletion of the first virtual sublist;
Steps A 44, according to this sublist deletion indication, the state of all the base table fields related with the sublist field of the first virtual sublist is set to not related with the sublist field of the first virtual sublist.
All base table field status that show the exactly corresponding first virtual sublist table_id in the field mappings table are set to 0.Certainly, need accordingly in the deletion sublist information table and the corresponding record of the first virtual sublist table_id.
In addition, for guaranteeing the reliability of master data table data, can be set at the state of base table field when not related with the sublist field of certain virtual sublist, whether the state setting of judging this base table field for not related with other any sublist fields, if then the content of this base table field is emptied.Show in the field mappings table and be set at 0 o'clock at the status of certain table_id exactly, judge whether all status are 0 to corresponding field_name, be not mapped to any virtual sublist if then show the base table field of this field_name correspondence, need carry out data and empty, be convenient to follow-up other virtual subnet table references that are redefined.
Embodiment two, a kind of data managing method, the difference part of present embodiment and embodiment one are that present embodiment adopts preferred sublist field identification scheme.
In the present embodiment, the sublist field of virtual sublist is no longer given tacit consent to the sign of the associated base table field identification of use as self, because field_name is the English character string usually, being not easy to the layman uses, the sublist field that is adopted as virtual sublist in the present embodiment provides the scheme of independently management sign, the concrete employing:
When the mapping of carrying out the base table field of associated virtual sublist not, increase in the indication except attribute description in field, the management sign that also comprises the sublist field that needs increase, certainly, this management sign can adopt the friendly name according to the application need definition, can be Chinese, will manage the corresponding preservation of sign then, get final product with the sign of selected base table field;
Show in the definition of field mappings table, it is exactly the field that increases this management sign of a storage for the field mappings table, if should the management sign adopt Chinese, the originally simple field mappings table that embodies mapping relations promptly becomes the Chinese and English field mappings table that Chinese interface can be provided for administration and supervision authorities, and an example is as shown in table 4:
Table 4
| Field name | Explanation of field | Type length | Default value | Major key whether |
| Field_name | Master data table field name | Varchar2 (30) | Be | |
| Field_type | Field type: 1-character string type; The 2-integer; The 3-floating type | Number (1) | ||
| Status | User mode: 0-does not use; 1-uses | Number (1) | 0 | |
| Field_title | The management sign (Chinese) of field correspondence is used for showing on the interface. | Varchar2 (30) | ||
| Table_id | Affiliated sublist ID | Number (10) |
The data management indication that issues of administration interface like this can show by the sign of the management in the Chinese and English field mappings table sublist field of this indication correspondence to make the actual field name of master data table shield the user.
Certainly, when the mapping of carrying out the base table field of associated virtual sublist, in new virtual sublist, the base table field can be used identical management sign, promptly needn't specify new management sign.But, if need also allow in the fixed different management sign of different virtual sublist middle fingers for same base table field, field_title field in the Chinese and English in this case field mappings table may be not unique in a record, corresponding with table_id, when revising the status corresponding, need delete or specify corresponding field_title simultaneously simultaneously with table_id.
As shown in Figure 2, provide a kind of data management apparatus 10 of the embodiment of being applied to one method below, comprising: receiving element 11, sublist administrative unit 12, field administrative unit 13 and Data Management Unit 14.
Receiving element 11 comprises reception subelement 1, receives subelement 2 112 and receives subelement 3 113.
Receive subelement 3 113, be used to receive sublist management indication, described sublist management indication can comprise that sublist increases indication and sublist deletion indication.
Receive subelement 1, be used for field management indication, described field management indication can comprise that field increases indication and field deletion indication.
Receive subelement 2 112, be used to receive the data management indication, described data management indication can comprise the indication of operations such as carrying out that data are inserted, upgraded, delete, search.
Sublist administrative unit 12, virtual sublist is set up or is deleted in the sublist management indication that is used for receiving according to receiving element 11.
Field administrative unit 13, the field management indication that is used for receiving according to receiving element 11 are set up or the incidence relation of the base table field of the sublist field of the virtual sublist that deletion sublist administrative unit 12 is set up and master data table.
If make the said equipment can be applicable to data managing method among the embodiment two, make receiving element present the Chinese administration interface that replaces the base table field name with the management sign, can adopt following setting: increase the management sign that comprises the sublist field that needs increase in the indication in field; The field administrative unit increases the corresponding relation of the sign of the management sign of described sublist field and base table field in increase the incidence relation that indication sets up according to described field; Like this, the user can manage operation on the administration interface that presents Chinese management sign, is to identify the sublist field that shows that this indication is corresponding by described management during the data management that makes receiving element receive is indicated.
The Database Systems 20 of a kind of embodiment of being applied to one or two methods are provided below, as shown in Figure 3, comprise data management apparatus 21, data storage device 22, data acquisition equipment 23 and data extraction device 24.
Embodiment for a better understanding of the present invention below provides a concrete application scenarios carrying out embodiment two data managing methods with above-mentioned Database Systems:
Suppositive scenario: certain department store prepares to carry out the new varieties goods marketing recently, and target is: like newborn class beverage, and often buy the user of food with low sugar content.The existing subscriber buys the information of newborn class beverage number of times/amount of money weekly in this moment user digging system, but does not also have the user to buy the information of food with low sugar content, and the sales field sales platform can provide the user to buy the number of times/amount of money of food with low sugar content.So in the user's digging system that adopts above-mentioned Database Systems, carry out following operation:
1, newly-increased virtual sublist, the sublist name is called " food with low sugar content ";
2, increase by two sub-literary name sections in " food with low sugar content " virtual sublist, the management sign is respectively " week is bought number of times " and " week is bought the amount of money ";
3, control data collecting device user that the sales field sales platform is provided number of times/amount of money of buying food with low sugar content is updated to " week is bought number of times " and " the week purchase amount of money " field of " food with low sugar content " table; (coming down to be updated to corresponding base table field)
4, issue the data management indication of carrying out data query, querying condition be set:
(newborn class beverage table---existing virtual sublist) week is bought number of times/amount of money＞x time/x unit
(food with low sugar content table---newly-built virtual sublist) week is bought number of times/amount of money＞x time/x unit
Sublist field inquiry by virtual sublist obtains the result, can show as some table records;
5, control data extraction equipment is exported all subscriber data numbers that satisfy condition, the Major key of the table record of promptly finding;
6, obtain desired subscriber data number, carry out the new varieties goods marketing targetedly.
By the foregoing description as can be seen, the embodiment of the invention adopts field mappings with the master data table on virtual sublist, the method of application oriented administration interface is provided by virtual sublist, make that operating personnel can be by the combination in any to master data literary name section, define the data structure that needs, can realize flexibly that application oriented data structure builds.No matter be that data dimension expansion or architectural characteristic are revised and can easily be realized by the reconstruct to virtual sublist.And,, guaranteed the stability of database master data table because the modification to the virtual subnet list structure does not cause change to the database object of reality on the administration interface.In addition, manage identification schemes based on the sublist field that the preferred embodiment of the present invention provides, make that the true field name of master data table can be shielded fully, operating personnel can be by friendly management sign, for example Chinese full sublist field name etc., conveniently carry out the data structure operation intuitively, improved the ease for use of system.
More than data managing method that the embodiment of the invention provided and management equipment and Database Systems are described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (12)
1, a kind of data managing method is characterized in that, this method comprises the steps:
Set up the incidence relation of the base table field of the sublist field of the first virtual sublist and master data table;
Reception is to the data management indication of the sublist field of the first virtual sublist; And
According to described incidence relation, the data management operations that is implemented as the base table field is indicated in the data management of described antithetical phrase literary name section.
2, data managing method according to claim 1 is characterized in that, also comprises step:
Receive sublist and increase indication; And
Increase indication according to described sublist and set up the first virtual sublist.
3, data managing method according to claim 1 is characterized in that, the described step of setting up the incidence relation of sublist field and base table field comprises:
Reception increases indication to the field of the first virtual sublist, and described field increases the attribute description that comprises the sublist field that needs increase in the indication;
Selection meets described attribute description and state is set to not related with any sublist field base table field;
The state of selected base table field is set to related with the sublist field of the first virtual sublist.
4, data managing method according to claim 3 is characterized in that: described field increases the management sign that also comprises the sublist field that needs increase in the indication, the corresponding preservation with the sign of selected base table field of described management sign;
Show the sublist field that this indication is corresponding by described management sign in the described data management indication.
5, data managing method according to claim 1 is characterized in that, the described step of setting up the incidence relation of sublist field and base table field comprises:
Obtain and show the sublist field of the second virtual sublist;
Reception increases indication to the field of the first virtual sublist, and described field increases the appointment that comprises in the indication certain sublist field of the second virtual sublist;
According to the incidence relation of the sublist field and the base table field of appointment, the state of this base table field is set to related with the sublist field of the first virtual sublist.
6, according to any described data managing method of claim 3～5, it is characterized in that described data managing method also comprises step:
Reception comprises the appointment to certain sublist field of the first virtual sublist to the field deletion indication of the first virtual sublist in the described field deletion indication; And
To specify the state of the related base table field of sublist field to be set to not related with the sublist field of the first virtual sublist with this.
7, data managing method according to claim 6, it is characterized in that, also comprise: be set to when not related with the sublist field of certain virtual sublist at the state of base table field, whether the state setting of judging this base table field for not related with other any sublist fields, if then the content of this base table field is emptied.
8, according to any described data managing method of claim 3～5, it is characterized in that described data managing method also comprises step:
Reception is to the sublist deletion indication of the first virtual sublist; And
According to described sublist deletion indication, the state of all the base table fields related with the sublist field of the first virtual sublist is set to not related with the sublist field of the first virtual sublist.
9, a kind of data management apparatus is characterized in that, this equipment comprises:
Receiving element, described receiving element comprise reception subelement one and receive subelement two; Described reception subelement one is used to receive field management indication; Described reception subelement two is used to receive the data management indication;
The field administrative unit is used for setting up or deleting according to described field management indication the incidence relation of the base table field of the sublist field of virtual sublist and master data table;
Data Management Unit is used for according to the incidence relation that described field administrative unit provides, the data management operations that is implemented as the base table field being indicated in the data management of antithetical phrase literary name section according to described data management indication.
10, data management apparatus according to claim 9 is characterized in that: described receiving element also comprises reception subelement three, is used to receive sublist management indication;
Described data management apparatus also comprises the sublist administrative unit, is used for setting up or delete virtual sublist according to described sublist management indication.
11, according to claim 9 or 10 described data management apparatus, it is characterized in that: described field management indication comprises that field increases indication, and described field increases the management sign that comprises the sublist field that needs increase in the indication; Described field administrative unit increases in the incidence relation that indication sets up according to described field, comprises the corresponding relation of the sign of the management sign of described sublist field and base table field; Show the sublist field that this indication is corresponding by described management sign in the described data management indication.
12, a kind of Database Systems is characterized in that: comprise data management apparatus, data storage device, data acquisition equipment and data extraction device;
Described data management apparatus adopts any described structure of claim 9～11;
Described data storage device is used to provide the master data table; Control according to described data management apparatus is carried out data management operations to the base table field of master data table, imports data or provides data to described data extraction device from described data acquisition equipment;
Described data acquisition equipment is used for control according to described data management apparatus from the external data source image data and offer described data storage device;
Described data extraction device is used for extracting data and offering outer application system from described data storage device according to the control of described data management apparatus.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200710087320 CN101021876A (en) | 2007-03-09 | 2007-03-09 | Data management method, equipment and data bank system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200710087320 CN101021876A (en) | 2007-03-09 | 2007-03-09 | Data management method, equipment and data bank system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101021876A true CN101021876A (en) | 2007-08-22 |
Family
ID=38709638
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200710087320 Pending CN101021876A (en) | 2007-03-09 | 2007-03-09 | Data management method, equipment and data bank system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101021876A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102253980A (en) * | 2011-06-23 | 2011-11-23 | 上海西本网络科技有限公司 | Data processing method and data processing system |
| CN103092916A (en) * | 2012-12-14 | 2013-05-08 | 华为技术有限公司 | Method and device for modifying data structure |
| CN103198144A (en) * | 2013-04-18 | 2013-07-10 | 北京元复科技有限公司 | Internet-of-things platform data management method |
| CN102103710B (en) * | 2009-12-21 | 2013-08-07 | 中国移动通信集团公司 | ERP (Enterprise Resource Planning) system access control method and platform |
| CN103970758A (en) * | 2013-01-29 | 2014-08-06 | 鸿富锦精密工业（深圳）有限公司 | Database accessing system and method |
| CN104991972A (en) * | 2015-07-28 | 2015-10-21 | 上海联影医疗科技有限公司 | Scanning protocol data storage method, scanning protocol data reading method and scanning protocol data storage device |
| CN106506661A (en) * | 2016-11-18 | 2017-03-15 | 浪潮软件集团有限公司 | Method, server and system for dynamically returning data |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
| CN108984620A (en) * | 2018-06-14 | 2018-12-11 | 中国科学院重庆绿色智能技术研究院 | A kind of relevant database and its design method of dynamic scalable |
| CN110489409A (en) * | 2018-09-14 | 2019-11-22 | 北京数聚鑫云信息技术有限公司 | A kind of method and device of dynamic expansion data field |
| CN111259046A (en) * | 2020-01-17 | 2020-06-09 | 深圳市魔数智擎人工智能有限公司 | Automatic generation method of parallelized SQL |
| CN112328665A (en) * | 2019-08-05 | 2021-02-05 | 北京国双科技有限公司 | Data import method and device, storage medium and processor |
| CN117789954A (en) * | 2024-02-26 | 2024-03-29 | 中国人民解放军海军青岛特勤疗养中心 | Rehabilitation and nursing equipment data management method and platform |
-
2007
- 2007-03-09 CN CN 200710087320 patent/CN101021876A/en active Pending
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102103710B (en) * | 2009-12-21 | 2013-08-07 | 中国移动通信集团公司 | ERP (Enterprise Resource Planning) system access control method and platform |
| CN102253980A (en) * | 2011-06-23 | 2011-11-23 | 上海西本网络科技有限公司 | Data processing method and data processing system |
| CN103092916A (en) * | 2012-12-14 | 2013-05-08 | 华为技术有限公司 | Method and device for modifying data structure |
| CN103092916B (en) * | 2012-12-14 | 2016-11-02 | 华为技术有限公司 | The method and apparatus of amendment data structure |
| CN103970758A (en) * | 2013-01-29 | 2014-08-06 | 鸿富锦精密工业（深圳）有限公司 | Database accessing system and method |
| CN103198144A (en) * | 2013-04-18 | 2013-07-10 | 北京元复科技有限公司 | Internet-of-things platform data management method |
| CN104991972A (en) * | 2015-07-28 | 2015-10-21 | 上海联影医疗科技有限公司 | Scanning protocol data storage method, scanning protocol data reading method and scanning protocol data storage device |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
| CN107273369B (en) * | 2016-04-06 | 2020-11-20 | 创新先进技术有限公司 | Table data modification method and device |
| CN106506661A (en) * | 2016-11-18 | 2017-03-15 | 浪潮软件集团有限公司 | Method, server and system for dynamically returning data |
| CN108984620A (en) * | 2018-06-14 | 2018-12-11 | 中国科学院重庆绿色智能技术研究院 | A kind of relevant database and its design method of dynamic scalable |
| CN108984620B (en) * | 2018-06-14 | 2021-02-05 | 中国科学院重庆绿色智能技术研究院 | Design method of dynamic extensible relational database |
| CN110489409A (en) * | 2018-09-14 | 2019-11-22 | 北京数聚鑫云信息技术有限公司 | A kind of method and device of dynamic expansion data field |
| CN110489409B (en) * | 2018-09-14 | 2020-06-23 | 北京数聚鑫云信息技术有限公司 | Method and device for dynamically expanding data field |
| CN112328665A (en) * | 2019-08-05 | 2021-02-05 | 北京国双科技有限公司 | Data import method and device, storage medium and processor |
| CN111259046A (en) * | 2020-01-17 | 2020-06-09 | 深圳市魔数智擎人工智能有限公司 | Automatic generation method of parallelized SQL |
| CN117789954A (en) * | 2024-02-26 | 2024-03-29 | 中国人民解放军海军青岛特勤疗养中心 | Rehabilitation and nursing equipment data management method and platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101021876A (en) | Data management method, equipment and data bank system | |
| CN101876983B (en) | Method for partitioning database and system thereof | |
| US5953017A (en) | Compressed object display | |
| KR100466143B1 (en) | File management method, contents recording apparatus, contents reproducing apparatus and contents recording medium | |
| US6826582B1 (en) | Method and system for using file systems for content management | |
| CN100458793C (en) | Mapping conversion method between data access level Xml format data and relational data | |
| CN101770479B (en) | Association relationship query method and device | |
| CN100465953C (en) | Iterative data analysis process via query result augmentation and result data feedback | |
| CN101673287A (en) | SQL sentence generation method and system | |
| US8364683B2 (en) | Importing and reconciling resources from disjoint name spaces to a common namespace | |
| CN103810212A (en) | Automated database index creation method and system | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| US20080005063A1 (en) | System and method of member unique names | |
| CN101183363B (en) | Method for unitedly configuring management EMS memory data-base by system table structure | |
| CN101258496A (en) | Autocompleting with queries to a database | |
| CN103678494A (en) | Method and device for client side and server side data synchronization | |
| CN106933837A (en) | A kind of database table model and creation method | |
| CN100426293C (en) | Object integrated management system | |
| CN102128628A (en) | Difference analysis method and difference analysis device for electronic maps | |
| CN106469372A (en) | A kind of address mapping method and device | |
| WO2023051125A1 (en) | Structured data version management method, apparatus, and related device | |
| CN109815240A (en) | For managing method, apparatus, equipment and the storage medium of index | |
| CN114579561A (en) | Data processing method and device, and storage medium | |
| US6701328B1 (en) | Database management system | |
| CA2702137A1 (en) | Update and serialization of xml documents |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20070822 |