Category:Database

  • Database Index

    Time:2019-8-24

    Database Index Why use index Generally, when the amount of data is small, the data is loaded into memory and scanned in full table. A large amount of data must be indexed (dictionary). What kind of information can be indexed Fields that can limit the record to a certain range of lookups. Primary key, unique […]

  • Unloading of Oracle

    Time:2019-8-24

    Unloading Oracle is not like other software. It can be unloaded with the control panel, Golden Mountain Guard, 360 and so on by clicking the unload button, or even clearing the registry. When you unload Oracle according to the unloading process of other software, you will find the software management areas such as the control […]

  • MongoDB Guide – 8. Specific types of queries

    Time:2019-8-24

    Last article: MongoDB Guide – 7. Find Introduction and Query ConditionsNext article: MongoDB Guide – 9. Cursors and database commands As described in Chapter 2, MongoDB documents can use multiple types of data. Some of them have special performance when querying. 4.3.1 null The null type of behavior is a little strange. It does match itself, […]

  • General KEY for Introduction to Command Grammar

    Time:2019-8-24

    Basic commands select num The default database selection is 16 [0 to 15] databases, and the default database selection is 0 automatically. move key num Move key to num server del key [key …] Delete one or more keys given. exists key Check whether a given key exists. expire key Integer value sets the life […]

  • How to remotely connect Sql Server 2014 Express without sqlserver Management Studio

    Time:2019-8-24

    Because the express version of sqlserver is free and compact, I installed a sqlserver 2014 express, but the express version is only locally connected by default, and my project needs a small partner to connect to my database, so I Google.In fact, I also Baidu.How to make your Sqlserver fail to start successfully by making […]

  • MyBatis Plug-in Use–Paging Plug-in and Performance Interceptor

    Time:2019-8-24

    There’s a lot of information on PageHelper. The author’s documentation is comprehensive. I’m just recording my own configuration and usage here.Required jar packages:jsqlparser-0.9.5.jarandpagehelper-5.0.0.jar XML Configuration Configuration in spring configuration file: Create MyBatis SqlSession Factory and specify data sources <bean id=”sqlSessionFactory” class=”org.mybatis.spring.SqlSessionFactoryBean”> <!– <property name=”configLocation” value=”classpath:mybatis-config.xml” /> –> <property name=”dataSource” ref=”dataSource” /> <property name=”mapperLocations” value=”classpath:com/yupont/gs/dao/mapper/*.xml” ></property> […]

  • PSS Mode of RSA Signature

    Time:2019-8-24

    This article is published by Cloud + Community Author: Mariolu First, what is the PSS model? 1.1. RSA-PSS, one of the two signature schemes A filling mode of PSS (Probability Signature Scheme) private key signature process. At present, the main RSA signatures include RSA-PSS and RSA-PKCS#1 v1.5. The corresponding PKCS (Public Key Cryptography Standards) is […]

  • Record a MySql data splitting

    Time:2019-8-23

    Preface When I went to work in the morning, the query data suddenly found slower, so I went to look at the database, and found that the table data had reached ten million levels, so I was ready to split the table. thinking Because table_one data is very large and online businesses write data to […]

  • PL/SQL Developer Installation and Link to Oracle

    Time:2019-8-23

    1. Introduction to PL/SQL Developer PL/SQL Developer is an integrated development environment, specializing in the development of Oracle database storage program unit. Nowadays, more and more business logic and application logic turn to Oracle Server, so PL/SQL programming has become an important part of the whole development process. PL/SQL Developer focuses on ease of use, […]

  • Redis data type

    Time:2019-8-23

    Introduction to Redis Redis is a very fast non-relational database, which can store mappings between keys and five different types of values. It can persist key-value pairs stored in memory to hard disk, use replication features to expand read performance, and use client fragmentation to expand write performance. FragmentationFragmentation is a method of dividing data […]

  • Summary of XML

    Time:2019-8-23

    XML data is stored in plain text formatAll XML elements must have closed labelsXML tags are case sensitiveAn XML document must have one element that is the parent of all other elements. This element is called the root element.In XML, only characters “<” and “&” are really illegal. Bigger sign is legal, but it’s a […]

  • Understand the way to a neat structure in a single article (with a sketch of knowledge)

    Time:2019-8-23

    With the rapid development of the world of programs, today’s skills may be out of date next year, but there are some things that will last forever and never change. If you master these, you won’t get lost in the ocean of programs. Architectural thinking is such a thing. This paper is a reading note […]