Database Administrator

Currently, an MV in the library is used to calculate the hourly traffic volume. The data is as follows:SQL> select * from mv_time_stat;TIME CNT--------------------0 1871 512 343 194 195 206 507 1078 6829 134210 185411 129212 141613 118014 121715 1573

When importing a batch of data to Oracle today, I encountered a problem: Toad prompts me to assign a value to a custom variable AMP. At first I was wondering that data is a series of Insert statements, how can I have custom variables? Then I

When using SQL to insert update a table directly in Oracle today, the error of ORA-01704: string literal too long occurs. Our SQL is UpdateMall_configSetA. category_info ='| Standard Among them, the category_info field is of the clob type, and the

The following are the two problems I encountered when working on the system: . SQL server has duplicate rows of data and cannot be updated or deleted. It is usually a table without a primary key. Error: Check whether the table has a primary key.

Eclipse failed to connect to Oracle Database: ORA-12505, error code: Org. springframework. jdbc. CannotGetJdbcConnectionException: cocould not get JDBC connection; nested exception is java. SQL. SQLException: Listener refused the connection with

Redis Introduction For details about redis installation, refer to here. For more information about redis usage, see here.How to Use the Redis C Client Redis c client Hiredis is widely used. The following describes it. 1. install and configure

Recently, we want to implement a business. We need to query the corresponding data in the Oracle Core database based on the table data in the SQL Server database, and then make statistics in the SQL Server database. therefore, we need to implement

GridFS is a distributed file system on MongoDB. It uses the distributed storage mechanism of MongoDB and uses MongoDB to store file data and file metadata. It has the advantages of both a document-based database and a file system. GridFS is the

Neo4jIt was said thatEmbeddedInPythonInGraph databaseModule, allowing Python to operate local files through graph database APIs to store graph structure data (similar to many libraries that support SQLite ). Today, Neo4j finally fulfilled its

From the author's website data analysis: data-driven website management, optimization and operation: http://item.jd.com/11295690.html The funnel chart is applicable to the Process Analysis with standardized business processes, long cycles, and

The bow whispered to the arrow, "Your freedom is mine ". Schema is like an arrow and bows like Python. Choosing Python is the biggest freedom of Schema. Freedom should be an opportunity to make yourself better.(I) MySQLdb SectionTable

SQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0

DB2 logs are divided into two modes: log loop and archive log, which are non-archive and archive modes. The following describes the two methods and their relationship with backup archiving settings. 1. Log Loop This is the default mode, that is, non-

Chapter 1 Meet HadoopData is large, the transfer speed is not improved much. it's a long time to read all data from one single disk-writing is even more slow. the obvious way to reduce the time is read from multiple disk once.The first problem to

Introduction Fact table The foreign key that stores the measurement value and dimension table. Dimension Table Angle and category. Time, region, and status. Old Method Select * from order oinner join district d on o. discode = d. discodeinner

Transaction Concept A transaction is an atomic SQL query statement and can be considered as a unit of work. If the database engine can successfully apply all query statements to the database, it will execute all queries. If any query statement

When the Rollback Recovery mode is enabled for the DB2 database, the log is changed from the cyclic log mode to the archive log mode, so that the user can restore the database or tablespace after the backup, roll back the transactions in the archive

For new users who are new to SQL databases, there are many questions about SQL versions, but they are too lazy to study them carefully. Although the problem is simple, the impact is not small. Version differences SQL Server 2000 has four editions:

IntroductionEditor's note: in DBA's work, backup has gradually become a hard task that is not often considered. However, any good DBA can tell you that data should be restored when a system failure occurs, at this time, backup will suddenly become

1. Sybase Database Introduction  1. Version In 1984, Mark B. Hiffman and Robert Epstern created Sybase and launched Sybase database products in 1987. SYBASE has three major versions: one is the version running under the UNIX operating system, the