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)


相关推荐

  • Maven安装教程_vmware安装教程

    Maven安装教程_vmware安装教程一、安装apache官网下载需要的版本,然后解压缩,解压路径尽量不要有空格和中文Maven–DownloadApacheMavenhttps://maven.apache.org/download.cgi二、配置环境变量新建系统变量变量名:MAVEN_HOME值:你解压的路径eg:D:\xxx\apache-maven-3.8.4编辑系统变量Path打开->新建->路径为:解压缩文件的路径到bin目录eg:D:\xxx\apac

  • scratch编程小游戏——黄金矿工

    黄金矿工的玩法就是操控一个不断摆来摆去的钩子去挖出黄金,现在我们就来用scratch编一个黄金矿工首先新建好变量:矿车要画出许多的造型:代码:钩爪的绳索是这个游戏最为复制的一点,方法是移动后画出一条线,返回时用背景一样的颜色来覆盖,我们首先来画出造型:红色的是中心位置代码如下:(此代码需要用到一部分自定义,不懂的见文章末尾链接)自定义部分是这个代码的核心:接下来是黄金,造型的话要画出三个:大、中、小各一个代码如下:黄金代码是程序中非常重要的一环,一定不要有差错现

  • WPF 精修篇 Winform 嵌入WPF控件「建议收藏」

    首先创建WPF控件库这样就有了一个WPF界面在wpf中增加界面等在winform中增加WPFDLL重新生成解决方案在左侧工具栏出现WPF控件拖到窗体效果…

  • Intellij IDEA 查找接口实现类的快捷键「建议收藏」

    Intellij IDEA 查找接口实现类的快捷键「建议收藏」查找接口的实现类:IDEA风格ctrl+alt+B在按F2查看详细文档注解查看类或接口的继承关系:ctrl+h1、IDEA_查找接口的实现的快捷键 个人分类管理http://blog.csdn.net/u010003835/article/details/790366662、intellijidea8.1.2中找到实现一个类或者接口子类的快捷键 https://zhidao.ba…

  • clion永久激活码3月最新在线激活

    clion永久激活码3月最新在线激活,https://javaforall.cn/100143.html。详细ieda激活码不妨到全栈程序员必看教程网一起来了解一下吧!

  • 什么是转发和重定向转发_转发和重定向的相同点

    什么是转发和重定向转发_转发和重定向的相同点通过代码和图解详细解释转发和重定向的区别。最后得出结论!

发表回复

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

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