DolphinDB 是一个速度极快的时序数据库和数据分析系统,可无限拓展。它具有内置的并行和分布式计算功能,可用于实时数据处理和多节点计算分析。 DolphinDB 支持常用的数据结构,包括向量、矩阵、字典和数据表以及相应的操作和查询。
目录
- 第1章:概述
- 第2章:数据类型和形式
- 第3章:对象
- 第4章:运算符
- 第5章:编程语句
- 第6章:数据操作
- 第7章:函数化编程
- 第8章:SQL 语句
- 第9章:文件 I/O
- 第10章:数据库和分布式计算
- 第11章:系统管理
- 第12章:编程 API
- 第13章:函数和命令
- 第14章:错误代码列表
- 其他
- member(.)
- 表
- 函数和 NULL 值
- iif
- unifiedCall
- viewTraceInfo
- imtUpdateChunkVersionOnDataNode
- take
- rand
- norm
- 按值赋值
- 引用赋值
- 多变量赋值
- 取消变量
- neg(-)
- add(+)
- at([ ])
- sub(-)
- mul(*)
- div(/)
- dot(**)
- ratio()
- mod(%)
- and(&&)
- or(||)
- intersection(set)/bitAnd(&)
- union(set)/bitOr(|)
- symmetricDifference(set)/bitXor(^)
- not(!)
- lt(<)
- le(<=)
- gt(>)
- ge(>=)
- eq(==)
- ne(!=)
- 链式比较
- lshift(<<)
- rshift(>>)
- join(<-)
- pair(:)
- seq(..)
- cast($)
- share
- enableTableShareAndPersistence
- loadPlugin
- run
- 取消变量
- undef
- defined
- seek
- avg
- sum
- log
- add
- sub
- prod
- expr
- eval
- sqlCol
- sqlColAlias
- sql
- partial
- makeCall
- call
- binaryExpr
- unifiedExpr
- makeUnifiedCall
- format
- 数据类型转换
- datehour
- duration
- typestr
- type
- array
- 字符串操作
- 标量
- 数据对
- 向量
- 矩阵
- 集合
- 字典
- 大数组(bigarray)
- 数组向量(array vector)
- pair
- matrix
- setIndexedMatrix!
- indexedSeries
- setIndexedSeries!
- set
- dict
- table
- createPartitionedTable
- indexedTable
- keyedTable
- streamTable
- haStreamTable
- mvccTable
- form
- VOID 初始化
- NULL 初始化
- 检查 NULL 值
- 填充 NULL 值
- NULL 值排序
- NULL 值运算
- isVoid
- isNull
- isValid
- 创建字符串
- 搜索字符串
- regexFind
- regexReplace
- regexCount
- cachedTable
- createTable
- addColumn
- dropTable
- truncate
- 删除数据库和表
- NULL 值标量
- 向量/集合/元组中的 NULL 值
- 表中的 NULL 值
- accumulate (:A)
- aggrTopN
- all
- any
- byRow
- contextby (:X)
- cross (:C)/pcross
- each (:E) / peach
- eachLeft (:L)
- eachPre (:P)
- eachRight (:R)
- eachPost (:O)
- groupby (:G)
- loop / ploop
- moving
- nullCompare
- pivot
- pcall
- reduce (:T)
- rolling
- segmentby
- talib
- tmoving
- twindow
- window
- withNullFill
- files
- file
- close
- writeLine
- readLine
- writeLines
- readLines
- readLines!
- read!
- readObject
- writeObject
- saveTable
- saveText
- append!
- tableInsert
- loadTable
- loadText
- setTraceMode
- getTraces
- database
- stat
- ols
- month
- year
- unpivot
- ffill
- cumsum
- mavg
- equal join
- left join
- full join
- cross join
- asof join
- window join
- prefix join
- inner join
- 数据模型
- 分级存储
- 事务
- 分布式数据库
- 安全关机
- ifirstNot
- ifirstHit
- ifNull
- ifValid
- ilastNot
- ilike
- imax
- imin
- imr
- in
- int
- int128
- integral
- interpolate
- intersection
- invBeta
- invBinomial
- invChiSquare
- inverse
- invExp
- invF
- invGamma
- invLogistic
- invNormal
- invPoisson
- invStudent
- invUniform
- invWeibull
- ipaddr
- isAlNum
- isAlpha
- isChunkNodeInit
- isControllerInitialized
- isDataNodeInitialized
- isDecimal
- isDigit
- isDuplicated
- isIndexedMatrix
- isIndexedSeries
- isLeapYear
- isLoggedIn
- isLower
- isMonotonic
- isMonotonicDecreasing
- isMonotonicIncreasing
- isMonthEnd
- isMonthStart
- isNanInf
- isNothing
- isNumeric
- isort
- isort!
- isortTop
- isPeak
- isQuarterEnd
- isQuarterStart
- isSorted
- isSpace
- isTitle
- isUpper
- isValley
- isYearEnd
- isYearStart
- iterate
- 附录
- 初始化
- 单节点模式
- 集群模式
- 功能配置
- getConfig
- loadMvccTable
- 数据备份与恢复
- 创建数据库和表
- 导入数据
- 插入数据
- 查询数据
- 增加分区
- 增加列
- 连接分布式表
- 删除分区
- 函数视图
- pnodeRun
- ploadText
- xdb
- remoteRun
- rpc
- sqlDS
- transDS!
- cacheDS!
- clearDSCache!
- cacheDSNow
- clearDSCacheNow
- olsEx
- pipeline
- getPersistenceMeta
- clearTablePersistence
- disableTablePersistence
- setStreamTableFilterColumn
- unsubscribeTable
- submitJob
- getJobStatus
- getJobMessage
- getJobReturn
- getRecentJobs
- imtForceGCRedolog
- getClusterChunksStatus
- getChunksMeta
- getPerf
- getClusterPerf
- getJobStat
- scheduleJob
- getScheduledJobs
- deleteScheduledJob
- grant
- deny
- revoke
- subscribeTable
- getUsersByGroupId
- getGroupsByUserId
- 滑动窗口系列(m 系列)
- 时序滑动窗口系列(tm 系列)
- 累计窗口系列(cum 系列)
- 行计算系列(row 系列)
- 流数据引擎
- TA-lib 系列
- TopN 系列
- t3
- tail
- talibNull
- tan
- tanh
- tanimoto
- tema
- temporalAdd
- temporalFormat
- temporalParse
- textChunkDS
- til
- time
- timestamp
- tmavg
- tmbeta
- tmcorr
- tmcount
- tmcovar
- tmfirst
- tmkurtosis
- tmlast
- tmmax
- tmmed
- tmmin
- tmove
- tmpercentile
- tmprod
- tmrank
- tmskew
- tmstd
- tmstdp
- tmsum
- tmsum2
- tmvar
- tmvarp
- tmwavg
- tmwsum
- toCharArray
- today
- toJson
- topRange
- toStdJson
- toUTF8
- transFreq
- transpose
- tril
- trim
- trima
- triu
- trueRange
- tTest
- tupleSum
- rad2deg
- randBeta
- randBinomial
- randChiSquare
- randDiscrete
- randExp
- randF
- randGamma
- randMultivariateNormal
- randNormal
- randLogistic
- randomForestClassifier
- randomForestRegressor
- randPoisson
- randStudent
- randUniform
- randWeibull
- rank
- ratio
- ratios
- rdp
- readBytes
- readRecord!
- rebalanceChunksAmongDataNodes
- rebalanceChunksWithinDataNode
- reciprocal
- refCount
- regroup
- removeHead!
- removeTail!
- rename!
- renameTable
- repartitionDS
- repeat
- replace
- replace!
- replay
- replayDS
- repmat
- resample
- reshape
- residual
- restore
- restoreDB
- restoreDislocatedTablet
- restoreTable
- reverse
- ridge
- right
- rollingPanel
- round
- row
- rowAnd
- rowAt
- rowAvg
- rowBeta
- rowCorr
- rowCount
- rowCovar
- rowDenseRank
- rowDot
- rowEuclidean
- rowKurtosis
- rowImax
- rowImin
- rowMax
- rowMin
- rowNames
- rowNo
- rowOr
- rowProd
- rowRank
- rows
- rowSize
- rowSkew
- rowStd
- rowStdp
- rowSum
- rowSum2
- rowTanimoto
- rowVar
- rowVarp
- rowWavg
- rowWsum
- rowXor
- rpad
- rshift
- rtrim
- evalTimer
- bool
- double
- short
- long
- char
- decimal32
- decimal64
- blob
- string
- symbol
- complex
- point
- uuid
- date
- datetime
- second
- nanotime
- nanotimestamp
- minute
- bigarray
- seq
- arrayVector
- fixedLengthArrayVector
- fromJson
- convertExcelFormula
- fromUTF8
- convertEncode
- cast
- upper
- lower
- ceil
- floor
- deg2rad
- hex
- decimalFormat
- highDouble
- lowDouble
- oneHot
- hashBucket
- md5
- crc32
- concatDateTime
- asfreq
- localtime
- gmtime
- convertTZ
- now
- daysInMonth
- weekday
- businessDay
- hour
- microsecond
- millisecond
- nanosecond
- yearBegin
- yearEnd
- quarterBegin
- quarterEnd
- monthBegin
- monthEnd
- semiMonthBegin
- semiMonthEnd
- weekBegin
- weekEnd
- businessMonthBegin
- businessMonthEnd
- businessQuarterBegin
- businessQuarterEnd
- businessYearBegin
- businessYearEnd
- weekOfMonth
- weekOfYear
- monthOfYear
- hourOfDay
- minuteOfHour
- secondOfMinute
- lastWeekOfMonth
- dayOfMonth
- dayOfWeek
- dayOfYear
- esd
- seasonalEsd
- fy5253
- fy5253Quarter
- stretch
- cut
- pop!
- conditionalFilter
- head
- subarray
- move
- next
- prev
- prevState
- nextState
- join
- join!
- wsum
- sumbars
- deltas
- distinct
- distance
- difference
- valueChanged
- maxPositiveStreak
- percentChange
- flip
- subtuple
- union
- symmetricDifference
- makeKey
- makeOrderedKey
- eye
- det
- diag
- dot
- eig
- cholesky
- flatten
- gram
- covarMatrix
- corrMatrix
- lu
- qr
- schur
- svd
- cell
- cells
- merge
- concatMatrix
- align
- shuffle
- shuffle!
- syncDict
- keys
- values
- dictUpdate!
- charAt
- left
- like
- strpos
- concat
- lpad
- ltrim
- strip
- substr
- substru
- split
- wc
- strlen
- strlenu
- strReplace
- addNode
- addVolumes
- startDataNode
- stopDataNode
- triggerNodeReport
- suspendRecovery
- resumeRecovery
- cancelRecoveryTask
- copyReplicas
- deleteReplicas
- moveReplicas
- startAsyncReplication
- stopAsyncReplication
- toggleAsyncReplicationTaskSkipFlag
- getAsyncReplicationStatus
- getAsyncReplicationTasks
- moveChunksAcrossVolume
- resetDBDirMeta
- backup
- backupDB
- backupTable
- migrate
- loadBackup
- getBackupList
- getBackupMeta
- getBackupStatus
- checkBackup
- existsDatabase
- existsPartition
- existsTable
- dropDatabase
- saveDatabase
- setAtomicLevel
- setOLAPCacheEngineSize
- getOLAPCacheEngineSize
- setTimeoutTick
- setTSDBCacheEngineSize
- getTSDBCacheEngineSize
- setMaxMemSize
- setReservedMemSize
- setMaxBlockSizeForReservedMemory
- setMemLimitOfTaskGroupResult
- getMemLimitOfTaskGroupResult
- setMemLimitOfQueryResult
- getMemLimitOfQueryResult
- setLogLevel
- resetRecoveryWorkerNum
- getRecoveryWorkerNum
- enableActivePartition
- disableActivePartition
- enableTSDBAsyncSorting
- disableTSDBAsyncSorting
- enableQueryMonitor
- disableQueryMonitor
- cols
- columnNames
- createDistributedInMemoryTable
- createIPCInMemoryTable
- dropDistributedInMemoryTable
- dropIPCInMemoryTable
- savePartition
- saveDualPartition
- panel
- unionAll
- setColumnComment
- slice
- sliceByKey
- col
- triggerTSDBCompaction
- flushTSDBCache
- purgeCacheEngine
- flushOLAPCache
- addFunctionView
- dropFunctionView
- addRangePartitions
- addValuePartitions
- dropPartition
- extractTextSchema
- loadNpy
- loadNpz
- loadRecord
- loadDistributedInMemoryTable
- loadIPCInMemoryTable
- loadTableBySQL
- loadTextEx
- push!
- update!
- upsert!
- reorderColumns!
- replaceColumn!
- drop
- dropColumns!
- dropna
- erase!
- keyedStreamTable
- appendMsg
- appendForJoin
- publishTable
- existsSubscriptionTopic
- addMetrics
- dropStreamTable
- removeTopicOffset
- getLeftStream
- getRightStream
- enableTablePersistence
- stopPublishTable
- createTimeSeriesEngine
- createAnomalyDetectionEngine
- createAsofJoinEngine
- createCrossSectionalEngine
- createDailyTimeSeriesEngine
- createEqualJoinEngine
- createLeftSemiJoinEngine
- createReactiveStateEngine
- createDualOwnershipReactiveStateEngine
- createSessionWindowEngine
- createWindowJoinEngine
- createLookupJoinEngine
- streamEngineParser
- dropStreamEngine
- dropAggregator
- registerSnapshotEngine
- unregisterSnapshotEngine
- warmupStreamEngine
- stateMavg
- stateIterate
- conditionalIterate
- getStreamEngine
- getAggregator
- getStreamEngineStat
- getAggregatorStat
- getSnapshotMsgId
- getStreamingStat
- getStreamingLeader
- getStreamingRaftGroups
- getStreamTableFilterColumn
- getSubscriptionTopic
- getTopicProcessedOffset
- multiTableRepartitionDS
- abs
- neg
- signum
- div
- mul
- mod
- square
- pow
- sqrt
- cbrt
- log2
- log10
- log1p
- exp
- exp2
- expm1
- lshift
- derivative
- polynomial
- and
- not
- or
- xor
- bitAnd
- bitOr
- bitXor
- eq
- eqFloat
- eqObj
- ge
- le
- gt
- lt
- ne
- cos
- cosh
- acos
- acosh
- sin
- sinh
- asin
- asinh
- atan
- atanh
- linprog
- qclp
- quadprog
- solve
- med
- var
- varp
- ewmVar
- covar
- ewmCov
- wcovar
- std
- stdp
- ewmStd
- percentile
- percentileRank
- quantile
- quantileSeries
- max
- min
- mean
- ewmMean
- wavg
- corr
- ewmCorr
- acf
- autocorr
- sum2
- sum3
- sum4
- contextSum
- contextSum2
- sem
- mad
- kurtosis
- skew
- beta
- mutualInfo
- spearmanr
- euclidean
- cdfBeta
- cdfBinomial
- cdfChiSquare
- chiSquareTest
- cdfExp
- cdfF
- fTest
- cdfGamma
- cdfKolmogorov
- cdfLogistic
- normal
- cdfNormal
- zTest
- cdfPoisson
- cdfStudent
- cdfUniform
- cdfWeibull
- cdfZipf
- mannWhitneyUTest
- shapiroTest
- ksTest
- winsorize
- winsorize!
- spline
- neville
- dividedDifference
- loess
- copy
- asis
- pack
- unpack
- stl
- anova
- manova
- zigzag
- zscore
- crossStat
- mr
- compress
- decompress
- loadModel
- saveModule
- predict
- adaBoostClassifier
- adaBoostRegressor
- gaussianNB
- multinomialNB
- logisticRegression
- glm
- gmm
- kmeans
- knn
- elasticNet
- lasso
- pca
- wls
- getActiveMaster
- getConnections
- getNodeAlias
- getNodeHost
- getNodePort
- getNodeType
- schema
- getConfigure
- getAllDBs
- getTables
- getTablet
- getTabletsMeta
- getTSDBMetaData
- getDFSDatabases
- getClusterDFSDatabases
- getDFSTablesByDatabase
- getClusterDFSTables
- getChunkPath
- getFunctionViews
- getTSDBCompactionTaskStatus
- getSessionMemoryStat
- getConsoleJobs
- getCompletedQueries
- getRunningQueries
- getQueryStatus
- getTransactionStatus
- getUnresolvedTxn
- getGroupAccess
- getUserAccess
- getUserList
- getCurrentSessionAndUser
- getAuthenticatedUsers
- getRedoLogGCStat
- getDiskIOStat
- getMemoryStat
- getEnv
- getHomeDir
- getOS
- getOSBit
- getRecoveryTaskStatus
- getSystemCpuUsage
- getSystemLoadAvg
- getLevelFileIndexCacheStatus
- mem
- getSupportBundle
- getOLAPCacheEngineStat
- license
- version
- updateLicense
- getLicenseExpiration
- getMachineFingerprint
- resetPwd
- changePwd
- login
- logout
- createGroup
- deleteGroup
- createUser
- deleteUser
- addGroupMember
- deleteGroupMember
- addAccessControl
- submitJobEx
- cancelJob
- cancelConsoleJob
- setMaxJobParallelism
- setMaxJobPriority
- closeSessions
- defs
- member
- objs
- objByName
- syntax
- runScript
- test
- loadModule
- clear!
- clearAllCache
- clearCachedModules
- fflush
- mkdir
- rm
- rmdir
- cleanOutdateLogFiles
- exists
- write
- writeBytes
- writeRecord
- saveTextFile
- saveAsNpy
- writeLog
- shell
- setRandomSeed
- setRetentionPolicy
- moveHotDataToColdVolume
- setSystem
- sleep
- plot
- plotHist
- all
- any
- hasNull
- between
- startsWith
- endsWith
- mask
- objectChecksum
- bfill
- bfill!
- ffill!
- nullFill
- nullFill!
- fill!
- lfill
- lfill!
- sort
- sort!
- sortBy!
- denseRank
- at
- loc
- asof
- mode
- binsrch
- find
- searchK
- firstNot
- lastNot
- firstHit
- atImax
- atImin
- bucket
- groups
- segment
- cutPoints
- bar
- dailyAlignedBar
- size
- count
- nunique
- shape
- coevent
- countNanInf
- bucketCount
- contextCount
- lowRange
- first
- last
- sqlDelete
- sqlUpdate
- parseExpr
- funcByName
- cumavg
- cumbeta
- cumcorr
- cumcount
- cumcovar
- cummax
- cummed
- cummin
- cumpercentile
- cumPositiveStreak
- cumprod
- cumrank
- cumstd
- cumstdp
- cumsum2
- cumsum3
- cumsum4
- cumvar
- cumvarp
- cumwavg
- cumwsum
- cumfirstNot
- cumlastNot
- dynamicGroupCumsum
- dynamicGroupCumcount
- msumTopN
- mavgTopN
- mstdpTopN
- mstdTopN
- mvarTopN
- mvarpTopN
- mcorrTopN
- mbetaTopN
- mcovarTopN
- mwsumTopN
- ma
- ema
- wma
- sma
- dema
- gema
- kama
- wilder
- linearTimeTrend
- mbeta
- mcorr
- mcount
- mcovar
- mfirst
- mimax
- mimin
- mkurtosis
- mlast
- mmad
- mmax
- mmaxPositiveStreak
- mmed
- mmin
- mmse
- mpercentile
- mprod
- mrank
- mskew
- mslr
- mstd
- mstdp
- msum
- msum2
- mvar
- mvarp
- mwavg
- mwsum
- mifirstNot
- milastNot
- movingWindowIndex
- movingTopNIndex
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
{{ commentTitle }}