TWI220203B - Method for mobile device real-time edit and access on-line data - Google Patents

Abstract

The present invention provides a method for a mobile device real-time editing and accessing on-line data, comprising: receiving a configure file of data accessing that was inputted via a mobile device by a user; generating a corresponding database command for the configure file; sending the database command to a back-end processing system, wherein the back-end processing system at least including a database; the back-end processing system generating a result according to the database command, and the result will be transferred to a data page that can be read and displayed by the mobile device, wherein various mobile devices have different displaying format respectively; finally, browsing the data page on the mobile device.

Description

1220203 _ Case No. 91114464_ Year Month Date __ V. Description of the Invention (1) 5-1 Field of Invention: The present invention relates to data query, and in particular, to a method for real-time editing, query and access of personal online data on mobile . 5-2 Background of the Invention: With the rapid development of various information technologies, people collect a large amount of data and various intelligence information, store them in computers and use their powerful computing capabilities to analyze, calculate, etc. these data, and It is hoped that the complicated and labor-intensive work that used to be done in the past can be completed quickly and accurately through various automated processes, so that people can directly obtain the required information from the terminal interface for use in making various decisions. The terminal interface mentioned above generally refers to a general computer device, such as a computer, a mainframe, etc., or a workstation computer or terminal connected to a back-end host using a network. However, users are still limited by the location of these terminals and cannot obtain information arbitrarily. For example, when marketing personnel are working outside, they cannot obtain the latest information in real time to provide to customers; or staff on different floors because Limited to the need to obtain information from a specific terminal, which is not conducive to work coordination; and other people who must move frequently because of the limitation of the working environment, cause even more inconvenience.

1220203 Case No. 91114464 Amendment 5 Invention Description (2) However, with the rapid development of wireless transmission, various mobile communication devices have become an indispensable part of modern life. Current mobile devices include mobile phones, personal Portable mobile devices such as Personal Digital Assistant (PDA), Smart Phone, Pocket PC, and ultra-thin pen computer, however, such as Tablet PC, Network PC and Web PAD, etc. It can be called a mobile device, and the development of mobile devices is roughly divided into mobile phones and portable data processing devices such as PDAs, pocket computers and other devices. At present, their respective wisdom in communication and data processing is based on their strong data processing capabilities. I 4 wΑ 疋 Based on PD Α, slightly governing ρ », _, $ The PD Α mobile phones developed have integrated mobile phone roar functions The computer data is false. Based on processing and Internet functions. At present, from the mobile device,> ☆ p, that is to say, the user can only choose two = two are passive information to receive information, but cannot back-end = ^ do not receive specific format and knowledge base, etc., For interaction, suppliers, such as databases and data, have the advantages of receiving information. They are taken by w 鄕,, #, and make it possible to carry the goods from the action for inventory or control. The warehouse management staff made it impossible for the tf on the fixed terminal to move constantly to facilitate work, correction of data and other actions, which caused Xu Xi's database to query the database. Xi :: The inconvenience and waste of time are hot, and the use of mobile devices or especially mobile problems, but the use of a part of the above situation can not only target the required features

Page 6 1220203 _Case No. 91114464_ Year Month and Day Amendment _ V. Description of the invention (3) Inquiry of specified data, and it is impossible to edit and access online data in real time. Furthermore, use mobile devices to receive information , And is also limited to the format that must be used to fit the data displayed on a particular mobile device. 5-3 Purpose and Summary of the Invention: In view of the above-mentioned background of the invention, due to the many shortcomings of conventional techniques, the present invention provides a mobile personal online method for real-time editing, querying and accessing data to overcome the traditional The problems derived from the above, therefore, the present invention provides a method for users to edit and access online data in real time directly from a mobile device, so that users are not limited by the influence of geographical factors. The main purpose of the present invention is to propose a method for real-time online data editing and storage. Another object of the present invention is to provide a method for online data query on different mobile devices. Another object of the present invention is to automatically detect and select the optimal display format for different mobile devices.

