CN113434501A - Storage method and device of relational database table and readable storage medium - Google Patents
Storage method and device of relational database table and readable storage medium Download PDFInfo
- Publication number
- CN113434501A CN113434501A CN202110699154.4A CN202110699154A CN113434501A CN 113434501 A CN113434501 A CN 113434501A CN 202110699154 A CN202110699154 A CN 202110699154A CN 113434501 A CN113434501 A CN 113434501A
- Authority
- CN
- China
- Prior art keywords
- data
- mapping relation
- primary key
- value
- built
- 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
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000013507 mapping Methods 0.000 claims abstract description 136
- 230000002085 persistent effect Effects 0.000 claims abstract description 10
- 230000002688 persistence Effects 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 9
- 238000013500 data storage Methods 0.000 claims description 8
- 238000003780 insertion Methods 0.000 claims description 7
- 230000037431 insertion Effects 0.000 claims description 7
- 238000010276 construction Methods 0.000 claims description 4
- 239000000126 substance Substances 0.000 claims description 2
- 238000012545 processing Methods 0.000 abstract description 12
- 238000005516 engineering process Methods 0.000 abstract description 3
- 230000000875 corresponding effect Effects 0.000 description 34
- 230000006870 function Effects 0.000 description 20
- 238000010586 diagram Methods 0.000 description 12
- 238000004891 communication Methods 0.000 description 7
- 230000004044 response Effects 0.000 description 6
- 238000007726 management method Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000011161 development Methods 0.000 description 3
- 239000004973 liquid crystal related substance Substances 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000002596 correlated effect Effects 0.000 description 2
- 238000013479 data entry Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000001276 controlling effect Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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
Abstract
The invention relates to a data processing technology, and provides a storage method, equipment and a readable storage medium for a relational database table, wherein the method comprises the following steps: persisting the data of the constructed mapping relation table into a redis; acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to data of a mapping relation table in the redis; inserting data into the newly-built table according to the ID value of the current primary key, wherein when the newly-built table is associated with a target table to be associated, the data of the target table is updated according to the data inserted into the newly-built table, and the updated newly-built table and the target table are stored into a redis; and updating the newly built data saved in the redis into the mapping relation table. The invention also relates to a block chain technology, and the data of the mapping relation table is stored in the block chain. The invention mainly aims to solve the problem of transaction control when the association of two tables is operated by persisting all data in the mapping relation table to a cache server redis.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for storing a relational database table, electronic equipment and a computer readable storage medium.
Background
In the development process of the intelligent agricultural system, a scene that two tables are operated in one interface and data of one table is related to a primary key ID of the other table often exists. However, since there is no return value in the current relational database data insertion, the primary key ID of the newly created table insertion data can be acquired and saved in the data of another table only by performing the query operation again after the data insertion.
At present, the execution logic of the association mode of the two tables is relatively complicated, and under the condition of high concurrency, the database is stressed greatly by a large amount of data insertion and query, and the condition of data loss exists.
In order to solve the above problems, the present invention needs to provide a new method for storing a relational database table.
Disclosure of Invention
The invention provides a storage method and a storage device of a relational database table, electronic equipment and a computer readable storage medium, and mainly aims to realize the quick acquisition of a main key ID under a high concurrency situation and solve the problem of transaction control when the association of two tables is operated by persisting all data in a mapping relation table in the relational database to a cache server redis.
In order to achieve the above object, the present invention provides a method for storing a relational database table, which is applied to an electronic device, and the method includes:
constructing a mapping relation table of a relational database, wherein the mapping relation table is used for storing the name of a newly-built table of the relational database and a primary key ID value corresponding to the newly-built table;
the data of the mapping relation table is persisted into a cache server redis;
acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to the data of the mapping relation table in the cache server redis;
inserting data into the new building table according to the current primary key ID value, wherein when the new building table is associated with a target table to be associated, data updating is carried out on the target table according to the data inserted into the new building table, and the updated new building table and the target table are stored in the cache server redis;
and updating the data of the new built table stored in the cache server redis into the mapping relation table.
Optionally, the mapping relation table includes a primary key ID value of the mapping relation table, a name of a new table of the relational database, and a primary key ID value of a new table of the relational database.
Optionally, the storing the data of the mapping relation table in a block chain, and the persisting the data of the mapping relation table in a cache server redis includes:
reading the mapping relation data of the mapping relation table;
and storing the read mapping relation data into the cache server redis in a semi-structured form, wherein the cache server redis not provided with an expiration time for the data of the mapping relation table.
Optionally, obtaining, according to the data in the mapping relationship table in the cache server redis, a current primary key ID value corresponding to a new table of data to be inserted includes:
looking up the name of the newly built table from the mapping relation table in the cache server redis;
and acquiring the ID value of the primary key of the new built table according to the name of the new built table.
Optionally, associating the new table with a target table to be associated includes:
setting related data items in the new build table;
correlating the related data items with primary key ID values of the target table;
the new build table and the target table are associated with each other by the associated data item and the primary key ID value of the target table.
Optionally, the performing data update on the target table according to the data inserted in the newly created table includes:
judging whether to update the data of the target table according to the related data item of the new table and the ID value of the primary key of the target table;
when the primary key ID value of the corresponding target table is inquired according to the related data item of the newly built table, if the primary key ID value of the corresponding target table is inquired in the target table, the target table is not updated;
and if the primary key ID value of the corresponding target table cannot be inquired in the target table, updating the target table.
In order to solve the above problem, the present invention also provides a storage apparatus for a base relational database table, the apparatus comprising:
the system comprises a mapping relation table construction module, a key configuration module and a key configuration module, wherein the mapping relation table construction module is used for constructing a mapping relation table of a relational database, and the mapping relation table is used for storing names of a newly-built table of the relational database and primary key ID values corresponding to the newly-built table;
the data persistence module is used for persisting the data of the mapping relation table into a cache server redis;
a current primary key ID value obtaining module, configured to obtain, according to the data in the mapping relationship table in the cache server redis, a current primary key ID value corresponding to a newly created table of data to be inserted;
the data inserting module is used for inserting data into the newly established table according to the current primary key ID value;
a new table and target table association module, configured to, when the new table is associated with a target table to be associated, perform data update on the target table according to data inserted in the new table, and store the new table and the target table after update to the cache server redis;
and the data updating module is used for updating the data of the newly built table stored in the cache server redis into the mapping relation table.
Optionally, the data persistence module comprises a data reading module and a data storage module, wherein,
the data reading module is used for reading the mapping relation data of the mapping relation table;
the data storage module is configured to store the read mapping relation data in the cache server redis in a semi-structured form, where an expiration time is not set for the data in the mapping relation table in the cache server redis.
In order to solve the above problem, the present invention also provides an electronic device, including:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to cause the at least one processor to perform the steps of storing the relational database tables described above.
In order to solve the above problem, the present invention further provides a computer-readable storage medium, which stores at least one instruction, where the at least one instruction is executed by a processor in an electronic device to implement the above storage method for a relational database table.
The embodiment of the invention constructs a mapping relation table of a relational database; the data of the mapping relation table is persisted into a cache server redis; acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to the data of the mapping relation table in the cache server redis; inserting data into the newly built table according to the current primary key ID value; when the new table is associated with a target table to be associated, data updating is carried out on the target table according to data inserted in the new table, and the updated new table and the target table are stored in the cache server redis; and updating the data of the new built table stored in the cache server redis into the mapping relation table. According to the method and the device, all data in the mapping relation table in the relational database are persisted to the cache server redis, so that the main key ID can be quickly acquired under the high concurrency situation, and meanwhile, the problem of transaction control during the association of two tables is solved.
Drawings
Fig. 1 is a schematic flow chart of a storage method of a relational database table according to an embodiment of the present invention;
FIG. 2 is a block diagram of a storage device for relational database tables according to an embodiment of the present invention;
fig. 3 is a schematic internal structural diagram of an electronic device implementing a storage method for a relational database table according to an embodiment of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In the following description, numerous specific details are set forth. However, it is understood that embodiments of the invention may be practiced without these specific details. In other instances, well-known methods, structures, and techniques have not been shown in detail in order not to obscure an understanding of this description. References to "one embodiment," "an embodiment," "example embodiment," "various embodiments," etc., indicate that the embodiment described in connection with the invention may include a particular feature, structure, or characteristic, but every embodiment may not necessarily include the particular feature, structure, or characteristic. Furthermore, repeated usage of the phrase "in one embodiment" does not necessarily refer to the same embodiment, although it may.
As used herein, unless otherwise specified the use of the ordinal adjectives "first", "second", "third", etc., to describe a common object, merely indicate that different instances of like objects are being referred to, and are not intended to imply that the objects so described must be in a given sequence, either temporally, spatially, in ranking, or in any other manner.
As used herein, unless otherwise specified, the terms "mobile device" and/or "device" generally refer to a wireless communication device, and more specifically to one or more of the following: a portable electronic device, a telephone (e.g., a cellular telephone, a smartphone), a computer (e.g., a laptop, a tablet), a portable media player, a Personal Digital Assistant (PDA), or any other electronic device with networking capabilities.
The invention provides a storage method of a relational database table. Fig. 1 is a schematic flow chart illustrating a storage method of a relational database table according to an embodiment of the present invention. The method may be performed by an apparatus, which may be implemented by software and/or hardware.
In this embodiment, the method for storing a relational database table includes:
s1: constructing a mapping relation table of a relational database, wherein the mapping relation table is used for storing the name of a newly-built table of the relational database and a primary key ID value corresponding to the newly-built table;
s2: the data of the mapping relation table is persisted into a cache server redis;
s3: acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to the data of the mapping relation table in the cache server redis;
s4: inserting data into the new building table according to the current primary key ID value, wherein when the new building table is associated with a target table to be associated, data updating is carried out on the target table according to the data inserted into the new building table, and the updated new building table and the target table are stored in the cache server redis;
s5: and updating the data of the new built table stored in the cache server redis into the mapping relation table.
The storage method of the relational database table realizes the quick acquisition of the primary key ID under the high concurrency situation by persisting all data in the mapping relational table in the relational database to the cache server redis, and simultaneously solves the problem of transaction control when the two tables are associated.
In the embodiment of the invention, the ID value of the primary key of the query table is obtained from the redis cache of the cache server, so that the query efficiency can be improved. The redis supports high concurrency and high performance, and the redis operation is atomic and simultaneously supports transactions; after data in the redis is persisted to the hard disk, the data can be guaranteed not to be lost after power failure, and the data can be loaded again for use when the hard disk is restarted. In the invention, the ID value of the primary key of the table is obtained in advance, so that other operations can be performed on two different and related tables, and the transaction control is convenient. By adopting the storage method, the operation of re-query after data insertion can be omitted, the pressure brought by querying a database is reduced, redundant codes can be eliminated, the codes are simpler, and the workload of programmers is reduced.
In step S1, the mapping table includes a primary key ID value of the mapping table, a name of a new table of the relational database, and a primary key ID value of the new table of the relational database. The mapping relation table (table _ ID) comprises three fields of ID, table _ name and ID _ value, wherein ID is the primary key ID of the table _ ID table (mapping relation table), table _ name is the name of a newly-built table of the relational database, ID _ value is the primary key ID value of the newly-built table, and the default primary key ID value of the newly-built table is 0.
In a specific embodiment of the present invention, the table _ id of the mapping relationship table is exemplified as follows:
| id | table _ name (Table name) | ID _ value (Primary Key ID value) |
| 1 | crab_fishing | 0 |
| 2 | crab_specs | 0 |
| 3 | crab_plan | 0 |
| …… | …… | …… |
In the table, table _ ID represents a mapping relation table of the table name of the newly-built table and the table primary key ID;
the table name of table 1 is crab _ fixing, and the primary key ID value of the table name is crab _ fixing is 0;
the name of table 2 is crab _ specs, and the primary key ID value of the table name crab _ specs is 0;
the name of table 3 is crab _ plan, and the primary key ID value of the table name crab _ specs is 0.
In step S2, the persisting the data of the mapping table to a cache server redis includes:
s21: reading the mapping relation data of the mapping relation table;
s22: and storing the read mapping relation data into the cache server redis in a semi-structured form, wherein the cache server redis does not set an expiration time for the data of the mapping relation table.
In the embodiment of the invention, the data of the mapping relation table in the cache server redis is not set with the expiration time, so that the data can be always stored in the redis memory, the data loading speed from the redis memory is very high, and the query efficiency is further improved.
The cache server redis has a certain persistence function, and as a persistence layer, the data stored by the cache server redis is semi-structured, so that the read-in speed of the redis is higher than that of a relational database. Compared with a relational database, the redis is used as a cache, supports data storage in a memory, has very high read-write response speed, is atomic in operation, and supports transaction control under high concurrency.
In the embodiment of the invention, the data of the mapping relation table is persisted into a cache server redis, the redis is stored based on key-value, and the primary key ID value is obtained through the table name of the newly built table, and is unique, so that the atomicity of data operation can be ensured, and meanwhile, the query efficiency is greatly improved.
In step S3, the obtaining, according to the data in the mapping relationship table in the cache server redis, a current primary key ID value corresponding to a new table of data to be inserted includes:
s31: looking up the table name of the new built table from the mapping relation table in the cache server redis;
s32: and acquiring the ID value of the primary key of the new built table according to the table name of the new built table.
In the embodiment of the present invention, when data is inserted into the table stored in the table _ name field, first, a value of ID _ value corresponding to the new table is obtained from the cache server redis, and the value is the current primary key ID of the new table. The table stored in the table _ name field refers to a newly built table, the name of the table is searched in a mapping relation table in the redis of the cache server, and the value of ID _ value corresponding to the newly built table is obtained according to the name of the newly built table, wherein the value is the current primary key ID value of the newly built table; and inserting data into the newly created table according to the current primary key ID value.
In step S4, the associating the new table with the target table to be associated includes:
s41: setting related data items in the new build table;
s42: correlating the related data items with primary key ID values of the target table;
s43: the new built table and the target table are mutually related through the related data items and the primary key ID value of the target table.
In step S42, the related data item is correlated with the primary key ID value of the target table by the Loadrunner script.
In the embodiment of the present invention, association (correlation) refers to that, during the playback of a script, a client sends a request, and searches through left and right boundary values (i.e., association rules) defined by an association function in content responded by a server to obtain corresponding values, and a variable form replaces a static value during recording, so as to send a correct request to the server, and this method of dynamically obtaining server response content is called association. The association is also a special parameterization, but is somewhat different from the general parameterization. Typical parameterized parameters are derived from a file, a defined table, a result set written by sql, etc., but the parameters obtained by association are a qualified, dynamic value returned by the server in response to a request.
In step S4, the data updating the target table according to the inserted data of the new built table includes:
44: determining whether to update the data of the target table according to the inserted related data item of the new table and the ID value of the primary key of the target table;
s45: inquiring a primary key ID value of a target table corresponding to the relevant data item according to the relevant inserted data item of the newly built table, and if the primary key ID value of the corresponding target table is inquired in the target table, not updating the target table;
s46: and if the primary key ID value of the corresponding target table cannot be inquired in the target table, updating the target table.
And updating the target table specifically means inserting information which can be associated with the newly-built table into the target table.
In a specific embodiment of the present invention, how the new table and the target table are associated is illustrated. In the process of data development, data received by a business layer may involve multiple tables, and the data needs to be split and stored in two tables. Now suppose there are two tables (table a and table b), how table a and table b are associated together will be explained below; wherein, table a is the new table, and table b is the target table.
Data in Table a are as follows
| id | name | classId | … |
| 1 | Zhang San | 1 | … |
| 2 | Li Si | 1 | … |
| 3 | Wang Wu | 2 | |
| 4 | Zhao liu xi | 3 | … |
Table b
| id | class_name | class_owner | … |
| 1 | Class 1 class one year | Plum teacher | … |
| 2 | Class 2 class one year | Song teacher | … |
In tables a and b above, the classId in Table a is the associated data entry with the id primary key value of Table b. In specific application, for convenience of query, the primary key values of table b are usually saved as related data items in table a; however, if the relevant data is not stored in table b, the associated primary key of table b cannot be stored in the data of table a unless the primary key of the data in table b is known. And the primary key value of the table b can be inserted and inquired by calling the inquiry method, although the storage of the data of the table a can also be realized, the inquiry pressure of the database is correspondingly increased. But if the main key of the table b is directly obtained from the memory, the speed is high, the efficiency is high, and the transaction control is convenient.
In the embodiment of the present invention, in the two tables in the above embodiment, the classId in table a and the id in table b are associated with each other through the Loadrunner script, if wang is queried, it can be known in table a that the primary key value of table b is 2, and the information that id of table b is 2 is queried, then: if the class is class 2 of one year and the teacher is Song teacher, then table b does not need to update data. If Zhao Liu is queried, it can be known that the primary key value in Table a should be 3, but since Table b does not have information id 3, then it is necessary to update the data in Table b, i.e. insert information id 3 in Table b, so that Table a and Table b can be associated together.
In step S5, the data saved to the new build table in the cache server redis is updated into the mapping relationship table, that is, the current primary key ID value of the new build table is mapped into the mapping relationship table; namely: when the data of the new table and the related table of the target table are successfully stored, updating the value of id _ value into table _ id of the relational database, thereby realizing data synchronization between the relational database and a cache server redis, namely: the table name and the primary key ID value (mapping relation table) of the relational database are stored through the relational database table, data loss after the server is powered off is prevented, and the server can be loaded again after being restarted.
The embodiment of the invention constructs a mapping relation table of a relational database; the data of the mapping relation table is persisted into a cache server redis; when data is inserted into one of the newly-built tables, acquiring a current primary key ID value corresponding to the newly-built table according to the data of the mapping relation table in the cache server redis; inserting data into the newly built table according to the current primary key ID value; when the new table is associated with a target table to be associated, data updating is carried out on the target table according to data inserted in the new table, and the updated new table and the target table are stored in the cache server redis; and updating the data of the new built table stored in the cache server redis into the mapping relation table. According to the method and the device, all data in the mapping relation table in the relational database are persisted to the cache server redis, so that the main key ID can be quickly acquired under the high concurrency situation, and meanwhile, the problem of transaction control during the association of two tables is solved.
FIG. 2 is a functional block diagram of a storage device for relational database tables according to the present invention. The storage device 100 of the relational database table according to the present invention may be installed in an electronic device. Depending on the functions implemented, the storage means 100 of the relational database table may comprise: the system comprises a mapping relation table building module 101, a data persistence module 102, a current primary key ID value obtaining module 103, a data inserting module 104, a new table building and target table associating module 105 and a data updating module 106. The module of the present invention, which may also be referred to as a unit, refers to a series of computer program segments that can be executed by a processor of an electronic device and that can perform a fixed function, and that are stored in a memory of the electronic device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
a mapping relation table constructing module 101, configured to construct a mapping relation table of a relational database, where the mapping relation table is used to store a name of a new table of the relational database and a primary key ID value corresponding to the new table;
the data persistence module 102 is configured to persist the data of the mapping relation table into a cache server redis;
a current primary key ID value obtaining module 103, configured to obtain, according to the data in the mapping relationship table in the cache server redis, a current primary key ID value corresponding to a newly created table of data to be inserted;
a data insertion module 104, configured to insert data into the new table according to the current primary key ID value;
a new table and target table association module 105, configured to, when the new table is associated with a target table to be associated, perform data update on the target table according to data inserted in the new table, and store the new table and the target table after update in the cache server redis;
and a data updating module 106, configured to update the data of the new table stored in the cache server redis to the mapping relationship table.
In the mapping relationship table constructing module 101, the mapping relationship table includes a primary key ID value of the mapping relationship table, a name of a newly created table of the relational database, and a primary key ID value of a newly created table of the relational database. The mapping relation table (table _ ID) comprises three fields of ID, table _ name and ID _ value, wherein ID is the primary key ID of the table _ ID table (mapping relation table), table _ name is the name of a newly-built table of the relational database, ID _ value is the primary key ID value of the newly-built table, and the default primary key ID value of the newly-built table is 0.
In a specific embodiment of the present invention, the table _ id of the mapping relationship table is exemplified as follows:
in the table, table _ ID represents a mapping relation table of the table name of the newly-built table and the table primary key ID;
the table name of table 1 is crab _ fixing, and the primary key ID value of the table name is crab _ fixing is 0;
the name of table 2 is crab _ specs, and the primary key ID value of the table name crab _ specs is 0;
the name of table 3 is crab _ plan, and the primary key ID value of the table name crab _ specs is 0.
In the data persistence module 102, the step of persisting the data of the mapping relationship table to a cache server redis includes: a data reading module and a data saving module, wherein,
the data reading module is used for reading the mapping relation data of the mapping relation table;
and the data storage module is used for storing the read mapping relation data into the cache server redis in a semi-structured form, wherein the cache server redis does not set expiration time for the data of the mapping relation table.
In the embodiment of the invention, the data of the mapping relation table in the cache server redis is not set with the expiration time, so that the data can be always stored in the redis memory, the data loading speed from the redis memory is very high, and the query efficiency is further improved.
The cache server redis has a certain persistence function, and as a persistence layer, the data stored by the cache server redis is semi-structured, so that the read-in speed of the redis is higher than that of a relational database. Compared with a relational database, the redis is used as a cache, supports data storage in a memory, has very high read-write response speed, is atomic in operation, and supports transaction control under high concurrency.
In the embodiment of the invention, the data of the mapping relation table is persisted into a cache server redis, the redis is stored based on key-value, and the primary key ID value is obtained through the table name of the newly built table, and is unique, so that the atomicity of data operation can be ensured, and meanwhile, the query efficiency is greatly improved.
Wherein, the current primary key ID value obtaining module 103 is configured to, when inserting data into one of the newly created tables, determine a current primary key ID value corresponding to the newly created table according to data of the mapping relationship table in the cache server redis, and includes a table name lookup module and a primary key ID value obtaining module,
the table name searching module is used for searching the table name of the newly established table from the mapping relation table in the cache server redis;
and the primary key ID value acquisition module is used for acquiring the primary key ID value of the new table according to the table name of the new table.
In the embodiment of the present invention, when data is inserted into the table stored in the table _ name field, first, a value of ID _ value corresponding to the new table is obtained from the cache server redis, and the value is the current primary key ID of the new table. The table stored in the table _ name field refers to a newly built table, the name of the table is searched in a mapping relation table in the redis of the cache server, and the value of ID _ value corresponding to the newly built table is obtained according to the name of the newly built table, wherein the value is the current primary key ID value of the newly built table; and inserting data into the newly created table according to the current primary key ID value.
And the data inserting module 104 is configured to insert data into the new table according to the current primary key ID value.
A new build table and target table associating module 105, configured to associate the new build table with a target table to be associated, including: setting related data items in the new build table;
setting a primary key ID value of the target table in the target table;
correlating the related data items with primary key ID values of the target table;
the new built table and the target table are mutually related through the related data items and the primary key ID value of the target table.
Wherein the associated data item is correlated with a primary key ID value of the target table by a Loadrunner script.
In the embodiment of the present invention, association (correlation) refers to that, during the playback of a script, a client sends a request, and searches through left and right boundary values (i.e., association rules) defined by an association function in content responded by a server to obtain corresponding values, and a variable form replaces a static value during recording, so as to send a correct request to the server, and this method of dynamically obtaining server response content is called association. The association is also a special parameterization, but is somewhat different from the general parameterization. Typical parameterized parameters are derived from a file, a defined table, a result set written by sql, etc., but the parameters obtained by association are a qualified, dynamic value returned by the server in response to a request.
In the new table creation and target table association module 105, the updating data of the target table according to the inserted data of the new table creation includes:
determining whether to update the data of the target table according to the inserted related data item of the new table and the ID value of the primary key of the target table;
inquiring a primary key ID value of a target table corresponding to the relevant data item according to the relevant inserted data item of the newly built table, and if the primary key ID value of the corresponding target table is inquired in the target table, not updating the target table;
and if the primary key ID value of the corresponding target table cannot be inquired in the target table, updating the target table.
And updating the target table specifically means inserting information which can be associated with the newly-built table into the target table. In the specific embodiment of the present invention, how the new table and the target table are associated is illustrated. In the process of data development, data received by a business layer may involve multiple tables, and the data needs to be split and stored in two tables. Now suppose there are two tables (table a and table b), how table a and table b are associated together will be explained below; wherein, table a is the new table, and table b is the target table.
TABLE a
| id | name | classId | … |
| 1 | Zhang San | 1 | … |
| 2 | Li Si | 1 | … |
| 3 | Wang Wu | 2 | |
| 4 | Zhao liu xi | 3 | … |
Table b
| id | class_name | class_owner | … |
| 1 | Class 1 class one year | Plum teacher | … |
| 2 | Class 2 class one year | Song teacher | … |
In tables a and b above, the classId in Table a is the associated data entry with the id primary key value of Table b. In specific application, for convenience of query, the primary key values of table b are usually saved as related data items in table a; however, if the relevant data is not stored in table b, the associated primary key of table b cannot be stored in the data of table a unless the primary key of the data in table b is known. And the primary key value of the table b can be inserted and inquired by calling the inquiry method, although the storage of the data of the table a can also be realized, the inquiry pressure of the database is correspondingly increased. But if the main key of the table b is directly obtained from the memory, the speed is high, the efficiency is high, and the transaction control is convenient.
In the embodiment of the present invention, in the two tables in the above embodiment, the classId in table a and the id in table b are associated with each other through the Loadrunner script, if wang is queried, it can be known in table a that the primary key value of table b is 2, and the information that id of table b is 2 is queried, then: if the class is class 2 of one year and the teacher is Song teacher, then table b does not need to update data. If Zhao Liu is queried, it can be known that the primary key value in Table a should be 3, but since Table b does not have information id 3, then it is necessary to update the data in Table b, i.e. insert information id 3 in Table b, so that Table a and Table b can be associated together.
In the data updating module 106, updating the data of the new built table stored in the cache server redis into the mapping relationship table, that is, mapping the current primary key ID value of the new built table into the mapping relationship table; namely: when the data of the new table and the related table of the target table are successfully stored, updating the value of id _ value into table _ id of the relational database, thereby realizing data synchronization between the relational database and a cache server redis, namely: the table name and the primary key ID value (mapping relation table) of the relational database are stored through the relational database table, data loss after the server is powered off is prevented, and the server can be loaded again after being restarted.
The embodiment of the invention constructs a mapping relation table of a relational database; the data of the mapping relation table is persisted into a cache server redis; when data is inserted into one of the newly-built tables, acquiring a current primary key ID value corresponding to the newly-built table according to the data of the mapping relation table in the cache server redis; inserting data into the newly built table according to the current primary key ID value; when the new table is associated with a target table to be associated, data updating is carried out on the target table according to data inserted in the new table, and the updated new table and the target table are stored in the cache server redis; and updating the data of the new built table stored in the cache server redis into the mapping relation table. According to the method and the device, all data in the mapping relation table in the relational database are persisted to the cache server redis, so that the main key ID can be quickly acquired under the high concurrency situation, and meanwhile, the problem of transaction control during the association of two tables is solved.
Fig. 3 is a schematic structural diagram of an electronic device implementing a storage method for a relational database table according to the present invention.
The electronic device 1 may comprise a processor 10, a memory 11 and a bus, and may further comprise a computer program, such as a stored program 12 of a relational database table, stored in the memory 11 and executable on the processor 10.
The memory 11 includes at least one type of readable storage medium, which includes flash memory, removable hard disk, multimedia card, card-type memory (e.g., SD or DX memory, etc.), magnetic memory, magnetic disk, optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the electronic device 1, such as a removable hard disk of the electronic device 1. The memory 11 may also be an external storage device of the electronic device 1 in other embodiments, such as a plug-in mobile hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the electronic device 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic device 1. The memory 11 may be used not only for storing application software installed in the electronic device 1 and various types of data, such as codes of a data auditing program, but also for temporarily storing data that has been output or will be output. The memory may store content that may be displayed by the electronic device or sent to other devices (e.g., headphones) for display or play by the other devices. The memory may also store content received from other devices. This content from the other devices may be displayed, played, or used by the electronic device to perform any necessary tasks or operations that may be performed by a computer processor or other component in the electronic device and/or the wireless access point.
The processor 10 may be composed of an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged with the same or different functions, including one or more Central Processing Units (CPUs), microprocessors, digital Processing chips, graphics processors, and combinations of various control chips. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects various components of the whole electronic device by using various interfaces and lines, and executes various functions and processes data of the electronic device 1 by operating or executing programs or modules (e.g., data auditing programs, etc.) stored in the memory 11 and calling data stored in the memory 11. The electronics can also include a chipset (not shown) for controlling communication between the one or more processors and one or more of the other components of the user device. In particular embodiments, the electronic device may be based on
Framework or
Architecture, and the processor and chipset may be from
A family of processors and chipsets. The one or more processors 104 may also include one or more application specific integrated circuits(ASIC) or Application Specific Standard Products (ASSP) for handling specific data processing functions or tasks.
The bus may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is arranged to enable connection communication between the memory 11 and at least one processor 10 or the like.
Further, the network and I/O interfaces may include one or more communication interfaces or network interface devices to provide for the transfer of data between the electronic device and other devices (e.g., network servers) via a network (not shown). The communication interfaces may include, but are not limited to: a human area network (BAN), a Personal Area Network (PAN), a wired Local Area Network (LAN), a Wireless Local Area Network (WLAN), a Wireless Wide Area Network (WWAN), and so on. The user device 102 may be coupled to the network via a wired connection. However, the wireless system interface may include hardware or software to broadcast and receive messages using the Wi-Fi direct standard and/or the IEEE 802.11 wireless standard, the bluetooth low energy standard, the Wi-Gig standard, and/or any other wireless standard and/or combinations thereof.
A wireless system may include a transmitter and a receiver or a transceiver capable of operating over a wide range of operating frequencies governed by the IEEE 802.11 wireless standard. The communication interface may utilize acoustic, radio frequency, optical, or other signals to exchange data between the electronic device and other devices, such as access points, hosts, servers, routers, reading devices, and the like. The network 118 may include, but is not limited to: the internet, private networks, virtual private networks, wireless wide area networks, local area networks, metropolitan area networks, telephone networks, and the like.
The display may include, but is not limited to, a liquid crystal display, a light emitting diode display, or an E-Ink display manufactured by E Ink corporation (E Ink Corp. of Cambridge, Mass.) in Massachusetts, Mass. The display may be used to display content to a user in the form of text, images, or video. In particular instances, the display may also operate as a touch screen display, which may enable a user to initiate commands or operations by touching the screen using certain fingers or gestures.
Fig. 3 only shows an electronic device with components, it will be understood by a person skilled in the art that the structure shown in fig. 2 does not constitute a limitation of the electronic device 1, and may comprise fewer or more components than shown, or a combination of certain components, or a different arrangement of components.
For example, although not shown, the electronic device 1 may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so as to implement functions of charge management, discharge management, power consumption management, and the like through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The electronic device 1 may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
Further, the electronic device 1 may further include a network interface, and optionally, the network interface may include a wired interface and/or a wireless interface (such as a WI-FI interface, a bluetooth interface, etc.), which are generally used for establishing a communication connection between the electronic device 1 and other electronic devices.
Optionally, the electronic device 1 may further comprise a user interface, which may be a Display (Display), an input unit (such as a Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the electronic device 1 and for displaying a visualized user interface, among other things.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
The storage program 12 of the relational database table stored in the memory 11 of the electronic device 1 is a combination of a plurality of instructions, which when executed in the processor 10, can realize:
constructing a mapping relation table of a relational database, wherein the mapping relation table is used for storing the name of a newly-built table of the relational database and a primary key ID value corresponding to the newly-built table;
the data of the mapping relation table is persisted into a cache server redis;
acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to the data of the mapping relation table in the cache server redis;
inserting data into the new building table according to the current primary key ID value, wherein when the new building table is associated with a target table to be associated, data updating is carried out on the target table according to the data inserted into the new building table, and the updated new building table and the target table are stored into the cache server redis;
and updating the data of the new built table stored in the cache server redis into the mapping relation table.
Specifically, the specific implementation method of the processor 10 for the instruction may refer to the description of the relevant steps in the embodiment corresponding to fig. 1, which is not described herein again. It should be emphasized that, in order to further ensure the privacy and security of the similarity semantic processing result of each group of semantic units to be processed, the similarity semantic processing of each group of semantic units to be processed may also be stored in a node of a block chain.
Further, the integrated modules/units of the electronic device 1, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. The computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM).
In an embodiment of the present invention, a computer-readable storage medium has at least one instruction stored therein, where the at least one instruction is executed by a processor in an electronic device to implement the steps of the above storage method for a relational database table, and the specific method is as follows:
constructing a mapping relation table of a relational database, wherein the mapping relation table is used for storing the name of a newly-built table of the relational database and a primary key ID value corresponding to the newly-built table;
the data of the mapping relation table is persisted into a cache server redis;
acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to the data of the mapping relation table in the cache server redis;
inserting data into the new building table according to the current primary key ID value, wherein when the new building table is associated with a target table to be associated, data updating is carried out on the target table according to the data inserted into the new building table, and the updated new building table and the target table are stored into the cache server redis;
and updating the data of the new built table stored in the cache server redis into the mapping relation table.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
Certain embodiments of the present invention are described above with reference to block diagrams and flowchart illustrations of systems and methods and/or computer program products according to exemplary embodiments of the invention. It will be understood that one or more blocks of the block diagrams and flowchart illustrations, and combinations of blocks in the block diagrams and flowchart illustrations, respectively, can be implemented by computer-executable program instructions. Likewise, some blocks of the block diagrams and flow diagrams may not necessarily be performed in the order presented, or may even not necessarily be performed at all, according to some embodiments of the invention.
These computer-executable program instructions may be loaded onto a general purpose computer, special purpose computer, processor, or other programmable data processing apparatus to produce a particular machine, such that the instructions which execute on the computer, processor, or other programmable data processing apparatus create means for implementing one or more functions specified in the flowchart block or blocks. These computer program products may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement one or more functions specified in the flowchart block or blocks. For example, embodiments of the invention may provide a computer program product comprising a computer usable medium having a computer readable program code or program instructions embodied therein, said computer readable program code adapted to be executed to implement one or more functions specified in the flowchart block or blocks. The computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational elements or steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide elements or steps for implementing the functions specified in the flowchart block or blocks.
Accordingly, blocks of the block diagrams or flowchart illustrations support combinations of means for performing the specified functions, combinations of elements or steps for performing the specified functions and program instruction means for performing the specified functions. It will also be understood that each block of the block diagrams and flowchart illustrations, and combinations of blocks in the block diagrams and flowchart illustrations, can be implemented by special purpose hardware-based computer systems that perform the specified functions, elements or steps, or combinations of special purpose hardware and computer instructions.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof.
The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
While certain embodiments of the invention have been described in connection with what is presently considered to be the most practical and various embodiments, it is to be understood that the invention is not to be limited to the disclosed embodiments, but on the contrary, is intended to cover various modifications and equivalent arrangements included within the scope of the appended claims. Although specific terms are employed herein, they are used in a generic and descriptive sense only and not for purposes of limitation.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.
Claims (10)
1. A storage method of a relational database table is applied to electronic equipment, and is characterized by comprising the following steps:
constructing a mapping relation table of a relational database, wherein the mapping relation table is used for storing the name of a newly-built table of the relational database and a primary key ID value corresponding to the newly-built table;
the data of the mapping relation table is persisted into a cache server redis;
acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to the data of the mapping relation table in the cache server redis;
inserting data into the new building table according to the current primary key ID value, wherein when the new building table is associated with a target table to be associated, data updating is carried out on the target table according to the data inserted into the new building table, and the updated new building table and the target table are stored into the cache server redis;
and updating the data of the new built table stored in the cache server redis into the mapping relation table.
2. The method of storing relational database tables according to claim 1,
the mapping relation table comprises a primary key ID value of the mapping relation table, a name of a newly-built table of the relational database and a primary key ID value of the newly-built table of the relational database.
3. The method of storing relational database tables according to claim 1,
storing data of the mapping relation table in a block chain, and persisting the data of the mapping relation table to a cache server redis includes:
reading the mapping relation data of the mapping relation table;
and storing the read mapping relation data into the cache server redis in a semi-structured form, wherein the cache server redis not provided with an expiration time for the data of the mapping relation table.
4. The method of storing relational database tables according to claim 1,
acquiring a current primary key ID value corresponding to a newly-built table of data to be inserted according to the data of the mapping relation table in the cache server redis, wherein the current primary key ID value comprises the following steps:
looking up the name of the newly built table from the mapping relation table in the cache server redis;
and acquiring the ID value of the primary key of the new built table according to the name of the new built table.
5. The method of storing relational database tables according to claim 1,
the new table is associated with a target table to be associated, and the method comprises the following steps:
setting related data items in the new build table;
correlating the related data items with primary key ID values of the target table;
the new built table and the target table are mutually related through the related data items and the primary key ID value of the target table.
6. The method of storing relational database tables according to claim 1,
and the step of updating the data of the target table according to the data inserted into the newly-built table comprises the following steps:
judging whether to update the data of the target table according to the related data item of the new table and the ID value of the primary key of the target table;
when the primary key ID value of the corresponding target table is inquired according to the related data item of the newly built table, if the primary key ID value of the corresponding target table is inquired in the target table, the target table is not updated;
and if the primary key ID value of the corresponding target table cannot be inquired in the target table, updating the target table.
7. An apparatus for storing relational database tables, the apparatus comprising:
the system comprises a mapping relation table construction module, a key configuration module and a key configuration module, wherein the mapping relation table construction module is used for constructing a mapping relation table of a relational database, and the mapping relation table is used for storing names of a newly-built table of the relational database and primary key ID values corresponding to the newly-built table;
the data persistence module is used for persisting the data of the mapping relation table into a cache server redis;
a current primary key ID value obtaining module, configured to obtain, according to the data in the mapping relationship table in the cache server redis, a current primary key ID value corresponding to a newly created table of data to be inserted;
the data insertion module is used for inserting data into the new table according to the current primary key ID value;
a new table and target table association module, configured to, when the new table is associated with a target table to be associated, perform data update on the target table according to data inserted in the new table, and store the new table and the target table after update to the cache server redis;
and the data updating module is used for updating the data of the newly built table stored in the cache server redis into the mapping relation table.
8. The storage device of relational database tables according to claim 7,
the data persistence module comprises a data reading module and a data storage module, wherein,
the data reading module is used for reading the mapping relation data of the mapping relation table;
the data storage module is configured to store the read mapping relation data in the cache server redis in a semi-structured form, where an expiration time is not set for the data in the mapping relation table in the cache server redis.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the steps of the method of storing a relational database table according to any one of claims 1 to 6.
10. A computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements a method of storing a relational database table as recited in any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110699154.4A CN113434501A (en) | 2021-06-23 | 2021-06-23 | Storage method and device of relational database table and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110699154.4A CN113434501A (en) | 2021-06-23 | 2021-06-23 | Storage method and device of relational database table and readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113434501A true CN113434501A (en) | 2021-09-24 |
Family
ID=77753622
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110699154.4A Pending CN113434501A (en) | 2021-06-23 | 2021-06-23 | Storage method and device of relational database table and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113434501A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023098593A1 (en) * | 2021-11-30 | 2023-06-08 | 阿里云计算有限公司 | Data processing method and apparatus |
| CN116501715A (en) * | 2023-04-28 | 2023-07-28 | 成都赛力斯科技有限公司 | Real-time association updating method and device for multi-table full data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019213A (en) * | 2017-12-04 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data managing method, device, electronic equipment and storage medium |
| CN110471774A (en) * | 2019-06-28 | 2019-11-19 | 苏宁云计算有限公司 | A kind of data processing method and device based on unified task schedule |
| CN112434015A (en) * | 2020-12-08 | 2021-03-02 | 新华三大数据技术有限公司 | Data storage method and device, electronic equipment and medium |
-
2021
- 2021-06-23 CN CN202110699154.4A patent/CN113434501A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019213A (en) * | 2017-12-04 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data managing method, device, electronic equipment and storage medium |
| CN110471774A (en) * | 2019-06-28 | 2019-11-19 | 苏宁云计算有限公司 | A kind of data processing method and device based on unified task schedule |
| CN112434015A (en) * | 2020-12-08 | 2021-03-02 | 新华三大数据技术有限公司 | Data storage method and device, electronic equipment and medium |
Non-Patent Citations (1)
| Title |
|---|
| 赵良辉等: "《SQL Server数据库轻松务实》", 30 June 2017 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023098593A1 (en) * | 2021-11-30 | 2023-06-08 | 阿里云计算有限公司 | Data processing method and apparatus |
| CN116501715A (en) * | 2023-04-28 | 2023-07-28 | 成都赛力斯科技有限公司 | Real-time association updating method and device for multi-table full data |
| CN116501715B (en) * | 2023-04-28 | 2024-03-12 | 重庆赛力斯凤凰智创科技有限公司 | Real-time association updating method and device for multi-table full data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9721116B2 (en) | Test sandbox in production systems during productive use | |
| US11003625B2 (en) | Method and apparatus for operating on file | |
| CN111767268B (en) | Database table partitioning method and device, electronic equipment and storage medium | |
| WO2019085474A1 (en) | Calculation engine implementing method, electronic device, and storage medium | |
| CN110737682A (en) | cache operation method, device, storage medium and electronic equipment | |
| CN113434501A (en) | Storage method and device of relational database table and readable storage medium | |
| US11500873B2 (en) | Methods and systems for searching directory access groups | |
| CN110851474A (en) | Data query method, database middleware, data query device and storage medium | |
| US20220374406A1 (en) | KV Database Configuration Method, Query Method, Device, and Storage Medium | |
| CN111737564A (en) | Information query method, device, equipment and medium | |
| CN115543198A (en) | Method and device for lake entering of unstructured data, electronic equipment and storage medium | |
| WO2022156588A1 (en) | Data management method, device, and system | |
| CN109614411B (en) | Data storage method, device and storage medium | |
| US10949433B2 (en) | Systems and methods for expedited large file processing | |
| WO2022179122A1 (en) | Big-data-based data storage method and apparatus, and electronic device and storage medium | |
| CN114722437A (en) | Cross-APP unique identifier generation method, device, equipment and storage medium | |
| CN115269523A (en) | File storage and query method based on artificial intelligence and related equipment | |
| CN114003661A (en) | Offline data entry method and device, electronic equipment and storage medium | |
| CN112328656A (en) | Service query method, device, equipment and storage medium based on middle platform architecture | |
| CN112686759A (en) | Account checking monitoring method, device, equipment and medium | |
| CN112988874A (en) | Data processing method, system, computing device and readable storage medium | |
| CN112612789A (en) | Data access method and device, electronic equipment and storage medium | |
| CN110889040B (en) | Method and device for pushing information | |
| CN113868285A (en) | Data reading method and device, electronic equipment and storage medium | |
| CN111444162A (en) | Big data initialization method and device, electronic equipment and storage medium |
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: 20210924 |
|
| RJ01 | Rejection of invention patent application after publication |