• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Metadata repository or DB

 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear all,

I need your help about the java application design:

I have a new java enterprise application project to implement a "Save and Retrieve" business function. It is to support other applications in my company to save their data and then retrieve in their data in different ordering and sorting. Those data is formated in a list of records and then can be displayed in their web applications.

For example,

Case 1. An application A1 sends a xml message to us on every 5 mins (using our Save function). The message body contains 5 fields (e.g. F1, F2, F3, F4 and F5). On the other hand, a user wants to select the fields F1, F2 and F3 within current day from our application (Retrieve functio). These fields are sorted by F4 in descending order.

Case 2. An application A2 sends a xml message to us on every 10 mins (using our Save function). The message body contains 6 fields (e.g. F10, F11, F12, F13, F14 and F15). On the other hand, a user wants to select the fields F14, F15 and F12 within this course from our application (Retrieve functio). Those fields are sorted by F10 in ascending order.

Case 3 ...
:
:

Case N ...


In order to support N applications, should I use a metadata repository store the data (since come from different applications) or store it in database?

Could you help and give me some hints?

Thanks a lot.
Ricky
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
A "metadata repository" is a database, isn't it?
 
ricky wong
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Paul,

The metadata repository is stored in file system or other non-database system which can allow to save / retrieve data in different ordering and sorting...


Thanks.
Ricky
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That doesn't sound like much of a difference from a database. Am I missing something?
 
ricky wong
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Paul,

Thanks for your reply.

Yes, its function is similar to database. But the difficulty is if we implement this design in database, how to support N (unknown) fields with different sorting and filtering in a table. It is not possible to create different tables to support different applications respectively (due to limited resources). So I am looking for any java based architecture or solution to support our requirements.

Thanks.
Ricky
 
Ranch Hand
Posts: 262
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


It is not possible to create different tables to support different applications respectively (due to limited resources).



What type of resources are your the limiting factor? Man power required to define a new database table?
 
ricky wong
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Dave,

Yes, the limited resource is man power and management concern. Management don't think our application should change for each application. It is not very reasonable.


Thanks.
Ricky
 
I was her plaything! And so was this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic