How to use an application database without touching its schema -


if have application uses data of existing database , needs more, , don't want change schema of existing database, how do that?

background of question: use ibm product (connections) store user profiles. have lots of custom requirements (lots of custom fields , logics), create few more tables, views , functions in backend database of connections store custom data. however, ibm's internal database , not supposed touch it, when upgrade connections, our custom tables, views , functions gone.

so decide move out our custom things. problem still need join data connections. (or not database join, other way integrate data before presenting users. )

if create federated table in our own database, can create tables , views used to. have performance issues? , still going heavily depend on ibm's schema , have assume don't change it. approach?

what other options consider?

if create federated table in our own database, can create tables , views used to. have performance issues?

probably. application code have joins between ibm database tables , database tables.

i'm assuming connections uses db2. if bring own db2 database, think can sql joins between 2 separate db2 databases.

either way, code should reside in separate data access package made of data access objects. rest of applications use data access package.

and still going heavily depend on ibm's schema , have assume don't change it.

ibm change schema, , have plan on making corresponding changes database , / or application.

what other options consider?

you copy ibm data database database. still have make changes copy process when ibm schema table definitions change.


Comments

Post a Comment

Popular posts from this blog

How to mention the localhost in android -

i trying call localhost in android application. unfortunately not possible used several methods emulator local host http://10.0.2.2/android/dbconnection.php and network ip address http://192.168.1.xx/android/dbconnection.php also http://localhost:8080/android/dbconnection.php but nothing connected localhost. purpose refer stackoverflow answers not working i facing same problem when worked on localhost. referred stackoverflow answer got solution create new emulator works fine in new emulator.
Read more

php - Calling a template part from a post -

i include iframe within post in wordpress. located inside content of post, meaning cannot in post template file, otherwise either before or after. i'd add facebook plugin within posts: <div id="socialwrap"><div class="fb-like" data-href="http://onlinearizonahomes.info" data-send="true" data-width="450" data-show-faces="true" data-font="arial"></div></div> i thinking of calling template part within post <?php get_template_part( 'social' ); ?> cannot use php within post without plugin (i'd avoid using plugin this). an alternative using javascript create html in post, seems unnecessary use of javascript. what best way add html within wordpress post? you can use shortcode. add functions.php function cudjex_fbshare( $atts, $content = null ) { global $post; $link = get_permalink($post->id); return '<div id="socialwrap...
Read more

c# - String.format() DateTime With Arabic culture -

check below code snippet, namespace testdateconvertion { class program { static void main(string[] args) { datetime testvalue = new datetime(2013, 12, 15, 15, 33, 44); cultureinfo culture = new cultureinfo("ar-sa"); string stringvalue = string.format(culture, "{0:d} {0:hh:mm:ss}", testvalue); console.writeline(stringvalue); console.readline(); } } } it gives output 22/02/35 15:33:44 i not getting how possible. whats 35 doing in output there that's 13/12/2015 in hijri, 35 means 1435 in hijri, default date format saudi arabia.
Read more