insert into on duplicate key_mysql数据库同步解决方案

insert into on duplicate key_mysql数据库同步解决方案1.Couldourdatabasesupportmulti-databaseunderonesingleinstance?2.Couldwesupporttemporarytable?3.Couldwesupportview?4.Couldwesupportstoredprocedureandfunctions?5.CouldeXtr…

大家好,又见面了,我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。

Jetbrains全系列IDE稳定放心使用

1. Could our database support multi-database under one single instance? 2. Could we support temporary table? 3. Could we support view? 4. Could we support stored procedure and functions? 5. Could eXtremeDB be integrated into BI app like Mi

> 1. Could our database support multi-database under one single instance?

>

> 2. Could we support temporary table?

>

> 3. Could we support view?

>

> 4. Could we support stored procedure and functions?

>

> 5. Could eXtremeDB be integrated into BI app like Microstrategy ?

>

> 6. Could we support Architeture like MPP so that all the data could be distributed onto different nodes evenly.

>

> 7. What is the average compression ratio or ratio range typically ? Could we reach the ratio of 10:1

1. Yes, eXtremeDB can open and maintain connections to multiple databases from a single task or process. Each database will require its own “database connection” (the database connection is a way to identify the database to the application)

2. The eXtremeDB databases are normally defined statically with the schema. eXtremeDB does not support temporary tables in the normal SQL meaning of the word (tables that exist within a session). That’s said, there is a limited support for “create table” statement to create in memory tables (or persistent tables. The in-mmeory tables created via the create statement will only exists during the current session, so essentially they are the same as “normal” temporary tables

3. There is a limited support for views (see the eXtremeSQL User’s Guide)

In order to create a view , the application must have the “Views” class defined in the schema:

class Views

{

string name;

string body;

treepk;

};

Only the name of the table and the names of fields are essential. “name” contains the name of the view and the body contains the text of view expression.

View are created in standard SQL manner:

CREATE VIEW name AS select-expression;

XSQL>create view SV as select sid from S; insert into S (sid,sname)

XSQL>values (1,1); select * from SV;

sid

——————————————————————————

1

XSQL>drop view SV;

Things to be aware about

a. Views are implemented as nested select so the query above will be translated to

select * from (select sid from S);

The xsql optimizer is not always smart enough to efficiently transform nested queries. So sometimes query with views will be less efficient than one written manually without views. I can not give you precise example now or give you some estimation how much presence of view can degrade performance of query.

b. The information about created views is stored in Views table. If you want view definition to be persistent , you should define table Views as “persistent”. Certainly it is relevant for disk database only.

c. Views are read-only. Updateable views are not supported. It means it is not possible to do something like:

insert into SV (sid) values (1);

4. Storage procedures are not supported since the eXtremeDB is an embedded database as opposed to a server-type database. SQL Support for functions in SQL is limited to the API — functions are not stored. SQL supports a number of built-in string and math functions as well as user-defined functions that can be used in SQL statements. For example

static String* dateformat( McoSql::Value* date) { char str[64]; int date_val = (int)date->intValue(); int yy = date_val / 10000; int mm = date_val / 100 % 100; int dd = date_val % 100; // Format dd.mm.yyyy assuming all dates are after 2000 eXtremeSQL User Guide version 4.5 page 33

sprintf( str, “%d.%d.20%02d”, dd, mm, yy ); return String::create( str ); } static SqlFunctionDeclaration udf( tpString, // tpInt is the return value of the UDF “dateformat”, // the name of the function as we’ll use it in a query (void*)dateformat, // the function pointer

1 // the number of arguments to the UDF ); The UDF can then be called in a normal SQL select statement. For example, the following statement formats the date values in the result set by calling the UDF:

select dateformat(date_val) from Contributions;

5. There is currently no integration between the eXtremeDB data source and MicroStrategy BI environment. However we are considering the integration of the FE with a number of platforms, including the MicroStrategy Intelligence Server

6. Again, sharding (as a tool within the MPP database architecture) is not currently supported. We are in the process adding sharding and will be happy to consider requirements

7. Compression is supported for the large data data sets (sequences) through RLE. Its not possible to quantify the compression rate as not depends on the data being compressed. By the same token there is no “typical” compression rate.

本文原创发布php中文网,转载请注明出处,感谢您的尊重!

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。

发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/181882.html原文链接:https://javaforall.cn

【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛

【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...

(0)


相关推荐

  • 圆柱体的立方计算公式_圆柱体积公式是什么

    圆柱体的立方计算公式_圆柱体积公式是什么圆柱的体积是六年级下册第三单元的知识点。利用圆柱的体积公式计算圆柱的体积显得尤为重要。让我们一起来复习一下吧!第一个计算圆柱的体积公式新课是怎样引出圆柱的体积的呢?你还记得那个操作不?选自人教版六年级下册数学课本人教版课本25页是将圆柱切割拼凑为近似长方体从而得到我们最常用的体积公式V=Sh例题1:如图,求圆柱的体积给s和h求圆柱的体积V=50.24×10=502.4平方厘米例题2:一个圆柱形蓄水…

  • Jenkins详细教程

    Jenkins详细教程大纲  1.背景  在实际开发中,我们经常要一边开发一边测试,当然这里说的测试并不是程序员对自己代码的单元测试,而是同组程序员将代码提交后,由测试人员测试;  或者前后端分离后,经常会修改接口,然后重新部署;  这些情况都会涉及到频繁的打包部署;  手动打包常规步骤:  1.提交代码  2.问一下同组小伙伴有没有要提交的代码  3.拉取代码并打包(war包,或者jar包)  4.上传到Linux服务器  5.查看当前程序是否在运行  6.关闭当前程序  .

  • 阿里云windows server 安装软件_阿里云windows

    阿里云windows server 安装软件_阿里云windows在阿里云服务器上安装svn与在本地安装是一样的,详细步骤参考楼主之前的帖子http://blog.csdn.net/m0_37027631/article/details/60773156楼主一开始安装完后,访问服务端svn连接失败。原因是因为阿里云服务器中的80、443端口没有开放的原因。如何开放阿里云服务器中的端口请参考http://blog.csdn.net/m0_3702763

    2022年10月10日
  • h3c路由器远程管理_h3c无线路由器怎么设置

    h3c路由器远程管理_h3c无线路由器怎么设置H3C路由器telnet进去以后重启的命令是什么啊?在用户模式下输入,reboot建议在重启之前进行设备配置的保存。避免丢失最近的配置操作。保存设备配置命令为:在用户模式下输入,save输入以上两种命令时,均会自动弹出提示信息,要求管理员确认是否进行重启或保存配置操作,弹出提示信息后输入Y即可。Y代表确认(yes)。H3C路由交换机清除所有配置的命令是?H3C路由交换机清除所有配置的命令是:re…

    2022年10月17日
  • 运行时异常和一般异常_异常代码c0000005

    运行时异常和一般异常_异常代码c0000005说到异常,大家都熟悉,只要程序出错了,那么肯定会说:“哎呀,我的程序出错啦~它抛出异常啦”。但单单以“异常”的名称来称呼它们,未免也太粗糙了。我们毕竟是一个精致的程序员,当然得知道他们到底都有哪些种类啦。这就好比一个优质的男朋友(比如本帅博主)必须能够精准地区分女朋友的口红色号一般。那Java到底有哪些异常呢?其实也不多,Java提供了两种错误的异常类,分别是Error和Excepti…

  • 10个Web设计的SEO规则建议收藏

    规则0:不要试图作*弊来提升SEO效果。当你踏入一个房间;里面汇集了手拿各种博士文凭的科学家,你认为你会聪明过他们吗?当然不会。Google和百度拥有成百上千个这样的房间,里面的工作人员都是高学历的技

    2021年12月20日

发表回复

您的电子邮箱地址不会被公开。

关注全栈程序员社区公众号