Discover oltp database, include the articles, news, trends, analysis and practical advice about oltp database on alibabacloud.com
= CHOOSE 1 265 1060 Index RANGE SCAN dlyx area 1 265 1060 Average execution time (0.062 seconds) From the execution result you can see that the third SQL is the most efficient. The execution path shows that 1th, 2 SQL performs more than one step of table access by INDEX ROWID (Access table via ROWID) because the returned result column includes columns (HBS_BH,XH_BZ) that are not indexed in the currently used index (QC_BH). The 3rd SQL returns the result directly via QC_BH, which is the way
corresponds to a record in the approval form, the record finally approved determines the business status. We can store a mark of the approval status in the business table to cancel the complex query of the associated table that needs to obtain the business approval status through the Associated approval table each time. · Do not perform too many associated table queries. Some table tables that have almost no data changes, such as gender, education, marital status, etc, you can consider download
workload patterns available for DB2: IBM Transaction Database Schema IBM Data mart Model The IBM transaction database schema is used to accommodate departmental online transaction processing (OLTP) applications that do not require a high level of database optimization. This dat
Scenario One: (Don't change too much My.ini file) Copy the database from the original database a ib_logfile1 ib_logfile0 ibdata1; Close the destination database B; Backup destination database b ib_logfile1 ib_logfile0 ibdata1 three files to prevent the database
Index by storage Method classification b* Tree Index b* Tree Index is the most commonly used index, its storage structure similar to the index structure of the book, there are branches and leaves two types of storage data blocks, branch block equivalent to the large directory of books, leaf block equivalent to the specific page index. Both the general index and the unique constraint index use the b* tree index. Bitmap index Bitmap index storage is mainly used to save space, r
database design. Rule 1: Figure out what is the nature of the application that will be developed (OLTP or OPAP)? When you want to start designing a database, you should first analyze what type of application you are designing for, is It "transactional" (transactional) or "analytic" (analytical)? You'll find that many developers adopt a standardized approach to d
database design. Rule 1: Figure out what is the nature of the application that will be developed (OLTP or OPAP)? When you want to start designing a database, you should first analyze what type of application you are designing for, is It "transactional" (transactional) or "analytic" (analytical)? You'll find that many developers adopt a standardized approach to d
/** This feature is mainly demo, while connecting two concurrent databases*/ /* contains C header file * *#include #include #include /* Contains SQLCA header file * *EXEC SQL INCLUDE Sqlca;EXEC SQL INCLUDE Sqlda; int main (){EXEC SQL BEGIN DECLARE section;int money;Char answerbuff[200];int flag;EXEC SQL end DECLARE section; /** Define input Host variables: Receive user name, password, and network service name**/Char username[10],password[10],server[10], conn_var[20];strcpy (username, "data_cente
full-text index consumes space. Like 'a % 'when the index like' % a' is used and like '% A %' is not used for the query, the query time is proportional to the total length of the field value, so the char type cannot be used, but varchar. Create a full-text index for a long field value. 9. Separate DB server and application server; Separate OLTP and OLAP 10. Distributed partition view can be used to implement Da
During the release of the new version of the project, some problems of database rights Management and database upgrade process specification were exposed. After the release of the real version, actually found that some scripts have not been executed, causing users to upgrade after the emergence of some bugs, has a very bad impact. The project team devoted a meeting to discuss this issue, the specific reason
Problem description: After a SQL Server database backup is restored, the word "restricted access" appears after the database nameProblem two description: When restoring to a SQL Server database, Tip: System.Data.SqlClient.SqlError: Because the database is in use, you cannot gain exclusive access to the
indexes. Their storage structure is similar to the index structure of books. There are two types of storage data blocks: branch and leaf. The branch block is equivalent to a large directory of books, A leaf block is equivalent to a specific index page. Generally, both the index and the unique constraint index use the B * tree index.Bitmap IndexBitmap index storage is mainly used to save space and reduce ORACLE access to data blocks. It uses bitmap offset to correspond to the table's row ID, bit
most complex, but also the focus of tuning. At present, the application of database is divided into two types of online transaction processing (oltp,online Transaction processing) and decision support System (Dss,decision Support System), which have different requirements for query. OLTP mainly involves a single table, simple SQL statement, the data is read by i
that will be developed (OLTP or OPAP)?When you want to start designing a database, you should first analyze what type of application you are designing for, is It "transactional" (transactional) or "analytic" (analytical)? You'll find that many developers adopt a standardized approach to designing databases, regardless of the type of target program, so that the program will quickly fall into performance, cu
Java database connection pool configuration methods (take MySQL database as an example), database connection mysqlSeveral configuration methods for Java Database Connection Pool (taking MySQL database as an example) 1. Tomcat configuration data source: Prerequisites: You nee
A server uses php to connect to the database, but the database address uses an external ip address, resulting in occasional access to the database connection handle requires 2 seconds. the Last Post is from u011822059 to 2013-09-0311: 29: 58 Editing example: on the server, php connects to the mysql database on the serv
EXP Export Oracle database table: (as native administrator), refer tohttp://jiqinlin.iteye.com/blog/758469 Export TABLE: Exp username/password @localhost (IP address): Port number/Database instance name file= local address \ Want to generate an indication. DMP owner= (username, Password) eg:exp C # #tjuser/TJUSER@LOCALHOST:1521/ORCL file=c:\adc160624.dmp owner= (C # #tjuser, Tjuser)//tables under the curren
In the LAN, the main store summarizes the branch sales and other information by establishing a backup database for the Branch database in the general store database, and then collecting the required information in the database of the branch to be counted. This tells us that the dat
top priority in database design.Rule 1: Figure out what is the nature of the application that will be developed (OLTP or OPAP)?When you want to start designing a database, you should first analyze what type of application you are designing for, is It "transactional" (transactional) or "analytic" (analytical)? You'll find that many developers adopt a standardized
Most of the important information of the website is kept in the database, the user gets the user information by submitting the Access database. If the database is very fast and helps conserve server resources, in this article, I've collected 10 tips for optimizing database speed. 0. Carefully design the
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
