23 results about "Tablespace" patented technology

The invention provides an SaaS tenant customized service method, and relates to the technical field of software as a service system architecture.The method comprises the steps that an independent database or table space is generated through a tenant identifier, configuration parameters are converted into JSON metadata in combination with a graphical tool and stored, and lightweight customization is achieved; according to the deep customization request, an independent server or container instance is distributed for a tenant, personalized codes are deployed, and the personalized codes and standard codes are separated for running through a dynamic loading mechanism; generating a unique second-level domain name based on the tenant identifier, and routing the request to a corresponding service node through DNS analysis and reverse proxy; and the standard tenants are supported to migrate to the customized tenants, configuration and service data are synchronized to a target instance, domain name resolution and proxy configuration are updated, and seamless switching of service paths is realized.

The invention relates to a database fault recovery method and device, a storage medium and electronic equipment. The method comprises the steps that when a database normally runs, a WAL log is written into a disk, and meanwhile, a log record is pre-analyzed through a background asynchronous thread to extract core semantic information of the log record; constructing a cache structure sorted according to table space identifiers and data page numbers in the shared memory, and storing the core semantic information in the cache structure in a recovery-oriented compact format; when the check point is executed, the memory dirty page is flashed to a disk, and the cache initial position corresponding to the check point in the cache structure serves as metadata to be written into a control file; and after the database crashes and is restarted, acquiring a cache initial position from the control file, loading all core semantic information entries behind the cache initial position in the cache structure according to the cache initial position, positioning a target data page, and modifying the target data page. The technical problem that an existing database collapse recovery technology is low in recovery speed is solved.

The application is suitable for the technical field of artificial intelligence security, and provides a jailbreaking security evaluation method and system based on dictionary guided sparse logic editing, which comprises the following steps: first, generating a static intensity vector; then, intercepting an original logit vector corresponding to each autoregressive decoding time step of a target large language model, and generating a dynamic gating signal based on the original logit vector; meanwhile, constructing a preliminary sparse intervention vector from the static intensity vector; and then, generating a modified adversarial logit vector based on the preliminary sparse intervention vector, so as to obtain response content for evaluating security. Through the application of extremely sparse local logic editing based on temperature scaling and trust region constraints in the vocabulary space, the high computing power overhead of traditional gradient attacks and the auxiliary model memory overhead of traditional logic intervention methods can be completely eliminated, and efficient, smooth, interpretable and robust large model jailbreaking security evaluation can be realized.

Methods and apparatuses for creating a tablespace, storage media, and electronic devices are disclosed. The method includes: receiving a tablespace creation instruction; determining, in a distributed database based on an identifier of a server carried in the creation instruction, the server corresponding to the identifier as a specified server; based on a capacity for creating a tablespace carried in the creation instruction and a remaining storage space of the specified server, determining a storage space whose total capacity is the capacity; creating a virtual file based on the determined storage space; and creating a tablespace including the virtual file.

The application relates to the technical field of data processing, and discloses a SQL-based column segmentation method, device, equipment and storage medium, which comprises the following steps: obtaining a to-be-divided string, and sorting different text data in the to-be-divided string; saving the sorted string to a first temporary table space of a database, obtaining the number of substrings of the text data of the sorted string in the first temporary table space; dividing the text data according to the number of substrings to obtain divided text data; performing a column-to-row operation on the multiple substrings in the divided text data respectively, so that each column comprises one substring; saving the substrings and the corresponding number of times of the substrings to a second temporary table space of the database, sorting the substrings according to the corresponding number of times of the substrings to obtain a segmentation result. The application can be applied to the data processing of financial technology and medical health, can avoid increasing the complexity of a database management system, and can reduce the configuration and maintenance cost of the database.

The present application relates to the technical field of network chip, and particularly relates to a flow table aging method, device, equipment and program product, the method comprises: obtaining a target flow table to be managed, and representing the activation state of each table entry in the target flow table by a binary bitmap configured by hardware logic; timing polling the binary bitmap to identify and delete the inactivated table entry in the target flow table; when there is a new table entry in the target flow table, according to the table entry occupation of the hash bucket corresponding to the new table entry and the value of the overlay permission control bit carried by the new table entry, it is decided whether to overlay the inactivated table entry with the same hash address as the new table entry in the target flow table. The present application improves the flow table space utilization, and can effectively cope with the table entry management demand under the high-speed network environment.

Tables are selected based on timestamp columns to obtain tables changed during a given time period and the selected tables are split into data blocks based on given partition ranges. Changes to data of the data blocks are incrementally copied into datasets. One or more tablespaces identified using a first structured query language query corresponding to a specified timestamp are unloaded based on output of the incrementally copying changes operation. Data of a source site and a target site are compared based on data blocks having the specified timestamp.

The present application relates to a decryption method and apparatus for a data page, a computer device, a readable storage medium, and a program product. The method comprises: upon receiving an access request for accessing an encrypted target table, acquiring a master key, and a target value and a secondary key in a tablespace file corresponding to the target table, wherein the tablespace file comprises different data pages (202); acquiring a page identifier of a target data page among the data pages (204); on the basis of the page identifier and the target value, determining a target mode from among at least two candidate modes (206); and when the secondary key is decrypted using the master key so as to obtain a plaintext secondary key, decrypting the target data page on the basis of the target mode and the plaintext secondary key so as to obtain data corresponding to the target table (208).

