103 results about "Database optimization" patented technology

Tools and methods for optimizing the selection and placement of wireless radio devices in a wireless network within a geographic region using a remote database that includes a geographic mapping of existing wireless devices within the network and / or adjacent networks, device characteristics for the wireless devices within the network and / or adjacent networks, and radio frequency spectral information across times for a plurality of regions (e.g., corresponding to locations of existing wireless devices). A tool may include a local user interface, a remote database, and a processor that communicates with the user interface and remote database. The methods and tools described herein may receive user input indicating a desired location and / or operational characteristics of new wireless radio device and may determine and suggest an optimal type, location and / or operational parameters for the additional device, or may suggest other modifications to the current network to optimize the network including the new device.

The subject invention relates to systems and methods that automatically create, update, and use statistics over complex objects within a database query processor. A system is provided that facilitates employment of statistics in connection with database optimization. The system includes a component that receives information relating to database performance and an optimization component that automatically identifies, from the information, a minimal set of statistics to employ in a query. A loader dynamically loads and employs the set of statistics during a query optimization process. The optimization component can employ the statistics over computed columns, whereby the columns can be computed from persisted and non-persisted data.

Described herein are optimizations and execution strategies for spreadsheet extensions to SQL. The partitioning of data, as specified in a spreadsheet clause, provides a way to parallelize the computation of spreadsheet and to provide and improve scalability. Even if the partitioning is not explicitly specified in the spreadsheet clause, the database optimizer can automatically infer the partitioning in some cases. Efficient hash based access structures on relations can be used for symbolic array addressing, enabling fast computation of formulas. When rewriting SQL statements, formulas whose results are not referenced in outer blocks can be removed from the spreadsheet clause, thus removing unnecessary computations. The predicates from other query blocks can be moved inside query blocks with spreadsheets clauses, thus considerably reducing the amount of data to be processed. Conditions for validity of this transformation are given.

Techniques for managing data stored within a database, such as a decentralized database are provided. Some techniques involve managing some data within a lower-trust database and some other data within a higher-trust database. A higher-trust database may be a decentralize database including a blockchain. A lower-trust database may store references to data within the blockchain, and optionally other data in association with those references. Disclosed techniques include WHERE clause query handling in databases with reference values, replacement of distinct data in a relational database with a distinct reference to that data, number line storing for secure indexing, APIs for databases, and consensus operations for private blockchain networks.

A system and method for determining an adequate sample size for statistics collection is disclosed. A mechanism for automatically determining an adequate sample size for both statistics and histograms is provided. The sample size determination is accomplished via an iterative approach where the process starts with a small sample, and for each attribute which may need more data, the sample size is increased while restricting the information collected to only those attributes that require the larger sample.

Certain embodiments of the present invention provide a system and method for real-time workflow management in a healthcare environment. The system includes a database, an optimizer engine, and an interface. The database includes resource information for a healthcare environment. The optimizer engine is capable of communicating with the database to extract resource information. The interface is capable of communicating with the optimizer engine and a user. The interface is capable of allocating a resource to manage a workflow based on output from the optimizer engine. In an embodiment, the optimizer engine is capable of making a recommendation based on the resource information. In an embodiment, the interface presents the recommendation to the user, and may present the recommendation based on a rule, for example. In an embodiment, the interface may include a map of resources. The user may direct workflow based in part on the interface and / or the recommendation.

Described herein are optimizations and execution strategies for spreadsheet extensions to SQL. The partitioning of data, as specified in a spreadsheet clause, provides a way to parallelize the computation of spreadsheet and to provide and improve scalability. Even if the partitioning is not explicitly specified in the spreadsheet clause, the database optimizer can automatically infer the partitioning in some cases. Efficient hash based access structures on relations can be used for symbolic array addressing, enabling fast computation of formulas. When rewriting SQL statements, formulas whose results are not referenced in outer blocks can be removed from the spreadsheet clause, thus removing unnecessary computations. The predicates from other query blocks can be moved inside query blocks with spreadsheets clauses, thus considerably reducing the amount of data to be processed. Conditions for validity of this transformation are given.

A legacy-to-container (L2C) system converts a computer program in a procedural programming language to an object oriented programming language. The L2C system parses the procedural language to identify program variables and also program sub-elements, such as paragraphs in COBOL for example. The L2C system provides a user interface that allows the user to select which paragraphs should be converted into methods wherein the remaining non-selected paragraphs are to be converted into classes. The L2C system is configured to re-architect the procedural language by (i) creating normal object classes corresponding to the identified variables, (ii) creating methods for the user-selected paragraphs; and (iii) creating classes for the remaining non-selected paragraphs. The L2C further includes various wizards to further facilitate the re-architecting, such as a UI enrichment wizard, a code elimination wizard, and a database optimizer wizard, as well as a code de-duplication wizard, a microservices wizard, and a parallel processing wizard.

The invention discloses a database optimization method. An index optimizing configuration instruction is received, and data sheet information needing to be monitored and indexed in a database is configured according to the received index optimizing configuration instruction; an index optimizing task is established and monitored, and SQL execution information corresponding the data sheet information is acquired; the collected SQL execution information is analyzed, and an optimal index scheme is obtained through calculation. The invention further discloses a database optimization device.