1220203 _ Case No. 91114464_ Year Month ___ V. Description of the invention (4) According to the above-mentioned purpose, the present invention provides a method for real-time editing and accessing data on a mobile device, which includes: receiving a user A data access profile entered on a mobile device; generating a database command corresponding to the data access profile; transmitting the database command to a back-end processing system, wherein the back-end processing system includes at least one database ; The back-end processing system generates a result according to the database command, and generates a data page that can be read by the mobile device according to the result, and different mobile devices have different data display formats for displaying on different mobile devices ; Finally browse this profile page on your mobile device. The above steps of generating a data page that can be read by a mobile device include at least: determining the type of mobile device used by the user; reading a display template corresponding to the type of the mobile device, combining the result generated by the database command with Display the template to generate the information page. Therefore, the present invention provides a method for real-time editing, querying, and accessing data on a mobile personal online, so that users can access real-time data access and query directly from a mobile device, and according to the different mobile devices used by the user , Automatically displayed in the best way. Therefore, users are not limited to the influence of geographical factors, nor to the need to use specific mobile devices to conform to the format of data display. 5-4 Detailed Description of the Invention: The embodiments of the present invention will be described in detail as follows. However, apart from the detailed description

1220203 _ Case No. 91114464_ 年月 日 _ί ±± _ 5. In addition to the description of the invention (5), the present invention can also be widely implemented in other embodiments, and the scope of the present invention is not limited. The scope of patents shall prevail. The method for real-time editing, querying, and accessing data on a mobile personal online of the present invention provides an action of editing and accessing data in a database in real time from a mobile device, such as a mobile device (Mobile phone), personal digital assistant (PDA), smart phone, smart phone, pocket computer, ultra-thin pen computer and other devices with input and output interfaces, and can use wireless communication for external data Transmission. In the preferred embodiment of the present invention, the HTTPD communication protocol over the wireless network TCP / IP is used, but other wireless data transmission methods can still be used in other embodiments. Therefore, the user can edit the query conditions for the required database table from the mobile device, and display the results on the mobile device, or update the changed data back to the database. Furthermore, the invention This method will automatically target the mobile device used by the user to provide the best data display method relative to this mobile device. In addition, when the user wants to perform this action on the mobile device, the method of the present invention may also choose to use a setting wizard to gradually guide the user through the relevant settings and action steps. According to the above, the present invention provides a method for instant editing and accessing data on a mobile device, which includes: receiving a user in a mobile device

1220203 __Case No. 91114464 ___ ^ 条条 正 ___ V. Invention description (9) The person who chooses to add a profile reads the name of the database currently available for linking and selects a database as the purpose of the new profile Library 1 〇2; otherwise, the user reads the original setting file 104 and performs the next setting operation on this setting file. Next, the user performs a setting operation 106 on the database to be queried or updated, which at least includes: setting the path to the database and the post-access code; reading the selection database form; completing the form-related settings; Read form field information; complete field related settings. In the above setting process, the user can go back to the previous setting step to modify until the user completes the setting action of the database 1 06, and the purpose of this action is to generate a structured query language (Structure) relative to the above setting action. Query Language (SQL) 108, which is used to query data in the database, or update data. Among them, SQL is the abbreviation of Structured Query Language, and it is the standard query language for related negative-type library management systems. With SQL, you can use it to define the database structure, specify the type and length of database tables and stops, add data, modify data, delete data, query data, and establish various complex table associations. That is to say, the user can perform various operations on the database without knowing the structured query language (SQL) through the default setting wizard or options. Next, the user chooses how to present the data, such as whether to present the queried data in a simple report or graphically (for example,

Page 13 1220203 Case No. 91114464 Amended 5. Description of the invention (10) Bar graph, circle block diagram, etc.) to display 1 1 0, and then according to the type of mobile device used by the user, profile, and data expression Wait for the information to generate the corresponding source code 1 1 2 and then store the above results °. The code generated from 'can display the data that the user wants to query in a specified' presentation mode 'in the user's action Device. Stats However, to display on different mobile devices requires different processing, such as computer screens and personal digital assistants1; due to different resolutions, different resolutions must be used when displaying data ^ The solution t shows the correct display state. It is also displayed on the computer as a "first-class file format of the page material. However, the file format: i :: only displays file formats such as JPEG and GIF. Therefore, when the present invention is displayed on a mobile device, it needs to be targeted at different The action of the stomach ^ ^. ~ Bey to turn to the step of the use of the line to read the question when the back end is used, and then the same picture shown in the line is used to show the invention in the display data to different Action flow chart, in which when the user finishes on the mobile device: the last step and send 200, then the mobile device will send ―Xinbei ^ check the poor material library to query the data, this message will be entrained to the action at the same time The identification information of the device type, the back-end database and the back-end database, based on the user ’s query, take the presentation model of the corresponding device " emput 2 > At the time, its set of M-type watch sets 1 board as the material conversion, such as graphic format conversion, resolution conversion and =

Page 14 1220203 _ Case No. 91114464_ Year Month Day __ V. Description of the invention (11) The expression and the code conversion corresponding to this mobile device, so that it can be executed on different mobile devices, and then The result is integrated into a web page 208 that can be displayed by the mobile device used by the user, and this web page is temporarily stored on the back-end server. However, after the above webpage is generated, users can browse this webpage wirelessly on the mobile device and obtain the required information. Since this webpage is a webpage customized by the user, its main The purpose is also for the user to access the database or query it, and it can be displayed on the mobile device used by the user in real time, but the web page generated by the user customization can also choose to be open to other users Browse, or replace an original web page. The third figure shows a disclosed embodiment of the present invention, illustrating that a block diagram of an external device receiving data input by a user for displaying a web page, wherein an external device 30 may be a mobile phone 3 01, a personal digital assistant 30 2 or computer 3 0 3, used to accept data query commands entered by the user and display the data day and time. Next, the mobile personal online data real-time query system 32 of the present invention includes at least a display module 321, a Meta Data module 3 2 2, a database setting module 3 2 3, and a code generator 3 2 4 of which a display module 3 2 1 includes different presentation modules to correspond to different external devices 30. For example, the second presentation module 3 2 1 b is used to display data on the personal digital assistant 3 02.

The MetaData module 3 2 2 is used to explain how the format of the data stored in the database is set. With explanatory data, you can understand the information stored in the database. The database setting module 3 2 3 is used according to user settings

Page 15 1220203 _ Case No. 91114464 V. Description of the invention (12)

Correction Generate the corresponding database query language, and most automatically generate a web page containing a result. 4 裎 code generator 3 2 4 is used

In addition, for the determination of the type of mobile device, the relevant information sent by the browser is incorrectly obtained by obtaining the mobile device. As shown in the fourth figure, when the user utters a sentence of a mobile device using the communication protocol on the wireless network TCP / IP, the browser protocol on the mobile device 400 is transmitted through HTTPD communication. = Transmission, such as the browser type, version, and compatibility of the HTTPD communication. The information included in the transmitted information includes the 40 model and other information. It is transmitted to the communication system and mobile device group 410 according to the server included in HTTPD. Receiver's rendering mode category. At the same time, the second presentation mode V at the receiving end = mobile device 4. . On. This test program can get relevant information about mobile devices, such as browser version information, resolution information, etc. Since the data display formats supported by various mobile devices 400 are different, the present invention determines the corresponding presentation template 4 1 6 according to the identification information sent by the mobile device 400. After the mobile device 400 sends a set of identification information to the presentation module 4 10, the presentation module 4 10 starts to perform analysis and judgment according to various sub-informations. Among them, the presentation module 4 丨 〇 includes a conversion module 4 0 2, an analysis and judgment module 4 1 2 and a presentation template module 4 1 4 and the presentation template module 4 1 4 includes various types of presentation templates 4 1 6 . Among them, each type of presentation template 4 1 6 is composed of various different sub-elements 4 1 8, and the presentation module 4 10 will determine the appropriate sub-element 4 1 8 according to each sub-information.

Page 16 1220203 Case No. 91114464 Amendment V. Description of the invention (13) After combining the judgment results of Yuan's appropriate presentation template to synthesize each sub-information, '416 ° In one embodiment, a personal digital assistant is used as the mobile device 4 0 0 to explain that the identification information sent by the mobile device 400 includes sub-information such as "operating system type", "operating system version", "browser type", and "browser version". The sub-elements supported by the presentation template 4 1 6 in the presentation module 4 1 0 include "table", "table bar", "table style", "graphics", "text", "hyperlink" , "Hyperlink style", "Document language", and "Web components", etc. The content of "Web components" also includes text boxes, text areas, check boxes, option buttons, drop-down list boxes, and so on. Therefore, the presentation module 4 1 0 will obtain the most appropriate presentation template 4 1 6 based on the identification information of the mobile device 4 0 0 and the dynamically determined matching sub-elements 4 1 8. When the various sub-elements 4 1 8 in the presentation template represent various data and content to be transmitted back to the mobile device 4 0 0, each sub-element 418 has its own unique attributes, which respectively represent the sub-element 4 丨8 various characteristics. Therefore, the lean conversion method is to modify the attributes of the child elements 4 and 8 and to convert the corresponding child by the conversion module 4 0 2 in the presentation module 4 1 0 according to the item to be converted. The attributes of element 418, these include the graphic format 4 0 2 A, the solution is 1 π Λ ^ s ΐ turn 414 will be through the conversion module 40 2 to perform the sub-prime attribute _____ after the new child element 4 1 8. Make the best combination

Page 17 converts 402D and other years, data expression 4 ° 2C and code, ^ a ^ 4 The system will transmit the detection device 401 to the mobile device 400! 22〇2〇3 —__ Case No. 9111446 won ___ ^ --- 3 --- jti__ V. Description of the invention (14) Presentation model 4 1 6 when present. The data conversion performed in the present invention, for example, the graphic format 4 0 2 A, the resolution 4 0 2 B, the data expression 4 0 2 c, and the program 4 0 2 D are described as follows: the graphic format 4 0 2 A Conversion, as the graphics supported by various mobile devices 4 0 0 are different, so this conversion is to modify the properties of the graphic format in the graphic sub-element; the conversion of resolution 4 0 2 B is based on various mobile devices 4 The resolution displayed by 0 0 is not the same. According to the resolution information returned in the browser identification information, the attributes related to the resolution size in the relevant sub-elements can be converted, such as the font size of text or the Length and width, etc .; The conversion of data expression 4 0 2 C, according to various mobile devices 4 00's display and arrangement of text 'or table will vary with the hardware specifications of mobile device 4 00 (for example , Screen size, color, or black and white); and 'Code 4 2 D conversion, the code supported and displayed by various mobile devices 4 00 are not consistent, so according to the mobile device 4 0 0 return The identification information 'converts the attributes of the code in each sub-element into the same attribute properties uniformly, so that the presentation template 4 1 6 best matches the characteristics of the mobile device 4 0 〇 and the' formatted code is displayed on the mobile device 4 〇 〇 上. Therefore, in the comprehensive judgment of the identification information returned by the mobile device 400, the 'related to the type of operating system, the model and browser type of the mobile device 400, and so on, are related to the text style, color, and form columns. The number of sub-elements such as numbers and table styles 4 丨 8 is used to convert attributes, so that the presentation template 4 1 6 can be presented in the most appropriate way for the characteristics of the mobile device 4 00.

1220203 _ Case No. 91114464_ Year Month Date __ V. Description of the Invention (15) According to the above, the present invention provides a method for real-time editing, querying and accessing data on a mobile personal online, so that users can directly take action Real-time data access and query on the device, and automatically display in the best way according to the different mobile devices used by users. Therefore, users are not limited to the influence of geographical factors, nor are they restricted to the use of specific mobile devices to conform to the format of data display. The above is only a preferred embodiment of the present invention, and is not intended to limit the scope of patent application of the present invention. Any other equivalent changes or modifications made without departing from the spirit disclosed by the present invention shall be included in the following Within the scope of patent application.

Page 19 1220203 _Case No. 91114464_ Year Month Day __ Brief description of the diagram The first diagram is used to illustrate a flowchart of a preferred embodiment of the present invention; the second diagram is used to illustrate the present invention in processing display data to different actions The flowchart of the steps when the device is installed; the third diagram is a block diagram showing the external device accepting the data input by the user to display the webpage according to the embodiment disclosed by the present invention; and the fourth diagram is the disclosed embodiment according to the present invention In the embodiment, a schematic diagram of determining the type of a mobile device is obtained by obtaining relevant information sent by a browser on the mobile device. Representative symbols of the main parts: 1 0 0 ~ 1 1 4 Preferred implementation steps flow block 2 0 0 ~ 2 0 8 Process steps when displaying data to different mobile devices Box 30 External device 3 0 1 Mobile phone 3 0 2 Personal digital assistant 3 0 3 Computer 32 Mobile personal online data instant query system 3 2 1 Display module 3 2 1 a First presentation module 3 2 1 b Second presentation module

Page 20 1220203 Case No. 91114464 Revised diagrams Brief description 321c Second presentation module 322 Meta D ata module 323 Database fixing module 324 Program stone horse generator 400 Mobile device 401 Detection device 402 Conversion module Group 40 2A Graphic format 4 0 2B Resolution 4 0 2C Data expression 4 0 2D program Shima 410 Presentation module 412 Analysis and judgment module 414 Presentation template module 416 Presentation template 418 Sub-element

Page 21

Claims (1)

No. 91114464 Amendment date: Special request to fly on the fly 1 A method for real-time editing and access to data on a mobile device, including receiving a data access profile entered by a user on a mobile device; A database command corresponding to the data access profile; transmitting the database command to a back-end processing system, wherein the back-end processing system includes at least one database; the back-end processing system generates according to the database command A result, and a data page that can be read by the mobile device is generated according to the result, wherein different mobile devices have different data display formats for displaying on different mobile devices; and browsing the data page at On the mobile device. 2. The method for real-time editing and accessing data on a mobile device as described in item 1 of the scope of the patent application, wherein the above steps of generating a data page that can be read by the mobile device include at least: A mobile device type used by a user; reading a display template corresponding to one of the mobile device types, wherein different mobile device types need to apply different display templates to correctly display data; and combining the data generated by the database command As a result, an information page is generated with the display template. 3. For real-time editing on a mobile device as described in item 2 of the scope of patent application 1220203 _ Case No. 91114464_ Year Month Date__ VI. Application scope of patents and methods of accessing data, you can also choose to display the data in reports or charts. 4. The method for real-time editing and accessing data on a mobile device as described in item 1 of the scope of patent application, wherein the aforementioned user can use a boot wizard when entering a data access profile on the mobile device, It is used to guide the user to complete various settings of the data access profile. 5. The method for real-time editing and accessing data on a mobile device as described in item 1 of the scope of patent application, wherein the above mobile device has the function of wirelessly transmitting data. 6. The method for real-time editing and accessing data on a mobile device as described in item 5 of the scope of the patent application, wherein the above mobile device is a personal digital assistant device. 7. The method for real-time editing and accessing data on a mobile device as described in item 1 of the scope of patent application, wherein the above-mentioned data access profile contains at least the following information: a database name; an account number and password, Used to log into the database. 8. The method for real-time editing and accessing data on a mobile device as described in item 1 of the scope of patent application, wherein the above-mentioned data page is a web page. Page 23 1220203 _ Case No. 91114464_ Year Month Date _i ± ^ _ VI. Patent Application Scope 9. The method for real-time editing and access to data on a mobile device as described in item 1 of the patent application scope, where The aforementioned back-end processing system may further include a web server. 1 0. A method for converting data for display on different mobile devices, including: determining a type of mobile device used by a user; obtaining a data display format corresponding to the type of mobile device; performing according to the data display format A conversion of a data display format for generating a webpage that can be displayed on the mobile device type; displaying the webpage on the mobile device type. 1 1. The method for converting data described in item 10 of the scope of patent application for displaying on different mobile devices, wherein the conversion of the above-mentioned data display format includes at least: a graphic format conversion for converting a graphic into Formats that can be displayed on the mobile device; A resolution conversion is used to convert the screen resolution to display correctly on the mobile device. Page 24 1220203 Page