The application discloses a table space moving method, device and equipment and a storage medium. The method comprises the following steps: obtaining a table space moving statement input by a user, wherein the table space moving statement is a database statement for moving a target table to a target table space; constructing an intermediate table according to the target table in the target table space, wherein the intermediate table has the same definition as a dependent object of the target table, and the intermediate table has the same structure as the target table; performing data dictionary exchange on the target table and the intermediate table; and migrating data in the intermediate table after the data dictionary exchange to the target table after the data dictionary exchange. Through the technical scheme, the efficiency of table space moving can be improved, and the complexity of table space moving can be reduced.

The invention relates to the technical field of multi-tenant system architecture, and discloses a multi-tenant resource isolation system and method. Comprising a meta-model driving layer which comprises a plurality of meta-models and a meta-model dynamic analysis engine, and the meta-model dynamic analysis engine is used for generating an SQL table structure and a business logic code according to a target meta-model selected by a tenant; the tenant configuration layer is used for a tenant to configure fields and processes of the target meta-model in the visual sandbox environment, and performing conflict detection and simulation running test when configuration of the target meta-model is updated; the resource isolation layer is used for distributing an independent container and an independent database for each tenant and carrying out dynamic quota management on CPU and memory resources of the containers; and the data storage layer creates an independent table space in the database of each tenant, and rewrites the initial query request based on the tenant ID in combination with the SQL routing middleware. According to the method and the device, data leakage and interference among the tenants can be prevented, and accurate data access in a multi-tenant environment is realized.

The application provides a table space storage capacity estimation method, device, equipment and medium. The method comprises the following steps: creating a temporary table in a target database according to the table structure of a source database table where to-be-loaded data is located, and loading sample data from the source database table to the temporary table; calculating the table space storage capacity occupied by the sample data in the temporary table, and calculating the number of the sample data; determining the attribute value of the sample data as the attribute value of the to-be-loaded data according to the table space storage capacity occupied by the sample data in the temporary table and the number of the sample data; estimating the number of the to-be-loaded data according to the sample data, and obtaining an estimated value of the number of the to-be-loaded data; and calculating an estimated value of the table space storage capacity occupied by the to-be-loaded data in the source database table according to the attribute value of the to-be-loaded data and the estimated value of the number of the to-be-loaded data. Therefore, the application can calculate the estimated value of the table space storage capacity occupied by the to-be-loaded data in the source database table.

The invention provides a database fault detection method, device and equipment, a medium and a program product, and relates to the technical field of databases. The method comprises the following steps: under the condition that data is to be written into a target database, determining a table space in which the data is to be written in the target database, and obtaining operation parameters of the target database; the operation parameter comprises the residual capacity of the meter space; and determining whether the target database has a no-response fault risk or not based on the residual capacity. According to the method, risk prompting can be carried out before the non-response fault occurs, namely, the timeliness of non-response fault detection of the database is improved, delay or hysteresis does not exist when risk prompting is carried out in advance, it is ensured that the influence of the non-response fault of the database on a data writing task can be improved in time, and the reliability of data writing is improved. The non-response fault of the database is detected in time, so that the normal operation of the database is effectively maintained.

This application provides a method, system, and device for automatic tablespace reclamation in a PostgreSQL database, belonging to the field of database technology. The method includes: obtaining business attribute tags of a target data table and determining a first reclamation trigger threshold based on the business attribute tags; real-time collection of dynamic indicators of the target data table; wherein the dynamic indicators include at least the frequency of insert operations and the frequency of update operations per unit time; determining the space reuse probability value of dead tuples in the target data table based on the dynamic indicators; dynamically adjusting the first reclamation trigger threshold based on a preset piecewise linear adjustment function and the space reuse probability value to determine a corresponding second reclamation trigger threshold; when the space fragmentation rate of the target data table is greater than the second reclamation trigger threshold, matching the corresponding reclamation operation according to the relationship between the space reuse probability value and a preset diversion threshold; wherein the preset diversion threshold is used to distinguish different reclamation operations.

The present disclosure provides a database storage space optimization method, which can be applied to the fields of finance and computer technology. The database storage space optimization method comprises: obtaining storage information of table spaces in a database, wherein the storage information comprises fragmentation space information of the table spaces; determining a first fragmentation rate of the database according to the fragmentation space information of each table space; generating a database sequence in the order of the size of the first fragmentation rate of each database among N databases, wherein N is greater than or equal to 1; determining M target databases from the N databases according to the database sequence, wherein N is greater than or equal to M and M is greater than or equal to 1; and performing space optimization processing on each target database to generate a space optimization report. The present disclosure also provides a database storage space optimization device, equipment, storage medium and program product.

