Tag: Cooperate DB

The same type of database components, besides DBLink, also includes Federated Database and Linked Server. Their configurations are complicated. And for most computations, data needs to be loaded to the local computer, which wastes the computing abilities of the remote database. Calcite is a Java class library that also supports cross-database computations. It is simple to configure and convenient to integrate, and is offered under an open-source license. Yet it is underdeveloped, without support of many functions. Scala, the language intended to compute big data, supplies abilities to perform cross-database computations, too. It is more mature and has rather good

There has been a long-standing debate about the stored procedure’s weaknesses. Now let’s again look at its disadvantages. Non-migratable Being migratable refers to the stored procedure’s ability to move from its native database to another database of different type. Lack of this ability makes stored procedure syntax narrowly applicable and costly un-migratable. Hard to edit and debug A stored procedure is implemented within the database without an invalid IDE environment. This makes the hard to edit and debug problem a long-lasting one. Closed system The stored procedure that runs within the database can only compute data in the database. It

There are more or less differences in terms of function between various types of databases. When we are trying to migrate reports from one database to another, the existing SQL containing a different set of function syntax need to be converted at the same time. Usually, a SQL data set in a report is static and fixed. As an automatic conversion is impossible, we have to modify corresponding SQL statement manually and replace the old with the new. Yet the auto-conversion of SQL in report between databases can be achieved with esProc SPL. SPL designs a set of standard SQL

Databases implement SQL in their own sets of syntax. We need to translate function syntax from one database to another so that functionally equal SQL query statements can be executed in an incompatible system. The ORM technique lets programmers convert queries to SQL of another type of database. This, in effect, is equivalent to having some degree of portability. The technique, however, is only suitable for dealing with simple SQL in OLTP scenarios. It is hard to handle the complicated SQL migration tasks under OLAP scenarios, such as the use of functions that are not supported directly by ORM and

There are mainly two parts of report development: one is report data preparation, processing the original data into the workable result set of reports, which is usually implemented by using SQL, stored procedures, Java, etc. ; the other is report data presentation, presenting the processed data in the form of chart, which is often realized with reporting tools. As the growth of reporting tools, the efficiency of presenting report data with reporting tools has been very high. Reporting tools like RaqReport can be used to quickly implement even the complicated reports, and the average report developers are capable of using them, so