A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.

The invention discloses a database optimized storage method based on the industrial control field. The method comprises the following steps of: S1, reading return path data, storing the return path data related to the automatic control rate into a real-time return path automatic control rate acquisition table, and storing the return path data related to the stability rate into a real-time return path stability rate acquisition table; taking the return path data with same space attribute as the tree node data, obtaining and storing the real-time automatic control rate and the stability rate of the tree node according to the return path data in the acquisition tables; S2, while reading the next round of return path data, executing the step S1, and simultaneously executing a step S3; and S3, storing a time stamp in a historical return path acquisition table before storing the current return path data; determining a statistic cycle, accumulating the length of the time stamp, storing the return path data in the historical return path acquisition table into each table corresponding to the statistic cycle, and then, obtaining the historical automatic control rate and the stability rate of the tree node. The invention further discloses a corresponding database optimized query method. With the method provided by the invention, the data query efficiency in a local database with a huge data volume can be improved.

The present invention relates to a method and system for using an external program to generate and update statistical information used by a database optimizer for at least one of a database and a database management system, at least one table of data being replicated from the database to the external program, the external program generating statistical information on the replicated data and sending the generated statistical information back to the database for use with the optimizer. The replicated data residing with the external program may also be used by an application for the execution of database queries instead of the database itself with the application using a list of replicated tables or replicated data to determine where to target its queries.

Database optimizing method and system are provided to optimally locate data. Only data satisfying conditions desired by a user is extracted among an access log. Values of a part of the data are translated on the basis of a translation table, and aggregated on the basis of aggregation condition rules. The obtained aggregation result is presented to the user. In addition, data in the database are optimally relocated on the basis of the obtained aggregation result.

The invention provides a method and a device for database optimization. The method includes the following steps: A acquiring original structured query languages (SQLs); B aiming at each acquired SQL, standardizing the original SQLs, obtaining standard SQLs corresponding to the original SQLs, and generating identification of the standard SQLs; and C locating the key SQLs to be optimized according to the identification of each standard SQL. By the adoption of the method, the key SQLs can be located, thereby facilitating database optimization.

The invention provides an AGV (Automated Guided Vehicle) scheduling method. The method comprises the following steps: a control system generates an AGV map and the AGV map is stored; initialization setting is carried out on the AGV; the optimal path between any two sites is calculated; a database is optimized; the AGV is called to execute a task from one site to another site, and the operating time is updated; and a deep learning is carried out through a genetic algorithm. Compared with the prior art, the AGV scheduling method is low in maintenance cost and high in working efficiency.

The invention is applicable for the technical field of a computer, and provides a solid state disk based database optimization method. The solid state disk based database optimization method comprises the steps of: A, obtaining information parameters of a database, wherein the information parameters include a length of a data record in the database; B, recalculating a storage position of the data record based on the size of the Flash page in the solid state disk and the length of the data record in the database, remapping the data record which needs to be stored across the Flash page to the same Flash page, and recording a mapping relationship between the original logic address and the new logic address of the data record; and C, calculating the new logic address of the data record based on the address mapping relationship of the database and sending the new logic address to the solid state disk in the reading-writing process of the data record. The invention also correspondingly provides a database optimization system for realizing the method. Therefore, the solid state disk based database optimization method and system, disclosed by the invention, have the advantages of optimizing the database, improving the database reading-writing access rate and further improving durability of the solid state disk.

The invention provides a database optimization method based on WiMAX local routing. A sharding optimization method based on user IP addresses and database operation frequency improvement is used for transferring user information in a CSN user database to other physical servers through certain rules according to the user IP addresses so as to form a sharding cluster, a database router is arranged in the CSN user database, when the user information is inquired, the IP address of a called user is sent to the database router, the database router is used for inquiring the information of the called user at a corresponding sharding according to the rules, and the database router is used for distributing the user information stored in all the shardings in real time according to an algorithm based on database operation frequency improvement so as to enable all sharding servers to reach load balance. By means of the database optimization method, the query management efficiency of the CSN user database at high concurrent reading can be improved, meanwhile, the operating cost of operator servers can be lowered, and rapid and high-quality communication service can be provided for users.

Techniques for managing data stored within a database, such as a decentralized database are provided. Some techniques involve managing some data within a lower-trust database and some other data within a higher-trust database. A higher-trust database may be a decentralize database including a blockchain. A lower-trust database may store references to data within the blockchain, and optionally other data in association with those references. Disclosed techniques include WHERE clause query handling in databases with reference values, replacement of distinct data in a relational database with a distinct reference to that data, number line storing for secure indexing, APIs for databases, and consensus operations for private blockchain networks.

A database optimizer collects statistics regarding which types of applications are accessing the database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. This means that the database optimizer must recognize when a different type of application requests data from any changed column, and must potentially perform a conversion from the new data type to the old data type before returning the requested data. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and that accesses the column a percentage of time that is less than a second predefined threshold level. In this case, a new column is created in the database so the data is present in both formats, thereby optimizing the performance of both old and new applications that access the data. The database optimizer looks at what type of application requested data, and returns the data in the format optimized for that type of application.

