CN1149224A - Data processing method and system installation for wireless channel database - Google Patents
Data processing method and system installation for wireless channel database Download PDFInfo
- Publication number
- CN1149224A CN1149224A CN 96102849 CN96102849A CN1149224A CN 1149224 A CN1149224 A CN 1149224A CN 96102849 CN96102849 CN 96102849 CN 96102849 A CN96102849 A CN 96102849A CN 1149224 A CN1149224 A CN 1149224A
- Authority
- CN
- China
- Prior art keywords
- information
- data
- database
- user
- record
- 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
Images
Landscapes
- Mobile Radio Communication Systems (AREA)
Abstract
A data processing method for database using wireless channel and its system features that the user terminal of the database is composed of two or more indepdendent microcomputers with wireless receiver and same database copy is loaded in these icrocomputers. The information providers over telephone network and data network and the information editing and managing terminals at central stationb roadcast data to all database users terminals via wireless channel and add, update and delete information to or from database. The information in the database at any user terminal can be queried or indexed.
Description
The invention belongs to the digital information transmission field, the data processing method and the system equipment that relate to a kind of wireless channel database, especially by the information editing office terminal by radio broadcasting one-way transmission information data and order with the information content in team control mode unified management total user data storehouse: create subdata base, append, cover and upgrade, the information record of delete database, designated key words and phrases in a plurality of records of batch modification, data reorganize, revise the user radio receiver and receive the authority password, upgrade the Database Systems of data base server, this Database Systems are used for tourism, traffic, finance, information services such as market.
At present, China is many to relate to the networking data storehouse systems of urban information service, because the restriction of communication line transmittability, information gathering is slow on the one hand, and institute's canned data can not time update, has influenced the information quality of database; Need the user of information can not in time obtain from database again on the other hand, influenced the range of application of database.When market economy information and urban service information are provided to the public because contain much information, information change is fast, validity information is short, makes the collection of information and safeguards difficultly more, becomes a difficult problem in Information System configuration and the information service.For example, tourism, traffic, directory information, Social Culture physical culture, market economy. information service data storehouses such as activity all are difficult to real-time typing, modification and extensively provide to society, can not satisfy the demand of society.
Though the user can directly safeguard, revise content relevant with it in the database by telephone network, data network, at this moment the communication interface of database not only will satisfy the requirement that the user directly imported, revised self information, also wants to satisfy the requirement that other users in time extract amended fresh information.Number of users is big more, when information updating is fast more, the growth that the load of communication interface also can be at double, the user will directly influence the unimpeded of interface to the wilderness demand of information.The database that relates to economy and city real time information service must take up to a hundred circuits when using telephone network, system's investment is increased.Networking operates in technical difficulty, has also influenced its extensive use.
For addressing this problem, some wireless paging stations transmit information on services to the Chinese character beep-pager, though coverage reaches the entire city suburb, it is very inconvenient that beep-pager reads information, and the capacity of beep-pager has limited the quantity of information issue again.Even with beep-pager tandem connection monitor device, perhaps large electronic display, become the call terminal that has enlarged display screen, also can only show information as a contiguous file, perhaps message file paging roll display, timing are revised and refreshed, this beep-pager or call terminal still do not have the inquiry service function of database.
Aspect the Financial Information service, used information such as satellite data channel radio quotations on the stock market, futures, the exchange rate, the receiving station of these information spreads all over the country, and quantity is above 2000.Institute's information transmitted generally is divided into data form and literal two classes, and some forms and literal constitute a packet, sends as an one piece.After packet is received by receiving station, revert to original form, written form.This type of information constantly splices with the pattern of chronological file at user side, and as the continuous data file storage, the user can be by the issuing time or the classification retrieval of information.In addition, the computer of existing teletext system receives working method, equally with the form of packet to users broadcasting information and application program.These two kinds of systems do not have the function of stored information in management, the control subscriber computer, do not have the essential characteristic of database yet.
When using said system to carry out the information broadcast service of the Chinese character large information capacity more than word every days 500,000, domestic consumer's hard disc of computer will be filled in 3 months, the system requirements user regularly revises and puts in order the content of being stored, reserve enough memory spaces for receiving fresh information, data broadcasting could carry out smoothly.But because the arrangement memory contents is a numerous and diverse job, it is inconvenient requiring all users in time to adjust memory contents synchronously.
Thereby, the present invention proposes mode by information centre's station unified management subscriber computer information stores content, central station not only per diem transmits fresh information to the user, but also user's data-base content will be arranged by wireless remote control mode administrative institute.Control command is transferred to subscriber computer by wireless channel, modification, deletion are appended, are covered in the unification of fulfillment database information, the user is as long as receive on time, at any time can both under off-line state, arbitrarily inquire about the information in the own database, do not need oneself to carry out other database maintenance work, so just proposing a kind of new mode of operation aspect the application and service of database.The present invention changes into " information flow " pattern of continuous transmission with traditional visit central database pattern, has realized the compiling of information, propagation and information sharing by information flow.
The purpose of this invention is to provide a kind of data structure and data processing method and system equipment that utilizes the wireless channel broadcast message and carry out database maintenance, make database can accelerate penetration and promotion, satisfy society the search request of information and carrying out of information service industry.
The objective of the invention is to realize by following technical proposals:
The information source owner focuses on the information centre station by telephone network, data network with information, central station carries out the information editing according to the data-base recording form, information data is transferred to customer data base in the wireless signal area of coverage in the One-to-All Broadcast mode, and the user opens receiver every day on time and computer power supply just can receive new information.
Specifically by the information centre station that comprises information editing office terminal, wireless transmitting station, main line input interface with have that the customer data base of wireless receiver forms, utilize the data processing method of the Database Systems of wireless channel broadcasting unidirectional transmitting data information to realize.
Main line input interface 56 links with the communication interface of information editing office terminal 50, the communication interface of information editing office terminal 50 and transmitter 60 link, described main line input interface 56 comprises multiplex telephony subscribers feeder audio input interface and voice data change-over circuit, the multi-channel modem communication interface, three input branch roads of calling telephone number receiving circuit, information from telephone network input and 50 direct typings in the information editing office terminal, editor through the information editing office terminal, handling the back is sent to user terminal data storehouse 11-1G with broadcast mode by wireless transmitting station 60, a plurality of subdata bases are arranged in Computer Database, come the logical construction relation of database of descriptions with the logical tables file, the sequence number of logical tables file is Er, r is the positive integer greater than 1, the title of logical tables file Er is record N1, its data item is A1, A2, A3...An, the data entries that is stored among the logical tables file En is record N2, N3....Nm, its data item is B1, B2, B3.....Bn, data item sequence number be J1, J2....Jn
Above-mentioned information editing office terminal by radio broadcasting one-way transmission information data and order with the information content in team control mode unified management all customer data storehouse: create subdata base, append, cover the information record of renewal, delete database, designated key words and phrases in the batch modification record, data reorganize, revise the user radio receiver and receive authority password M, data base server upgrades
Described wireless channel database system, on the computer of the band wireless receiver that works alone more than its database evergreen chinquapin shellfish to two, the supplier who allows information source by telephone set, computer, with wired and wireless points point to-point communication mode to information centre's sink information of standing, modification, deletion are appended, covered in the information editing office terminal at information centre station with the radio broadcasting mode to all database user terminal transmission with to customer data base canned data with these information, and the user of database can arbitrarily carry out consulting and retrieving of information.Described wireless channel database system is made up of information centre station and database user terminal two parts, the radio band that wireless transmitting station can use paging, broadcasting, satellite communication etc. to allow to carry out data communication, information centre's station part comprises: main line input interface 56, information editing office terminal 50, wireless transmitting station 60; User terminal partly comprises: intelligence receiver 20, computer and database 90, intelligence receiver have reception data temporary storage.
Category information in the database is to comprise various information on services from the file of keyboard operation inquiry; Another kind of information is the Notice Board Information that is made of F file.F file transmits, appends, covers modification, deletion equally with the out of Memory file, and when the computer keyboard of database was not touched within a certain period of time, notice board can be by the page that gives fixed order and F file of interval Automatic Cycle demonstration; In case any one button is touched, the demonstration of notice board will stop, and pick up counting again.
Described data processing method rule is as follows:
(1) a plurality of subdata bases is arranged in Computer Database, come the logical construction relation of database of descriptions with the logical tables file, sequence number is subdata base of logical tables representation of file of Er, r is the positive integer greater than 1, the title of form document Er is record N1, and each unit A1, A2 of N1, A3...An respectively are a data item; The data entries that is stored in each row among the logical tables file E is called record N2, N3....Nm, and its data item is B1, B2, B3.....Bn, and all E, the N in the data base logic form is unique;
Each category information service item in the user terminal data storehouse is a subdata base, represent with a logical tables file Er, the title of this document and each row content are all as single record, and the logical tables file is divided into some row, and the element that belongs to each row in each record is a data item; Each data item Bn of every capable content of file Er is with respect to the data item An of the same row of logical tables title, and data item B content can be numeral or literal;
Row sequence number J according to control command C, sequence number N and data item can directly append, deletes, cover the modification designated recorder to customer data base by the editorial management terminal by transmission system, or modification arbitrary data item wherein, revise effective equally to the database replisome;
(2) transmitting station when the user sends information to be recorded as base unit, a plurality of information records constitute a batch information, and each batch information will be titled with address code D, reception authority password M, message sequence number T, control command C and database sequence number E, the LSN N of user profile receiver 100;
The information of control command C decision broadcasting arrives after the customer data base the appending, cover and upgrade and the deletion designated recorder of record or data item, retrieves and revises, deletes comprising the bulk data item of specifying words;
Each intelligence receiver has a lifelong address code D and a reception authority password M relevant with the viability;
Message sequence number T is the flowing water code name of giving when sending each batch information, T is the consecution natural number since 1, whether the customer data base terminal message sequence number that verification receives according to sequence number T is complete, show and leak the message sequence number Ti that receives, receive when information is reissued at the information centre station and leak the information Ti that receives, the introducing of sequence number T is in order to guarantee that in uni-directional wireless broadcasting all users are not because of the accident drop-out;
(3) transmitting station is divided into basic format and data packet format to the information record format that the user sends
During transmission wall scroll record, use basic format:
User code D+ receives authority password M+ message sequence number T+ control command C+ database sequence number En+ data-base recording sequence number N+ logical tables title A or content B+ information retention date S;
Logical tables title A or content B can adopt continuation mode or indexed mode;
Continuation mode is promptly: ##A1*A2*A3*....*An#** or
##B1*B2*B3?*....*Bn#**
The data item sequence number y of logical tables file is the positive integer from 1 to n, and n is total columns of logical tables;
An, Bn are the numerical value of each data item, and all numerical value all will send successively during continuation mode, and the vacancy value is 0;
##: the prompt that continuation mode is described;
Indexed mode is promptly: * * J1*A1#J2*A2...#Jy*Ay#** or
**J1*B1#J2*B2...#Jy*By#**
J is the data item sequence number of logical tables file, and the Jy of indexed mode is the row sequence number of each data item that will revise;
An, Bn are the data item numerical value that will revise, and the numerical value of not revising is default, need not send;
*: the prompt that indexed mode is described;
#**: the prompt that transmission log finishes is described.
When transmitting the batch information of many record formations, use data packet format:
User code D+ receives authority password M+ message sequence number T+ control command C+ database sequence number E+ LSN N+ logical tables title Ay or content By+ information retention date Sy+......+ data-base recording sequence number N+ logical tables content Bn+ information retention date Sn;
(4) the reception program of intelligence receiver 100 is checked user code D, the reception authority password M of each batch information;
The data that are transferred to Computer Database are: message sequence number T, control command C, database sequence number E, LSN N, logical tables title A or content B, information retention time S, data before the data item A that receives at last in the record in user terminal data storehouse, B content can cover, information retention time S in same record as a data item;
Customer data base has been installed the signal procedure with the wireless receiver cooperating, and when receiver was sent " data send be ready to " sign here, computer was answered " reception DSR " sign, begins subsequently to receive and to the database transmissions data;
(5) user that has the right has oneself information record Nn in database, and available phone machine, computer with oneself A, B data item by telephone network, oppositely wireless channel is delivered to information centre's station phone automatic relay interface in point-to-point mode, by being wirelessly broadcast to all user terminal data storehouses, the record Nn of oneself is upgraded again;
(6) the information editing office terminal 50 at transmitting station information centre station sends the combination of a plurality of record N in batch, when receiver divorced from computer database receives separately, every batch information maximum amount of data is not more than the reception data temporary storage capacity of intelligence receiver, when online again with input database of data; During the online reception data of intelligence receiver, the information packet that receives directly is transferred to the appointed area of computer 90 internal memories, receiver continues to receive next packet simultaneously, the capacity of the reception data buffer 43 of receiver is greater than the twice of each packet, to adapt to the requirement of changeing while receiving;
(7) record in the user terminal data storehouse determines memory time by its information retention time S, and S is applicable to the information of having determined effective time in advance, and this is recorded in the database and removes automatically after surpassing S memory time, and the record of default parameter S will keep for a long time;
Information retention time S has 2 kinds of expression forms: with the S digital value of the moon, day numeric representation, as June 7 be 0607; With the parameter value of character, numeral, as S001, S002, S003....S999.By control program operation, to sending to S parameter value date value assignment selected in the customer data base, make its digital value S have same effect with target date, the data item that control command can also be indicated selected S parameter be deleted;
(8) information centre station uses control command C to decide information to append, delete, cover modification in customer data base, append, when deleting, the sequence number N of information record also writes with deleted thereupon;
(9) information centre station uses control program and crucial words and phrases to retrieve X contiguous items that writes down in the customer data base, and controls deletion, the modification of these data item, and X equals, greater than 1.
Wireless database system is that an information is concentrated and system is provided, and it can gather information on services in real time, and the user is identical in the effect of arbitrary database terminal Query Information.
The present invention to market economy and urban information service be a kind of practicality, efficient, cover face width, be suitable for the information service system that the public uses, its investment is 1/tens of traditional networking data storehouse, system's small investment, build fast, Operation and Maintenance is simple, contain much information, made full use of radio frequency resources, existing computer and network technologies have been made full use of, the technology of system's promotion and implementation, economic difficulty are little, are the systems of a kind of suitable Chinese society applied environment.
After the present invention finishes practicability, following advantage is arranged:
1. integrated data store is changed into distributed data base, the wide coverage of information broadcast, cost is low, inquiry need not connect telephone network, can be in urban and urual areas of whole country, mountain area, island set up thousands of customer data base terminals, help the popularization and application of database, utilize its investment of national wireless database of satellite channel only to be 10% of some areas database;
2. the Chinese character information of 30-50 more than ten thousand can be provided every day, and customer data base can keep 2000-3000 ten thousand Chinese character information memory spaces, has reached the function of centralized data base.Information all provides to the user, directly participation information of user issue, upgrade, not only help user inquiring, also help improve the user to the information centre station provide, the enthusiasm of sink information, system helps compiling of information resources, and the acceleration that helps database starts;
3. database has the information centre station to safeguard, upgrade, and does not need user management, and the user does not need special training study, has not only improved the information quality of database, has also improved the utilance of computer;
4. because the system cost reduction, do not need the support of telephone network, can be AT STATION, ground such as airport, market, crossing, park, exhibition center, post and telecommunications office found the low price business service of database terminal, this is that the operation of cable network data storehouse is never accomplished for many years.
The present invention has the following drawings:
Fig. 1. the wireless channel database system block diagram
Fig. 2. logical tables file structure block diagram
Fig. 3. the user sends data item option log form
Fig. 4. transmitting station information centre transmits information format in the station
Fig. 5. transmitting station information centre station system block diagram
Fig. 6. the intelligence receiver logic diagram
Fig. 7. satellite channel Database Systems block diagram
Fig. 8. information editing office terminal program flow diagram
Fig. 9. the receiver program flow diagram
Figure 10. customer data base signal procedure flow chart
Figure 11. customer data base polling routine flow chart
Describe the solution of the present invention in detail below in conjunction with embodiment one and accompanying drawing, the wireless transmitting station of embodiment uses radio call frequency range and system of paging centers.
Urban service information can be divided into multidate information, short term information and long-term information, multidate information mainly transmits at any time by telephone network and wireless point-to-point channel, and wireless point-to-point channel is meant equipment such as the subscriber channel, private radio terminal of mobile phone, two-way paging channel.Short term information and long-term information also can be delivered to database information administrative center with the information manuscript by the user except that being revised at any time, increase with aforesaid way by information providing unit, send in batch behind typing, editor.Short term information needs descriptive information retention date S, surpasses the record of retention time S, and database can be deleted automatically.The information of retention date can not be described in advance, can use the mode of giving special parameter to delete S.The S of multidate information and long-term information can be specified constant or default.Subscriber computer is in night, holiday when shutting down, receiver Autoattendant, and broadcast information can not surpass the data temporary storage heap(ed) capacity of intelligence receiver.System sends data volume every day and is not less than 10,000 Chinese characters, and the Chinese character quantity that customer data base is preserved is no less than 5,000,000 words.
Referring to accompanying drawing 1. is the wireless channel database system block diagram, and frame of broken lines 20 is a 21-2N information providing unit among the figure, and frame of broken lines 10 is a 11k 1G user terminal, frame 30 is a local network, frame 56 is the main line input interface, and frame 50 is the information editing office terminal, and frame 60 is a transmitting station.
Referring to accompanying drawing 2, be logical tables file E, each information on services classification can represent that in computer the title of logical tables file is the first row N1 of form with a logical tables file Er, its data item is A1, A2, A3...An; The information record that row such as the N2 of logical tables file, N3....Nm are made up of data item B1, B2, B3.....Bn respectively.During transmission information record, the total data item be can transmit continuously, also can under the prompting of data item sequence number Jn, the index of reference mode corresponding An, Bn be transmitted.
The sequence number N of data-base recording is 50 generations in the information editing office terminal, and the rear side phone number that obtains from main line directly is converted to LSN, or change according to the password that the user keys on telephone set, computer.The data that send enter the table content B that customer data base is revised respective record N then in paging centers's server queuing back broadcasting.The transmission of above-mentioned telephone number is identical with the mode of automatic paging platform transmitting and displaying calling telephone number.
Referring to accompanying drawing 3, the user sends data item option log form, and the information record of each data entries occupies delegation, and the data item that the user often will issue is logined in table.The B2 that N2 is capable, B3 as shown in Figure 3, the B1 that N3 is capable, the B3 that Nm is capable, B4.When transmission information write down, the user can be only to information editing office terminal transmission selected data item.For example, hotel information is only transmitted vacant the number in certain several guest room, and the remainder data item all skips over.Information editing office terminal 50 is guiding character and data item sequence numbers such as stack D, M, T automatically, enter the corresponding content B of user's computer database update logical tables respective record N through wireless channel.When sending the default sequence number of data item, customer data base can be revised the selected data item according to stored data items option log form.This information transmission mode has not only reduced user's operation of the information that sends, and has also saved the holding time of wireless channel.
When the user uses telephone key to send digital information, except that the user sends data item option log form predetermined data item, also can select for use continuously and indexed mode:
Continuation mode, the information record of each data entries occupies delegation, uses
## the 1st numerical value+* the 2nd numerical value+... ...+* n numerical value
+#**
Indexed mode sends not coordinate time of indivedual numerals or numeral:
The 1st data item of *+y data item of * numerical value 1+.......#
+ * numerical value y+#**
Y is the positive integer from 1 to n.
Available area bit code, telegraph code etc. are transferred to paging centers information editing office terminal 50 with Chinese character when using a computer communication.
All logical tables file formats, user profile clauses and subclauses and the LSN N table of comparisons, user that customer data base has been stored in information editing office terminal 50 send data item option log form etc.
Referring to accompanying drawing 4, the transmitting station Center For Information Management to the form that the customer data base terminal transmits information is: intelligence receiver address code D, reception authority password M, message sequence number T, control command C, logical tables sequence number E, data-base recording sequence number N, logical tables title A or content B, information retention time S;
Intelligence receiver is checked address code D earlier and is received authority password M, receives to continue reception information batch sequence number T, control command C, logical tables sequence number E, data-base recording sequence number N, logical tables title A or content B, information retention date S when correct.Above-mentioned each code all is made up of some bytes, and each byte is made up of 2 16 system characters.Address code D, reception authority password M, information batch sequence number T, data item LSN N are 6 numerals of 3 bytes.Control command C is 2 bytes, and first byte is 2 characters among the 11H-15H, and second byte is 2 numerals, the kind sequence number of representative order.Information retention date S is 2 bytes, and with 4 numerals, each 2 of the moon, days, when S represented with parameter value, first character was 1 character among the 11H-15H when date value was represented, the back has 3 numerals.
Referring to accompanying drawing 5, be transmitting station Information Management Department subsystem block diagram, comprise r bar telephone wire audio input interface 521-52r at the main line input interface frame 56 described in the accompanying drawing 1, audio frequency receives change-over circuit 531-53r, and the phone data input interface 511-51q of band modem, intelligent multichannel interface 55 and calling telephone number receiving circuit 54, it can handle the information that a plurality of users transmit simultaneously, the audio signal of its input receives change-over circuit 531-53r by audio frequency and is converted to data-signal, frame 50 is the information editing office terminal that comprises information editing's management software, the queuing server 57 of it and main line input interface 56 and transmitting station links, 58 is the computer keyboard of information editing office terminal, 59 is the floppy disk of information editing office terminal, 60 is transmitting station, and 68 is the transmitting station antenna;
Information providing unit can be changed the multidate information of oneself at any time, connect the phone automatic relay interface 56 of transmitting station, press logical tables data item order and send multidate informations such as multidate information data, particularly hotel berth, the price of oneself, financial stock market, credit card code name with telephone set or computer button.According to the requirement of the data structure and the data processing method of system, information editing office terminal 50 adds information data the guiding character of system requirements automatically, delivers to queuing server 57 then and waits for antenna 68 emissions from transmitting station 60.Information can be imported, be read in to the keyboard 58 and the driver 59 of information editing office terminal.
The user can be by the terminal equipment classification of using for convenience in actual use, and telephone set and computer respectively use 1 phone to reelect number, and intelligent multichannel interface 55 uses the General Multiplex interface that microprocessor is arranged.Local Exchange's stored-program control exchange is sent calling telephone number here from Leased line, received by calling telephone number receiving circuit 54.When Local Exchange did not provide calling telephone number, the system requirements user key-press was entered password after the connection circuit, and password is by the routine processes of information editing office terminal.The information publisher connects the information centre station, keys in the multidate information data according to data item option log form predetermined data item.Referring to accompanying drawing 8, information editing office terminal program flow diagram.
Referring to accompanying drawing 6, be the intelligence receiver logic diagram, intelligence receiver comprises that high frequency receiving circuit 41, data separation circuit 42, data temporary storage 43, digital register 44, digital comparison circuit 45, communications status register 46, communication control circuit 47, the computer that links with it are 90, and digital register 44 is used for depositing receiver address code D, the user that has the right receives authority password M.Intelligence receiver is as beep-pager, and the data that comparison circuit 45 is received the D in the digital register 44, M numerical value and data temporary storage 43 allow memory 43 to continue to receive data when both compare unanimity.After message pick-up was finished, the data T that is received, C, E, N, A, B, S were temporary in data temporary storage 43, and communications status register 46 is sent the communications status sign of " data send and are ready to " to computer.When it receives the Status Flag of " reception DSR " of computer, be about to whole temporal datas and be sent to computer.When computer shutdown or off-duty database, the information that receives is temporarily stored in the register 43 always, waits for the Status Flag of computer " reception DSR ".For making intelligence receiver preserve information reliably, its data storage will have enough capacity, and memory space is 10,000 Chinese characters in an embodiment.In addition, system has the power of alterating and direct current of providing for oneself 48.Referring to accompanying drawing 9, the receiver program flow diagram.
User terminal computer is when query State, and intelligence receiver receives fresh information, user terminal can the interrupt inquiry state automatically with the information input data storehouse of intelligence receiver, return query State again after revising each record;
Because system uses broadcast mode, can not guarantee that all users can both successfully receive every information of one-way transmission, particularly can not solve the leakage that receives interference, equipment, power failure and artificial origin and receive phenomenon.For this reason.System just transmits to computer when verification is correct in the information of receiving; In addition also be provided with message sequence number T, T is the flowing water sequence number of transmission information, if take place to leak receive, the sequence number that the user terminal data storehouse will lack to user prompt is convenient to check, reissue.Referring to accompanying drawing 10, customer data base signal procedure flow chart.
Customer data base has F Notice Board Information file, and when the computer keyboard of database was not touched within a certain period of time, notice board can be by the page that gives fixed order and F file of interval Automatic Cycle demonstration; In case any one button is touched, the demonstration of notice board will stop, and pick up counting again.Referring to accompanying drawing 11, customer data base polling routine flow chart.
The address D of wireless messages receiver can receive to be grouied busy and group calling information: group busy at all users, group calling information is by the thematic information classification, group busy with group calling the authority of reception password is all arranged, receive the rights management that the authority password is used for information that the user is received, can use and have the replaceable chip that receives the authority password, as the address chip of some beep-pager, its information format and data processing method are determined by unit of operation.
Below in conjunction with embodiment two and description of drawings the present invention, the wireless transmitting station of embodiment uses satellite broadcasting frequency range and system of unidirectional receiving station.
Referring to accompanying drawing 7, be satellite channel wireless database system block diagram, this figure and Fig. 1 are in full accord on principle, have just replaced terrestrial wireless system with satellite system.Frame of broken lines 20 still is a 21-2N information providing unit among the figure, and frame of broken lines 10 still is 11-1G user's receiving terminal, and frame 50 is the information editing office terminal, all less than changing.Frame of broken lines 71 usefulness packet data switched network have replaced telephone network, and frame 60 is the satellites transmits station.Satellite information network is the specialized network in the face of nationwide service, and receiver and computer all require Attended mode, according to unified maintenance requirement operation.
The information that the user sends gathers arrival information editing office terminal by Packet Based Network, to all intelligence receiver broadcasting, enters subscriber computer database update respective record with broadcast mode then.System's broadcasting amount every day can reach 30-50 ten thousand Chinese characters, and customer data base can keep at least 3,000 ten thousand Chinese characters, has realized that with centralized traditional database transition be distributed broadcast database.
Information editing office terminal in the accompanying drawing 7 receives the user data information that the subscriber channel of the telephone network that links by the electronic mail system on Packet Based Network and the Packet Based Network, with Packet Based Network, satellite two-way channel transmits, and the message file through editor is transferred to satellites transmits station 60
Information centre's station editorial management terminal is seen accompanying drawing 4 to the form that the customer data base terminal transmits information;
Satellite receiver and subscriber computer database link, and satellite receiver receives message file according to address code D and reception authority password M, and the data that intelligence receiver receives directly are transferred to Computer Database by standard interface.
System is fair customer data base while Query Database content when the input fresh information,
The information editing office terminal at information centre station is carried out following operation with control command C to customer data base:
1. append information
The information editing office terminal is the information format layout of the fresh information of Np-Nq according to accompanying drawing 6 with sequence number, and C1 is transferred to receiving station with information packet with control command, and Computer Database increases the Np-Nq data item thereupon.This is the basic function of system, every day can according to the information column timesharing successively transmission capacity be the packet of 5-10 ten thousand words, be applicable to the issue of integrated information;
2. covering lastest imformation
With the sequence number that had sent is the information layout again of Nr-Ns, adds packet then and sends, and C2 is transferred to Computer Database with control command, and covering the sequence number that has existed is the information data item of Nr-Ns.This function is applicable to the multidate information issue of set form, and for example every day, airline ticket was sold information, can cover renewal at any time;
3. deletion information
With the sequence number that sent is the information of Np, adds packet and sends, be transferred to customer data base with control command C3 after, sequence number is the information data item of Np, comprises that sequence number is deleted.This function is applicable to disposable information issue, and for example, personnel recruitment will in time be deleted after information on bidding is out-of-date;
4. revise the user and receive authority password M
The user that information centre uses control command C4 to revise intelligence receiver in the station receives authority password M.When system carries out paid service, in order to guarantee regularly to collect service charge, the receiving function of the receiver user of must in time not pay dues;
5. to the subprogram of customer data base transmission, renewal, delete database
Control command C5, C6, the C7 subprogram to customer data base transmission, renewal, delete database is used at information centre station.After system began commercial service, because number of users is many, it was wide to distribute, and when system update software, should be undertaken by Network Transmission.At present this technology has been used in some wired networking data storehouses, but can only once be transferred to a user, native system can be once to the subprogram in all user's updating user data storehouses;
6. the storage area data of controlling database reorganizes
Information centre station uses the control command C8 storage area data of controlling database to reorganize;
7. information data item retrieval words is replaced, is deleted
Information centre station uses control command and crucial words and phrases to retrieve X the record that comprises contiguous items in the customer data base, controls these data item and replaces, deletes, and X equals, greater than 1.
The crucial words and phrases that control command C9 controls database in the relative recording are replaced, at this moment data item is retrieval words and modification words, sequence number N and information date saved S are default, after the retrieval words is transferred to Computer Database, the control command startup subroutine is retrieved out with the relevant data item, prime information is replaced with revising words by the requirement of control command then;
The control database deletion of relative recording of control command C10, at this moment data item is the retrieval words, it is default to revise words, sequence number N and information date saved S, after the retrieval words is transferred to Computer Database, the control command startup subroutine is retrieved out with the relevant data item, by the requirement of control command these data item is deleted then;
This function is applicable to the bulk information modification, for example: " phone: 01-" changed into " phone: 010-", be fit to the automatic modification of large quantities of information.Native system uses the words of present Computerized Editing software to replace function, will replace function by the operation automatically under the control command operation of database subprogram;
8. information is regularly deleted
With sequence number is the information format layout of the fresh information of Np-Nq according to accompanying drawing 4, its information date saved S is the date data of predetermined deletion, after information is transferred to Computer Database with control command C1, C2, when fixed date arrives, when database start operation, automatically this a collection of outdated information is all deleted;
Sequence number is the fresh information of Np-Nq, its information date saved can't be determined when editor, it is parameter S that the information date saved is fixed tentatively, when deleting this a collection of information, from editor terminal transmitting control commands C11 and parameter value S, database is searched for all data item that the S parameter is arranged after receiving control command automatically, and with relevant record deletion;
Sequence number is the fresh information of Np-Nq, its information date saved can't be determined when editor, it is parameter S that the information date saved is fixed tentatively, determined to delete the day after date of this a collection of information, from editor terminal transmitting control commands C10, parameter value S and assignment date value, database is searched for all data item that the S parameter is arranged after receiving control command automatically, and its S is deleted the date value assignment with subscribing.Interim when the deletion date, database starting up Automatic Program is with relevant record deletion.This function is applicable to information of inviting outside investment, and when the trade and investment promotion purpose had reached, this a collection of information of being about to was all deleted.
The information of customer data base is except being increased, revised by the control of information collection center, can also adopt method by database timing, quantitative automatic deletion outdated information, promptly regulation is when database information reaches rating number, at first delete the information that enters database the earliest, this function is carried out by the hypervisor of customer data base, and the information temporary storage district of the commodity communication software that uses just has this function now.
The present invention is the structural change in traditional networking data storehouse, with communication network from being between information editing office terminal and database at the position change between database and the user terminal; Change two-way wireline communication network into the uni-directional wireless communication network; The individual data storehouse of concentrating is changed into a plurality of databases of distribution; When keeping database function, the full detail content delivery at information centre station in customer data base, make the information of database can be under the situation that breaks away from telephone network extensively, use fully.
Claims (4)
1. one kind by the information centre station that comprises information editing office terminal, wireless transmitting station, main line input interface with have that the customer data base of wireless receiver forms, utilize the data processing method of the Database Systems of wireless channel broadcasting unidirectional transmitting data information
Main line input interface [56] links with the communication interface of information editing office terminal [50], the communication interface of information editing office terminal [50] and transmitter [60] link, described main line input interface [56] comprises multiplex telephony subscribers feeder audio input interface and voice data change-over circuit, the multi-channel modem communication interface, three input branch roads of calling telephone number receiving circuit, from telephone network input with in information editing office terminal [50] the direct information of typing, editor through the information editing office terminal, handling the back is sent to user terminal data storehouse [11-1G] with broadcast mode by wireless transmitting station [60], a plurality of subdata bases are arranged in Computer Database, come the logical construction relation of database of descriptions with the logical tables file, the sequence number of logical tables file is Er, r is the positive integer greater than 1, the title of logical tables file Er is record N1, its data item is A1, A2, A3...An, the data entries that is stored among the logical tables file En is record N2, N3....Nm, its data item is B1, B2, B3.....Bn, data item sequence number be J1, J2....Jn
It is characterized in that above-mentioned information editing office terminal by radio broadcasting one-way transmission information data and order with the information content in team control mode unified management all customer data storehouse: create subdata base, append, cover the information record of renewal, delete database, designated key words and phrases in the batch modification record, data reorganize, revise the user radio receiver and receive authority password M, data base server upgrades
All logical tables file formats, user password and the data-base recording sequence number table of comparisons, user that customer data base has been stored in information editing office terminal [50] send data item option log form, with the program of management, maintenance customer's database, information editing office terminal [50] carry out control, management to customer data base by following step.
(1) information editing office terminal [50] are superimposed with record N, data item sequence number J and content A, the B of data entries the desired receiving equipment address D of wireless channel, receive authority password M, message sequence number T, control command C, database file name E, data item sequence number J can be default when transmitting complete record
(2) the control command C of information editing office terminal stack on the information record is character, digital form, control command C1, C2, C3 decision information appending, covering renewals, delete in customer data base, append, when deleting, the sequence number N of information record also writes with deleted thereupon
The user that information centre uses control command C4 to revise intelligence receiver in the station receives authority password M, and control command C5, C6, C7 are to customer data base transmission, renewal, deleted data library subroutine, and the C8 determination data reorganizes,
(3) the information editing office terminal uses control command and crucial words and phrases to retrieve X the record that comprises contiguous items in the customer data base, control command C9, C10 control the crucial words and phrases deletion in the relative recording in these records respectively, cover and revise, X equals, greater than 1
(4) the information record to database transmissions has information retention date data item S, determine the date numeral form S of the information use national Specification of information retention date in advance, the same day that the user terminal data storehouse is indicated by date digital value S by the automatic cancellation of S target date, the outdated information record, this operates in the user carries out when starting shooting automatically, the record of default parameter S will keep for a long time, retention time can not pre-determined information be used the parameter value S that represents with character numeral synthetic parameters form, concrete numerical value is S001-S999, after determining in the information deletion time, by the S character properties value usefulness deletion date assignment of transmitting control commands C11 to selecting, make its deletion automatically then, also can directly delete and have the information record of specifying the S parameter value with control command C12
2. Database Systems data processing method according to claim 1, it is characterized in that described information management terminal overlapped information sequence number T on information transmitted record N, on screen, show the leakage that the lacks breath sequence number T that collects mail by the reception program of database when the T that receives at customer data base is discontinuous, the prompting user notes, customer data base can only receive sequence number that message sequence number T (k+1) retransmits greater than the information of original sequence number Tk and information centre station less than the leakage of the Tk breath record of collecting mail
3. Database Systems data processing method according to claim 1, it is characterized in that described customer data base logical tables file En record following two kinds of display modes:
(1) routine data library inquiry display mode,
(2) notice board display mode, notice board can extract the content in F the form document of appointment, when computer keyboard is knocked, database begins reclocking, timing will show the content of F form document by predefined procedure and interval Automatic Cycle after surpassing the numerical value t0 that stipulates, be touched once more up to keyboard, and demonstration stops, the database reclocking
4. system equipment that is used for the Database Systems data processing method of utilizing wireless channel described in the claim 1 is characterized in that:
Described information centre station equipment comprises:
(1) the main line input interface [56] that comprises r bar telephone wire input interface [521-52r], a r audio frequency reception change-over circuit [531-53r] and q data interface [511-51q] can be handled audio signal and the data-signal that r+q user transmits simultaneously, and audio signal is converted to data format delivers to information editing office terminal [50], r and q for greater than, equal 0 natural number, r+q is more than or equal to 1
(2) the described information editing office terminal [50] that comprises information editing's management software, its communication interface links with server [57] with main line input interface [56] and transmitting station [60] respectively, the information data that needs send can be added the control character that transmitting station [60] requires, delivering to server [57] wait then launches from antenna [68], server [57] is to be the communication server in the wireless transmitting system of information service special use at wireless channel
(3) the described information editing office terminal [50] that comprises information editing's management software, its communication interface links with server [57] with main line input interface [56] and transmitting station [60] respectively, the information data that needs send can be added the control character that transmitter [60] requires, delivering to server [57] wait then launches from antenna [68], server [57] with the wireless transmitting system of paging service dual-purpose wireless channel in be the queuing server
(4) the calling telephone number receiving circuit [54] of the main line input interface [56] of transmitting station links with the automatic display device of calling telephone number of telephone office, when the telephone set of use appointment is imported the data item content of representing with audio signal, its calling telephone number is by receiving circuit [54], multichannel interface [55] is transferred to information editing office terminal [50], the user does not need to import the telephone number of use
The described user data library facilities that has wireless receiver comprises:
(1) the wireless messages receiver [100] that links with computer [90] in user terminal data storehouse has V to group busy address and this machine address, it has receive data register [43] address code D and the user that has the right receives authority password M register, according to the address code of grouping busy in the register, this machine address code and reception authority password M, the wireless data broadcasting signal that belongs to native system could continue to receive and be retained in the data storage, receive the authority password by forming with the individual corresponding byte section in address of grouping busy of V respectively, each grouies busy that the address is corresponding to 1 logical tables file, on service business, be called information column
(2) information data that the wireless messages receiver [100] that links with the user terminal data storehouse receives all is temporarily stored into the receive data buffer [43] of receiver; Finish accepting state backcasting machine and send the communications status sign of " data send and are ready to "; When receiver is received the Status Flag of " receive data is ready to " of computer [90]; Be about to temporary data and be sent to computer [90]; The capacity of the receive data buffer [43] of receiver is greater than the data volume of every a collection of transmission
(3) information data that receives of the wireless messages receiver [100] that links with the user terminal data storehouse all is temporarily stored into the reception data buffer [43] of receiver, when reaching packet of appointment, the data volume that receives sends the communications status sign of " data send and are ready to " to computer, when receiver is received the Status Flag of " reception DSR " of computer [90], be about to temporary data and be sent to computer [90], receiver continues to receive next packet simultaneously, the capacity of the reception data buffer [43] of receiver is greater than the twice of each packet
(4) user terminal computer is when query State, and intelligence receiver is not in order to influence the reception of fresh information, and user terminal can interrupt changing over to the reception program automatically, and the information of intelligence receiver is sent into database, revises and returns former query State after each writes down.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 96102849 CN1149224A (en) | 1995-04-10 | 1996-04-09 | Data processing method and system installation for wireless channel database |
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN95103676.9 | 1995-04-10 | ||
| CN95103676 | 1995-04-10 | ||
| CN 96102849 CN1149224A (en) | 1995-04-10 | 1996-04-09 | Data processing method and system installation for wireless channel database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1149224A true CN1149224A (en) | 1997-05-07 |
Family
ID=25743709
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 96102849 Pending CN1149224A (en) | 1995-04-10 | 1996-04-09 | Data processing method and system installation for wireless channel database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1149224A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100386744C (en) * | 2004-04-07 | 2008-05-07 | 美国博通公司 | Method and system for secure erasure of information in non-volatile memory in an electronic device |
-
1996
- 1996-04-09 CN CN 96102849 patent/CN1149224A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100386744C (en) * | 2004-04-07 | 2008-05-07 | 美国博通公司 | Method and system for secure erasure of information in non-volatile memory in an electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1160970C (en) | Communication system with rapid database synchronization | |
| US4819191A (en) | Electronic calendaring method to establish calendar floating triggers for calendared events and processes | |
| CN100478956C (en) | Method and corresponding system for creating and obtaining report forms | |
| CN1141846C (en) | SCP database migration | |
| CN1131859A (en) | Subscriber information service system | |
| EP0632397A2 (en) | Book data service system with data delivery by broadcasting | |
| CN1902658A (en) | System and method for comparing candidate responses to interview questions | |
| CN1636351A (en) | Method and system for accessing available service on a second network by member of a first network | |
| CN102136118A (en) | Advertisement order booking method, advertisement delivering method and system | |
| CN1658687A (en) | Command based group SMS with mobile message receiver and server | |
| CN1945612A (en) | City regional management commanding and control system for administration law enforcement | |
| CN1052564A (en) | The end device of reservation system | |
| CN1106121C (en) | Communication system with centrolized global title translation table | |
| US20040251180A1 (en) | System and method for dynamically adjusting the allocation of mail items associated with particular delivery points within a carrier structure | |
| CN1278238C (en) | Information control system, server for information control system, and information terminal for the same | |
| CN1166219C (en) | Communication system with multiple SCP | |
| CN1276942A (en) | Communications network node | |
| CN101043347A (en) | Memo service realization system, realization method and memo application server | |
| CN1149224A (en) | Data processing method and system installation for wireless channel database | |
| CN101924841B (en) | Building and control method of a kind of call center and data center's distributed frame | |
| CN1756171A (en) | Digital media advertising system and its method | |
| CN1722757B (en) | Recording system based on voice communication | |
| CN102655610A (en) | Automatic play control system and method for digital multimedia files | |
| CN1655569A (en) | Intelligent telephone network | |
| CN1126342C (en) | Method and devices for transmitting and displaying data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C01 | Deemed withdrawal of patent application (patent law 1993) | ||
| WD01 | Invention patent application deemed withdrawn after publication |