The application discloses a kind of distributed database temporary table space full chaos test method and system, belong to computer software test technical field, the method includes the following steps: determine target database and temporary table space;Perform preset consumption script, through cyclic insertion data and interval execution cartesian product etc. Complex query, simulate temporary table space consumption to full load;Real-time monitoring table space usage and generating alarm;According to alarm execution gradient recovery strategy, first attempt to automatically expand space, if invalid, then terminate the session that occupies most space.The application also provides a system for implementing the method.The application fills the chaos test blank for the scenario of database internal temporary table space resource depletion, realizes the precise controllable and monitoring recovery of fault simulation Automatic closed loop, can significantly improve the efficiency and safety of database resilience testing, shorten the test period from several hours to minutes.

This invention discloses a method for detecting and mitigating slow flow table overflow attacks based on a two-level threshold, belonging to the field of network security. The method includes: deploying on an SDN switch to monitor the flow table occupancy rate in real time; when the flow table occupancy rate reaches the first-level threshold, sampling the flow table and calculating its characteristics, then initiating attack detection. If a slow flow table overflow attack is detected, the malicious flow expulsion mode of the attack mitigation module is entered, and flow rules classified as malicious are expelled; when the flow table occupancy rate reaches the second-level threshold, the flow table overflow prevention mode of the mitigation module is entered, and suspected malicious flow rules are expelled proportionally to free up flow table space and prevent overflow. This method can monitor the flow table status of the switch in real time, accurately detect slow flow table overflow attacks, has a low false negative rate and low false positive rate, and can accurately identify and expel malicious flow rules. Therefore, this method can effectively detect and mitigate slow flow table overflow attacks in SDN environments.

Tables are selected based on timestamp columns to obtain tables changed during a given time period and the selected tables are split into data blocks based on given partition ranges. Changes to data of the data blocks are incrementally copied into datasets. One or more tablespaces identified using a first structured query language query corresponding to a specified timestamp are unloaded based on output of the incrementally copying changes operation. Data of a source site and a target site are compared based on data blocks having the specified timestamp.

The present application relates to a kind of based on openGauss Data Studio implementation database physical modeling method and device.The present application includes preparing development environment and dependence, configure the menu and operation panel of physical modeling, realize front-end physical modeling based on H5 and Antv X6, UI is fused to openGauss Data Studio to the front-end modeling content is transmitted to back-end JDBC and is executed.The present application can be based on the development environment of database, realize the design of visual physical modeling, can directly show the physical storage structure of database during design process, including table space, table, constraint and various objects and its relationship, and one-key type is completed the execution of modeling DDL, it is saved in different tools back and forth switching and facing complex modeling syntax, greatly simplify the modeling process, improve the development efficiency of research and development team, reduce human cost.

The application provides a database storage object processing method, a storage medium and a computer device. The method comprises the following steps: obtaining a storage object reference information table from a system table of a database, wherein the storage object reference information table is used for recording reference data of a set type storage object; obtaining an update event of the storage object reference information table; judging whether the updated reference data meets a deletion condition; and if yes, deleting a database storage object corresponding to the updated reference data. Through the method, the database storage object without a reference relationship can be deleted in time without affecting the execution of a database operation statement, the problem of transient table space expansion is avoided, and the performance of the database is improved.

The application discloses a space sub-table method based on a space dynamic grid, which comprises the following steps: S1, creating a storage structure of a sub-table result; S2, determining an initial level and an initial grid set according to a data space range and a sub-table record number upper limit; and S3, performing a data transfer / storage / continuing sub-table operation in the sub-table space range. The application adopts a dynamic grid based on a map pyramid model and the record number contained in the grid to comprehensively determine the sub-table range, and stores the records across multiple sub-tables uniformly through a sub-table total table, so as to balance the sub-table capacity and guarantee the geometric integrity of the vector data.

This invention discloses a database construction method, apparatus, device, and medium, relating to the field of database management technology. In response to a database configuration operation in the database configuration interface, target configuration information is obtained; in response to a data model selection operation in the data model interface, a target data model is determined; the target project size is obtained, and a pre-created project tablespace is established based on the target project size and the target data model; in response to a performance configuration operation in the performance configuration interface, target performance configuration information for the target database is obtained; and the target database is constructed based on the pre-created project tablespace, the target performance configuration information, and the target configuration information. This technical solution ensures rapid database construction to meet the high requirements of data management and system performance in the seismic exploration field.

The application provides a table capacity adjustment method and device, a storage medium and an electronic device, and the method comprises the following steps: obtaining target capacity data of a database application table collected in a preset period; the target capacity data comprises a data volume peak value and a table space size; calculating a space usage rate peak value of the database application table in the period according to the data volume peak value and the table space size; predicting a space usage rate peak value of a future period according to the space usage rate peak value of the period; in the case that the space usage rate peak value of the future period meets an adjustment condition, outputting a capacity adjustment prompt information of the database application table, the capacity adjustment prompt information is used for prompting a user to perform capacity adjustment on the database application table; receiving a capacity adjustment instruction triggered by the user in response to the capacity adjustment prompt information; and performing capacity adjustment on the database application table based on a capacity adjustment parameter in the capacity adjustment instruction. The capacity of the database application table can be dynamically adjusted.