• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to share data to another application

 
Ranch Hand
Posts: 215
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We need to develop an API where we need to share the data to another application from database through API or any other way.Database may have neara bout 5 million rows 1. what would be best way to do this.Read data share to file. 2. Or Instead of having API, can we give database details to them and let them get the data. We can create a View and Let them share the data. So we avoid IO operation.
 
Saloon Keeper
Posts: 7585
176
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You won't be able to avoid the I/O - somehow the data needs to be sent, after all. There are many ways to share data between applications, but to recommend one we would need to know a lot more about the specifics. What kind of process (and user) is reading the data? What kind of process (and user) is sending the data? How often does the data change? How often is the data read? In terms of network architecture, where are the two processes located relative to one another? Etc. etc.
 
Saloon Keeper
Posts: 27762
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This depends on how strong you want the coupling to be between the second application and the database. A direct SQL login is efficient, but it requires the second application to know details about the database schema. Additionally, it may require firewall privileges to get to the database. And it's definitely not recommended for desktop apps - that's basically the root of the infamous Microsoft SQL Server "Slammer" attack.

If you want less coupling and more flexibility, you can provide an API either as a third application or as an addition to the first application. It's more overhead, but it's more likely to be change-sensitive (if properly maintained) and generally it's going to be more secure.
 
Rahul Ba
Ranch Hand
Posts: 215
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi yes, I want to add few more detail

1. yes data will be accessed by daily once
2. Data from one Oracle db table
2. Data will be big
3. How to send data by IO steam, Rest API?
 
reply
    Bookmark Topic Watch Topic
  • New Topic