The present invention relates to a method for enhancing the efficiency of digitally communicated data exchanges and to a computer system that implements such a method. The invention particularly concerns the use of adaptive custom compression techniques, binary integers (“bits”), massively parallel processing, database optimization techniques and / or calculation optimization techniques to achieve such enhanced efficiency. The invention is applicable to any digitally communicated data exchange, but is particularly applicable to exchanges of financial information such as financial market buy / sell orders, market making, etc.

The invention discloses a method for improving the processing performance of a database-based service system. The service system comprises a service SQL (structured query language), a service layer cache, a page replacement algorithm and a database; after the service system inquires required service data from the database, a local service layer cache is created to store the required service data, and when the second inquiry is performed, the data is directly read from the service layer cache; the information of the service layer cache is processed by using the page replacement algorithm, and the page replacement algorithm is used for judging the validity of stored data in the service layer cache and clearing invalid data. By using the method disclosed by the invention, the processing performance of the service system can be further improved, and the boundedness, low resource utilization rate and dependence of a traditional method are avoided; the method is implemented by using the existing mature cache technique and the page replacement algorithm, so that the improvement is performed completely from the point of the service system without the limitation to the SQL optimization and dependence on the database optimization, and the resources of a service server are fully used.

This disclosure relates to increasing performance of database queries. A proxy server receives an input query string and a parameter value for first parameter name in the query string. The proxy server determines a second parameter name based on the parameter value and different to the first parameter name. The proxy server then determines an output query string based on the input query string. The output query string comprises a filter clause with a field name and a second field value, the second field value of the output query string being based on the second parameter name. The proxy serverfinally sends the output query string to a database management system to cause the database management system to execute a database query using an execution plan based on the second parameter name inthe output query string.

The invention provides a database optimization method and device, electronic equipment and a computer readable storage medium. The method comprises the steps of obtaining at least one numerical valueset corresponding to a database; wherein the numerical value set comprises numerical values of a plurality of parameters capable of being used for adjusting the performance of the database; iteratingthe numerical value set, sending a load request to a database deploying the numerical value set in each iteration process to obtain a performance index of the database in response to the load request,and updating the numerical value set according to the performance index; when an iteration stopping condition is met, determining an extreme value performance index from a plurality of performance indexes obtained by multiple iterations; and taking the numerical value set corresponding to the extreme value performance index as an optimal numerical value set, and deploying the optimal numerical value set to a database to adjust the performance of the database. By means of the database optimization method and device, the database optimization efficiency can be improved on the basis that the optimization effect is guaranteed, and the performance of the optimized database responding to database operation is improved.

The invention discloses an urban public security event chain formal organization method and an event chain database. The method provided by the invention comprises steps: based on priori expert knowledge and emergency plans of different disasters, establishing an urban public event chain abstract meta-model; determining a relationship between events in the city public event chain abstract meta-model established in the step S011 according to an event association matrix established by domain experts; finally, obtaining an event chain abstract meta-model database; establishing an urban public safety event chain database of a target city according to the event chain abstract meta-model database. According to the method, the decision paths of the events in the urban public safety event chain database of the target city are optimized, secondary, derived and possibly associated subsequent events in the event chain can be quickly determined, and the decision efficiency and the emergency response effect are improved.

The invention discloses a containerization-based relational database optimization method and device, and the method comprises the steps: obtaining a database access request, carrying out the judgmentbased on the database access request, and carrying out database optimization through a database buffer according to a judgment result, and monitoring whether the memory or CPU utilization rate of thedatabase buffer is higher than a preset threshold value or not in real time, recording a log and sending a log notification when the memory or CPU utilization rate is higher than the preset thresholdvalue, receiving the log notification and analyzing the log to judge changed data, and performing transverse / longitudinal expansion on the database buffer according to a preset value in configuration.

The embodiment of the invention provides a database optimization method and device based on a database, and relates to the technical field of database processing, and the method comprises the steps: receiving an analysis log of the database; judging whether the analysis log meets a preset optimization triggering condition or not; when the analysis log meets the optimization triggering condition, obtaining an optimization scheme of the database; and optimizing the database according to the optimization scheme. Visibly, by implementing the implementation mode, database optimization can be performed on the database, so that the use efficiency of the database is improved, and the automation degree of the database is improved.

The invention provides a database optimization method based on vulnerability repair. The method is characterized by comprising: obtaining a first database statement in response to an online post-auditing signal of a database; obtaining an optimization model, and the optimization model is used for outputting corresponding optimization suggestions for database statements input into the optimizationmodel; inputting the first database statement into an optimization model to obtain an optimization suggestion which is output by the optimization model and aims at the first database statement; and generating an optimized database statement and / or an optimized suggestion report according to the optimized suggestion for the first database statement. The invention further provides a database optimization system based on vulnerability restoration, computer equipment and a computer readable storage medium.