[Asterisk-Dev] Re: Creating An Asterisk Data Model

Paul Mahler pmahler at signate.com
Sun Jun 6 08:15:22 MST 2004


Hi,

Hibernate is a tool to do object-relational mapping, not a data modeling
tool. What is needed first is a data model, as steve started on. 

I have attached a piece of my ER data model as an example.

Paul


Paul Mahler 
pmahler at signate.com 	
Signate, LLC
665 Third Street
Suite 100
San Francisco, CA
 94107-1901

 Asterisk Services and Training

 

 

 

 

> -----Original Message-----
> From: asterisk-dev-admin at lists.digium.com 
> [mailto:asterisk-dev-admin at lists.digium.com] On Behalf Of 
> Miroslav Nachev
> Sent: Saturday, June 05, 2004 11:15 PM
> To: Paul Mahler
> Subject: Re[2]: [Asterisk-Dev] Re: Creating An Asterisk Data Model
> 
>    Hi,
> 
>    What do you think about some management & configuration 
> program using Java. I mean that we can do the data model 
> using Hibernate which data model use XML as description and 
> Hibernate supports more than 15 popular databases like MySQL, 
> MS SQL Server, Oracle, Informix, DB2, PostgreSQL, HSQL and 
> etc. The creation of database, tables, primary keys, foreign 
> keys, indexes, and population is automaticaly from Hibernate. 
> If some changes are made in XML description file Hibernate 
> automaticaly correct the database model.
>    If we do in details the user/technical requirements I can 
> start working for this and other concerning management and 
> configuration.
> 
> 
>    Best Regards,
>    Miroslav Nachev
>    
> I'm working on a data model, too. Steve has shared his model 
> with me. I am doing The ER model right now. 
> 
> 
> Paul Mahler 
> pmahler at signate.com 	
> Signate, LLC
> 665 Third Street
> Suite 100
> San Francisco, CA
>  94107-1901
> 
>  Asterisk Services and Training
> 
>  
> 
>  
> 
>  
> 
>  
> 
> > -----Original Message-----
> > From: asterisk-dev-admin at lists.digium.com
> > [mailto:asterisk-dev-admin at lists.digium.com] On Behalf Of 
> Peter Nixon
> > Sent: Saturday, June 05, 2004 2:58 AM
> > To: asterisk-dev at lists.digium.com
> > Subject: [Asterisk-Dev] Re: Creating An Asterisk Data Model
> > 
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> > 
> > On Saturday 29 May 2004 02:20, Ray Burkholder wrote:
> > > I've been working on implementing such a project.  The
> > basics for much
> > > of this stuff is in place.
> > >
> > > I have the basic double entry accounting tables in place
> > for handling
> > > sales orders, invoicing, shopping cart, AR, AP, GL.
> > >
> > > Basic telephony tables are in place to handle atomic
> > services such as
> > > origination, termination, did numbers, corporate dial plan, per 
> > > extension feature handling, voicemail, etc.  There is a
> > then a 'package'
> > > table that allows a mix and match of atomic services to
> > make a service
> > > provider offering.
> > >
> > > A user self-provisions various services through a web based
> > interface.
> > > Services are selected and placed on an order, then 
> invoiced.  In a 
> > > prepaid scenario, and deposit has to be applied before 
> provisioning 
> > > takes place.  On post paid accounts, provisioning can
> > happen right away.
> > >
> > > Provisioning is simply a matter of enabling the atomic services 
> > > selected via the package.
> > >
> > > Incoming calls are directed via a double AGI step, the first 
> > > identifies the inbound DID and it's generic call processing
> > script.  
> > > That specific script is then started to handle the
> > specifics of that
> > > DID's 'character'.
> > >
> > > Termination is handled in a similar manner.  There are
> > various calling
> > > plans to which one may subscribe.  The context:script 
> handling that 
> > > terminating call authorizes the termination if the account
> > is active,
> > > otherwise not if it is suspended or some such.  Then the
> > appropriate
> > > rating table is pulled up to rate and route the call.
> > >
> > > At call completion, a manager interface pulls out the cdr,
> > figures out
> > > the account and service type, and throws it into a sales order.  
> > > Account status is updated at this time to reflect balances
> > available
> > > for further calls and such.
> > >
> > > The user can review their sales orders and invoices at 
> any time and 
> > > apply payments.  On a regular basis, the system post sales
> > orders to
> > > invoices and submits email reminders for payments.
> > >
> > > Accounting is built in but I've been considering
> > accelerating that by
> > > connecting up with open source accounting such as Compiere.
> > >
> > > The solution runs on a minimum of 3+n servers.  A base system is 
> > > composed of:
> > >   * SQL server, currently PostgreSQL
> > >   * Apache web server running a bunch of Mason/Perl scripts
> > >   * Asterisk server with ip and tdm termination and more 
> Perl call 
> > > processing scripts
> > >
> > > All scripts and configurations are CVS'd to facilitate server 
> > > rebuilding and expansion.
> > 
> > - --snip--
> > 
> > > Now the question that comes to my mind is that it would be
> > interesting
> > > to share the solution as alpha as it may be in order to 
> accelerate 
> > > development and improvement, but still be able to glean
> > some dollars
> > > off it.
> > >
> > > That is a hard question.
> > 
> > It is, but as you, Steven and myself all appear to be independently 
> > working towards similar goals, it makes sense to chare the code. I 
> > think you choices of both Postgres and perl are good ones 
> and Compiere 
> > is a good idea, although something that I have currently 
> left out on 
> > the grounds that I don't know enough about accounting systems :-)
> > 
> > Cheers
> > - --
> > 
> > Peter Nixon
> > http://www.peternixon.net/
> > PGP Key: http://www.peternixon.net/public.asc
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.2.4 (GNU/Linux)
> > 
> > iD8DBQFAwadQAcdsUt9pJjwRAu0mAKCmIBEp21Cn7YM8/ahX9g6+oXDccwCg9lsE
> > SLX/x7KQmWsSk5c/egiQh40=
> > =KJSf
> > -----END PGP SIGNATURE-----
> > 
> > _______________________________________________
> > Asterisk-Dev mailing list
> > Asterisk-Dev at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-dev
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-dev
> > 
> 
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev
> 
> 
> 
> 
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Astersik.pdf
Type: application/pdf
Size: 10481 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-dev/attachments/20040606/778276d4/Astersik.pdf


More information about the asterisk-dev mailing list