CN1885882A - Short message managing system based on embedded mobile data base - Google Patents
Short message managing system based on embedded mobile data base Download PDFInfo
- Publication number
- CN1885882A CN1885882A CN 200610028322 CN200610028322A CN1885882A CN 1885882 A CN1885882 A CN 1885882A CN 200610028322 CN200610028322 CN 200610028322 CN 200610028322 A CN200610028322 A CN 200610028322A CN 1885882 A CN1885882 A CN 1885882A
- Authority
- CN
- China
- Prior art keywords
- short message
- user
- database
- subsystem
- transaction
- 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
Abstract
The SMS management system based on embedded mobile database comprises: once receiving new information, the subsystem calls system to store information into the database; before storing SMS, the subsystem opens data to write data and close to database; once receiving user command, the affair subsystem opens database to execute command, returns result to top main control interface, and closes database, wherein the main control interface comprises some windows and buttons. This invention replaces traditional file management method, uses SQL language for query and management, and exchanges data conveniently.
Description
Technical field
What the present invention relates to is a kind of system of communication technical field, specifically is a kind of short message managing system based on embedded mobile data base.
Background technology
Mobile phone reception at present and the information major part that sends are kept on the SIM card of mobile phone, are subjected to the restriction of SIM memory capacity, and short message is had to often deletion to receive new information.The user is when opening inbox and outbox, and the content of the inside is to read from SIM card, and the user can't come the short message enquiry breath according to phone number, time and content.
Current also have the part mobile phone that short message is kept at (such as motorola L7 mobile phone) on the mobile phone, specifically the information that receives with sending can be kept at respectively in two different files of mobile phone file system, the user is when opening inbox and outbox, open this two different files respectively, show the short message of its preservation one by one.These mobile phones are realized fairly simple when handling the short message storage.The user can only browse the short message in inbox and the outbox in proper order, if short message is more, consult certain bar note can only a rule browse over, pretty troublesome.The user can't come the short message enquiry breath according to phone number, time and content.
According to new, do not find identical with theme of the present invention or similar bibliographical information as yet to looking into of prior art.
Summary of the invention
The objective of the invention is limitation, proposed a kind of short message managing system based on embedded mobile data base at the short message storage of present SIM cards of mobile phones.The present invention can carry out unified management to all short messages that receive and send.The user can often delete short message and the short message that receives and send is saved in the embedded database, the user can check that all are stored in the reception in the database and the short message of transmission, the user can inquire about the short message of inbox and outbox according to keywords such as phone number, time and contents, perhaps the combination according to these keywords comes the short message enquiry breath, the user also can inquire about and the note chat record of certain phone number according to time-sequencing, and the user can delete short message.
The present invention is achieved through the following technical solutions, and the present invention includes: storage subsystem, transaction subsystem, master control interface subsystem.
Storage subsystem is that the session services process of smart mobile phone is called this system sender's number, short message content and the transmitting time of the information that receives is saved in the database when receiving fresh information.Also calling this system when the success of transmission information is saved in note recipient number, the short message content of transmission, transmitting time in the database.Storage subsystem connects earlier before the storage short message opens data, writes data then, closes the turn-off data storehouse at last.
The transaction subsystem is the request of process user, and result is turned back to the master control interface subsystem on upper strata.User's request of handling comprises inquiry inbox, inquiry outbox, the inquiry note chat record to certain number, deletion information and inquire about according to phone number, time and content etc.The transaction subsystem connects earlier and opens database after receiving user command, and fill order and master control interface that the result is returned to the upper strata are closed the turn-off data storehouse at last then.
The master control interface subsystem is the master control interface that the user directly sees, the user can see inbox window, outbox window, note chat record window.Deletion, inquire button are topmost arranged.To show all information that receive according to time-sequencing when the user clicks inbox window, the user can delete information, also can be according to the short message of sender's number, time and content search inbox.To show all information that send according to time-sequencing when the user clicks the outbox window, the user can delete information, also can be according to the short message of recipient's number, time and content search outbox.The user will show the phone number tabulation in the window left side when clicking note chat record window, the right side shows the short message according to time-sequencing corresponding to all receptions and the transmission of left side phone number.The user can delete certain bar short message, also can delete all short messages of certain number correspondence.Originally based on the SMS query function ratio of file system a little less than, can only do simple inquiry, adopt data base administration after, can use SQL statement and do powerful query composition function.
Database of the present invention adopts embedded database, and storage is in internal memory or on the Flash permanent storage device.Compare with traditional short message supervision system based on file system, it is advantageous that unified Back ground Information management, adopt unified database storage model, solved at random based on filesystem information originally, redundancy is many, causes the problem of inconsistency of information easily.
The present invention adopts general database interface to be connected with outside, can easily data be imported and exported on PC or the Internet by database interface, has solved the skimble-scamble problem of exchanges data of short message.
Present many mobile phones directly are kept at short message that card is gone up and the bar number is few, can not inquire about etc.Innovative point of the present invention is all transmissions and the short message that receives are saved in the database, and the user can inquire about according to different keywords.The user can inquire about according to phone number, can inquire about according to the date, can perhaps inquire about according to the combination of keyword according to content search.
Among the present invention, Back ground Information adopts embedded database, replaces traditional file system management mode; Storage adopts management of database SQL statement and inquiry short message information in internal memory or permanent storage device, have powerful query composition function; Adopt database interface to import and export on the external equipment, have data exchanging function easily.
Database of the present invention adopts embedded database, takies that memory space is little, reliability is high, fail safe is good.Storage is in internal memory, write, read and inquiry velocity fast, the EMS memory occupation of embedded database is from two aspects, the one, database itself, resource overhead when promptly not having loading data, the 2nd, the expense that causes during deal with data, promptly be written into data after, to data upgrade, inquiry or memory source consumption that the deletion of database table, modification etc. are introduced.Database Systems take resource not only can reduce cost less significantly, can also vacate more memory source for other program, improves the overall performance and the reliability of system.
Description of drawings
Fig. 1 is the flow chart of short message managing system of the present invention
Fig. 2 is the actual treatment precedence diagram of short message management system of the present invention
Embodiment
As shown in Figure 1, the present invention includes: storage subsystem, transaction subsystem, master control interface subsystem.
Storage subsystem is that the session services process of smart mobile phone is called this system sender's number, short message content and the transmitting time of the information that receives is saved in the database when receiving fresh information, also calling this system when the success of transmission information is saved in note recipient number, the short message content of transmission, transmitting time in the database, storage subsystem connects earlier before the storage short message opens data, write data then, close the turn-off data storehouse at last;
The transaction subsystem is the request of process user, and result is turned back to the master control interface subsystem on upper strata, user's request of handling comprises inquiry inbox, inquiry outbox, inquires about the note chat record to certain number, deletion information and inquire about according to phone number, time and content, the transaction subsystem is after receiving user command, connect earlier and open database, fill order and master control interface that the result is returned to the upper strata are closed the turn-off data storehouse at last then;
The master control interface subsystem is the master control interface that the user directly sees, inbox window is arranged, the outbox window, note chat record window, deletion is topmost arranged, inquire button, when clicking inbox window, the user will show all information that receive according to time-sequencing, the user can delete information, also can be according to sender's number, the short message of time and content search inbox, when the user clicks the outbox window, with all information that send that show according to time-sequencing, the user equally can deletion information and according to recipient's number, the short message of time and content search outbox, the user is when clicking note chat record window, to show the phone number tabulation in the window left side, the right side shows the short message according to time-sequencing corresponding to all receptions and the transmission of left side phone number, the user can delete certain bar short message, also can delete all short messages of certain number correspondence.
As shown in Figure 2, the present invention in use, the user opens the short message managing system master control interface, master control interface has inbox window, outbox window, note chat record window.
When the user clicks inbox window, to inquire about the inbox order by interprocess communication and send to the transaction subsystem, resolve command after the transaction subsystem receives orders, connect and open database, carry out querying command, close the turn-off data storehouse, then result is returned to user interface and demonstration by interprocess communication: the content of sender's number, reception, time of reception.If user's deletion certain bar short message wherein.To delete the short message order by interprocess communication and send to the transaction subsystem, the order of transaction sub system analysis connects database, carries out delete command, closes the turn-off data storehouse.If user's input handset number or time or content are inquired about inbox, querying command sends to the transaction subsystem by interprocess communication, the transaction subsystem receives orders, resolve command, connect and open database, carry out querying command, close the turn-off data storehouse, then Query Result is returned to upper-layer user interface and demonstration.
When the user clicks the outbox window, to inquire about the outbox order by interprocess communication and send to the transaction subsystem, resolve command after the transaction subsystem receives orders, connect and open database, carry out querying command, close the turn-off data storehouse, then result is returned to user interface and demonstration by interprocess communication: the content of recipient's number, transmission, transmitting time.If user's deletion certain bar short message wherein.To delete the short message order by interprocess communication and send to the transaction subsystem, the order of transaction sub system analysis connects database, carries out delete command, closes the turn-off data storehouse.If user's input handset number or time or content are inquired about outbox, querying command sends to the transaction subsystem by interprocess communication, the transaction subsystem receives orders, resolve command, connect and open database, carry out querying command, close the turn-off data storehouse, then Query Result is returned to upper-layer user interface and demonstration.
When the user clicks note chat record window, by interprocess communication the order of short message enquiry chat record is sent to the transaction subsystem, resolve command after the transaction subsystem receives orders, connect and open database, carry out querying command, close the turn-off data storehouse, then result is returned to user interface by interprocess communication, show the phone number tabulation in the window left side, the right side shows corresponding to all transmissions according to time sequence of left side phone number and the short message of reception.If user's deletion is corresponding to certain bar note of certain number of left side.To delete the short message order by interprocess communication and send to the transaction subsystem, the order of transaction sub system analysis connects database, carries out delete command, closes the turn-off data storehouse.If certain phone number of user's deletion left side, the short message order that will delete phone number by interprocess communication sends to the transaction subsystem, and the transaction subsystem receives orders, resolve command, connect database, carry out delete command, close the turn-off data storehouse.All transmissions of this number and the short message of reception have so just been deleted.
Storage subsystem is that the session services process of smart mobile phone is called the sender number of this system with the information that receives when receiving fresh information, short message content, and transmitting time is saved in the database.When the success of transmission information, call this system with note recipient number, the short message content of transmission, transmitting time is saved in the database.Storage subsystem connects earlier before the storage short message opens data, writes data then, closes the turn-off data storehouse at last.
Database of the present invention adopts embedded database, storage is in internal memory, the EMS memory occupation of embedded database is from two aspects, the one, database itself, resource overhead when promptly not having loading data, the 2nd, the expense that causes during deal with data, promptly be written into data after, to data upgrade, inquiry or memory source consumption that the deletion of database table, modification etc. are introduced.
Claims (4)
1, a kind of short message managing system based on embedded mobile data base comprises: storage subsystem, transaction subsystem, master control interface subsystem is characterized in that:
Described storage subsystem, calling this system when receiving fresh information is saved in sender's number, short message content and the transmitting time of the information that receives in the database, also calling this system when the success of transmission information is saved in note recipient number, the short message content of transmission, transmitting time in the database, storage subsystem connects earlier before the storage short message opens data, write data then, close the turn-off data storehouse at last;
Described transaction subsystem is the request of process user, and result is turned back to the master control interface subsystem on upper strata, user's request of handling comprises inquiry inbox, inquiry outbox, inquires about the note chat record to certain number, deletion information and inquire about according to phone number, time and content, the transaction subsystem is after receiving user command, connect earlier and open database, fill order and master control interface that the result is returned to the upper strata are closed the turn-off data storehouse at last then;
Described master control interface subsystem is the master control interface that the user directly sees, inbox window is arranged, the outbox window, note chat record window, deletion is topmost arranged, inquire button, when clicking inbox window, the user will show all information that receive according to time-sequencing, the user can delete information, also can be according to sender's number, the short message of time and content search inbox, when the user clicks the outbox window, with all information that send that show according to time-sequencing, the user equally can deletion information and according to recipient's number, the short message of time and content search outbox, the user is when clicking note chat record window, to show the phone number tabulation in the window left side, the right side shows the short message according to time-sequencing corresponding to all receptions and the transmission of left side phone number, the user can delete certain bar short message, also can delete all short messages of certain number correspondence.
Above-mentioned database adopts embedded database, and storage is in internal memory or on the Flash permanent storage device.
2, short message managing system based on embedded mobile data base according to claim 1, it is characterized in that, described master control interface subsystem, adopt management of database SQL statement and inquiry short message information, when the user clicks inbox window on it, to inquire about the inbox order by interprocess communication and send to the transaction subsystem, resolve command after the transaction subsystem receives orders, connect and open database, carry out querying command, close the turn-off data storehouse, then result is returned to user interface and demonstration by interprocess communication: sender's number, the content that receives, time of reception; If user's deletion certain bar short message wherein will be deleted the short message order by interprocess communication and be sent to the transaction subsystem, the order of transaction sub system analysis connects database, carries out delete command, closes the turn-off data storehouse; If user's input handset number or time or content are inquired about inbox, querying command sends to the transaction subsystem by interprocess communication, the transaction subsystem receives orders, resolve command, connect and open database, carry out querying command, close the turn-off data storehouse, then Query Result is returned to upper-layer user interface and demonstration.
3, the short message managing system based on embedded mobile data base according to claim 1, it is characterized in that, described master control interface subsystem, when the user clicks outbox window on it, to inquire about the outbox order by interprocess communication and send to the transaction subsystem, resolve command after the transaction subsystem receives orders, connect and open database, carry out querying command, close the turn-off data storehouse, then result is returned to user interface and demonstration by interprocess communication: the content of recipient's number, transmission, transmitting time; If user's deletion certain bar short message wherein will be deleted the short message order by interprocess communication and be sent to the transaction subsystem, the order of transaction sub system analysis connects database, carries out delete command, closes the turn-off data storehouse; If user's input handset number or time or content are inquired about outbox, querying command sends to the transaction subsystem by interprocess communication, the transaction subsystem receives orders, resolve command, connect and open database, carry out querying command, close the turn-off data storehouse, then Query Result is returned to upper-layer user interface and demonstration.
4, the short message managing system based on embedded mobile data base according to claim 1 is characterized in that, system adopts general database interface to be connected with outside, data can be imported and exported on PC or the Internet by database interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610028322 CN1885882A (en) | 2006-06-29 | 2006-06-29 | Short message managing system based on embedded mobile data base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610028322 CN1885882A (en) | 2006-06-29 | 2006-06-29 | Short message managing system based on embedded mobile data base |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1885882A true CN1885882A (en) | 2006-12-27 |
Family
ID=37583852
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200610028322 Pending CN1885882A (en) | 2006-06-29 | 2006-06-29 | Short message managing system based on embedded mobile data base |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1885882A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102156700A (en) * | 2010-02-12 | 2011-08-17 | 华为技术有限公司 | Database accessing method and device and system |
| CN101571788B (en) * | 2008-04-30 | 2013-01-02 | 宏达国际电子股份有限公司 | Information browsing method, information browsing device and storage medium |
-
2006
- 2006-06-29 CN CN 200610028322 patent/CN1885882A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101571788B (en) * | 2008-04-30 | 2013-01-02 | 宏达国际电子股份有限公司 | Information browsing method, information browsing device and storage medium |
| CN102156700A (en) * | 2010-02-12 | 2011-08-17 | 华为技术有限公司 | Database accessing method and device and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104272694B (en) | For the system and method for the access based on the privately owned line stage for providing the USB device or local device for re-directing | |
| US9344555B2 (en) | Maintaining history information for a user across multiple types of end points | |
| CN101185007B (en) | Upload security scheme | |
| CN101080056B (en) | A management method and system of network browser collection folder of mobile terminal | |
| CN1658211A (en) | Recent contacts and items | |
| KR20100125325A (en) | Aggregated view of local and remote social information | |
| CN102075449A (en) | Method, device and terminal equipment for managing E-mails | |
| CN100378663C (en) | Method, system and module for dynamic downloading of applied programe to user identification | |
| CN106843770A (en) | A kind of distributed file system small file data storage, read method and device | |
| US20160306988A1 (en) | Providing secure access to data in mobile devices | |
| CN101330657A (en) | Address list system and implementing method thereof | |
| US20130310014A1 (en) | Method and Mobile Terminal for Storing Memo During Call | |
| CN103118138A (en) | Cloud service based message queue stream processing method | |
| CN108536617A (en) | Buffer memory management method, medium, system and electronic equipment | |
| CN103618824B (en) | Method and the mobile terminal of information transmission is carried out in address list program | |
| CN112199442A (en) | Distributed batch file downloading method and device, computer equipment and storage medium | |
| CN103580998A (en) | Method and device for sharing communication behavior information | |
| CN105701179B (en) | The form access method of distributed file system based on UniWhale | |
| CN115455058A (en) | Cache data processing method and device, computer equipment and storage medium | |
| CN105791552B (en) | A kind of SMS processing method, device and mobile terminal | |
| CN109446220B (en) | Express user-based customer service voice menu customization method and customization system | |
| CN1885882A (en) | Short message managing system based on embedded mobile data base | |
| CN1867106A (en) | System and method capable of ordering mail push | |
| CN101404797B (en) | Storage method, storage management apparatus and storage system for long and short messages | |
| US6473496B1 (en) | Method for handling telephone commands |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |