CN101198931A - Data management for mobile data system - Google Patents
Data management for mobile data system Download PDFInfo
- Publication number
- CN101198931A CN101198931A CNA2006800089682A CN200680008968A CN101198931A CN 101198931 A CN101198931 A CN 101198931A CN A2006800089682 A CNA2006800089682 A CN A2006800089682A CN 200680008968 A CN200680008968 A CN 200680008968A CN 101198931 A CN101198931 A CN 101198931A
- Authority
- CN
- China
- Prior art keywords
- data
- business
- mobile
- command
- data source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000013523 data management Methods 0.000 title description 6
- 238000000034 method Methods 0.000 claims description 46
- 230000009471 action Effects 0.000 claims description 41
- 230000008569 process Effects 0.000 claims description 31
- 238000012217 deletion Methods 0.000 claims description 8
- 230000037430 deletion Effects 0.000 claims description 8
- 238000003860 storage Methods 0.000 claims description 8
- 238000003780 insertion Methods 0.000 claims description 5
- 230000037431 insertion Effects 0.000 claims description 5
- 238000007726 management method Methods 0.000 description 22
- 238000013500 data storage Methods 0.000 description 17
- 230000006870 function Effects 0.000 description 17
- 238000010586 diagram Methods 0.000 description 14
- 230000000712 assembly Effects 0.000 description 9
- 238000000429 assembly Methods 0.000 description 9
- 238000013461 design Methods 0.000 description 6
- 238000001514 detection method Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 5
- 230000010354 integration Effects 0.000 description 5
- 230000004044 response Effects 0.000 description 5
- 230000001360 synchronised effect Effects 0.000 description 5
- 238000004590 computer program Methods 0.000 description 4
- 230000008676 import Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000012546 transfer Methods 0.000 description 3
- 239000000284 extract Substances 0.000 description 2
- 238000009434 installation Methods 0.000 description 2
- 230000002452 interceptive effect Effects 0.000 description 2
- 230000009545 invasion Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 240000005020 Acaciella glauca Species 0.000 description 1
- 241000394635 Acetomicrobium mobile Species 0.000 description 1
- 230000003044 adaptive effect Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000002457 bidirectional effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 239000003795 chemical substances by application Substances 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000013497 data interchange Methods 0.000 description 1
- 230000005284 excitation Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000002045 lasting effect Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 239000011159 matrix material Substances 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000011112 process operation Methods 0.000 description 1
- 235000003499 redwood Nutrition 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 239000000344 soap Substances 0.000 description 1
- GOLXNESZZPUPJE-UHFFFAOYSA-N spiromesifen Chemical compound CC1=CC(C)=CC(C)=C1C(C(O1)=O)=C(OC(=O)CC(C)(C)C)C11CCCC1 GOLXNESZZPUPJE-UHFFFAOYSA-N 0.000 description 1
- 230000000087 stabilizing effect Effects 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A data architecture provides View objects that define an enterprise data source interface to an application through connectors, and also by Data Objects defined by Commands. Thus, a Data Object comprises a configurable request for data that is issued through Commands to the Adapters of the enterprise data sources. The architecture provides an application developer with the ability to create custom enterprise connectivity to disparate backend enterprise data sources.
Description
The reference of priority document
The application requires the right of priority of the following files: the sequence number that people such as Robert O ' Farrell submitted on March 21st, 2005 is 60/664,121 and is entitled as the U.S. Provisional Patent Application that awaits the reply jointly of " Data Management for Mobile Data System "; The sequence number that Robert Loughan submitted on March 21st, 2005 is 60/664,088 and is entitled as the U.S. Provisional Patent Application that awaits the reply jointly of " Modular Applications for Mobile Data System "; The sequence number that people such as Robert O ' Farrell submitted on March 21st, 2005 is 60/664,122 and is entitled as the U.S. Provisional Patent Application that awaits the reply jointly of " Adapter Architecture for Mobile Data System "; And the sequence number submitted on April 1st, 2005 of people such as Robert O ' Farrell is 60/667,816 and is entitled as the U.S. Provisional Patent Application that awaits the reply jointly of " Modular Applications Management forMobile Data System ".Therefore require the right of priority of each submission date, and the disclosure of these temporary patent applications is quoted at this as a reference.
Copyright notice
A part of disclosure of this patent file comprises data protected by copyright.The copyright ownerL copyrighted material's owner does not oppose that anyone faxs and copies this patent file or patent disclosure with the appearance that United States Patent (USP) trademark office file or record are presented, but then keeps all copyrights in others.
Technical field
The present invention relates generally to mobile computing system, the data management and the data that relate in particular in the mobile computing system are disposed.
Background technology
The automaticity that ripe Customer Relation Management (CRM) system and Enterprise Resources Planning (ERP) system can be used for improving administration section and administrative department's course of work.Although many companies have recognized that all disposing these systems can significantly save cost and raise the efficiency, be equally really many tissues find these systems implement burden very heavy and be difficult to existing legacy data system combination to together.
Recently, work organization and enterprise are disposing CRM and the employee of ERP system to help to move, and this mainly utilizes such as mobile computing devices such as pager, mobile phone and PDA(Personal Digital Assistant)s.Use the CRM of these mobile devices and ERP system in wider, obtain adopting a required significant obstacle that faces relate to enterprise in the problem integrated of other data.
The reason that the business data integration problem occurs is that usually with proprietary closed system structure appearance, this architecture hinders with other data system of enterprise and integrates mobile applications.For example, the data in the enterprise may be kept in four or five the different sources.Some source in these data sources comprises crm system, dispatching system, ERP system and financial register system.Different data volume architecture, form and agreement can be used in each source in these data sources.The configuration of data of storing and data and access mechanism is all in continuous variation.Many mobile computing systems are created a kind of ephemeral data storage (datastore), have wherein collected the data from each source in the enterprise.Like this, can be collected in the single public database from different business data sources and these data of having different data volume architecture and form separately.The mobile subscriber stores by this ephemeral data of visit but not access just can be carried out to business data in actual business data source.Yet, this interim storage produced about himself Data Update with problem such as conflict.Synchronous operation and other safety practice must often be carried out, to guarantee that the data in this ephemeral data storage are reliable copies of the data in the business data source.
Knownly provide a kind of data integration solution that can use mobile computing device, these mobile computing devices join by the webserver and business data.The sequence number of submitting on Dec 23rd, 2003 is that 10/746,229 U.S. Patent application has been described this system, and this patented claim has transferred the Dexterra incorporated company in Washington state Bothell city.The content quotation of this application at this as a reference.
A kind of like this system has been described in the above-mentioned application of Dexterra incorporated company, in this system, use data in a plurality of business data source between the mobile client with distributed way, the feasible request that receives from mobile client to business data, determine to contain the suitable business data source of institute's request msg, and from determined business data source, retrieved business data.When retrieving business data, it is converted into relational format, even these data are from the business data source (such as file system, Email etc.) of the non-relationship type of a plurality of differences.The business data that conversion is good is stored in the relation data storage in the mobile client.Like this, mobile applications just can be with fully integrated from the data in a plurality of business data source, and Data Update and configuration variation just can be assigned to/derive from mobile client in real time under the situation of not using the ephemeral data storage, have avoided synchronous and asynchronous data problem complicated between business data source and the mobile client thus.Real time data changes not only can comprise Data Update, can also comprise the deployment that mobile applications self changes.These real-time change will further adapt with data collision detection and solution.
The said system of Dexterra incorporated company is based on a kind of like this system architecture, and wherein target business data source comprises a plurality of objects or tables of data, and each target matrix all is mapped to the data object that is called as view (View).That is, view is defined by corresponding to application program each tables of data in those business data sources of data therefrom.These views can be defined by application developer, perhaps from another manufacturer.Between one or more data entities that are called as business object (Business Object), share the data in these views.Single business object can be used the data from a plurality of views, therefore can use the data from a plurality of business data source, even can use the data from the incompatible a plurality of data sources of its data layout.In this system, the data object that is called as connector (Connector) provides the data sharing interface for the business data source.
In case define one group of business object, application developer just can be described and be defined in the situation of view and connector but not be absorbed in by its design application when this interface of organizing business object comes deal with data.Therefore, for the developer presents a kind of unformatted data-interface, so extract the difference of target aspect from the developer.
System described in the above-mentioned patented claim of Dexterra incorporated company provides a kind of powerful developing instrument that is used to permit visit the mobile computing platform in various business data source.Yet if the data-interface aspect has greater flexibility, ability that can expanding system also makes application development easier.The present invention just provides this greater flexibility.
Summary of the invention
According to the present invention, a kind of data volume architecture is provided, wherein view definition arrive the business data source interface of application program by connector, but also used by the defined data object of order.Therefore, data object comprises configurable request, this request at be the data that are sent to the adapter in business data source by order.Present architecture makes the developer can create the customization enterprise connectivity that arrives business data source, complete different backstage.The developer can also separate the connectedness that arrives any backstage business system with the configuration of the particular instance of implementation and at its adaptability.This allow to make between " .NET " system and the background system technology (connection) can with the incoherent situation of the configuration of this background system information needed under develop, created level of abstraction thus and allowed configuration tool to manage this adaptability.Developing instrument external member environment can be provided, and it allows the user to utilize " Dexterra Studio " VS.NET plug-in card program to create data package and they are connected to the adapter of any support.The assembly that is used for this suite of tools environment comprises connecting object, command object, data object and view.
About the description of better embodiment, should be clear that other characteristics of the present invention and advantage according to hereinafter, better embodiment shows principle of the present invention as example.
Description of drawings
Fig. 1 is the block diagram of the computing system environments that is suitable for of the mobile enterprise platform that makes up according to the present invention.
Fig. 2 is the block diagram of the logic architecture of the data in the mobile enterprise platform shown in Figure 1.
Fig. 3 shows the business data source of Fig. 1 and the block diagram of the attachment unit interface between the mobile client.
Fig. 4 is the block diagram of the suitable computing system environments 400 of structure according to the present invention.
Fig. 5 shows the diagram of the data volume architecture that is used for mobile platform shown in Figure 1.
Fig. 6 is the diagram that is used for the data access configuration of the mobile platform of structure according to the present invention.
Fig. 7 is the screenshot capture as the display of the computer equipment of the main frame of DAD computer program application.
Fig. 8 shows tree-like view and the context menu that is produced by the DAD program when choosing " Datasource Types " on the Dexterra explorer menu.
Fig. 9 shows the situation of choosing of Data Sources menu item in Fig. 8 display.
Figure 10 shows the situation of choosing of particular data Source Type, has therefrom produced context menu.
Figure 11 shows the view type that can be used for selecting.
Figure 12 shows by using Data Sources context menu to create a kind of novel data source (Data Source) thereby the Data Sources Properties dialog box that produces.
Figure 13 shows the checking screen that is used for the DAD log-on message and selects specific enterprise data source target.
Figure 14 shows the deviser makes command selection from tree-like view situation.
Figure 15 shows " New Command " dialog box in response to the selection of Figure 14.
Figure 16 shows the parameter options card of Add Command dialogue.
Figure 17 shows the tree-like view of the newer command of adding " CustomerQuery " by name.
Figure 18 shows the process flow diagram according to the processing of mobile platform of the present invention system.
Embodiment
In mobile data integration system constructed according to the invention, view object has defined the business data source interface that arrives application program by connector, but has also used by the defined data object of order.That is, data object comprises configurable request, this request at be the data that are sent to the adapter in business data source by order.Present architecture makes the developer can create the conventional enterprise connectivity that arrives business data source, complete different backstage.What hereinafter at first describe is system described in the above-mentioned patented claim of Dexterra incorporated company.Then, the present invention compares its architectural variations with prior art system details has been described in " V. adaptor body architecture " and subsequent paragraph thereof.
I. system outline
The invention provides a kind of system, in this system, use data from a plurality of business data source to the mobile client of carrying out mobile applications, make mobile applications and a plurality of business data source combine, and Data Update and configuration variation can be assigned to/be received from mobile client in real time under the situation of not using the ephemeral data memory storage.Cancellation ephemeral data storage facility can be avoided synchronous and asynchronous data problem complicated between business data source and the mobile client.Thus, Data Update and the system configuration that is used for mobile applications upgraded and can be transferred to mobile client or be transferred to enterprise from mobile client from enterprise in real time.Change because can propagate these in real time, so no longer need any special synchronous operation by this system.
II. system platform
Fig. 1 is the block diagram of the suitable computing system environments 100 that constructs as described in the above-mentioned patented claim of Dexterra incorporated company according to the present invention.Fig. 1 shows mobile client machine equipment 102, and such as PDA(Personal Digital Assistant) equipment, this equipment is used in combination with Microsoft PocketPC or Palm PDA operating system.The mobile client machine equipment communicates with apps server 106 by network connection 104, to ask from data in server and to receive Data Update, new data is provided and receives configuration variation.Should be appreciated that a plurality of mobile clients 102 can communicate with server 106.Easy in order to draw, Fig. 1 only shows single client devices 102.
Keeper's application program 110 and developer application 112 constitute " operating room (Studio) " assembly 130 together.In the embodiment shown, keeper and developer provide as two independent application programs, and a kind of device that is used to dispose this system is provided, comprising metadata data and application programming interfaces.
III. logic architecture
Utilize any client applications of mobile enterprise platform shown in Figure 1 all will use the system component shown in the block diagram of Fig. 2.These assemblies comprise:
Business object (Business Object)-based on the Programmable object of service concept has made up a plurality of fields and has related to information from different business data source.(data source is such as client, contact person, assets, task dispatching data source are arranged).
Business rule (Business Rule)-under the situation that the business datum from the business data source is applied inspection, utilize professional constant to implement the customized logic of operation flow.
Professional constant (Business the Constant)-configurable variable of a kind of user is used for client applications and client-server both sides' business rule (such as business rule, alert message etc.).
Data source connector (Datasource Connector)-be designed to seamlessly provides the data source connector to the visit of various business data source (such as according to Oracle and formative those databases of sql server, the message transfer service as MQ series or MSMQ, the CRM application program, general networking service as Siebel or Peoplesoft etc.).
Operation flow (Business Process)-metaphor, such as " Force Flow (forcing stream) " process of the Dexterra incorporated company of Washington state Bothell, it has defined a kind of navigation framework that is used for the list of analog service flow process to list.
The combination of the standard vision display screen of list (Form)-have event-driven logic (such as watching, edit, search etc.), these display screens are designed to display message, acquisition of information and guiding user and pass a given operation flow (being called as " ForceFlow (forcing stream) " or " Field Flow (field stream) " herein).
The expression the revised mode of the data of view (View)-from one or more business objects employed business data source or application program, identify.
Filtrator (Filter)-can be applicable to view to revise the filtrator of business object data available.
These assemblies can be used to specify any by using the configuration (logic architecture) of the client applications that technological frame as Microsoft " .NET " and the instrument as Microsoft " Visual Studio.NET " make up.Those skilled in the art can be very familiar to this programming tool, with specified application and related data object thereof.Mobile enterprise platform shown in Figure 1 is realized as a kind of metadata driven framework.This framework provides the client-server network service of integrating, thereby can realize being used to dispose the necessary connection of (mission-critical) enterprise solution, configuration and the data management service of fail-safe, task-key.
Structure and external application business object that Fig. 2 shows relational database table in the mobile enterprise platform of Fig. 1 all are mapped to a plurality of views as metadata.One or more views are by business object (also defining by metadata) consumption, and the latter transfers to be moved again application program and uses.Mobile applications uses the client computer framework that is called as " Dexterra Smartclient ", the instantiation of this framework management business object, the local data visit (Local DataAccess) to residing in the basic physics database on the mobile client machine equipment, the client-server data communication that equipment is integrated and passed through data administrator and/or connector web service.In this platform, the standard that is used for all logical layers (such as business object, view, filtrator and connector) all defines in metadata and preserves.
The mobile enterprise platform is built into a logical stack, and it is designed to make the layer in the logic architecture to isolate with all non-adjacent layers.In the bottom of this logical stack, target (Target) layer is the data that reside in the business data source on backstage.This platform comes work with local source data, and does not require the information reproduction in the background system of record to the middle layer coping database.That is, do not need the ephemeral data storage.This provides the dirigibility and the real-time data access of design aspect, and can help to reduce to have the total cost of this platform and application program, also helps to have simplified data management processes.
Be the connector layer toward last layer again in the logical stack.The connector layer will be used to describe back-end data program stored structure with relational format and offer apps server.All be stored in the metadata about information and the security set (such as verification method and user and grouping definition) that how to be connected to the business data source, and preserve with keeper's assembly.Following one deck in the logical stack is the view layer, and it comprises that the object or the table that are used for to business data source, backstage provide those objects of mapping one to one.For example, if background system has the table that is called as CUST_ADDR (customer address), and the data in this form need be used for an application program, then will create a view in keeper's assembly.For example, the administrator view can be called as CUSTOMER_ADDRESS, to be in the data of outside, business data source in the environment of representing the mobile enterprise platform.Should be appreciated that, view have with background system in data object attribute or be listed as corresponding attribute.Yet, and do not require that all properties in the Data Source is all the same with the attribute in the view.In fact, required attribute be in Management Unit, define and stored as metadata.In the example of just having mentioned, these attributes may comprise such as fields such as ID, STREET_ADDR, CITY, STATE and ZIP_CODE.
In addition, the user can define the data type of the various attributes in the view, and these data types can be independent of the data type of respective attributes in the business data source.Other option of the view properties that can be identified is unique identifier, read-only, index, essential attribute and length.All above-mentioned information are all stored as metadata.
The view layer also provides the indication of data collision, and a kind of means that are used to solve this conflict are provided.For example, as long as between between the content existing from mobile client uploaded content and server place data variation is arranged, then just data collision may appear.The solution of this conflict can be carried out at view layer place, implement some business rules, nearest data variation is always preferential such as permitting, and perhaps permits preferential from the data variation of particular source (such as mobile client or business data source) according to data type (such as field data or customer account data).Hereinafter the service of binding data supervisory routine network is further described this.
As shown in Figure 2, can define view, provide the dirigibility of the aspects such as use of application deployment and original place system thus, the burden that does not have data to duplicate simultaneously at a plurality of objects in a plurality of data storage.As connector, definition of view also is stored in the metadata, and is managed by the keeper.It should be appreciated by those skilled in the art that the details of the data definition in the metadata, and need not to be further explained.As mentioned above, can be passed to the data of one deck down with modification with filter application in view.The keeper provides the view management characteristics, comprising based on the object interface of back-end data storage object (from the business data source) or table definition and automatically create the view wizard (Views Wizard) of view.
Among Fig. 2 up again one deck comprise a plurality of business objects, they are mapped to one or more views or are associated with one or more views.The business object of this platform is that the developer incites somebody to action interactive program entity with it when making up the mobile applications of customization.Business object comprises a plurality of attributes, and each attribute can have a kind of simple data type or can be another kind of business object.Because the business object of this platform can be mapped to a plurality of views, so the developer can use the single entity that is used to represent the data that are derived from a plurality of disparate data sources to carry out work.Thus, the single business object that defines of mobile enterprise platform according to the present invention can comprise the data from a plurality of potential incompatible business data sources (such as from different professional formats).
Creating or revising when being used for the application program of mobile applications and mobile client machine equipment, the developer can be only and business object layer reciprocation.This make the developer not need to understand or with the direct reciprocation of the background system that is used for source data (business data source).Like this, the business object layer provides object-based interface for application developer, thereby extracts the details about lasting data and retrieval.The developer there is no need with mobile device on the direct reciprocation of local datastore.In addition, character because of turn-off data, mobile client stores data variation in the client computer into by the business object interface locally, thus the processing procedure of management data variation automatically, and these data variation will be passed to apps server in renewal process.This has further exempted developer's fixed program task.
Business object is present on the mobile client machine equipment as metadata, and also manages with keeper (Fig. 1).The use of metadata in the mobile enterprise platform provides a kind of like this environment, in this environment the attribute of most of data entities and behavior can be by graphic user interface but not coding be configured.
The metadata driven character of mobile enterprise platform can be carried out operation flow by the stateless server architecture on mobile client.By metadata, can dispose and customize mobile applications.Meta data definition with reference to professional business data to the structure of the business object of mobile device, and defined the incident of the business rule that is used to trigger those control operation flows.
Metadata database comprise interleaving function cross-application program backstage business information with reference to situation, this information comes out with the configuration service object by connector.This process realizes by operating room's assembly (Fig. 1), so that dispose also with reference to the business data source business information that is just connecting with business object.This provides the path of particular data for mobile applications, thus guarantee without any business datum from the business data source be with its data layout originally store on the apps server or be stored in any other and be used for the ephemeral data storage of the system of Data Update.The non-invasion formula of this use metadata and real-time method for synchronous are permitted the mobile enterprise platform and be connected to background system effectively under the situations of interruption amount minimum, make data access, data consistency and the data integrity of interleaving function all reach maximum simultaneously.
IV. mobile enterprise platform assembly
A. mobile applications
As mentioned above, mobile client 102 (Fig. 1) can comprise the application program 124 of installation, and they realize the operation flow of enterprise.This application program can regulate above-mentioned mobile enterprise platform, and proves that this application program is a how instantiation business object, and these business objects drive the operation flow with metadata configurations.
For example, task or job order information will be provided for mobile applications by view, and will conduct interviews to it by business object.By in the process of view definition retrieval service data, to serve by using the data administrator network, this business object can be delivered to business datum this mobile applications to describe these tasks.These data are stored on the local relational database on the mobile device.When in from the request of application program, the task business object being confirmed the renewal of task data, the Smartclient application program will be preserved the variation of the view definition data storage on the mobile client, then Smartclient serves managing data updates to get back to the raw data source by the data administrator network, thereby guarantees data integrity and consistance.
By using the degree of depth, width and the strength of network service available in the mobile enterprise platform described herein (such as connection, configuration and data administrator service), can be easy to make up large quantities of mobile applications, comprising such as application programs such as sales force's throughput rate, customer service and support solutions.These application programs can with the very wide vertical applications integration procedure of a class range together, comprising oil/gas, health care/medical treatment and finance service industry solution.
B. server component
Apps server is a class metadata driven platform application program and information, application program and operation flow offered mobile client, and guaranteed the managed data integrity between the main frame in mobile enterprise platform and business data source, backstage.Apps server is a kind of technical high performance solution based on process of Microsoft " .NET " that is implemented in.By using " .NET " technology, the mobile enterprise solution is a kind of framework by carrying out the network service of exchanges data and transmission at local XML and SOAP.Apps server provides three kinds of core network services, just as shown in the functional architecture figure of Fig. 1:
The service of connector network
The non-invasion formula of connector network service delivering surviving enterprise base of applications facility is integrated, and keeps the control to the data integrity condition between mobile client and the discrete business data source simultaneously.
The configuration network service
The system configuration (such as checking, login, safety and role) that is used to define the metadata of business datum, business object, business rule, professional constant and comprises the mobile applications (residing in the component applications on the mobile device) that is passed to mobile client in the configuration network Service Management.
The service of data administrator network
Renewal reciprocation between data administrator network service coordination mobile client application program, apps server and the third party's business data source.In addition, the service of data administrator network can directly communicate with the connector layer so that inquiry in real time.The data administrator network service management relates to a plurality of users provides dirigibility to the mode of the various conditions of a plurality of implementation data integralities of more newly arriving in a plurality of business data source.The service of data administrator network can or be pointed to any API and/or web service that the third party has announced realizes above-mentioned this point by apps server.
Like this, the service of data administrator network can be managed application program update and the deployment scenario of data variation in the mobile client of this system.
Below these assemblies will be described in more detail.
1. connector network service
The service of connector network is designed to support that data source or network AP services I with any ODBC of complying with communicate.The service of connector network allows the client to define and make up view based on the data of being stored in the one or more third party system.The service of connector network has the interface of issue, allows to upgrade in batch and real-time data access from the standard of mobile client.
The service of connector network provides the Physical layer between the special interface in apps server unit's application program and business data source to connect.Connector supporting database competition management and notification service, transaction management and mistake are handled.In client's configuration of acquiescence,, dispose the mobile enterprise plateform system at client with ODBC or network service adapter.Those skilled in the art can produce the connector that is connected to the most frequently used business system (such as Siebel, SAP, PeopleSoft, Oracle, sql server etc.).
For example, the nearest data configuration that has by the client directly arrives enterprise database self to API (such as the PL/SQL process) or by ODBC, and " Oracle " application program connector allows the client to call Oracle and supports service.As all ODBC connectors, the dynamic access of RDBMS pattern is automatically carried out, thereby exposes the specific physical Design of database.This has provided the hierarchical view of the actual interface that arrives this system for the client.
It is the example that how to make business data source and mobile enterprise platform interface that Fig. 3 shows connector.In the left side of Fig. 3 is the expression in a plurality of business data source, comprising ERP data source 302, CRM data source 304, occurrences in human life/financial data source 306, legacy version/odbc data source 308, and can comprise other network service or other source (not shown).At the middle part of Fig. 3 is the expression of metadata 312, and metadata 312 specifies in to apps server 314 how the data from different business data source will be stored with related in the mobile client 316, and mobile client 316 then is illustrated in the right side of Fig. 3.
Therefore, in this example, the data that are denoted as ORDER_ID are present in the ERP data source.The data that are identified as F_NAME and L_NAME are present in the CRM data source.The data that are identified as CRED_LIM are present on occurrences in human life/financial data source, and the data that are identified as WARRANTY are stored in legacy version/odbc data source.All these data that identified all are stored in the business data source, such as in the office system of backstage.
In metadata 312, be mapped to a plurality of views from the data definition in business data source, these views are used for creating data storage and will be from the related service data storage on the mobile client in business data source to relational database on the client computer.By the business object layer that defines and store in the metadata on the mobile client, carry out visit to above-mentioned business datum.As shown in Figure 3, ORDER_ID from the ERP data source is mapped to a business object attribute that is called as OrderID, and its contextual definition is stored in the metadata 318 on the mobile client 316 and by one or more mobile applications that define in metadata equally and uses.F_NAME data from CRM business data source are mapped to the FirstName business object attribute definition of being stored in (storing into) mobile client database, and the L_NAME data are mapped to LastName business object attribute.Similar is, is mapped to CreditLimit business object attribute from the CRED_LIM data in occurrences in human life/financial data source, and is mapped to Warranty business object attribute from the WARRANTY data of legacy version/odbc data source.Therefore, serve by the data administrator network, from the data in potential dissmilarity and incompatible complete different business data source 302,304,306,308,310 with suitable form be passed to mobile client local datastore (by from the business data source to apps server 314 circuit represent) so that conduct interviews with one of business object on the mobile client (in mobile client 316, indicating) with actual numerical value.
Connector type
The connector that the service of connector network is supported comprises following three kinds of connector types:
1. when being connected to the third party system, uses mobile platform the network service adapter, this third party system (a) is the non-ODBC's of complying with, or (b) do not allow the ODBC/RDBMS connectivity, or (c) its interface by standard A PI definition and can serve descriptor language (WSDL) with network and pack and define.
2. when being connected to the third party system, uses mobile platform the ODBC/RDBMS connector, this third party system (a) complys with ODBC's and (b) allows direct ODBC/RDBMS visit, and (c) its data are physically located in the identical lan environment or can conduct interviews by supporting the communication protocol of transmitting (such as RPC, TCP etc.).
3.API connector is similar to the network service adapter, but (a) requires this API to visit by non-internet agreement (such as RPC), and (b) if network service interface is unavailable, then uses this API connector.
Through ODBC/RDBMS connector readout mode, under the situation of use and management person's application program, finish information by operating room's part 130 (Fig. 1) of using the mobile enterprise platform.Operating room's part is used to dispose the view definition that is mapped to Data Source, and one or more definition of view are mapped to one or more business objects.When use and management person defined view definition or view is mapped to business object, above-mentioned information was stored as metadata.In the process of upgrading with apps server and business data source, read this metadata to determine how to read, preserve and to remove data (selections/insertions/renewal/delete function), use the functions such as affairs that compensate such as collision detection/solution, intrinsic affairs with when suitable to manage and the implementation data integrality simultaneously.
For the RDBMS (8i, 9i etc.) of Microsoft's sql server or Oracle, when using the ODBC/RDBMS connector, read, preserve and/or remove data by ANSI SQL statement and/or storing process.When using network service/API connector, read, preserve and/or remove data by calling the proper A PI function or the method that are used for affairs.
2. configuration network service
The configuration network service that Dexterra is consumed the operating room provides a kind of mode of easy co-operate to realize, dispose for keeper, AR Analyst and developer and has managed Dexterra mobile enterprise solution.The configuration network service allows manipulator data at an easy rate, and this metadata is used to dispose and customize the data and the procedure definition of mobile applications.Characteristics with reference to keeper's assembly will be understood this service better, hereinafter this will be described in more detail.
3. data administrator network service
The renewal process model
In native system, use the renewal process model, wherein mobile applications upgrades its local data (application program or its business object) of preserving by using one group of core Net assembly (service comes out so that be easy to interoperability these assemblies as network) with the backstage enterprise database.
Mobile applications and all related service object definition data thereof are upgraded in the service of data administrator network.This renewal process model can be realized bidirectional data transfers by Dexterra apps server and mobile client between a plurality of business data source, thereby allows to upgrade when mobile client is connected to network, merges when they link to each other and upgrades.When being in off-state, these renewals of management in client environment are up to obtaining connection status and can starting update request that time.
Above-mentioned renewal process model adopts the method for " all or what all do not have ".If fault has appearred in (or before on whole stream is uploaded onto the server from client computer) before downloading on the mobile client from apps server whole stream, then the data administrator network service on the apps server does not receive about downloading the affirmation of (or uploading) affairs.As a result, server carries that intelligence need be return about it with management or client state such as simple retry.When mobile client is carried out the renewal process operation for the second time, apps server is considered the raw information state, and can under the situation that apps server had been handled, transmit the result, perhaps can never receive all in apps server must handle under the situation of information once more, thus between mobile client and apps server once and only implemented the reliable delivery of information once.In any case, along with data move to one or more Data Source from mobile client, all implemented the integrality of data.
The renewal process fault
Two types renewal is handled supported:
1: obtain nearest: in this updating type, mobile client is made a request so that obtain nearest information by the Dexterra apps server from the business data source.The Dexterra apps server is handled this request, and serves retrieval service information from a plurality of data sources with Dexterra connector network, and this business information is delivered to mobile client.
2: upgrade (two-way renewal): in this updating type, solve configuration parameter by using the Dexterra conflict, the record on the client-server terminal obtains exchanging, thereby has implemented the integrality of the data on mobile client and the business data source, backstage.
Collision detection/solution
Conflict solves has described the rule of using when the caused data collision of having done between mobile client and the business data source, one or more backstage of variation arbitrated.This solves this conflict (solution) in one or more modes then and carries out by at first discerning this conflict (detection).
The Dexterra apps server can detect conflict in one of three kinds of modes: revision, date is stabbed, or manual operations, and comes the identification collision situation by the row or column level.
Revision is a kind of setting, and wherein specific fields or attribute are identified as in single record source and revised, and the Dexterra apps server will use it to determine whether data changed on Data Source or mobile client.
Date is stabbed
It is a kind of setting that date is stabbed, wherein specific fields or attribute are identified as the date stamp and all obtain upgrading when any insertion/renewal or deletion in single record source, and the Dexterra apps server will use it to determine whether data changed on Data Source or mobile client.
Manual operations is a kind of setting, wherein do not have specific fields or attribute to be used for identifying the collision scenario in single record source, so the relatively more all field of Dexterra apps server or attribute data are with the definition uniqueness and detect whether data changed on Data Source or mobile client.
According to the configuration of Dexterra apps server, conflict solves in one of four kinds of modes: first upgrades successfully, the final updating success, and management solves, or server one square gauge is then.
First upgrades successfully
According to first new model more, apps server will only be accepted the variation that first makes any record of renewal.If record is at first upgraded and upgrades the network service detection to conflict by Data Source, then do not return mistake, but the service of data administrator network the version that provided by client computer will be provided and will be turned back to mobile client from the transcript of the latest edition in business data source, backstage.
The final updating success
According to final updating success model, server does not need to detect conflict.It will be saved in business data source, backstage from the variation of mobile client simply, thus overwrite current record in the business data source, backstage.
Management (or manual operations) solves
When being configured to management/manual operations solution, server will be looked all conflicts all needs manual intervention to solve, and will return copy, and randomly notify conflict to occur and allow and solve by the Dexterra keeper by advise of same service (SMS, Email etc.) from the current record in business data source, backstage.Do allowing the conflict of row level to solve like this, because the keeper determines these values optionally back to be applied to business data source, backstage again.
Server one square gauge then
Can create customizable server one square gauge then, so that more how sequencing ground and definite particularly some collision scenario should solve.For example, can solve conflict based on the value of the data in the record.This dirigibility allows to control fully the specific action that solves scene round conflict.
Client computer from server is disposed
Apps server comprises the definition that will be downloaded to the one or more mobile rig-site utilization program on the mobile client, comprising list/screen (being called as " list stream (FormFlow) "), the data interaction effect (being called as " field stream (FieldFlow) ") of expression task and be building up to list stream in operation flow/workflow and the grouping (being called as " forcing to flow (ForceFlow) ") of field stream.Hereinafter further describe list stream, field stream and force stream.This application program definition also comprises the metadata that configure relevant with application program, such as view, business object, the definition of professional constant.What also comprise in this deployment is particular traffic data from business data source, one or more backstage, and these data sources are that the operation mobile client is necessary in the state that " once in a while " connects.
Apps server provides the basis of transmitting and managing application program and being connected to surviving enterprise's data source and system.Distribute and management mobile enterprise platform application program at mobile device (such as Pocket PC and Tablet PC equipment) apps server, thereby provide a kind of height manageable management mode for all user interfaces at the scene.
C. keeper's assembly
As mentioned above, keeper's assembly (Fig. 1) allows the system manager to carry out those regular or frequent relatively variations.Keeper's assembly is suitable for form that AR Analyst or keeper manage visit to choice variable, drop-down list content and out of Memory is provided with a kind of.This management method allows the system manager that many functions are expanded to keeper's level downwards, and need not the sacrificial system integrality.
For example, the data of the business information of formation definition business events flow path can receive by business object definition form.The configuration network service provides this visit on the one hand to keeper's assembly.
D. client component
As mentioned above, client computer 102 (Fig. 1) in the enterprise platform architecture provides a kind of framework, in this framework mobile applications be called as " force stream ", " field stream " and " list stream " by use thus technology permission use based on role's operation flow, and under the situation of using the network service, can be by LAN/WAN network (such as the internet) or by wired and be wirelessly connected between mobile client and Dexterra apps server and the business data source and communicate.The mobile applications that runs on the client devices works in a kind of mode that is optimized at little form factor equipment, thereby a kind of user experience of unusual easy is provided.
Shown in system in, client computer is a kind of object-oriented framework that makes up with Microsoft " .NET compact framework " (it knows metadata).Client component can be delivered to the function of application of enterprise-level on the mobile device, and mobile device is preferably operated according to " PocketPC " operating system or " Tablet PC " operating system of Microsoft.Client component also with existing " PocketPC " function combine with the calendar at PocketPC interface, task and today screen function carry out seamless integration.It provides stabilizing effective working environment thus.
List stream (FormFlow), field stream (FieldFlow), pressure stream (ForceFlow)
Be that any operation flow task of form or step or operation all are called as " list stream " with the display screen.List stream is used to start the process interface effect of " the field stream " that is called as, and they allow to start operation flow, and this is called as " forcing stream ".Field stream starts excitation " band outer (out of band) " forces stream, thereby has brought real world elasticity for operation flow.
List stream is divided into three classes: (1) information; (2) activity; And (3) are upgraded.The information table single current is to be used for showing that the mobile subscriber finishes the screen of the required information of the next logic task of operation flow.The hotlist single current is the screen that is used for the content that explicit user need do or carry out.The updating form single current is a screen shown when prompting user input will turn back to the data of host application program (business data source).
For example, when a part may be out of order and whether the search that may need to carry out inventory database exists and can obtain any compatible portion or do not exist and can obtain to have the similar problem of solution the time to check, may need field stream, this is called as searches; Perhaps may need to be ordered or distribute or predetermined so that when being delivered to client computer, may need field stream when a part, promptly be called as the field stream of renewal.
Forcing stream is a kind of operation flow, therefore is the set of list stream and field stream.Forcing the example of stream will be time, travelling and expense record, and this record is relevant with work or allocating event.
Back with reference to Fig. 2, this block diagram show row in the destination application and the relation between the field be how with " list stream " (step in the operation flow, they are represented as " list " in application program) in information relevant and next be how to be associated with to force in the stream (operation flow).In a list stream, have many business objects and more than list stream is arranged in any operation flow potentially.
When in mobile applications to its carry out with reference to the time, filtrator allows feature and condition are placed on the data.For example, can detect data type (for example date), life type (for example only the week) and any conflict condition.Can also dispose other filter characteristic and condition.
Data that view definition is used in one or more business objects and memory location, and business object can be based on one or more views.This allows supplementary features associated.For example, business object can be called as " client ", and it can comprise standard client details; Position, contact method, inventory and SLA and other attribute, application program is classified as the client with them but they is not kept in the identical Object table even in the object application.
V. adaptor body architecture
Fig. 4 shows according to adaptor body architecture of the present invention.Some assemblies shown in Figure 4 are similar to assembly shown in Figure 1.In Fig. 4, those assemblies that its function is the same with corresponding assembly in the system shown in Figure 1 will identify with identical label, and difference is to start with " 4 " but not starts with " 1 ".
Fig. 4 is the block diagram of the suitable computing system environments 400 of structure according to the present invention.Fig. 4 shows mobile client machine equipment 402, and such as PDA(Personal Digital Assistant) equipment, the PocketPC or the Palm PDA operating system of it and Microsoft combine operation.Client devices 402 comprise with in conjunction with the identical assembly of client devices 102 described those assemblies shown in Figure 1, but these identical assemblies do not have shown in Figure 4 for simplicity.Mobile client machine equipment 402 connects 404 by network and communicates with apps server 406, so that request is from data in server and receive Data Update, new data is provided and receives configuration variation.Should be appreciated that a plurality of mobile clients 402 can communicate with server 406.Easy in order to draw, only show single client devices 402 among Fig. 4.
" Dexterra Studio " assembly 430 communicates with server 406, and comprises keeper's application program and developer application's (not shown among Fig. 4).More particularly, the configurator reciprocation of operating room's assembly and server 406, and the server of data server DDS and server 406 and adapter framework reciprocation, server 406 communicates with business data source 408.
Adapter framework provides a kind of interface, and it will be implemented in the required specific input and output of mobile data between server 406 and any other business data source.The data administrator of server 406 will be asked and in response to the connector assembly of any appropriate definition, so that communicate by adapter framework and business data source 408.Therefore, server 406 uses connecting object, command object, data object and definition of view, determines how to retrieve or preserve data and retrieval or preserve what data for business data source, backstage.
(" Dexterra Adapter Designer " or DAD) provides operating room 430 for the design tool external member, to allow each assembly of developer's specific adaptors framework.That is, DAD 430 provides by using the Dexterra VS.NET of operating room plug-in card program to make up the adapter framework data package and these assemblies being connected to the means of any Dexterra support adapter for the developer.Assembly comprises connecting object, command object, data object and view.
By using DAD 430, the developer will be created to the connecting object of Data Source by using the Dexterra support adapter.This connecting object with (by discovery/introspection or description) exposing into table, storing process, script or object (EAI etc.) by the data-interface object that adapter obtains.By using Dexterra adapter design person, next the developer will create a series of command objects, and these command objects are carried out specific action by adapter, such as selecting, insert, upgrade and/or deletion.The developer is the definition of data object next, and wherein they will select suitable select command, insert order, update command and/or delete command.Then, at its request action, view is tied to data object.By using this instrument and architecture, the developer can ask and preserve the data from business data source, one or more backstage, these data sources all are mapped to the single data object that defines in the Dexterra server 406, and the level of abstraction and the interface capability of physical data structure is provided thus.These actions can realize by the user interface of instrument 430, hereinafter this are further described.
A. command object
The command object of adapter framework has defined a kind of will the execution to retrieve or to preserve the action of data by adapter (being connector).For example, order may be defined as by adapter the customer data object is saved in the business data source " to preserve the client ".Command type or form will be by adapter according to determining with their interactive business data sources and therefore must supporting.For example, the potential command type that is used for data system can comprise table, process, SQL, script and object.
Command object will be specified the action that will be performed.According to the present invention, the command action type comprises five actions that define: (1) READ (reading), and (2) ADD (interpolation), (3) UPDATE (renewal), (4) REMOVE (removing) and (5) are used for EDIT (editor's) READ (reading).
Hereinafter the discussion of binding data object further describes these command action.Command object can the given filter device, and they will be operated when fill order.Each filtrator will come data are operated according to the data type of its corresponding command type.Order will comprise Column Properties, and it comprises the multi-column data that returns when carrying out this order.At last, order comprises and some parameters, these parameters is used to specify appropriate execution this orders necessary numerical value.
B. data object
Data object associating command object is with retrieval or preserve data, thereby logically they is grouped into single object (for example target client).Data object is by by (be it be on business data source exectorial result) of adapter in command definition performed on the business data source.As mentioned above, order comprises READ (reading), ADD (interpolation), UPDATE (renewal), REMOVE (removing) and the READ (reading) that is used for EDIT (editor).Reading order is a kind of like this command object, it with retrieve data, the data rows that will return of definition with and attribute, and it also with the cover data type so that turn to " .NET " example from adapter.Adding order is a kind of like this command object, and it will be preserved new data instance by adapter and be inserted in the corresponding business data source so that new data instance returned.Update command is a kind of like this command object, and it will back be saved in corresponding business data source with the variation of existing data item by adapter.Removing order is a kind of like this command object, and it will remove data from the business data source by adapter.The reading order that is used to edit is a kind of like this command object, and it will retrieve the single record with row lock (RowLock) by adapter.
Data object returns the parameters of element map to orders such as reading of adding, upgrade, remove and be used to edit with reading order.The individual data object can and be preserved data to potential different adapter by different command searches.
C. connect
As mentioned above, connection will with the business data source interface, so that mobile client application's data visit to be provided.In the adapter framework of describing in conjunction with the present invention 430, these connections will not carried out direct communication with view, but will directly carry out alternately with command object, and these command objects will final and data object and view swap data.
VI. dispose and user interface
In the adapter framework in the server 430 of configuration shown in Figure 4, the view not situation (as shown in Figure 2) in the system beyond the present invention is tied to the individual data table.More particularly, view is tied to the data object with the order that defines, and what these orders were used to read, add, upgrade, remove and be used to edit reads.Therefore, provide a kind of more general data-interface.The structure of view is listed as by the specified selected data of the reading order that is used for data object and defines.
In the system that uses view object configuration of the present invention, filter creation is in the command object place, but not the view object place.Operation that the configuration of the view object in the server 430 can abstract view CRUD to the business data source (create, read, upgrade, deletion), and can define CRUD but not to its hard coded.Except view configuration that changes and the variation (such as the variation that is used to create filtrator) of accompanying, remaining component shown in Figure 1 may be used to the mobile platform system that constructs according to the present invention.
Fig. 5 shows the diagram of the data volume architecture that is used for mobile platform shown in Figure 1 and comprises one embodiment of the present invention.The view object that Fig. 5 shows data system has view ID and is tied to the data object that defines.Fig. 5 shows data object and can comprise one or more from following order: reading order, the reading order that adds order, update command, removes order and be used to edit.
Fig. 5 shows command object and also is tied to data object, and is tied to connecting object, they then be tied to the adapter object.Fig. 5 shows adapter object and metadata store reciprocation, and metadata store and business data source reciprocation, so that retrieval is used for the data of mobile platform.
Fig. 6 is the diagram that is used for the data access configuration of the mobile platform of constructing according to the present invention.Fig. 6 shows view object and the apps server (in Fig. 6 promptly be represented as " Dexterra server ") of mobile client (being represented as " Dexterra client computer " among Fig. 6) by the server place and communicates, wherein thereby view object and data object reciprocation are so that by command object action visit adapter object, final and business data source (promptly being represented as the sql server and the Siebel data server of Microsoft among Fig. 6) the direct reciprocation of adapter object.At the client devices place, mobile applications by smart client request of data is sent to metadata store and business datum is stored the view object that arrives the apps server place again.
How Fig. 7 shows file resource management device type by graphic user interface and obtains visit to the DAD characteristics of mobile platform system.Fig. 7 is the screenshot capture of display on as the computer equipment of the main frame of DAD computer program application program.In Fig. 7, this display is the demonstration title " Dexterra Explorer " of Window-type, and demonstrates the workspace with the tree-like view of file.This tree-like view demonstrates the layered system of a plurality of servers, and these server names are Solomon, Tempest, Ultrium and Thunder.Should be clearly, these server names can be optional.
According to the DAD program,, can take exercises with respect to the server of choosing.It is selected that Fig. 7 shows " Solomon " server, and Data Access menu item is highlighted can be investigated to demonstrate data access option.Under Data Access menu item, demonstrate submenu, comprising DataSources, Datasource Types, Commands, Data Objects and Views.By using DAD program and explorer menu, the mobile applications deviser can specify new data source and can with corresponding adapter reciprocation to obtain visit to the business data source that is used for mobile client (they will use the application program of being developed).
Fig. 8 shows that the deviser chooses on the Dexterra explorer menu " Datasource Types ", and Fig. 8 shows context menu and is produced, thereby provides multiple option to add new data source type or to refresh this view or editing data Source Type or deleted data Source Type for the deviser.Therefore, select Dexterra explorer menu item can produce context menu, this context menu provides the menu of the additional operations on selected menu item.Fig. 9 shows the selection situation from the Data Sources menu item of Fig. 8, thereby shows according to available typical data source in the design native system.Fig. 10 shows the selection situation of particular data Source Type, therefrom can produce context menu so that the operations on editor's selected data Source Type.Figure 11 shows the view type that can be used for selecting.As use other DexterraExplorer menu item, select the View menu will produce a context menu, this context menu allows the deviser to view type executive editor operation, comprising creating, edit and deletion.
As mentioned above, if " Data Sources " node on the selection Dexterra explorer menu, then the context menu that can pass through to be produced is specified new data source.Figure 12 shows the data source property dialog box, and it is to produce by the data source of using the data source context menu to create newtype.Figure 12 shows to the deviser and presents a screen, allow based on the deviser can with data type select data adapter unit.In Figure 12, the available adapters type is shown as OLE DB for SQL Server, OLE DB forOracle, Clarify Adapter and Remedy Adapter.These type of adapters only are for purpose of explanation and show, should be appreciated that, additional and different type of adapters can content according to the present invention be provided.Figure 12 shows the deviser can also specify connection type.After selecting adapter, the deviser will select to connect the Show Button and connect parameter to specify.
Figure 13 shows a checking screen, and being used for the deviser provides log-on message and select specific business data source target.In case the deviser is authorized to, then will change this demonstration according to selected adapter.After new data source is defined, by using the DAD interface, according to the data source type of deviser's redetermination, new data source type node will appear in the tree-like view of Dexterra Explorer (Figure 10).
Can from the tree-like view of Dexterra Explorer, create, add, edit and delete other node.Figure 14 shows the deviser and just makes command selection from tree-like view." Add NewCommand " among selection Figure 13 will produce " New Command " dialog box of Figure 15.
Figure 15 shows and can and be used to specify the various parameters in data source, action, data type and source and import title at newer command, can also import title at being used to import the space of SQL statement.The parameter options clamping that Figure 16 shows Add Command dialog box is subjected to additional command explanation.
Various controlled variable in the Add New Command dialog box that is used for Figure 15 have:
Command name text box-DAD user imports a title to identify this order uniquely.On " save ", there is one about the whether unique proof procedure of this command name.
Data source-this is the drop-down list of the data source that defined.This information is found from metadata.Require each order all to have corresponding data source.
Command type (action)-this is the drop-down list of dissimilar available command.Require each order all to have a command type.
Data set frame-this group frame comprises the tab that is used for " Main " and " Parameters ", and comprises many controls to define a plurality of actions of this order.This frame will be according to the selected data source and difference.For example, demonstration shown in Figure 15 is used for RDBMS (such as sql server).The system as the Oracle/Siebel system that it will be apparent to one skilled in the art that will not have " SQL Statement " text box.
Source Type radio button-this radio button of selection will start two corresponding combo boxes (Datasource and Source Type) and forbidding SQL statement text box.This radio button is pointed out enterprise's object that the deviser is using the business data system to use.
Source Type frame-be is used for pointing out can be from the tabulation of enterprise's object type that business system obtains.The example of Source Type comprises the process of form, view or storage among the SQL.
The drop-down list of source frame-a kind of available enterprise object allows the user select based on filtering by type.
SQL statement radio button-this radio button of selection will start the corresponding text frame and forbid SourceType and the Source combo box.This radio button points out that the deviser will specify this order with the SQL statement of carrying out.
The SQL statement text box-deviser's input will be by the SQL statement of command execution.
Parameters in the Add New Command-Parameters dialog box that is used for Figure 16 has:
If Argument List bezel, cluster-comprise the parameter list that is used for selected enterprise object is the words that they are fit to.Figure 16 shows the parameter that is used for Return Value and CustomerFirstName.
Parameter attribute group frame-show is used to describe the control grouping of the attribute of selected parameter.
The title of name text frame-selected parameter.In Figure 16, it is disabled to point out it that text frame has become ash, because parameter name can't be edited.
The direction frame-this comprises the drop-down list of the direction type that a parameter may have, such as input, output and I/O.
The data type frame-this has comprised the drop-down list of the data type that can be used for this parameter, if available words.
Required frame-comprised the Boolean true or false, and point out whether need this parameter thus.
If the numerical value of numerical value text box-this parameter will be forced to, then text frame is available.
After editing process was finished, the tree-like view among the Dexterra Explorer will be updated to reflect any item that has added.For example, Figure 17 shows the newer command that is called as " CustomerQuery " and has been added to this tree-like view.Therefore, this title order will can be used for the subsequent development person that any use DAD is connected to the Solomon server.Should be noted that by using Dexterra Explorer graphic user interface and edit a plurality of orders, new CustomerQuery order can also be handled another node that (duplicate, move, edit and mobile etc.) arrives tree-like view.
Therefore, Dexterra Explorer instrument can be created conventional enterprise connectivity, and can separate any connectedness with this configuration and adaptive backstage business system of arrival at the particular instance of implementation.This permission communicates between .NET interface and background system leaved for development, and the required information configuration of this exploitation and this background system is what to be separated, has created a level of abstraction thus and has allowed configuration tool to manage this adaptability.Like this, the instrument that is disclosed has just been realized a kind of specific Dexterra adaptor interface, and it will be tied to the Dexterra data administrator, and is implemented in the necessary specific input and output of mobile data between Dexterra server and any business data source.
Figure 18 is a process flow diagram, shows the operating process of above-mentioned mobile data plateform system.In first operation (frame 1802), the user specifies (establishment) connecting object, it provide place, business data source, backstage storage data object interface and can expose in table, storing process, script or the object any by the data-interface object that this connecting object obtains.(frame 1804) determined data action in ensuing operation, wherein will carry out data action on the data-interface object, and wherein this data action is specified by the data object that identifies this data action according to command object.In the end (frame 1806) in the single stepping, view object are tied to data object so that carry out the command object data action of appointment on the data-interface object.
As mentioned above, when using the Dexterra instrument, the adapter that system designer will utilize Dexterra-to support is created the connecting object that arrives business data source, backstage.This connecting object (by using discovery with internal check or by describing) can expose into table, storing process, script or object by the data-interface object that adapter obtains.Next, when using the Dexterra instrument, the deviser will create a series of command object, and these command objects are carried out specific action by adapter.These actions can comprise operations such as picture selection, insertion, renewal and/or deletion.Next, deviser's definition of data object, wherein they will be selected suitable select command, insert order, update command and/or delete command.Next, view object is tied to data object so that its request and response action.When using this technology, the developer can ask and preserve the data from one or more Data Source, these data sources are mapped to the single data object that defines in the Dexterra apps server, and the level of abstraction and the interface capability of physical data structure is provided thus.
When mobile platform is worked in response to mobile client, the data administrator of apps server will be asked and in response to any attachment unit interface assembly of this system.Apps server uses definition of object such as connection, order, data and view to determine how to retrieve or preserve data and retrieval or preserve which type of data for business data source, backstage.
According to the present invention, the computer program instrument that is called as " DAD " that provides a kind of deviser for mobile applications to use is to create the customization enterprise connectivity that arrives complete different business data source in the mobile data plateform system.This DAD application tool provides these characteristics by the user interface of accompanying drawing.Therefore, this DAD application tool provides a kind of being used to specify that the data of being shared between a plurality of business data source and the mobile client are carried out the means that application program is handled.As mentioned above, the DAD application program provides: be used to specify the means of connecting object, this connecting object provides the interface of the data object that arrives the storage of business data source, backstage place and can expose in table, storing process, script or the object any by the data-interface object that this connecting object obtains; Be used to specify the means of command object, this command object is carried out specific data action; Be used to specify the means of data object, this data object is permitted the mobile data client computer and specify one of the command object data action that will carry out on the data-interface object; And the means that are used to specify view object, this view object is suitable for binding and is tied to data object so that carry out the command object data action of appointment.
The computer program that comprises the DAD instrument can be installed in computer installation or the system, such as desk-top computer, notebook etc., if this DAD implementing procedure can receive user input with realize the connection adaptor assignment procedure and can the verification msg source, binding etc. is just passable.Adapter that configures and connecting object can be included within the mobile data plateform system and be installed in the apps server place of mobile platform, sentence just and operate with the business data source so the operating feature of adapter can be used in mobile client.
Above invention has been described according to better embodiment, makes the understanding of the present invention can access reception and registration.Yet, have many configurations that are applicable to the mobile enterprise data system to specifically describe in this article, but the present invention can be applicable to these configurations.Therefore, the present invention should not be regarded as only limiting to specific implementations described herein, but should be appreciated that the present invention has very wide application usually about the mobile enterprise data system.All modifications, variation or the equivalent arrangements mode and the implementation that drop within the scope of appended claims all should be regarded as dropping among the scope of the present invention.
Claims (7)
1. method that the application program that is used to specify the data of being shared between a plurality of business data source and mobile client is handled, described method comprises:
Specify connecting object, described connecting object provide the storage of place, business data source, backstage data object interface and can expose in table, storing process, script or the object any by the data-interface object that described connecting object obtains;
The definite data action that will on described data-interface object, carry out, wherein said data action is to come appointment by the data object that identifies described data action according to command object; And
Make view object be tied to data object so that on described data-interface object, carry out the command object data action of appointment.
2. the method for claim 1 is characterized in that, described command object can be specified by the data action that arbitrary action constituted in data selection, insertion, renewal and the deletion.
3. the method for claim 1 is characterized in that, specifies described connecting object to comprise from a plurality of adapters and selects, and each adapter is suitable for communicating with complete different business data source.
4. a computer programming system is used to specify the application program processing of the data of being shared between a plurality of business data source and mobile client, and described system comprises:
Be used to specify the device of connecting object, described connecting object provide place, business data source, backstage storage data object interface and can expose in table, storing process, script or the object any by the data-interface object that this connecting object obtains;
Be used to specify the device of command object, described command object is carried out specific data action;
Be used to specify the device of data object, described data object is permitted the mobile data client computer and specify one of the command object data action that will carry out on the data-interface object; And
Be used to specify the device of view object, described view object is suitable for being tied to described data object so that carry out the command object data action of appointment.
5. system as claimed in claim 4 is characterized in that, described command object can be specified by the data action that arbitrary action constituted in data selection, insertion, renewal and the deletion.
6. system as claimed in claim 4 is characterized in that the connecting object of described appointment is selected from a plurality of adapters, and each adapter is suitable for communicating with complete different business data source.
7. a computer programming system is used to specify the application program processing of the data of being shared between a plurality of business data source and mobile client, and described system comprises:
Processor, described processor communicate by apps server and described mobile client and with described business data source reciprocation;
Deviser's tool applications, be used to specify connecting object, the specified command object, specified data object, and given view object, described connecting object provide one of business data source place storage data object interface and can expose into table by the data-interface object that connecting object obtains, storing process, script, or in the object any, described command object is carried out specific data action, described data object is permitted the mobile data client computer and specify one of the command object data action that will carry out on the data-interface object, described view object is suitable for being tied to described data object so that carry out the command object data action of appointment, wherein said command object can be specified by data and be selected, insert, data action and wherein said connecting object that any action in renewal and the deletion constitutes are selected from a plurality of adapter objects, and each adapter object is suitable for communicating with different full business data source.
Applications Claiming Priority (5)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US66408805P | 2005-03-21 | 2005-03-21 | |
| US60/664,088 | 2005-03-21 | ||
| US60/664,121 | 2005-03-21 | ||
| US60/664,122 | 2005-03-21 | ||
| US60/667,816 | 2005-04-01 |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101198931A true CN101198931A (en) | 2008-06-11 |
Family
ID=39548381
Family Applications (3)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2006800084392A Pending CN101208662A (en) | 2005-03-21 | 2006-03-21 | Modular applications for mobile data system |
| CNA2006800089682A Pending CN101198931A (en) | 2005-03-21 | 2006-03-21 | Data management for mobile data system |
| CNA2006800089697A Pending CN101218563A (en) | 2005-03-21 | 2006-03-21 | Data management for mobile data system |
Family Applications Before (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2006800084392A Pending CN101208662A (en) | 2005-03-21 | 2006-03-21 | Modular applications for mobile data system |
Family Applications After (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2006800089697A Pending CN101218563A (en) | 2005-03-21 | 2006-03-21 | Data management for mobile data system |
Country Status (1)
| Country | Link |
|---|---|
| CN (3) | CN101208662A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105956160A (en) * | 2016-05-17 | 2016-09-21 | 武汉邮电科学研究院 | Method for Android application to access database |
| CN110362320A (en) * | 2018-04-02 | 2019-10-22 | 阿里巴巴集团控股有限公司 | A kind of the order implementation method and device of application development platform |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102141996A (en) | 2010-01-29 | 2011-08-03 | 国际商业机器公司 | Data access method and configuration management database system |
| CN109857496A (en) * | 2018-12-30 | 2019-06-07 | 贝壳技术有限公司 | More application navigation configuration methods and system in a kind of ERP system |
| CN111221803B (en) * | 2019-12-27 | 2024-01-09 | 深圳云天励飞技术有限公司 | Feature library management method and coprocessor |
| CN117271643A (en) * | 2023-10-11 | 2023-12-22 | 浪潮通用软件有限公司 | Methods, systems, equipment and media for obtaining data through basic data framework |
-
2006
- 2006-03-21 CN CNA2006800084392A patent/CN101208662A/en active Pending
- 2006-03-21 CN CNA2006800089682A patent/CN101198931A/en active Pending
- 2006-03-21 CN CNA2006800089697A patent/CN101218563A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105956160A (en) * | 2016-05-17 | 2016-09-21 | 武汉邮电科学研究院 | Method for Android application to access database |
| CN110362320A (en) * | 2018-04-02 | 2019-10-22 | 阿里巴巴集团控股有限公司 | A kind of the order implementation method and device of application development platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101218563A (en) | 2008-07-09 |
| CN101208662A (en) | 2008-06-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8214409B2 (en) | Adapter architecture for mobile data system | |
| AU2003299837B2 (en) | Mobile data and software update system and method | |
| CN1744120B (en) | Conversion between application objects and smart client objects | |
| US7366460B2 (en) | System and method for mobile data update | |
| CN102378975B (en) | Extending collaboration capabilities to external data | |
| US10109027B1 (en) | Database access and community electronic medical records system | |
| US8694465B2 (en) | System and method for context sensitive mobile data and software update | |
| US20110167408A1 (en) | Configurable software application | |
| US20030204427A1 (en) | User interface for processing requests for approval | |
| AU1271601A (en) | Integrated data bank combining system | |
| US20060059035A1 (en) | Mobile sales online manager for handheld devices | |
| US20140229509A1 (en) | GINA Virtual Guid | |
| CN101198931A (en) | Data management for mobile data system | |
| US20010039536A1 (en) | Cost data management system, method of managing cost data, and recording medium | |
| US8204920B2 (en) | Method and system for accessing software-based systems | |
| CN100498685C (en) | Mobile data and software update system and method | |
| CN117474648A (en) | System and method for realizing industrial chain quota management and control based on tree structure | |
| US20080208900A1 (en) | Systems and methods for providing an enhanced status management service |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |