CN112632078B - Method, system, equipment and readable storage medium for adding field to form - Google Patents

Method, system, equipment and readable storage medium for adding field to form Download PDF

Info

Publication number
CN112632078B
CN112632078B CN202011590952.5A CN202011590952A CN112632078B CN 112632078 B CN112632078 B CN 112632078B CN 202011590952 A CN202011590952 A CN 202011590952A CN 112632078 B CN112632078 B CN 112632078B
Authority
CN
China
Prior art keywords
data
newly added
piece
field
added field
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.)
Active
Application number
CN202011590952.5A
Other languages
Chinese (zh)
Other versions
CN112632078A (en
Inventor
简仁贤
董震
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Emotibot Technologies Ltd
Original Assignee
Emotibot Technologies Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Emotibot Technologies Ltd filed Critical Emotibot Technologies Ltd
Priority to CN202011590952.5A priority Critical patent/CN112632078B/en
Publication of CN112632078A publication Critical patent/CN112632078A/en
Application granted granted Critical
Publication of CN112632078B publication Critical patent/CN112632078B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24564Applying rules; Deductive queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method, a system, equipment and a readable storage medium for adding fields in a form, wherein the method is characterized in that a corresponding added field table A' is newly built aiming at a table A needing to be added with fields; then writing the newly added field information of each piece of data Q in the table A in the newly added field table A'; and finally, when each piece of data Q is called by the database, the newly added field information corresponding to each piece of data Q is simultaneously called. The method and the device have the advantages that the fields can be added smoothly without locking the table, and the user has no obvious effect of perception.

Description

Method, system, equipment and readable storage medium for adding field to form
Technical Field
The invention belongs to the technical field of structured databases, and particularly relates to a method, a system, a device and a readable storage medium for adding fields in a form.
Background
With the development of internet technology, the data volume is rapidly increased, and solutions for storing structured databases are generated, and the database and the table are common;
and (5) library separation: the original relational database is split into a plurality of databases to store data, so that the throughput and the storage capacity are increased.
And (5) sub-table: splitting an original table into a plurality of tables according to a certain rule to finish the scattered storage of data, and determining the rule of the sub-table.
And the data throughput and the storage capacity are greatly increased by library and table division. But also creates technical difficulties. For example, after a database is divided into tables (the tables may generate thousands of sub-tables or more), fields need to be added, so that the thousands of sub-tables are affected by adding fields at the same time, and the services are not available due to the fact that the tables are locked; the data inconsistency problem may occur without adding fields simultaneously on the sub-table.
In general, an idle period with less user access is selected to directly add a field on an original service table; the existing scheme has the problem that if the system is a system with high heat (high concurrency and high throughput) accessed by a user, service intermittence (service temporarily unavailable) can be generated, and the user has the problem of perception and the like.
The newly added fields which are smooth after the database and the table are separated are continuously served, and the user does not perceive the newly added fields as the problems to be solved in the urgent database and table separation.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a strategy for adding fields to the list, which is capable of smoothly adding fields without locking the list and has no perception to users.
The first aspect of the invention discloses a method for adding fields in a form, which comprises the following steps:
newly building a corresponding newly added field table A' aiming at a table A needing to be newly added;
writing newly added field information of each piece of data Q in the table A into the newly added field table A';
and configuring a data calling rule, wherein the data calling rule comprises that when each piece of data Q is called, the newly added field information corresponding to each piece of data Q is called at the same time.
Further, writing the newly added field information of each piece of data Q in the table a in the newly added field table a', including the following steps:
calling the identification ID of each piece of data Q;
and combining the identification ID and the newly added field information into a piece of new data P to be written into the newly added field table A'.
Further, the data retrieval rule includes:
when each piece of data Q is called, acquiring the identification ID of the data Q;
inquiring new data P to be called in a new field table according to the identification ID;
combining the new data P with the data Q to obtain a piece of complete data K;
the complete data K is simultaneously retrieved.
Further, combining the new data P with the data Q comprises the steps of:
deleting information in the data P which is already in the data Q;
and splicing the residual information of the data P on the data Q.
Further, the table A of the field to be added is an order table, a settlement table, a human resource table or a financial statement.
Further, the data Q is text data, image data, voice data, or video data.
Further, the newly added field information includes an identification ID, a field name, a field type, a field value, and a field description.
The invention discloses a system for adding fields in a form in a database, which comprises a form building module, a writing module and a configuration module;
the table building module is used for newly building a corresponding newly added field table A' aiming at the table A needing to be newly added;
the writing module is used for writing the newly added field information of each piece of data Q in the table A into the newly added field table A';
the configuration module is used for configuring data calling rules;
the data calling rule includes that when each piece of data Q is called, newly added field information corresponding to each piece of data Q is called at the same time.
Further, the writing module writes the new field information of each piece of data Q in the table a into the new field table a', and includes the following steps:
calling the identification ID of the data Q;
the identification ID and the newly added field information are combined into a new piece of data P to be written into a newly added field table A'.
Further, the data calling rule configured by the configuration module includes:
when each piece of data Q is called, acquiring the identification ID of the data Q;
inquiring new data P to be called in a new field table according to the identification ID;
combining the new data P with the data Q to obtain a piece of complete data K;
the complete data K is simultaneously retrieved.
Further, the configuration module combines the new data P with the data Q, comprising the steps of:
the information in the data P which is already in the data Q is deleted, and then the rest information of the data P is spliced on the data Q.
The third aspect of the invention discloses an electronic device, which comprises a processor and a memory, wherein the memory is connected with the processor;
the memory is used for storing programs;
the processor invokes a program stored in the memory to perform the method provided by the first aspect or any implementation manner of the first aspect.
A fourth aspect of the invention discloses a computer readable storage medium having stored thereon a computer program which when run by a computer performs the method provided by the first aspect or any implementation of the first aspect.
Compared with the prior art, the invention has the following advantages: the invention realizes the new field addition of the original table by adopting the new field table and adding the record in the new field table, thereby avoiding the suspension service risk caused by directly adding the new field in the original table. Because the field is directly added on the original table, the lock table is required to suspend service, and the granularity of the lock is relatively large. And the record is added on the newly added field table, so that the use of the original table is not affected, the granularity of the lock is small, and the service is not suspended. In addition, the fields are directly added in the original table, because the number of the original table is large, and thousands of sheets are actually arranged in the original table, if the fields are not added at the same time, the phenomenon of inconsistent data is easily caused. The method of the invention can add records to all the newly added field tables at the same time, thereby ensuring the consistency of the data.
The technical scheme of the invention is further described in detail through the drawings and the embodiments.
Drawings
Fig. 1 is a flow chart of the method of embodiment 1 of the present invention.
Fig. 2 is a flow chart of the method of embodiment 2 of the present invention.
Fig. 3 is a block diagram of embodiment 3 of the present invention.
Fig. 4 is a block diagram of embodiment 4 of the present invention.
Detailed Description
Example 1
As shown in fig. 1, a method for adding fields to a form includes the following steps:
step 1, a corresponding newly added field table A' is newly built aiming at a table A needing to be newly added with fields;
specifically, a table A of the required newly added field in the database is obtained, and then a corresponding newly added field table A' is newly built for each table A in the same way as the table A is built;
step 2, writing the newly added field information of each piece of data Q in the table A in each newly added field table A';
specifically, the newly added field information includes a field name, a field type, a field value, and a field description;
when writing the newly added field information of the data Q in the newly added field table A', firstly, calling the identification ID of the data Q; the identification ID and the newly added field information are then combined into a new piece of data P to be written into the newly added field table a'. The identification ID is the identification ID of the data Q corresponding to the newly added field information. I.e. the new data P written in the new added field table a' comprises an identification ID, a field name, a field type, a field value and a field description;
by combining the identification ID and the newly added field information, a link relation between the data Q and the newly added field information can be established, and a foundation is laid for calling the newly added field information at the same time when the data Q is called subsequently.
And 3, configuring a data calling rule, wherein the data calling rule comprises that when each piece of data Q is called, the newly added field information corresponding to each piece of data Q is called at the same time.
The newly added field information of the data Q is simultaneously called, namely corresponding new data P is called in a newly added field table according to the identification ID of the data Q; combining the new data P with the data Q to obtain a piece of complete data K; the complete data K is fetched.
Combining the new data P with the data Q comprises the steps of: deleting information in the data P which is already in the data Q; and splicing the residual information of the data P on the data Q.
The method comprises the steps of configuring a data calling rule, finally realizing the purpose of calling newly added field information along with data Q, deleting information existing in the data Q in the data P when the new data P is combined with the data Q, and splicing the rest information of the data P on the data Q. The data is simplified, and the field is newly added in the final fetched complete data K compared with the data Q.
And the table A of the field to be added is an order table, a settlement table, a human resource table or a financial statement.
The data Q is text data, image data, voice data, or video data.
The newly added field information includes an identification ID, a field name, a field type, a field value, and a field description.
Example 2
In this embodiment, the principle of the present invention will be described by taking as an example a sub-table newly added field in a database storing order data. Assuming that the sub-tables include tables A and B, the fields "card holder" and "card number" need to be added to both tables A and B.
Specifically, the method for adding the field to the form comprises the following steps:
step 1, newly establishing a table A 'in a database, wherein the table A' is an newly added field table of the table A; newly building a table B' in a database; table B' is the newly added field table of Table B;
it should be noted that, the technical means adopted in the new tables a 'and B' are conventional database sub-table methods, and detailed discussion about how to create the sub-tables is omitted here.
Step 2, writing the newly added fields of ' card holder ' and ' card number ' of each data Q in the table A '; writing in table B' the newly added fields "card holder" and "card number" for each data Q in table B;
specifically, when writing the newly added field "card holder" and "card number" of each piece of data Q, the identification ID of the data Q is called, the identification ID and the field name, field type, field value and field description of the newly added field are synthesized into one piece of new data P, and then the new data P is stored in the newly added field table (table a 'or table B'). In this embodiment, the identification ID is an order number, and assuming that one piece of order data in the table a is (1, '2020102713552554124',1001,1,1,35.00, '2020-10-2713:58:07', 'tn_202010271360', 'and then two pieces of data are corresponding to the order in the table a', wherein one piece of data is (1, '2020102713552554124', 'card_wner', 0, 'winning', 'owner of the card') and the other piece of data is (1, '2020102713552554124', 'card_no',1, '6225880150312112', 'card number').
Step 3, the configuration database executes the following steps when receiving a query request:
step 3-1, one or more pieces of data Q in the sub-table are called according to the query request;
step 3-2, for each piece of data Q in step 3-2, calling one or more corresponding pieces of new data P in the newly added field table according to the identification ID of the data Q;
step 3-3, combining one or more pieces of new data P which are called by the step 3-2 with the data Q for each piece of data Q, and obtaining a piece of complete data K after combination; the complete data K is returned to the originator of the query request.
When the data P and the data Q are combined, the information in the data P, which is already in the data Q, is deleted, and then the rest information of the data P is spliced on the data Q. For example, the order data in Table A (1, '2020102713552554124',1001,1,1,35.00, '2020-10-2713:58:07', ' tn_202010271360', ') and the data in Table A ' (1, '2020102713552554124', ' card_wner ',0, ' won's administration ', ' card owner ') is synthesized as (1, '2020102713552554124',1001,1,1,35.00, '2020-10-2713:58:07', ' tn_202010271360', card_wner ',0, ' won's administration ', ' card owner ').
Example 3
As shown in fig. 3, a system for adding fields in a form in a database includes a form creation module 1, a writing module 2, and a configuration module 3.
The table building module 1 is configured to newly build a corresponding newly added field table a' for a table a of fields to be newly added in the database.
Specifically, when the table building module 1 works, firstly, a table a requiring a new field in the database is obtained, and then a corresponding new field table a' is newly built for each table a in the same manner as the table a is built.
The writing module 2 is configured to write the newly added field information of each piece of data Q in the table a into the newly added field table a'.
Specifically, the newly added field information includes a field name, a field type, a field value, and a field description;
when writing the newly added field information of the data Q in the newly added field table A', the writing module 2 firstly calls the identification ID of the data Q; the identification ID and the newly added field information are then combined into a new piece of data P to be written into the newly added field table a'. The identification ID is the identification ID of the data Q corresponding to the newly added field information. I.e. the new data P written in the new added field table a' comprises an identification ID, a field name, a field type, a field value and a field description;
by combining the identification ID and the newly added field information, a link relation between the data Q and the newly added field information can be established, and a foundation is laid for calling the newly added field information at the same time when the data Q is called subsequently.
The configuration module 3 is used for configuring data calling rules; the data calling rule includes that when each piece of data Q is called, newly added field information corresponding to each piece of data Q is called at the same time.
Specifically, the configuration module 3 directly configures a calling rule of the database, and when the original data in the table a is called and each piece of data Q is configured to be called, the newly added field information of the data Q is called simultaneously. The newly added field information of the data Q is simultaneously called, namely corresponding new data P is called in a newly added field table according to the identification ID of the data Q; combining the new data P with the data Q to obtain a piece of complete data K; the complete data K is fetched.
Combining the new data P with the data Q comprises the steps of: deleting information in the data P which is already in the data Q; and splicing the residual information of the data P on the data Q.
The method comprises the steps of configuring a data calling rule, finally realizing the purpose of calling newly added field information along with data Q, deleting information existing in the data Q in the data P when the new data P is combined with the data Q, and splicing the rest information of the data P on the data Q. The data is simplified, and the field is newly added in the final fetched complete data K compared with the data Q.
And the table A of the field to be added is an order table, a settlement table, a human resource table or a financial statement.
The data Q is text data, image data, voice data, or video data.
The newly added field information includes an identification ID, a field name, a field type, a field value, and a field description.
Example 4
A computer-readable storage medium having stored thereon a computer program which, when executed by a computer, performs the method of adding fields to a form as in embodiment 1 or embodiment 2 above.
Example 5
An electronic device may be, but is not limited to, a personal computer (Personal computer, PC), a tablet computer, a mobile internet device (Mobile Internet Device, MID), etc.
Wherein the electronic device 100 may comprise: processor 110, memory 120
It should be noted that the components and structures of the electronic device 100 shown in fig. 4 are exemplary only and not limiting, as the electronic device 100 may have other components and structures as desired.
The processor 110, the memory 120, and other components that may be present in the electronic device 100 are electrically connected to each other, either directly or indirectly, to enable transmission or interaction of data. For example, the processor 110, the memory 120, and possibly other components may be electrically connected to each other by one or more communication buses or signal lines.
The memory 120 is used for storing programs, such as programs corresponding to the method of the form newly added field appearing before or the system for the form newly added field appearing before in the database. Optionally, when the memory 120 stores a system for adding fields in a form in a database, the system for adding fields in a form in a database includes at least one software functional module that may be stored in the memory 120 in the form of software or firmware (firmware).
Optionally, the software functional modules included in the system for forming the newly added fields in the database may also be cured in an Operating System (OS) of the electronic device 100.
The processor 110 is configured to execute executable modules stored in the memory 120, such as software functional modules or computer programs included in the system for representing newly added fields in a database. When the processor 110 receives the execution instructions, it may execute a computer program, for example, to perform: newly building a corresponding newly added field table A' aiming at a table A needing to be newly added; writing the newly added field information of each piece of data Q in the table A into the newly added field table A'; when the configuration database calls each piece of data Q, the newly added fields of the data Q are simultaneously called.
Of course, the methods disclosed in any of the embodiments of the present application may be applied to the processor 110 or implemented by the processor 110.
It should be noted that, in the present specification, each embodiment is described in a progressive manner, and each embodiment is mainly described as different from other embodiments, and identical and similar parts between the embodiments are all enough to be referred to each other.
In the several embodiments provided in this application, it should be understood that the disclosed systems and methods may be implemented in other ways as well. The system embodiments described above are merely illustrative, for example, of the flowcharts and block diagrams in the figures that illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, the functional modules in the embodiments of the present application may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a notebook computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily think about changes or substitutions within the technical scope of the present application, and the changes and substitutions are intended to be covered by the scope of the present application.

Claims (8)

1. A method for adding fields to a form, comprising the steps of:
newly building a corresponding newly added field table A' aiming at a table A needing to be newly added;
writing newly added field information of each piece of data Q in the table A into the newly added field table A';
configuring a data calling rule, wherein the data calling rule comprises that when each piece of data Q is called, newly added field information corresponding to each piece of data Q is called at the same time;
writing the newly added field information of each piece of data Q in the table A in the newly added field table A', wherein the method comprises the following steps of:
calling the identification ID of each piece of data Q;
combining the identification ID and the newly added field information into a piece of new data P to be written into the newly added field table A';
the data retrieval rule includes:
when each piece of data Q is called, acquiring the identification ID of the data Q;
inquiring new data P to be called in a new field table according to the identification ID;
combining the new data P with the data Q to obtain a piece of complete data K;
the complete data K is simultaneously retrieved.
2. The method of a form add-on field of claim 1, wherein combining the new data P with the data Q comprises the steps of:
deleting information in the data P which is already in the data Q;
and splicing the residual information of the data P on the data Q.
3. The method for adding fields to forms according to claim 1 or 2, wherein the form a requiring the new fields is an order form, a settlement form, a human resource form or a financial form.
4. The method of adding a field to a form according to claim 1 or 2, wherein the data Q is text data, image data, voice data or video data.
5. The method of adding fields to a form according to claim 1 or 2, wherein the added field information includes an identification ID, a field name, a field type, a field value, and a field description.
6. A system for adding fields in a form in a database, comprising a form creation module, a writing module and a configuration module;
the table building module is used for newly building a corresponding newly added field table A' aiming at the table A needing to be newly added;
the writing module is used for writing the newly added field information of each piece of data Q in the table A into the newly added field table A';
the configuration module is used for configuring data calling rules;
the data calling rule comprises that when each piece of data Q is called, newly added field information corresponding to each piece of data Q is called at the same time;
writing the newly added field information of each piece of data Q in the table A in the newly added field table A', wherein the method comprises the following steps of:
calling the identification ID of each piece of data Q;
combining the identification ID and the newly added field information into a piece of new data P to be written into the newly added field table A';
the data retrieval rule includes:
when each piece of data Q is called, acquiring the identification ID of the data Q;
inquiring new data P to be called in a new field table according to the identification ID;
combining the new data P with the data Q to obtain a piece of complete data K;
the complete data K is simultaneously retrieved.
7. An electronic device comprising a processor and a memory, the memory being coupled to the processor;
the memory is used for storing programs;
the processor invokes a program stored in the memory to perform the method of any one of claims 1-5.
8. A computer-readable storage medium, on which a computer program is stored, which computer program, when run by a computer, performs the method according to any one of claims 1-5.
CN202011590952.5A 2020-12-29 2020-12-29 Method, system, equipment and readable storage medium for adding field to form Active CN112632078B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011590952.5A CN112632078B (en) 2020-12-29 2020-12-29 Method, system, equipment and readable storage medium for adding field to form

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011590952.5A CN112632078B (en) 2020-12-29 2020-12-29 Method, system, equipment and readable storage medium for adding field to form

Publications (2)

Publication Number Publication Date
CN112632078A CN112632078A (en) 2021-04-09
CN112632078B true CN112632078B (en) 2023-06-30

Family

ID=75286222

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011590952.5A Active CN112632078B (en) 2020-12-29 2020-12-29 Method, system, equipment and readable storage medium for adding field to form

Country Status (1)

Country Link
CN (1) CN112632078B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1527226A (en) * 2003-02-13 2004-09-08 Chaining of file element with corresponding field, inquiry and/or process in data base
CN102609492A (en) * 2012-01-21 2012-07-25 东华大学 Metadata management method supporting variable table modes
CN104063409A (en) * 2013-04-11 2014-09-24 腾讯科技(深圳)有限公司 Field adding method and system of database
CN109710613A (en) * 2018-12-26 2019-05-03 深圳乐信软件技术有限公司 Management method, device, server and the storage medium of field
CN109814856A (en) * 2019-01-17 2019-05-28 平安科技(深圳)有限公司 Data entry method, device, terminal and computer readable storage medium
CN109885581A (en) * 2019-03-14 2019-06-14 苏州达家迎信息技术有限公司 Synchronous method, device, equipment and the storage medium of database

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040205530A1 (en) * 2001-06-28 2004-10-14 Borg Michael J. System and method to automatically complete electronic forms
US20030154197A1 (en) * 2002-02-13 2003-08-14 Permutta Technologies Flexible relational data storage method and apparatus
US9165048B2 (en) * 2012-05-16 2015-10-20 Sap Se Linked field table for databases
US20140201192A1 (en) * 2013-01-15 2014-07-17 Syscom Computer Engineering Co. Automatic data index establishment method
US10346376B2 (en) * 2016-11-02 2019-07-09 Mastercard International Incorporated Systems and methods for database management

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1527226A (en) * 2003-02-13 2004-09-08 Chaining of file element with corresponding field, inquiry and/or process in data base
CN102609492A (en) * 2012-01-21 2012-07-25 东华大学 Metadata management method supporting variable table modes
CN104063409A (en) * 2013-04-11 2014-09-24 腾讯科技(深圳)有限公司 Field adding method and system of database
CN109710613A (en) * 2018-12-26 2019-05-03 深圳乐信软件技术有限公司 Management method, device, server and the storage medium of field
CN109814856A (en) * 2019-01-17 2019-05-28 平安科技(深圳)有限公司 Data entry method, device, terminal and computer readable storage medium
CN109885581A (en) * 2019-03-14 2019-06-14 苏州达家迎信息技术有限公司 Synchronous method, device, equipment and the storage medium of database

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
--: an argument for SQL injection coverage in database textbooks.《ACM Inroads》.2019, *
Cynthia Taylor等.BEST PAPER AT SIGCSE 2019 IN THE CURRICULUM INITIATIVES TRACK: ")DROP TABLE textbooks *
基于字段嵌入的数据库自然语言查询接口;田野等;《计算机科学》;20200930(第09期);第60-66页 *

Also Published As

Publication number Publication date
CN112632078A (en) 2021-04-09

Similar Documents

Publication Publication Date Title
CN110032604B (en) Data storage device, translation device and database access method
EP3477914B1 (en) Data recovery method and device, and cloud storage system
US9477727B2 (en) Abstracting data for use by a mobile device having occasional connectivity
CN111414403B (en) Data access method and device and data storage method and device
CN109408523B (en) Data sharing method and device, data sharing platform and electronic equipment
US20160299930A1 (en) Metadata driven reporting and editing of databases
CN109885585B (en) Distributed database system and method supporting stored procedures, triggers and views
CN114756627B (en) Alliance-chain-based digital asset processing method, system and storage medium
CN111651424B (en) Data processing method, device, data node and storage medium
CN109299225A (en) Log searching method, system, terminal and computer readable storage medium
CN111753141B (en) Data management method and related equipment
US20150178122A1 (en) Method and system for providing a high-availability application
CN109614411B (en) Data storage method, device and storage medium
US20220300503A1 (en) Querying distributed databases
CN110019527B (en) Slave library reading method, related device and equipment
CN115687503A (en) Method, device and equipment for synchronizing data among databases and storage medium
CN112632078B (en) Method, system, equipment and readable storage medium for adding field to form
CN108256019A (en) Database key generation method, device, equipment and its storage medium
CN116701413A (en) Main data processing method and device
CN116775712A (en) Method, device, electronic equipment, distributed system and storage medium for inquiring linked list
CN107463618B (en) Index creating method and device
CN113448939A (en) Data archiving and storing method and device and storage medium
CN114416884B (en) Method and device for connecting partition table
CN115510072A (en) Main data engine based on multi-tenant SaaS application platform
JP2006146615A (en) Object-related information management program, management method and management apparatus

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
GR01 Patent grant
GR01 Patent grant